ORACLE DATABASE PROBLEM AND SOLUTIONS: January 2023

Tuesday, January 31, 2023

How to Fix ifconfig - command not found Error in Linux

ifconfig - bash: ifconfig: command not found error in Linux

[oracle@ip-10.22.3333.2222 ~]$

[oracle@ip-10.22.3333.2222 ~]$ ifconfig

bash: ifconfig: command not found

[oracle@ip-10.22.3333.2222 ~]$

Login as root user:

[oracle@ip-10.22.3333.2222 ~]$ su - root

Password:

There were 243 failed login attempts since the last successful login.

[root@ip-10.22.3333.2222 ~]#

Install net-tools package :

[root@ip-10.22.3333.2222 ~]# dnf install net-tools

Updating Subscription Management repositories.

Unable to read consumer identity

This system is not registered with an entitlement server. You can use subscription-manager to register.

Red Hat Enterprise Linux 8 for x86_64 - AppStream from RHUI (RPMs) 31 kB/s | 4.5 kB 00:00

Red Hat Enterprise Linux 8 for x86_64 - AppStream from RHUI (RPMs) 63 MB/s | 52 MB 00:00

Red Hat Enterprise Linux 8 for x86_64 - BaseOS from RHUI (RPMs) 116 kB/s | 4.1 kB 00:00

Red Hat Enterprise Linux 8 for x86_64 - BaseOS from RHUI (RPMs) 67 MB/s | 56 MB 00:00

Red Hat Ansible Engine 2 for RHEL 8 (RPMs) from RHUI 98 kB/s | 4.0 kB 00:00

Red Hat Update Infrastructure 3 Client Configuration Server 8 68 kB/s | 2.0 kB 00:00

Dependencies resolved.

==============================================================================================================================================

Package Architecture Version Repository Size

==============================================================================================================================================

Installing:

net-tools x86_64 2.0-0.52.20160912git.el8 rhel-8-baseos-rhui-rpms 322 k

Transaction Summary

==============================================================================================================================================

Install 1 Package

Total download size: 322 k

Installed size: 942 k

Is this ok [y/N]: y

Downloading Packages:

net-tools-2.0-0.52.20160912git.el8.x86_64.rpm 8.0 MB/s | 322 kB 00:00

----------------------------------------------------------------------------------------------------------------------------------------------

Total 5.7 MB/s | 322 kB 00:00

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Preparing : 1/1

Installing : net-tools-2.0-0.52.20160912git.el8.x86_64 1/1

Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64 1/1

Verifying : net-tools-2.0-0.52.20160912git.el8.x86_64 1/1

Installed products updated.

Installed:

net-tools-2.0-0.52.20160912git.el8.x86_64

Complete!

[root@ip-10.22.3333.2222 ~]#

Run ifconfig command :

[root@ip-10.22.3333.2222 ~]# ifconfig

eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 9001

inet 10.22.3333.2222 netmask 255.255.240.0 broadcast 10.22.3333.255

inet6 fe80::82c:94ff:fe4a:1c13 prefixlen 64 scopeid 0x20<link>

ether 0a:2c:94:4a:1c:13 txqueuelen 1000 (Ethernet)

RX packets 80039 bytes 118266327 (112.7 MiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 17828 bytes 1499744 (1.4 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536

inet 127.0.0.1 netmask 255.0.0.0

inet6 ::1 prefixlen 128 scopeid 0x10<host>

loop txqueuelen 1000 (Local Loopback)

RX packets 0 bytes 0 (0.0 B)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 0 bytes 0 (0.0 B)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

[root@ip-10.22.3333.2222 ~]#

[root@ip-10.22.3333.2222 ~]# exit

logout

[oracle@ip-10.22.3333.2222 ~]$

[oracle@ip-10.22.3333.2222 ~]$ ifconfig

eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 9001

inet 10.22.3333.2222 netmask 255.255.240.0 broadcast 10.22.3333.255

inet6 fe80::82c:94ff:fe4a:1c13 prefixlen 64 scopeid 0x20<link>

ether 0a:2c:94:4a:1c:13 txqueuelen 1000 (Ethernet)

RX packets 80076 bytes 118268659 (112.7 MiB)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 17857 bytes 1503186 (1.4 MiB)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536

inet 127.0.0.1 netmask 255.0.0.0

inet6 ::1 prefixlen 128 scopeid 0x10<host>

loop txqueuelen 1000 (Local Loopback)

RX packets 0 bytes 0 (0.0 B)

RX errors 0 dropped 0 overruns 0 frame 0

TX packets 0 bytes 0 (0.0 B)

TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0

[oracle@ip-10.22.3333.2222 ~]$

ANURAG PANDEY

I am Anurag Pandey, working as Cloud Database Architect | Migration & Modernization Expert . Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible

Tuesday, January 17, 2023

Step by Step Configuration Of Data Guard Broker in Oracle database 19c

Data Guard Broker Configuration in oracle

Listener configuration on primary

(SID_DESC =

(GLOBAL_DBNAME = ddb_dgmgrl)

(ORACLE_HOME = /u01/app/oracle/product/19.0/dbhome1)

(SID_NAME = ddb)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.19.40)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ddb)

(ORACLE_HOME = /u01/app/oracle/product/19.0/dbhome1)

(SID_NAME = ddb)

)

