Skip to content
Saturday, May 28, 2022
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • Oracle 11g

Category: Oracle 11g

Script to take user password backup in Oracle 11g

19 August 202019 August 2020 Administrator

$ sqlplus “/as sysdba” set pages 50000 lines 32767 select ‘alter user ‘ || name || ‘ identified by values “‘ || password || “‘;’ from sys.user$Read More…

Oracle 11gR2 RAC Services create/status/configure/relocate

19 August 202019 August 2020 Administrator

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…

ORACLE 11G PASSWORD EXPIRATION

19 August 202019 August 2020 Administrator

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…

How server side load balancing will happen in Oracle RAC 11g??

19 August 202019 August 2020 Administrator

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 Single instance oracle home

19 August 202019 August 2020 Administrator

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…

How To Change/Restore User Password in 11G

19 August 202019 August 2020 Administrator

——Oracle 11g introduces Case-sensitive passwords for database authentication. Along with this if you wish to change the password (temporarily) anRead More…

Oracle 11g new feature Automatic Memory Management(AMM)

19 August 202019 August 2020 Administrator

This article explains Oracle Database 11g New Feature(AMM). Memory Parameters: oracle 11g introduced new feature called automatic memory manageRead More…

Repair Database Corrupution Using 11g New Tools

18 August 202018 August 2020 Administrator

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 on Linux CentOS

18 August 202018 August 2020 Administrator

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…

If db_recovery_file_dest_size got full

18 August 202018 August 2020 Administrator

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…

Posts navigation

Older posts

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 53
  • 29,903

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.