*********************************************************************************************************
# listener.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = orahosted01.srv.mst.edu)(PORT = 1521))
)
)
**********************************************************************************************************
# sqlnet.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
NAMES.DEFAULT_DOMAIN = eapac.ericsson.seSQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES, HOSTNAME, ONAMES)
*************************************************************************************************************
# tnsnames.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.SCSP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =orahosted01.srv.mst.edu)(PORT = 1521))
)
(CONNECT_DATA =
((SID = scsp)(SERVICE_NAME =scsp))
)
)
*************************************************************************************************************
三个文件如上,我在命令行中Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.C:\Users\xiao lu>tnsping scspTNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 25-NOV-2
009 08:49:38Copyright (c) 1997, 2007, Oracle. All rights reserved.Used parameter files:
C:\oracle\product\11.1.0\db_1\network\admin\sqlnet.oraTNS-03505: Failed to resolve nameC:\Users\xiao lu>lsnrctl status listenerLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 25-NOV-2009 09:30
:20Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orahosted01.srv.mst.edu)
(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error而且我的OracleOraDb11g_home1TNSListener服务打不开求教各位~~多谢
# listener.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = orahosted01.srv.mst.edu)(PORT = 1521))
)
)
**********************************************************************************************************
# sqlnet.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
NAMES.DEFAULT_DOMAIN = eapac.ericsson.seSQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (LDAP,TNSNAMES, HOSTNAME, ONAMES)
*************************************************************************************************************
# tnsnames.ora Network Configuration File: C:\oracle\product\11.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.SCSP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =orahosted01.srv.mst.edu)(PORT = 1521))
)
(CONNECT_DATA =
((SID = scsp)(SERVICE_NAME =scsp))
)
)
*************************************************************************************************************
三个文件如上,我在命令行中Microsoft Windows [Version 6.0.6001]
Copyright (c) 2006 Microsoft Corporation. All rights reserved.C:\Users\xiao lu>tnsping scspTNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 25-NOV-2
009 08:49:38Copyright (c) 1997, 2007, Oracle. All rights reserved.Used parameter files:
C:\oracle\product\11.1.0\db_1\network\admin\sqlnet.oraTNS-03505: Failed to resolve nameC:\Users\xiao lu>lsnrctl status listenerLSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 25-NOV-2009 09:30
:20Copyright (c) 1991, 2007, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orahosted01.srv.mst.edu)
(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
32-bit Windows Error: 1001: Unknown error而且我的OracleOraDb11g_home1TNSListener服务打不开求教各位~~多谢
请问你说的换成地址后,是指什么呀?