Script to take user password backup in Oracle 11g
$ sqlplus “/as sysdba” set pages 50000 lines 32767 select ‘alter user ‘ || name || ‘ identified by values “‘ || password || “‘;’ from sys.user$Read More…
$ sqlplus “/as sysdba” set pages 50000 lines 32767 select ‘alter user ‘ || name || ‘ identified by values “‘ || password || “‘;’ from sys.user$Read More…
How to see what services you have and where they are running:[[email protected] ~]$ srvctl status service -d RACService CONTACT is running on instance(s) RRead More…
In Oracle 11g release, schema password is expired periodically, by default this is 180 days. However, if required we can alter this setting and make Read More…
Based on the load information fed by SMON, listener will decide on to which instance the incoming connections to be directed (Or how to distribute onRead More…
Cloning the single instance oracle home (This method require -Sudo privilage on both servers) here I am going to clone the oracle home to the new Read More…
——Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarily) anRead More…
This article explains Oracle Database 11g New Feature(AMM). Memory Parameters: oracle 11g introduced new feature called automatic memory manageRead More…
As Database Administrator you Face Some Issue About The Database Corruption But In 11g You have Some New Tool Called “data recovery advisor” . WitRead More…
Install Oracle 11g in silent mode shouldnít be a complex task but due to some bugs it turns out in a tricky activity. Iím using a Linux CentOS 6Read More…
Mostly this is applicable for 11g Instances when ever the db_recovery_file_dest_size got full then database will be in hang state and unable to operaRead More…