Yesterday, I knew how to create new Listener and TNS in Oracle. It's kinda simple if you know how to do. If not, so complicated

Create new Listener in Oracle

First of all, we need to go Oracle first. Then, we need to go Configuration and migration tools > Net Manager.

Above screen, we need to fill up all needed information for Oracle listener.

Global Database Name is the name of database. Oracle Home Directory is the full directory path of Oracle installation path. SID is the Oracle System ID of Oracle database.

After filling up that information into Net Manager, go to File and Save it then. Now, you can see your new listener is running in Services. If not, go to command line and type following two commands to check whether your listener is running or not.

Create new TNS in Oracle

First of all, we need to go Oracle first. Then, we need to go Configuration and migration tools > Net Configuration Assistance.

Above screen will be popping up. Then, we need to choose Local Net Name configuration. After that, we need to choose which options we want to use out of six options (Add, Reconfigure, Delete, Rename, Test).

For example, I’ll choose Add option to create new TNS for Oracle and click “Next” button. After that, we need to choose the version of Oracle database. Normally, we need to choose the first option called “Oracle8i or later database or services.” Then, we need to click on “Next” button and type Service name. Then, we need to choose database network as TCP. After that, Host Name is the computer name of database server and Oracle standard default port is 1521. Then, click “Next” button and you will see the screen provide whether you want to test TNS name or not. Then, click “Next” to finish.

This entry was posted on September 23, 2011 at 9:16 AM and has received 1029 views. There are currently 0 comments. Print this entry.