(1) Installing Oracle under Linux
Pre-installation Note: 1. Ensure that the system hostname is logged in the/etc/hosts
2, Linux system installation graphical interface
3, OFA (Best flexible architecture):/alphanumeric/Standard name/username, such as/u01/app/oracle
Step: 1, create the Oracle user and/u01 directory, and modify the owner and group of/u01 to this user;
2, the software copied to/u01, after unzip decompression, using the user created to run Runinstaller installation;
(Note: (1) If the report DISPLAY is not defined execution: Export display=:0.0 and Xhost +
(2) The installation interface is garbled: A, download Chinese fonts placed in/usr/share/fonts/zh_cn/truetype and/usr/share/fonts/chinese/truetype;
b, using the command:./runinstaller-jreloc/usr/lib/jvm/java-1.6.0-openjdk/jre;
C, modify the language to en_US. UTF-8.
3, in the typical installation step, first define the Oracle home directory: VI ~/.bash_profile
Export oracle_base= "/u01/app/oracle" # #根据实际定义基目录
Export Oracle_home= "/u01/app/product/11.2.0/dbhome_1" # #根据实际定义家目录
Export display=:0.0
Path= $PATH: $HOME/bin: $ORACLE _home/bin # #支持直接使用sqlplus命令
4. Configure system parameters: Su to root user, execute/tmp/cvu_12.1.0.2.0_oracle/runfixup.sh
5. Install the required software:
6. Script to run the requirements:/u01/app/orainventory/orainstroot.sh and/u01/app/oracle/product/12.1.0/dbhome_1/root.sh
7. Set the SYS and system password (if you select "Install Oracle software only" at the time of installation, there is no step to create the database using the DBCA command).
(2) Installing the database using DBCA
Steps:
1. NETCA: Create Listener # #文件在 $ORACLE _home/network/admin/listener.ora
2. DBCA: Create Database
(3) Oracle database management Tools
1. OEM:HTTPS://IP: Port/em # #database Control and Grid control
(Note: 12c version port default 5500;11g previous version port default 1158, view: Cat $ORACLE _home/install/portlist.ini, cannot open modify client Hosts file)
2, Sqldevelper
3, SQLPlus
(Note: A, cannot use up and down keys, need to install rlwrap kit;
B, login display in English, set the variable export nls_lang= ' simplified Chinese_china. UTF8 ')
Connection mode: A, sqlplus enter after entering the account password;
B, Sqlplus/nolog Enter: Connect account/password @ library name as Sysdba
C, sqlplus account/password @ library name as Sysdba
D, Sqlplus/as sysdba # #使用本地系统账号登入
Install Oracle 12c database under Linux