Post-install test of Oracle XE

xe_post_install_verify.sh

# initial test of Oracle XE database after install

# become the "oracle" user 
su - oracle

# connect to database
sqlplus /nolog
connect sys as sysdba

-- basic query to see stuff working
select sysdate, sys_context('userenv', 'server_host') from dual;

-- check components and versions
select comp_id, version, status
from dba_registry;

-- check users
select username, account_status
from dba_users
order by 1;