The documentation uses OEM to do this, something that Oracle XE does not have. Has a non-DBA, I find installing Oracle EE tedious. Thanks to waslleysouza.com.br, I was able to find the right script to execute with XE. For the DB-disabled like myself, here are the full steps to do this on a Linux host:
- login to linux as a member of the dba group or sudo as same
- # echo $ORACLE_SID
- # echo $ORACLE_HOME
if either is blank:
# set ORACLE_SID=XE (or your service id) # set ORACLE_HOME= (Eg: C:oraclexeapporacleproduct10.2.0server)
- #locate sqlplus
- run [RESULT FOUND PATH]sqlplus / as sysdba
i.e.,
# /u01/app/oracle/product/11.2.0/xe/bin/sqlplus / as sysdba
- execute the following (replace values inside [brackets]):
CREATE USER [csuser] IDENTIFIED BY [password] DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; GRANT CREATE session, CREATE table, CREATE view TO [csuser]; GRANT UNLIMITED TABLESPACE TO [csuser]; COMMIT;





© Scott S. Nelson