Bookshelf Home | Contents | Index | PDF     

Siebel Database Upgrade Guide > Postupgrade Tasks for the Siebel Database >

Verifying an Upgraded Oracle RDBMS After a Siebel Upgrade

Environments: Development, production test, 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. For additional information about the following procedure, see 477966.1 (Article ID) My Oracle Support.

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 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.
Related Topics

About Upgrading Your RDBMS in the Siebel Environment

    
Siebel Database Upgrade Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.