我把listener.ora里面的改为ip地址了,tns里面也改了,不知道现在怎么数据库就起不来的,报错是this listener supports no services,不知道是什么原因呢?
数据库我用sqlplus /nolog是可以连的
做一个trigger包含 after logon on database begin execute immediate 'alter session set events ''10046 trace name context forever, level 10'''; end;可以看看追踪停到哪里,哪些不正常
增加
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = 服务名)
(SID_NAME = 服务名)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0)
)
)
after logon on database
begin
execute immediate 'alter session set events ''10046 trace name context forever, level 10''';
end;可以看看追踪停到哪里,哪些不正常