adstrtal.sh: exiting with status 1

Hi,

We have fresh installation of EBS R12.2 on 2-node RAC. After the successful installation we shutdown the application services and DB services for backup then again started the database and application services.

We are able to connect to the EBS Database through both nodes. And it is using the SCAN Listeners configured in Grid.

The DB is up and running but on running adstrtal.sh apps/apps it gives the following error

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> [-nothreading]
adstrtal.sh <applications_username/applications_password> -secureapps
adstrtal.sh -nodbchk


adstrtal.sh: exiting with status 1

I will appreciate for providing the solution.

Thanks.

Subi Zaidi

[ErmanArslansOracleBlog]

Is your EBS DB up?
Send me following from your Apps node.. (use applmgr OS account)

1)output of tnsping $TWO_TASK
2)outpuf of sqlplus apps/apps_password
3)your tnsnames.ora that resides in 10.1.2 Home.
4)Your apps and db node names

Also from your db node; send me the following;

5)The sqlnet.ora from your database tier
6)output of lsnrctl status <listener_name> from your Database tier

Hi,

Ans. 4. It is a single node installation both Database and application on wtnoraerp1 node.


Please find the attached files as required.

Also, I want to know that during installation of EBS R12.2 on DB Node Configuration Form it asks for two port values for two file systems as Database is listening on one port only.

Also, under /DB/PROD/12.1.0/network/admin there are two directories PROD1_wtnoraerp1 and PROD_wtnoraerp1 both have sqlnet.ora file. Are these directories default creation or some problem with installation.

Thanks.Output_SQLPLUS_Listner_$TWO_TASK.txtsqlnet_PROD_wtnoraerp1.orasqlnet_PROD1_wtnoraerp1.orascreenshot_Oracle_home.PNGscreenshot_Oraclehome_networ_admin.PNGtnsnames.ora

[ErmanArslansOracleBlog]

your listener is configured wrong!

it should listen on service name "PROD" and instance name "PROD1", as well..

[ErmanArslansOracleBlog]

1)
What is the value of the parameter "local_listener"

connect to db
sqlplus "/as sysdba" (from db  node)
SQL>show parameter local_listener

2)
You say this is fresh install, but you did something right? autoconfig etc..
fresh install db won't be like this. You probably did something.. You run someting like adcfgclone, autoconfig or something else..
Tell me the things that you did.
autoconfig on db tier can fix this. But still, we need to investigate.