Re: SQLNET/Developer 2000 (was Re: Getting this error with Oracle 8)

Thanks. I finally got Developer 2000 connected with my loacl Oracle 8 database by starting the listener. This brings up another problem.

I could only connect to my local Oracle 8 database if I am physically connected to a network It appears that the listener uses the TCP protocol to locate the oracle database which is on the same machine as Developer 2000. When I disconnect from the network (I am using a Thinkpad) the listener is unable to locate the database and thus I am unable to connect.

SQL Plus 8.0 seems to recognize the local database without the listener running or a TNSNAMEs file. How do I configure SQL PLUS 3.3 and Developer 2000 to do the same ?

Joe Brown wrote:

> Older Developer 2000 doesn't understand Net8. That's why Oracle
> includes both Net8 & SQLNET 2.3.4 with the database.
> If you havn't installed SQLNET 2.3.4, or even if you have, you may
> need to configure the SQLNET 2.3.4 Listener.ORA and TNSNAMES.ORA on
> the local machine to locate the instance.
>
> I had difficulty getting the SQLNET2.3.4 listener working after
> install.
>
> BTW: Unless you use different ports for the two listeners, you'll have
> to stop TNSListener80, before starting TNSListener.
>
> Aside from being able to use Dev/Discover 2000, the SQLNET2.3.4
> version uses about 3-4 megs less memory. But I bet you loose object
> capabilities.
>
> Jason Lee <jason.lee_at_hnet.moh.bc.ca> wrote:
>
> > zhrem_at_my-dejanews.com wrote:
> >
> > > In article <35DE51BD.42FA3858_at_centtel.com>,
> > > lpgao_at_cheerful.com wrote:
> > > > Hi,
> > > > Anybody knows what are the default username, password, database or server(ces)
> > > > name when first start Oracle dev200 after installed?
> > > > I can not use some components of dev2000 because I was always asked to enter
 there
> > > > stuff. But how can I know them? even Oracle documents never mention it.
> > > > what benefits and features are if they can not be started?
> > > >
> > > >
> > >
> > > For security reason, Oracle uses user names and passwords. database is where
> > > you can connect and process data.
> > >
> > > Ask your DBA for a user name /password and a database name you can use.
> > >
> > > J.Z. Zhang
> > > Oracle Certified DBA
> > > E-mail: ccev20_at_nus.edu.sg
> > >
> >
> > I am having a similar problem.
> >
> > I installed PO8 on my Win95 machine along with Designer 2000. When using SQL Plus
> > 8.0 I am able to log onto the PO8 database, but, I am unable to do so with SQL Plus
> > 3.3 or Designer 2000. However, I am able to access a remote database (Oracle 7.3)
> > via all three methods (SQL Plus 8, 3.3 and Designer). Why can't I access my local
> > PO8 database with Designer 2000? (I've tried configuring SQL*Net and NET8 to no
> > avail).
> >
> > Thanks in advance,
> >
>
> --
> joebrown
> _at_leading.net
Received on Fri Sep 18 1998 - 00:00:00 CEST