Category Archives: Oracle

In this we are handling Oracle Database Administration and development task. If provide solution of ORA Errors and configuration Steps for setup in Oracle.

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