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 =)