Executing task SQLPLUS_CATMAC connect SYS:java.sql.SQLException: ORA-12547: TNS:lost contact Database Vault

Leave a reply

Resolve ORA-12547: TNS Lost Contact Easily

During the Database Vault installation, you may encounter an error. To fix this, create a TNS entry for the database. This may help resolve your issue.

MANAGE_INSTANCE start RDBMS
Executing task SQLPLUS_CATMAC
connect SYS:java.sql.SQLException: ORA-12547: TNS: lost contact

Solution:
1. Go to Oracle Home E:\oracle\dbhome_1

2. Go the network folder

3. Go to the admin folder

4. Open the file tnsnames.ora present in folder otherwise create new file as name TNSNAMES.ora

Make an entry of database in TNSNAMES.ORA file as follows:

EXAMPLE=
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = example.host.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = EXASID)
    )
  )

Otherwise you can add entry with help of NETCA tool.

Leave a Reply