Bookshelf Home | Contents | Index | PDF     

Upgrade Guide > Postupgrade Tasks for the Siebel Database and File System >

Verifying an Upgraded Oracle RDBMS After a Siebel Upgrade

Upgrades: All Siebel upgrades.

Environments: Development, production test, production.

Databases: Oracle only.

This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade.

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, you must run the Siebel ddlimp utility to verify the schema layout of the upgraded database.

This also converts the Siebel Database to character-based length for char and varchar data. For additional information about the following procedure, see Alert 1053 on Oracle's Siebel SupportWeb.

To verify the upgraded Oracle RDBMS

  1. 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

  2. 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).
  3. After the command completes, review the output logs for errors. If the log indicates there are errors, contact Oracle's Siebel Technical Support.
    
Upgrade Guide Copyright © 2006, Oracle. All rights reserved.