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博客

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

Applies to:

Symptoms

Cause

Solution

References

最新文章