(SID_DESC =

(GLOBAL_DBNAME = ddb_dgmgrl)

(ORACLE_HOME = /u01/app/oracle/product/19.0/dbhome1)

(SID_NAME = ddb)

)

Listener configuration on standby

(SID_DESC =

(GLOBAL_DBNAME = ddb_dr_dgmgrl)

(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)

(SID_NAME = ddb_dr)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.13.0.4)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ddb_dr)

(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)

(SID_NAME = ddb_dr)

)

(SID_DESC =

(GLOBAL_DBNAME = ddb_dr_dgmgrl)

(ORACLE_HOME = /u01/app/oracle/product/19.0.0/dbhome_1)

(SID_NAME = ddb_dr)

)

tnsnames.ora on primary and standby

DDB =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = wes-4-92-00-112.compute-1.amazonaws.com )(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ddb)

)

DDB_DR =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 92.100.100.922 )(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ddb_dr)

)

On standby database:

SQL> alter database recover managed standby database cancel;

SQL> alter system set LOG_ARCHIVE_DEST_2='' SCOPE=BOTH sid='*';

On primary database:

SQL> alter system set LOG_ARCHIVE_DEST_2='' SCOPE=BOTH sid='*';

Enable broker on primary and standby database

alter system set dg_broker_start=true;

show parameter dg_broker_start

Register primary database with broker

create configuration prod_ddb as primary database is ddb connect identifier is ddb;

[oracle@10.22.3333.2222 admin]$

[oracle@10.22.3333.2222 admin]$ dgmgrl sys/Rdx1234567890@ddb

DGMGRL for Linux: Release 19.0.0.0.0 - Production on Sat Jan 14 15:02:21 2023

Version 19.3.0.0.0

Welcome to DGMGRL, type "help" for information.

Connected to "ddb"

Connected as SYSDBA.

DGMGRL>

DGMGRL> create configuration prod_ddb as primary database is ddb connect identifier is ddb;

Configuration "prod_ddb" created with primary database "ddb"

DGMGRL>

DGMGRL> show configuration;

Configuration - prod_ddb

Protection Mode: MaxPerformance

Members:

ddb - Primary database

Fast-Start Failover: Disabled

Configuration Status:

DISABLED

DGMGRL>

Register standby database with broker

add database ddb_dr as connect identifier is ddb_dr;

DGMGRL> add database ddb_dr as connect identifier is ddb_dr;

Database "ddb_dr" added

DGMGRL>

DGMGRL> show configuration;

Configuration - prod_ddb

Protection Mode: MaxPerformance

Members:

ddb - Primary database

ddb_dr - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:

DISABLED

DGMGRL>

Enable Data Guard broker

DGMGRL>

DGMGRL> enable configuration;

Enabled.

DGMGRL>

DGMGRL> show configuration;

Configuration - prod_ddb

Protection Mode: MaxPerformance

Members:

ddb - Primary database

ddb_dr - Physical standby database

Warning: ORA-16853: apply lag has exceeded specified threshold

Fast-Start Failover: Disabled

Configuration Status:

WARNING (status updated 16 seconds ago)

DGMGRL>

DGMGRL> show database ddb

Database - ddb

Role: PRIMARY

Intended State: TRANSPORT-ON

Instance(s):

ddb

Database Status:

SUCCESS

DGMGRL> show database ddb_dr

Database - ddb_dr

Role: PHYSICAL STANDBY

Intended State: APPLY-ON

Transport Lag: 0 seconds (computed 0 seconds ago)

Apply Lag: 0 seconds (computed 0 seconds ago)

Average Apply Rate: 55.00 KByte/s

Real Time Query: OFF

Instance(s):

ddb_dr

Database Status:

SUCCESS

DGMGRL>

ANURAG PANDEY

