Remote connection to the Oracle database using Toad

Source: Internet
Author: User
To connect to a remote Oracle database using Toad on the local machine, follow these steps. Install the Oracle database, and install the Oracle database without using ldquo; create the startup database (additional

To connect to a remote Oracle database using Toad on the local machine, follow these steps. Install the Oracle database, and install the Oracle database without using ldquo; create the startup database (additional

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

Step 1: Install the Oracle database

When installing the Oracle database, pay attention to the following points:

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.