TNS-03505: Unable to determine name

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.