Error: ORA-16662: network timeout when contacting a member : DGMGRL

Error: ORA-16662: network timeout when contacting a member

DGMGRL>

DGMGRL> show configuration

Configuration - prod_ddb

Protection Mode: MaxPerformance

Members:

ddb_dr - Primary database

ddb - Physical standby database

Error: ORA-16662: network timeout when contacting a member

Fast-Start Failover: Disabled

Configuration Status:

ERROR (status updated 47 seconds ago)

DGMGRL>

SQL> select

dest_name,

status,

error

from

v$archive_dest

where

status='ERROR'

; 2 3 4 5 6 7 8 9

DEST_NAME

--------------------------------------------------------------------------------

STATUS ERROR

--------- -----------------------------------------------------------------

LOG_ARCHIVE_DEST_2

ERROR ORA-16198: Timeout incurred on internal channel during remote

archival

Workaround

EDIT DATABASE 'ddb' SET PROPERTY NetTimeout = 60;

EDIT DATABASE 'ddb_dr' SET PROPERTY NetTimeout = 60;

ANURAG PANDEY

Switchover with Data Guard Broker : DGMGRL

Switchover with Data Guard Broker

DGMGRL>

DGMGRL> show configuration;

Configuration - prod_ddb

Protection Mode: MaxPerformance

Members:

ddb - Primary database

ddb_dr - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:

SUCCESS (status updated 11 seconds ago)

DGMGRL>

DGMGRL> switchover to ddb_dr

Performing switchover NOW, please wait...

Operation requires a connection to database "ddb_dr"

Connecting ...

Connected to "ddb_dr"

Connected as SYSDBA.

New primary database "ddb_dr" is opening...

Operation requires start up of instance "ddb" on database "ddb"

Starting instance "ddb"...

Connected to an idle instance.

ORACLE instance started.

Connected to "ddb"

Database mounted.

Connected to "ddb"

Switchover succeeded, new primary is "ddb_dr"

DGMGRL>

DGMGRL> show configuration

Configuration - prod_ddb

Protection Mode: MaxPerformance

Members:

ddb_dr - Primary database

ddb - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:

SUCCESS (status updated 78 seconds ago)

DGMGRL>

DGMGRL> switchover to ddb

Performing switchover NOW, please wait...

Operation requires a connection to database "ddb"

Connecting ...

Connected to "ddb"

Connected as SYSDBA.

New primary database "ddb" is opening...

Operation requires start up of instance "ddb_dr" on database "ddb_dr"

Starting instance "ddb_dr"...

Connected to an idle instance.

ORACLE instance started.

Connected to "ddb_dr"

Database mounted.

Connected to "ddb_dr"

Switchover succeeded, new primary is "ddb"

DGMGRL>

DGMGRL> show configuration

Configuration - prod_ddb

Protection Mode: MaxPerformance

Members:

ddb - Primary database

ddb_dr - Physical standby database

Fast-Start Failover: Disabled

Configuration Status:

SUCCESS (status updated 77 seconds ago)

DGMGRL>

ANURAG PANDEY

Sunday, January 15, 2023

How to resolve ORA error like ORA-16058 during oracle datagaurd setup .

Execute below steps on primary database

SQL> alter system set log_archive_dest_state_2='DEFER';

SQL> alter system set log_archive_dest_state_2='ENABLE';

SQL> select dest_id, status, destination, error from v$archive_dest where dest_id<=2;

DEST_ID STATUS DESTINATION ERROR

---------- --------- ------------------------------ -----------------------------------------------------------------

1 VALID USE_DB_RECOVERY_FILE_DEST

2 VALID ddb_dr

SQL>

ANURAG PANDEY

Client Connectivity in Data Guard Configuration | HA service

Client Connectivity in Data Guard Configuration

create database service on primary database server

exec DBMS_SERVICE.CREATE_SERVICE (service_name => 'ddb_ha', network_name => 'ddb_ha');

create or replace procedure start_db_ha_service

v_role VARCHAR(30);

begin

select DATABASE_ROLE into v_role from V$DATABASE;

if v_role = 'PRIMARY' then

DBMS_SERVICE.START_SERVICE('ddb_ha');

else

DBMS_SERVICE.STOP_SERVICE('ddb_ha');

end if;

end;

TRIGGER TO START SERVICE ON DB STARTUP:

create or replace TRIGGER db_hasrv_on_startup

after startup on database

begin

start_db_ha_service;

end;

TRIGGER TO START SERVICE ON DB ROLECHANGE:

create or replace TRIGGER db_hasrv_on_role_change

