Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: not able to connect from developer 2000 to oracle

    Hi,

    I am having windows 98 loaded with oracle personal database version 8.0.3.0. I am able to connect from SQL plus using scott/tiger. I am not able to connect from forms [32 bit] version 5.0.5.4 using scott/tiger. My tnsnames.ora and sqlnet.log files are given below. Can you help me in finding the solutions for this problem.

    thanks and regards
    ps

    tnsnames.ora file is as follows

    Beq-local.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = BEQ)
    (PROGRAM = oracle80)
    (ARGV0 = oracle80ORCL)
    (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) ')
    )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
    )
    Tcp-loopback.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = 127.0.0.1)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
    )

    TcpExample.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)
    (Host = Production1)
    (Port = 1521)
    )
    )
    (CONNECT_DATA = (SID = SID1)
    )
    )
    SpxExample.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = SPX)
    (Service = Server_lsnr)
    )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
    )
    NmpExample.world =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = NMP)
    (Server = FinanceServer1)
    (Pipe = ORAPIPE)
    )
    )
    (CONNECT_DATA = (SID = ORCL)
    )
    )
    CMExample.world =
    (DESCRIPTION=(address_list=
    (ADDRESS=
    (PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER))
    (ADDRESS=
    (PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER)))
    (CONNECT_DATA=(SID=ORCL))
    (SOURCE_ROUTE=yes)
    )
    extproc_connection_data.world =
    (DESCRIPTION =
    (ADDRESS =
    (PROTOCOL = IPC)
    (KEY = ORCL)
    )
    (CONNECT_DATA = (SID = extproc)
    )
    )



    sqlnet.log file is as follows.

    ************************************************** *********************
    Fatal NI connect error 12547, connecting to:
    (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.0.3.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.3.0.1 - Production
    Time: 09-NOV-03 23:41:52
    Tracing not turned on.
    Tns error struct:
    nr err code: 0
    ns main err code: 12547
    TNS-12547: TNS:lost contact
    ns secondary err code: 12560
    nt main err code: 517
    TNS-00517: Lost contact
    nt secondary err code: 123
    nt OS err code: 0

  2. #2
    Join Date
    Sep 2003
    Posts
    4
    Install the Oracle Bequeath NT Protocol Adapter from the Oracle Forms CD-ROM. Everything else would be taken take off.

  3. #3
    Join Date
    Nov 2003
    Location
    Dhaka,Bangladesh
    Posts
    86

    Talking Solution of Connecting Developer with Oracle

    Hello Friend

    Firstly i suggest you to use Oracle on win2000 server/Xp for getting
    better. Any way just follow the step below to connect--

    Firstly find "tnsname.ora" file from your oracle home directory
    (like c:\oracle) then overwrite it in the Developer home directory
    where a same "tnsname.ora" exist. hope u enjoy!
    hello

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •