ORA-23502: valid directory for offline instatiation is not
specified



ORA-23502: valid directory for offline instatiation is not specified..

Answer / guest

Cause: An attempt was made to offline instantiate to a
directory which is not specified or null.

Action: There are two ways to specify the directory: o As a
parm offline_dirpath to the API o As an init.ora parm named
utl_file_dir Make sure you have specified an appropriate
directory in which the offline file can be created.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12715: invalid character set specified

1 Answers  


ORA-25502: concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running

1 Answers  


ORA-07636: smsdbp: $MGBLSC failure

1 Answers  


ORA-31531: could not find column string in CDC subscriber view string.string

1 Answers  


RMAN-20241: ambiguous archived log name

1 Answers  






ORA-07277: spdde: illegal pid passed as argument.

1 Answers  


SQL*Loader-00114: Error in OPTIONS statement

1 Answers  


ORA-08462: raw buffer contains invalid decimal data

1 Answers  


ORA-02147: conflicting SHARED/EXCLUSIVE options

1 Answers  


ORA-00297: must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START

1 Answers  


RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

1 Answers  


PCC-02020: Preprocessor error at line number, column number, file string:

1 Answers  


Categories