Error connecting ASM ORA-15055: unable to connect to ASM instance Fatal NI connect error 12547 ORA-12547: TNS:lost contact


This Blog is intended to resolve below errors observed in DB alert log file due connectivity issue between DB Instance & ASM disk/Instance






Errors:

Fatal NI connect error 12547, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/u01/app/grid/product/11.2.0/grid/bin/oracle)(ARGV0=oracle+ASM_asmb_remdev)(ENVS='ORACLE_HOME=/u01/app/grid/product/11.2.0/grid,ORACLE_SID=+ASM')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle)(HOST=remedy-ebu-dev-db1)(USER=ora11g))))
TNS-12547: TNS:lost contact
    ns secondary err code: 12560
    nt main err code: 517

Cross OS Platform Oracle DB Migration Using RMAN


Introduction:


Document highlights cross OS platform migration of Oracle 10g database from HP UX to Sun using RMAN convert method.  


Oracle Doc. For Reference:
Cross-Platform Migration on Destination Host Using RMAN Convert Database [ID 414878.1]

Activity Index:

On Source:

           1. Verify invalid objects on source, invalid indexes, db component status
           2. Re-open DB in read only mode
           3. Verify external references & transportable compatibility w.r.t target platform
           4. Generate transport & convert script, parameter file using RMAN
           5. Shut down database,copy datafiles & transport/convert script/pfile to Target

On Target:

 6. Prepare pfile & create controlfile 
 7. Perform RMAN convert on SYSTEM/UNDO datafiles using convert script generated on source
 8. Re-create Control file with converted datafiles
 9. Execute transport script for migration 
10. Rename datafiles,create spfile 
11. Verify invalid objects, invalid indexes, db component status

Activity Steps:

ORA-00600 ORA-01114 ORA-27063 WARNING: failed to write mirror WARNING: IO Failed

Post related to below ORA- errors

ORA-00600: internal error code, arguments: [17183], [0x11041A2C8], [], [], [], [], [], []
ORA-01114: IO error writing block to file  (block # )
ORA-27063: number of bytes read/written is incorrect
WARNING: failed to write mirror side 0 of virtual extent  of file in group
WARNING: IO Failed.  au: diskname:




Error:



ORA-00600: internal error code, arguments: [17183], [0x11041A2C8], [], [], [], [], [], []
ORA-01114: IO error writing block to file  (block # )
ORA-01114: IO error writing block to file 201 (block # 647794)
ORA-27063: number of bytes read/written is incorrect

Oracle 10g Standard Edition Installation & Features


Introduction:

Document highlights oracle standard edition installation steps, database hardening as per SOX compliances and issues faced during a project setup along with best practices


Table of Content(TOC):

1.     Platform OS/DB Version  

2.     How to download oracle software
3.     Difference between Enterprise & Standard Edition

4.     Server Pre-requisites
5.     Software & database Installation

6.     Issues faced
7.     Practices

Disabling Oracle Performance Pack



Method 1:  Revoking Management Pack Access through OEM
Home Page>setup>Management Pack Access <Remove Access> <Apply>



Method 2:
ΓΌ  Step 1

Oracle Performance Tuning I

Oracle Performance Tuning : Tuning Pack 


Oracle has introduced Performance tuning & Diagnostic Pack (10g onwards), let me brief you about Tuning Pack first

Oracle Tuning Pack :

The Oracle Tuning Pack provides database administrators with expert performance management for the Oracle environment, including SQL tuning and storage optimizations. The Oracle Diagnostic Pack is a prerequisite product to the Oracle Tuning Pack. Therefore, to use the Tuning Pack, you must also have a Diagnostic Pack. The Tuning Pack includes the following features:

1.SQL Access Advisor :


ORA-00600 , PLS-707, ORA-06553, ORA-06544


ORA-06553 unsupported construct or internal error 

Follow Below for errors observed in Oracle 8i,9i DB's due to unsupported pl/sql tool version