RE: Problem with TOAD is solved !!

From: Satya Prakash Viswanath <SatyaPrakash_V_at_infosys.com>
Date: Tue, 03 Jun 2003 09:59:44 -0800
Message-ID: <F001.005A925A.20030603095944@fatcity.com>

Hi List !

        My problem with TOAD was fixed.I do not call it great. Solution Obtained:
1. Reverted back to TOAD 7.2 (IT still did not work even though I was able to connect thru SQL *PLUS)
2. I took a back-up of my database and ran the catexp.sql script. I got a few warnings but all my data dictionary objects were re-created. 3. I am able to connect to my 9.2 db thru TOAD !!

Thanks one and all!

Regards,
Satya Prakash

-----Original Message-----
Sent: Thursday, May 29, 2003 8:16 PM
To: Multiple recipients of list ORACLE-L

You will want to repost this to toad_at_yahoogroups.com Many users as well as the TOAD development team are on this list.

Or, since it's v7.3, you've obviously purchased TOAD (right?!?) and could try http://www.quest.com/support/

HTH! GL! Rich

Rich Jesse                        System/Database Administrator
rich.jesse_at_qtiworld.com           Quad/Tech International, Sussex, WI

USA
> -----Original Message-----
> From: Satya Prakash Viswanath [mailto:SatyaPrakash_V_at_infosys.com]
> Sent: Wednesday, May 28, 2003 11:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Problem with TOAD
>
>
> Hi List,
>
> I am facing a strange problem with TOAD (ver 7.3.0.0).
>
> I am not able to log onto my Oracle database server ( 9.2.0.1.0) thru
> TOAD. I am getting "ORA-00980: synonym translation is no longer
> valid". I do not know how this correlates with this error while
> connecting. I am
> able to connect to any other database thru TOAD.
> I am able to connect to my database using SQL* PLUS but my
> comfort level
> with TOAD is high that I do not want to revert to SQL * PLUS. ;)
>
> The things that I will list out are :
> 1. Tried running the TOADPREP.sql from SQL*PLUS. The script goes thru
> fine without any problems. 2. Nothing has happnened to my PC/Database
> since the last time I logged
> in to my machine. Very normal behavior.
> 3. I can desribe all my toad specific tables from SQL* PLUS.
> 4. The strange thing now (after running TOADPREP.sql) is that i can
> access all user tables but not dba tables(dynamic performance views)
> 5. Stopped and restarted the servies but to no effect
> 6. Even reinstalled TOAD but to no effect.
> 7. I have checked the trace files, seems fine to me.
>
> Even though this issue is specific to TOAD, plz help me on this.
> I am in touch with the support also but I cannot wait for 1 day for
> their reply.
> Any pointers?
>
> Regards,
> Satya Prakash

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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: Satya Prakash Viswanath
  INET: SatyaPrakash_V_at_infosys.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 Tue Jun 03 2003 - 12:59:44 CDT