Oracle Error ORA-12650 when starting Master

Document ID : KB000085049
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ErrorMsg: AwE-5001 Database Query Error (12/4/15 9:32 AM)
Details: null
java.sql.SQLException: Oracle Error ORA-12650

When starting the Applications Manager (AM) processes the following error is seen in the RmiServer.log and the RmiServer process fails to start.
 
ErrorMsg: AwE-5001 Database Query Error (12/4/15 9:32 AM)
Details: null
java.sql.SQLException: Oracle Error ORA-12650
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at java.sql.DriverManager.getConnection(DriverManager.java:571)


 
Environment:
OS Version: N/A
Cause:
Cause type:
Configuration
Root Cause: This is an Oracle error which occurs when the client and server have no algorithm in common for the encryption, data integrity or both.
Resolution:
The default net.encryption_types_client variable for Applications Manager can be changed by defining it in the $AW_HOME/site/awenv.ini.

This needs to be added the following under the [default] section of the file.

net.encryption_types_client=AES256

Note: This is an example of setting AES256. Other encryption types can be added to the variable as well.

Ensure the master is on a version of Java which supports the higher encryption (1.8).
 
Once in place the Application Manager back end processes will need to be stopped and restarted.

The setting can be confirmed by looking in the RmiServer log with debug enabled. The line will look as follows:

08:50:42.914 main: .AwEnvOptions: net.encryption_types_client = AES256
08:50:42.915 main: .AwEnvOptions: using default: net.crypto_checksum_types_client = MD5
08:50:42.915 main: .AwEnvOptions: net.crypto_checksum_types_client = MD5
08:50:43.177 main: .AxConnection: inUse (sync) null AM9 false
08:50:43.178 main: .AxConnection: inUse (sync) done null AM9

Applications Manager version 9.1 allows for stronger encryption if using Java 8 or above. It is advised to update to java 1.8 along with implementing the encryption changes to the awenv.ini as noted above.

 

Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A