Oracle EBS的DB Server无法启动
Oracle EBS的DB Server无法启动解决方法,使用addbctl.sh stop abort来关闭数据库,再用addbctl.sh start启动。之前关闭DB的时候
冷备份系统后(见Oracle EBS系统整体备份(冷备份) ),然后重启DB Listener和DB没报什么错误,再起通过命令adstrtal.sh apps/apps来启动Apps Server的时候报错
如果DB有问题的话,那么./adstrtal.sh apps/apps 是不会启动的。
解决过程:
然后检查DB的情况,尝试用sqlplus来连instance.
[oracle@bej301441 mc3yd213_bej301441]$ sqlplus apps/apps@mc3yd213
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Jun 30 03:18:39 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
Enter user-name:
sqlplus不能连上instance,那么应该是数据库的问题。
ping服务器的IP
C:\Documents and Settings\ptian>ping 10.182.74.181
Pinging 10.182.74.181 with 32 bytes of data:
Reply from 10.182.74.181: bytes=32 time=229ms TTL=57
Reply from 10.182.74.181: bytes=32 time=230ms TTL=57
Reply from 10.182.74.181: bytes=32 time=230ms TTL=57
Reply from 10.182.74.181: bytes=32 time=228ms TTL=57
Ping statistics for 10.182.74.181:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 228ms, Maximum = 230ms, Average = 229ms
C:\Documents and Settings\ptian>
能够ping通,说明网络没问题
SELINUX=disabled,防火墙也是关闭的,,不存在防火墙阻挡的问题。
[oracle@bej301441 mc3yd213_bej301441]$ vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
# targeted - Only targeted network daemons are protected.
# strict - Full SELinux protection.
SELINUXTYPE=targeted
tnsping这个instance
C:\Documents and Settings\ptian>tnsping mc3yd213
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 30-6月 -2012 18:14:29
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = bej301441.cn.oracle.com)(PORT = 1522)) (CONNECT_DATA = (SID = mc3yd213)))
OK (770 msec)
C:\Documents and Settings\ptian>
这是说明服务器端DB Listener已经启动了。
上一篇: 谷歌新专利:无人驾驶车可识别转向信号
下一篇: 如何保护与破解Word2007制作的论文
推荐阅读
-
Oracle EBS的DB Server无法启动
-
修改计算机名或IP后Oracle10g服务无法启动的解决方法
-
解决SQL Server无法启动的小技巧
-
修改计算机名或IP后Oracle10g无法启动服务的解决办法
-
SQL Server代理服务无法启动的解决方法
-
修改计算机名或IP后Oracle10g服务无法启动的解决方法
-
解决SQL Server无法启动的小技巧
-
在Windows2012下安装SQL Server 2005无法启动服务的解决办法
-
ORACLE运行报错“ORA-01081:无法启动已在运行的ORACLE-请首先关闭它”的解决办法
-
sql server 2008数据库无法启动的解决办法(图文教程)