after db_role_change on database

begin

start_db_ha_service;

end;

Start the new service on primary

SQL> exec start_db_ha_service;

SQL> alter system archive log current;

SQL>

SQL> exec DBMS_SERVICE.CREATE_SERVICE (service_name => 'ddb_ha', network_name => 'ddb_ha');

PL/SQL procedure successfully completed.

SQL> create or replace procedure start_db_ha_service

v_role VARCHAR(30);

begin

select DATABASE_ROLE into v_role from V$DATABASE;

if v_role = 'PRIMARY' then

DBMS_SERVICE.START_SERVICE('ddb_ha');

else

DBMS_SERVICE.STOP_SERVICE('ddb_ha');

end if;

end;

/ 2 3 4 5 6 7 8 9 10 11 12

Procedure created.

SQL> create or replace TRIGGER db_hasrv_on_startup

after startup on database

begin

start_db_ha_service;

end;

2 3 4 5 6

Trigger created.

SQL>

SQL> create or replace TRIGGER db_hasrv_on_role_change

after db_role_change on database

begin

start_db_ha_service;

end;

/ 2 3 4 5 6

Trigger created.

SQL>

SQL> exec start_db_ha_service;

PL/SQL procedure successfully completed.

SQL>

SQL> alter system archive log current;

System altered.

SQL> alter system archive log current;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL>

tnsnames.ora (client site)

DDB =

(DESCRIPTION =

(ADDRESS_LIST=

(ADDRESS = (PROTOCOL = TCP)(HOST = 9.82.83.159)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 72.471.436.842)(PORT = 1521))

)

(CONNECT_DATA = (SERVICE_NAME = ddb_ha)

(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=60)(DELAY=20))

)

ANURAG PANDEY

Saturday, January 14, 2023

Use Orapwd utility to create Password File In Oracle

orapwd file=orapwddb password=Rdx$1234567890 force=y

to avoid password verification:

orapwd file=orapwddb password=Rdx1234567890 force=y format=12

[oracle@dbs]$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 14 13:07:04 2023

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> alter user sys identified by Rdx1234567890;

User altered.

ANURAG PANDEY

How to Disable firewall on linux server : firewalld

[root@oracle ~]#

[root@oracle ~]# systemctl status firewalld

● firewalld.service - firewalld - dynamic firewall daemon

Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)

Active: active (running) since Sat 2023-01-14 10:02:49 UTC; 50min ago

Docs: man:firewalld(1)

Main PID: 933 (firewalld)

CGroup: /system.slice/firewalld.service

└─933 /usr/bin/python2 -Es /usr/sbin/firewalld --nofork --nopid

Jan 14 10:02:48 oracle systemd[1]: Starting firewalld - dynamic firewall daemon...

Jan 14 10:02:49 oracle systemd[1]: Started firewalld - dynamic firewall daemon.

[root@oracle ~]#

[root@oracle ~]# service firewalld stop

Redirecting to /bin/systemctl stop firewalld.service

[root@oracle ~]#

[root@oracle ~]# systemctl status firewalld

● firewalld.service - firewalld - dynamic firewall daemon

Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)

Active: inactive (dead) since Sat 2023-01-14 10:55:01 UTC; 9s ago

Docs: man:firewalld(1)

Process: 933 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)

Main PID: 933 (code=exited, status=0/SUCCESS)

Jan 14 10:02:48 oracle systemd[1]: Starting firewalld - dynamic firewall daemon...

Jan 14 10:02:49 oracle systemd[1]: Started firewalld - dynamic firewall daemon.

Jan 14 10:55:01 oracle systemd[1]: Stopping firewalld - dynamic firewall daemon...

Jan 14 10:55:01 oracle systemd[1]: Stopped firewalld - dynamic firewall daemon.

[root@oracle ~]#

[root@oracle ~]# systemctl disable firewalld

Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.

Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.

[root@oracle ~]#

[root@oracle ~]# systemctl status firewalld

● firewalld.service - firewalld - dynamic firewall daemon

Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)

Active: inactive (dead)

Docs: man:firewalld(1)

Jan 14 10:02:48 oracle systemd[1]: Starting firewalld - dynamic firewall daemon...

Jan 14 10:02:49 oracle systemd[1]: Started firewalld - dynamic firewall daemon.

Jan 14 10:55:01 oracle systemd[1]: Stopping firewalld - dynamic firewall daemon...

Jan 14 10:55:01 oracle systemd[1]: Stopped firewalld - dynamic firewall daemon.

[root@oracle ~]#

