Re: 16 bit sqlplus cannot connect to PO8i

Rahul,
It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different "Homes" and you should be able to connect to the different DB's.

Hope it helps.

Luis Octavio

Rahul wrote:

> Jkstill,
> i'm using sql*net 2, and can connect to other 8i database
> on the AIX machine, but then i installed PO 805 (in another home) , and
> cannot use the sqlplus to connect to the local DB. (the sqlplus installed
> under
> the same home as the database can connect without problems)
>
> Regards
>
> PS: infact i did mention the platform and oracle version in my earlier mail
> also.
>
> > ----------
> > From: Jared Still[SMTP:jkstill_at_cybcon.com]
> > Reply To: ORACLE-L_at_fatcity.com
> > Sent: Tuesday, May 29, 2001 1:20 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: 16 bit sqlplus cannot connect to PO8i
> >
> > On Monday 28 May 2001 11:00, Kimberly Smith wrote:
> > > Hey Jraed,
> > > Why did you change your name? Sorry, I am bored. Management decided to
> > > move us around so I am unpacking.
> >
> > I should change it, as I find Jread much easier to type than Jared.
> >
> > Jraed
> >
> > >
> > > -----Original Message-----
> > > Sent: Monday, May 28, 2001 10:20 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > >
> > > If by "16 bit sqlplus" you mean version 1 of SqlNet, you
> > > can't connect to an 8i database with it.
> > >
> > > Some version numbers here would help.
> > >
> > > platform:
> > > version of platform:
> > > version of Oracle:
> > > etc...
> > >
> > > Jraed
> > >
> > > On Monday 28 May 2001 00:40, Rahul wrote:
> > > > List,
> > > > i'm trying to make a connect to 8i database (installed under orawin95)
> > > > from a 16 bit sqlplus (installed under orawin)
> > > >
> > > > i tried to configure the IPC in listener, the sqlplus in orawin95 is
> > able
> > > > to connect,
> > > > but the 16 bit sqlplus returns error...(cant get server error
> > > > message....)
> > > >
> > > > ----+-----+-----+-----+----+------ LISTENER.ORA
> > > >
> > > > LISTENER =
> > > > (ADDRESS_LIST =
> > > > (ADDRESS=
> > > > (PROTOCOL= IPC)
> > > > (KEY= oracle.world)
> > > > )
> > > > (ADDRESS=
> > > > (PROTOCOL= IPC)
> > > > (KEY= ORCL)
> > > > )
> > > > )
> > > > ----+-----+-----+-----+----+------ TNSNAMES.ORA
> > > > local.world =
> > > > (DESCRIPTION =
> > > > (ADDRESS_LIST =
> > > > (ADDRESS =
> > > > (PROTOCOL = BEQ)
> > > > (PROGRAM = oracle80)
> > > > (ARGV0 = oracle80ORCL)
> > > > (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
> > > > )
> > > > )
> > > > (CONNECT_DATA = (SID = ORCL)
> > > > )
> > > > )
> > > >
> > > > this is win95 and PO805
> > > >
> > > > TIA
> > > >
> > > > Regards
> > > > Rahul
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jared Still
> > INET: jkstill_at_cybcon.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue May 29 2001 - 09:02:35 CDT