How to configure the local Oracle Net service name

During team development, generally, each person in the team only needs to install a client. There is no need to install an Oracle database server, and the database server is shared. At this time, we need to configure the client. The client Configuration can be either of the following two methods: Net Configuration Assistant and Net Manager. Both tools are available in the Start Menu, I personally prefer to use Net Configuration Assistant because it is based on the wizard type, which is very convenient and does not cause errors.

First, open Net Configuration Assistant and select the local Net service name Configuration in the pop-up dialog box, as shown in:

Second, click Next and select "add" in the dialog box, as shown in:

Third, click "Next" and enter the database server instance name in the dialog box, for example, "WALK". It is best to ask the DBA what is the installed Instance name, and ORACLE is ORCL by default.

Fourth, click Next and select the network protocol in the new dialog box. Generally, use the default TCP protocol, as shown in:

Fifth, click Next. In the new dialog box, enter the IP address of the database server and select the correct port number. The default port number of the ORACLE instance is 1521, and everyone on Earth knows the renewal. As shown in:

Sixth, click Next and select "Yes, perform a test" or "No, do not perform a test". We recommend that you perform a test, as shown in:

7. Click Next and click "Change login". For earlier versions of Oracle 9i, the default username and password of Oracle are: syste/manager and for versions of 92i, 10g, or 11g, during installation, you must confirm the password again. Therefore, the test is unsuccessful. You only need to change the logon password.

Change Logon:

Click OK.

During team development, generally, each person in the team only needs to install a client. There is no need to install an Oracle database server, and the database server is shared. At this time, we need to configure the client. The client Configuration can be either of the following two methods: Net Configuration Assistant and Net Manager. Both tools are available in the Start Menu, I personally prefer to use Net Configuration Assistant because it is based on the wizard type, which is very convenient and does not cause errors.

First, open Net Configuration Assistant and select the local Net service name Configuration in the pop-up dialog box, as shown in:

Second, click Next and select "add" in the dialog box, as shown in:

Third, click "Next" and enter the database server instance name in the dialog box, for example, "WALK". It is best to ask the DBA what is the installed Instance name, and ORACLE is ORCL by default.

Fourth, click Next and select the network protocol in the new dialog box. Generally, use the default TCP protocol, as shown in:

Fifth, click Next. In the new dialog box, enter the IP address of the database server and select the correct port number. The default port number of the ORACLE instance is 1521, and everyone on Earth knows the renewal. As shown in:

Sixth, click Next and select "Yes, perform a test" or "No, do not perform a test". We recommend that you perform a test, as shown in:

7. Click Next and click "Change login". For earlier versions of Oracle 9i, the default username and password of Oracle are: syste/manager and for versions of 92i, 10g, or 11g, during installation, you must confirm the password again. Therefore, the test is unsuccessful. You only need to change the logon password.

Change Logon:

Click OK.

Eighth, click "Next" and enter the local service name. You can name the service name with the same name as the server or different names. No problem is found, as long as the local machine is unique.

Ninth, click Next to complete the configuration. Select No, click Next, and click Finish to complete the configuration.

Tenth, test

Go to the command line and enter:

Sqlplus zizz @ WALK

Zizz is a user of the WALK server, and the WALK is a local Naming Service of the server.