| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Not able to connect to database
When you installed the 8i client, you selected an Oracle_Home. From the START button, go to PROGRAMS. From there, find the "Oracle Home Selector". This will give you a list of the current Oracle_Homes on your computer. Find the oracle_home that you used to install the 8i client and note what position it is in the list (1st, 2nd, 3rd, etc.). Then start TOAD. On the logon screen click the SQL-NET help. This will pop up a list of Oracle_homes named HOME0, HOME1 etc. Pick the same position as the oracle_home that you noted earlier (ignore the Oracle Root) and change TOAD to that oracle_home.
That should work. If not, try the various oracle-homes until one does work.
HTH
<rgaffuri
@cox.net> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent by: root cc:
Subject: Re: Re: Not able to connect to database
04/21/2003 01:42
PM
Please respond
to ORACLE-L
how do I set it then?
>
> From: "Thomas Day" <tday6_at_csc.com>
> Date: 2003/04/21 Mon PM 12:51:57 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: Re: Not able to connect to database
>
>
> All I can say is that you're not using the Oracle_Home that you think you
> are. On a Win box there is not just one Oracle_Home variable that is
set.
> Each client or application will have it's own Oracle_Home that it will
use,
> regardless of the registry settings.
>
>
>
>
> This is a PRIVATE message. If you are not the intended recipient, please
> delete without copying and kindly advise us by e-mail of the mistake in
> delivery. NOTE: Regardless of content, this e-mail shall not operate to
> bind CSC to any order or other contract unless pursuant to explicit
written
> agreement or government initiative expressly permitting the use of e-mail
> for such purpose.
>
>
>
>
>
>
> <rgaffuri
> @cox.net> To: Multiple
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent by: root cc:
> Subject: Re: Re: Not able
to connect to database
>
> 04/21/2003 12:12
> PM
> Please respond
> to ORACLE-L
>
>
>
>
>
>
> did that and I installed the ORacle 8i client properly. I am now getting:
>
> my oci.dll is in the bin directory and I set the Toad home directory
> properly. Any idea?
>
> Initialization error
> Could not locate OCI dll
>
> building Oracle HOMES List
> HOME Name OraHome81 added to list.
> Found multiple homes, searching each HOMEx for valid PATH
> searching in SOFTWARE\ORACLE\HOME0
> Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!
> Unloading previous Oracle DLL
> >
> > From: "Thomas Day" <tday6_at_csc.com>
> > Date: 2003/04/21 Mon AM 10:07:01 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: Re: Not able to connect to database
> >
> >
> > Check to see which Oracle home your TOAD is using. You can check it
and
> > change it from TOAD. When TOAD pops up it's logon screen, click on the
> > SQL-NET Help.
> >
> >
> >
>
>
> >
> > This is a PRIVATE message. If you are not the intended recipient,
please
> > delete without copying and kindly advise us by e-mail of the mistake in
> > delivery. NOTE: Regardless of content, this e-mail shall not operate to
> > bind CSC to any order or other contract unless pursuant to explicit
> written
> > agreement or government initiative expressly permitting the use of
e-mail
> > for such purpose.
> >
>
>
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Thomas Day
> > INET: tday6_at_csc.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: Thomas Day
> INET: tday6_at_csc.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net -- Author: <rgaffuri_at_cox.net INET: rgaffuri_at_cox.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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.net -- Author: Thomas Day INET: tday6_at_csc.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Mon Apr 21 2003 - 13:11:43 CDT
 |
 |