1 2 3 4 Previous Next 47 Replies Latest reply: Feb 5, 2014 3:21 AM by fb767351-a660-4b18-9a9f-73bc141f6a0c RSS

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

    fb767351-a660-4b18-9a9f-73bc141f6a0c

      Hi All,

       

      I am not able to connect database remotely. I have two servers with the name US and localhost. Below are my tns details:

       

      Details of host Server US:

       

      [oracle@US admin]$ more tnsnames.ora

      # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

      # Generated by Oracle configuration tools.

      PROD =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = US)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = prod.WORLD)

          )

        )

       

       

      PROD_STBY =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = prod.WORLD)

          )

        )


      [oracle@US admin]$ more /etc/sysconfig/network

      NETWORKING=yes

      NETWORKING_IPV6=yes

      HOSTNAME=US.localdomain


      [oracle@US admin]$ more /etc/hosts

      # Do not remove the following line, or various programs

      # that require network functionality will fail.

      127.0.0.1               localhost.localdomain localhost

      ::1             US.localdomain6 US

       

      Pinging remote location from US server:

       

      [oracle@US admin]$ ping 192.168.188.131

      PING 192.168.188.131 (192.168.188.131) 56(84) bytes of data.

      64 bytes from 192.168.188.131: icmp_seq=1 ttl=64 time=0.662 ms

      64 bytes from 192.168.188.131: icmp_seq=2 ttl=64 time=0.558 ms

      64 bytes from 192.168.188.131: icmp_seq=3 ttl=64 time=0.566 ms

      64 bytes from 192.168.188.131: icmp_seq=4 ttl=64 time=0.603 ms

      64 bytes from 192.168.188.131: icmp_seq=5 ttl=64 time=0.575 ms

      ^C

      --- 192.168.188.131 ping statistics ---

      5 packets transmitted, 5 received, 0% packet loss, time 4002ms

      rtt min/avg/max/mdev = 0.558/0.592/0.662/0.048 ms

       

      Details of remote server localhost:

       

      [oracle@localhost admin]$ more tnsnames.ora

      PROD =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = US)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = prod.WORLD)

          )

        )

       

       

      PROD_STBY =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = prod.WORLD)

          )

        )


      [oracle@localhost admin]$ cat /etc/hosts

      # Do not remove the following line, or various programs

      # that require network functionality will fail.

      127.0.0.1               localhost.localdomain localhost

      ::1             localhost6.localdomain6 localhost6


      [oracle@localhost admin]$ cat /etc/sysconfig/network

      NETWORKING=yes

      NETWORKING_IPV6=yes

      HOSTNAME=localhost.localdomain

       

      [oracle@localhost admin]$ more listener.ora

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (GLOBAL_DBNAME = prod.WORLD)

            (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

            (SID_NAME = prod)

          )

        )

       

       

      LISTENER =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

          )

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

          )

        )

       

       

      ADR_BASE_LISTENER = /u01/app/oracle

       

      [oracle@localhost admin]$ lsnrctl status


      LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-FEB-2014 16:49:36

       

      Copyright (c) 1991, 2009, Oracle.  All rights reserved.

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))

      STATUS of the LISTENER

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

      Alias                     LISTENER

      Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

      Start Date                04-FEB-2014 16:42:09

      Uptime                    0 days 0 hr. 7 min. 26 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

      Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

      Services Summary...

      Service "prod.WORLD" has 1 instance(s).

        Instance "prod", status UNKNOWN, has 1 handler(s) for this service...

      The command completed successfully

       

      Pinging host location from remote server localhost:

       

      [oracle@localhost admin]$ ping 192.168.188.130

      PING 192.168.188.130 (192.168.188.130) 56(84) bytes of data.

      64 bytes from 192.168.188.130: icmp_seq=1 ttl=64 time=1.57 ms

      64 bytes from 192.168.188.130: icmp_seq=2 ttl=64 time=0.223 ms

      64 bytes from 192.168.188.130: icmp_seq=3 ttl=64 time=0.577 ms

      64 bytes from 192.168.188.130: icmp_seq=4 ttl=64 time=0.571 ms

      64 bytes from 192.168.188.130: icmp_seq=5 ttl=64 time=0.568 ms

      ^C

      --- 192.168.188.130 ping statistics ---

      5 packets transmitted, 5 received, 0% packet loss, time 4006ms

      rtt min/avg/max/mdev = 0.223/0.703/1.578/0.458 ms

       

      Connecting target database from standby through RMAN:

       

       

      [oracle@localhost admin]$ rman target sys/oracle_4U@PROD auxiliary sys/oracle_4U@PROD_STBY


      Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 4 16:56:45 2014

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-00554: initialization of internal recovery manager package failed

      RMAN-04005: error from target database:

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

       

      Please let me know the cause of this error and please assist me how can I resolve it.

       

       

      Regards,

      Michel

        1 2 3 4 Previous Next