Oracle has over 250 instance startup parameters that are kept in a file commonly abbreviated init.ora. The init.ora file can be located where you want (with. Want to change your SPFILE location? To a configuration file used by the Oracle database to set values. Have a file named INIT.ora in the default. Hi, In oracle, init. Red Alert 2 Egypt Patch. ora is the profile file and spfile.ora is the system profile file. These files are needed by oracle while startup. These files will be.

Hi, In oracle, init.ora is the profile file and spfile.ora is the system profile file. These files are needed by oracle while startup.

These files will be usually available in the path $ORACLE_HOME/dbs (where $ORACLE_HOME=/oralce//102_64). These files are just like the profile files for SAP (available in the location /usr/sap//SYS/profile). While taking a backup, a copy of these profiles will be taken in the backup stage directory. This happens whenever a backup is scheduled using BRTools. These are just copies and nothing to do with the oracle startup.

Hope this clarifies. Regards, Varadharajan M 0 Likes 0.

UTL_FILE_DIR lets you specify one or more directories that Oracle should use for PL/SQL file I/O. If you are specifying multiple directories, you must repeat the UTL_FILE_DIR parameter for each directory on separate lines of the initialization parameter file. On 11/24/07, awadhoot via oracle-db-l wrote: >>>>Hi all, >I am using Oracle 10g on Windows XP. >I created database with Database Configuration Assistant. It created file >init.ora.3651 >>I have appended utl_file_dir=* to this file.

Still I am getting >ORA-29280: invalid directory path error. >>Do I need to do anthing else?

Thanks for your reply! What I understand is, UTL_FILE_DIR=* is a general statement which denotes Oracle can use entire disk for I/O. Even I tried with specifying the directory I am actually using for I/O.

Still, same error is there. I am unable to figure out what is going wrong. -----Original Message----- UTL_FILE_DIR lets you specify one or more directories that Oracle should use for PL/SQL file I/O.

If you are specifying multiple directories, you must repeat the UTL_FILE_DIR parameter for each directory on separate lines of the initialization parameter file. Hi, When ever you use UTL_FILE package, you should use only those directories mentioned in V$PARAMETER. If you try to use any other directories, it will error out and throw the above message. For finding out the directories, you please use the below command. Select name from v$parameter where name = 'utl_file_dir'; Please let me knonw if you have any issues. Thanks & Regards, Jithendra.

-----Original Message----- Thanks for your reply!What I understand is, UTL_FILE_DIR=* is a general statement which denotes Oracle can use entire disk for I/O. Even I tried with specifying the directory I am actually using for I/O.Still, same error is there.I am unable to figure out what is going wrong. I slightly changed the query, select value from v$parameterwhere name = 'utl_file_dir'; It gave following output, NAME ------------ utl_file_dir From where, this view picks up this information? Can its contents be updated? Thanks a lot! -----Original Message----- Hi, When ever you use UTL_FILE package, you should use only those directories mentioned in V$PARAMETER. Ar Rahman Instrumental Tamil Mp3 Songs there.

If you try to use any other directories, it will error out and throw the above message. For finding out the directories, you please use the below command.select name from v$parameterwhere name = 'utl_file_dir';Please let me knonw if you have any issues.Thanks & Regards,Jithendra. I came to know that this information is picked from pfile or spfile.