ORACLE11G_WIN32 Listener does not support service

Oralce after the installation is completed, the monitoring service does not support errors, and is checked because the listener is not configured to cause.

Summarized as follows:

For client programs:

1. Need to configure Oracle_home as a directory containing oci.dll files

Set oracle_home=d:\app\administrator\product\11.2.0\client_1

2. Add the PATH environment variable to the directory that contains the Oci.dll file

Set Path=d:\app\administrator\product\11.2.0\client_1:path

3.tnsnames.ora file is filled with the connection string information, Tns_admin is set to include the Tnsnames.ora file path.
Set tns_admin=d:\app\administrator\product\11.2.0\client_1

Can be saved as bat file execution:

@echo on
Set path=d:\app\administrator\product\11.2.0\client_1
Set Oracle_home=d:\app\administrator\product\11.2.0\client_1:path
Set tns_admin=d:\app\administrator\product\11.2.0\client_1
Set Nls_lang=american_america. Zhs16gbk
Start c \ "program Files (x86)" \ "Plsql Developer" \plsqldev.exe
@echo off

These actions can be added under right-clicking My Computer-Properties-Advanced system Settings-advanced-environment variables-system variables. This can be used regardless of the restart or whatever.

This allows the database to be connected after the Plsql is started.

For a service database program, you can also connect to the database after configuring it as a client, but to start the local database you need to focus on the Listener.ora,sqlnet.ora and Tnsnames.ora three file configurations. After installing the database software, you need to configure the listener and then configure the Network service name to start normally.

For this error, you need to configure Listener.ora:

Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Plsextproc)
(Oracle_home = D:\app\Administrator\product\11.2.0\oracledb)
(program = Extproc)
)
(Sid_desc =
(Sid_name = ORCL)
(Oracle_home = D:\app\Administrator\product\11.2.0\oracledb)
(Global_dbname= ORCL)
)
)

LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = AXC) (PORT = 1521))
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0))
)
)

Execute command lsnrctl stop, lsnrctl start, lsnrctl status to see the database listening service has been up.

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.

If only Plsextproc is started and the new instance ORCL not up so that other computers use PL/SQL connections, the "Ora-12514:tns: The listener is currently unable to recognize the service requested by the connection descriptor " appears. The reason, of course, lies in Listener.ora. After the general new monitoring, theListener.ora will have the corresponding configuration.

Reference article:

Http://www.51testing.com/html/99/478599-842622.html

ORACLE11G_WIN32 Listener does not support service