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
  
  
  
  

---

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

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