Profile cover photo
Profile photo
Santhana Pandi
8 followers
8 followers
About
Posts

Post has attachment
Remove a Node from an Existing Oracle RAC 11g R2 Cluster
Please find the below links if you want to remove a Node from ORACLE RAC. Remove a Node from an Existing Oracle RAC 11g R2 Cluster Kindly update .
Add a comment...

Post has attachment
PRCR-1001 : Resource ora.asm does not exist in Oracle 11gR2 RAC
I am trying to stop  asm in node3( vsnlmmdb06) but getting below error. [root@vsnlmmdb06 ~]#  srvctl stop asm -n vsnlmmdb06 -f PRCR-1001 : Resource ora.asm does not exist and i checked   crsctl status res -t   it is  shows list of cluster   services but ora...
Add a comment...

Post has attachment
Grid Infrastructure Disk Issues– CHM DB file: crfclust.bdb
We had issues our Live production server grid Infrastructure disk usage increasing.  I have come across an issue in 11gR2 RAC, where the GI file system  GRID_HOME  was mostly consumed by a single file called  crfclust.bdb This single file itself was about 1...
Add a comment...

Post has attachment
SRVCTL comands in Oracle RAC
SRVCTL CO mands in Oracle RAC SRVCTL: (Server Control utility) srvctl command target [options] srvctl help  or  srvctl -v srvctl -V  - prints version  srvctl version: 10.2.0.0.0 (or) srvctl version: 11.2.0.1.0 srvctl h  - print usage srvctl status servi...
Add a comment...

Post has attachment
How to Resolve Virtual IP (VIP) OFFLINE in Oracle Real Application Clusters (RAC) 11gR2?
We have 2 Node Cluster server running on Production  , Network team planed and successfully  changed subnet mask  from 255.255.x.x to 255.252.x.x .. suddenly node 1 is went down after changed changed subnet mask. I checked in cluster statues all the service...
Add a comment...

Post has attachment
ASM DISK creation failed
Marking disk "ASMDATA26" as an ASM disk:                   [FAILED] I tried to create ASM disk creation failed when you try to create ASM disk, Kindly check the created Lun size ro correct or not. [root@vsnlmmdb02 ~]# fdisk -l /dev/mapper/mpath_oradata26 Di...
Add a comment...

Post has attachment
Archive gap between PRIMARY and STANDBY
To Check the below query to confirm ARCHIVE GAP Primary and Standby  servers. A Physical Standby database syncs with Primary by continuous apply of archive logs from a Primary Database. When the logs are missing on standby difference is huge (Suppose  more ...
Add a comment...

Post has attachment
ORA-00600 Internal Error Solution Troubleshooting
Have you observed an ORA-0600 error reported in your alert log? The ORA-600 error is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. The ORA-600 error statement ...
Add a comment...

Post has attachment
The database is down. Please specify the host credentials to access database restart and diagnostics tools
The database is down. Please specify the host credentials to access database restart and diagnostics tools. Enterprise manager shows that database is down but in real it is not. [oracle@grhldb01 trace]$ sqldba

SQL*Plus: Release 11.2.0.3.0 Production on Fri...
Add a comment...

Post has attachment
How to Set password limit Unlimited in Oracle..
When You  tried login you user(TEST) it is showing password will expired with 7 Days. [oracle@k44-db1]$ sqlplus test/test SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar 11 22:34:42 2013 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Enter passw...
Add a comment...
Wait while more posts are being loaded