Whole Process of remote database connection from Oracle10g Client

Recently, Oracle was used in the project, and oracle10gb was used because many people in the group use the database, and the Oracle database occupies a large proportion.

Storage is placed on a separate server, so it is best for everyone to install an Oracle10g client. Then the client is far away from the database

It is inevitable.

    In fact, remote access is very simple, but the implementation process is indeed very difficult. There seems to be no similar information on the Internet. From

If it is hard to install it, write it down. I hope it will be useful to those who need it.

    My Oracle server is located in Windows2003, and the client is located in XP.

    1. Create a database on the server, such as website. (It is best not to exceed 8 characters. I tried it myself. If it exceeds a certain character

Enter the service name during remote access, and the service name is invalid. After the query, the 8i cannot exceed 8 characters ). In this case

The database name is website, and the SID is also website.

    2. Configure net configuration asistence on the client. This tool can be used to set and test remote connections. Select

Select "local net service name configuration" and "add ". Enter the "service name" option (the service name is actually your own remote database

You can use the same name as the remote database, or you can use the same name as the remote database, as long as you know that it corresponds to the remote data.

Library .). Enter "website", select "TCP", and enter "Host Name", that is, the IP address of the host where the remote database is located.

Then you can select test or do not perform the test for the moment.

   3. In the net manager tool, in the tree structure on the left, you can see the service you Just configured and some of its

Information. You can also configure or test the service in this tool. In short, both of these tools can successfully connect to the remote connection.

For row testing. Note: If the test fails during these two tools, you can change the user used during the test.

Name and password. Then test.

   4. If the test is successful, you can access the remote database now. You can use the SQL/plus tool or

Enterprise Manager Console is a graphical tool. In the SQL/plus connection, the "host string" is entered in the net

The service name configured in configuration configurence or net manager can be used. For example, in the preceding environment, the service name is website.

When you log on, the "host string" is "website as sysdba ". The prerequisite must be that you have configured these two tools. (

Haha, nonsense !). When using the Enterprise Manager Console, you must manually add the database to the tree structure.

Button. Then there are some IP and Sid settings. These are similar to those on the front. When logging on to the remote database

You are advised to use the Sys user name. You do not have the DBA permission to use system.

   Write it here. If you have time, write the Oracle10g installation. However, I personally think that 10g is much better than 9i. Complete

When a registry is deleted, the information to be deleted in the registry is smaller than that in 9i. Sorry, I am stupid!