While working on an issue with Oracle support for our Oracle Enterprise Manager 12c, I was asked to install the EMDIAG REPVFY Kit for Cloud Control 12c.

When I attempted the install from the command line, I received the following error:

[oracle@myserver bin]$ ./repvfy install -tns myserver.mydomain.com:1521:MYDB -pwd password

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 19 11:43:17 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> ERROR:
ORA-12545: Connect failed because target host or object does not exist

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 19 11:43:17 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> ERROR:
ORA-12545: Connect failed because target host or object does not exist

RESOLUTION

Oracle’s installation documentation, titled:  “EMDIAG REPVFY Kit for Cloud Control 12c – Download, Install/De-Install and Upgrade [ID 1426973.1]”, required the host:port:sid for the TNS parameter. Which is what I entered, and did not work.

However this install utility uses the tnsnames.ora file.  What I needed to do was to match the repvfy utility’s TNS parameter to net_service_name parameter in the tnsnames.ora file.

If the entry in the tnsnames.ora file:

MYDB =
    (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = MYDB)
    )
  )

Then the install string would look like:

[oracle@myserver bin]$ ./repvfy install -tns MYDB -pwd password