Summary of Oracle10g listener

Source: Internet
Author: User


Summary of Oracle10g listener there are many reasons why Oracle 10g listener cannot be started. In this article, we will summarize the causes for listener failure, next let's take a look at this part. 1. ora-01034: Oracle not available, ora-27101: shared mermory realm does not exist. solution: www.2cto.com Method 1: 1. input: connect/as sysdba; 2. restart the computer. Method 2: Enter the following command in the command line: 1. c:> svrmgrl 2. oracle Server Manager Release 3.1.7.0.0-Production 3. copyright (c) 2000, Oracle Corporation. tbAll Rights Reserved. 4. oracle8i Enterprise Edition Release 8.1.7.0.0-Production 5. with the Partitioning o Ption 6. JServer Release 8.1.7.0.0-Production 7. www.2cto.com 8. SVRMGR> connect internal/oracle 9. The connection is successful. Www.2cto.com 10. 11. SVRMGR> startup 12. It should be okay to connect to the database again. 2. Oracle Listener cannot be started suddenly, and the error code is 1067. Solution: Enter dos input lsnrctl start to wait for the display result. My results are as follows: start tnslsnr: Please wait... TNSLSNR for 32-bit Windows: Version 9.2.0.1.0-Production the system parameter file is E: oracleora92networkadminlistener. ora writes E: oracleora92networkloglistener. an error occurred while listening to the object with log information: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 123.118.1.39) (PORT = 1521 ))). TNS-12545: the connection failed because the target host or object does not exist. TNS-12560: TNS: protocol adapter error. TNS-00515: the connection failed because the target host or object does not exist. 32-bit Windows Error: 49: Unknown error. The Listener failed to start. See the error message above... Www.2cto.com. Method 1: the IP address can be modified. Method 2: modify the configuration of the E: oracleora92networkadminlistener. ora file. 3. The AGENT service cannot be started. You can delete the files in the networkagent directory. Q,. ver and other files, and then re-agentctl start. If sqlnet. ora is incorrect, check the content of sqlnet. ora. 1. # SQLNET. ORA Network Configuration file: D: oracleora92networkadminsqlnet. ora 2. # Generated by Oracle configuration tools. 3. SQLNET. AUTHENTICATION_SERVICES = (ETS) 4. NAMES. DIRECTORY_PATH = (TNSNAMES, ONAMES, HOSTNAME) sqlnet. ora name 1. # NAMES. PREFERRED_SERVERS = www.2cto.com 2. # (ADDRESS_LIST = 3. # (ADDRESS = (PROTOCOL = TCP) (HOST = MICROSOF-3D9384) (PORT = 1575) 4. #) 4. oracle http Server cannot start the site that uses port 80 in IIS, or you can change the Http Server port of Oracle. Here is a summary of the error solution that Oracle 10g listening listener cannot be started. I hope this introduction will be helpful to you!
 

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.