| 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: ORA-03115 (TOAD question!!)
Jared,
<Snip from my original post>
> However, I have set the
> default home to ORA_8i_HOME(which has Net8) using the 'Home
> Selector' utility. Also, TOAD is reading the TNSNames.Ora file
> from this home, so should be using Net8 rather than SQL*Net.
</Snip from my original post>
The question is, is it TOAD that uses the LAST_HOME entry, or is it Oracle itself? TOAD documentation suggests it's Oracle.
Reading LAST_HOME entry to decide which version of SQLNet to use just doesn't sound right (can't see any logic). I think DEFAULT_HOME setting should always be used. I read note Note:73963.1 regarding this but it doesn't mention this behaviour.
Maybe I will look for a higher version of TOAD and see how it goes.
Regards,
Charu.
-----Original Message-----
Behalf Of
Jared Still
Sent: Thursday, July 31, 2003 9:02 PM
To: Multiple recipients of list ORACLE-L
You may find it easier to just run the "Oracle Home Selector"
that appears in the Startup->Programs->Oracle Installation
Products
menu.
It has the benefit of also modifying the PATH variable.
Jared
On Thu, 2003-07-31 at 07:54, Charu Joshi wrote:
> RE: ORA-03115 (TOAD question!!)Hi,
>
> It worked!! As suggested by Raj, I browsed the TOAD help on
SQL*Net
> installation and found out this piece of information:
>
> **
> When Oracle connects, it will look in ALL_HOMES for the
"LAST_HOME" value,
> which in this case is zero "0". It appends zero to "HOME" to
produce
> "HOME0", then it looks in HKLM\Software\ORACLE\HOME0 for the
ORACLE_HOME
> value.
> **
>
> I modified the LAST_HOME key to point to the 8i HOME and
restarted TOAD and
> was able to query CLOBs successfully.
>
> Thanks a lot!!
>
> Best wishes,
> Charu
> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On
Behalf Of
> Jamadagni, Rajendra
> Sent: Tuesday, July 29, 2003 8:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORA-03115 (TOAD question!!)
>
>
> It is a TOAD question .... you need to read the sqlnet setup
section from
> help file. It is pretty detailed and will help you resolve the
problem.
>
> Raj
> --------------------------------------------------------------
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: jkstill_at_cybcon.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: Charu Joshi INET: joshic_at_mahindrabt.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 Fri Aug 01 2003 - 04:09:22 CDT
 |
 |