Siebel Database Upgrade Guide > Preparing an Oracle Database for a Siebel Upgrade >

Verifying Oracle Database Sort Order for a Siebel Upgrade

Upgrades from: All Supported Siebel releases.

Environments: Development, production test, production.

Databases: Oracle only.

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

The NLS_SORT parameter determines the sort order of query returns. NLS_SORT must be set to BINARY for the development environment upgrade, including the repository merge. It must also be set to BINARY when using Siebel Tools to compile an SRF file.

This setting is strongly recommended for production test environment upgrades and production upgrades.

To verify that your database is using binary sort order

  1. Run SQLPlus to connect to the Oracle Database.
  2. Issue the following query:


  3. In the returned parameters, locate NLS_SORT and verify that its value is BINARY.
    • If NLS_SORT has a value of BINARY, then the sort order is binary and no action is required.
    • If NLS_SORT is anything other than BINARY, reset the value to BINARY.
Related Topics

About Database Sort Order in the Siebel Environment

Siebel Database Upgrade Guide Copyright © 2008, Oracle. All rights reserved.