千家信息网

如何进行Oracle11gR2+ASM的安装

发表于:2025-02-03 作者:千家信息网编辑
千家信息网最后更新 2025年02月03日,如何进行Oracle11gR2+ASM的安装,很多新手对此不是很清楚,为了帮助大家解决这个难题,下面小编将为大家详细讲解,有这方面需求的人可以来学习下,希望你能有所收获。说明:本想将安装过程中的所有截
千家信息网最后更新 2025年02月03日如何进行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

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

0