ORA-12545: Connect failed because target host or object does not exist using SERVICE_NAME in tnsnames.ora
Today I observed that we were getting following error when we were going to connect using SERVICE_NAME from (DR site)…
7 years ago
Restore Archivelog from particular sequence to another location using tape backup
Error in DR alert log:- FAL[client]: Failed to request gap sequence GAP - thread 2 sequence 9432-9473 DBID 2085418592 branch…
7 years ago
PSU patch Oracle 11gR2 oracle single instance HA
1.OPatch installation Copy the opatch binary using root user to $ORACLE_HOME and $GRID_HOME. Then please keep backup of old OPatch…
7 years ago
Grid and Oracle PSU patching using OPatch 11gR2 RAC
1.Please download latest version of OPatch and install under $ORACLE_HOME and $GRID_HOE Copy the opatch binary using root user to…
7 years ago
Create new mount point using LVM in RHEL 7
First install gdisk utility (you may use old fdisk utility if LUN/drive size is less than 2 TB) -bash-4.1$ yum…
7 years ago
Monitor steps for Logical Standby Database
1.V$LOGSTDBY_PROCESS displays dynamic information about what is happening to the Data Guard log apply services. This view is helpful when…
7 years ago
FLASHBACK DATABASE AND QUERIES
FLASHBACK FEATURES Purging the Recycle Bin purge table sales.woodscrews; purge index sales.woodscrews_pk_idx; purge tablespace sales; purge recyclebin; …
7 years ago
Network configuration listener and tnsnames in oracle
Oracle Network Configuration =========================== In its most basic form, Oracle uses three files (listener.ora, tnsnames.ora & sqlnet.ora) for network configuration.…
7 years ago
Memory and Process in Oracle generic note
MEMORY MANAGEMENT 11g ===================== //blog.tanelpoder.com/2007/08/21/oracle-11g-internals-part-1-automatic-memory-management/ PGA+SGA=MEMORY_TARGET what are the shared memory IDs for my instance $ sysresv corresponding SysV SHM…
7 years ago
PLSQL Reference for DBA
PLSQL Reference for DBA PL/SQL stands for Procedural Language/SQL.PL/SQL extends SQL by adding control Structures found in other procedural language.PL/SQL…
7 years ago