Oracle EBS的DB Server无法启动

最新推荐文章于 2023-03-02 07:59:52 发布

田攀

最新推荐文章于 2023-03-02 07:59:52 发布

阅读量7.1k

点赞数 1

文章标签： oracle server credentials network file warnings

本文链接：https://blog.csdn.net/pan_tian/article/details/7705275

版权

在冷备份后，尝试启动Oracle EBS的Apps Server时遇到错误，提示数据库连接失败。通过一系列步骤，如验证DB Listener状态、网络连接、端口监听、tnsping及查看进程，确认DB Listener已启动，但仍然无法连接数据库。问题可能在于数据库未完全关闭，尝试使用addbctl.sh stop abort强制关闭后再启动，以解决无法启动的问题。

摘要由CSDN通过智能技术生成

冷备份系统后，然后重启DB Listener和DB没报什么错误，再起通过命令adstrtal.sh apps/apps来启动Apps Server的时候报错

[oracle@bej301441 scripts]$ adstrtal.sh apps/password
You are running adstrtal.sh version 120.15.12010000.3
adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.
USAGE: adstrtal.sh <appsusername/appspassword>
adstrtal.sh <applications_username/applications_password> -secureapps
adstrtal.sh -nodbchk
adstrtal.sh: exiting with status 1

如果DB有问题的话，那么./adstrtal.sh apps/apps 是不会启动的。

解决过程：
然后检查DB的情况，尝试用sqlplus来连instance.

[oracle@bej301441 mc3yd213_bej301441]$ sqlplus apps/password@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\AD