iis服务器助手广告广告
返回顶部
首页 > 资讯 > 数据库 >AIX 7安装11.2.0.4 RAC-(主机名大写坑)
  • 539
分享到

AIX 7安装11.2.0.4 RAC-(主机名大写坑)

2024-04-02 19:04:59 539人浏览 独家记忆
摘要

在我们安装oracle RAC的时候,要求操作系统的主机名都要小写,8个字符以内,不要使用下划线,不然我们在配置互信验证的时候是无法通过的,在配置EMCC的时候也可能有问题。 aiX + 11G RAC 手

在我们安装oracle RAC的时候,要求操作系统的主机名都要小写,8个字符以内,不要使用下划线,不然我们在配置互信验证的时候是无法通过的,在配置EMCC的时候也可能有问题。

aiX + 11G RAC 手动配置互信

分别在grid用户和oracle用户下 执行

$ ./sshsetup/sshUserSetup.sh -user grid -hosts "test1a test1b" -advanced -noPromptPassphrase
The output of this script is also logged into /tmp/sshUserSetup_2018-03-20-22-42-12.log
Hosts are test1a test1b
user is grid
PlatfORM:- AIX 
Checking if the remote hosts are reachable
PING test1a: (20.1.1.3): 56 data bytes
64 bytes from 20.1.1.3: icmp_seq=0 ttl=255 time=0 ms
64 bytes from 20.1.1.3: icmp_seq=1 ttl=255 time=0 ms
64 bytes from 20.1.1.3: icmp_seq=2 ttl=255 time=0 ms
64 bytes from 20.1.1.3: icmp_seq=3 ttl=255 time=0 ms
64 bytes from 20.1.1.3: icmp_seq=4 ttl=255 time=0 ms

--- test1a ping statistics ---
5 packets transmitted, 5 packets received, 0% packet loss
round-trip min/avg/max = 0/0/0 ms
PING test1b: (20.1.1.4): 56 data bytes
64 bytes from 20.1.1.4: icmp_seq=0 ttl=255 time=0 ms
64 bytes from 20.1.1.4: icmp_seq=1 ttl=255 time=0 ms
64 bytes from 20.1.1.4: icmp_seq=2 ttl=255 time=0 ms
64 bytes from 20.1.1.4: icmp_seq=3 ttl=255 time=0 ms
64 bytes from 20.1.1.4: icmp_seq=4 ttl=255 time=0 ms

--- test1b ping statistics ---
5 packets transmitted, 5 packets received, 0% packet loss
round-trip min/avg/max = 0/0/0 ms
Remote host reachability check succeeded.
The following hosts are reachable: test1a test1b.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
firsthost test1a
numhosts 2
The script will setup SSH connectivity from the host test1a 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 test1a
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/grid/.ssh/config, it would be backed up to /home/grid/.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/grid/.ssh/id_rsa.
Your public key has been saved in /home/grid/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:EF3sifhL3fQcDNDryrwYFuLS54euDwn6K75GJewXQMY grid@test1a
The key's randomart image is:
+---[RSA 1024]----+
| oo   .. ooo     |
| .E    .. . o    |
| . .  .. o . +   |
|  o o ... o o o  |
| . o....S. + o . |
|  o..+ oo.. o o  |
| .... =.+= .     |
|  o. . =oo=      |
| oooo..+=...     |
+----[SHA256]-----+
Creating .ssh directory and setting permissions on remote host test1a
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 /home/grid/.ssh/config file on remote host test1a. If a config file exists already at /home/grid/.ssh/config, it would be backed up to /home/grid/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host test1a.
Warning: Permanently added 'test1a,20.1.1.3' (ECDSA) to the list of known hosts.
grid@test1a's password: 
Done with creating .ssh directory and setting permissions on remote host test1a.
Creating .ssh directory and setting permissions on remote host test1b
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 /home/grid/.ssh/config file on remote host test1b. If a config file exists already at /home/grid/.ssh/config, it would be backed up to /home/grid/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host test1b.
Warning: Permanently added 'test1b,20.1.1.4' (ECDSA) to the list of known hosts.
grid@test1b's password: 
Done with creating .ssh directory and setting permissions on remote host test1b.
Copying local host public key to the remote host test1a
The user may be prompted for a password or passphrase here since the script would be using SCP for host test1a.
grid@test1a's password: 
Done copying local host public key to the remote host test1a
Copying local host public key to the remote host test1b
The user may be prompted for a password or passphrase here since the script would be using SCP for host test1b.
grid@test1b's password: 
Done copying local host public key to the remote host test1b
Creating keys on remote host test1a if they do not exist already. This is required to setup SSH on host test1a.

