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 |
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