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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: ORA-03115 (TOAD question!!)
Sorry, I must have been shooting from the hip. Not taking enough time to read more carefully. The LAST_HOME is likely being read by TOAD. Could be that TOAD stores the Oracle home it was last initialized with, compares it to the current on on subsequent startups, and tries to revert by using LAST_HOME. Take a look at any ini files or TOAD registry entries. Jared On Fri, 2003-08-01 at 02:09, Charu Joshi wrote: 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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
RE: ORA-03115 (TOAD question!!)
rant Man, I hope not. The complete reversal of the security in TOAD from deny all / grant some to grant all / deny some in 7.3 made maintenance a nightmare (we're stuck at v7.2 for this reason). Security granted by default is not security -- it's a welcome mat with the key tucked underneath. This problem has been compounded by the lack of version specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does. If it had this, I could use a logon trigger to weed out non-standard versions of TOAD on our production DBs. I'm not looking to hamper our devs, just help prevent them or TOAD from making happy accidents. So now, if the freeware version's updated, I'll have zero control over who uses what version of TOAD against our DBs. And if the freeware version is using the new and improved security-less model, it's an open door. I miss Toadman Jim... /rant Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
Where can we get a list of the bugs in freeware TOAD? Patrice. -Original Message- Sent: Thursday, July 31, 2003 10:50 AM To: Multiple recipients of list ORACLE-L rant Man, I hope not. The complete reversal of the security in TOAD from deny all / grant some to grant all / deny some in 7.3 made maintenance a nightmare (we're stuck at v7.2 for this reason). Security granted by default is not security -- it's a welcome mat with the key tucked underneath. This problem has been compounded by the lack of version specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does. If it had this, I could use a logon trigger to weed out non-standard versions of TOAD on our production DBs. I'm not looking to hamper our devs, just help prevent them or TOAD from making happy accidents. So now, if the freeware version's updated, I'll have zero control over who uses what version of TOAD against our DBs. And if the freeware version is using the new and improved security-less model, it's an open door. I miss Toadman Jim... /rant Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
http://www.toadsoft.com I still think that the freeware version is excellent, just lacking in some features found in v7. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 9:10 AM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) Where can we get a list of the bugs in freeware TOAD? Patrice. -Original Message- Sent: Thursday, July 31, 2003 10:50 AM To: Multiple recipients of list ORACLE-L rant Man, I hope not. The complete reversal of the security in TOAD from deny all / grant some to grant all / deny some in 7.3 made maintenance a nightmare (we're stuck at v7.2 for this reason). Security granted by default is not security -- it's a welcome mat with the key tucked underneath. This problem has been compounded by the lack of version specified in the call to DBMS_APPLICATION_INFO.SET_MODULE that TOAD does. If it had this, I could use a logon trigger to weed out non-standard versions of TOAD on our production DBs. I'm not looking to hamper our devs, just help prevent them or TOAD from making happy accidents. So now, if the freeware version's updated, I'll have zero control over who uses what version of TOAD against our DBs. And if the freeware version is using the new and improved security-less model, it's an open door. I miss Toadman Jim... /rant Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 6:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
Title: 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 tothe 8i HOME and restarted TOAD and was able to query CLOBs successfully. Thanks a lot!! Best wishes, Charu -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Tuesday, July 29, 2003 8:21 PMTo: Multiple recipients of list ORACLE-LSubject: 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 Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 -- -- Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] 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: [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.net -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
I believe I read on the TOAD list that they are working on a major upgrade to the free version of TOAD that will bring it up to the 7.5 code base. I think the target date was September... Dave -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 4:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: ORA-03115 (TOAD question!!) 7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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.net -- Author: INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
Title: 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 Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 29, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Subject: ORA-03115 (TOAD question!!) Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] 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: [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). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: ORA-03115 (TOAD question!!)
Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] 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: [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.net -- Author: AK INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
It's a TOAD issue. It's fixed in one of the v7.x versions. The current supported version is 7.5. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi INET: [EMAIL PROTECTED] 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: [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.net -- Author: AK INET: [EMAIL PROTECTED] 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: [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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] 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: [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: ORA-03115 (TOAD question!!)
7.6 is BETA. 7.5.2 is the current release. New betas appear frequently. Also, this version is not free. It's listed at just under $800 US. The freeware version is v6.x, which has the LOB bug, among a host of others. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-03115 (TOAD question!!) I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. 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. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [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).
