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:[EMAIL PROTECTED]] > > Reply To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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 subscr
RE: 16 bit sqlplus cannot connect to PO8i
Try using TCP protocol and then connect. I have connected so many times using the same. -- On Mon, 28 May 2001 19:45:54 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:[EMAIL PROTECTED]] >> Reply To:[EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] >> >> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 16 bit sqlplus cannot connect to PO8i
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:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: 16 bit sqlplus cannot connect to PO8i
Hey Jraed, Why did you change your name? Sorry, I am bored. Management decided to move us around so I am unpacking. -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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Kimberly Smith INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: 16 bit sqlplus cannot connect to PO8i
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).