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;
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;
No comments:
Post a Comment