Categories

oracle backup

#!/bin/bash #oracle_backup.sh version1.0 chmod 700 #00 00 * * * /usr/local/scripts/oracle_backup.sh #chmod 700 /usr/local/scripts/oracle_backup.sh #You must first import the environment variables in the Oracle user’s bash_profile file #Must be used to define the DBA account first dpdata1 path and authorized directory to read and write, modify the dpdata1 group

export ORACLE_BASE=/usr/local/u01/oracle export ORACLE_HOME=/usr/local/u01/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=oracle11 […]

Oracle backup script

Oracle backup script

#!/bin/bash #oracle_backup.sh version1.0 chmod 700 #00 00 * * * /usr/local/scripts/oracle_backup.sh #chmod 700 /usr/local/scripts/oracle_backup.sh #You must first import the environment variables in the Oracle user’s bash_profile file #Must be used to define the DBA account first dpdata1 path and authorized directory to read and write, modify the dpdata1 group

export ORACLE_BASE=/usr/local/u01/oracle […]

Oracle data pump expdp / impdp

Oracle 11g later new features make the default conditions in the allocation of table space when the empty table is ignored to reduce the table space resource consumption, so that the use of Oracle’s exp export user data will be ignored when the empty table, it will cause data Not complete, of course, in the use […]

tcpdump to see Oracle errors

ot all exceptions are created equally, and most you can ignore (the one below you can, in general). However, if you have to troubleshoot on JBOSS (or anywhere a Linux application connects to an Oracle database), what is below is a good “quicky” command the root user can run to quickly dump the Oracle exceptions […]

Oracle ASM 12c on Linux

How to setup Oracle ASM 12c on Linux Software used:- 1.VMWARE 10 2.Redhat enterprise linux 6.5(64 bit) 3.Oracle database 12C (64 bit) 4.Oracle Grid infrastructure 12c(64 bit)

What to Setup:-

1. Setup oracle grid infrastructure for standalone server “ASM” 2. Setup oracle Database

Update /etc/sysctl.conf [root@server1]# vi /etc/sysctl.conf Scroll to the bottom and add the […]

Install Oracle Express 11G R2 on CentOS 7

 Install Oracle Express 11G R2 on CentOS 7 Preparations

Install some additional packages via yum to ensure that the installation and execution of the database will work. The list may differ, depending on the actual version of CentOS you are using, but the internet gave me back the following packages and you should be on […]

Configuring automatic startup of Oracle Database under systemd on RHEL 7/OEL 7/CentOS 7

Configuring automatic startup of Oracle Database under systemd on RHEL 7/OEL 7/CentOS 7 There are several methods how to start Oracle Database automatically during/after OS boot. You can use Oracle CRS, other clusterware or init implemented in Linux. Starting RHEL 7 SysV init has been replaced by systemd or simply said systemd is the new […]

Recover database without control files and redolog files.

 Recover database without control files and redolog files. Scenario:- We are deleting controlfiles from database and would recover database after dropping them.

Database version :- Oracle 11g R2 OS: Rhel 6 Database sid: orcl Archivelog mode: enabled

Step1:- $cd /u01/app/oracle/oradata/orcl $rm -rf *.ctl

$sqlplus / as sysdba SQL>startup ORACLE instance started.

Total System Global Area […]

How to sync standby database which is lagging behind from primary database

How to sync standby database which is lagging behind from primary database Primary Database cluster: cluster1.rmohan.com Standby Database cluster: cluster2.rmohan.com

Primary Database: prim Standby database: stand

Database version:11.2.0.1.0

Reason:- 1. Might be due to the network outage between the primary and the standby database leading to the archive gaps. Data guard would be able to […]

How to start/stop oracle database from linux command prompt

How to start/stop oracle database from linux command prompt How to start/stop oracle database from linux command prompt:- [oracle@configsrv1 ~]$vi /etc/oratab #

# This file is used by ORACLE utilities.  It is created by root.sh # and updated by the Database Configuration Assistant when creating # a database.

# A colon, ‘:’, is used as […]

Page 1 of 3123