Profile cover photo
Profile photo
Ajay More
41 followers
41 followers
About
Posts

Post has attachment
How to enable sql session tracing in oracle database
            Enabling session tracing in oracle database 1. Identify sql client session to be traced For example you are planning to trace the session for module ABC , identify the SPID for session e.g.  13762780 alter session set nls_date_format='dd-mon-yyy...
Add a comment...

Post has attachment
steps to create active data guard in 11g and up-gradation to 12c using manual method
Steps to Create 11 ADG and up-gradation to 12c using manual method  10 steps will take you through systematic approach to create standby database/ADG (active data guard) followed by activation and up-gradation to 12c using manual method      1.    11g dummy...
Add a comment...

Post has attachment
ORA-01722: invalid number
Issue : ORA-01722: invalid number Cause: I. Attempt has been made to insert a character value in integer datatype column SQL> create table mytest ( one integer , two varchar2(10)); Table created. SQL> desc mytest  Name                                      N...
Add a comment...

Post has attachment
CRS-4123 CRS-4124 CRS-4000
Issue:   cluster start command "crsctl start crs"   fails to start crs services CRS-4123: Starting Oracle High Availability Services-managed resources CRS-4124: Oracle High Availability Services startup failed CRS-4000: Command Start failed, or completed wi...
Add a comment...

Post has attachment
CLSRSC-218: Failed to install the OHASD startup script CLSRSC-317: Failed to register Oracle OHASD service
Problem: During Standalone 12c oracle grid installation it has been observed that root.sh is failing on SUSE Linux 11 due to errors CLSRSC-218 & CLSRSC-317 $ /rdbms/app/12.1.0.2/grid/root.sh Performing root user operation. The following environment variable...
Add a comment...

Post has attachment
Lesson for Life 1 : Work Life Balance
Starting with a series of Lesson for Life (LFL) on Lesson Learned page , stories based on personal experience & imaginary characters. LFL will give me opportunity to write something not related to technical skill (which is core of this blog) but will help r...
Add a comment...

Post has attachment
ORA-15018: diskgroup cannot be created
Errrors: SQL> create diskgroup DG03 external redundancy disk '/dev/abc'
attribute 'compatible.asm'='11.2'; create diskgroup DG03 external redundancy disk '/dev/abc' attribute
'compatible.asm'='11.2' * ORA-15018: diskgroup cannot be created ORA-15031: disk s...
Add a comment...

Post has attachment
Installing OEM 12c on Linux
Oracle
Enterprise Manager 12c cloud control installation 1. Architecture : 2. Background : Oracle Management Agent
(Management Agent/OMA) The Management Agent is an
integral software component that enables you to convert an un-managed host to a
managed host...
Add a comment...

Post has attachment
ASM DiskGroup Migration
Step Wise Disk-Group Migration from DG01 to DG02 Scenario: DBTST is an Oracle11g single instance database on ASM which holds complete database in Disk Group named DG01 spread across 4*50 GB of Disks. Objective is to migrate complete databases from DG01 to D...
Add a comment...

Post has attachment
oracle database corrupt block recovery
Error: Corrupt block relative dba: 0x1a0975d9 (file 104, block 619993) Bad check value found during user buffer read Data in bad block:  type: 6 format: 2 rdba: 0x1a0975d9  last change scn: 0x0726.9a3a3fc5 seq: 0x1 flg: 0x06  spare1: 0x0 spare2: 0x0 spare3:...
Add a comment...
Wait while more posts are being loaded