We are just creating a test environment for oracle 9i on Open VMS 7.3.
I have created an undo tablespace and then i have to change the compatible parameter to 18.104.22.168.0
i also added these parameters into init.ora file
UNDO_MANAGEMENT = AUTO # Default is MANUAL
UNDO_TABLESPACE = undotbs_01 # The name of the undo tablespace.
UNDO_RETENTION = 900 # The time undo is retained.
# Default is 900 seconds.
UNDO_SUPPRESS_ERRORS = TRUE # Suppress errors when MANUAL undo admin
# SQL statements are issued.
but when i restart the database it gave this error
so i remove the above parameters from the init.ora and then restart the database.
Does undotbs_01 exist? Is it UNDO type? I think one of these question has an answer = NO :-)
If no UNDO tablespace exists, edit the init.ora file to comment out the UNDO_MANAGEMENT parameter: the default value for UNDO_MANAGEMENT is MANUAL.
Then, after starting the database, do one of the following:
A. Create a non UNDO tablespace with at least one online rollback segment. The instance can work this way.
B. Create a new UNDO tablespace. If you want the instance to work under Automatic Undo Management,
a. Set the UNDO_MANAGEMENT back to AUTO
b. Set the UNDO_TABLESPACE parameter to the name of the new UNDO tablespace
c. Restart the database