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.