I have a java webapp with an Oracle 11.2 db that was working fine for several months. Out of the blue, it stoped working.
I went into my webserver's log (tomcat 5) and saw that it was having trouble connecting to the DB with an error # 12505.
That error is: ORA-12505, TNS:listener does not currently know of SID given in connect
I tried to tnsping my SID and it worked:
I tried to lsnrctl services and it said, "The listener supports no services". That can't be correct, right?
My tsnames.ora file is as follows:
(ADDRESS = (PROTOCOL = TCP)(HOST = domU-12-31-38-00-E1-E2)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = LMORACLE)
Please keep in mind that this app was working fine for about 3 months and it all of a sudden stopped working. No one logged in and changed anything (I checked the system logs).
Any ideas? I tried googling the heck out of this issue.