Database Creation on 11.2 Grid Infrastructure with Role Separation
本文轉自 metalink ID 1084186.1
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.
Goal
This document discusses the necessary steps to take before creating a 11.2 / 11.1 / 10.2 database with 11.2 Grid Infrastructure when Role Separation is in place.
Solution
In case of role separation we typically have the following groups and users:
Grid Infrastructure Home Owner : grid
Primary Group : oinstall
Secondary Groups : asmadmin, asmdba, asmoper
RDBMS Home Owner : oracle
Primary Group : oinstall
Secondary Groups : dba, oper, asmdba
In case of stand alone set up, if the 11.2 Database be managed by
Oracle Restart ( srvctl stop/start ), then 'grid' user should also be a
part of 'dba' group.
The ASM Disks would be owned by grid:asmadmin
11.2 Database
If we use 11.2 DBCA to create the database, everything will go through fine. If we create the 11.2 database manually, then before creating the database we need to run the following command:
$ su - grid
$ cd <Grid Home>/bin
$ ./setasmgidwrap o=<11.2 RDBMS Home>/bin/oracle
If we do not do this, database creation will fail with ORA-15025 as it will not be able to access the ASM Disks.
Pre11.2 Database
For pre11.2 Databases ( 11.1 and 10.2 ), whether creating the database using DBCA or manually, apply Patch 9575578 to the 11.2 Grid Home. After applying the patch run the following commands:
$ su - grid
$ cd <Grid Home>/bin
$ ./setasmgidwrap o=<11.1/10.2 RDBMS Home>/bin/oracle
Without the patch script setasmgidwrap will fail with KFSG-00312
Note: Bug 9575578 is fixed in 11.2.0.2 GI release
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/21754115/viewspace-1755063/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Pre 11.2 Database Issues in 11gR2 Grid Infrastructure Environment_948456.1DatabaseASTStruct
- 【MOS】How to backup or restore OLR in 11.2/12c Grid InfrastructureRESTASTStruct
- oracle linux 11.2 rac grid infrastructure add scan ipOracleLinuxASTStruct
- redhat linux 11.2 rac grid infrastructure add scan ipRedhatLinuxASTStruct
- backup or restore OLR in 11.2 Grid Infrastructure (Doc ID 1193643.1)RESTASTStruct
- 【轉】How to recover from root.sh on 11.2 Grid Infrastructure FailedASTStructAI
- Database Creation on 11.2 Grid Infracture( ORA-15025, KFSG-00312, ORA-15081 )Database
- 11g oracle database installation with oracle grid infrastructure on linux(文件)OracleDatabaseASTStructLinux
- Laravel workflow with database and roleLaravelDatabase
- Oracle Grid Infrastructure for a Standalone ServerOracleASTStructServer
- clone grid INfrastructure Home and clusterwareASTStruct
- Oracle Clusterware and Oracle Grid InfrastructureOracleASTStruct
- How to Troubleshoot Grid Infrastructure Startup IssuesASTStruct
- Oracle grid infrastructure 解除安裝OracleASTStruct
- Troubleshooting Database Creation (121)Database
- DNS and DHCP Setup Example for Grid Infrastructure GNSDNSASTStruct
- 記錄下 patch Grid Infrastructure for StandaloneASTStruct
- Oracle Grid Infrastructure Patch Set Update 11.2.0.4.3OracleASTStruct
- 認識SQL Server2000 Server Role 和 Database RoleSQLServerDatabase
- 重新配置 11gR2 Grid InfrastructureASTStruct
- oracle 10g physical standby database creationOracle 10gDatabase
- 【MOS】Top 5 Grid Infrastructure Startup Issues (文件 ID 1368382.1)ASTStruct
- Apply PSU for Grid Infrastructure Standalone and DB with Oracle RestartAPPASTStructOracleREST
- 升級Grid Infrastructure到10.2.0.2 遭遇bug 9413827ASTStruct
- Specifying Oracle-Managed Files at Database Creation (76)OracleDatabase
- How to Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]ASTStruct
- Troubleshoot Grid Infrastructure Startup Issues (Doc ID 1050908.1)ASTStruct
- manual database creation for oracle10g on solaris10DatabaseOracle
- Supporting Bigfile Tablespaces During Database Creation (77)Database
- 【GRID】Grid Infrastructure 啟動的五大問題 (Doc ID 1526147.1)ASTStruct
- Oracle 12c Grid Infrastructure for a Standalone Server on Oracle Linux 7OracleASTStructServerLinux
- Master Note for RAC Oracle Clusterware and Oracle Grid Infrastructure 1096952.ASTOracleStruct
- [INS-40406] The installer detects no existing Oracle Grid Infrastructure ...OracleASTStruct
- 聊聊兩種給Grid Infrastructure打補丁的方法(上)ASTStruct
- 聊聊兩種給Grid Infrastructure打補丁的方法(下)ASTStruct
- 【RAC】How to Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]ASTStruct
- Deconfigure/Reconfigure(Rebuild OCR) or Deinstall Grid InfrastructureRebuildASTStruct
- 為11gR2 Grid Infrastructure增加新的public網路ASTStruct