Oracle Change Password

Create DB:

CREATE TABLESPACE ARSYSTEM DATAFILE '/usr/local/ars_data/ars/ARSYS' size 8000M reuse AUTOEXTEND ON;
CREATE TEMPORARY TABLESPACE ARTMP TEMPFILE '/usr/local/ars_data/ars/ARTMP' SIZE 2000M REUSE AUTOEXTEND ON;
create user ARAdmin identified by "AR#Admin#" PROFILE "DEFAULT" TEMPORARY TABLESPACE "ARTMP" DEFAULT TABLESPACE "ARSYSTEM" QUOTA UNLIMITED on "ARSYSTEM";
CREATE ROLE ARADMINROLE NOT IDENTIFIED;
GRANT ARADMINROLE TO ARADMIN;
GRANT ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE PROCEDURE, CREATE TRIGGER, QUERY REWRITE TO ARADMINROLE;


Delete AR DB:

drop role aradminrole;
drop user aradmin cascade;
DROP TABLESPACE ARTMP INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE ARSYSTEM INCLUDING CONTENTS AND DATAFILES;

S5 Box

Login