Saturday, April 27, 2019

Siebel Install Database Error: set_unicode.sql not found

When doing a fresh install of Siebel version IP19.2 on an Oracle Linux 7.6 server, I faced the following error during the database installation:

UpgradeLog UpgradeInfo 3 0000000254e42d16:0 2019-04-18 19:28:43 Status Message (Executing SQL statements in file /opt/siebel/ses/dbsrvr/oracle/set_unicode.sql ...)
Trace Trace 3 0000000254e42d16:0 2019-04-18 19:28:43 Unable to open file 'set_unicode.sql'.

After a long night of research I figured out that this error was caused by a error that happened during the Siebel binaries installation, as seen in the $SIEBEL_ROOT/cfgtoollogs/oui path:

$ ls -ltr *.err

I found non-zero .err files, so taking a closer look to these files, this is what I found:

java.io.IOException: Cannot run program "/bin/csh": error=2, No such file or directory at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048)


With the above error message I was able to identify that the root cause of the error was the lack of c shell installation on my server, so I simply ran:

yum install tcsh

It is important to note that, after installing the c shell lib, I re-installed Siebel from scratch and everything ran smoothly =)

No comments:

Post a Comment