(iii) installation of the ORACLE database
Extract the "Resources" folder ORACLE installation package to the system of the virtual machine and double-click the setup.exe in the extracted directory, the installation interface appears as follows:
Enter the password and Confirm password, such as: Itcast, click Next, the following progress bar appears, note: This password is the administrator password.
Click "Next", the "Summary" screen appears, click "Install".
The installation progress bar appears, waiting for the installation to complete, such as:
After the installation is complete, run the Configuration Wizard automatically, for example, to wait for it to complete:
When finished, the "Password management" screen appears, such as: Click "OK", such as:
At the end of the installation, click "Exit".
At this point, you can test the installation results at the command prompt: Sqlplus system/itcast
Itcast The password you entered when you installed
(iv) SQLPlus remote connection to ORACLE database
Copy the instantclient_12_1 in the Resources folder to the D packing directory
Go to the command prompt, enter the directory, enter the following command to connect to the remote ORACLE
(v) Plsql Developer installation and configuration
(1) Install resource folder plsql+developer10.0.3.1701
Note: The installation directory cannot have Chinese and white space, otherwise the connection is not
Change the top directory to D:\PLSQLDeveloper
(2) Configuring the client Path
In the pop-up login window, click Cancel, tools->>preferences
(3) Edit ORA file
Locate the Tnsnames.ora file in the following installation directory of ORACLE and copy it to the local computer's D-Packing directory.
Open Tnsnames.ora file Edit, modify red box
(4) Set environment variable tns_admin to D packing directory (Tnsnames.ora directory)
(5) Enter the system
Enter the user Name System password Itcast to enter the main software interface.
(6) Chinese encoding settings
To view server-side encoded SQL:
Select Userenv (' language ') from dual
The result I actually found was: American_america. Zhs16gbk
New, environment variable, advanced system settings, properties, computer
Set Variable name: Nls_lang, Variable value: The 1th step to find the value, mine is
American_america. Zhs16gbk
In Oracle-day01