Re: Oracle DBA's should know this problem... HELP!!!!!!!!

From: N. Steffens <nsteffens_at_advantage.nl>
Date: Sun, 15 Aug 1999 17:47:56 +0200
Message-ID: <7p6ngf$ib6$1@buty.wanadoo.nl>

It still ain't working....

When I'm connecting with scott/tiger_at_beq-local I get ORA-12203: TNS: Unable to connect to destination.

When I'm connecting with scott/tiger_at_oracle I get: ORA-12222: TNS: No such protocol adapter.

My TNSNAMES is as folowing:

# TNSNAMES.ORA Configuration file: D:\ORAWIN95\NET80\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

oracle.world =
(address = (host = 127.0.0.1) (port=1521) (sid=ORCL))

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

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
TcpExample.world =
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)

    )
    (CONNECT_DATA = (SID = SID1)
    )
  )
SpxExample.world =
  (DESCRIPTION =
    (ADDRESS =
(PROTOCOL = SPX)
(Service = Server_lsnr)

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )
NmpExample.world =
  (DESCRIPTION =
    (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)
    )
  )

It is in orawin95\net80\admin and also in orawin95\network\admin.

What am I doing wrong?
please help.
-----Oorspronkelijk bericht-----
Van: Sybrand Bakker <postmaster_at_sybrandb.demon.nl> Aan: N. Steffens <nsteffens_at_advantage.nl> Datum: zondag 15 augustus 1999 17:28
Onderwerp: Re: Oracle DBA's should know this problem... HELP!!!!!!!!

>Same problem here with Oracle 8 Server on a laptop . Not being a newbie, a
>quick investigation made , resolved the problem.
>Developer 2.1 doesn't seem to use net8, it uses sqlnet 2.3. The advice of
>copying tnsnames.ora is correct.
>However you need the following entry added
>oracle.world =
>(address = (host = 127.0.0.1) (port=1521) (sid=ORCL))
>
>If you have set up your hosts file correctly localhost instead of the
>hardcoded IP should also work.
>For future requests please submit the exact error message. Other people are
>willing to help you, but usually can't reproduce your problem.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>

Received on Sun Aug 15 1999 - 10:47:56 CDT