Oracle : Cloning user in Database

 

Oracle : Setting up glogin.sql

Setting up glogin.sql : cd $ORACLE_HOME/sqlplus/admin cp glogin.sql glogin.sql.bkp vi glogin.sql SET termout off DEFINE myv = ‘Not connected’ COLUMN myc new_value myv select user || ‘@QA@’ || global_name myc from global_name; SET sqlprompt ‘&myv:SQL> ‘ Execution : $ sqlplus scott/PW SQL*Plus: Release 12.1.0.2.0 Production… Read More

Oracle : Setting up Oramenu for Databases

Use this script to setup oramenu:  

  ~$ chmod +x oramenu ~$ sudo su – root ~# cp /home/oracle/oramenu /usr/local/bin/ ~# exit logout ~$ . oramenu Or Example : $ chmod +x oramenu oracle@server123:ORCL1:/home/oracle > $ . oramenu Please select your SID to… Read More

Oracle : Important Queries for RMAN

RMAN Backup Size :  set linesize 300 SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+ PROMPT | Report : RMAN Status | PROMPT | Instance : &current_instance | PROMPT +————————————————————————+ SET ECHO OFF… Read More

Oracle DBA Checklist/Tasks

1) Proper Documentation which is very important in order to save time and act on issue immediately.2) DB health check list for Day to Day Activities. –> Check Alert log–> Tablespaces–> Archivelog cleanup script–> Check OS Watchers scripts are running or not.–> Setup cronjob for… Read More