DB nonresponsive with ORA-12514 after weeks of running fine
544528May 29 2008 — edited May 29 2008I have seen many prior users complain about getting ORA-12514 after a reboot after installation, and looking at the suggestions, I couldn't find anything addressed a situation where the whole system works for a long period of time and then stops working.
I have a working APEX installation that I can access over the web from remote clients
I have a working JDBC connection that I can use from several remote clients.
After several weeks/months of happily running, I no longer can access the apex website, and I can no longer access the db through the JDBC connection getting:
ORA-12514, TNS:listener does not currently know of service requested in connect
descriptor
The Connection descriptor used by the client was:
//###.###.###.###:1521/XE
Going to look at Windows services, both OracleServiceXE and OracleXETNSListener are still running. To try and recover, I do the following:
* Stop the db and start the db. (Which simply stops OracleServiceXE, and then starts both it and the listener)
Doesn't fix it
* Thinking that the listener might be the problem, I then stop the db, and also manually stop the listener. I then start both of the services
Doesn't fix it
* I reboot the computer
Fixes it.
What is different about rebooting the computer that could possibly fix this? Also, someone had suggested in another thread to look at the listener log in db_1/network/admin/listener.log. I don't know what db_1 is, but I have a oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN directory that does not have this log. If anyone has any insight into what this is, or what log I should look at to identify it, I would be greatly appreciative.
Thanks,
Dan