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.