On the Oracle command prompt execute the following command:
<SCHEMA> = Oracle schema to use for the new installation
<EPISERVERFILE> = File for the EPiServer installation e.g. "C:\TEMP\EPiServerNET.sql"
<PATH> = Where to store the database files on the Oracle e.g. "D:\DATA\Oracle"
<USER> = A user with administrator rights e.g. "sys/systemmanager"
<INST> = The Oracle instance to use e.g. "oracle.EPiWiki.se"
sqlplus /nolog @CreateDatabase.sql <SCHEMA> <EPISERVERFILE> <PATH> <USER> <INST>
CreateDatabase.sql
connect &4@&5 as sysdba;
BEGIN
FOR I IN (SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME = '&1' )
LOOP
EXECUTE IMMEDIATE 'ALTER SYSTEM KILL SESSION ' ||''''|| I.SID ||','|| I.SERIAL# ||''' IMMEDIATE';
END LOOP;
END;
/
DROP USER &1 CASCADE;
DROP TABLESPACE &1 INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS;
EXCEPTION WHEN OTHERS THEN
NULL;
CREATE TABLESPACE &1
LOGGING DATAFILE '&3/(&1).ora'
SIZE 50M
EXTENT MANAGEMENT LOCAL;
CREATE USER &1 IDENTIFIED BY &1
DEFAULT TABLESPACE &1
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE TO &1;
connect &1/&1@&5;
@&2