cancel
Showing results for 
Search instead for 
Did you mean: 

AgentConfig fails to connect to recovery catalog on active standby

Mike_Ely
Level 4

We need to use our active standby database for BUE to offload the backup churn from the production database.  The production database is registered with a recovery catalog.  Running AgentConfig goes fine until the credentials are given for the recovery catalog, at which time the agent incorrectly asserts that the DB is down.  I've run this six ways from Saturday and get the same broken typical-for-BUE result every time.

Givens:
Database is running as active standby.
Primary database has been registered with the recovery catalog, and shares DBID with active standby.
All credentials are correct and can be used in sqlplus from the server running active standby.
64-bit RHEL 5.3 with BEWS (rhymes with "spews") 12.5.x

Here's the AgentConfig log output for the session:

5612d5a0 Thu Jun 24 09:22:52 2010 : ORACLEConfiguration::GetCredentials : Created new instance of OCIINTERCONNECT
5612d5a0 Thu Jun 24 09:22:52 2010 : ORACLEConfiguration::GetCredentials : Trying to login to Oracle
5612d5a0 Thu Jun 24 09:22:52 2010 : OCIINTERCONNECT::LogonOracle: db = (S), home_dir = (/), user =(s), passwd= (****)
5612d5a0 Thu Jun 24 09:22:52 2010 : Current Oracle user name (sys)
5612d5a0 Thu Jun 24 09:22:52 2010 : putenv(ORACLE_SID=EBSHA)
5612d5a0 Thu Jun 24 09:22:52 2010 : putenv(ORACLE_HOME=/u01/app/oracle/db/tech_st/11.1.0)
5612d5a0 Thu Jun 24 09:22:52 2010 : Using the OCI library - /u01/app/oracle/db/tech_st/11.1.0/lib/libclntsh.so
5612d5a0 Thu Jun 24 09:22:52 2010 : OCIServerAttach() Linux 1
5612d5a0 Thu Jun 24 09:22:52 2010 : OCIServerAttach() Linux 2
5612d5a0 Thu Jun 24 09:22:52 2010 : OCIINTERCONNECT::LogonOracle: Logon is successful
5612d5a0 Thu Jun 24 09:22:52 2010 : ORACLEConfiguration::GetCredentials : Deleting instance of OCIINTERCONNECT
5612d5a0 Thu Jun 24 09:22:52 2010 : OCIInterconnect: logoff successful
5612d5a0 Thu Jun 24 09:22:52 2010 : ORACLEConfiguration::GetCredentials : Login to Oracle successful
5612d5a0 Thu Jun 24 09:22:52 2010 : ORACLEConfiguration::GetCredentials : Return value : 1
5612d5a0 Thu Jun 24 09:22:52 2010 : Exiting from function : ORACLEConfiguration::GetCredentials
5612d5a0 Thu Jun 24 09:22:52 2010 : Entered function : BASEConfig::GetMediaServerName
5612d5a0 Thu Jun 24 09:24:19 2010 : BASEConfig::GetMediaServerName : Return value : 1
5612d5a0 Thu Jun 24 09:24:19 2010 : Exiting from function : BASEConfig::GetMediaServerName
5612d5a0 Thu Jun 24 09:24:22 2010 : Entered function : ORACLEConfiguration::GetCredentials
5612d5a0 Thu Jun 24 09:24:38 2010 : ORACLEConfiguration::GetCredentials : Created new instance of OCIINTERCONNECT
5612d5a0 Thu Jun 24 09:24:38 2010 : ORACLEConfiguration::GetCredentials : Trying to login to Oracle
5612d5a0 Thu Jun 24 09:24:38 2010 : OCIINTERCONNECT::LogonOracle: db = (r), home_dir = (/), user =(r), passwd= (****)
5612d5a0 Thu Jun 24 09:24:38 2010 : Current Oracle user name (catman)
5612d5a0 Thu Jun 24 09:24:38 2010 : putenv(ORACLE_SID=catalogdb)
5612d5a0 Thu Jun 24 09:24:38 2010 : putenv(ORACLE_HOME=/u01/app/oracle/db/tech_st/11.1.0)
5612d5a0 Thu Jun 24 09:24:38 2010 : OCIServerAttach() Linux 1
5612d5a0 Thu Jun 24 09:24:38 2010 : OCIServerAttach() Linux 2
5612d5a0 Thu Jun 24 09:24:38 2010 : OCISessionBegin() failed with database credentials.
5612d5a0 Thu Jun 24 09:24:38 2010 : OCI_ERROR: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
5612d5a0 Thu Jun 24 09:24:38 2010 : Oracle Instance is down. Start it up! Error code (1034)
5612d5a0 Thu Jun 24 09:24:38 2010 : Returning E_RMAN_LOGON_INSTANCE_DOWN error (0xe000100e)
5612d5a0 Thu Jun 24 09:24:38 2010 : OCIINTERCONNECT::LogonOracle: Logon is Unsuccessful
5612d5a0 Thu Jun 24 09:24:38 2010 : ORACLEConfiguration::GetCredentials : Deleting instance of OCIINTERCONNECT
5612d5a0 Thu Jun 24 09:24:38 2010 : ORACLEConfiguration::GetCredentials : Oracle instance is down
 
See? Broken! Why? You can see it logs in correctly to the dabase, but horks badly on the recovery catalog.
0 REPLIES 0