This blog saved my day: http://sai-surya-talk.blogspot.com/2011/06/resetting-oracle-xe-system-account.html
For a Linux adaptation of the above:
log in as a member of the oracle and/or 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:/u01/app/oracle/product/11.2.0/xe)
locate sqlplus
[RESULT FOUND PATH]sqlplus / as sysdba
Example:
/u01/app/oracle/product/11.2.0/xe/bin/sqlplus / as sysdba
alter user [SCHEMA_OWNER] identified by [SCHEMA_PASSWORD]
Example:
alter user WCSDGE_OCS identified by webLogic1
If you have lots of system-generated users such as from Oracle RCU, you can find them all with:
select * from all_users;
© Scott S. Nelson