rpm prepare for rac install on linux

there are the rpm information listed on note which you can get from below

Document 811306.1 RAC and Oracle Clusterware Best Practices and Starter Kit (Linux)

check out the example on oel4 x86_64,you need to install each needed rpm package to avoid the coming error msg.

—————————————————————————————————

64-Bit Required RPM's

Red Hat,Oracle] Enterprise Linux 4:
 
binutils-2.15.92.0.2-13.0.0.0.2.x86_64 (you can install binutils-2.15.92.0.2-18.x86_64.rpm from RHEL4 Update 3.)
 
compat-db-4.1.25-9.x86_64.rpm
 
compat-gcc-32-c++ (with Patch 5240469 to correct bad genoccish file. see Note WebIV:430526.1))
 
compat-libstdc++-33-3.2.3-47.3.x86_64.rpm
 
compat-libstdc++-33-3.2.3-47.3.i386.rpm 
 
control-center-2.8.0-12.x86_64.rpm
 
gcc-3.4.3-47.x86_64.rpm
 
gcc-c++-3.4.3-47.x86_64.rpm   
 
glibc-2.3.4-2.9.x86_64.rpm   
 
glibc-2.3.4-2.9.i386.rpm   
 
glibc-common-2.3.4-2.9.x86_64.rpm   
 
glibc-devel-2.3.4-2.9.x86_64.rpm   
 
glibc-devel-2.3.4-2.9.i386.rpm   
 
glibc-headers-2.3.4-2.9.x86_64.rpm   
 
glibc-kernheaders-2.4-9.1.87.x86_64.rpm   
 
gnome-libs-1.4.1.2.90-44.1.x86_64
 
libaio-0.3.103-3.i386.rpm
 
libaio-0.3.103-3.x86_64.rpm   
 
libgcc-3.4.3-9.EL4
 
libstdc++-3.4.3-22.1.x86_64   
 
libstdc++-devel-3.4.3-22.1.x86_64   
 
make-3.80-5.x86_64.rpm
 
pdksh-5.2.14-30.x86_64.rpm   
 
sysstat-5.0.5-1.x86_64.rpm   
 
util-linux-2.12a-16.EL4.23.x86_64 (for raw devices)   
 
xorg-x11-deprecated-libs-6.8.1-23
 
xscreensaver-4.18-5.rhel4.2.x86_64.rpm   
 

——————————————————————————–

it's quite easy to find the details, you need both x86 and x86_64 in some rpm packs

issue of yum config in rhel 5u5

rhel 5u5上打rpm包是非常烦人的事情,没有license,无法连接redhat的yum源。只好寻求centos的源帮忙。

进入/etc/yum.repos.d目录,里面有一个缺省的源rhel-debuginfo.repo,删掉、重建吧,里面的内容帮助不大。

[molin@localhost downloads]$ cd /etc/yum.repos.d

[molin@localhost downloads]$ vi rhel-debuginfo.repo

文件的内容如下:

[base]
name=CentOS-5 – Base

baseurl=http://ftp.sjtu.edu.cn/centos/5/os/$basearch/
gpgcheck=1
gpgkey=http://mirror.centos.org/centos/RPM-GPG-KEY-centos5

这个时候如果你直接yum install rpm包的话,会遭遇报错:

warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key………….

还需要重新import key:

rpm –import http://centos.ustc.edu.cn/centos/RPM-GPG-KEY-CentOS-5

 

[root@hundsun ~]# yum install libaio-devel
Loaded plugins: rhnplugin, security
This system is not registered with RHN.
RHN support will be disabled.
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package libaio-devel.i386 0:0.3.106-5 set to be updated
—> Package libaio-devel.x86_64 0:0.3.106-5 set to be updated
–> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
libaio-devel i386 0.3.106-5 base 12 k
libaio-devel x86_64 0.3.106-5 base 11 k

Transaction Summary
================================================================================
Install 2 Package(s)
Upgrade 0 Package(s)

Total download size: 23 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): libaio-devel-0.3.106-5.x86_64.rpm | 11 kB 00:00
(2/2): libaio-devel-0.3.106-5.i386.rpm | 12 kB 00:00
——————————————————————————–
Total 6.8 kB/s | 23 kB 00:03
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : libaio-devel 1/2
Installing : libaio-devel 2/2

