ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle 11gR2 Database dbca ORA-03114 not Connected to Oracle

Oracle 11gR2 Database dbca ORA-03114 not Connected to Oracle

原创 Linux操作系统 作者:尛样儿 时间:2011-06-18 17:36:32 0 删除 编辑
DBCA Is Failing With ORA-03114 While Installing/Configuring Database Vault [ID 1227004.1]

  修改时间 04-OCT-2010     类型 PROBLEM     状态 MODERATED  

In this Document
  Symptoms
  Cause
  Solution
  References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Database Vault - Version: 11.1 to 11.2.0.2 - Release: to 11.2
Information in this document applies to any platform.

Symptoms

You may be configuring database vault using DBCA and the DBCA is failing with "ORA-03114: not connected to ORACLE " .

Cause

At this point there are two scenarios identified that are causing this behavior.:

1.) Database vault triggers are not disabled properly while patching the database or while reconfiguring the database .

2.) SQLNET encryption is active on the problematic database.

Solution

1.)When ever database triggers needs to be disabled , they have to be called with their qualified name :
ALTER TRIGGER DVSYS.DV_BEFORE_DDL_TRG DISABLE;

But not :
"ALTER TRIGGER DV_BEFORE_DDL_TRG DISABLE;"

2.) Disable the encryption parameters in the SQLNET.ORA[If active].
Use DBCA to configure network encryption and than Enable the encryption parameters once database vault is configured.

References

BUG:7503070 - CANNOT ADD DATABASE VAULT OPTION TO 11.1.0.7 UISNG DBCA, GETTING ORA-03114

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

请登录后发表评论 登录
全部评论
Oracle数据库管理员,Oracle数据库系统构架员;2012年7月出版《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》一书;Oracle 10g OCM。

注册时间:2010-01-05

  • 博文量
    483
  • 访问量
    5427788