如何進行Oracle11gR2+ASM的安裝

如何進行Oracle11gR2+ASM的安裝，很多新手對此不是很清楚，為了幫助大家解決這個難題，下面小編將為大家詳細講解，有這方面需求的人可以來學習下，希望你能有所收獲。

說明：本想將安裝過程中的所有截圖一同發布，可惜的是這里的日志中不好粘貼圖片，所以安裝過程中的截圖將以打包的形式發布，請各位諒解！鏈接地址：http://space.itpub.net/25881373/viewspace-702460

（6）       安裝grid軟件

注意：這一步中，必須是以grid用戶登錄操作，而不能從其他用戶su命令切換到grid上。

[grid@AS5 u02]$ unzip linux_11gR2_grid.zip

[grid@AS5 u02]$ cd grid/

[grid@AS5 grid]$ export DISPLAY=172.24.0.1:0.0

[grid@AS5 grid]$ ./runInstaller

圖1至圖10 （打包在grid_setup.rar中）

http://space.itpub.net/25881373/viewspace-702460

[root@AS5 u02]# /u02/app/oraInventory/orainstRoot.sh

Changing permissions of /u02/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /u02/app/oraInventory to oinstall.

The execution of the script. is complete.

[root@AS5 u02]# /u02/app/grid/11.2.0/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u02/app/grid/11.2.0

Enter the full pathname of the local bin directory: [/usr/local/bin]:

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

2011-07-15 11:56:31: Checking for super user privileges

2011-07-15 11:56:32: User has super user privileges

2011-07-15 11:56:32: Parsing the host name

Using configuration parameter file: /u02/app/grid/11.2.0/crs/install/crsconfig_params

Creating trace directory

LOCAL ADD MODE

Creating OCR keys for user 'grid', privgrp 'oinstall'..

Operation successful.

CRS-4664: Node as5 successfully pinned.

Adding daemon to inittab

CRS-4123: Oracle High Availability Services has been started.

ohasd is starting

as5     2011/07/15 11:57:46     /u02/app/grid/11.2.0/cdata/as5/backup_20110715_115746.olr

Successfully configured Oracle Grid Infrastructure for a Standalone Server

Updating inventory properties for clusterware

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 2000 MB    Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u02/app/oraInventory

'UpdateNodeList' was successful.

至此，grid安裝完畢。

[root@AS5 install]# ps -ef | grep ASM

grid     30172     1  0 15:23 ?        00:00:00 asm_pmon_+ASM

grid     30174     1  0 15:23 ?        00:00:00 asm_vktm_+ASM

grid     30178     1  0 15:23 ?        00:00:00 asm_gen0_+ASM

grid     30180     1  0 15:23 ?        00:00:00 asm_diag_+ASM

grid     30182     1  0 15:23 ?        00:00:00 asm_psp0_+ASM

grid     30184     1  0 15:23 ?        00:00:00 asm_dia0_+ASM

grid     30186     1  0 15:23 ?        00:00:00 asm_mman_+ASM

grid     30188     1  0 15:23 ?        00:00:00 asm_dbw0_+ASM

grid     30190     1  0 15:23 ?        00:00:00 asm_lgwr_+ASM

grid     30192     1  0 15:23 ?        00:00:00 asm_ckpt_+ASM

grid     30194     1  0 15:23 ?        00:00:00 asm_smon_+ASM

grid     30196     1  0 15:23 ?        00:00:00 asm_rbal_+ASM

grid     30198     1  0 15:23 ?        00:00:00 asm_gmon_+ASM

grid     30200     1  0 15:23 ?        00:00:00 asm_mmon_+ASM

grid     30202     1  0 15:23 ?        00:00:00 asm_mmnl_+ASM

創建完成ASM實例后，需要用grid用戶進行：

[grid@AS5 utl]$ crsctl modify resource "ora.cssd" -attr "AUTO_START=1"

[grid@AS5 utl]$ crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"

（7）       創建ASM磁盤組

SQL> select name,state,type,total_mb,usable_file_mb from v$asm_diskgroup;

NAME    STATE       TYPE     TOTAL_MB USABLE_FILE_MB

-------- ----------- ------ ---------- --------------

DATA01 MOUNTED     NORMAL         8610           4185

SQL> select name,header_status,mount_status,state,path from v$asm_disk;

NAME    HEADER_STATU MOUNT_S STATE    PATH

