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.2Information 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/