1. Close down database
2. Open/dbs
3. Open the file init.ora file after taking a backup of this file.
4. Add the new parameter directory under "utl_file_dir" tag.
5. save the file.
6. take a backup of spfile.
7. connect with database as sysdba user.
$ sqlplus / as sysdba
8. Run the following commands ->
SQL> startup pfile=/dbs/initDEMOFFF.ora
SQL> create spfile from pfile='/initDEMOFFF.ora';
File created.
SQL> show parameter utl
2. Open
3. Open the file init
4. Add the new parameter directory under "utl_file_dir" tag.
5. save the file.
6. take a backup of spfile.
7. connect with database as sysdba user.
$ sqlplus / as sysdba
8. Run the following commands ->
SQL> startup pfile=
SQL> create spfile from pfile='
File created.
SQL> show parameter utl
No comments :
Post a Comment