Enforce upgrade to v11 fails with java.sql.SQLException: ORA-06550

Products

• Data Loss Prevention Enforce

Issue/Introduction

Upgrading Enforce to v11 fails with the following error:

Database upgrade failed due to SQL exception:
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'UPGRADESCHEMA_V11_0_0.MAIN_DRIVER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

Database upgrade failed due to SQL exception:
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'UPGRADESCHEMA_V12_5_0.MAIN_DRIVER' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Resolution

 

The schema upgrader is failing to connect to the database using sqlplus with the connection string configured in the config file Jdbc.properties. Ensure the connection string syntax is correct by using it to manually connect using sqlplus like the example below. This issue was seen with a customer connecting to a database running on Oracle RAC where there were spaces in the jdbc string, as well as missing parameters when compared to the tnsnames.ora file.  In another case the TNSNames file was pointing to a machine name, where as the jdbc.properties was pointing to 127.0.0.1.  In this case the issue was resolved by changing jdbc.properties to use the machine name.

sqlplus -L protect/[email protected](description=(address=(host=127.0.0.1)(protocol=tcp)(port=1521))(connect_data=(sid=protect)))