ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Database Creation on 11.2 Grid Infracture with Role Separation

Database Creation on 11.2 Grid Infracture with Role Separation

原创 Linux操作系统 作者:lhl1212 时间:2011-04-10 01:08:03 0 删除 编辑
Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 ) [ID 1084186.1]

  修改时间 04-FEB-2011     类型 HOWTO     状态 PUBLISHED  

In this Document
  Goal
  Solution
  References


Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information 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 /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:

$ su - grid
$ cd /bin
$ ./setasmgidwrap o=<11.1/10.2 RDBMS Home>/bin/oracle

Without the patch script. setasmgidwrap will fail with KFSG-00312

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/611609/viewspace-692173/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-12-08

  • 博文量
    252
  • 访问量
    496722