My boss has had a local instance of Oracle 11g Express installed on her laptop. Every now and then she gets the error message , ORA-12505: TNS:listener does not currently know of SID given in connect descriptor , the only solution is to uninstall Oracle and reinstall it, reimport the database, and then reconnect to it. She seems to think that it had something to do with her not logging out of the database each night. She seems to think that it would happen some time during the night, as if some service is locking the database.
As I've been looking into it I've tried logging into listener and stopping it then starting it, but it says I don't have permission to stop it. I have administrator permissions. Oracle services are all turned on, but listening to our
lsnrctl services show they are all on
lsnrctl status is OK
in the listener.log file:
28-MAY-2015 13:18:52 * service_died * xe * 12547
TNS-12547: TNS:lost contact
When I try to log on via command line:
>sqlplus
Enter user name: system
Enter password:
ERROR:
ORA-12560: TNS Protocol Adapter error
Just to make sure I started the DB service then tried to log on again:
>sqlplus
Enter user name: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
We've recorded more of the steps taken and error messages, but it seems like something is locking the database and is not releasing it. My boss suspects the virus scan may be doing this.
Anymore, any reinstall will work for me, but then when she logs in it locks the database and it can't be unlocked or entered. My logging in afterwards has it locked and I get the error message as well. We get various different error messages, but it all starts with ORA-12505: TNS:listener does not currently know of SID given in connect descriptor. Any thoughts or suggestions? Thanks!