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-30119: unable to obtain a valid value for 'string'

1 Answers  


ORA-01218: logfile member is not from the same point-in-time

1 Answers  


ORA-27415: repeat interval must start with the FREQ= clause

1 Answers  


ORA-19815: WARNING: string of string bytes is string used, and has string remaining bytes available.

1 Answers  


ORA-39102: Timeout before master process string finished initialization. Master error:

1 Answers  


ORA-16631: Operation requires shutdown of database/instance "string"

1 Answers  


NNL-01001: NAME EXISTS responses received: number

1 Answers  


NNL-00986: Reforwarded requests expired: number

1 Answers  


LPX-00283: document encoding is ~s-based but default input encoding is not

1 Answers  


NNL-00961: Cache checkpoints: number

1 Answers  


NZE-29042: Read buffer is not empty.

1 Answers  


ORA-22293: LOB already opened in the same transaction

1 Answers  


Categories