如何进行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

看完上述内容是否对您有帮助呢?如果还想对相关知识有进一步的了解或阅读更多相关文章,请关注创新互联行业资讯频道,感谢您对创新互联的支持。


网站标题:如何进行Oracle11gR2+ASM的安装
本文网址:http://cdiso.cn/article/gpppsj.html

其他资讯