严青的Blog

摘要： 在liunx下启动oracle1.连接到liunx2.切换到oraclesu - oracle3.启动监听lsnrctl start 4.login到sqlplussqlplus /nolog5.连接conn /as sysdba6.启动数据库startup进入到sqlplus关闭数据库shutdown immediate退出sqlplusexit关闭监听lsnrctl stop 阅读全文

摘要： 1.查询被锁对象：select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o ,v$session swhere l.object_id　=　o.object_id and l.session_id=s.sid; 2.将查找的被锁会话结束：alter system kill session '130... 阅读全文