Oracle 11 配置监听以便连接（oracle11监听配置）

Oracle 11: Configuring Listener for Connection

Oracle 11g provides a robust database management system that requires proper configuration of the listener to enable connections. Listener is a program that facilitates database connections between clients and the Oracle database. In this article, we will guide you through the steps of configuring the listener in Oracle 11g.

Step 1: Check if the Listener is Running

Before configuring the listener, it’s important to check whether the listener is already running on your system. To do this, open the command prompt and enter the following command:

lsnrctl status

If the listener is running, you’ll see a message that says “The listener supports no services.” However, if it’s not running, you’ll see an error message like “TNS-12541: TNS: no listener.”

Step 2: Configuration of Listener

To configure the listener, you’ll need to modify the listener.ora file. This file is located in the $ORACLE_HOME/network/admin directory. Open the file in a text editor and add the following lines at the bottom of the file:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = your_database_name)

(SID_NAME = your_sid_name)

(ORACLE_HOME = your_oracle_home_path)

)

)

Replace “your_database_name” with the name of your database, “your_sid_name” with the SID number of the instance, and “your_oracle_home_path” with the path of your Oracle installation.

Step 3: Starting the Listener

To start the listener, enter the following command in the command prompt:

lsnrctl start

This will start the listener and enable connections between the clients and the Oracle database.

Step 4: Checking the Listener Status

To check the status of the listener, enter the following command in the command prompt:

lsnrctl status

This will display the current status of the listener and the services it’s supporting.

Step 5: Testing the Connection

Finally, to test the connection to the Oracle database, you can use SQL*Plus, which is a command-line interface for Oracle. Open SQL*Plus and enter the following command:

connect username/password@database_name

Replace “username” with your username, “password” with your password and “database_name” with the name of your database.

If the connection is successful, you’ll see a message that says “Connected to Oracle.” This confirms that the listener has been successfully configured.

Conclusion

Configuring the listener in Oracle 11g is an essential step for ensuring proper communication between clients and the database. By following the steps outlined in this article, you should be able to configure the listener and test your database connection successfully.

Note: It’s important to ensure that your firewall is properly configured to allow traffic through the listener port to enable communication.

Code Sample:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ORCL)

(ORACLE_HOME = C:\app\oracle\product\11.2.0\dbhome_1)

(SID_NAME = ORCL)

)

)

In the above code sample, replace “ORCL” with the name of your own database, “C:\app\oracle\product\11.2.0\dbhome_1” with the path to your Oracle installation, and “ORCL” with the SID name of your instance. Save the file after making the necessary changes.