How to drop an existing Siebel Database Completely ?

I was working on a requirement and expectation was to deploy a new Siebel vanilla database on an existing one. Task was simple but need to be done carefully as new system may face issues if it’s not done properly. Following steps need to be followed carefully. Please make sure all backups have been taken on priority.

Drop Exiting Siebel/SADMIN/ldapuser –

DROP USER SIEBEL CASCADE
DROP USER SADMIN CASCADE
DROP USER LDAPUSER CASCADE

Drop roles

DROP ROLE SSE_ROLE
DROP ROLE tblo_role

Drop Existing tablespaces

DROP TABLESPACE SIEBELXXDT INCLUDING CONTENTS CASCADE CONSTRAINTS
DROP TABLESPACE SIEBELXXDT INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE SIEBELXXIN INCLUDING CONTENTS CASCADE CONSTRAINTS
DROP TABLESPACE SIEBELXXIN INCLUDING CONTENTS AND DATAFILES;

Create Tablespaces

select * from dba_data_files
select * from dba_tablespaces

create tablespace SIEBELXXDT datafile ‘/data/oradata/siebeldata/datafiles/SIEBEL01.dbf’ size 4G autoextend on next 160K maxsize unlimited;

create tablespace SIEBELXXIN datafile ‘/data/oradata/siebeldata/datafiles/SIEBELIDX01.dbf’ size 2G autoextend on next 160K maxsize unlimited;

Run Grantuser.sql (Before running grantusr.sql please run these commands also)

alter user SIEBEL quota unlimited on SIEBELXXIN
alter user SADMIN quota unlimited on SIEBELXXIN
alter user SIEBEL quota unlimited on SIEBELXXDT
alter user SADMIN quota unlimited on SIEBELXXIN

Thats all ! Now you can proceed for Siebel Deployment.

Happy Learning.