Installed:
libaio-devel.i386 0:0.3.106-5 libaio-devel.x86_64 0:0.3.106-5

Complete!

现在可以正常的yum了,当然上述的配置都是建立在这样的前提条件的:”能够ping通外网”

 

 

oracle public yum server

sometimes,you need a solution to the rpm dependency,while YUM is a better solution,if your server could access to the www, you are the luck one,check out these picked from http://public-yum.oracle.com/

Public Yum Server

 

Introduction

The Oracle public yum server offers a free and convenient way to install the latest Oracle Linux packages as well as packages from the Oracle VM installation media via a yum client.

You can download the full Oracle Linux and Oracle VM installation media via edelivery.oracle.com/linux. To stay current on errata updates, you may wish to subscribe to the Oracle Linux errata mailing list.

This yum server is offered without support of any kind. If you require support, please consider purchasing Oracle Linux Support via the online store, or via your sales representative.

Getting Started

  1. Download and Install Oracle Linux
  2. Download and copy the appropriate yum configuration file in place, by running the following commands as root:

    Oracle Linux 4, Update 6 or Newer

    # cd /etc/yum.repos.d # mv Oracle-Base.repo Oracle-Base.repo.disabled # wget http://public-yum.oracle.com/public-yum-el4.repo 

    Oracle Linux 5

    # cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-el5.repo 

    Oracle Linux 6

    # cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-ol6.repo 

    Oracle VM 2

    # cd /etc/yum.repos.d # wget http://public-yum.oracle.com/public-yum-ovm2.repo 
  3. Enable the appropriate repository by editing the yum configuration file
    • Open the yum configuration file in a text editor
    • Locate the section in the file for the repository you plan to update from, e.g. [el4_u6_base]
    • Change enabled=0 to enabled=1
  4. Begin using yum, for example:yum list

    yum install firefox

You may be prompted to confirm the import of the Oracle OSS Group GPG key.

aix errpt BFE4C025

客户的一套核心aix在巡检的时候发现了一些异常的信息。

IDENTIFIER   TIMESTAMP    T    C    RESOURCE_NAME      DESCRIPTION
BFE4C025      0625061812     P    H    sysplanar0     UNDETERMINED ERROR

详细的errpt code信息,如下:

hostname:/local/oracle#errpt -aj BFE4C025|more

—————————————————————————

LABEL: SCAN_ERROR_CHRP
IDENTIFIER: BFE4C025

Date/Time: Mon Jun 25 06:18:37 BEIST 2012
Sequence Number: 1061
Machine Id: 00C6Fxxxxx
Node Id: trade_b1
Class: H
Type: PERM
Resource Name: sysplanar0
Resource Class: planar
Resource Type: sysplanar_rspc
Location:

Description
UNDETERMINED ERROR

Failure Causes
UNDETERMINED

Recommended Actions
RUN SYSTEM DIAGNOSTICS.

Detail Data
PROBLEM DATA
0644 00E0 0000 0600 B600 8E00 0000 0000 0000 0000 4942 4D00 5048 0030 0100 3F30
2012 0624 2218 2486 2012 0624 2218 2486 4500 0106 0000 0000 0000 0000 0000 0000
502E A13F 502E A13F 5548 0018 0100 3F30 6103 4400 0000 0000 0000 A804 0000 0000
5053 00F4 0101 3F30 0201 0002 0000 00EC 003C 0001 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 3131 3030 3135 3134 2020 2020 2020 2020
2020 2020 2020 2020 2020 2020 2020 2020 C000 0029 502B 4C18 5537 3837 392E 3030
312E 4451 4432 3035 472D 4531 0000 0000 4944 1C1D 3339 4A32 3737 3900 3531 4237
594C 3131 3137 4D31 3632 3437 5045 1800 3931 3137 2D35 3730 3036 3646 3930 3000
0000 0000 502B 4C18 5537 3837 392E 3030 312E 4451 4432 3035 472D 5031 2D43 3800
4944 1C1D 3130 4E38 3530 3500 3238 4541 594C 3131 4337 3238 3532 3931 5045 1800
3931 3137 2D35 3730 3036 3646 3930 3000 0000 0000 5544 0094 0204 4400 0000 023B
2F62 696E 2F70 6F77 725F 4C34 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 6669 7073 3234 302F 6230 3832
3761 5F30 3732 352E 3234 3000 0000 0000 0000 0000 0000 0001 0000 0002 0000 0801
0000 0004 0000 0009 4D54 001C 0100 4400 3931 3137 2D35 3730 3036 3646 3930 3000
0000 0000 5544 0404 0000 3F30 0086 FE3C 0001 0086 2150 1001 0086 FE3C 0001 0086
2150 1001 0086 FE3C 0001 0086 2150 1E01 0086 FE3C 0001 0086 2150 3301 0086 FE3C
0001 0086 2150 3307 0000 FE3C 0001 0000 2159 0000 0000 FE3C 0001 0000 2159 0001
0003 FE3C 0001 0003 1064 0010 0003 FE3C 0001 0003 1064 0000 0003 FE3C 0001 0003
1065 0002 0003 FE3C 0001 0003 1065 0003 0003 FE3C 0001 0003 1100 4010 0003 FE3C
0001 0003 1100 4000 0005 FE3C 0001 0005 1062 0001 0007 FE3C 0001 0007 0101 0000
0008 FE3C 0001 0008 1016 1100 000C FE3C 0001 000C 0103 0000 000D FE3C 0001 000D
1016 1104 0012 FE3C 0001 0012 2150 2F07 0012 FE3C 0001 0012 2150 2501 0012 FE3C
0001 0012 2700 2501 0012 FE3C 0001 0012 0107 0000 0012 FE3C 0001 0012 1101 4000
0012 FE3C 0001 0012 1101 4000 0012 FE3C 0001 0012 0104 0000 0013 FE3C 0001 0013
2150 3001 0013 FE3C 0001 0013 15D7 0000 0013 FE3C 0001 0013 215B 3000 0013 FE3C
0001 0013 2150 1E01 0013 FE3C 0001 0013 1220 6000 0013 FE3C 0001 0013 2150 2401
0013 FE3C 0001 0013 2150 2401 0014 FE3C 0001 0014 2150 2501 0014 FE3C 0001 0014
2150 2501 0015 FE3C 0001 0015 1100 1000 0015 FE3C 0001 0015 1100 1000 0015 FE3C
0001 0015 1580 1000 0017 FE3C 0001 0017 1580 1001 0018 FE3C 0001 0018 2150 0A07
0018 FE3C 0001 0018 2700 0A02 0018 FE3C 0001 0018 2700 0A04 0018 FE3C 0001 0018
1580 1102 0019 FE3C 0001 0019 1580 1103 001B FE3C 0001 001B 0105 0000 001F FE3C
0001 001F 1102 0501 001F FE3C 0001 001F 1112 0001 0065 FE3C 0001 0065 1102 0700
0065 FE3C 0001 0065 13A0 1101 0065 FE3C 0001 0065 13A1 0B52 0065 FE3C 0001 0065
13A2 0103 0065 FE3C 0001 0065 13FF 0B52 0066 FE3C 0001 0066 13AF 1152 0066 FE3C
0001 0066 2150 1E01 0066 FE3C 0001 0066 2150 2001 0066 FE3C 0001 0066 2150 2001
0067 FE3C 0001 0067 2150 2101 0067 FE3C 0001 0067 2150 2101 0067 FE3C 0001 0067
2150 3707 0067 FE3C 0001 0067 2150 3607 0067 FE3C 0001 0067 13A0 1101 0067 FE3C
0001 0067 13A1 0B52 0067 FE3C 0001 0067 13A2 0106 0067 FE3C 0001 0067 13FF 0B52
0068 FE3C 0001 0068 1523 0100 0068 FE3C 0001 0068 13AF 1152 007F FE3C 0001 007F
2150 1E01 007F FE3C 0001 007F 2150 2401 007F FE3C 0001 007F 2150 2401 007F FE3C
0001 007F 2150 2001 007F FE3C 0001 007F 2150 2001 007F FE3C 0001 007F 2150 2101
007F FE3C 0001 007F 2150 2101 0080 FE3C 0001 0080 2150 3607 0080 FE3C 0001 0080
2150 3707 0080 FE3C 0001 0080 2150 0801 0080 FE3C 0001 0080 2150 0801 0082 FE3C
0001 0082 2150 0901 0082 FE3C 0001 0082 2150 0901 0084 FE3C 0001 0084 2150 2501
0084 FE3C 0001 0084 2150 2501 0086 FE3C 0001 0086 2150 0301 0086 FE3C 0001 0086
2150 0301 0088 FE3C 0001 0088 2150 1E01 0077 FE3C 0001 0077 2500 045A 0077 FE3C
0001 0077 1276 0399 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000

