1 2 Previous Next 28 Replies Latest reply: Aug 9, 2010 5:40 AM by dba_princess RSS

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

    Samuel Rabini
      Hi,
      I have an Oracle Database 11g Release 11.1.0.6.0 - 64bit Production With the Real Application Clusters option.
      I activated the DRCP on the server and modified the tnsnames.ora, creating 3 new entries to manage the pooled connection type:

      EVODB =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
      (LOAD_BALANCE = yes)
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EVODB)
      )
      )

      EVODB1 =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EVODB)
      (INSTANCE_NAME = EVODB1)
      )
      )

      EVODB2 =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EVODB)
      (INSTANCE_NAME = EVODB2)
      )
      )

      EVODB_POOLED =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
      (LOAD_BALANCE = yes)
      (CONNECT_DATA =
      (SERVER = POOLED)
      (SERVICE_NAME = EVODB)
      )
      )

      EVODB1_POOLED =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = POOLED)
      (SERVICE_NAME = EVODB)
      (INSTANCE_NAME = EVODB1)
      )
      )

      EVODB2_POOLED =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = POOLED)
      (SERVICE_NAME = EVODB)
      (INSTANCE_NAME = EVODB2)
      )
      )

      All entries are working fine but EVODB_POOLED.
      When I used that one I got the ORA-12545.
      But not always! After 3 or 4 tries I can connect to the database:

      C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED

      SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:24 2010

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

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


      Enter user-name:
      C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED

      SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:26 2010

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

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


      Enter user-name:
      C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED

      SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:28 2010

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

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


      Enter user-name:
      C:\Documents and Settings\serveruser>sqlplus user/password@EVODB_POOLED

      SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 10:59:30 2010

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


      Connected to:
      Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
      With the Real Application Clusters option

      SQL>

      Do you have any idea about the problem?

      Thanks in advance,
      Samuel
        • 1. Re: ORA-12545: Connect failed because target host or object does not exist
          Chinar
          EVODB_POOLED =
          +(DESCRIPTION =+
          +(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node1_virtual)(PORT = 1521))+
          +(ADDRESS = (PROTOCOL = TCP)(HOST = dns_node2_virtual)(PORT = 1521))+
          +(LOAD_BALANCE = yes)+
          +(CONNECT_DATA =+
          +(SERVER = POOLED)+
          +(SERVICE_NAME = EVODB)+
          +)+
          +)+

          Probably there problem setting up dns_node1_virtual and dns_node2_virtual.One of their is fine but other is not properly setting.Also there is enable load balancing because of this you can connect after 3 login.Check listener log and investigate this
          • 2. Re: ORA-12545: Connect failed because target host or object does not exist
            Satish Kandi
            Could you post your sqlnet.ora here?
            • 3. Re: ORA-12545: Connect failed because target host or object does not exist
              781937
              I too had the same issue and i configured separate tns entry as you have done. After that i didnt get any problem.
              • 4. Re: ORA-12545: Connect failed because target host or object does not exist
                Samuel Rabini
                Well, the entry EVODB doesn't have any problem. I can connected with it without any issue.
                Also EVODB1_POOLED and EVODB2_POOLED are working fine.

                ******************************************************************************************************************

                C:\Documents and Settings\serveruser>sqlplus user/password@EVODB

                SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 12:48:17 2010

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


                Connected to:
                Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                SQL> quit
                Disconnected from Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                C:\Documents and Settings\serveruser>sqlplus user/password@EVODB

                SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 12:48:28 2010

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


                Connected to:
                Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                SQL> quit
                Disconnected from Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                C:\Documents and Settings\serveruser>sqlplus user/password@EVODB

                SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 12:48:30 2010

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


                Connected to:
                Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                SQL> quit
                Disconnected from Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                *****************************************************************************************************

                C:\Documents and Settings\serveruser>sqlplus user/password@EVODB1_POOLED

                SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 12:41:47 2010

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


                Connected to:
                Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                SQL> select instance_name from v$instance;

                INSTANCE_NAME
                ----------------
                EVODB1

                SQL> quit
                Disconnected from Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                C:\Documents and Settings\serveruser>sqlplus user/password@EVODB2_POOLED

                SQL*Plus: Release 11.1.0.6.0 - Production on Thu Jul 8 12:41:54 2010

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


                Connected to:
                Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                SQL> select instance_name from v$instance;

                INSTANCE_NAME
                ----------------
                EVODB2

                SQL> quit
                Disconnected from Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
                With the Real Application Clusters option

                Edited by: Samuel Rabini on Jul 8, 2010 2:42 PM

                Edited by: Samuel Rabini on Jul 8, 2010 2:49 PM
                • 6. Re: ORA-12545: Connect failed because target host or object does not exist
                  277993
                  If you are using Database Resident Connection Pooling and you are sure that your PC can access or see both nodes without any problems (check outside Oracle) , then ensure that the connection pool is started on both Instances.
                  execute dbms_connection_pool.start_pool;
                  The conenction pool is at Instance level I believe. So the difference is that this does not have the instance name. Not sure how it will work with the service name only
                  • 7. Re: ORA-12545: Connect failed because target host or object does not exist
                    Samuel Rabini
                    What I found on the Oracle Documentation is that the

                    execute dbms_connection_pool.start_pool;

                    enables DRCP on all Oracle RAC Instance.
                    And I verified that it is enabled on both:

                    SQL> select connection_pool, status from dba_cpool_info;

                    CONNECTION_POOL STATUS
                    -------------------------------------------------- ---------------
                    SYS_DEFAULT_CONNECTION_POOL ACTIVE

                    thanks
                    • 8. Re: ORA-12545: Connect failed because target host or object does not exist
                      Kmohan-Oracle
                      After the pool is started, it may take some time for the connection broker to register with the listener. Once you start getting successful connections, you should not see the connect problems again.
                      • 9. Re: ORA-12545: Connect failed because target host or object does not exist
                        Samuel Rabini
                        Thanks Kmohan,
                        but the pool is up and running since 1 month.
                        • 10. Re: ORA-12545: Connect failed because target host or object does not exist
                          Samuel Rabini
                          Hi, some new ideas?
                          The problem persists.

                          Thanks,
                          Samuel
                          • 11. Re: ORA-12545: Connect failed because target host or object does not exist
                            rajeysh
                            for client side load balancing use remote_listener parameter
                            refer the link: and oracle documentation
                            http://www.databasejournal.com/features/oracle/article.php/3666396/Oracle-10gR2-RAC-Load-Balancing-Features.htm
                            • 12. Re: ORA-12545: Connect failed because target host or object does not exist
                              Samuel Rabini
                              But why the problem exists just for the POOLED entry and not for the DEDICATED one?
                              • 13. Re: ORA-12545: Connect failed because target host or object does not exist
                                Samuel Rabini
                                I've some new about this problem.
                                I activated the sql net trace on my client.
                                I've a trace of a success and an unsuccess:

                                I post just the part of traces in which there is significant information

                                Unsuccess

                                [03-AUG-2010 16:28:04:500] nspsend: packet dump
                                [03-AUG-2010 16:28:04:500] nspsend: 01 26 00 00 06 00 00 00 |.&......|
                                [03-AUG-2010 16:28:04:500] nspsend: 00 00 28 44 45 53 43 52 |..(DESCR|
                                [03-AUG-2010 16:28:04:500] nspsend: 49 50 54 49 4F 4E 3D 28 |IPTION=(|
                                [03-AUG-2010 16:28:04:500] nspsend: 41 44 44 52 45 53 53 3D |ADDRESS=|
                                [03-AUG-2010 16:28:04:500] nspsend: 28 50 52 4F 54 4F 43 4F |(PROTOCO|
                                [03-AUG-2010 16:28:04:500] nspsend: 4C 3D 54 43 50 29 28 48 |L=TCP)(H|
                                [03-AUG-2010 16:28:04:500] nspsend: 4F 53 54 3D 31 30 2E 38 |OST=10.8|
                                [03-AUG-2010 16:28:04:500] nspsend: 31 2E 31 30 2E 31 34 30 |1.10.140|
                                [03-AUG-2010 16:28:04:500] nspsend: 29 28 50 4F 52 54 3D 31 |)(PORT=1|
                                [03-AUG-2010 16:28:04:500] nspsend: 35 32 31 29 29 28 4C 4F |521))(LO|
                                [03-AUG-2010 16:28:04:500] nspsend: 41 44 5F 42 41 4C 41 4E |AD_BALAN|
                                [03-AUG-2010 16:28:04:500] nspsend: 43 45 3D 79 65 73 29 28 |CE=yes)(|
                                [03-AUG-2010 16:28:04:500] nspsend: 43 4F 4E 4E 45 43 54 5F |CONNECT_|
                                [03-AUG-2010 16:28:04:500] nspsend: 44 41 54 41 3D 28 53 45 |DATA=(SE|
                                [03-AUG-2010 16:28:04:500] nspsend: 52 56 45 52 3D 50 4F 4F |RVER=POO|
                                [03-AUG-2010 16:28:04:500] nspsend: 4C 45 44 29 28 53 45 52 |LED)(SER|
                                [03-AUG-2010 16:28:04:500] nspsend: 56 49 43 45 5F 4E 41 4D |VICE_NAM|
                                [03-AUG-2010 16:28:04:500] nspsend: 45 3D 45 56 4F 44 42 29 |E=EVODB)|
                                [03-AUG-2010 16:28:04:500] nspsend: 28 46 41 49 4C 4F 56 45 |(FAILOVE|
                                [03-AUG-2010 16:28:04:500] nspsend: 52 5F 4D 4F 44 45 3D 28 |R_MODE=(|
                                [03-AUG-2010 16:28:04:500] nspsend: 54 59 50 45 3D 53 45 4C |TYPE=SEL|
                                [03-AUG-2010 16:28:04:500] nspsend: 45 43 54 29 28 4D 45 54 |ECT)(MET|
                                [03-AUG-2010 16:28:04:500] nspsend: 48 4F 44 3D 53 45 53 53 |HOD=SESS|
                                [03-AUG-2010 16:28:04:500] nspsend: 49 4F 4E 29 28 52 45 54 |ION)(RET|
                                [03-AUG-2010 16:28:04:500] nspsend: 52 49 45 53 3D 31 38 30 |RIES=180|
                                [03-AUG-2010 16:28:04:500] nspsend: 29 28 44 45 4C 41 59 3D |)(DELAY=|
                                [03-AUG-2010 16:28:04:500] nspsend: 35 29 29 28 43 49 44 3D |5))(CID=|
                                [03-AUG-2010 16:28:04:500] nspsend: 28 50 52 4F 47 52 41 4D |(PROGRAM|
                                [03-AUG-2010 16:28:04:500] nspsend: 3D 45 3A 5C 6F 72 61 63 |=E:\orac|
                                [03-AUG-2010 16:28:04:500] nspsend: 6C 65 31 31 5C 62 69 6E |le11\bin|
                                [03-AUG-2010 16:28:04:500] nspsend: 5C 73 71 6C 70 6C 75 73 |\sqlplus|
                                [03-AUG-2010 16:28:04:500] nspsend: 2E 65 78 65 29 28 48 4F |.exe)(HO|
                                [03-AUG-2010 16:28:04:500] nspsend: 53 54 3D 49 54 57 53 2D |ST=ITWS-|
                                [03-AUG-2010 16:28:04:500] nspsend: 52 41 42 49 4E 49 29 28 |RABINI)(|
                                [03-AUG-2010 16:28:04:500] nspsend: 55 53 45 52 3D 73 61 6D |USER=sam|
                                [03-AUG-2010 16:28:04:500] nspsend: 75 65 6C 2E 72 61 62 69 |uel.rabi|
                                [03-AUG-2010 16:28:04:500] nspsend: 6E 69 29 29 29 29 |ni)))) |
                                [03-AUG-2010 16:28:04:500] nspsend: 294 bytes to transport
                                [03-AUG-2010 16:28:04:500] nspsend: normal exit
                                [03-AUG-2010 16:28:04:500] nsdofls: exit (0)
                                [03-AUG-2010 16:28:04:500] nsdoacts: flushing transport
                                [03-AUG-2010 16:28:04:500] nttctl: entry
                                [03-AUG-2010 16:28:04:500] nsdoacts: normal exit
                                [03-AUG-2010 16:28:04:500] nsdo: normal exit
                                [03-AUG-2010 16:28:04:500] nscon: exit (0)
                                [03-AUG-2010 16:28:04:500] nsdo: nsctxrnk=0
                                [03-AUG-2010 16:28:04:500] nsdo: normal exit
                                [03-AUG-2010 16:28:04:500] nsdo: entry
                                [03-AUG-2010 16:28:04:500] nsdo: cid=0, opcode=68, bl=512, what=9, uflgs=0x0, cflgs=0x3
                                [03-AUG-2010 16:28:04:500] nsdo: rank=64, nsctxrnk=0
                                [03-AUG-2010 16:28:04:500] nsdo: nsctx: state=2, flg=0x4005, mvd=0
                                [03-AUG-2010 16:28:04:500] nsdo: gtn=10, gtc=10, ptn=10, ptc=8155
                                [03-AUG-2010 16:28:04:500] nscon: entry
                                [03-AUG-2010 16:28:04:500] nscon: recving a packet
                                [03-AUG-2010 16:28:04:500] nsprecv: entry
                                [03-AUG-2010 16:28:04:500] nsprecv: reading from transport...
                                [03-AUG-2010 16:28:04:500] nttrd: entry
                                [03-AUG-2010 16:28:04:515] nttrd: socket 1764 had bytes read=76
                                [03-AUG-2010 16:28:04:515] nttrd: exit
                                [03-AUG-2010 16:28:04:515] nsprecv: 76 bytes from transport
                                [03-AUG-2010 16:28:04:515] nsprecv: tlen=76, plen=76, type=5
                                [03-AUG-2010 16:28:04:515] nsprecv: packet dump
                                [03-AUG-2010 16:28:04:515] nsprecv: 00 4C 00 00 05 00 00 00 |.L......|
                                [03-AUG-2010 16:28:04:515] nsprecv: 00 42 28 41 44 44 52 45 |.B(ADDRE|
                                [03-AUG-2010 16:28:04:515] nsprecv: 53 53 3D 28 50 52 4F 54 |SS=(PROT|
                                [03-AUG-2010 16:28:04:515] nsprecv: 4F 43 4F 4C 3D 74 63 70 |OCOL=tcp|
                                [03-AUG-2010 16:28:04:515] nsprecv: 29 28 48 4F 53 54 3D 64 |)(HOST=d|
                                [03-AUG-2010 16:28:04:515] nsprecv: 63 73 72 76 2D 65 76 6F |csrv-evo|
                                [03-AUG-2010 16:28:04:515] nsprecv: 64 62 30 31 2E 61 6C 74 |db01.alt|
                                [03-AUG-2010 16:28:04:515] nsprecv: 65 61 2E 6E 65 74 29 28 |ea.net)(|
                                [03-AUG-2010 16:28:04:515] nsprecv: 50 4F 52 54 3D 35 38 38 |PORT=588|
                                [03-AUG-2010 16:28:04:515] nsprecv: 31 31 29 29 |11)) |
                                [03-AUG-2010 16:28:04:515] nsprecv: normal exit
                                [03-AUG-2010 16:28:04:515] nscon: got NSPTRD packet
                                [03-AUG-2010 16:28:04:515] nscon: got 66 bytes connect data
                                ...
                                [03-AUG-2010 16:28:04:515] nsc2addr: (ADDRESS=(PROTOCOL=tcp)(HOST=dcsrv-evodb01.altea.net)(PORT=58811))
                                [03-AUG-2010 16:28:04:515] nttbnd2addr: entry
                                [03-AUG-2010 16:28:04:515] snlinGetAddrInfo: entry
                                [03-AUG-2010 16:28:04:515] snlinGetAddrInfo: getaddrinfo() failed with error 11001
                                [03-AUG-2010 16:28:04:515] snlinGetAddrInfo: exit
                                [03-AUG-2010 16:28:04:515] nttbnd2addr: looking up IP addr for host: dcsrv-evodb01.altea.net
                                [03-AUG-2010 16:28:04:515] snlinGetAddrInfo: entry
                                [03-AUG-2010 16:28:04:531] snlinGetAddrInfo: getaddrinfo() failed with error 11001
                                [03-AUG-2010 16:28:04:531] snlinGetAddrInfo: exit
                                [03-AUG-2010 16:28:04:531] nttbnd2addr: *** hostname lookup failure! ***
                                [03-AUG-2010 16:28:04:531] nttbnd2addr: exit

                                Success

                                [03-AUG-2010 17:18:53:656] nspsend: packet dump
                                [03-AUG-2010 17:18:53:656] nspsend: 01 26 00 00 06 00 00 00 |.&......|
                                [03-AUG-2010 17:18:53:656] nspsend: 00 00 28 44 45 53 43 52 |..(DESCR|
                                [03-AUG-2010 17:18:53:656] nspsend: 49 50 54 49 4F 4E 3D 28 |IPTION=(|
                                [03-AUG-2010 17:18:53:656] nspsend: 41 44 44 52 45 53 53 3D |ADDRESS=|
                                [03-AUG-2010 17:18:53:656] nspsend: 28 50 52 4F 54 4F 43 4F |(PROTOCO|
                                [03-AUG-2010 17:18:53:656] nspsend: 4C 3D 54 43 50 29 28 48 |L=TCP)(H|
                                [03-AUG-2010 17:18:53:656] nspsend: 4F 53 54 3D 31 30 2E 38 |OST=10.8|
                                [03-AUG-2010 17:18:53:656] nspsend: 31 2E 31 30 2E 31 33 30 |1.10.130|
                                [03-AUG-2010 17:18:53:656] nspsend: 29 28 50 4F 52 54 3D 31 |)(PORT=1|
                                [03-AUG-2010 17:18:53:656] nspsend: 35 32 31 29 29 28 4C 4F |521))(LO|
                                [03-AUG-2010 17:18:53:656] nspsend: 41 44 5F 42 41 4C 41 4E |AD_BALAN|
                                [03-AUG-2010 17:18:53:656] nspsend: 43 45 3D 79 65 73 29 28 |CE=yes)(|
                                [03-AUG-2010 17:18:53:656] nspsend: 43 4F 4E 4E 45 43 54 5F |CONNECT_|
                                [03-AUG-2010 17:18:53:656] nspsend: 44 41 54 41 3D 28 53 45 |DATA=(SE|
                                [03-AUG-2010 17:18:53:656] nspsend: 52 56 45 52 3D 50 4F 4F |RVER=POO|
                                [03-AUG-2010 17:18:53:656] nspsend: 4C 45 44 29 28 53 45 52 |LED)(SER|
                                [03-AUG-2010 17:18:53:656] nspsend: 56 49 43 45 5F 4E 41 4D |VICE_NAM|
                                [03-AUG-2010 17:18:53:656] nspsend: 45 3D 45 56 4F 44 42 29 |E=EVODB)|
                                [03-AUG-2010 17:18:53:656] nspsend: 28 46 41 49 4C 4F 56 45 |(FAILOVE|
                                [03-AUG-2010 17:18:53:656] nspsend: 52 5F 4D 4F 44 45 3D 28 |R_MODE=(|
                                [03-AUG-2010 17:18:53:656] nspsend: 54 59 50 45 3D 53 45 4C |TYPE=SEL|
                                [03-AUG-2010 17:18:53:656] nspsend: 45 43 54 29 28 4D 45 54 |ECT)(MET|
                                [03-AUG-2010 17:18:53:656] nspsend: 48 4F 44 3D 53 45 53 53 |HOD=SESS|
                                [03-AUG-2010 17:18:53:656] nspsend: 49 4F 4E 29 28 52 45 54 |ION)(RET|
                                [03-AUG-2010 17:18:53:656] nspsend: 52 49 45 53 3D 31 38 30 |RIES=180|
                                [03-AUG-2010 17:18:53:656] nspsend: 29 28 44 45 4C 41 59 3D |)(DELAY=|
                                [03-AUG-2010 17:18:53:656] nspsend: 35 29 29 28 43 49 44 3D |5))(CID=|
                                [03-AUG-2010 17:18:53:656] nspsend: 28 50 52 4F 47 52 41 4D |(PROGRAM|
                                [03-AUG-2010 17:18:53:656] nspsend: 3D 45 3A 5C 6F 72 61 63 |=E:\orac|
                                [03-AUG-2010 17:18:53:656] nspsend: 6C 65 31 31 5C 62 69 6E |le11\bin|
                                [03-AUG-2010 17:18:53:656] nspsend: 5C 73 71 6C 70 6C 75 73 |\sqlplus|
                                [03-AUG-2010 17:18:53:656] nspsend: 2E 65 78 65 29 28 48 4F |.exe)(HO|
                                [03-AUG-2010 17:18:53:656] nspsend: 53 54 3D 49 54 57 53 2D |ST=ITWS-|
                                [03-AUG-2010 17:18:53:656] nspsend: 52 41 42 49 4E 49 29 28 |RABINI)(|
                                [03-AUG-2010 17:18:53:656] nspsend: 55 53 45 52 3D 73 61 6D |USER=sam|
                                [03-AUG-2010 17:18:53:656] nspsend: 75 65 6C 2E 72 61 62 69 |uel.rabi|
                                [03-AUG-2010 17:18:53:656] nspsend: 6E 69 29 29 29 29 |ni)))) |
                                [03-AUG-2010 17:18:53:656] nspsend: 294 bytes to transport
                                [03-AUG-2010 17:18:53:656] nspsend: normal exit
                                [03-AUG-2010 17:18:53:656] nsdofls: exit (0)
                                [03-AUG-2010 17:18:53:656] nsdoacts: flushing transport
                                [03-AUG-2010 17:18:53:656] nttctl: entry
                                [03-AUG-2010 17:18:53:656] nsdoacts: normal exit
                                [03-AUG-2010 17:18:53:656] nsdo: normal exit
                                [03-AUG-2010 17:18:53:656] nscon: exit (0)
                                [03-AUG-2010 17:18:53:656] nsdo: nsctxrnk=0
                                [03-AUG-2010 17:18:53:656] nsdo: normal exit
                                [03-AUG-2010 17:18:53:656] nsdo: entry
                                [03-AUG-2010 17:18:53:656] nsdo: cid=0, opcode=68, bl=512, what=9, uflgs=0x0, cflgs=0x3
                                [03-AUG-2010 17:18:53:656] nsdo: rank=64, nsctxrnk=0
                                [03-AUG-2010 17:18:53:656] nsdo: nsctx: state=2, flg=0x4005, mvd=0
                                [03-AUG-2010 17:18:53:656] nsdo: gtn=10, gtc=10, ptn=10, ptc=8155
                                [03-AUG-2010 17:18:53:656] nscon: entry
                                [03-AUG-2010 17:18:53:656] nscon: recving a packet
                                [03-AUG-2010 17:18:53:656] nsprecv: entry
                                [03-AUG-2010 17:18:53:656] nsprecv: reading from transport...
                                [03-AUG-2010 17:18:53:656] nttrd: entry
                                [03-AUG-2010 17:18:53:671] nttrd: socket 1764 had bytes read=8
                                [03-AUG-2010 17:18:53:671] nttrd: exit
                                [03-AUG-2010 17:18:53:671] nsprecv: 8 bytes from transport
                                [03-AUG-2010 17:18:53:671] nsprecv: tlen=8, plen=8, type=11
                                [03-AUG-2010 17:18:53:671] nsprecv: packet dump
                                [03-AUG-2010 17:18:53:671] nsprecv: 00 08 00 00 0B 00 00 00 |........|
                                [03-AUG-2010 17:18:53:671] nsprecv: normal exit
                                [03-AUG-2010 17:18:53:671] nscon: got NSPTRS packet
                                [03-AUG-2010 17:18:53:671] nscon: no connect data
                                [03-AUG-2010 17:18:53:671] nscon: exit (0)
                                [03-AUG-2010 17:18:53:671] nsdo: nsctxrnk=0
                                [03-AUG-2010 17:18:53:671] nsdo: normal exit
                                [03-AUG-2010 17:18:53:671] nsdo: entry
                                [03-AUG-2010 17:18:53:671] nsdo: cid=0, opcode=67, bl=284, what=8, uflgs=0x0, cflgs=0x3
                                [03-AUG-2010 17:18:53:671] nsdo: rank=64, nsctxrnk=0
                                [03-AUG-2010 17:18:53:671] nsdo: nsctx: state=2, flg=0x4005, mvd=0
                                [03-AUG-2010 17:18:53:671] nsdo: gtn=10, gtc=10, ptn=10, ptc=8155
                                [03-AUG-2010 17:18:53:671] nscon: entry
                                [03-AUG-2010 17:18:53:671] nscon: sending NSPTCN packet
                                [03-AUG-2010 17:18:53:671] nspsend: entry
                                [03-AUG-2010 17:18:53:671] nspsend: plen=58, type=1
                                [03-AUG-2010 17:18:53:671] nttwr: entry
                                [03-AUG-2010 17:18:53:671] nttwr: socket 1764 had bytes written=58
                                [03-AUG-2010 17:18:53:671] nttwr: exit
                                [03-AUG-2010 17:18:53:671] nspsend: packet dump
                                [03-AUG-2010 17:18:53:671] nspsend: 00 3A 00 00 01 00 00 00 |.:......|
                                [03-AUG-2010 17:18:53:671] nspsend: 01 3A 01 2C 00 41 20 00 |.:.,.A..|
                                [03-AUG-2010 17:18:53:671] nspsend: 7F FF C6 0E 00 00 01 00 |........|
                                [03-AUG-2010 17:18:53:671] nspsend: 01 1C 00 3A 00 00 02 00 |...:....|
                                [03-AUG-2010 17:18:53:671] nspsend: 41 41 00 00 00 00 00 00 |AA......|
                                [03-AUG-2010 17:18:53:671] nspsend: 00 00 00 00 00 00 00 00 |........|
                                [03-AUG-2010 17:18:53:671] nspsend: 00 00 00 00 00 00 00 00 |........|
                                [03-AUG-2010 17:18:53:671] nspsend: 00 00 |.. |
                                [03-AUG-2010 17:18:53:671] nspsend: 58 bytes to transport
                                ...

                                The log of the success is a lot bigger than the other one.

                                What I noticed into the unsuccess one is that to the client has been told from the server to connect to the HOST=dcsrv-evodb01.altea.net, PORT=58811.
                                That host is the fisical address of the host, not the virutal one.
                                The fisical could not been solved by the client. Even if I add the address to the hosts file, I've the problem of the port, that I cannot open all port between a DMZ to the DB Server LAN.
                                When I've a success, the client is redirect to the vip-address port 1521 (allowed by the firewall).

                                Why the client receive the fisical address instead of the virtual one?

                                If the full logs could be usefull I can post them (is there a way to attach files to a post?).

                                Thanks in advance.

                                Samuel

                                Edited by: Samuel Rabini on Aug 6, 2010 11:41 AM
                                • 14. Re: ORA-12545: Connect failed because target host or object does not exist
                                  Richard Harrison .
                                  Hi,
                                  In your listener.ora on the two rac nodes are you using (IP=FIRST) at the end of the configuration line?

                                  i.e.

                                  LISTENER =
                                  (DESCRIPTION_LIST =
                                  (DESCRIPTION =
                                  (ADDRESS_LIST =
                                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
                                  )
                                  (ADDRESS_LIST =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = your-vip)(PORT = 1521)(IP = FIRST))
                                  )
                                  )
                                  )

                                  Perhaps this is the cause if it's not there?

                                  Cheers,
                                  Harry
                                  1 2 Previous Next