Custom Search . . .

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


Monday, February 22, 2010

ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns

Hello,

Today when i try to change database time zone setting i got the below error message.


SQL> ALTER DATABASE SET TIME_ZONE = '+00:00';
ALTER DATABASE SET TIME_ZONE = '+00:00'
*
ERROR at line 1:
ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH
LOCAL TIME ZONE columns

To avoid the above issues; follow the Document ID: 230099.1


Thanks, share with me your feedback/comments...