• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to Change SYS and SYSTEM Passwords in Oracle Database

by admin

These steps will allow you to change the passwords for SYS, SYSTEM, and the oracle user at the operating system level.

1. Log into Oracle as internal or sysdba

$ svrmgrl command="connect internal"

– or –

$ sqlplus "/ as sysdba"

2. Type the following commands:

SQL> ALTER USER SYS IDENTIFIED BY [password]; 
SQL> ALTER USER SYSTEM IDENTIFIED BY [password];

3. Log off of Oracle and reconnect as SYS or SYSTEM and test the new password

Note that any OS user who is a member of the osdba group (usually ‘dba’)can run ‘sqlplus / as sysdba’. Because of this it is recommended to change the password of the OS users who are members of this group. To change a password at the OS level, perform the following steps.

For UNIX

1 Log in as the oracle software owner, usually ‘oracle’.

2. Type the following:

$ passwd 

3. It will prompt you for the current password, enter current password.

4. It will then prompt you for the new password, enter the new password.

5. It will then ask for a confirmation of new password, re-enter new password.

Filed Under: oracle

Some more articles you might also be interested in …

  1. Oracle DGMGRL (Data Guard Manager) Command Line Reference (Cheat Sheet)
  2. Recommendation for the Oracle Real Application Cluster Interconnect and Jumbo Frames
  3. Oracle database – How to create pfile or spfile using the current parameters
  4. FATAL: Error inserting rds_rdma
  5. How To Run ggsci In “silent” Mode
  6. How to set udev rule for setting the disk permission on ASM disks when using multipath on CentOS/RHEL 6
  7. How to change static parameters through SPFILE parameter file in Oracle Database
  8. List of Operating System Processes Started by the OMS
  9. How to check Oracle Database uptime
  10. What Is Oracle Key Vault

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright