Oracle 10 Gb database creation and remote access configuration

Oracle 10 Gb database creation and remote access configuration

Recently, Oracle was used in the project, with oracle10gb. because many people in the group use the database, and the oracle database occupies a lot of memory, it is placed on a separate server, therefore, it is best for everyone to install an oracle10g client. Therefore, remote access from the client to the database 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. If it's 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 better 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 "local Net service name configuration" and "add ". The "service name" option should be filled in (the service name is actually your own identifier for the remote database. You can use the same name as the remote database name, or you can choose one as needed, as long as you know that it corresponds to the remote database .). Enter "website", select "TCP", and enter "Host Name", that is, the IP address of the host where the remote database is located. You can select test or do not perform 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 information about it. You can also configure or test the service in this tool. In short, both tools can test the success of remote connection. Note: If the test fails, you can change the user name and password used during the test. Then test.

4. If the test is successful, you can access the remote database now. You can use the SQL/PLUS tool or the graphical tool Enterprise Manager Console. In the SQL/PLUS connection, the "host string" is filled with the service name configured in NetConfiguration configurence or Net Manager. 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 need to manually add the database to the tree structure, which is included in the top button. Then there are some IP and SID settings. These are similar to those on the front. When logging on to a remote database, it is best to use the sys user name, using system without DBA permissions.

Recommended reading:

Oracle 10g client remote database connection configuration Diagram