Solutions to Em-related problems in Oracle 10 GB (repost)

Source: Internet
Author: User
Solutions to Em-related problems in Oracle 10 GB

The EM in Oracle 10 Gb adopts the web form to manage databases and related services. However, some em-related problems may occur during use. Based on the prompts from the peers and the actual experience of the author, I have summarized some ideas and hope to help related fans:
(1) After the Database Console is started, 1) The database instance has no information. 2) Listen. Program Status: unavailable 3) the proxy connection status to the instance is unavailable.
Problem Analysis:
At this time, the Service has just started and is not yet in place
Solution:
Will refresh again. At this point you may see 1) The database instance has related information 2) the listener has information but the status is closed 3) the proxy connection to the instance status is failed and the prompt ORA-12541: TNS: no listener (DBD error: ociserverattach ). The cause may be that the listening service is not started.
(2) Io exception: the network adapter cocould not establish the connection
Problem Analysis:
When the IP address or computer name is changed, the listening service is generally faulty.
Solution:
Step 1: Use the emca-config dbcontrol dB command to configure the EM Database Control;
Step 2: Enter http: // oracl_hostname: 5500/EM/(port 5500 instead of port 1158) in IE to check whether the server is running normally. If the server is abnormal, then, solve the problem according to the solution (3.
(3) When multiple NICs or IP addresses are changed, the console displays the following situations:
1) listening program TNS-12541: TNS: no listening program
2) proxy connection to instance ORA-12541: TNS: No listener (DBD error: ociserverattach)
Solution:
Modify network configuration file: tnsnames under % ORACLE_HOME % \ Network \ admin. ora and listener. ora, change the host name or IP address after host = to the current host name or IP address, and restart the listening service. Then refresh the console page and you will see that the listener has started, but the following prompt may appear: ORA-12505: TNS: The Listener currently cannot recognize the SID (DBD error: ociserverattach) ", it doesn't matter. Refresh several times to see the successful proxy connection information of the instance.
(4) Java. Lang. Exception: ioexception in sending request: Connection refused: connect
Problem Analysis:
It is common when refreshing on the console. The reason is unknown and it seems that there is no impact.
Solution:
Cold Processing (^_^ ).
(5) Listener refused the connection with the following error: ORA-12514, TNS: Listener does not currently know of Service requested in connect descriptor the connection descriptor used by the client was: (description = (address_list = (address = (Protocol = TCP) (host = lhl) (Port = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl )))
Problem Analysis:
It may be that the database instance is not started;
Solution:
Check whether the database instance service is started.
Tip: when installing Oracle 10 GB on multiple Nic machines, it is best to disable the network and then install it.

 

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.