|
||||||
|
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 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 […] 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 […] 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 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 […] 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. 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 […] 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:- [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 […] Install Oracle Database 12c On CentOS7 Add a host file entry [root@oracledb ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.1.60 oracledb.rmohan.com oracledb [root@oracledb ~]# hostnamectl Static hostname: oracledb.rmohan.com Icon name: computer-vm Chassis: vm Machine ID: 4145c21ef6ec4ca3a6a4ea34087a5552 Boot ID: a0d067b346df44f98ba7248578bfde3b Virtualization: vmware Operating System: CentOS Linux 7 (Core) CPE OS […] |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments