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