Showing posts with label password. Show all posts
Showing posts with label password. Show all posts
Friday, October 16, 2015
Friday, December 14, 2012
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;
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;
Subscribe to:
Posts (Atom)