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

Several remarks
- I forgot to include the connect_data stuff around sid=orcl, sorry for that. Basically the entry should be identical to the tcp-loopback entry. - 1222 means you don't have the TCP/IP protocol installed. Can you verify that using the Oracle Installer?
- 12203. This is a weird problem. I have the 80 occurences replaced by 73 in my beq-local entry, and this DOES connect to an Oracle 8 database. Probably has been hardcoded in sqlnet 2.3

Hth,

Sybrand Bakker, Oracle DBA

N. Steffens <nsteffens_at_advantage.nl> wrote in message news:7p6ngf$ib6$1_at_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 - 15:54:59 CDT