EM Problems in Oracle 10g/11g

Oracle 10g In EM Use Web To manage databases and related services. However EM Based on the prompts from colleagues and the actual experience of the author, I have summarized the relevant questions and hope to help related fans:    ( 1 ) After the Database Console is started, you can see 1 ) The database instance has no information. 2 The listener is in the unavailable status. 3 ) The proxy connection status to the instance is unavailable.Problem Analysis: At this time, the Service has just started and there is no solution in place:Will refresh again. 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 is failed, and a prompt is displayed.ORA-12541: TNS:No listener (Dbd error: OCIServerAttach ). The cause may be that the listening service is not started.( 2 ) IoException : The Network Adapter cocould not establish the connection Problem Analysis: Changing Ip Or the computer name. Generally, the listening service has a problem. Solution: Step 1: Use Emca-config dbcontrol db Configure the command again Em Of Database control ; Step 2: Ie Input Http: // effecl_hostname: 5500/em/ (Yes 5500 Port instead 1158 Port) to see if it is running normally, if it is not normal, then press the problem ( 3 .( 3 ) For multiple NICs, or change Ip The console displays the following situations :!!! (I have encountered this kind of situation. The version is 11 GB and the error can be solved with reference to the solution)1) ListenerTNS-12541: TNS:No listener2) proxy connection to the instanceORA-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 been started, but the following prompt may appear:ORA-12505: TNS:The listener cannot identify 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 ( Pai_^ ).( 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:ViewWhether the database instance service is started.

Tip: Install on multiple NICs Oracle 10g It is best to first disable the network and then install.