oracle805?
用LSNRCTL80.EXE看看状态: status
也许你新挂得的sid没配好,给你个样本,手工改改listener.ora文件
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 4.0A
# Name..........:
# Date..........:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= hnm.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= hnm)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = 192.168.0.6)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = hnm)
(ORACLE_HOME = D:\orant805)
)
(SID_DESC =
(GLOBAL_DBNAME = thnm)
(ORACLE_HOME = D:\ORANT805)
(SID_NAME = thnm)
)
)
用LSNRCTL80.EXE看看状态: status
也许你新挂得的sid没配好,给你个样本,手工改改listener.ora文件
################
# Filename......: listener.ora
# Created.......: created by SAP AG, R/3 Rel. >= 4.0A
# Name..........:
# Date..........:
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL=IPC)
(KEY= hnm.WORLD)
)
(ADDRESS=
(PROTOCOL=IPC)
(KEY= hnm)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = 192.168.0.6)
(PORT = 1527)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(SID_NAME = hnm)
(ORACLE_HOME = D:\orant805)
)
(SID_DESC =
(GLOBAL_DBNAME = thnm)
(ORACLE_HOME = D:\ORANT805)
(SID_NAME = thnm)
)
)
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cgl)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
//-------------------------------------------------------
# TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORA8 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpha)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora8)
)
)ORA817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBMF80)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora817)
)
)IORA817 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.67.9.22)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora817)
)
)//---------------------------------------------------------
手工修改一下应该就行了!!!!