Friday 23 September 2016

How to change the password of SYSTEM in oracle 11g?


By default the system password will be manager.

[oracle1@subbu2 ~]$ sqlplus system/manager

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 23 16:44:41 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user;

USER is "SYSTEM"  Here i connected as system user. now i am changing this password to system.

[oracle1@subbu2 ~]$ sqlplus system/manager

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 23 16:44:41 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user;
USER is "SYSTEM"
SQL> conn / as sysdba
Connected.
SQL> show user;
USER is "SYS"
SQL> alter user system identified by system; 

User altered.

SQL> commit;

Commit complete.

SQL> conn system/manager
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> conn system/system;
Connected.
SQL> show user;

USER is "SYSTEM"


1 comment:

  1. Database backup for disaster recovery
    Genex DBS proves that data loss is only temporary every day with the highest data recovery success rate in the industry. Our recovery rates speak for themselves.Disaster Recovery


    The Data Storage Solutions team has been performing professional data recovery services for over 17 years, including desktop hard drives, laptop hard drives, external/USB hard drives, RAID arrays, NASs, SANs, DASs, SSDs, encryption storage devices, CCTV data recovery, and flash cards. RAID systems are also available at an enterprise-level. Our proprietary tools can handle a wide range of data loss situations on any server, including physical and mechanical failures, backup failures, water and fire damage, file corruptions, file deletions, system failures, etc. When performing data recovery, we use software and solutions that will not further damage your device.

    ReplyDelete