Configure oralce 10 Gb local net service

When you use commands to connect to Oracle on the server, you do not need to start the listener (if you want to, you can certainly configure it), as shown below:

Sqlplus/nolog

Conn sys/admin as sysdba;

 

If the current user belongs to the DBA group, you can run the following command to log on to Oracle:

Conn/As sysdba.

In this case, the operating system logon authentication is used.

 

However, when the client starts to log on to Oracle for 10 Gb, you need to start the listener and configure the local net service as follows:

Open "configuration and porting tool" --- net configuration assistant.

In the displayed window, select "local net service name configuration" and click Next.

Select "add ".

Enter "service name". Here the service name refers to the database instance name of Oracle, which must correspond to the database instance name. Click "Next ".

Select TCP. Click "Next ".

Enter the host name. You can enter the IP address of the host. However, we strongly recommend that you enter the host name! We strongly recommend that you enter the host name instead of the IP address When configuring the listener, because once the IP address changes, all the listeners will not work, and of course, they will not be able to log on to the OEM! Click "Next ".

Prompt whether to test, of course, it is best to test:

Enter the user name and password for testing.

Click "Next ".

The system will prompt you to enter "network service name" (that is, what is the name of the local database instance for the client ):

You can enter orcl at will (in general, we set the network service name and database instance name to be consistent)

Click "Next" to complete the configuration.

 

When the client is connected in the future, the server's service address will be: IP/orcl.