Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!newsfeed.freenet.de!feeder.news-service.com!news.astraweb.com!newsrouter-eu.astraweb.com!border2.nntp.ams.giganews.com!nntp.giganews.com!feeder4.cambrium.nl!feed.tweaknews.nl!63.218.45.11.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail
Date: Thu, 03 May 2007 15:37:12 -0700
From: DA Morgan <damorgan@psoug.org>
Organization: Puget Sound Oracle Users Group
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: RAC, user equivalence
References: <pan.2007.05.03.20.06.57@not-at-verizon.net>	<1178225074.590812.8890@y5g2000hsa.googlegroups.com> <pan.2007.05.03.21.01.11@not-at-verizon.net>
In-Reply-To: <pan.2007.05.03.21.01.11@not-at-verizon.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <1178231829.110398@bubbleator.drizzle.com>
Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 43
X-Complaints-To: abuse@csolutions.net
Xref: news.f.de.plusline.net comp.databases.oracle.server:197398

Mladen Gogala wrote:
> On Thu, 03 May 2007 13:44:34 -0700, Keith wrote:
> 
>> I had a similar problem at one point where user equivalence was
>> "working" but cluvfy said no-no.  I ended up following the steps in
>> Metalink note 300548.1 to get it going.
> 
> I configured RSA keys. Do I really need to configure DSA keys, too?
> This is idiotic.

Yes.

$ pgrep sshd
$ cd ~
$ pwd
$ mkdir .ssh
$ chmod 700 .ssh
$ /usr/bin/ssh-keygen -t rsa
$ /usr/bin/ssh-keygen -t dsa
$ cd ~/.ssh
$ touch authorized_keys

$ ssh alpha1 cat /home/oracle/.ssh/id_rsa.pub >> 
authorized_keysoracle@node1's password:	$ ssh alpha1 cat 
/home/oracle/.ssh/id_dsa.pub >> authorized_keys$ ssh alpha2 cat 
/home/oracle/.ssh/id_rsa.pub >> authorized_keysoracle@node2's password:$ 
ssh alpha2 cat /home/oracle/.ssh/id_dsa.pub >> 
authorized_keysoracle@node2's password:

$ chmod 600 ~/.ssh/authorized_keys
$ cat authorized_keys | grep psoug.org --color

$ cd /stage/setup
$ cp config /home/oracle/.ssh

Aren't you glad you asked. <g>
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