Creating keys on remote host test1b if they do not exist already. This is required to setup SSH on host test1b.
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:
SHA256:hcmrstSGW5DnyeR2jCZHXpIhZXO5yL9oUMYuhji+auw grid@test1b
The key's randomart image is:
+---[RSA 1024]----+
|      + ..       |
|     o +.o       |
|    .o..+..      |
|     o*o.o       |
| . .o+*.S        |
|o . +%.B.        |
|o. .=o/.o.       |
| + . @o..        |
|=E. o.           |
+----[SHA256]-----+
Updating authorized_keys file on remote host test1a
Updating known_hosts file on remote host test1a
Updating authorized_keys file on remote host test1b
Updating known_hosts file on remote host test1b
cat: 0652-050 Cannot open /home/grid/.ssh/known_hosts.tmp.
cat: 0652-050 Cannot open /home/grid/.ssh/authorized_keys.tmp.
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. /home/grid or /home/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.
------------------------------------------------------------------------
--test1a:--
Running /usr/bin/ssh -x -l grid test1a date to verify SSH connectivity has been setup from local host to test1a.
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.
Tue Mar 20 22:42:37 CST 2018
------------------------------------------------------------------------
--test1b:--
Running /usr/bin/ssh -x -l grid test1b date to verify SSH connectivity has been setup from local host to test1b.
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.
Tue Mar 20 08:41:35 CST 2018
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from test1a to test1a
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.
Tue Mar 20 22:42:38 CST 2018
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from test1a to test1b
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.
Tue Mar 20 08:41:37 CST 2018
------------------------------------------------------------------------
-Verification from complete-
SSH verification complete.
$ hostanme
ksh: hostanme:  not found.
$ hostname
test1a
$ ssh test1b
Last unsuccessful login: Tue Mar 20 08:36:55 CST 2018 on ssh from 20.1.1.3
Last login: Tue Mar 20 08:41:37 CST 2018 on ssh from 20.1.1.3
*******************************************************************************
*                                                                             *
*                                                                             *
*  Welcome to AIX Version 7.1!                                                *
*                                                                             *
*                                                                             *
*  Please see the README file in /usr/lpp/bos for information pertinent to    *
*  this release of the AIX Operating System.                                  *
*                                                                             *
*                                                                             *
*******************************************************************************
$ ssh test1a
Last unsuccessful login: Tue Mar 20 22:37:46 CST 2018 on ssh from 20.1.1.3
Last login: Tue Mar 20 22:42:38 CST 2018 on ssh from 20.1.1.3
*******************************************************************************
*                                                                             *
*                                                                             *
*  Welcome to AIX Version 7.1!                                                *
*                                                                             *
*                                                                             *
*  Please see the README file in /usr/lpp/bos for information pertinent to    *
*  this release of the AIX Operating System.                                  *
*                                                                             *
*                                                                             *
*******************************************************************************
$ 

输入一次yes,四次密码
验证方法
date;ssh 远端主机名 date 
您可能感兴趣的文档:

--结束END--

本文标题: AIX 7安装11.2.0.4 RAC-(主机名大写坑)

本文链接: https://www.lsjlt.com/news/36810.html(转载时请注明来源链接)

有问题或投稿请发送至: 邮箱/279061341@qq.com    QQ/279061341

本篇文章演示代码以及资料文档资料下载

下载Word文档到电脑,方便收藏和打印~

下载Word文档
猜你喜欢
  • mysql拒绝访问怎么办
    mysql 出现拒绝访问的原因和解决方法:权限问题:授予用户适当的数据库或表访问权限。防火墙或安全组:允许对 mysql 端口(3306)的入站连接。密码错误:重置 mysql 密码或使...
    99+
    2024-05-19
    mysql
  • mysql怎么比较日期大小
    mysql 中比较日期大小的方法包括:直接比较两个日期,使用 、= 运算符。使用 date_format() 函数将日期转换为字符串,然后比较字符串大小。使用 str_to_date()...
    99+
    2024-05-19
    mysql
  • mysql怎么加锁
    mysql中加锁是一种确保数据并发访问一致性的机制。加锁方式有:表级锁(对整个表加锁)和行级锁(对特定行加锁)。加锁类型有共享锁(允许读取但禁止修改)、排他锁(禁止读取和修改)和意向锁(...
    99+
    2024-05-19
    mysql 并发访问
  • mysql误删数据怎么恢复
    mysql误删数据可通过以下步骤恢复:停止数据库服务,防止数据覆盖。若开启binlog日志,可从中提取删除语句,再重新执行后将数据恢复。使用恢复工具修复表文件或恢复事务。从备份中恢复数据...
    99+
    2024-05-19
    mysql
  • 怎么判断mysql安装成功
    成功安装 mysql 的方法:检查命令行界面版本号;连接到 mysql 服务器,输入 "mysql -u root -p";创建数据库,输入 "create database test;...
    99+
    2024-05-19
    mysql linux macos 防火墙配置
  • mysql怎么修改表名
    如何修改 mysql 表名:检查当前表名:show tables;运行 rename table 语句:rename table 旧表名 to 新表名;验证更改:show tables;...
    99+
    2024-05-19
    mysql
  • mysql删除的表怎么恢复
    mysql 中已删除表的恢复方法主要涉及以下步骤:检查 binlog 日志以获取删除事务信息;使用数据恢复工具扫描数据库文件;从备份还原表数据;或联系 mysql 支持寻求帮助。 My...
    99+
    2024-05-19
    mysql 数据丢失
  • mysql复合主键怎么写
    在 mysql 中编写复合主键:在 create table 语句中使用 primary key 约束并列出字段名称。复合主键的好处包括提高查询效率、保证数据完整性和强制数据顺序。注意选...
    99+
    2024-05-19
    mysql
  • 怎么查看mysql数据库版本
    如何查看 mysql 数据库版本?连接到数据库并执行查询:select version();检查命令行或 mysql workbench 中的服务器属性。 如何查看 MySQL 数据库...
    99+
    2024-05-19
    mysql linux
  • 怎么检测mysql安装成功
    要验证 mysql 安装是否成功,请执行以下步骤:检查系统服务是否正在运行。使用 mysql 命令行工具连接到服务器。创建一个测试数据库并使用它。在数据库中创建一个测试表。插入测试数据并...
    99+
    2024-05-19
    mysql linux
软考高级职称资格查询
编程网,编程工程师的家园,是目前国内优秀的开源技术社区之一,形成了由开源软件库、代码分享、资讯、协作翻译、讨论区和博客等几大频道内容,为IT开发者提供了一个发现、使用、并交流开源技术的平台。
  • 官方手机版

  • 微信公众号

  • 商务合作