CODEWITHSUNDEEP
oracle-databaselisteneroracle18c
Aman Singh Rajpoot
Aman Singh Rajpoot

Reputation: 1479

TNS-12545: Connect failed because target host or object does not exist

I am trying to configure Oracle database 18C on Azure cloud VM. I have installed the Oracle database and now I am trying to configure Listener I have set up a public static IPv4 address for the VM When I am trying to add the IP address in the listener and tnsnames file, I am getting this error

Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   64-bit Windows Error: 49: Unknown error

Here is my listener.ora and tsnnames.ora file configuration.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\app\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
     (SID_DESC =
             (SID_NAME = ORCL)
             )
                       
  )


LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IPaddress)(PORT = 1521))
  )

ADR_BASE_LISTENER = C:\Oracle\Oracle18C\log

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IPaddress)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )

Ping is working for the IP address when I try with my local machine When I tried using the hostname 'oraclevm' then listener was able to start up

Upvotes: 1

Views: 13675

Answers (1)

scott yu
scott yu

Reputation: 125

the following a working example for listener.ora

[oracle@ol7-19 ~]$ cd $ORACLE_HOME/network/admin
[oracle@ol7-19 admin]$ more listener.ora
# listener.ora Network Configuration File: /home/oracle/Downloads/19c/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ol7-19.localdomain)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )

Upvotes: 1

Related Questions