Hi Experts,
On one of the servers with Windows Server 2008, we have 5 Oracle 11g databases installed for our dev & testing environments.
With the help of oracle client we are connecting to those server db's.
Last Friday,for one of the db's, I have populated a million records to few tables and everything was fine on that day.
Suddenly on this Monday, one of the front-end users complained that the db was not working. We are not able to connect to that db, but able to connect to one of the other db's on the same server.
Message thrown was :
" ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor "
I connected to server and tried to login from there..the same message was thrown, but able to connect to other db's.
Finally I set the oracle_home path to the db to which i was not able to login and connected using
something like....
conn /as sysdba
idle instance
startup;
database mounted
database started
After that i was able to connect to that db as well as all other db's on the server.
My doubt is, why suddenly that stopped working and it didn't work until i use "startup" command ?
Also, how DBA's maintain server's with multiple oracle_home's?(though recommended to have multiple schema's instead of multiple db's)
I'm the only Oracle guy in the team and need to take care of everything(basically i'm developer and new to DBA related tasks)
My lead's warned me to make sure that it won't happen again !!
Thanks guys.. you are always awesome in giving nice suggestions.