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-09918: Unable to get user privileges from SQL*Net

1 Answers  


ORA-01691: unable to extend lob segment string.string by string in tablespace string

1 Answers  


ORA-07408: slbtpd: overflow while converting to packed decimal.

1 Answers  


ORA-38460: filtering based on datatype "string" not supported for XML Tags

1 Answers  


LPX-00651: VM Stack overflow.

1 Answers  






ORA-38758: cannot flashback data file string; restored since last recovery

1 Answers  


PCB-00007: %s

1 Answers  


ORA-12225: TNS:destination host unreachable

1 Answers  


ORA-09770: pws_look_up: translation failure.

1 Answers  


ORA-31066: Insertion of string into string creates a cycle

1 Answers  


DRG-11530: token exceeds maximum length

1 Answers  


IMG-02005: 2FF05 - incorrect color specification

1 Answers  


Categories