ORA-12514 after rebooting server on 10g
ngacJul 17 2009 — edited Jul 17 2009Hi we have a 10g database and 10g application server installed on windows server.
When we restart the server the application server comes back fine but the database does not come back. if we try to connect via sql we get ORA-12514. We have read a lot of information relating to TNS problems which is not the case here as
a) it works fine before the reboot
b) if we go into Database Administration Assistant and select the configure instance and select our instance this fixes the problem.
Im assuming this is a service that is not starting properly or something but could do with some help trying to find a solution.
Other unusual things we found are that after a reboot and when we recieve the ORA 12514:
1, We can TNS PING it and it comes through fine
2, lsnrctl status the database and it is not displayed in the list but after going into the Database Administration Assistant and select the configure instance and select our instance then we get the database in here fine.
Like i say if we start the DB Admin assistant for our instance it fixes our problem.
Any help is much appreciated