Oracle Database Discussions

Hi. this is a new thread as its a new chapter (of the same journey).
I have created / edited a new control file. When I run it, these are the errors
(Oracle 9i, UNIX). I realise there are some errors that Oracle ignores, but the whole thing runs for maybe a second before quitting so I know Im doing something wrong.

I have shut the database down before I run this script.

I will post here the errors, then the control file itself.
ERRORS:
SQL> @create_control_file.sql
ORA-01081: cannot start already-running ORACLE - shut it down first
CREATE CONTROLFILE SET DATABASE "TEST" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01223: RESETLOGS must be specified to set a new database name


SP2-0734: unknown command beginning "Recovery i..." - rest of line ignored.
SP2-0734: unknown command beginning "or if the ..." - rest of line ignored.
ORA-01507: database not mounted


SP2-0734: unknown command beginning "All logs n..." - rest of line ignored.
ALTER SYSTEM ARCHIVE LOG ALL
*
ERROR at line 1:
ORA-01507: database not mounted


SP2-0734: unknown command beginning "Database c..." - rest of line ignored.
ALTER DATABASE OPEN
*
ERROR at line 1:
ORA-01507: database not mounted


SP2-0734: unknown command beginning "Commands t..." - rest of line ignored.
SP2-0734: unknown command beginning "Online tem..." - rest of line ignored.
SP2-0734: unknown command beginning "Other temp..." - rest of line ignored.
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi2/oracle/testdata/tmp02.dbf'
*
ERROR at line 1:
ORA-01109: database not open


ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi2/oracle/testdata/tmp01.dbf'
*
ERROR at line 1:
ORA-01109: database not open


SP2-0734: unknown command beginning "End of tem..." - rest of line ignored.


Here is the Control file:
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "TEST" NORESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 500
MAXINSTANCES 1
MAXLOGHISTORY 19285
LOGFILE
GROUP 1 (
'/oradbi2/oracle/testdata/log01a.dbf',
'/oradbi2/oracle/testdata/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/oradbi2/oracle/testdata/log02a.dbf',
'/oradbi2/oracle/testdata/log02b.dbf'
) SIZE 10M,
GROUP 3 (
'/oradbi2/oracle/testdata/log03a.dbf',
'/oradbi2/oracle/testdata/log03b.dbf'
) SIZE 10M
-- STANDBY LOGFILE
DATAFILE
'/oradbi2/oracle/testdata/system01.dbf',
.
.
.
CHARACTER SET US7ASCII
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;
# Database can now be opened normally.
ALTER DATABASE OPEN;
# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi2/oracle/testdata/tmp02.dbf'
SIZE 2040M REUSE AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M;
ALTER TABLESPACE TEMP ADD TEMPFILE '/oradbi2/oracle/testdata/tmp01.dbf'
SIZE 2000M REUSE AUTOEXTEND OFF;
# End of tempfile additions.

I just spoke to the DBA and I followed his instructions....can anyone see any silly mistakes???

many many thanks ... I know its Friday.
DA