Windows8 install oracle11.2.0.1-0624 with DBCA build, NETCA Create listener, configure Plsql, define client environment variables Nls_lang, define client environment variables Tns_admin03

Source: Internet
Author: User

5, Configuration Plsql

A 64-bit Oracle database is installed on a 64-bit system, but there is no corresponding 64-bit PL/SQL Developer, and it is not possible to use PL/SQL Developer for direct connection, so the connection needs to be done in other ways. Here's how to implement a connection.

5.1 Download Oracle Client

: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, click Connect to enter the following page appears.

Select the first instant Client for Microsoft Windows (32-bit) to download it, please do not download 64bit, I tried, can not implement the connection.

5.2 Configuring the Oracle Client

After download, unzip it, do not need to install, such as extract to ... \tools_app directory, and then in the Instantclient_11_2 directory, create a new Layer two folder \NETWORK\ADMIN, Then build a tnsnames.ora file under the Admin folder and add the following to the file:

[Plain] view plaincopy

ORACLE =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

(Connect_data =

(SERVER = dedicated)

(service_name = ORACLE)

)

)

Listener_oracle =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

Oraclr_connection_data =

(DESCRIPTION =

(Address_list =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))

)

(Connect_data =

(SID = Clrextproc)

(PRESENTATION = RO)

)

)

The above content can be copied in this place: E:\OracleDB\app\MuLing\Product\11.2.0\dbhome_1\network\admin\tnsnames.ora.

5.3 To install PL/SQL Developer

Install the previously downloaded PL/SQL Developer (not downloaded on-line), but you need to emphasize one point: the installation path cannot have parentheses, do not install in C:\Program Files (x86) directory below .

5.4 Configuration of PL/SQL developer

After the installation is complete, run PL/SQL Developer, the login form that appears cannot log in, click the Calcel button, you will enter without login.

Configure the appropriate information to configure the previous decompression package information:

Note Specify the location of the "oci.dll" file

5.5 Restart PL/SQL developer for login

Enter the appropriate information to connect to the login.

5.6 Verify that you are really connected to Oracle

Write an SQL statement to verify that the query can see the following effect, indicating that the connection was successful.

6, define the client environment variable Nls_lang

Machines that do not have the environment variable configured use the Plsql client to insert Chinese data, garbled in the database


Go to the registry and look for the following

Hkey_local_machine->

Software->

Oracle->

Find $NLS _lang Parameters

Please modify it to simplified Chinese_china. ZHS16GBK, add support for Chinese

7, define the client environment variable Tns_admin

After adding new database information in $oracle_home\network\admin\tnsnames.ora, the Plsql login interface

The corresponding database information could not be found.

Define the client's environment variable tns_admin, after which the plsql login is normal (paths configured in path with Plsql)

Windows8 install oracle11.2.0.1-0624 with DBCA build, NETCA Create listener, configure Plsql, define client environment variables Nls_lang, define client environment variables Tns_admin03

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.