My Oracle Support Banner

Siebel EncryptUpg Utility Execution To Upgrade To Higher Encryption Fails With "SBL-DBC-00107: An Oracle database error has occurred." Error (Doc ID 2930904.1)

Last updated on MARCH 17, 2023

Applies to:

Siebel CRM - Version 8.1.1.1 [21211] and later
Information in this document applies to any platform.

Symptoms

When attempting to execute encryptupg utility to increase the encryption strength manually, the utility fails to execute and the following errors are seen when running the utility manually from command prompt:

encryptupg /f RC2 /t AES /j /xxx/xxx/xxx/xxx/xxx/encryptupg.inp /l ENU /u username /p xxxx /c /xx/xx/xx/siebsrvr/bin/enu/siebel.cfg
....
An Oracle database error has occurred.
Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00107)ORA-12154: TNS:could not resolve the connect identifier specified
Cleaning up... this may take a while.

In the generatred encryptupg.log under $SIEBEL_ROOT/siebsrvr/log directory, below errors were seen

2021 2023-01-27 09:46:22 2023-01-27 09:46:22 -0600 00000005 001 003f 0001 09 encryptupg 2032081 -175732992 /xx/xxx/xxx/siebsrvr/log/encryptupg.log
GenericLog      GenericError    1       0000000263d301d1:0      2023-01-27 09:46:22     Start object definition loading.
ObjMgrLog       Error   1       0000000263d301d1:0      2023-01-27 09:46:22     (oracon.cpp (5028)) SBL-DBC-00107: An Oracle database error has occurred. Please continue or ask your systems administrator to check your application configuration if the problem persists.

Steps To Replicate:

1. Verify that the input file encrypt_colums.inp under $SIEBEL_ROOT/siebsrvr/bin directory includes all the columns for upgrade
2. Run encryptupg.exe by navigating to $SIEBEL_ROOT/siebsrvr/bin and entering the following command:

encryptupg.exe /f FromEncrytionStrength /t ToEncryptionStrength /j InputFileName /l Language /u UserName /p Password /c ConfigurationFile /L LogFile

3. Check to see if the encryption upgrade is executed successfully for the columns in the input file

 

Changes

Upgrade from lower version (RC2) to higher version (AES) when upgrade does not execute the encryption and a manual execution is needed to encrypt to AES.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.