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
- Run SQLPlus to connect to the Oracle Database.
- Issue the following query:
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS;
- In the returned parameters, locate
NLS_SORT and verify that its value is
NLS_SORT has a value of
BINARY, then the sort order is binary and no action is required.
NLS_SORT is anything other than
BINARY, reset the value to BINARY.
About Database Sort Order in the Siebel Environment