Wednesday, April 16, 2008

ORA-30014:Solution

Add the lines below into init.ora ..here initorcl3.ora:

 

undo_management = auto
undo_tablespace = UNDOTBS1
undo_suppress_errors = true
undo_retention = 3600 # seconds

 

 

Then

 

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> startup nomount;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                  2004832 bytes
Variable Size             150997152 bytes
Database Buffers           16777216 bytes
Redo Buffers                2187264 bytes
SQL> @create_db_orcl3.sql

 

 

--- Working ;-)

No comments:

Post a Comment