Oracle RAC, problem

Dear Friends,

At the time Oracle clusterware installation, I am getting this error.

The specified nodes are not clusterable
The following error was returned by the operating system
NULL


tarting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks w
ll be executed.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2008-05-29_0
-12-58PM. Please wait ...$ Oracle Universal Installer, Version 10.2.0.1.0 Produ
tion
Copyright (C) 1999, 2005, Oracle. All rights reserved.

Caught Cluster ExceptionPRKC-1044 : Failed to check remote command execution se
up for node ariepdb1 using shells /usr/bin/ssh and /usr/bin/rsh
rcmd2: socket: The file access permissions do not allow the specified action.
[PRKC-1044 : Failed to check remote command execution setup for node ariepdb1
using shells /usr/bin/ssh and /usr/bin/rsh
rcmd2: socket: The file access permissions do not allow the specified action.]
[PRKC-1044 : Failed to check remote command execution setup for node ariepdb1
using shells /usr/bin/ssh and /usr/bin/rsh
rcmd2: socket: The file access permissions do not allow the specified action.
[PRKC-1044 : Failed to check remote command execution setup for node ariepdb1
using shells /usr/bin/ssh and /usr/bin/rsh
rcmd2: socket: The file access permissions do not allow the specified action.]]


Please help me out,

Regards,
Muz

Edit by admin: no contact info permitted on the forum, thank you

do you have access to ssh and rsh

Dear Friend,

I have access to ssh and rsh, but when i m trying to connect 1 to 2nd Node it asking me password, see blow

$ ssh node2
1 unsuccessful login attempt since last login.
Last unsuccessful login: Thu May 29 12:03:02 WST 2008 on /dev/pts/4 from 10.51.
0.216
Last login: Thu May 29 12:02:20 WST 2008 on /dev/pts/4 from 10.51.20.216
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
$ hostname
node2

$ rsh node2
oracle's Password:
*******************************************************************************
* *
* *
* Welcome to AIX Version 5.3! *
* *
* *
* Please see the README file in /usr/lpp/bos for information pertinent to *
* this release of the AIX Operating System. *
* *
* *
*******************************************************************************
Last unsuccessful login: Thu May 29 12:03:02 WST 2008 on /dev/pts/4 from 10.51.2
0.216
Last login: Sun Jun 1 09:06:05 WST 2008 on /dev/pts/0 from ariepdb1

$ hostname
node2

PLEASE HELP ME OUT.

Thanks,
Muz

you havent set up ssh and rsh to not ask for passwords then, you must do that which are part of the installation instructions

I configure ssh like that, is it correct ???

TWO NODES
$/home/oracle
mkdir .ssh
chmod 777 .ssh
ssh-keygen -t rsa
ssh-keygen -t dsa

SINGLE NODE
ssh rac1 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
ssh rac1 cat /home/oracle/.ssh/id_dsa.pub >> authorized_keys
ssh rac2 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
ssh rac2 cat /home/oracle/.ssh/id_dsa.pub >> authorized_keys
scp authorized_keys rac2:/home/oracle/.ssh
scp known_hosts rac2:/home/oracle/.ssh

plz. see the steps, & reply me soon.

Regards,
Muz

did it work when you did that

after configuration ssh, I am able to connect Node1 to Node2 without any password, but when i connect from Node2 to Node1 it asking oracle password.

Regards,
Muz

Hi Everyone,

I am New to AIX ...
Please help me out with details how to Install & Enable SSH on AIX 5.3.
Kindly give the detailed steps.

Thanks in advance.
Muzammil
email: [email protected]

well do what you did on one node, to the other node as well

BOTH NODES
$/home/oracle
mkdir .ssh
chmod 777 .ssh
ssh-keygen -t rsa
ssh-keygen -t dsa


NODE1 Only:

ssh rac1 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
ssh rac1 cat /home/oracle/.ssh/id_dsa.pub >> authorized_keys
ssh rac2 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
ssh rac2 cat /home/oracle/.ssh/id_dsa.pub >> authorized_keys
scp authorized_keys rac2:/home/oracle/.ssh
scp known_hosts rac2:/home/oracle/.ssh


Regards,
Muz

yeah you posted that already

I am new to AIX...
I don't no how to Enable SSH in AIX
Plz. send me the solution.

doing RAC installation again got the error while a screen called

Configuration assistants

Oracle Notification server configuration assitant Succeeded Recommended.
Oracle Private Interconnect Configuration assistant Succeeded Recommended.
Oracle Cluster Verficiation Utility Failed Recommended

With Error OUI-25031

any one help out this problem

Dear Friends,

Plz. help me out.

Again I got the error while cluster installation, a screen called

Configuration assistants

Oracle Notification server configuration assitant Succeeded Recommended.
Oracle Private Interconnect Configuration assistant Succeeded Recommended.
Oracle Cluster Verficiation Utility Failed Recommended

With Error OUI-25031

but there is no file ...
/opt/crs/oracle/cfgtoollogs/configtoolfailedcommands in the nodes.

& we verified the below commands with success results.

cd /opt/crs/oracle/bin
$./olsnodes -n
it gave output
rac1
rac2

Should I continue with this Cluster verification utility fail or should we wait.

Regards,
Muz

its about time you opened an SR or found a dba as people on a forum cant help you

Already I have created SR, till now, i did'nt get any response overthere.

please help me anyone.

Thanx in advance,

Regards,
Muz

Quote:

---

Originally Posted by muzammil.dba

Already I have created SR, till now, i did'nt get any response overthere.

please help me anyone.

Thanx in advance,

Regards,
Muz

---

At what severity level did you open your SR?