-------- ------------ ------- -------- -----------

        PROVISIONED      CLOSED  NORMAL   ORCL:VOL04

VOL01    MEMBER       CACHED  NORMAL   ORCL:VOL01

VOL02    MEMBER       CACHED  NORMAL   ORCL:VOL02

VOL03    MEMBER       CACHED  NORMAL   ORCL:VOL03

SQL> create diskgroup flash_recover_area external redundancy disk 'ORCL:VOL04';

Diskgroup created.

SQL> select name,state,type,total_mb,usable_file_mb from v$asm_diskgroup;

NAME               STATE   TYPE     TOTAL_MB USABLE_FILE_MB

------------------- ----------- ------ ---------- --------------

DATA01            MOUNTED    NORMAL           8610         4185

FLASH_RECOVER_AREA  MOUNTED  EXTERN            1913         1863

3．安裝oracle數據庫軟件

（1）將oracle數據庫軟件上傳到主機上，然后用oracle身份解壓：

[oracle@AS5 u01]$ ll

total 3188280

drwxrwxr-x 3 oracle oinstall       4096 Jul 14 18:30 app

-rwxrwxr-x 1 oracle oinstall 1285396902 Jul 14 18:49 linux_11gR2_database_1of2.zip

-rwxrwxr-x 1 oracle oinstall  995359177 Jul 14 18:46 linux_11gR2_database_2of2.zip

 [oracle@AS5 u01]$ unzip linux_11gR2_database_1of2.zip

[oracle@AS5 u01]$ rm linux_11gR2_database_1of2.zip

[oracle@AS5 u01]$ unzip linux_11gR2_database_2of2.zip

[oracle@AS5 u01]$ rm linux_11gR2_database_2of2.zip

[oracle@AS5 u01]$ chmod -R 775 database/

（2）安裝oracle

注意：這一步中，必須是以oracle用戶登錄操作，而不能從其他用戶su命令切換到oracle上。

[oracle@AS5 u01]$ cd database/

[oracle@AS5 database]$ pwd

/u01/database

[oracle@AS5 database]$ ll

total 40

drwxrwxr-x 12 oracle oinstall 4096 Aug 17  2009 doc

drwxrwxr-x  4 oracle oinstall 4096 Aug 14  2009 install

drwxrwxr-x  2 oracle oinstall 4096 Aug 14  2009 response

drwxrwxr-x  2 oracle oinstall 4096 Aug 14  2009 rpm

-rwxrwxr-x  1 oracle oinstall 4352 Aug 14  2009 runInstaller

drwxrwxr-x  2 oracle oinstall 4096 Aug 14  2009 sshsetup

drwxrwxr-x 14 oracle oinstall 4096 Aug 14  2009 stage

-rwxrwxr-x  1 oracle oinstall 5400 Aug 18  2009 welcome.html

[oracle@AS5 database]$ export DISPLAY=172.24.0.1:0.0

[oracle@AS5 database]$ ./runInstaller

安裝過程截圖11至圖20（打包在oracle_setup.rar中）

http://space.itpub.net/25881373/viewspace-702460

[root@AS5 install]# /u01/app/oracle/product/11.2.0/db_1/root.sh

Running Oracle 11g root.sh script...

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying dbhome to /usr/local/bin ...

The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying oraenv to /usr/local/bin ...

The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)

[n]: y

   Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

至此，oracle數據庫軟件已經安裝完畢。

4．建庫

[oracle@AS5 database]$ echo $ORACLE_SID

ora10

[oracle@AS5 database]$ export DISPLAY=172.24.0.1:0.0

[oracle@AS5 database]$ dbca

圖21至圖32（打包在dbca.rar中）

http://space.itpub.net/25881373/viewspace-702460

完成上面的操作，數據庫即創建完成。

SQL> select file_name from dba_data_files;

FILE_NAME

--------------------------------------------------------------------------------

+DATA01/ora10/datafile/users.259.756577629

+DATA01/ora10/datafile/undotbs1.258.756577629

+DATA01/ora10/datafile/sysaux.257.756577629

+DATA01/ora10/datafile/system.256.756577627

+DATA01/ora10/datafile/example.265.756577983

看完上述內容是否對您有幫助呢？如果還想對相關知識有進一步的了解或閱讀更多相關文章，請關注億速云行業資訊頻道，感謝您對億速云的支持。