SQL> Create controlfile reuse set database "em12rep"
  2  MAXINSTANCES 8
  3  MAXLOGHISTORY 1
  4  MAXLOGFILES 16
  5  MAXLOGMEMBERS 3
  6  MAXDATAFILES 100
  7  Datafile
  8  '/oracle/oraclehomes/oradata/em12rep/system01.dbf',
  9  '/oracle/oraclehomes/oradata/em12rep/undotbs01.dbf',
 10  '/oracle/oraclehomes/oradata/em12rep/sysaux01.dbf',
 11  '/oracle/oraclehomes/oradata/em12rep/users01.dbf',
 12  '/oracle/oraclehomes/oradata/em12rep/mgmt.dbf',
 13  '/oracle/oraclehomes/oradata/em12rep/mgmt_ecm_depot1.dbf'
 14  LOGFILE GROUP 1 ('/oracle/oraclehomes/oradata/em12rep/redo01.log') SIZE 102400K,
 15  GROUP 2 ('/oracle/oraclehomes/oradata/em12rep/redo02.log') SIZE 102400K,
 16  GROUP 3 ('/oracle/oraclehomes/oradata/em12rep/redo03.log') SIZE 102400K,
 17  GROUP 4 ('/oracle/oraclehomes/oradata/em12rep/redo04.log') SIZE 102400K RESETLOGS;

Control file created.

SQL> exec dbms_backup_restore.zerodbid(0);

PL/SQL procedure successfully completed.

SQL> shutdown immediate;
ORA-01109: database not open 


Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile="/oracle/oraclehomes/admin/em12rep/scripts/initem12repTemp.ora";
ORACLE instance started.

Total System Global Area  534462464 bytes                                       
Fixed Size                  2215064 bytes                                       
Variable Size             163578728 bytes                                       
Database Buffers          360710144 bytes                                       
Redo Buffers                7958528 bytes                                       
SQL> Create controlfile reuse set database "em12rep"
  2  MAXINSTANCES 8
  3  MAXLOGHISTORY 1
  4  MAXLOGFILES 16
  5  MAXLOGMEMBERS 3
  6  MAXDATAFILES 100
  7  Datafile
  8  '/oracle/oraclehomes/oradata/em12rep/system01.dbf',
  9  '/oracle/oraclehomes/oradata/em12rep/undotbs01.dbf',
 10  '/oracle/oraclehomes/oradata/em12rep/sysaux01.dbf',
 11  '/oracle/oraclehomes/oradata/em12rep/users01.dbf',
 12  '/oracle/oraclehomes/oradata/em12rep/mgmt.dbf',
 13  '/oracle/oraclehomes/oradata/em12rep/mgmt_ecm_depot1.dbf'
 14  LOGFILE GROUP 1 ('/oracle/oraclehomes/oradata/em12rep/redo01.log') SIZE 102400K,
 15  GROUP 2 ('/oracle/oraclehomes/oradata/em12rep/redo02.log') SIZE 102400K,
 16  GROUP 3 ('/oracle/oraclehomes/oradata/em12rep/redo03.log') SIZE 102400K,
 17  GROUP 4 ('/oracle/oraclehomes/oradata/em12rep/redo04.log') SIZE 102400K RESETLOGS;

Control file created.

SQL> alter system enable restricted session;

System altered.

SQL> alter database "em12rep" open resetlogs;
alter database "em12rep" open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced 
ORA-00704: bootstrap process failure 
ORA-39700: database must be opened with UPGRADE option 
Process ID: 14033 
Session ID: 133 Serial number: 1 


SQL> exec dbms_service.delete_service('emrep');
ERROR:
ORA-03114: not connected to ORACLE 


SQL> exec dbms_service.delete_service('emrepXDB');
ERROR:
ORA-03114: not connected to ORACLE 


SQL> alter database rename global_name to "em12rep.palmbeach.k12.fl.us";
ERROR:
ORA-03114: not connected to ORACLE 


SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/oracle/oraclehomes/oradata/em12rep/temp01.dbf' SIZE 5242880K REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED;
ERROR:
ORA-03114: not connected to ORACLE 


SQL> select tablespace_name from dba_tablespaces where tablespace_name='USERS';
ERROR:
ORA-03114: not connected to ORACLE 


SQL> select sid, program, serial#, username from v$session;
ERROR:
ORA-03114: not connected to ORACLE 


SQL> alter database character set INTERNAL_CONVERT WE8MSWIN1252;
ERROR:
ORA-03114: not connected to ORACLE 


SQL> alter database national character set INTERNAL_CONVERT AL16UTF16;
ERROR:
ORA-03114: not connected to ORACLE 


SQL> alter user sys account unlock identified by "&&sysPassword";
ERROR:
ORA-03114: not connected to ORACLE 


SQL> alter user system account unlock identified by "&&systemPassword";
ERROR:
ORA-03114: not connected to ORACLE 


SQL> alter system disable restricted session;
ERROR:
ORA-03114: not connected to ORACLE 


SQL> @/oracle/oraclehomes/admin/em12rep/scripts/postScripts.sql
SQL> SET VERIFY OFF
SQL> connect "SYS"/"&&sysPassword" as SYSDBA
Connected to an idle instance.
SQL> set echo on
SQL> spool /oracle/oraclehomes/admin/em12rep/scripts/postScripts.log append