While I start my database with my initialization parameter it fails with oracle error

Solution :-
su oracle
run environment variable
sqlplus / as sysdba

SQL>create pfile from spfile;
Then remove or comment below line in pfile
db_recovery_file_dest
Save and exit
su oracle
run environment variable
sqlplus / as sysdba

SQL>startup mount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes

it should became the mount stage then open the DB as follows
SQL>alter database open;

Database altered.

0 comments:

Post a Comment

 
Top