Oracle Database remote connection configuration tutorial

Oracle Database remote connection configuration tutorial

I have worked on Oracle databases some time ago, but I found that the database listening program and service name are difficult to handle, and there is no ready-made tutorial on the Internet. Therefore, after your own exploration, I will contribute this article to you. If you have any mistakes, please forgive me and contact me.

This configuration is performed only when the local machine allows access. If access is not allowed, disable the firewall.

Server Configuration:

Configure the listener

1. Open Net Manager

2. Add a listener

Select listener and click the green plus sign on the left.

Name the listener. The default value is LINSTENER1. Click "OK"

1. Add a listening address

The host name is changed to the server (Local Machine) IP address, and the port number is automatically specified.

4. Add a Database Service

Click Select in the upper part of the page and select "database service ".

Click "add Database". You can specify the global database name, which is generally in the format of "database name. IP Address"

SID is the database served by the listener.

So far, the server Listener Configuration is complete!

 

Client Service Configuration:

Service name Configuration

1. Add a service

The creation process is consistent with that of the listener.

2. Network Service name

The Network Service name is a local service identifier and can be specified arbitrarily.

3. protocol selection

TCP/IP protocol selected by default

1. Specify the host name and port number

The host name and port number must be the IP address of the server host and the port number used, that is, the same as that specified by the listener.

1. Service name settings

Here, the service name is the service name of the connection server. It must be consistent with the global service name of the listener. Select a dedicated server as the connection type.

Connection test

The connection test is used to test whether the service can connect to the server. The default user name is scott and the password is tiger.

Click Change logon to change the user name and password of the database to be connected. Click OK.

Click test. The connection is displayed in the Information Window. Click CLOSE> complete.

Now, all configurations are complete, and the client and server can be connected normally.