Oracle ebs db Server cannot be started

After the cold backup system (see Oracle EBS system overall backup (cold backup), restart the DB Listener and DB without any errors, and then run the command adstrtal. when sh apps/apps is used to start the Apps Server, an error is reported.

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

If the DB is faulty,./adstrtal. sh apps/apps will not be started.
Solution Process:
Then, check the database and try to use sqlplus to connect to the 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,200 5, Oracle. All rights reserved.
ERROR:
ORA-12537: TNS: connection closed
Enter user-name:

Sqlplus cannot be connected to an instance, so it should be a database problem.

Ping the IP address of the server

C: \ Documents ents 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 = 229 ms TTL = 57
Reply from 10.182.74.181: bytes = 32 time = 230 ms TTL = 57
Reply from 10.182.74.181: bytes = 32 time = 230 ms TTL = 57
Reply from 10.182.74.181: bytes = 32 time = 228 ms TTL = 57
Ping statistics for 10.182.74.181:
Packets: Sent = 4, stored ED = 4, Lost = 0 (0% loss ),
Approximate round trip times in milli-seconds:
Minimum = 228 ms, Maximum = 230 ms, Average = 229 ms
C: \ Documents ents and Settings \ ptian>

If the ping is successful, the network is normal.

SELINUX = disabled. The firewall is also disabled and there is no firewall blocking problem.

[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 ents and Settings \ ptian> tnsping mc3yd213
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0-Production on-2012 18:14:29
Copyright (c) 1997,200 3, 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 ents and Settings \ ptian>

This indicates that the server DB Listener has been started.

1 2 3 Next Page