commvault.com commvault.com
Question

rhel 8.8 oracle client failing to discover db instances

  • 30 June 2023
  • 5 replies
  • 150 views
J
Rank
Badge +1

after install of the oracle client on rhel8.8 machine, i am unable to discover databases.  getting this error in the logs:

577603 8d043 06/29 16:02:15 ### NetMessage::verifyResponseHeader() - Error Code [547] returned - [Problems executing [AppInsertInstanceProp], Line[137] :The INSERT statement conflicted with the FOREIGN KEY constraint "APP_InstanceProp_componentNameId_FK". The conflict occurred in database "CommServ", table "dbo.APP_InstanceName", column 'id'.].
 

i have been comparing this client to ones that are not having the issue and i can not find any reason for these clients to be different.  i do have a case open with commvault but no response yet other than to check that oracle was running.

5 replies

J
Rank
Badge +1

sorry all of the log i tried to paste didnt paste.  see below.  it is reading the oratab info just fine:

 

 Creating the control thread
1268413 135abd 07/10 14:41:55 ### CvClntCert::loadLib() - Successfully loaded /opt/commvault/Base/libCvClntCertImpl.so
1268413 135abd 07/10 14:41:55 ### Cvcl::init() - CVCL: Running in FIPS Mode
1268413 135abd 07/10 14:41:55 ### ::GetSbtLibrary() - Defaulting to Oracle version:[9]
1268413 135abd 07/10 14:41:55 ### ::GetSbtLibrary() - Oracle version: [9]
1268413 135abd 07/10 14:41:55 ### ::GetSbtLibrary() - Oracle SBT library for this instance is: [/opt/commvault/Base/libobk.so]
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - No additional oratab file paths specified. Default oratab file would be used for auto discovery
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Reading Oracle instance entries from file /etc/oratab
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Oracle Home Path : /oracle/product/19.0.0.0/test
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Oracle user Name : oracle
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Oracle sbtLibName : /opt/commvault/Base/libobk.so
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Added instance SID : advqa, Home : /oracle/product/19.0.0.0/test , User oracle ,sbtLibName /opt/commvault/Base/libobk.so
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Oracle Home Path : /oracle/product/19.0.0.0/test
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Oracle user Name : oracle
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Oracle sbtLibName : /opt/commvault/Base/libobk.so
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Added instance SID : listener_advqa, Home : /oracle/product/19.0.0.0/test , User oracle ,sbtLibName /opt/commvault/Base/libobk.so
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Oracle Home Path : /oracle/app/agent_13.5.0.0.0
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getOracleInstanceList() - Failed to get owner id for  file /oracle/app/agent_13.5.0.0.0/bin/oracle
1268413 135abd 07/10 14:41:55 ### CvProcess::system() - PATH=/usr/xpg4/bin:$PATH;export PATH;ps -ef | awk '/_pmon_/ { n = split($NF, a, "_pmon_"); if(n > 1) printf("ORASID=%s,",  a[n]); }'
1268413 135abd 07/10 14:41:55 ### CvProcess::system() - Command completed with rc=0
1268413 135abd 07/10 14:41:55 ### ClOraAgent::AutoDiscoverInstances() - Client Id : 6345
1268413 135abd 07/10 14:41:55 ### ::getStoragePoliciesForDiscoveredInstance() - Client Id : 6345
1268413 135abd 07/10 14:41:55 ### ::getStoragePoliciesFromAgentProperties() - Data SP=[174]
1268413 135abd 07/10 14:41:55 ### ::getStoragePoliciesFromAgentProperties() - Logs SP=[174]
1268413 135abd 07/10 14:41:55 ### CvProcess::system() - PATH=/usr/xpg4/bin:$PATH;export PATH;ps -ef | grep crsd | grep -v grep|awk '{print $8}'
1268413 135abd 07/10 14:41:55 ### CvProcess::system() - Command completed with rc=0
1268413 135abd 07/10 14:41:55 ### ClOraAutoDiscover::IsCRSDRunning(861) - This server is not running Oracle cluster software.
1268413 135abd 07/10 14:41:55 ### ClOraAutoDiscover::DiscoverRACDatabases(709) - crsd not running on this node
1268413 135abd 07/10 14:41:55 ### IdaBackup::filterOldRACEntitiesFromDiscoverListForClient(910) - no existing RAC entities for this client
1268413 135abd 07/10 14:41:55 ### ClOraAutoDiscover::CreateNewRACEntities(1276) - No new entities discovered
1268413 135abd 07/10 14:41:55 ### ClOraAgent::AutoDiscoverInstances() - Instance advqa not found creating now
1268413 135abd 07/10 14:41:55 ### NetMessage::verifyResponseHeader() - Error Code [547] returned - [Problems executing [AppInsertInstanceProp], Line[137] :The INSERT statement conflicted with the FOREIGN KEY constraint "APP_InstanceProp_componentNameId_FK". The conflict occurred in database "CommServ", table "dbo.APP_InstanceName", column 'id'.].
1268413 135abd 07/10 14:41:55 ### InstInterfaceNet::setProperties() - Problems executing [AppInsertInstanceProp], Line[137] :The INSERT statement conflicted with the FOREIGN KEY constraint "APP_InstanceProp_componentNameId_FK". The conflict occurred in database "CommServ", table "dbo.APP_InstanceName", column 'id'.
1268413 135abd 07/10 14:41:55 ### ClOraAgent::AutoDiscoverInstances() - Failed to set Galaxy library path 547
1268413 135abd 07/10 14:41:55 ### ClOraAgent::getRmanErrors() - ORA_OPT_IGNORE_RMANWARNINGS  0
1268413 135abd 07/10 14:41:55 ### GetChannelParamFileName() - Channel Parameter File : /opt/commvault/Base/Temp/cv_channel_info0
1268413 135abd 07/10 14:41:55 ### ::Close() - ClOraAgent Closed.
1268413 135abd 07/10 14:41:55 ### ::Finalize() - enter Parent=true
1268413 135abd 07/10 14:41:55 ### ::Finalize() - delete m_event ...
 

