• Post Reply Bookmark Topic Watch Topic
  • New Topic

ORA-12154

 
Lara Martin
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Friends,
I have a J2EE application which consists of Servlets,JSP's and Java classes.
I use classes12.zip as typeII driver and WebLogic6.1 with Sun Solaris 8.
The application contacts the tnsnames.ora file and gets access to database(Oracle 8.1.6)
My Problem ----------
When I start the server, It works fine for 70-100 hrs properly. Suddenly, I get ORA-12154 error and my users can't login into the application.When I restart the server,this problem will not come for another 70-100 hrs. Why it happens?Anyone can please advice me? Thanks Lawrence
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle says:
(TNS-12154 = ORA-12154)
TNS-12154 TNS:could not resolve service name
Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the SQL*Net V2 Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager. (reference page)

don't know why it works for 70 -100 hours though?
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!