oracle ORA-01940 报错的处理方法
删除用户时报错，提示有此用户的会话在连接。
SQL> drop user tran cascade;
drop user tran cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
查询会话信息，查询不到此用户的会话信息。
SQL> select * from v$session where username='ACCT';
no rows selected
判断有应用程序在连接此用户，关闭监听程序，并重启数据库。
[oracle@host149 bk]$ lsnrctl stop
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1358956536 bytes
Database Buffers 285212672 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
成功删除用户。
SQL> drop user tran cascade;
User dropped.
启动监听。
[oracle@host149 bk]$ lsnrctl start
SQL> drop user tran cascade;
drop user tran cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
查询会话信息，查询不到此用户的会话信息。
SQL> select * from v$session where username='ACCT';
no rows selected
[oracle@host149 bk]$ lsnrctl stop
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1358956536 bytes
Database Buffers 285212672 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
成功删除用户。
SQL> drop user tran cascade;
User dropped.
[oracle@host149 bk]$ lsnrctl start
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26506993/viewspace-1816331/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- MySQL执行语句报Incorrect key file for table '/tmp/#sql_.MYI'; try to repair it
- MySQL启动报错InnoDB: The innodb_system data file './ibdata1' is of a different
- Redis 5.02官方集群搭建
- MySQL报错Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.
- MySQL报错Slave: received end packet from server, apparent master shutdown
- MySQL 5.6因为OOM导致数据库重启
- Django报错ValueError: invalid literal for int() with base 10:
- MySQL 5.6复制报错Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;
- MySQL [ERROR] Slave I/O: Found a Gtid_log_event or Previous_gtids_log_event
- MySQL 5.6执行DDL报错ERROR 1050 (42S01): Table 'sms/#sql-ib752' already exist
