Re: Personal Oracle V8 and Developer 2000 V2

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