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

Last updated on JULY 13, 2023

Applies to:

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

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