0 Replies Latest reply: Oct 23, 2013 4:44 AM by hokoba RSS

    tnsping80 ok! - ORA-12203

    hokoba

      Hi Techies,

      I am trying to connect to the oracle DB in another machine using Forms 6i.(I have only runtime environment)

      I can ping the DB server and also the tnsping80 works fine.

      while connecting through Forms 6i ifrun60 shortcut, I get "ORA-12203:TNS:Unable to connect to destination" error.

       

      TNSPING80 @Client

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

      C:\orant\BIN>tnsping80 occi

      TNS Ping Utility for 32-bit Windows: Version 8.0.6.0.0 - Production on 22-OCT-13

      16:59:26

      (c) Copyright 1997 Oracle Corporation.  All rights reserved.

      Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=192.192.0.90)(PORT=1521))

      OK (0 msec)

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

      TNSPING.trc @ Client

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

      TNS Ping Utility for 32-bit Windows: Version 8.0.6.0.0 - Production on 22-OCT-13 16:32:23

      (c) Copyright 1997 Oracle Corporation.  All rights reserved.

      --- TRACE CONFIGURATION INFORMATION FOLLOWS ---

      New trace stream is "c:\trace\trace\tnsping.trc"

      New trace level is 6

      --- TRACE CONFIGURATION INFORMATION ENDS ---

      nnftboot: entry

      nnftboot: exit

      nnfoboot: entry

      nnfoboot: exit

      nnfoboot: entry

      nnfoboot: exit

      nnfhboot: entry

      nnfhboot: exit

      nncpmlf_make_local_addrfile: construction of local names file failed

      nncpmsf_make_sys_addrfile: system names file is C:\orant\NET80\admin\tnsnames.ora

      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]

      nnfun2a: entry

      nnftqnm: entry

      nnfcagmd: entry

      nnfcagmd: Attribute name a.smd is a predefined meta type, syntax is 4.

      nnfcagmd: exit

      nncpldf_load_addrfile: initial load of names file C:\orant\NET80\admin\tnsnames.ora

      nncpldf_load_addrfile: success

      nnftqnm: Using tnsnames.ora address (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.192.0.90)(PORT = 1521)) (CONNECT_DATA = (SID = ora9itgo))) for name occi

      nnfcraa: entry

      nnftans: entry

      nnfcran: entry

      nnfcran: 64 rrs requested, 1 remaining, 1 total

      nnfcran: exit

      nnfotrv1: entry

      nnfotrv1: translated "occi" to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.192.0.90)(PORT = 1521)) (CONNECT_DATA = (SID = ora9itgo)))

      nscall: connecting...

      nttbnd2addr: entry

      nttbnd2addr: port resolved to 1521

      nttbnd2addr: using host IP address: 192.192.0.90

      nttbnd2addr: exit

      nsmal: 400 bytes at 0x1afa6b8

      nsmal: 1664 bytes at 0x1b3dc70

      nsopen: opening transport...

      nttcon: entry

      nttcon: toc = 1

      nttcnp: entry

      ntvlin: entry

      ntvllt: entry

      ntvllt: No PROTOCOL.ORA file is found

      ntvllt: exit

      ntvlin: exit

      nttcnp: Validnode Table IN use; err 0x0

      nttcnp: exit

      nttcni: entry

      nttcni: trying to connect to socket 352.

      nttcni: exit

      nttcon: exit

      nsopen: transport is open

      nsnainit: call

      nsnainit: NA not wanted - disabling and returning

      nsoptions: lcl[0]=0x0, lcl[1]=0x10, gbl[0]=0x0, gbl[1]=0x0, cha=0x0

      nsoptions: lcl[0]=0xefff, lcl[1]=0x10, gbl[0]=0xb83f, gbl[1]=0x0

      nsopen: global context check-in (to slot 0) complete

      nsopen: lcl[0]=0xefff, lcl[1]=0x10, gbl[0]=0xb83f, gbl[1]=0x0, tdu=32767, sdu=2048

      nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2

      nsdo: rank=64, nsctxrnk=0

      nsdo: nsctx: state=7, flg=0x4201, mvd=0

      nsmal: 44 bytes at 0x1afa850

      nsmal: 44 bytes at 0x1afc750

      nlidg8: entry

      nlidg8: exit

      nsdo: nsctxrnk=0

      nsdo: cid=0, opcode=67, *bl=29, *what=8, uflgs=0x0, cflgs=0x3

      nsdo: rank=64, nsctxrnk=0

      nsdo: nsctx: state=14, flg=0x4205, mvd=0

      nsdo: gtn=0, gtc=0, ptn=10, ptc=2047

      nscon: doing connect handshake...

      nscon: sending NSPTCN packet

      nspsend: plen=87, type=1

      nttwr: entry

      nttwr: socket 352 had bytes written=87

      nttwr: exit

      nspsend: 87 bytes to transport

      nsdo: nsctxrnk=0

      nsdo: cid=0, opcode=68, *bl=256, *what=9, uflgs=0x2000, cflgs=0x3

      nsdo: rank=64, nsctxrnk=0

      nsdo: nsctx: state=2, flg=0x4205, mvd=0

      nsdo: gtn=0, gtc=0, ptn=10, ptc=2047

      nscon: recving a packet

      nsmal: 44 bytes at 0x1afc788

      nsprecv: reading from transport...

      nttrd: entry

      nttrd: socket 352 had bytes read=73

      nttrd: exit

      nsprecv: 73 bytes from transport

      nsprecv: tlen=73, plen=73, type=4

      nscon: got NSPTRF packet

      nscon: got 61 bytes connect data

      nsdo: nsctxrnk=0

      nscall: refused

      nstimarmed: no timer allocated

      nsdo: cid=0, opcode=98, *bl=0, *what=0, uflgs=0x40, cflgs=0x2

      nsdo: rank=64, nsctxrnk=0

      nsdo: nsctx: state=3, flg=0x4201, mvd=0

      nsdo: nsctxrnk=0

      nsclose: closing transport

      nttdisc: entry

      nttdisc: Closed socket 352

      nttdisc: exit

      nsclose: global context check-out (from slot 0) complete

      nsmfr: 1664 bytes at 0x1b3dc70

      nsmfr: 400 bytes at 0x1afa6b8

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

      SQLNET.ora @ Client

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

      # SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora

      # Generated by Oracle configuration tools.

      #NAMES.DEFAULT_DOMAIN = bahrainyellowpages.com.bh

      SQLNET.AUTHENTICATION_SERVICES= (NONE)

      NAMES.DIRECTORY_PATH= (TNSNAMES)

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

      tnsnames.ora@Client

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

      OCCI =

        (DESCRIPTION =

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

          (CONNECT_DATA = (SID = ora9itgo))

        )

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

      Listener.log@server

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

      22-OCT-2013 16:32:44 * service_update * ora9itgo * 0

      22-OCT-2013 16:39:21 * (CONNECT_DATA=(SID=ora9itgo)(CID=(PROGRAM=C:\orant\BIN\ifrun60.EXE)(HOST=CC-EXEC-1)(USER=user))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.28)(PORT=55618)) * establish * ora9itgo * 0

      22-OCT-2013 16:42:47 * service_update * ora9itgo * 0

      22-OCT-2013 16:55:17 * ping * 0

      22-OCT-2013 16:58:10 * (CONNECT_DATA=(SID=ora9itgo)(CID=(PROGRAM=C:\orant\BIN\ifrun60.EXE)(HOST=CC-EXEC-1)(USER=user))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.28)(PORT=55906)) * establish * ora9itgo * 0

      22-OCT-2013 17:00:45 * (CONNECT_DATA=(SID=ora9itgo)(CID=(PROGRAM=C:\orant\BIN\ifrun60.EXE)(HOST=CC-EXEC-6)(USER=user))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=56691)) * establish * ora9itgo * 0

      22-OCT-2013 17:05:23 * (CONNECT_DATA=(SID=ora9itgo)(CID=(PROGRAM=C:\orant\BIN\ifrun60.EXE)(HOST=CC-EXEC-6)(USER=user))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.11)(PORT=56717)) * establish * ora9itgo * 0

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

      listener.ora@server

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

      (SID_DESC =

            (GLOBAL_DBNAME = ora9itgo)

            (ORACLE_HOME = C:\oracle\ora92)

            (SID_NAME = ora9itgo)

          )

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

      sqlnet.ora@server

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

      # SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora

      # Generated by Oracle configuration tools.

      #NAMES.DEFAULT_DOMAIN = bahrainyellowpages.com.bh

      #SQLNET.AUTHENTICATION_SERVICES=(NTS)

      SQLNET.AUTHENTICATION_SERVICES=(NONE)

      NAMES.DIRECTORY_PATH=(TNSNAMES,ONAMES,HOSTNAME)

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

      tnsnames.ora@server

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

      occi =

        (DESCRIPTION =

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

          (CONNECT_DATA = (SID = ora9itgo))

        )

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

      Please advise to overcome this issue. Thanks.

      Regards

      Sri.