Lorem Ipsum has been the industry's standard dummy
This document describes the procedure to extend your existing mount point after adding the disk in RHEL 7 using LVM. 1.Please create partition on newly added disk [root@linuxacademy1 ~]# gdisk /dev/xvdf GPT fdisk (gdisk) version 0.8.6 Partition table scan: MBR: not present BSD: not present APM: not present GPT: not present Creating new GPT entries. Command (? for help): n […]
Today I observed that we were getting following error when we were going to connect using SERVICE_NAME from (DR site) to new exadata server. The connection was working fine with SID in tnsnames.ora to individual instances. [oracle@XXX admin]$ sqlplus dba/XXX@PROD_CDV SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 27 09:08:38 2017 Copyright (c) 1982, 2014, Oracle. All rights reserved. ERROR: ORA-12545: […]
Error in DR alert log:- FAL[client]: Failed to request gap sequence GAP – thread 2 sequence 9432-9473 DBID 2085418592 branch 924361120 FAL[client]: All defined FAL servers have been attempted. ———————————————————— Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter is defined to a value that’s sufficiently large enough to maintain adequate log switch information to resolve archivelog gaps. ———————————————————— Now in Primary,do the […]
1.OPatch installation Copy the opatch binary using root user to $ORACLE_HOME and $GRID_HOME. Then please keep backup of old OPatch directory. Unzip the binary in the $ORACLE_HOME and $GRID_HOME. unzip -o -d $ORACLE_HOME /oracle/soft/p6880880_112000_Linux-x86-64.zip unzip -o -d $GRID_HOME /oracle/soft/p6880880_112000_Linux-x86-64.zip Change owner of the folder OPatch. chown -R oracle:oinstall $ORACLE_HOME/OPatch chown -R oracle:oinstall $GRID_HOME/OPatch 2.Stop EM DB console [oracle@jminvgpdb01 ~]$ […]
1.Please download latest version of OPatch and install under $ORACLE_HOME and $GRID_HOE Copy the opatch binary using root user to $ORACLE_HOME and $GRID_HOME. Then please keep backup of old OPatch directory. Unzip the binary in the $ORACLE_HOME and $GRID_HOME. unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0/grid unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/db_1 Change owner of the folder OPatch. chown -R oracle:oinstall $ORACLE_HOME/OPatch /u01/app/11.2.0/grid/OPatch/opatch version chown […]
Install GitHub Download Git https://git-scm.com/download/win Installation Steps After finish,Please create repository where code will be saved There is no code now I am creating sample code in c:\mygitrep directory We need to again login to git from program and rescan. Now stage unchanged Now sign off Please commit now Now we will get this screen. Please create […]
First install gdisk utility (you may use old fdisk utility if LUN/drive size is less than 2 TB) -bash-4.1$ yum install gdisk Loaded plugins: fastestmirror, security You need to be root to perform this command. -bash-4.1$ su Password: [root@LinuxAcademy linuxacademy]# yum install gdisk Loaded plugins: fastestmirror, security Setting up Install Process Determining fastest mirrors * base: mirror.cs.pitt.edu * extras: mirrors.advancedhosters.com […]
1.V$LOGSTDBY_PROCESS displays dynamic information about what is happening to the Data Guard log apply services. This view is helpful when diagnosing performance problems during the logical application of archived redo logs to the standby database, and it can be helpful for other problems. This view is for logical standby databases only. INPUT QUERY:- SELECT STATUS FROM V$LOGSTDBY_PROCESS WHERE […]
LOGICAL STANDBY DATABASE STEP BY STEP Primary DB: CLRVMS (ip:10.3.248.5 and 10.3.248.8) Logical Standby DB: CLRVMS_B(ip:10.3.248.129) Please check whether Primary database is in archivelog or not.It should be in archivelog. select log_mode from v$database; LOG_MODE ———— ARCHIVELOG Enable Force Logging, SQL> ALTER DATABASE FORCE LOGGING; Database altered. Configure Standby Redo Log on PRIMARY Check the […]
FLASHBACK FEATURES Purging the Recycle Bin purge table sales.woodscrews; purge index sales.woodscrews_pk_idx; purge tablespace sales; purge recyclebin; Undropping Objects in the Recycle Bin flashback table ws_app.woodscrews to before drop; select object_name, original_name, droptime, dropscn from user_recyclebin; flashback table bonus to before drop rename to bonus_deb; ———–Accidentaly Delete—————————————— Accidentally dropped table MHC_PA_INT_PPA_SPN_RL_TBL from MHCPA schema […]