Oracle's NET Configuration Assistant configurations

In the team development, everyone in the general team only need 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. There are two ways to configure a client: The first is to use NET configuration Assistant, and the second is to use Net Manager, both of which are available from the Start menu, and individuals prefer to use NET configuration Assistant, because it is wizard-based, very convenient, and not much of an error.

First, open the 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, enter the database server instance name in the dialog box, for example: WALK, the instance name is best to ask the DBA, what is the name of the installed instance, Oracle default is ORCL.

Finally, click Next, select the network protocol in the New dialog box, usually with the default TCP, as shown in:

Five, click Next, enter the IP of the database server in the New dialog box, and select the correct port number, the default port for Oracle instance is 1521, the Earth people know the beep. As shown in the following:

Six, click Next, select "Yes, test" or "No, do not test", it is recommended to test, as shown in:

Seven, click Next, click the "Change Login" button, for Oracle 9i earlier version, Oracle Default username and password is: Syste/manager, for 92i or 10g or 11g version, the installation must re-identify the password, so it will show that the test was unsuccessful, You only need to change the login.

Change Login:

Finally click the OK button

Click Next, enter the local service name, the service name you can take the same name as the server, you can also have a different name, there is no problem, as long as the unique machine can be.

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

Tenth, test

Go to the command line and enter:

Sqlplus [email protected]

Where Zizz is a user of the walk server, walk is a local naming service for the server.

Oracle's NET Configuration Assistant configurations