系统是64位win2003 server,oracle版本是10.2,安装有2个数据库实例:orcl、test,主机机器名serHost,所在域localnet。
配置文件没问题:sqlnet.ora里内容是“SQLNET.AUTHENTICATION_SERVICES = (NTS)”,
tnsnames.ora里内容是:
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serHost.localnet)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serHost.localnet)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)listener.ora里内容:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(SID_NAME = test)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = serHost.localnet)(PORT = 1521))
)
)
----------------------------------------------
下面是问题:有段时间使用正常,有一天突然就连不上了,数据库配置、网络配置都没变,数据库的业务量也没有大的变化,在服务器上连:
SQL> connect / as sysdba;
ERROR:
ORA-12560: TNS: 协议适配器错误在别的机器上用plsql连的时候报错:
ORA-12518: TNS: 监听程序无法分发客户机连接重启服务没用,重启服务器主机后恢复正常,但是使用几分钟后,又出同样的问题。这个问题几乎是没隔一段时间就会出现,求大虾指点Oracle
配置文件没问题:sqlnet.ora里内容是“SQLNET.AUTHENTICATION_SERVICES = (NTS)”,
tnsnames.ora里内容是:
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serHost.localnet)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serHost.localnet)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)listener.ora里内容:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(SID_NAME = test)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (PROTOCOL = TCP)(HOST = serHost.localnet)(PORT = 1521))
)
)
----------------------------------------------
下面是问题:有段时间使用正常,有一天突然就连不上了,数据库配置、网络配置都没变,数据库的业务量也没有大的变化,在服务器上连:
SQL> connect / as sysdba;
ERROR:
ORA-12560: TNS: 协议适配器错误在别的机器上用plsql连的时候报错:
ORA-12518: TNS: 监听程序无法分发客户机连接重启服务没用,重启服务器主机后恢复正常,但是使用几分钟后,又出同样的问题。这个问题几乎是没隔一段时间就会出现,求大虾指点Oracle
SQL> connect / as sysdba;
这个连接成功后,连接我的用户不行:
SQL> connect myuser/myuser@orcl
提示:
ORA-12637:包接收失败