4 Replies Latest reply: Jan 30, 2013 10:56 AM by Krithi RSS

    ORA-12541:TNS nolistener error: REMOTE DATABASE changed their server

    Krithi
      PLATFORM:WINDOWS
      ORACLE 11gR1(11.1.0.7.0) (Soon will be upgraded to 11gR2)
      Hi
      Our tnsping and remote database connectivity to the remote system was working perfect until yesterday.
      Yesterday the remote database we are connecting to, changed their server to new one so we have been given a new conncetion description and this was changed in the tnsnames.ora file.No other changes made. Our existing listener was stopped and restarted as well .
      we are getting the error
      ORA-12541:TNS nolistener when trying to conenct to their database.
      Please guide how to fix now!
      Please see below the old and new tns entries in tnsnames.ora file
      --This was the old entry , just renamed to .old now
      OS.WORLD.old =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.71)(PORT = 1521))
          )
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = orc1)
          )
        )
      --new entry
      OS.WORLD =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.247)(PORT = 1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.248)(PORT = 1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.249)(PORT = 1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.182)(PORT = 1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.184)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = PRD.osi.net)
          )
        )
      They said new server is on RAC and this is the address what they gave.
      Is there anything unusual in the above entry for os.world?
      I am not sure where else to check for the error information other than tnsping.trc file, its information is given below:
      TNS Ping Utility for 32-bit Windows: Version 11.1.0.7.0 - Production on 30-JAN-2013 11:13:14
      
      Copyright (c) 1997, 2008, Oracle.  All rights reserved.
      
      --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
      New trace stream is F:\oracle11g\home\network\trace\tnsping.trc
      New trace level is 6
      --- TRACE CONFIGURATION INFORMATION ENDS ---
      --- PARAMETER SOURCE INFORMATION FOLLOWS ---
      Attempted load of system pfile source f:\oracle11g\home\network\admin\sqlnet.ora
      Parameter source loaded successfully
      
       -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
      Successful parameter table load
       -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
        TNSPING.TRACE_LEVEL = ADMIN
        NAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)
        TNSPING.TRACE_DIRECTORY = F:\oracle11g\home\network\trace
        SQLNET.AUTHENTICATION_SERVICES = (NTS)
      --- PARAMETER SOURCE INFORMATION ENDS ---
      --- LOG CONFIGURATION INFORMATION FOLLOWS ---
      Log stream will be "standard output"
      Log stream validation not requested
      --- LOG CONFIGURATION INFORMATION ENDS ---
      
      nlstdipi: entry
      nlstdipi: exit
      nnfun2awanm: entry
      nnfgiinit: entry
      nncpcin_maybe_init: first request sent to name server will have ID 0
      nncpcin_maybe_init: initial retry timeout for all name servers is 1500 csecs
      nncpcin_maybe_init: max request retries per name server is 1
      nngsini_init_streams: initializing stream subsystem, cache size is 10
      nngtini_init_msg: initializing PDU subsystem, initial pool size is 2
      nncpcin_maybe_init: default name server domain is [root]
      nnfgiinit: Installing read path
      nnfgsrsp: entry
      nnfgsrsp: Obtaining path parameter from names.directory_path or native_names.directory_path
      nnfgsrdp: entry
      nnfgsrdp: Setting path:
      nnfgsrdp: checking element TNSNAMES
      nnfgsrdp: checking element EZCONNECT
      nnfgsrdp: Path set
      nnfun2a: entry
      nlolgobj: entry
      nnfgrne: entry
      nnfgrne: Going though read path adapters
      nnfgrne: Switching to TNSNAMES adapter
      nnftboot: entry
      nlpaxini: entry
      nlpaxini: exit
      nnftmlf_make_local_addrfile: entry
      nnftmlf_make_local_addrfile: construction of local names file failed
      nnftmlf_make_local_addrfile: exit
      nlpaxini: entry
      nlpaxini: exit
      nnftmlf_make_system_addrfile: entry
      nnftmlf_make_system_addrfile: system names file is f:\oracle11g\home\network\admin\tnsnames.ora
      nnftmlf_make_system_addrfile: exit
      nnftboot: exit
      nnftrne: entry
      nnftrne: Original name: os.world
      nnfttran: entry
      nnfttran: exit
      nnftrne: Using tnsnames.ora address (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.247)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.248)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.249)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.182)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.184)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = PRD.osi.net))) for name os.world
      nnftrne: exit
      nnfgrne: exit
      nlolgserv: entry
      nnfggav: entry
      nnftgav: entry
      nnftgav: exit
      nnfgfrm: entry
      nnftfrm: entry
      nnftfrm: exit
      nnfgfrm: exit
      nlolgserv: exit
      nlolgobj: exit
      nlolfmem: entry
      nlolfmem: exit
      nnfun2awanm: Getting the path of sqlnet.ora
      nnfun2awanm: Getting the adapter name
      nnfun2awanm: exit
      nsmal: 212 bytes at 0x1ef0158
      nscall: connecting...
      nladini: entry
      nladini: exit
      nladget: entry
      nladget: exit
      nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.247)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRD.osi.net)))
      nttbnd2addr: entry
      snlinGetAddrInfo: entry
      snlinGetAddrInfo: exit
      nttbnd2addr: using host IP address: 172.16.1.247
      snlinFreeAddrInfo: entry
      snlinFreeAddrInfo: exit
      nttbnd2addr: exit
      nsmal: 996 bytes at 0x1f3ae00
      nsmal: 2096 bytes at 0x1f3b1f0
      nsmal: 84 bytes at 0x1f3abd0
      nsopen: opening transport...
      nttcon: entry
      nttcon: toc = 1
      nttcnp: entry
      nttcnp: exit
      nttcni: entry
      nttcni: Tcp conn timeout = 0 (ms)
      nttcni: trying to connect to socket 1720.
      ntt2err: entry
      ntt2err: soc 1720 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
      ntt2err: exit
      nttcni: exit
      nttcon: exit
      nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
      nsopen: unable to open transport
      nsvntx_dei: entry
      nsvntx_dei: exit
      nsmfr: 2096 bytes at 0x1f3b1f0
      nsmfr: 996 bytes at 0x1f3ae00
      nscall: connecting...
      nladget: entry
      nladget: exit
      nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.248)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRD.osi.net)))
      nttbnd2addr: entry
      snlinGetAddrInfo: entry
      snlinGetAddrInfo: exit
      nttbnd2addr: using host IP address: 172.16.1.248
      snlinFreeAddrInfo: entry
      snlinFreeAddrInfo: exit
      nttbnd2addr: exit
      nsmal: 996 bytes at 0x1f3ae00
      nsmal: 2096 bytes at 0x1f3db80
      nsopen: opening transport...
      nttcon: entry
      nttcon: toc = 1
      nttcnp: entry
      nttcnp: exit
      nttcni: entry
      nttcni: Tcp conn timeout = 0 (ms)
      nttcni: trying to connect to socket 1720.
      ntt2err: entry
      ntt2err: soc 1720 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
      ntt2err: exit
      nttcni: exit
      nttcon: exit
      nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
      nsopen: unable to open transport
      nsvntx_dei: entry
      nsvntx_dei: exit
      nsmfr: 2096 bytes at 0x1f3db80
      nsmfr: 996 bytes at 0x1f3ae00
      nscall: connecting...
      nladget: entry
      nladget: exit
      nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.249)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRD.osi.net)))
      nttbnd2addr: entry
      snlinGetAddrInfo: entry
      snlinGetAddrInfo: exit
      nttbnd2addr: using host IP address: 172.16.1.249
      snlinFreeAddrInfo: entry
      snlinFreeAddrInfo: exit
      nttbnd2addr: exit
      nsmal: 996 bytes at 0x1f3ae00
      nsmal: 2096 bytes at 0x1f3db80
      nsopen: opening transport...
      nttcon: entry
      nttcon: toc = 1
      nttcnp: entry
      nttcnp: exit
      nttcni: entry
      nttcni: Tcp conn timeout = 0 (ms)
      nttcni: trying to connect to socket 1720.
      ntt2err: entry
      ntt2err: soc 1720 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
      ntt2err: exit
      nttcni: exit
      nttcon: exit
      nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
      nsopen: unable to open transport
      nsvntx_dei: entry
      nsvntx_dei: exit
      nsmfr: 2096 bytes at 0x1f3db80
      nsmfr: 996 bytes at 0x1f3ae00
      nscall: connecting...
      nladget: entry
      nladget: exit
      nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.182)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRD.osi.net)))
      nttbnd2addr: entry
      snlinGetAddrInfo: entry
      snlinGetAddrInfo: exit
      nttbnd2addr: using host IP address: 172.16.1.182
      snlinFreeAddrInfo: entry
      snlinFreeAddrInfo: exit
      nttbnd2addr: exit
      nsmal: 996 bytes at 0x1f3ae00
      nsmal: 2096 bytes at 0x1f3db80
      nsopen: opening transport...
      nttcon: entry
      nttcon: toc = 1
      nttcnp: entry
      nttcnp: exit
      nttcni: entry
      nttcni: Tcp conn timeout = 0 (ms)
      nttcni: trying to connect to socket 1720.
      ntt2err: entry
      ntt2err: soc 1720 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
      ntt2err: exit
      nttcni: exit
      nttcon: exit
      nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
      nsopen: unable to open transport
      nsvntx_dei: entry
      nsvntx_dei: exit
      nsmfr: 2096 bytes at 0x1f3db80
      nsmfr: 996 bytes at 0x1f3ae00
      nscall: connecting...
      nladget: entry
      nladget: exit
      nsc2addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.1.184)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=PRD.osi.net)))
      nttbnd2addr: entry
      snlinGetAddrInfo: entry
      snlinGetAddrInfo: exit
      nttbnd2addr: using host IP address: 172.16.1.184
      snlinFreeAddrInfo: entry
      snlinFreeAddrInfo: exit
      nttbnd2addr: exit
      nsmal: 996 bytes at 0x1f3ae00
      nsmal: 2096 bytes at 0x1f3db80
      nsopen: opening transport...
      nttcon: entry
      nttcon: toc = 1
      nttcnp: entry
      nttcnp: exit
      nttcni: entry
      nttcni: Tcp conn timeout = 0 (ms)
      nttcni: trying to connect to socket 1720.
      ntt2err: entry
      ntt2err: soc 1720 error - operation=1, ntresnt[0]=511, ntresnt[1]=61, ntresnt[2]=0
      ntt2err: exit
      nttcni: exit
      nttcon: exit
      nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[0]=511, nt[1]=61, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
      nsopen: unable to open transport
      nsvntx_dei: entry
      nsvntx_dei: exit
      nsmfr: 2096 bytes at 0x1f3db80
      nsmfr: 996 bytes at 0x1f3ae00
      nscall: connecting...
      nladget: entry
      nladget: exit
      nsmfr: 212 bytes at 0x1ef0158
      nladtrm: entry
      nladtrm: exit
      nlse_term_audit: entry
      nlse_term_audit: exit