All about table and constraints in Oracle
CREATING ORACLE DATABASE OBJECTS CREATING TEMPORARY TABLES SQL>CREATE GLOBAL TEMPORARY TABLE TEMP_EMP (EMPNO NUMBER,ENAME VARCHAR2(10)) CREATING ONE TABLE […]
Technology
security
DBMS_CRYPTO example
SQL> CONN SYS/SYS AS SYSDBA Connected. SQL> set serveroutput on SQL> SQL> set linesize 121 SQL> SQL> DECLARE l_credit_card_no VARCHAR2(19)
Dataguard
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL
FAST START FAILOVER (FSFO) CONFIGURATION USING FAR SYNC NODE AS OBSERVER IN DATAGUARD USING DGMGRL 1.For data guard DGMGRL
Dataguard
Step by Step Oracle Active Data Guard Far Sync RAC
Step by Step Oracle Active Data Guard Far Sync RAC Active Data Guard Far Sync, a new capability with
SCRIPTS
Clean *.trc ,*.trm and *.aud older than 1 day clean oracle home
#!/bin/bash . /home/oracle/.bash_profile export log=/u01/app/oracle/shells/clean_rdbms_audit.log echo $ORACLE_HOME | tee $log echo “DELETING AUDIT LOGS FROM RDBMS” | tee -a $log
SCRIPTS
Tablespace usage considering autoextend on
This script will show tablespaces from all databases in server which are full by 85 percent.This script will take care
Dataguard, SCRIPTS
Script to sync check of applied archive log between 2 RAC databases
1.First create the shell script mentioning all environmental variables adjusted to your environment. vi dataguard_dr_sync_check.sh #!/bin/bash cd /u01/app/oracle/shells for k
Backup and Recovery
RMAN incremental Backup cumulative and differential
RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make
ASM
ASM overview and commands
Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related
Linux
Unix basic command and shell script for DBA and SYSADMIN
DIRECTORY STRUCTURE IN UNIX Directory Contains bin/ Required Boot-time binaries boot/ Boot configuration files for the OS loader and kernel