Verifying an Upgraded Oracle Database After a Siebel Upgrade

Environments: Development, Test and Production.

Databases: Oracle only.

You can upgrade your RDBMS before or after upgrading to the current Siebel release.

If you upgrade your Oracle RDBMS after upgrading to the current Siebel release, then you must run the Siebel ddlimp utility to verify the schema layout of the upgraded database.

Note: The upgphys process might recreate descending (DESC) indexes as ascending (ASC) indexes. To recreate descending indexes, use the /9 option while running ddlimp.

This also converts the Siebel database to character-based length for char and varchar data.

To verify the upgraded Oracle Database

On the Siebel Server where the Siebel Database Server files are installed, navigate to the following location:
Windows: SIEBEL_ROOT\bin
UNIX: $SIEBEL_ROOT/bin
Run the following command:
```
ddlimp /u TableOwner /p TablePassword /c "ODBCDataSource" /f DBSRVR_ROOT/DatabasePlatform/schema.ddl /t y /i n /e n /B TableSpace /X IndexSpace /G SSE_ROLE
/R Y /l SiebelLogDir/ddlctl_verify_RDBMS.log
```
where:
- TableOwner is the Siebel table owner name, also called the schema qualifier name.
- TablePassword is the Siebel table owner password.
- ODBCDataSource is the ODBC name for connecting to the database. Enclose the name in quotes.
- DBSRVR_ROOT is the absolute path to the Siebel Database Server installation directory.
- DatabasePlatform is the Siebel Database Server directory for the Oracle Database.
- Tablespace is the Oracle tablespace name for the Siebel database.
- IndexSpace is the Oracle index space name for Siebel database.
- SiebelLogdir is the path to the directory where you want the output log placed (log output directory).
After the command completes, review the output log files for errors. If the log indicates there are errors, then create a service request (SR) on My Oracle Support. Alternatively, you can phone Global Customer Support directly to create a service request or get a status update on your current SR. Support phone numbers remain the same and are listed on My Oracle Support.

To verify the upgraded Oracle Database

Related Topic