1. Database Upgrade Guide
  2. Verifying Oracle Database Sort Order for a Siebel Upgrade

Verifying Oracle Database Sort Order for a Siebel Upgrade

Environments: Development, Test and Production.

Databases: Oracle only.

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 publish the Siebel Runtime Repository.

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

To verify that your database is using binary sort order

  1. Run SQL*Plus to connect to the Oracle Database.

  2. Issue the following query:

    SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;

  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, then reset the value to BINARY.