Oracle EM FAQs

(1) After the Oracle Database Console is started, 1) The database instance has no information. 2) The Listener is in the unavailable state. 3) the proxy connection status to the instance is unavailable.

Problem analysis: the service has just started and is not yet in place

Solution: refresh the page later. 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, a problem occurs in the monitoring service.

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) For multi-nic, or ip address change, the console displays the following situation: 1) Listener TNS-12541: TNS: No listener 2) to the instance proxy connection ORA-12541: TNS: no listener (dbd error: OCIServerAttach)

Solution: Modify tnsnames under Network Configuration File: % 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 to refresh 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: the database instance may not be started;

Solution: Check whether the database instance service is started.

Tip: When you install Oracle10g on multiple NICs, you 'd better disable the network and then install it.