Skip to main content
NetApp Knowledge Base

Unable to discover or backup database after upgrading Oracle

Views:
60
Visibility:
Public
Votes:
0
Category:
snapcenter
Specialty:
snapx
Last Updated:

Applies to

  • SnapCenter Plug-In for Oracle 4.6P1 (SCO)
  • Oracle v. 12.2
  • Oracle v. 18.3

Issue

SCO is unable to discover or backup the database after upgrading Oracle from v.12.2 to 18.3.
In SCO UI the database shows as 'unavailable for backup' and it lists the old db version.
During a Backup, SPL log generates the following errors:
 
2022-05-09T09:53:47.0000180+02:00 DEBUG     DRes-DB1 c.n.o.c.s.d.OracleDatabaseStateService - Entering method  findCurrentDatabaseState with the parameters DatabaseContext [uniqueConfigurationId=323014, sid=DB1, databaseName=DB1, host=Host1.MyDomain.com, port=1521, tnsName=null, rmanCatalogTnsName=, rmanCatalogUserName=, isSysDba=true].
2022-05-09T09:53:47.0000180+02:00 DEBUG     DRes-DB1 c.n.o.c.s.d.OracleDatabaseStateService - Completed method  findCurrentDatabaseState with the  return parameters Empty output.
2022-05-09T09:53:47.0000184+02:00 DEBUG     DRes-DB1 c.n.o.c.s.d.OracleDatabaseStateService - failed to complete method findCurrentDatabaseState  with JVM free memory 1.2 GB and used memory 368.0 MB.
2022-05-09T09:53:47.0000189+02:00 ERROR     DRes-DB1 c.n.o.c.s.d.OracleDatabaseStateService - An exception thrown during the execution of method findCurrentDatabaseState and the exception message is ORACLE-10002: Error received from connection to Oracle database DB1: ORA-12547: TNS:lost contact    

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

Scan to view the article on your device