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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Satya Prakash Viswanath [mailto:[EMAIL PROTECTED] > 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: [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: Satya Prakash Viswanath 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).