Remote connection to the Oracle database using Toad

To connect to a remote Oracle database using Toad on the local machine, follow these steps.

Step 1: Install the Oracle database

Pay attention to the following points when installing the Oracle database:

1) Click setup.exe, the outmost icon of the installation package. (As Li XX said, you cannot click to install it)

2) You do not need to create a startup database (720 MB attached). Similarly, the global database name and password corresponding to this option can be canceled and skipped directly. This can reduce the CPU burden on the local machine. Of course, if you need to use the local database to do some operation exercises on the local machine, you still need to create and start the database. Here, you only want to connect to a remote database, so you do not need to create a local database.

Step 2: Install Toad

Install Toad for Oracle 9.5. The decoding is as follows:

Toad 9.5 Authorization key

Sit message: li

Authorization key: 0-63920-00993-29060-08749

Step 3: Configure TNSNAMES)

Open Toad. The database drop-down list is still empty. You need to configure the tnsnames. ora file to use it:

E: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN \ tnsnames. ora. Note: At the beginning, the tnsnames. ora file in this directory does not exist and needs to be configured as follows:

1) [Win + R]-> [netca] Call up the Oracle Net Service configuration.

2) Select Local Net service name configuration> next to go to The add page.

3) [add]-> [next] To Go To The Net service name configuration page.

In this case, the service name must be the global database name of the remote database, that is, the global name specified by the database during design.

1 2 3 Next Page