000022695 - Syntax errors appear  Oracle database creation fails when running the setup.bat file to create the database schema when running on a Windows client

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000022695
Applies ToMicrosoft Windows
Oracle
setup.bat
IssueSyntax errors appear, Oracle database creation fails when running the setup.bat file to create the database schema when running on a Windows client
CauseThe 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.
ResolutionEdit 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.
Legacy Article IDa31610

Attachments

    Outcomes