Unlock system user in Oracle 11 XE (CentOS)

1) sudo -iu oracle

2) make sure you have in .bashrc ". /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh"

3) launch sqlplus
[oracle@azer ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 14 20:03:58 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> ALTER USER system ACCOUNT UNLOCK;
User altered.
SQL>

Change password just in case.


[oracle@azer ~]$ sqlplus / as sysdba
SQL> alter user system identified by my-new-password;
User altered.
SQL> commit;

How to install Oracle 11g Express Edition (XE) on CentOS

Nothing tell more then .... follow: http://www.davidghedini.com/pg/entry/install_oracle_11g_xe_on