Dear OTN Community,
Oracle 10gR2 Patchset 3
HP-UX v11.31
I have been trying to create and locate the password file for my physical standby database however it seems that its not working.
On the primary database its name is KNWA and on the standby the instance name is KNWASTBY. I have set the ORACLE_HOME, ORACLE_SID and PATH parameters on Oracle user's .profile file.
When the database is on mount stage i can connect to the physical standby database as;
sqlplus sys/password*@ORACLE_SID* as sysdba
But when its in nomount or idle state i can't connect to it with the above command.
What could be the reason? By the way i have created the password file underneath $ORACLE_HOME/dbs and its called orapwKNWASTBY. What am i missing here?
Thank you in anticipating,
Ogan