ORACLE DATABASE PROBLEM AND SOLUTIONS

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