Syntax errors appear Oracle database creation fails when running the setup.bat file to create the database schema when running on a Windows client
2 years ago
Originally Published: 2006-08-29
Article Number
000057882
Applies To
Microsoft Windows
Oracle
setup.bat
Issue
Syntax errors appear, Oracle database creation fails when running the setup.bat file to create the database schema when running on a Windows client
Cause
The problem occurs when setup.bat invokes the Oracle SQL-Plus client which in turn invokes "runme3.sql", which in turn invokes "msg_code_keys.sql". SQL-Plus behavior is different when running the "msg_code_keys.sql" file on Linux and Windows. The "msg_code_keys.sql" file fails to execute because certain variables have not been replaced by the substitute value.
Resolution
Edit the file "runme3.sql" in the Oracle setup directory, moving the line

   @categories.sql &4

from where it is (line 8) to the next-to-last line, just before the line:

   @quitprog.sql

then rerun setupdb.bat.