Re: create data guard on 11G have ORA-16191
- From: "April Sims" <sims@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>,<mccdba1@xxxxxxxxx>
- Date: Mon, 29 Dec 2008 15:45:04 -0700
http://aprilcsims.wordpress.com/2008/04/22/ora-16191-applicable-to-streams-data-guard-errors-in-11g/
April Sims
SELECT IOUG Contributing Editor
http://aprilcsims.wordpress.com
OCP 8i, 9i, 10g DBA
Southern Utah University
sims@xxxxxxx
940-484-4276
>>> dba1 mcc <mccdba1@xxxxxxxxx> 12/29/2008 4:05 PM >>>
I tried to setup ORACLE 11G dataguard on two servers. I follow document setup
following:
1. remote_login_passwordfile = exclusive on both servers init.ora
2. orapwd file=orapwdT11DB.ora password=xxxx. I also transfer "orapwdT11db.ora"
to another server and put under /home/app/oracle/product/11.1/dbs
3. "sys" password same like "orapwd" password
After I startup both primary DB and Standby DB, I got ORA-16191 error. Anyone
know what wrong it is?
================ alert.log message =====
Errors in file
/home/app/oracle/diag/rdbms/t11db/T11DB/trace/T11DB_arc0_30623.trc:
ORA-01017: invalid username/password; logon denied
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
Errors in file
/home/app/oracle/diag/rdbms/t11db/T11DB/trace/T11DB_arc0_30623.trc:
ORA-16191: Primary log shipping client not logged on standby
PING[ARC0]: Heartbeat failed to connect to standby 'T11DBSTY'. Error is 16191.
===============================================
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Other related posts: