设为首页 收藏本站
查看: 2416|回复: 0

[经验分享] Oralce 自带创建互信脚本-sshUserSetup.sh

[复制链接]
累计签到:1 天
连续签到:1 天
发表于 2017-9-15 10:08:16 | 显示全部楼层 |阅读模式
Oracle 12cR1 测试自带互信脚本,路径为安装文件解压后的./grid/sshsetup/下

1.脚本路径

<roidb01:+ASM:/home/grid>$cd /soft/grid
<roidb01:+ASM:/soft/grid>$ls
install  response  rpm  runcluvfy.sh  runInstaller  sshsetup  stage  welcome.html
<roidb01:+ASM:/soft/grid>$cd sshsetup/
<roidb01:+ASM:/soft/grid/sshsetup>$ls
sshUserSetup.sh
<roidb01:+ASM:/soft/grid/sshsetup>$

2.脚本帮助

<roidb01:orcl:/home/oracle>$cd /soft/grid/
<roidb01:orcl:/soft/grid>$ls
install  response  rpm  runcluvfy.sh  runInstaller  sshsetup  stage  welcome.html
<roidb01:orcl:/soft/grid>$./sshsetup/sshUserSetup.sh -h
Please specify a valid and existing cluster configuration file.
Either user name or host information is missing
Usage ./sshsetup/sshUserSetup.sh -user <user name> [ -hosts "<space separated hostlist>" | -hostfile <absolute path of cluster configuration file> ] [ -advanced ]  [ -verify] [ -exverify ] [ -logfile <desired absolute path of logfile> ] [-confirm] [-shared] [-help] [-usePassphrase] [-noPromptPassphrase]

3.执行脚本,需要输入用户和主机名,后续还要输入密码

<roidb01:orcl:/soft/grid>$./sshsetup/sshUserSetup.sh -user grid -hosts "roidb01 roidb02" -advanced -noPromptPassphrase  
The output of this script is also logged into /tmp/sshUserSetup_2017-09-14-08-02-35.log
Hosts are roidb01 roidb02
user is grid
Platform:- Linux
Checking if the remote hosts are reachable
PING roidb01 (192.168.1.111) 56(84) bytes of data.
64 bytes from roidb01 (192.168.1.111): icmp_seq=1 ttl=64 time=0.014 ms
64 bytes from roidb01 (192.168.1.111): icmp_seq=2 ttl=64 time=0.020 ms
64 bytes from roidb01 (192.168.1.111): icmp_seq=3 ttl=64 time=0.023 ms
64 bytes from roidb01 (192.168.1.111): icmp_seq=4 ttl=64 time=0.022 ms
64 bytes from roidb01 (192.168.1.111): icmp_seq=5 ttl=64 time=0.022 ms

--- roidb01 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 3999ms
rtt min/avg/max/mdev = 0.014/0.020/0.023/0.004 ms
PING roidb02 (192.168.1.112) 56(84) bytes of data.
64 bytes from roidb02 (192.168.1.112): icmp_seq=1 ttl=64 time=0.314 ms
64 bytes from roidb02 (192.168.1.112): icmp_seq=2 ttl=64 time=0.159 ms
64 bytes from roidb02 (192.168.1.112): icmp_seq=3 ttl=64 time=0.198 ms
64 bytes from roidb02 (192.168.1.112): icmp_seq=4 ttl=64 time=0.200 ms
64 bytes from roidb02 (192.168.1.112): icmp_seq=5 ttl=64 time=0.322 ms

--- roidb02 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4001ms
rtt min/avg/max/mdev = 0.159/0.238/0.322/0.068 ms
Remote host reachability check succeeded.
The following hosts are reachable: roidb01 roidb02.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
firsthost roidb01
numhosts 2
The script will setup SSH connectivity from the host roidb01 to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host roidb01
and the remote hosts without being prompted for passwords or confirmations.

NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.

NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEDGES TO THESE
directories.

Do you want to continue and let the script make the above mentioned changes (yes/no)?
yes

