My Oracle Support Banner

How Do You Check The Value Of The NLS_LENGTH_SEMANTICS Parameter (Doc ID 2394239.1)

Last updated on MAY 09, 2018

Applies to:

Oracle Argus Safety - Version 8.1.1 and later
Information in this document applies to any platform.

Goal

According to the Argus Installation Guide, the NLS_LENGTH_SEMANTICS parameter needs to be set to CHAR.

Note:
The Argus Safety Database requires the Database semantics to be CHAR and not BYTE. Follow the steps below:
1.Log in to the database as the SYS user.
2.Execute: ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR SCOPE=BOTH;
3.Shutdown and Startup the database after applying the above statement.

How does a user confirm/check the value of this parameter?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.