Search Blog Post

Saturday, March 15, 2014

adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong

Problem:
While trying to start application on middle tier, I was getting below error: $ ./adstrtal.sh apps/<apps password>
adstrtal.sh version 115.19
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: exiting with status 1


Cause:  
  • The database listener may not be up and running and please check if you can connect to the database remotely as apps/apps.
  • Also, check is the apps password is correct 
  • Please make sure you source the Correct environment file before using adstrtal.sh
Possibilities:
In our case, both the database and listener were running fine. So, it might be something else which is not letting us start the applications.
I invoked APPSORA.env to set the environment, and tried to start application again but all in vain still the same issue.

Now, when I'm trying to connect to database from CM node via SQL*Plus .. I got ORA-12545 error
 $ sqlplus
SQL*Plus: Release 8.0.6.0.0 - Production on Sat Mar 15 08:25:58 2014
(c) Copyright 1999 Oracle Corporation.  All rights reserved.
Enter user-name: apps
ERROR:
ORA-12545: Connect failed because target host or object does not exist


Alright, it seems easier to troubleshoot now as we know 

ORA-12545 is a generic error as a result of TNS configuration issue at client.

TNS configuration issue is unable to resolve host / IP specified in TNS entry
We can analyze what exactly is wrong by performing below steps
1. ping  <DB_HOST/IP>
2. telnet <DB_HOST/IP> <PORT>
3. tnsping <TNS_Alias/SID>
4. sqlplus apps@<TNS_Alias>/<apps_password>
Checks 1 and 2 were  successful when ORA-12545 is faced, but 3 and 4 were not working and making them successful will resolve the error.

Solution:
I would recommend you to follow the below steps to overcome the issue. 
  • Bounce or reload listener on DB node
  • Check if all services are down on application node, no process should be running. 
  • Run cmclean -- on Concurrent Processing node - CMCLEAN.SQL - Non Destructive Script to Clean Concurrent Manager Tables [ID 134007.1] 
  • Run autoconfig on db tier -- make sure it completes successfully. 
  • Run autoconfig on all apps tier -- make sure it completes successfully. 
  • Now, try to start applications on middle tier.

                   ++++++++++++++XXXXX+++++++++++++++
Please see the following docs, if the above fix doesn't work.
R12: "adstrtal.sh: Database connection could not be established" Error When Running Script adstrtal.sh and adstpall.sh [ID 1492611.1]
R12 Adstrtal.sh Fails with "Database Connection Could Not Be Established error starting all services on the target" [ID 1499837.1]

HTH
Thanks for reading.

