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.
According to the Argus Installation Guide, the NLS_LENGTH_SEMANTICS parameter needs to be set to CHAR.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!