ORACLE11G_WIN32 Listener does not support service

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.