Home » RDBMS Server » Server Administration » unable to drop user get ORA-00600 (ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [],)
unable to drop user get ORA-00600 [message #336112] Thu, 24 July 2008 18:37 Go to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
SQL> create user test identified by test;

User created.

SQL> drop user test;
drop user test
*
ERROR at line 1:
ORA-01001: invalid cursor
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [],
[], [], []


SQL>

Report message to a moderator

Re: unable to drop user get ORA-00600 [message #336113 is a reply to message #336112] Thu, 24 July 2008 18:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Subject: ORA-600 [qmxiUnpPacked2]
Doc ID: Note:222876.1
from http://metalink.oracle.com

Report message to a moderator

Re: unable to drop user get ORA-00600 [message #336116 is a reply to message #336112] Thu, 24 July 2008 19:57 Go to previous message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
actually the issue is now fixed only by removing the XDB as following

SQL> set echo on
SQL> spool xdb_removal.log
SQL> @?/rdbms/admin/catnoqm.sql


No more issues removing users

Thanks all

Maria

Report message to a moderator

Previous Topic: ORA-01667: cannot add any more tablespaces: limit of exceeded
Next Topic: 10gR2 on AIX - Table size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 08 23:34:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.