Installation of ORACLE_11G_R2 in SUSE_11_X64_SP4 environment

First, the preparatory work:

1.IP set to Static

The configuration of the 2./etc/hosts file must be consistent with the 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. Install some of the library files required by 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.3_20081022-11.18.x86_64.rpm

libgcc43-4.3.3_20081022-11.18.x86_64.rpm

II. Installation of Oracle database

1. Create users and Groups:

With the root user login GUI, right mouse button open terminal, execute command:

Groupadd Oinstall

Groupadd dba

Useradd-g oinstall-g dba-s/bin/bash-m Oracle

passwd Oracle

2. Create the installation directory, modify permissions, users, 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 immediately:

Sysctl-p

4. Set the shell's limitations on 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 the jdk-7u79-linux-x64.rpm to the server

Perform installation: Rpm-ivh jdk-7u79-linux-x64.rpm (You can also run the installation directly from the graphical interface)

6. Install some software required by Oracle environment below, if there is a direct installation in the CD, do not go to the Internet to download the corresponding RPM package, tested missing the following 5 packages, and then install:

RPM-IVH libstdc++43-32bit-4.3.3_20081022-11.18.x86_64.rpm--force--nodeps

RPM-IVH libstdc++43-4.3.3_20081022-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.3_20081022-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(graphical interface can be found in the corresponding directory files, double-click to open, copy and paste the following content, save.) ）

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

Effective immediately after adding:

Source/home/oracle/.bashrc

Then execute:

Xhost +

9. Generate the Redhat file (this step can omit the operation, actually generate the/etc/redhat-release file):

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

Unzip Linux.x64_11gR2_database_1of2.zip

Unzip Linux.x64_11gR2_database_2of2.zip

Give the extracted directory permissions after decompression:

Chmod-r 777/home/poka/database/

11. Open Xhost Desktop (Oracle):

Switch to Oracle User

Su-oracle

Enter the Xclock command, normal display small clock, indicating the setting of the Oracle User environment is successful, otherwise check the previous environment parameter settings.

12. Start the installation:

Select Al32utf8 when selecting a character set, you can resolve the problem of Chinese garbled display after client connection, switch to database directory, and then start the installation

./runinstaller-ignoresysprereqs

13. A graphical installation interface appears:

Step 1: Check out the contents of the Red box, click Next, Prompt "No email address specified" Click "Yes" 650) this.width=650; "Src="/e/u261/themes/default/images/spacer.gif " Style= "border:1px solid rgb (221,221,221); background-position:50% 50%;background-repeat:no-repeat; alt=" Spacer.gif "/>650" this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/8C/0D/wKioL1hgzSKgIBDeAADPIiEZkl8093.png-wh_ 500x0-wm_3-wmp_4-s_40792250.png "title=" qq picture 20161226155545.png "alt=" wkiol1hgzskgibdeaadpiiezkl8093.png-wh_50 "/ >

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/8C/0D/wKioL1hgzZuBs32aAADFUTjRHkY550.png-wh_500x0-wm_3 -wmp_4-s_701744318.png "title=" 2.png "alt=" Wkiol1hgzzubs32aaadfutjrhky550.png-wh_50 "/>

Step 2: Click to select the 1th option "Create and configure a database" This option is also the default option, click Next.

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/8C/11/wKiom1hgzhnh8N_2AAETL68TifM113.png-wh_500x0-wm_3 -wmp_4-s_3892311627.png "title=" 3.png "alt=" Wkiom1hgzhnh8n_2aaetl68tifm113.png-wh_50 "/>

Step 3: Click to select the 2nd option "Server Class" and click "Next"

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M00/8C/0D/wKioL1hgzm2ALU4aAACrhBT-ync376.png-wh_500x0-wm_3 -wmp_4-s_511770782.png "title=" 4.png "alt=" Wkiol1hgzm2alu4aaacrhbt-ync376.png-wh_50 "/>

Step 4: Click to select the 1th option "Single Instance database Installation" and click Next.

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/8C/11/wKiom1hgzsaRT9ogAADDk79-hw0853.png-wh_500x0-wm_3 -wmp_4-s_2913039889.png "title=" 6.png "alt=" Wkiom1hgzsart9ogaaddk79-hw0853.png-wh_50 "/>

Step 5: Click to select "Basic Installation" and click "Next"

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/8C/0D/wKioL1hgzxPSIv_1AADR8ilaGwE812.png-wh_500x0-wm_3 -wmp_4-s_759000767.png "title=" 7.png "alt=" Wkiol1hgzxpsiv_1aadr8ilagwe812.png-wh_50 "/>

Step 6: Set ORCL password (case plus number), other settings do not change

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/8C/11/wKiom1hg1y6zcLMGAAD7Kns0wXw981.png-wh_500x0-wm_3 -wmp_4-s_2633680883.png "title=" 11.png "alt=" Wkiom1hg1y6zclmgaad7kns0wxw981.png-wh_50 "/>

