Re: Personal Oracle V8 and Developer 2000 V2
Date: 1998/03/11
Message-ID: <6e5u4p$or8_at_romeo.logica.co.uk>#1/1
I have managed to connect. What was wrong was that I didn't have the
listener
running. I assume you're working on a single
PC and trying to connect a local client (eg forms) to your instance of PO8
also
running locally. I've discovered that you can't do
this unless you've run the listener program. It is located in the oracle
home
directory (I don't know what you've called it - mine's
Orawin95) eg Orawin95 \Bin. You need to run LSNRCTL80.exe then type start at
the
command prompt. If your SQL*Net
easy config has been done properly then you should get a 'successful'
message
back. Note it may also be necessary to edit the
Listener.ora file in the C:\Orawin95\Net80\Admin directory to get the
listener
to work - I had to do this, you might be luckier.
Anyway, once the listener is running it should be possible to connect from
an
Oracle client to the database using the alias
specified in Easy Config. Be warned, however, that designer 2000 V2 does not
support the
new datatypes in PO8 such as LOBs or any
of the new PL/SQL features.
Cheers,
Hans Spek wrote in message
<889575243.5985.0.nnrp-07.c2de751d_at_news.demon.co.uk>...
>platform : PC Windows 95
>I down loaoded Personal Oracle V8 and Developer 2000 V2 from the internet
>for a trial period.
>I am able to connect sqlplus 8 to oracle however when I try to connect
forms
>(etc) to oracle I am getting the following error :
>
>___________________________________________________________________________
_
>_______________
>***********************************************************************
>Fatal OSN connect error 12154, connecting to:
> orcl
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
> Time: 10-MAR-98 23:50:26
> Tracing not turned on.
>***********************************************************************
>Fatal OSN connect error 12203, connecting to:
>
>(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=
o
>racle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CO
N
>NECT_DATA=(SID=ORCL)(CID=(PROGRAM=F50DES32.EXE)(HOST=DEFAULT)(USER=jhps))))
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
2.3.4.0.0 -
>Production
> Time: 10-MAR-98 23:51:49
> Tracing not turned on.
> Tns error struct:
> nr err code: 12203
> TNS-12203: TNS:unable to connect to destination
> ns main err code: 12560
> TNS-12560: TNS:protocol adapter error
> ns secondary err code: 0
> nt main err code: 0
> nt secondary err code: 0
> nt OS err code: 0
>
>__________________________________________________________
>
>Does anyone know about this
>
>Hans Spek
>jhps_at_demon.co.uk
>
>
Received on Wed Mar 11 1998 - 00:00:00 CET