83 comments:

  1. Thanks for sharing the information. It is very useful for my future. keep sharing.
    AWS training in chennai |AWS training chennai | AWS course in chennai

    ReplyDelete
  2. I learn a worthful information by this training.This makes very helpful for future reference.All the doubts are very clearly explained in this article.Thank you very much.cloud computing training in chennai | cloud computing training chennai | cloud computing course in chennai | cloud computing course chennai

    ReplyDelete
  3. I did all the things which you mentioned.But it did not helped , I am still getting this same URL error. and I am not able to run adadmin, as it is not taking my manager password

    Ankit
    .

    ReplyDelete
  4. Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly,
    but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
    Websphere Training in Chennai

    ReplyDelete
  5. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Java Training in Chennai

    ReplyDelete
  6. It is really very helpful for us and I have gathered some important information from this blog.If anyone wants to Selenium Training in Chennai reach Greens Technology training and placement academy.
    selenium Training in Chennai

    ReplyDelete
  7. Latest Govt Bank Railway Jobs Notification 2016

    Posts your shared useful information and meaningful life, I'm glad to be reading this article and hope to soon learn the next article. thank you....................

    ReplyDelete
  8. Excellent information with unique content and it is very useful to know about the information based on blogs.
    the best android training institute

    ReplyDelete
  9. A pioneer Institute owned by industry professionals to impart vibrant, innovative and global education in the field of Hospitality to bridge the gap of 40 lakh job vacancies in the Hospitality sector. The Institute is contributing to the creation of knowledge and offer quality program to equip students with skills to face the global market concerted effort by dedicated faculties, providing best learning environment in fulfilling the ambition to become a Leading Institute in India.

    cha jaipur
    management college in jaipur
    management of hospitality administration jaipur
    cha management jaipur
    Best hotel college in jaipur
    Best management college in jaipur
    College of Hospitality Administration, Jaipur

    ReplyDelete

  10. A Pioneer Institute owned by industry professionals to impart vibrant, innovative and global education in the field of Hospitality to bridge the gap of 40 lakh job vacancies in the Hospitality sector. The Institute is contributing to the creation of knowledge and offer quality program to equip students with skills to face the global market concerted effort by dedicated faculties, providing best learning environment in fulfilling the ambition to become a Leading Institute in India.

    cha jaipur
    management college in jaipur
    management of hospitality administration jaipur
    cha management jaipurs
    Hotel management in jaipur
    Best hotel college in jaipur
    Best management college in jaipur
    College of Hospitality Administration, Jaipur
    Top 10 hotel management in jaipur
    Hotel managementin Rajasthan





    ReplyDelete
  11. Hello,
    Your article guide me little bit and my problem has been solved.
    Honestly speaking, I did not read your whole post but i get enough information for me to solve the problem.
    Thanks
    --
    Mohammad Shahnawaz

    ReplyDelete
  12. My rather long internet look up has at the end of the day been compensated with pleasant insight to talk about with my family and friends.

    Best Java Training Institute Chennai

    ReplyDelete
  13. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.Thanks for sharing your information.
    selenium training in chennai

    ReplyDelete
  14. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.
    Best Java Training Institute Chennai
    Java Training Institute Bangalore

    ReplyDelete
  15. I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation. Digital Marketing Training in Bangalore | Best Digital Marketing Training

    ReplyDelete
  16. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

    ReplyDelete
  17. I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.
    Best selenium training Institute in chennai

    ReplyDelete
  18. It’s always so sweet and also full of a lot of fun for me personally and my office colleagues to search your blog a minimum of thrice in a week to see the new guidance you have got.

    Hadoop Training in Chennai

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. Whatever We Are Gathering the information from the blogs,we have to keep on updating it,Urgent Care in Chicago.By getting them into one place.Really thanks for posting.Very Thankful for the Informative Post.Thanks for Posting.

    ReplyDelete


  21. vidyasthali is one of the best law college in India
    Vidyasthali Law College is a self-financing Institution affiliated to the University of Rajasthan

    Best law college in Jaipur

    ReplyDelete


  22. vidyasthali is one of the best law college in India
    Vidyasthali Law College is a self-financing Institution affiliated to the University of Rajasthan

    Vidyasthali Law College

    ReplyDelete
  23. Vidyasthali is one of the best law college in India.
    Vidyasthali Law College is a self-financing Institution affiliated to the University of Rajasthan

    Jaipur Law College



    ReplyDelete
  24. Greetings. I know this is somewhat off-topic, but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform like yours, and I’m having difficulty finding one? Thanks a lot.
    Hadoop Training in Bangalore
    Hadoop Training in Chennai
    Big data training in tambaram
    Big data training in tambaram

    ReplyDelete
  25. Hello. This post couldn’t be written any better! Reading this post reminds me of my previous roommate. He always kept chatting about this. I will forward this page to him. Fairly certain he will have a good read. Thank you for sharing.
    MEAN stack training in Chennai
    MEAN stack training in bangalore

    ReplyDelete
  26. This is beyond doubt a blog significant to follow. You’ve dig up a great deal to say about this topic, and so much awareness. I believe that you recognize how to construct people pay attention to what you have to pronounce, particularly with a concern that’s so vital. I am pleased to suggest this blog.
    java training in omr

    java training in annanagar | java training in chennai

    java training in marathahalli | java training in btm layout

    java training in rajaji nagar | java training in jayanagar

    ReplyDelete
  27. I would really like to read some personal experiences like the way, you've explained through the above article. I'm glad for your achievements and would probably like to see much more in the near future. Thanks for share.
    python training in rajajinagar
    Python training in btm
    Python training in usa

    ReplyDelete
  28. Hello I am so delighted I found your blog, I really found you by mistake, while I was looking on Yahoo for something else, anyways I am here now and would just like to say thanks for a tremendous post. Please do keep up the great work.
    Python training in marathahalli
    Python training in pune
    AWS Training in chennai

    ReplyDelete
  29. Thanks for your informative article, Your post helped me to understand the future and career prospects & Keep on updating your blog with such awesome article.
    DevOps online Training

    ReplyDelete
  30. I really like the dear information you offer in your articles. I’m able to bookmark your site and show the kids check out up here generally. Im fairly positive theyre likely to be informed a great deal of new stuff here than anyone

    angularjs Training in chennai
    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    angularjs-Training in velachery

    ReplyDelete
  31. At this time, it seems like Word Press is the preferred blogging platform available right now. (from what I’ve read) Is that what you’re using on your blog? Great post, however, I was wondering if you could write a little more on this subject?
    Best AWS Training in Marathahalli | AWS Training in Marathahalli
    Amazon Web Services Training in Anna Nagar, Chennai |Best AWS Training in Anna Nagar, Chennai

    ReplyDelete
  32. I have never read more interesting articles than yours before. You make me so easy to understand and I will continue to share this site. Thank you very much and more power!
    Best Selenium Training Institute in Chennai
    Selenium training in Chennai
    JAVA Training
    ios training institute in chennai
    ios developer training in chennai

    ReplyDelete
  33. Nice post. I learned some new information. Thanks for sharing.

    Article submission sites

    Technology

    ReplyDelete
  34. Nice post! It really resolved my problem

    ReplyDelete
  35. Grateful to you, for sharing those superb expressive confirmations. I'll try to do around a spurring power in reacting; there's a striking course of action that you've crushed in articulating the important goals, as you charmingly put it. Keep Sharing
    Dba Training in Bangalore

    ReplyDelete
  36. Thank you for posting informative insights, I think we have got some more information to share with! Do check out oracle dba training in chennai and let us know your thoughts. Let’s have great learning!

    ReplyDelete
  37. Infycle Technologies, the No.1 software training institute in Chennai offers the leading Python course in Chennai for tech professionals and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

    ReplyDelete
  38. Very Informative blog thank you for sharing. Keep sharing.

    Best software training institute in Chennai. Make your career development the best by learning software courses.

    android training in chennai
    devops training in chennai
    best devops training in chennai

    ReplyDelete