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 […]
#!/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 […]
This script will show tablespaces from all databases in server which are full by 85 percent.This script will take care
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
RMAN Incremental backup This backups only datafile blocks changed since specified previous backup. 1.This strategy could be followed to make
Automatic Storage Management (ASM) A.Overview of Automatic Storage Management (ASM) Automatic Storage Management (ASM) simplifies administration of Oracle related
DIRECTORY STRUCTURE IN UNIX Directory Contains bin/ Required Boot-time binaries boot/ Boot configuration files for the OS loader and kernel
DB CREATION STEPS IN WINDOWS SETTING AN ENVIRONMENT(FOR WINDOWS) ORADIM -new -sid <new_sid> -intpwd oracle -startmode AUTO -pfile c:\oracle\admin\<new_sid>\pfile\init<new_sid>.ora
MANAGING SECURITY Managing Profiles 1.Creating profile and Granting it to user CONN sys/password AS SYSDBA CREATE PROFILE my_profile LIMIT
Install mysql 5.7 in Ubuntu root@ubuntu:~# sudo apt-get install mysql-server Reading package lists… Done Building dependency tree Reading state
First Add disk from datastore to the VM server node using following steps Login to vCenter console and Right Click