Database is up and running but when I connect as oracle it's idle?
631766May 7 2008 — edited Jun 13 2008Hi experts,
I have a strange kind of problem. I installed Oracle10 on UNIX.
When I connect to the Database remotely I am on a perfect working database but when I am connected directly on the machine via Oracle user, and run SQLPLUS I am connected to an idle instance. Also I can not startup this instance because I of 'ORA-01102: cannot mount database in EXCLUSIVE mode'.
when I run SQLPLUS useing the '@' condition I am connected correctly.
I checked SID settings and so on but it looks fine. I also only have one instance installed (I hope!).
Any ideas?
Thanks
Flo