Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle DBA's should know this problem... HELP!!!!!!!!

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

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 17 Aug 1999 07:14:42 +0200
Message-ID: <934866903.24160.0.pluto.d4ee154e@news.demon.nl>


Make sure the following lines are set
in NET8's listener.ora (%ORACLE_HOME%\net80\admin\listener.ora) trace_level_listener = 16
trace_directory_listener = %ORACLE_HOME% (whatever is in your case) \net80\trace
in sqlnet 2.3's sqlnet.ora (ORACLE_HOME\network\admin) trace_level_client = 16
trace_directory_client = etc...
and post the associated trace files you get.

Hth,

Sybrand Bakker, Oracle DBA

N. Steffens <nsteffens_at_advantage.nl> wrote in message news:7p9s67$27nk$1_at_buty.wanadoo.nl...
> I keep getting the following errors when I try to start up
> tnslsnr80
>
> also when I try to do it through lsnrctl80> START
>
> Errors:
> TNS-12560: TNS: protocol adapter error
> TNS-00530: protocol adapter error
> 32-bit windows error: 50: Unknown system error.
>
> I have TCP-IP protocol installed (there were 2 on my Oracle 8 cd)
>
> TCP-ip 2.xxxxx and TCP 8.xxxx
>
> tried both... but nothing working.......
>
> Please help!!!!
>
>
> Rao Ramineni heeft geschreven in bericht
> <37B8629A.F7A75180_at_alliedtours.com>...
> >We had similar problems when we tried to use Developer/2000 with Oracle
> 8.x.
> >
> >For some reason (known to Oracle only) Developer/2000 uses sqlnet 2.3
where
> as
> >Oracle
> >8.x uses Net8 as the standard mechanism to connect to database.
> >
> >Resolve this as follows.
> >
> >1. copy "TNSNAMES.ORA" file to orawin95\network\admin\ directory.
> >
> >2. Configure listener process of Net 8 by specifying the configuration
> >information
> > in orawin95\net8\admin\listener.ora file.
> >
> >3. Start listener program by executing tnslsnr80.
> >
> >Now you should be able to connect to the Database if your tnsnames.ora
file
> >specifies
> >the correct connect-string, protocol, and Database SID.
> >
> >
> >
> >"N. Steffens" wrote:
> >
> >> I sure hope someone can help me (and some
> >> others for I have seen that more (newbe's) have the same problem.
> >>
> >> I have: Personal Oracle 8 & Developer 2.1 installed.... It all installs
> >> great without any problem.
> >>
> >> PLSQL works great with standard SCOTT/TIGER uid.
> >> But when I tried to start up Forms builder it just doesn't connect to
my
> >> standard Oracle DB.
> >>
> >> I have copied my TNSNAMES from orawin95\net80\admin to
> >> orawin95\network\admin (at advice from someone) but that still doesn't
> help.
> >>
> >> I tried TNSPING to BEQ-LOCAL but it also gives an error while TNSPING80
> >> BEQ-LOCAL works great.
> >>
> >> Can U please help me?
> >> I've tried it on both WIN 98 and WIN 95..
> >>
> >> thanks in advance,
> >>
> >> Niels Steffens.
> >
>
>
Received on Tue Aug 17 1999 - 00:14:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US