ITPub博客

首页 > 数据库 > Oracle > 在青云平台Centos7.2上安装oracle11gDB出现故障及解决方法

在青云平台Centos7.2上安装oracle11gDB出现故障及解决方法

原创 Oracle 作者:yangqi2015 时间:2018-06-24 13:06:16 0 删除 编辑


故障1 : 当运行安装时,打开另一个session时,无法敲入任何命令

 

 

开SecureCRT登陆青云跳板机 :

 

[root@lxjk01 ~]# ping 172.50.100.111

PING 172.50.100.111 (172.50.100.111) 56(84) bytes of data.

64 bytes from 172.50.100.111: icmp_seq=1 ttl=64 time=0.202 ms

64 bytes from 172.50.100.111: icmp_seq=2 ttl=64 time=0.233 ms

^C

--- 172.50.100.111 ping statistics ---

2 packets transmitted, 2 received, 0% packet loss, time 999ms

rtt min/avg/max/mdev = 0.202/0.217/0.233/0.021 ms

[root@lxjk01 ~]# ssh 172.50.100.111

Warning: Permanently added '172.50.100.111' (ECDSA) to the list of known hosts.

root@172.50.100.111's password:

Permission denied, please try again.

root@172.50.100.111's password:

Last failed login: Mon Jun 11 09:43:02 CST 2018 from 172.30.100.9 on ssh:notty

There were 2 failed login attempts since the last successful login.

Last login: Fri Jun  8 19:46:50 2018 from 172.30.100.8

[root@oracle04 ~]#

[root@oracle04 ~]#

[root@oracle04 ~]# ifconfig

eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500

        inet 172.50.100.111  netmask 255.255.255.0  broadcast 172.30.100.255

        inet6 fe80::5054:aaff:fee3:d098  prefixlen 64  scopeid 0x20<link>

        ether 52:54:aa:e3:d0:98  txqueuelen 1000  (Ethernet)

        RX packets 1040986  bytes 5077303885 (4.7 GiB)

        RX errors 0  dropped 0  overruns 0  frame 0

        TX packets 1027635  bytes 180868716 (172.4 MiB)

        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

 

lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536

        inet 127.0.0.1  netmask 255.0.0.0

        inet6 ::1  prefixlen 128  scopeid 0x10<host>

        loop  txqueuelen 0  (Local Loopback)

        RX packets 260  bytes 15600 (15.2 KiB)

        RX errors 0  dropped 0  overruns 0  frame 0

        TX packets 260  bytes 15600 (15.2 KiB)

        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

 

[root@oracle04 ~]#

[root@oracle04 ~]# cd /tmp/CVU_11.2.0.1.0_oracle/

[root@oracle04 CVU_11.2.0.1.0_oracle]# ll

总用量 2140

-rwxr-xr-x 1 oracle oinstall    8173 7月  15 2009 cvuqdisk-1.0.7-1.rpm

-rwxr-xr-x 1 oracle oinstall 2093821 8月   1 2009 exectask

-rwxr-xr-x 1 oracle oinstall     223 8月   1 2009 exectask.sh

drwxr-xr-x 3 oracle oinstall    4096 6月   8 20:53 fixup

-rw-r--r-- 1 oracle oinstall      53 6月   8 20:53 fixup.enable

-rw-r--r-- 1 oracle oinstall      93 6月   8 20:53 fixup.response

-rwxr-xr-x 1 oracle oinstall   61253 8月   1 2009 orarun.sh

-rwxr-xr-x 1 oracle oinstall     975 8月   1 2009 runfixup.sh

drwxrwxrwx 2 oracle oinstall    4096 6月   8 20:53 scratch

[root@oracle04 CVU_11.2.0.1.0_oracle]# ./runfixup.sh

Response file being used is :./fixup.response

Enable file being used is :./fixup.enable

Log file location: ./orarun.log

Setting Kernel Parameters...

The value for semmni in response file is not greater than value of semmni for current session. Hence not changing it.

The value for semmni in response file is not greater than value for semmni in /etc/sysctl.conf file. Hence not changing it.

uid=1000(oracle) gid=1000(oinstall) 组=1000(oinstall),1001(dba)

[root@oracle04 CVU_11.2.0.1.0_oracle]#

 

 

