ORA-01308: initialization parameter utl_file_dir is not set

Answers were Sorted based on User's Feedback



ORA-01308: initialization parameter utl_file_dir is not set..

Answer / abhijit

utl_fire_dir is not set in the init.ora file.
This is, usually, not modifiable at the instance, session or
system level (cannot do an 'alter' to make life easier)
A change will involve setting the utl_file_dir in the
init.ora file and the database needs to be bounced to
reflect the change.
n.b. if utl_file_dir needs to point to multiple directories,
a separate entry for each directory needs to be made in the
init.ora file.

Is This Answer Correct ?    3 Yes 1 No

ORA-01308: initialization parameter utl_file_dir is not set..

Answer / guest

Cause: utl_file_dir is not set in the initialization file.

Action: Set utl_file_dir to the appropriate directory.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01292: no log file has been specified for the current LogMiner session

2 Answers  


ORA-26510: materialized view name: 'string' is greater than max. allowed length of string bytes

1 Answers  


ORA-30457: 'string.string' cannot be refreshed because of unmnanaged NOT NULL columns in container

1 Answers  


PLS-00909: object string is not declared or insufficient privileges to access object string

1 Answers  


ORA-01934: circular role grant detected

1 Answers  






ORA-00363: log is not the archived version

1 Answers  


ORA-06436: ssaio: asynchronous I/O failed due to incorrect parameters.

1 Answers  


DRG-12606: error encountered while parsing COLUMNS list

1 Answers  


PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses

1 Answers  


PLS-00587: a static method cannot be invoked on an instance value

1 Answers  


TNS-04003: Syntax Error.

1 Answers  


ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.

1 Answers  


Categories