|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.|
Oracle Database Vault - Version: 11.1 to 184.108.40.206 - Release: to 11.2
Information in this document applies to any platform.
You may be configuring database vault using DBCA and the DBCA is failing with "ORA-03114: not connected to ORACLE " .
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.
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.
- CANNOT ADD DATABASE VAULT OPTION TO 220.127.116.11 UISNG DBCA, GETTING ORA-03114
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23135684/viewspace-700182/，如需转载，请注明出处，否则将追究法律责任。