以前都是好的。但是今天不知道怎么回事就无法登陆oracle了。tnsnames.oraENGDB01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ENGDB01)
)
)listener.ora# listener.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\client_1)
(PROGRAM = extproc)
)(SID_DESC =
(GOLBAL_DBNAME= ENGDB01)
(ORACLE_HOME = C:\oracle\product\10.2.0\client_1)
(SID_NAME=ENGDB01)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xx)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)请大家看看是什么原因?
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ENGDB01)
)
)listener.ora# listener.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\client_1)
(PROGRAM = extproc)
)(SID_DESC =
(GOLBAL_DBNAME= ENGDB01)
(ORACLE_HOME = C:\oracle\product\10.2.0\client_1)
(SID_NAME=ENGDB01)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xx)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)请大家看看是什么原因?
# SQLNET.ORA Network Configuration File: C:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.#SQLNET.AUTHENTICATION_SERVICES= (NTS)#NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)也就是在文字前加个#。试下看把。
tnsping ENGDB01
看看情况,是不是监听真的有问题,顺便也看看网络.ping 下子
C:\Documents and Settings\sz.ft>tnsping ENGDB01TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 16-SEP-2
009 16:09:56Copyright (c) 1997, 2005, Oracle. All rights reserved.Used parameter files:
C:\OraHome_1\network\admin\sqlnet.oraUsed HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=ENGDB01.cnsz.eems
.com))(ADDRESS=(PROTOCOL=TCP)(HOST=172.19.101.72)(PORT=1521)))
OK (70 msec)
win2003 重新启动系统就可以了。
其他系统如UNIX等,到网上搜下吧.