How to Display Comma Separated Init.ora Value Longer than 512 Bytes
(Doc ID 153076.1)
Last updated on FEBRUARY 23, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 9.0.1.0 [Release 8.1.7 to 9.0.1]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Several init.ora parameters can have a comma separated list of different values,
such as rollback_segments, control_files, and utl_file_dir. A select value
from v$parameter truncates this string to 512 bytes. This can provide
incomplete information; especially, the parameter utl_file_dir is vulnerable.
For example:
SQL> select value from v$parameter where name like 'utl%';
VALUE
--------------------------------------------------------------------------------
/tmp, /var/opt/oracle/utldir1, /var/opt/oracle/utldir2, /var/opt/oracle/utldir3,
/var/opt/oracle/utldir4, /var/opt/oracle/utldir5, /var/opt/oracle/utldir6, /var
/opt/oracle/utldir7, /var/opt/oracle/utldir8, /var/opt/oracle/utldir9, /var/opt/
oracle/utldir0, /var/opt/oracle/utldira, /var/opt/oracle/utldirb, /var/opt/oracl
e/utldirc, /var/opt/oracle/utldird, /var/opt/oracle/utldire, /var/opt/oracle/utl
dirf, /var/opt/oracle/utldirg, /var/opt/oracle/utldirh, /var/opt/oracle/utldiri,
/var/opt/oracle/utldirj, /var/o
Changes
No changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |