Shulou(Shulou.com)06/01 Report--

(1) install Oracle under Linux

Note before installation: 1. Make sure the hostname of the system is recorded in / etc/hosts

2. Graphical interface for Linux system installation

3. OFA (Best flexible Architecture): / alphanumeric / standard name / user name, such as / u01/app/oracle

Steps: 1. Create the Oracle user and / U01 directory, and modify the owner and group of / U01 to this user

2. Copy the software to / U01, then extract the unzip, and run the runInstaller installation with the created user.

(note: (1) if DISPLAY does not define execution: export DISPLAY=:0.0 and xhost +

(2) there are garbled codes in the installation interface: a, download Chinese fonts on / usr/share/fonts/zh_CN/TrueType and / usr/share/fonts/chinese/TrueType

B. Use the command:. / runInstaller-jreLoc / usr/lib/jvm/java-1.6.0-openjdk/jre

C. Change the language to en_US.UTF-8.

3. In the typical installation steps, first define the Oracle home directory: vi ~ / .bash_profile

Export ORACLE_BASE= "/ u01/app/oracle" # # define the base directory according to the actual

Export ORACLE_HOME= "/ u01/app/product/11.2.0/dbhome_1" # # based on the actual definition of home directory

Export DISPLAY=:0.0

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin # # supports direct use of sqlplus commands

4. Configure system parameters: su to root users, execute / tmp/CVU_12.1.0.2.0_oracle/runfixup.sh

5. Install the required software:

6. Run the required scripts: / u01/app/oraInventory/orainstRoot.sh and / u01/app/oracle/product/12.1.0/dbhome_1/root.sh

7. Set the SYS and SYSTEM passwords (if you choose "install only Oracle software" during installation, there is no such step, use the dbca command to create the database).

(2) use dbca to install the database

Steps:

1. Netca: create a listener # # File in $ORACLE_HOME/network/admin/listener.ora

2. Dbca: create a database

(3) Oracle database management tools

1. OEM: https://ip: port / em # # database control and grid control

(note: 12c version port defaults to 5500ans11g previous version port defaults to 1158. View: cat $ORACLE_HOME/install/portlist.ini, cannot open and modify client hosts file)

2 、 SQLdevelper

3 、 SQLPlus

(note: a, cannot use the up and down keys, you need to install the rlwrap toolkit

B, log in to display English, set the variable export NLS_LANG='SIMPLIFIED CHINESE_CHINA.UTF8')

Connection method: a, enter the account password after sqlplus enter

B. After sqlplus / nolog enter, enter: connect account / password @ library name as sysdba

C, sqlplus account / password @ library name as sysdba

D, sqlplus / as sysdba # # log in using the local system account

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.