[root@oracle04 CVU_11.2.0.1.0_oracle]# sysctl -p

kernel.shmmax = 12884901888

kernel.shmmni = 4096

kernel.shmall = 4194304

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

fs.file-max = 6815744

fs.aio-max-nr = 1048576

[root@oracle04 CVU_11.2.0.1.0_oracle]#

 

故障2 : 内核参数设置大于要求可还是报内存最小设置不足

 

 因为内核配置的内存使用大于Oracle安装的最小要求,所以脚本实际没有对参数进行改动.

 

  

[root@oracle04 os_packages]# /data/app/oracle/product/11.2.0/dbhome_1/root.sh

Running Oracle 11g root.sh script...

 

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /data/app/oracle/product/11.2.0/dbhome_1

 

Enter the full pathname of the local bin directory: [/usr/local/bin]:

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

 

 

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

[root@oracle04 os_packages]#

 

故障3 : 出现如下画面,一直转圈,好几个小时一直如此,无法输入任何字符或执行下一步

 

 

故障4 : 缺包并ins_ctx.mk 映射关系错误

 

 

一般情况都是缺包,用yum 把需要的包全部打上之后,再次安装就没有问题了。
yum install -y  libXp.i686 libXp-devel.i686 libXt.i686 libXt-devel.i686 libXtst.i686 libXtst-devel.i686 make.x86_64 gcc.x86_64 libaio.x86_64 glibc-devel.i686 libgcc.i686
yum install -y  glibc-devel.x86_64 compat-libstdc++-33

yum install glibc* gcc* make* compat-db* libstdc* libXp* libXtst* compat-libstdc++*  -y

其次就是环境变量的问题 看看PATH 和 LD_LIBRARY_PATH
都要加上$ORACLE_HOME/lib
64位加上 $ORACLE_HOME/lib64

 

/lib64/libstdc++.so中memcpy@GLIBC_2.4找不到。

问题:glibc是2.17的库,连接找的是2.14的库。

解决办法:改成静态链接。

查看 /usr/lib64/libc.a是否存在。

修改oracle安装目录下:$ORACLE_HOME/ctx/lib/ins_ctx.mk

ctxhx: $(CTXHXOBJ)

        $(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK)

 

修改为:

ctxhx: $(CTXHXOBJ)

        -static $(LINK_CTXHX) $(CTXHXOBJ) $(INSO_LINK) /usr/lib64/libc.a

 

然后点击retry通过。

故障5 : 如下

 

x86_64下:

yum install -y libaio glibc compat-libstdc++-33 elfutils-libelf-devel libaio-devel libstdc++ unixODBC unixODBC-devel ksh

另外还需安装一个pdksh包,网上下载安装时可能与ksh包冲突,可以卸掉ksh包再装pdksh包,也可以直接强制安装pdksh包,强制安装语句:

rpm -ivh --force --nodeps pdksh-5.2.14-30.x86_64.rpm

 

 

 

cd   /data/app/oracle/product/11.2.0/dbhome_1/sysman/lib

 

修改ins_emagent.mk 文件

 

#===========================

#  emdctl

#===========================

 

$(SYSMANBIN)emdctl:

        $(MK_EMAGENT_NMECTL)

 

修改为:

$(SYSMANBIN)emdctl:

        $(MK_EMAGENT_NMECTL)-lnnzll

 

 

 

 

然后  Retry

如果还是retry不了直接continues

 

 

 

 

 

 

 

点下一步时出现以下情况:

 故障6 : 出现如上白屏(如果一直等待,则一直是白屏状态)

 

 

 

打开数据库建库过程日志

Cd  $ORACLE_BASE/cfgtoollogs/dbca/logs/

Tail   -f   trace.log_OraDb11g_home1

 

找到运行的命令窗口直接多次点击回车.  最后回完成安装.

 

数据库创建完毕后Netca建立 Listener

 

 

故障7:   sqlplus  test/test_John@health  通过网络方式登陆速度非常慢. 跳开网络映射 sqlplus  test/test_John速度非常快

 
检查私有云双网卡映射关系,消除网络延迟故障


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30230358/viewspace-2156580/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2015-05-01

  • 博文量
    9
  • 访问量
    15316