Upgrading the Oracle database for HCL Docs
Learn how to upgrade the Oracle database for HCL Docs.
Procedure
- Log in to the Oracle database system.
- The SQL scripts are in the DocsApp/oracle directory (versus
the DocsApp/setupDB directory for DB2®).
If the database server and HCL Docs are installed
on different systems, copy the SQL scripts to the system that hosts
the database server, using the instructions provided for DB2® in the previous topic (replacing "setupDB"
with "oracle"). Note: Make sure that the user ID has Write privileges for the directory of these scripts.
- Linux™: Switch to
the Oracle user:
su - oracle
- Set
ORACLE_SID
to the Oracle database name that you created withDBCA
.- Windows™:
set ORACLE_SID=idocs
- Linux™:
export ORACLE_SID=idocs
Note: Ensure that the SID is correct or the upgrade process will not work. - Windows™:
- Make sure the Oracle server is started.
- Run one of the following scripts to update the database
schema:
- Windows™:
updateDBSchema.bat
- Linux™:
. ./updateDBSchema.sh
- Windows™: