SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Uninstall doesn't work - any ideas?

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Uninstall doesn't work - any ideas?
Author Message
KrankerAffe



Joined: 02 May 2007
Posts: 1
Country: United Kingdom

Post Uninstall doesn't work - any ideas? Reply with quote
Hi - I read the manual regarding uninstallation, and followed the instructions to run Uninstall.sql. However I get a bumch of errors. Does anyone have any ideas?

I'm not a DB wizard - hence exploring the application. I am logged into DB using Oracle SQLDeveloper as sysadm, the Db version is 10G. I am running it on my laptop.

The DBMonitor job is lkilling my laptop, which is my main reason to uninstall.


Error starting at line 15 in command:
DROP USER ora_monitor CASCADE
Error report:
SQL Error: ORA-01940: cannot drop a user that is currently connected



Error starting at line 16 in command:
DROP PUBLIC SYNONYM db_alert
Error report:
SQL Error: ORA-01432: public synonym to be dropped does not exist




Error starting at line 20 in command:
EXECUTE DBMS_IJOB.DROP_USER_JOBS('ORA_MONITOR');
Error report:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_IJOB.DROP_USER_JOBS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored




Error starting at line 23 in command:
{
Error report:
Unknown Command


Error starting at line 24 in command:
FOR rec IN (SELECT job FROM sys.dba_jobs WHERE upper(what) LIKE 'ORA_MONITOR.%') LOOP
Error report:
Unknown Command


Error starting at line 25 in command:
DBMS_JOB.BROKEN(rec.job, TRUE, SYSDATE);
Error report:
Unknown Command


Error starting at line 26 in command:
END LOOP;
Error report:
Unknown Command


Error starting at line 27 in command:
}
Error report:
Unknown Command



Many thanks
Wed May 02, 2007 8:46 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
As the first error suggests, you have an active ORA_MONITOR connection. Please find out who is using it and close it, then run
DROP USER ora_monitor CASCADE

Make sure you connect to the database as SYS when executing this command, and last if you are going to do this from SQL*Plus or other non-DB Tools editor, don't use {} brackets around PL/SQL blocks, paste the entire block beginning with "DECLARE" and ending with "END;" to the SQL*Plus then enter / on a new line and then press the enter key.
Wed May 02, 2007 9:29 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.