Author Archives: SandeepSingh DBA

About SandeepSingh DBA

Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Copy password file from primary to standby in RAC Environment

Copy password file from primary to standby in RAC Environment

Errors:

--PRODDB - Primary database
Error: ORA-16810: multiple errors or warnings detected for the database

--DRDB - Physical standby database
Error: ORA-01017: invalid username/password; logon denied

--PRODB - Primary database
ORA-16191: Primary log shipping client not logged on standby
*** 2018-07-26 16:04:50.817626 4929 krsh.c
PING[ARC5]: Heartbeat failed to connect to standby 'PRODDB_REPL'. Error is 16191.
Thu Jul 26 16:30:24 2018
Errors in file /u01/app/oracle/diag/rdbms/proddb/PRODDB/trace/PRODDB_tt00_329234.trc:
ORA-16191: Primary log shipping client not logged on standby
Error 16191 for archive log file 1 to 'PRODDB_REPL'

Cause:
Problems seems to be in password file mismatch in Primary and Standby Server.

Solution:

1. Disable the DG broker service.

alter system set dg_broker_start =false
alter system set log_archive_dest_state_2=defer;
-- Manually start for debugging
alter system set log_archive_dest_state_2=enable;

2. Steps to copy the password file from primary to Standby.
Check configuration of RAC environment with SRVCTL command.

--At Primary :
srvctl config database -d PRODDB
Database unique name: PRODB
Database name:
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1
Oracle user: oracle
Spfile: +DG_1/PRODB/PARAMETERFILE/spfilePRODB.ora
Password file: +DG_1/PRODB/PASSWORD/pwdPRODB.455.982492525
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DG_1
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: racoper
Database instances: PRODB1,PRODB2
Configured nodes: b1xlvdb8a-adm,b1xlvdb8b-adm
Database is administrator managed

Check for Standby Database
-- At Standby
srvctl config database -d DRDB
Database unique name: DRDB
Database name: DRDB
Oracle home: /u01/app/oracle/product/12.1.0.2/dbhome_1
Oracle user: oracle
Spfile: +DG_1/DRDB/PARAMETERFILE/spfile.288.947968565
Password file: +DG_1/DRDB/PASSWORD/pwdDRDB.289.982492821
Domain:
Start options: mount
Stop options: immediate
Database role: PHYSICAL_STANDBY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DG_1
Mount point paths:
Services: IBASE_BATCH_SVC,IBASE_SVC
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: racoper
Database instances: DRDB1,DRDB2
Configured nodes: b1xlvdb6a-adm,b1xlvdb6b-adm
Database is administrator managed

3. Copy the ASM Password file from Primary to local disk.

pwcopy DG_1/PRODB/PARAMETERFILE/spfilePRODB.ora /tmp/primary_passwd

4. SCP the file from primary to standby.

copy /tmp/primary_passwd to standby side

5. Remove current password file from Standby Server present at ASM location.

pwdelete +DG_1/DRDB

6. Copy the primary password file to Standby ASM location.

pwcopy /tmp/primary_passwd +DG_1/DRDB/PASSWORD/pwdDRDB

7. Modify the Setting with SRVCLT

srvctl modify database DRDB -pwfile +DG_1/DRDB/PASSWORD/pwdDRDB

8. Check the Standby and start the recovery process.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

9. Enable the DB Services by stop manually process of apply.

Advertisements