When attempting to use Database Partitioning, either during installation or by activating it in the data_engine GUI, an error may occur. ?The error reported may be ORA-06650, and/or PLS-00905, and may be accompanied by an error similar to "object AUTO_10_238_4_69.SPN_DE_DATAMAINT is invalid."
Example message from data_engine.log or iaoutput.txt installation log:
? ? ? OCIEnv: 0xfff100 OCIAuthInfo: 0x1021690 OCISvcCtx: 0x1020148
?- Error: ExecuteSP [Admin] data_engine [Admin Classic] status: -1
????? OCI_ERROR - ORA-06550: line 1, column 7:
PLS-00905: object AUTO_10_238_4_69.SPN_DE_DATAMAINT is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
This error message indicates that one or more of the required database permissions has not been applied to the database user. ?The permissions have changed in CAUIM 8.0 compared to previous versions, so it's important to double-check and make sure all of the appropriate permissions have been correctly applied. ?Please refer to the NMS 8.0 installation guide for details regarding the necessary permissions.
Specifically, prior to installation you will want to "grant execute on dbms_redefinition" to the user that is being used for the DB credentials.
To correct this situation after installation, use the following procedure to grant the appropriate permissions and then you will have to recompile the stored procedures.
Follow these steps:
1. ? ? ? Log in to the database server as SYSDBA and execute:
grant execute on dbms_redefinition to <NMS USER>;
2. ? ? ? Use a tool such as Oracle SQL Developer to recompile the following stored procedures: