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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23135684/viewspace-700182/