problem with undo tablespace in 9i

[UKDBA]

Hi
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 9.0.0.0.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

ora-01092


so i remove the above parameters from the init.ora and then restart the database.

Do you have any idea about this problem.

how can i use the undo tablespace.

Any idea???

[julian]

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.

-OR-

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

[Chandra]

Mistake

[Edited by Chandra on 12-07-2001 at 10:00 AM]

[julian]

Originally posted by Chandra
Mistake

[Edited by Chandra on 12-07-2001 at 10:00 AM]

What mistake?