"Oracle Connection string" "Oracle Net Manager Service naming Configuration" "PL/SQL Landing database"

Several important parameters to connect to the database:

1. Login Username: User;

2. Login Password: password;

3. The server address (SERVER_IP) and Port (Server_port) that holds the database;

4. Database name (db_name);

I. Oracle connection string If we want to connect db_name this data, in addition to the user name password, we also need to enter a connection string like "Server_ip:server_port/db_name". <add key= "ConnectionString" value= "Data source= server Address: Port/Database name (or directly with your own configured service name); user= login user name; password= login password; " />

Ii. Oracle Net Manager Service naming configuration

1. Open the Oracle Net Manager tool, select the "Service Naming" node, click on the left Green "+" button to eject the "Net Service Naming Wizard"

The "Network Service name", which is a custom service name, can be selected arbitrarily and does not conflict with existing service naming. If you take ws_service_name here, click Next.

2. Select the communication protocol:

The TCP/IP protocol is used here by default. Click Next.

3. Configure SERVER_IP, Server_port:

The hostname is the server address of the database, and the port number uses the default port of 1521. Click Next.

4. Configure db_name:

The "(oracle8i or later) service name" is the global database name of the database you created earlier. At this point, a service named Server_ip, Server_port, and db_name three features are configured to complete. Click Next.

5. Test or Complete:

Click "Finish" to exit the wizard. Or click the "Test" button to test whether the above configuration is correct:

Make sure that the user ID you used for your test is not locked. You can click on the "Change Login" button to select another account test. If the test fails, go back and check that the configuration for each step above is entered correctly.

6. Back to the Oracle Net Manager Tools main interface, you can see the parameters that have been configured:

7. Finally, do not forget to choose the menu "file"--"Save network Configuration" to make the changes take effect.

Third, with PL/SQL Landing database:

Because a naming service named "My_service_name" is already configured, the "Database" entry only needs to fill in the "My_service_name" string for the connection to succeed.

If the naming service is not configured, the user is required to display the specified database server address, port, and database name, and the following parameters can be successfully connected:

Obviously not as convenient as naming services.

Oracle Connection string, Oracle Net Manager service naming configuration, PL/SQL Landing database