Verify that you are running the Oracle Database installation SQL script on a Windows based computer. If your Oracle Database is hosted by a Unix server, you must run the Oracle Database installation SQL script on a Windows client that can remotely access the database server using Oracle’s SQL*Plus.
-
Copy the
database.zip file from the Database Server installation media to the temp directory you created and extract the ZIP file.
-
Open the
define.migration file in Notepad.
-
Set the value to the right of the equals sign for the following ID or passwords in the
define.migration file you are editing.
Only define the settings from this list that are already present in the
define.migration file. Do not add any setting to the file from this list.
- define
sid=name of the database instance for the existing
LIQUENT InSight database
- define
orapath=database files location
D:\oracle\oraXX\insight or
\apps\oracle\oradata\insight
Note: To prevent connection errors when modifying database execution scripts, because the @ symbol is a value in the Oracle database connection string, enter database passwords containing the character @ using quotes.
Password
abc@123 should be entered as
'"abc@123"' (single quotes, double quotes, password, double quotes, single quotes).
-
Open the
command prompt, type:
sqlplus/nolog and press Enter.
-
In the
sqlplus prompt, type
@master.sql and press Enter.
-
Once the script is complete, check the database log file for errors.
This file is generated in the directory where the build script was executed, and should be found in the same directory created previously.
Note: In case of errors, refer to the
Database Script Error Messages topic.
D:\install\InSightDBUpgrade1\DBupgrade
-
Optional Step:
- Open the
define.passwords.alternate file in Notepad and update passwords values if needed. Save and close file.