ITPub博客

查看oracle的锁的相关信息[@more@]查看锁的用户和等待锁的用户相关信息select 'blockers('||sb.sid||':'||sb.serial#||'-'||sb.username||')-'||qb.sql_text blockers,'waiters('||sw.sid||':'||sw.serial#||'-'||sw.username||')-'||qw.sql_text waitersfrom v$lock lb,v$lock lw,v$session sb,v$session sw,v$sql qb,v$sql qwwhere lb.sid=sb.sidand lw.sid=sw.sidand sb.prev_sql_addr=qb.addressand sw.sql_address=qw.addressand lb.id1=lw.id1and sb.lockwait is nulland sw.lockwait is not nulland lb.block=1;BLOCKERS

ORA-00101: invalid specification for system parameter MTS_DISPATCHERS[@more@]ORA-00101: invalid specification for system parameter MTS_DISPATCHERS这个问题是由于修改了主机名和IP地址以后，没有修改$ORACLE_HOME/network/admin/下面的listener.ora文件中的host地址引起的。修改一下listener.ora文件中的host地址即可LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521)) ) )