how to restore system user in oracle and lock it back

By -
Following instructions will help you unlock the oracle db system user and lock it back when needed.
Those are the instructions:
1) login to a machine as user oracle
2) connect to sqlplus: sqlplus '/ as sysdba'
3) unlock user: alter user system account unlock;
4) change password: alter user system identified by manager;
5) verify connection: conn system/manager
6) restore password: ALTER USER system IDENTIFIED BY VALUES 'F2B917B76C7DFF0A';
7) lock user: alter user system account lock;
8) verify lock: conn system/manager
you should see the following message: ERROR: ORA-28000: the account is locked

Comments

Leigh Bolton said…
This comment has been removed by a blog administrator.
9:17 AM
Post a Comment

Popular posts from this blog

How to set or disable auto-logout on bash shell

By -
Following information is intended for bash shell only. The system variable TMOUT can be set to specify the amount of time the user is inactive before the user is automatically logged out. Set the following listed below in the /root/. bashrc file: TMOUT =XXX # The system will logout the root account after one hour of inactivity. The value entered for the TMOUT = variable is in seconds. To represent 1 hour, we have to multiply as follows: 1 hour is 60 minutes. 60 minutes * 60 seconds = 3600 seconds. After setting the parameter, the intended user will need to log out and then log in for the changes to take effect. To make modifications apply to all users on the system, specify the TMOUT variable in /etc/ profile. To disable auto- logout simply comment out or delete the line with TMOUT value Provided by: Forthscale systems, cloud experts
Read more

Setting up updates with public yum server for Oracle Enterprise Linux

By -
Oracle provides a free and public yum server to update it`s Enterprise Linux distribution. It is easy to set-up and it supports versions 4, 5 and 6. To set up public repositories for different versions, download configuration file (for ex. with wget) In Oracle Enterprise Linux 6.x # cd /etc/yum.repos.d # wget https://public-yum.oracle.com/public-yum-ol6.repo In Oracle Enterprise Linux 5.x # cd /etc/yum.repos.d # wget https://public-yum.oracle.com/public-yum-el5.repo In Oracle Enterprise Linux 4, Update 6 or Newer # cd /etc/yum.repos.d # if you have old repo file then: # mv Oracle-Base.repo Oracle-Base.repo.disabled # wget https://public-yum.oracle.com/public-yum-el4.repo You can verify new configuration with: #   yum list And execute update with : # yum  update Provided by: Forthscale systems, scalable infrastructure experts
Read more

How to Install Terraform 0.12 on Ubuntu 18.04

By -
To this day (8/8/2019) Terraform is not packaged in an official apt repository. There is an option to install it with Snap but be careful it will probably be an older version. When i checked it was v0.11.11 If you do want to install it with snap, run: $   snap install terraform To install the latest version follow this procedure. You might want to update your system just in case: $  sudo apt-get update Now since you are getting a Terraform binary from official Hashicorp site, you will need both wget and unzip packages unless already installed: $  sudo apt-get install wget unzip Last step would be to download an unzip Terraform package ( you can find latest here ). $  wget https://releases.hashicorp.com/terraform/0.12.6/terraform_0.12.6_linux_amd64.zip $  sudo unzip ./terraform_0.12.6_linux_amd64.zip -d /usr/local/bin/ check that it is installed: $ terraform -v you are all done. Provided by: Forthscale systems, cloud experts
Read more