SBL-GDB-00004: Error in Main function.

Error While Generating a New Database

Error While Generating a New Database
SBL-GDB-00004: Error in Main function.
Error Details:
Executing  “Generate New Database” Job resulted in following error.
SBL-GDB-00004: Error in Main function
Reason:
We increased the log level for Generate New Database Component and analyzed the generated logs. In logs we found the following information
Trace TracingInfo 3 0 2009-04-28 02:37:54 Copying template /siebdir/sieb78/siebsrvr/dbtempl/sse_utf8.dbf
to /siebdir/sieb78/siebsrvr/dbtempl/db42r53.682/sse_utf8.dbf...
GenericLog GenericError 1 0 2009-04-28 02:37:54 Error creating SQL Anywhere database template file (UTLFileCopy szTemplFileName -> szWatcFileName).
Solution:
Further analysis revealed that sse_utf8.dbf file was not present in  /siebsrvr/dbtempl. After going through bookshelf and metalink we came to conclusion that there are two files that should be present in /siebsrvr/dbtempl/ folder
    sse_utf8.dbf
    sse_encr.dbf
We copied these files from other server and exectued “Generate New Database” Job and it ran successfully.

No comments:

How to add a datafile to a bigfile tablespace in Oracle 23ai Database.

  Syntax for Bigfile Tablespace: SQL > ALTER TABLESPACE tablespace_name ADD DATAFILE SIZE 10G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; Ho...