The user chose yes
User chose to skip passphrase related questions.
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup.
Removing old private/public keys on local host
Running SSH keygen on local host with empty passphrase
Generating public/private rsa key pair.
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
6e:ce:31:81:d0:9a:8e:fe:04:2b:e1:68:49:17:46:4d oracle@roidb01
The key's randomart image is:
+--[ RSA 1024]----+
|   .oE           |
|  .  o           |
|   o. .          |
|  . .+ .         |
|....o . S        |
|+.o=   . .       |
|o+o o   =        |
|.o .   + o       |
|  ...   o        |
+-----------------+
Creating .ssh directory and setting permissions on remote host roidb01
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR grid. THIS IS AN SSH REQUIREMENT.
The script would create ~grid/.ssh/config file on remote host roidb01. If a config file exists already at ~grid/.ssh/config, it would be backed up to ~grid/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host roidb01.
Warning: Permanently added 'roidb01,192.168.1.111' (ECDSA) to the list of known hosts.
grid@roidb01's password:
Done with creating .ssh directory and setting permissions on remote host roidb01.
Creating .ssh directory and setting permissions on remote host roidb02
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR grid. THIS IS AN SSH REQUIREMENT.
The script would create ~grid/.ssh/config file on remote host roidb02. If a config file exists already at ~grid/.ssh/config, it would be backed up to ~grid/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host roidb02.
Warning: Permanently added 'roidb02,192.168.1.112' (ECDSA) to the list of known hosts.
grid@roidb02's password:
Done with creating .ssh directory and setting permissions on remote host roidb02.
Copying local host public key to the remote host roidb01
The user may be prompted for a password or passphrase here since the script would be using SCP for host roidb01.
grid@roidb01's password:
Done copying local host public key to the remote host roidb01
Copying local host public key to the remote host roidb02
The user may be prompted for a password or passphrase here since the script would be using SCP for host roidb02.
grid@roidb02's password:
Done copying local host public key to the remote host roidb02
Creating keys on remote host roidb01 if they do not exist already. This is required to setup SSH on host roidb01.
Generating public/private rsa key pair.
Your identification has been saved in .ssh/id_rsa.
Your public key has been saved in .ssh/id_rsa.pub.
The key fingerprint is:
29:1f:ed:1c:a2:9c:5b:a1:d9:be:71:32:6d:b1:05:fb grid@roidb01
The key's randomart image is:
+--[ RSA 1024]----+
|                 |
|                 |
|          .      |
|         o o     |
|      . S = .    |
|     . O B *     |
|      * B B E    |
|       + *       |
|      . o.       |
+-----------------+
Creating keys on remote host roidb02 if they do not exist already. This is required to setup SSH on host roidb02.
Generating public/private rsa key pair.
Your identification has been saved in .ssh/id_rsa.
Your public key has been saved in .ssh/id_rsa.pub.
The key fingerprint is:
7b:84:f0:b2:f2:89:d9:f3:fb:38:38:65:50:ce:0a:11 grid@roidb02
The key's randomart image is:
+--[ RSA 1024]----+
|    E.           |
|    .   .        |
|     ..+         |
|    . .oo.       |
|     ..oS .      |
|      .ooo       |
|    . .+. .      |
|     *+..o       |
|    o ++++.      |
+-----------------+
Updating authorized_keys file on remote host roidb01
Updating known_hosts file on remote host roidb01
Updating authorized_keys file on remote host roidb02
Updating known_hosts file on remote host roidb02
SSH setup is complete.

------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user grid.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~grid or ~grid/.ssh on the remote host may not be owned by grid.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--roidb01:--
Running /usr/bin/ssh -x -l grid roidb01 date to verify SSH connectivity has been setup from local host to roidb01.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Thu Sep 14 08:03:37 CST 2017
------------------------------------------------------------------------
--roidb02:--
Running /usr/bin/ssh -x -l grid roidb02 date to verify SSH connectivity has been setup from local host to roidb02.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Thu Sep 14 08:03:37 CST 2017
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from roidb01 to roidb01
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Thu Sep 14 08:03:38 CST 2017
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from roidb01 to roidb02
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Thu Sep 14 08:03:38 CST 2017
------------------------------------------------------------------------
-Verification from complete-
SSH verification complete.
<roidb01:orcl:/soft/grid>$ssh roidb02 date
oracle@roidb02's password:
Permission denied, please try again.
oracle@roidb02's password:
Permission denied, please try again.
oracle@roidb02's password:
Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password).
4.测试验证

<roidb01:orcl:/soft/grid>$ssh roidb02
oracle@roidb02's password:

<roidb01:orcl:/soft/grid>$whoami
oracle
<roidb01:orcl:/soft/grid>$exit
logout
[iyunv@roidb01 ~]# su - grid
Last login: Thu Sep 14 07:58:16 CST 2017
<roidb01:+ASM:/home/grid>$ssh roidb02 date
Thu Sep 14 08:05:01 CST 2017

<roidb01:+ASM:/home/grid>$

<roidb02:+ASM:/home/grid>$ssh roidb01 date
Thu Sep 14 08:09:57 CST 2017

<roidb02:+ASM:/home/grid>$


运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.iyunv.com/thread-404568-1-1.html 上篇帖子: Oracle 12C RAC数据迁移 下篇帖子: Oracle 11g单实例RMAN恢复到Oracle 11g RAC
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表