Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 )

最新推荐文章于 2022-01-26 17:47:58 发布

原创最新推荐文章于 2022-01-26 17:47:58 发布 · 9.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #oracle #patch #server #command #access

ORACLE Management 专栏收录该内容

78 篇文章

订阅专栏

本文档介绍了在11.2格栅基础设施上创建数据库时，当设置角色分离时可能遇到的问题及解决步骤。涉及ORA-15025, KFSG-00312, ORA-15081错误。创建11.2数据库前，需要确保用户权限和组设置正确，并可能需要应用特定补丁。" 103542407,5103777,微服务架构详解：从概念到实践,"['微服务架构', '分布式系统', '软件工程', '开发模式', '服务拆分']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Database Creation on 11.2 Grid Infracture with Role Separation ( ORA-15025, KFSG-00312, ORA-15081 ) [ID 1084186.1]

In this Document
Goal
Fix
References
Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 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.

Fix

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 after shutting down the GI ( clusterware and ASM instance ):

$ 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 after shutting down the GI ( clusterware and ASM instance ):

$ 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

References

BUG:9575578 - KFSG-00312: NOT AN ORACLE BINARY, USING SETASMGIDWRAP

Related

Products

Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition > STORAGE > ASM Administration, Errors

Keywords

ASM;DBCA;GRID;INFRASTRUCTURE;ORACLE RESTART;RESTART;SRVCTL

Errors

ORA-15025;ORA-15081

Back to Top