Configuration of Oracle Database remote connection

Today help others solve the problem, about Oracle, suddenly feel that should be a note, friends can see. Here is the detailed configuration:

1. First locate the attached configuration net Manager at installation time in Oracle, open it, and configure it on it.

2. Below is the page after you enter NET Manager, click the service name below, then click the Plus + arrow to create a new service.

3. Click on the first page after the creation, fill in the Network service name, this name is to connect to the database, can be called casually.

4. The second page is the Select Service Wizard, we generally choose the first TCP/IP (Internet Protocol), then click on the next page.

5. The third page is populated with the hostname, which is the IP number of the remote computer you want to connect to, the Oracle port number is 1521, and then the next step.

6. The fourth page is mainly the service name in Oracle, my is Cabis, can not write casually, is fixed, the following database connection type is: Database default settings, there are other needs can be freely changed. When you are done, click Next.

7. The fifth page is to complete the operation configuration, you can also test, fill in the database name and password.

8. This is a configuration completed template, mainly on the right side of the content.

9. When you are done, click Save to pop up the message box when you close.

10. Then use Oracle's Connection tool PL/SQL to connect, fill in the user name, is the name on the remote computer, password is the password of the remote computer, the database selects the service name that you wrote at the beginning. Click OK.

11. After the successful entry of the template, the title has a user name.

　　　　　　

Configuration of Oracle Database remote connection