Six connection problems and solutions for Oracle listeners

Source: Internet
Author: User
Tags dedicated server

Many users encounter Oracle listening configuration problems when learning Oracle databases. The Client cannot connect to the Server ). This article briefly introduces the Oracle listener configuration and provides some solutions for the failure of client terminals to connect to the server.

1. Oracle LISTENER (LISTENER)

Oracle listener is a server-based network service of Oracle. It is mainly used to listen for connection requests from clients to database servers. Since it is a server-based service, it only exists on the database server, and Oracle listener settings are also completed on the database server.

2. Local Service name (Tnsname)

The connection between the Oracle client and the server is a connection request sent by the client. The Oracle listener of the server checks the client connection request validity. If the connection request is valid, the connection is performed. Otherwise, the connection is rejected. The local service name is a type of network configuration for the Oracle client, as well as the Oracle Names Server. The common client configuration in Oracle is the local service name. This article describes the configuration based on the local service name.

Iii. Common connection problems

To eliminate the connection problem between the client and the server, first check whether the client configuration is correct (the client configuration must be consistent with the database server listening configuration), and then solve the problem according to the error prompt.

1. ORA-12541: TNS: no Oracle listener
Obviously, the server listener is not started, and check whether the client IP address or port is entered correctly. Start listener: $ lsnrctl start or C: \ lsnrctl start

2. ORA-12500: TNS: Oracle listeners cannot start dedicated server processes
For Windows, the Oracle instance service is not started. Start the instance service: C: \ oradim-startup-sid myoracle

3. ORA-12535: TNS: Operation timeout
There are many reasons for this problem, but it is mainly related to the network. To solve this problem, first check whether the network between the client and the server is smooth. If the network is connected, check whether the firewalls at both ends have blocked the connection.

4. ORA-12154: TNS: unable to process service name
Check whether the entered service name is consistent with the configured service name. In addition, pay attention to the generated local service name file (for example, D: \ oracle \ ora92 \ network \ admin \ tnsnames in Windows. ora, $ ORACLE_HOME/network/admin/tnsnames in Linux/Unix. the name of the first line of each service in ora cannot contain spaces.

5. ORA-12514: TNS: Oracle listening process cannot parse SERVICE_NAME given in the connection Descriptor
Open Net Manager, select the service name, and check whether the service name entered in the service ID column is correct. The service name must be consistent with the global database name configured for the server-side Oracle listener.

6. If the Oracle listening service is started in Windows, the system prompts that the path cannot be found.
The path cannot be found when a command is run or the listener is started in the service window, or an exception occurs when the Oracle listening service is started. Open the registry and enter HKEY_LOCAL_MACHINE/SYSTEM/Current.
ControlSet/Services/OracleOraHome92TNSListener to check whether the ImagePath string exists. If not, set the value to D: \ oracle \ ora92 \ BIN \ TNSLSNR, change the installation path values accordingly. This method is also applicable to Oracle instance Services. Same as above, find items like HKEY_LOCAL_MACHINE/SYSTEM/Current ControlSet/Services/Oracle ServiceMYORACLE to check whether the ImagePath string item exists. If not, create a new one, set the value to d: \ oracle \ ora92 \ binORACLE. exe myoracle.

The above are some common problems for Oracle clients to connect to the server. Of course, it cannot cover all connection exceptions. The key to solving the problem lies in the methods and ideas, rather than having fixed answers to each question.

  1. How to install and configure Oracle listeners
  2. Explore how to collect Oracle listener log files
  3. Oracle listener, let you listen to what you want
  4. 11 tips for protecting RHEL4 Oracle listeners
  5. Analysis of Oracle listener installation and configuration

Related Article

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.