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

1. Preparatory work:

1.IP is set to static

The configuration of 2./etc/hosts files must be consistent with native ip information

3.SUSE_11_X64_SP4 system environment

4.ORACLE_11G_R2 installation package:

Linux.x64_11gR2_database_1of2.zip

Linux.x64_11gR2_database_2of2.zip

5. Some of the library files required to install ORACLE:

Sysstat-8.1.5-7.9.56.x86_64.rpm

Libstdc++43-devel-32bit-4.3.3_20081022-11.18.x86_64.rpm

Libstdc++43-32bit-4.3.3_20081022-11.18.x86_64.rpm

Libstdc++43-4.3.3mm 20081022-11.18.x86_64.rpm

Libgcc43-4.3.3mm 20081022-11.18.x86_64.rpm

Second, install the oracle database

1. Create users and groups:

Log in to the graphical interface with the root user, open the terminal with the right mouse button and execute the command:

Groupadd oinstall

Groupadd dba

Useradd-g oinstall-G dba-s / bin/bash-m oracle

Passwd oracle

two。 Create an installation directory and modify permissions, users, and groups:

Mkdir-p-m 777 / opt/oracle

Chown-R oracle:oinstall / opt/oracle

3. Modify kernel parameters:

Vi / etc/sysctl.conf

Kernel.shmmax = 4294967295

Kernel.shmall = 2097152

Kernel.shmmni = 8192

Kernel.sem = 250 32000 100 128

Fs.file-max = 6815744

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 4194304

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048576

Fs.aio-max-nr = 1048576

After saving, execute the following command to take effect immediately:

Sysctl-p

4. Set shell limits for oracle users:

Vi / etc/security/limits.conf

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Vim / etc/pam.d/login

Session required pam_limits.so

Vi / etc/profile

If [$USER = "oracle"]; then

If [$SHELL = "/ bin/ksh"]; then

Ulimit-p 16384

Ulimit-n 65536

Else

Ulimit-u 16384-n 65536

Fi

Fi

5. Install the java environment:

Upload jdk-7u79-linux-x64.rpm to the server

Perform installation: rpm-ivh jdk-7u79-linux-x64.rpm (you can also double-click to run the installation directly from the graphical interface)

6. Install some of the software needed in the following oracle environment, install it directly if it is in the CD, download the corresponding rpm package on the Internet, and test the lack of the following 5 software packages, and then install it:

Rpm-ivh libstdc++43-32bit-4.3.3_20081022-11.18.x86_64.rpm-force-nodeps

Rpm-ivh libstdc++43-4.3.320081022-11.18.x86_64.rpm-- force-- nodeps

Rpm-ivh libstdc++43-devel-32bit-4.3.3_20081022-11.18.x86_64.rpm-force-nodeps

Rpm-ivh libgcc43-4.3.320081022-11.18.x86_64.rpm-- force-- nodeps

Rpm-ivh sysstat-8.1.5-7.9.56.x86_64.rpm-force-nodeps

7. Configure the oracle global environment variable:

Vi / etc/profile (the graphical interface can find the file in the appropriate directory, double-click to open it, copy and paste the following content, and save it. )

Export ORACLE_BASE=/opt/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11gR2/db

Export ORACLE_SID=orcl

Export JAVA_HOME=/usr/java/jdk1.7.0_79

Export PATH=$PATH:$JAVA_HOME/bin:$ORACLE_HOME/bin:$HOME/bin

Export CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar

Export DISPLAY=:0.0

Effective immediately after adding: source / etc/profile

8. Modify the orcle user environment:

Vi / home/oracle/.bashrc

Export ORACLE_BASE=/opt/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11gR2/db

Export ORACLE_SID=orcl

Export JAVA_HOME=/usr/java/jdk1.7.0_79

Export PATH=$PATH:$JAVA_HOME/bin:$ORACLE_HOME/bin:$HOME/bin

Export CLASSPATH=.:$JAVA_HOME/lib/tools.jar:$JAVA_HOME/lib/dt.jar

Export LANG=en_us

Export LC_ALL=en_us

Take effect immediately after adding:

Source / home/oracle/.bashrc

Then execute:

Xhost +

9. Generate the RedHat file (this step can be omitted, but actually the / etc/redhat-release file is generated):

Echo "Red Hat Linux release 4.1" > > / etc/redhat-release

10. Enter the oracle installation file (oracle):

Copy the oracle installation package to the server:

Then decompress:

Unzip linux.x64_11gR2_database_1of2.zip

Unzip linux.x64_11gR2_database_2of2.zip

Give permissions to the merged directories after decompression:

Chmod-R 777 / home/poka/database/

11. Open the xhost Desktop (oracle):

Switch to oracle user

Su-oracle

Enter the xclock command to display the small clock normally, which means that the oracle user environment is set successfully. Otherwise, please check the previous environment parameter settings.

twelve。 Start the installation:

Pay attention to AL32UTF8 when selecting the character set, which can solve the problem of garbled Chinese display after the client connects. Change to the database directory, and then start the installation.

. / runInstaller-ignoresysprereqs

13. A graphical installation interface appears:

Step 1: uncheck the contents in the red box, click next, and prompt "No email address specified". Click "Yes".

Step 2: click to select the first option, "create and configure database". This option is also the default option, click next.

Step 3: click to select the second option "Server Class" and click "next"

Step 4: click to select the first option, "single instance database installation", and click next.

Step 5: click to select basic installation, and click next

Step 6: set the orcl password (uppercase and lowercase plus numbers). Other settings need not be changed.

Step 7: select the path / opt/oracle/oraInventory here. Click next and prompt to select yes.

Step 8: if there is a prompt here, follow the prompt. If there is no prompt, you will go straight to the next step.

Step 9: if there is no prompt above, this interface will appear directly. Click finish to proceed to the next step.

Step 10: enter the installation progress bar interface

Step 11: when the progress reaches 95%, an interface (DATABASE CONFIGURATION ASSISTANT) will pop up, and then please wait

Step 12: progress to 100% will prompt the password Managerment interface

Click password Managerment to configure the password:

To set the user password, note that both the New Password and Confirm Password columns should be set: the System password can be set to 123456, then click OK, and when prompted to select yes

Step 13: execute the script for the path under root, and then click OK to determine

Sh / opt/oracle/oraInventory/orainstRoot.sh

Sh / opt/oracle/product/11gR2/db/root.sh

Step 14: installation is complete

3. Set up listening and starting oracle database

Set up listening to modify / opt/oracle/product/11gR2/db/network/admin/listener.ora file

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = / opt/oracle/product/11gR2/db)

(SID_NAME = orcl)

)

)

On | off | View listening:

Lsnrctl start | stop | status

Connect to the database command:

(1) sqlplus / as sysdba

(2) sqlplus / nolog

SQL > connect / as sysdba

Enable | close | close the database immediately:

Startup

Shutdown

Shutdown immediate

SQL > select * from all_users; (View all users of the system)

SQL > SELECT * FROM DBA_USERS; (View all users of Oracle database (sysdba))

SQL > select * from tab; (view all tables of the system)

SQL > select * from version; (view current version)

SQL > show user (View current user)

SQL > select status from vault instance; (check whether the installation is successful)

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.