Step 7: Here path select/opt/oracle/orainventory, click Next, prompt to select Yes

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M01/8C/0E/wKioL1hg2BPjr3ZWAAC9GpMEW9Q112.png-wh_500x0-wm_3 -wmp_4-s_3489105143.png "style=" Float:none; "title=" 12.png "alt=" Wkiol1hg2bpjr3zwaac9gpmew9q112.png-wh_50 "/>

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M01/8C/0E/wKioL1hg2BSRM4ZwAADJyFLZbhM016.png-wh_500x0-wm_3 -wmp_4-s_3775278930.png "style=" Float:none; "title=" 13.png "alt=" Wkiol1hg2bsrm4zwaadjyflzbhm016.png-wh_50 "/>

Step 8: Here if prompted to follow the prompts to do, without prompting will go directly to the next step

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/8C/0E/wKioL1hg2GmD9z0lAAGqHmX6maA430.png-wh_500x0-wm_3 -wmp_4-s_3598568738.png "title=" image 1.png "alt=" Wkiol1hg2gmd9z0laagqhmx6maa430.png-wh_50 "/>

Step 9: If you do not have the above prompt will appear directly this interface, click Finish to enter the next

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/8C/0E/wKioL1hg2PrRIdCXAAEE3iqMbhk464.png-wh_500x0-wm_3 -wmp_4-s_1167742845.png "title=" 15.png "alt=" Wkiol1hg2prridcxaaee3iqmbhk464.png-wh_50 "/>

Step 10: Go to the Installation progress bar interface

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/8C/0E/wKioL1hg2TSCr8x5AAD6xUsH4No150.png-wh_500x0-wm_3 -wmp_4-s_2243011742.png "title=" 16.png "alt=" Wkiol1hg2tscr8x5aad6xush4no150.png-wh_50 "/>

Step 11: Progress to 95% will pop up an interface (DATABASE CONFIGURATION ASSISTANT), and then please wait

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/8C/12/wKiom1hg3SbQi7yaAAEk7WDxlfg687.png-wh_500x0-wm_3 -wmp_4-s_3034992383.png "title=" 111.png "alt=" Wkiom1hg3sbqi7yaaaek7wdxlfg687.png-wh_50 "/>

Step 12: Progress to 100% will prompt password Managerment interface

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/8C/13/wKiom1hg4ovQhp1rAAGgQiJneQo983.png-wh_500x0-wm_3 -wmp_4-s_2519894329.png "style=" Float:none; "title=" 222.png "alt=" Wkiom1hg4ovqhp1raaggqijneqo983.png-wh_50 "/>

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/8C/0F/wKioL1hg4oyx4VakAAGzZ5nQ-_c936.png-wh_500x0-wm_3 -wmp_4-s_2817250713.png "style=" Float:none; "title=" 333.png "alt=" Wkiol1hg4oyx4vakaagzz5nq-_c936.png-wh_50 "/>

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/8C/10/wKioL1hg6GDSsw7lAAEryxJnumY032.png-wh_500x0-wm_3 -wmp_4-s_338312823.png "title=" 444.png "alt=" Wkiol1hg6gdssw7laaeryxjnumy032.png-wh_50 "/>

Click Password managerment To configure the password:

Set the user password, note the new password and Confirm password two columns to set: The system password can be set to 123456, then click OK, the prompt to choose Yes

Step 13: Execute the path script under the root user, then click OK to confirm

sh/opt/oracle/orainventory/orainstroot.sh

sh/opt/oracle/product/11gr2/db/root.sh

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/8C/11/wKioL1hg6LTCJwlfAAD5W8dLli8354.png-wh_500x0-wm_3 -wmp_4-s_3659014112.png "title=" 555.png "alt=" Wkiol1hg6ltcjwlfaad5w8dlli8354.png-wh_50 "/>

Step 14: Install complete

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/8C/14/wKiom1hg6amiaKv7AADCFnZofZo088.png-wh_500x0-wm_3 -wmp_4-s_941368154.png "title=" 666.png "alt=" Wkiom1hg6amiakv7aadcfnzofzo088.png-wh_50 "/>

Third, set up monitoring and start the Oracle database

2. Set the listener to modify the/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)

   )

   )

4. Open | close | View monitoring:

   Lsnrctl Start|stop|status

6. Connection Database command:

   (1) Sqlplus/as SYSDBA

   (2) Sqlplus/nolog

   Sql> Connect/as SYSDBA

8. Open | close | Close the database now:

   Startup

   Shutdown

   Shutdown immediate

10. Sql> select * from All_users; (View all users of the system)

12. Sql> SELECT * from dba_users; (View all users of Oracle database (SYSDBA))

14. Sql> select * from tab; (View all tables of the system)

16. Sql> select * from V$version; (view current version)

18. Sql> Show User (view current users)

20. Sql> select status from V$instance; (see if the installation was successful)

Installation of ORACLE_11G_R2 in SUSE_11_X64_SP4 environment