Unable to discover or backup database after upgrading Oracle

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Views:: 77

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