Is it critical? call Oracle Support and ask them to escalate your SR to sev=1

Also ask them to assign the SR to an engineer in your time zone.

Quote:

---

Originally Posted by muzammil.dba

I am new to AIX...
I don't no how to Enable SSH in AIX
Plz. send me the solution.

---

You enable ssh in AIX the same way as you do for any Unix.

This is not valid: chmod 777 .ssh the permissions should be mode 700.
Also the ~/.ssh/authorized_keys on the each site should be mode 600.
:rolleyes:

Hi,

Follow the steps in the attachment for your ssh configuration on AIX...

Hey All,

Now ssh configured on AIX 5.3, but I face some other issue, when I am trying connect from Node1 to Node2 or Node2 to Node1 with the help of ssh, some time it will connect with in 1 second, & some time it will take more time(10-15 mints) to connect both the nodes & after couple of mininutes I got this error.

$ ssh: connect to host rac1 port 22: Connection timed out

plz. send me the solution.

Thanks,
Muz

Hi,
I'm trying the 2 following method and everything was succefully configured to install oracle10+11g on Linux .

I hope will help you .


During the installation, both RSH and RSH-Server were installed.
Enable remote shell and rlogin by doing the following.

# chkconfig rsh on
# chkconfig rlogin on
# service xinetd reload

Create the /etc/hosts.equiv file as the root user.

# touch /etc/hosts.equiv
# chmod 600 /etc/hosts.equiv
# chown root:root /etc/hosts.equiv

Edit the /etc/hosts.equiv file to include all the RAC nodes:

+rac1 oracle
+rac2 oracle
+rac1-priv oracle
+rac2-priv oracle


And testing without asking for a password :

ON RAC1 as user root
#
# su - orale
rac1$
$ rsh rac2 -l oracle
rac2$
CTR-D
rac1$
rac1$ rsh rac2 "ls"
rac2$


Everything is OK...





=========================
Configure SSH on each node in the cluster.
Log in as the "oracle" user and perform the following tasks on each node.

su - oracle
mkdir ~/.ssh
chmod 700 ~/.ssh
/usr/bin/ssh-keygen -t rsa # Accept the default settings.

The RSA public key is written to the ~/.ssh/id_rsa.pub file and the private key to the ~/.ssh/id_rsa file.

Log in as the "oracle" user on RAC1, generate an "authorized_keys" file on RAC1 and copy it to RAC2 using the following commands.

su - oracle
cd ~/.ssh
cat id_rsa.pub >> authorized_keys
scp authorized_keys rac2:/home/oracle/.ssh/

Next, log in as the "oracle" user on RAC2 and perform the following commands.

su - oracle
cd ~/.ssh
cat id_rsa.pub >> authorized_keys
scp authorized_keys rac1:/home/oracle/.ssh/

The "authorized_keys" file on both servers now contains the public keys generated on all RAC nodes.

To enable SSH user equivalency on the cluster member nodes issue the following commands on each node.

ssh rac1 date
ssh rac2 date
exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add

You should now be able to SSH and SCP between servers without entering passwords.

Dear Friends,

I have created RAC db on AIX, but some of the crs target application are OFFLINE.

$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....b1.inst application 0/5 0/0 ONLINE ONLINE ariepdb1
ora....b2.inst application 0/5 0/0 ONLINE OFFLINE
ora.ariepdb.db application 0/1 0/1 ONLINE ONLINE ariepdb2
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb1
ora....db1.gsd application 0/5 0/0 ONLINE ONLINE ariepdb1
ora....db1.ons application 0/3 0/0 ONLINE ONLINE ariepdb1
ora....db1.vip application 0/0 0/0 ONLINE ONLINE ariepdb1
ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb2
ora....B2.lsnr application 0/5 0/0 ONLINE ONLINE ariepdb2
ora....db2.gsd application 0/5 0/0 ONLINE ONLINE ariepdb2
ora....db2.ons application 0/3 0/0 ONLINE ONLINE ariepdb2
ora....db2.vip application 0/0 0/0 ONLINE ONLINE ariepdb2

Please help me out !!!
Thanks & Regards,
Muz

start them then?

Hi,

Please help me out, I have created Oracle 10g RAC db, when I connect from Node2 it connected then I m trying to connect from Node1 I am getting this error message.

Enter user-name: /as sysdba
ERROR:
ORA-12162: TNS:net service name is incorrectly specified

Please send me the solution.

Thanks,
Muz

Rtfm

What is this mean Rtfm

& End of Oracle 10g RAC db creation I got this error message.



Failed to start service "[ariepdb_rac' of cluster db 'ariepdb, 'PRKP-1030': failed to start the service ariepdb_rac

crs-1006: No more member to consider

crs-0215: could not start resource ora.ariepdb.ariepdb_rac.cs



PRKT-1001 error starting instance ariepdb1 on ariepdb1

crs-0215: could not start resource ora.ariepdb1.ariepdb_rac.cs

PRKT-1001 error starting instance ariepdb2 on ariepdb2

crs-0215: could not start resource ora.ariepdb2.ariepdb_rac.cs



when I m trying to connect from Node1 instance, it through out error.



Enter user-name: /as sysdba

ERROR:

ORA-12162: TNS:net service name is incorrectly specified


please help me out.
Thanks,

Make sure your ORACLE_SID & ORACLE_HOME are set correctly, then restart whatever node/service that's not starting, using either the srvctl utility or sqlplus...

Dear divroro,

Thanks a lot, I solved this issue, previously i have given in .bash_profile as oRACLE_SID=... now I change it to ORACLE_SID=..., I think this is character sensetive issue.

Once again thanks for your suggestion.

Regards,
Muz