Diagnostic Analysis
Diagnostic Log sequence number: 548
Resource tested: sysplanar0
Resource Description: System Planar
Location:
SRC: 11001514
Description: Power/Cooling subsystem Unrecovered Error, bypassed
with loss of redundancy. Refer to the system service
documentation for more information.
Additional Words: 2-003C0001 3-00000000 4-00000000 5-00000000
6-00000000 7-00000000 8-00000000 9-00000000
Possible FRUs:
Priority: L FRU: 39J2779 S/N: YL1117M16247 CCIN: 51B7
Location: U7879.001.DQD205G-E1
Priority: L FRU: 10N8505 S/N: YL11C7285291 CCIN: 28EA
Location: U7879.001.DQD205G-P1-C8

—————————————————————————————-

description部分已经描述的很清楚了,很可能是电源、风扇的问题。

 

 

There have been too many unsuccessful login attempts; please see the system administrator

用户打来电话,在AIX上登录账户的时候遭遇报错,无法登录。
There have been too many unsuccessful login attempts; please see the system administrator
询问了客户,得知之前做过安全加固,对于登录次数、失败的次数做过严格限制,导致在多次账户密码输入错误后,登录遭遇报错。
以root用户查询/etc/security/lastlog文件

xjapan:

time_last_login = 1249055415

tty_last_login = /dev/pts/15

host_last_login = 58.22.58.88

unsuccessful_login_count = 20

time_last_unsuccessful_login = 1249057164

tty_last_unsuccessful_login = ftp

host_last_unsuccessful_login = 58.22.58.110

“unsuccessful_login_count”表示登录失败的次数,应该是尝试了20次登录没成功,而且最后一次不成功来自ftp客户端。

安全加固是双刃剑,如果在small business尤其就两个技术人员的地方,实在没必要自找麻烦。

-EOF-

aix上使用xmanager启动图形的界面

在给客户实施时经常会遇到使用aix上的图形界面的情况,例如安装oracle的时候如果对slient方式不是很熟悉,可以考虑dbca图形创建数据库实例。而redhat linux下面使用比较多的是vncserver启动gnome或者kde,在aix下面,使用较多的是xmanager去连接aix server的图形环境:例如CDE(前提是安装了图形界面)。在aix端比较方便,无需什么配置,只需要支持XDMCP协议即可,而aix上面CDE的xdmcp服务器为dtlogin,监听的端口一般为177。netstat -an|grep 177查询一下即可。
安装完Xmanager后,在Xbrowser中New一个XDMCP,选择XDM query,在Host输入框输入主机名或IP 地址,选Apply,然后Done,启动Xmanager就会显示图形登录介面了。

简单在图形界面中开启的terminal中输入如下:

su – oracle//su到oracle用户下面
设置display
trade_test:/local/oracle#export DISPLAY=192.168.201.124:0.0
trade_test:/local/oracle#dbca//图形启动了..

备注:
export DISPLAY=YourIPAddress:x.0

YourIPAddress是你运行Xmanager 的机器的IP地址。x是Xmanger那个窗口上提示的数字。一般是0。
然后就可以启动OUI安装了。

lanmanservershare

windows的共享权限都记录在注册表里面,“lanmanservershare”。如果用户遇到迁移共享文件夹的需求时,可以考虑注册表的导入导出。文件夹目录的ntfs权限应该在copy时能带过去,而共享权限都在注册表导出文件中。

–EOF–

starwind+starport做共享存储

starwind和starport是个不错的组合,如果你想在virtualbox或者vmware上测试基于共享存储的集群方案的话,可以
考虑采用iscsi的starwind服务端+starport客户端的组合。例如,mscs,oracle rac等等。。
之前有客户需求搭建模拟测试环境,在mscs+oracle做primary/standby模式测试,遇到死活找不到仲裁磁盘的错误。。
折腾了两个晚上,在朋友的建议拿starwind和starport来做共享存储,很轻松解决了,很方便。
–EOF–