J
Rank
Badge +1

this is the error, before and after update to 11.28.72.

 

1269672 135fa8 07/10 14:47:09 ### ClOraAutoDiscover::CreateNewRACEntities(1276) - No new entities discovered
1269672 135fa8 07/10 14:47:09 ### ClOraAgent::AutoDiscoverInstances() - Instance advqa not found creating now
1269672 135fa8 07/10 14:47:10 ### NetMessage::verifyResponseHeader() - Error Code [547] returned - [Problems executing [AppInsertInstanceProp], Line[137] :The INSERT statement conflicted with the FOREIGN KEY constraint "APP_InstanceProp_componentNameId_FK". The conflict occurred in database "CommServ", table "dbo.APP_InstanceName", column 'id'.].
1269672 135fa8 07/10 14:47:10 ### InstInterfaceNet::setProperties() - Problems executing [AppInsertInstanceProp], Line[137] :The INSERT statement conflicted with the FOREIGN KEY constraint "APP_InstanceProp_componentNameId_FK". The conflict occurred in database "CommServ", table "dbo.APP_InstanceName", column 'id'.
1269672 135fa8 07/10 14:47:10 ### ClOraAgent::AutoDiscoverInstances() - Failed to set Galaxy library path 547
 

i asked for call back on this in my ticket but so far no one has called and they just changed my update time to 4:45pm.  so all the help i have had to this point was that the patch would fix my issue.  it definitely DOES not.

G
Rank
Userlevel 4
Badge +13

Hi @casl 

 

Yes you can have multiple databases with the same name but on a different hosts 

 

Regards,

Gowri Shankar

C
Rank
Badge

It is accurate that the CommServe can support the same database name on different clients, right?

G
Rank
Userlevel 4
Badge +13

Hi @jayme 

 

Could you ensure the database entries are available in /etc/oratab file and also the database is in open mode.

 

Regards,

Gowri Shankar

Reply


Terms & ConditionsCookie settings