Upgrading the Oracle database for IBM Docs
Learn how to upgrade the Oracle database for IBM 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 IBM 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: