A link to my LinkedIn post to a blog with the how to is https://www.linkedin.com/pulse/blog-mash-up-virtualbox-port-forwards-windows-7-oracle-scott-nelson.

In short, go to advanced networking and add the port to the Virtualbox instance settings then go to the Firewall control in Oracle Linux System Administration menu and add it there, too.

One of those things that took hours to figure out and moments to explain.

© Scott S. Nelson

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

 A Front End Engineer’s Manifesto

© Scott S. Nelson