Tnsping server exception
For example, tnsping intel
C: \> tnsping intel
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0-Production on August 16-2
012 15:37:27
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
D: \ oracle \ ora92 \ network \ admin \ sqlnet. ora
TNS-03505: Unable to determine name
A) check whether the configuration of tnsnames. ora (% ORACLE_HOME % \ oracle \ network \ admin \ tnsnames. ora) is correct. INTEL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.161.8.100) (PORT = 1526 ))
)
(CONNECT_DATA =
(SERVICE_NAME = intel)
)
)
B) if it is correct, ping 10.161.8.100 to confirm that the network is correct.
C) if the network is smooth, log on to the server (telnet 10.161.8.100) and check whether the listener is enabled.
Intel </data> $ lsnrctl status
LSNRCTL for Linux: Version 8.1.6.0.0-Production on 08-DEC-2004 15:43:47
(D) Copyright 1998,199 9, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC )))
TNS-01103: Protocol specific component of the address is incorrectly specified
TNS-12541: TNS: no listener
TNS-12560: TNS: protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Apparently, this listener has been disabled.
Display listening status: intel </data> $ lsnrctl status
Enable listening command: intel </data> $ lsnrctl start
Disable listening command: intel </data> $ lsnrctl stop
(E) Enable the listening command: intel </data> $ lsnrctl start does not work after listening.
The system parameter file is D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ admin \ listener. ora.
Write the log information of D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ log \ listener. log
Write trace information for D: \ oracle \ product \ 10.2.0 \ db_1 \ network \ trace \ listener. trc
I found that there were not many problems.
(F) I finally found that my local DB server is 9i, but it uses 8i sqlplus.
Suggestion: when installing ORACLE, there will be an SQL plus tool that comes with it, so that it will not take as many detours as I do.