(GO) Oracle Boot listener "Listener does not support service" resolution

Transfer from http://www.51testing.com/html/99/478599-842622.html

Today, after the installation of Oracle , start monitoring, error is as follows:

Start Tnslsnr: Please wait ... Tnslsnr for 32-bit Windows: Version 10.2.0.1.0-production writes to E:\oracle\product\10.2.0\db_2\network\log\listener.log LogInformation monitoring: (Description= (Address= (protocol=tcp) (host=win2003-64template) (port=1521)))Connecting to (address= (PROTOCOL=TCP) (host=) (port=1521))the STATUS of LISTENER------------------------alias LISTENERversion Tnslsnr for 32-bit windows:version 10.2.0.1.0-productionStart date 2 May-March -2013 14:30:30uptime 0 days 0 hours 0 minutes 1 secondsTrace level offSecurity on:local OS authenticationSNMP OFFListener log file E:\oracle\product\10.2.0\db_2\network\log\listener.logListener Endpoint Summary ...(description= (address= (protocol=tcp) (host=win2003-64template) (port=1521)))Listener does not support servicecommand execution succeededThe Service report listener does not support the service, then focus on the Listener.ora file. Listener.ora is an Oracle server-side network configuration file that Oracle is equipped with for monitoring services. It accepts remote pairs of Databaseand forwarded to Oracle for the service process. The possible cause of this problem is that the configuration is not added to the file. So I checked the E:\oracle\product\10.2.0\db_2\network\Admin.folder and found sure that there are no Listener.ora files. Have I stumbled into a new local net configuration without creating a listening file? No matter 3,721, plusListener.ora. Add the following content, which is the same as the content of the new listener file through Net Configuration Assistant:Sid_list_listener =(sid_list =(Sid_desc =(sid_name = plsextproc)(oracle_home = E:\oracle\product\10.2.0\db_2)(program = extproc)    )  ) LISTENER =(description_list =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = win2003-64template) (PORT = 1521))(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))    )  )By the Way, reviewThe role of Listener.ora:in this file, we typically see two parameters1) Parameter LISTENER defines the listening protocol address of the listener "LISTENER" (Listening protocol addresses)format Examples:LISTENER =(description_list =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))(ADDRESS = (PROTOCOL = TCP) (HOST = china-e24ea7c0a) (PORT = 1521))    )  ) 2) parameter sid_list_listener is used to provide service information that can be statically supported by the listener "LISTENER". Also, this parameter is necessary if you use EM (Oracle Enterprise Manager) to manage the database.  format Examples:Sid_list_listener =(sid_list =(Sid_desc =(sid_name = plsextproc)(oracle_home = c:\oracle\product\10.2.0\db_1)(program = extproc)    )  )As seen above, Plsextproc,plsextproc is not an Oracle instance, which is the meaning of PL/SQL external procdure, which is to invoke external statements in PL/SQL, such as the C,java write process. This inside configuration is to let the listener produce extproc agent, is actually a extproc process, used for external procedure service.AddListener.ora OK, start again. OK, this time the boot is successful, the following interface appears:see only the boot upPlsextproc, and our new instance of ORCL is not up. So that other computers use PL/SQL connections, the "Ora-12514:tns: Listener currently does not recognize the requested service in the connection descriptor”。 The reason, of course, lies in Listener.ora. After the general new monitoring, there will be a corresponding configuration in the Listener.ora, but I do not know why I in the above operation also new monitoring, but not automatically generated. Then I modify Sid_list_listener manually add the following: Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = plsextproc) (oracle_h OME = E:\oracle\product\10.2.0\db_2) (program = Extproc)) (Sid_desc = (Sid_name = ORCL) (oracle_home = E:\oracle\product\10.2.0\db_2) (global_dbname= ORCL)))LISTENER =(description_list =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = win2003-64template) (PORT = 1521))(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))    )  ) OK, try again. Success. Although it may be a very simple question, but still understand the role of Listener.ora, but also, the side reflects my time to install Oracle absent-minded!! However, if not absent-minded, how can learn how to find out how to troubleshoot the problem in the future after the monitoring problem, we know where to start.

(GO) Oracle Boot listener "Listener does not support service" resolution