之前发过一个帖:http://topic.csdn.net/u/20100630/14/775905d7-0eaf-4ebe-93f0-1af0fb66776d.html
SQL> drop user user1 cascade;
Warning: connection was lost and re-established
User dropped --但是用户没有被删除--再次删除用户
SQL> drop user user1 cascade;
drop user user1 cascade
*
第 1 行出现错误:
ORA-00600: 内部错误代码,参数: [1236], [], [], [], [], [], [], []--再次使用用户登录时出现:
ORA-12516: TNS:监听程序找不到符合协议堆栈要求的可用处理程序--查询表时也出错
SQL> select * from dual;
select * from dual
*
第 1 行出现错误:
ORA-00600: 内部错误代码,参数: [1236], [], [], [], [], [], [], []
大家知道解决的方法吗?
SQL> drop user user1 cascade;
Warning: connection was lost and re-established
User dropped --但是用户没有被删除--再次删除用户
SQL> drop user user1 cascade;
drop user user1 cascade
*
第 1 行出现错误:
ORA-00600: 内部错误代码,参数: [1236], [], [], [], [], [], [], []--再次使用用户登录时出现:
ORA-12516: TNS:监听程序找不到符合协议堆栈要求的可用处理程序--查询表时也出错
SQL> select * from dual;
select * from dual
*
第 1 行出现错误:
ORA-00600: 内部错误代码,参数: [1236], [], [], [], [], [], [], []
大家知道解决的方法吗?
试试:
1)SQL> shutdown immediate
2)SQL> startup migrate
3)SQL> spool patch.log
4)SQL> @?/rdbms/admin/catpatch
5)SQL> spool off
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
Warning: connection was lost and re-established
User dropped --但是用户没有被删除
???都提示用户删除了啊,怎么会没有删除?
[email protected]
出现:User dropped
但是菜单栏也出现了:commit和rollback.
不管是选择commit还是rollback。都会出现上面的ORA-00600错误信息。
听说刷共享池可以解决!
请教:怎么刷共享池呢? 数据库版本是:oracle92