itle: Unable to connect to remote database during virtual database policy enforcement

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress

Title: Unable to connect to remote database during virtual database policy enforcement
Details: Unable to connect to the database "...temp_db_name...". The database or host may be down. Connection error: Cannot connect to database due to: Exception occurred while getting connection:

oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

User Action: Start the affected database and make sure connectivity is available.

----------------


i am getting above waring with suggestion but both source and target db is already started.

delphix is new to me and not sure what to check,


Photo of Ashok

Ashok

  • 80 Points 75 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matt Watson

Matt Watson, Employee

  • 782 Points 500 badge 2x thumb
: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Check that the VDB has successfully registered with the listener using "lsnrctl status", if it hasn't, check that the local_listener parameter in oracle is correct.
Photo of Ashok

Ashok

  • 80 Points 75 badge 2x thumb

Its already register as per the local_listener parameter. maybe it is because of we have recently bounce back the production server also we have changed snapsyn policy recently.

Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,632 Points 4k badge 2x thumb

Hi

Please check if you have at the target level Under database tab a connection defined for the comserned DB.

Regards,


Mouhssine 

Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
Can you show a screenshot of the error message?