Custom Search . . .

Saturday, April 17, 2010

Terminating clsd session

Memorial Day and right now I am so busy at work that I haven’t had time to study. I do have a post half way complete on RAC Installation but I can finish that this weekend. So what can I blog about in the meantime?


Well today I have completed Oracle RAC Installation on Windows 2003 SP2. Next month I have a Solaris environment to setup that is RAC. I did 3 Linux ones last month (All Red Hat). What I will do is post through the install and what hiccups I ran into as well as what the gotcha were with each system.


So here we are 1:20  pm at night and I will be trying to get this done throughout the night. I am actually working on 3 posts in parallel. This, VIP Mondification on RAC Nodes, and then a post on some more RMAN Backup jobs. All good stuff. When I finish that I will try and get some more OCM 10g DBA posts up.

Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
2010-04-17 13:14:03.875: [ default][2120]Terminating clsd session

After successful RAC Installation on RAC in windows; VIP not able to start in both nodes. 5125957.8 as per metalink node i have done CRS upgrade from 10.1 to 10.2


Now I am trying to upgrade CRS 10.2.0.1 to 10.2.0.4. Once successfully completion I will update you same. 


Thanks.., Fell free to write your comments and feedback.

Saturday, April 10, 2010

SCSI Reservation Under VMware Server is only available for machine running on the same host machine

Vmware SCSI Issue. 

Today have great experience with you VMware RAC Shared Storage Issue

Vm development RAC Shared Storage configured using SCSI. Today when I try to start cluster nodes from VMWare getting the below error message







Workaround for this issue:

From shared storage we found “RESLCK” files. When I try to remove “RESLCK” files this issues resolved. 

Thanks ..

Thursday, February 25, 2010

ORA-12547: TNS:lost contact During ASM Instance Creation


Hi,

Using RHEL 4 & 10.2.0.4; I was trying to configure two node RAC Cluster. When i try configure ASM instance creation using DBCA I got the below error message.

ORA-12547: TNS:lost contact

Cluster Services & LISTENER working fine. But still not able to create ASM instance.

Work Around I:

1. Close your DBCA Session
2. Stop your cluster listener in your all the nodes
3. $ORACLE_HOME/bin

relink all

Once i relink my oracle home; it's should be work; but in my case continuously getting TNS Lost contact error message.

Work Around II:

When I try to type sqlplus in my terminal window i got some RPM package issues

-bash-3.00$ sqlplus

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 25 15:34:47 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name:
oracleoracle: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

Current RPM Version:

The RPM package libaio-0.3.103-3.X86_64.RPM has not been installed.

$ rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep libaio

libaio-0.3.105.2 (ia64)
libaio-0.3.105.2 (i386)

The output should show:

libaio-0.3.105.2 (x86_64)
libaio-0.3.105.2 (i386)


As per 394297.1; We upgraded this RPM package after it's working fine.

After Upgrade RPM Package:

rpm -qa --queryformat "%{NAME}-%{VERSION}.%{RELEASE} (%{ARCH})\n" | grep libaio

libaio-devel-0.3.105.2 (x86_64)
libaio-0.3.105.2 (x86_64)
libaio-0.3.105.2 (i386)

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 25 16:59:35 2010

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Please share with your valuable comments & feedback. Thanks