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_admin

Source: Internet
Author: User

Windows8 installation Oracle11.2.0.1

Operating system: Windows 8 Enterprise Edition 64bit

oracle:11.2.0.1 64bit

1. Oracle

Win 64-bit Oracle:
Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip

Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_2of2.zip

2, Oracle installation 2.1. Extracting files

Unzip the file, select the two compressed packages together, right-click and unzip to the current folder

2.2. Perform the installation

To the appropriate decompression path, locate the executable installation file "setup.exe" double-click the installation.

2.3. Modify the compatibility of the file "setup.exe"

Please modify the file compatibility to run as "administrator"

2.4. Configuring Security Updates

This step can fill in your e-mail address (or you can not fill in, just received some useless mail only).

Cancel the "I want to accept security update (W) through my Oracle support" below. Such as:

2.5. Installation Options

Select Install only database software, and subsequently create and configure the database as follows:

2.6. Select the type of database installation you want to perform

Select "Single Instance Database Installation"

2.7. Select the language to use when running the product

Default "Simplified Chinese", "English"

2.8 Select the database version to install

Choose Enterprise Edition for Richer features

2.9 setting $oracle_home, $ORACLE _base

Specify a new path according to the recommendations given in Oracle's official documentation

Note: The directory path does not contain Chinese or other special characters

2.9 Some profiles for Oracle installation

2.10 Long absence of installation interface

After about 10 minutes, the installation is complete

2.11 Oracle Software Installation Complete

Just finished the first step OH

3. NETCA Configuration Listener

Enter the DOS window to run NETCA

4, DBCA Building Library

With configuration listener, run DBCA in DOS window

Setting the database name

No need for EM

To set a password for a user in a database

For ease of management, it is recommended to use the Unified password Oracle

Password input, there is a warning, do not comply with ORACEL recommendations without tube. (because the password rules recommended by Oracel are cumbersome, they must be uppercase and lowercase plus numbers, and must be more than 8 digits.) Trouble, you can enter the usual oneself habit of short password can be)

No need to configure "Quick recovery zone"

The Oracle database provides a sample user Scott/tiger, which can be used to practice the user at all times. If you do not create the user at this time, you can later use the script to create the user

allocating memory to an Oracle database

Specifies the character set for the Oracle database. Select Al32utf8 with better compatibility, note that the character set of the client must be consistent with the character set of the server

Some profiles for Oracle databases

Click Finish to start creating the database

Some profiles for Oracle databases

A long absence of installation progress

Click password Management to unlock the user

Unlock the sample user Scott, remove the green tick from the front, and enter the password. You can also enter a short password that you normally use.

Log in to the database to test whether the installation is complete

Check the status of an instance

The instance is already open and the installation is complete

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 Installing the Pl/sqldeveloper

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 the Pl/sqldeveloper

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/sqldeveloper to log in

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_admin

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.