ANURAG PANDEY

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Cause : database was crashed, could be database shut abort or database was not clean shutdown.

check alert log as well to get more details .

workaround :

[oracle@10.1.1.0 ~]$

[oracle@10.1.1.0 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 14 10:04:10 2023

Version 19.3.0.0.0

Connected to an idle instance.

SQL>

SQL> startup mount

ORACLE instance started.

Total System Global Area 1610609200 bytes

Fixed Size 8897072 bytes

Variable Size 385875968 bytes

Database Buffers 1207959552 bytes

Redo Buffers 7876608 bytes

Database mounted.

SQL>

SQL> select log_mode from v$database;

LOG_MODE

------------

NOARCHIVELOG

SQL>

SQL> alter database archivelog;

alter database archivelog

ERROR at line 1:

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

SQL> alter database open;

Database altered.

SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@10.1.1.0 ~]$

[oracle@10.1.1.0 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jan 14 10:23:27 2023

Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1610609200 bytes

Fixed Size 8897072 bytes

Variable Size 385875968 bytes

Database Buffers 1207959552 bytes

Redo Buffers 7876608 bytes

Database mounted.

SQL>

SQL> select log_mode from v$database;

LOG_MODE

------------

NOARCHIVELOG

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> select log_mode from v$database;

LOG_MODE

------------

ARCHIVELOG

SQL>

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence 4

Next log sequence to archive 6

Current log sequence 6

SQL>

ANURAG PANDEY

Friday, January 13, 2023

Listener.ora & Tnsnames.ora file for Oracle Database

listener.ora file (with static listener)

-----------------------------------------------

cat listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/19.0/dbhome1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.19.48)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ddb)

(ORACLE_HOME = /u01/app/oracle/product/19.0/dbhome1)

(SID_NAME = ddb)

)

tnsnames.ora file

--------------------------

cat tnsnames.ora

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0/dbhome1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

DDB=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.19.48 )(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ddb)

)

ANURAG PANDEY

How To Create Database Using DBCA in Silent Mode on Linux – 19C

Prerequisite :

Oracle 19c software already install
Oracle Environment variable should be set
create database using dbca
create or update listener.ora ,tnsnames.ora
verify database

Command for database create:

-------------------------------------

Login as oracle user
execute on terminal

dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ddb -sid ddb -sysPassword Rdx@1234567890 -systemPassword Rdx@1234567890 -createAsContainerDatabase false -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8 -totalMemory 2048 -recoveryAreaDestination /u01/app/oracle/fast_recovery_area -sampleSchema true

[oracle@10.1.1.0~]$

[oracle@10.1.1.0~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ddb -sid ddb -sysPassword Rdx@1234567890 -systemPassword Rdx@1234567890 -createAsContainerDatabase false -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8 -totalMemory 2048 -recoveryAreaDestination /u01/app/oracle/fast_recovery_area -sampleSchema true

Prepare for db operation

10% complete

Copying database files

40% complete

Creating and starting Oracle instance

42% complete

46% complete

50% complete

54% complete

58% complete

60% complete

Completing Database Creation

66% complete

69% complete

70% complete

Executing Post Configuration Actions

100% complete

Database creation complete. For details check the logfiles at:

/u01/app/oracle/cfgtoollogs/dbca/ddb.

Database Information:

Global Database Name:ddb

System Identifier(SID):ddb

Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ddb/ddb.log" for further details.

[oracle@10.1.1.0~]$

[oracle@10.1.1.0~]$ cat /etc/oratab

# This file is used by ORACLE utilities. It is created by root.sh

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator. A new line terminates

# the entry. Lines beginning with a pound sign, '#', are comments.

# Entries are of the form:

# $ORACLE_SID:$ORACLE_HOME:<N|Y>:

# The first and second fields are the system identifier and home

# directory of the database respectively. The third field indicates

# to the dbstart utility that the database should , "Y", or should not,

# "N", be brought up at system boot time.

# Multiple entries with the same $ORACLE_SID are not allowed.

ddb:/u01/app/oracle/product/19.0/dbhome1:N

[oracle@10.1.1.0~]$

[oracle@10.1.1.0~]$ . oraenv

ORACLE_SID = [india] ? ddb

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@10.1.1.0~]$

[oracle@10.1.1.0~]$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 13 14:19:03 2023

Version 19.3.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

SQL> select name ,open_mode,database_role from v$database;

NAME OPEN_MODE DATABASE_ROLE

--------- -------------------- ----------------

DDB READ WRITE PRIMARY

SQL>

ANURAG PANDEY