Oracle Database Discussions

I have installed Oracle 10g database and AS 10g on SUSE linux EE 10 (SP2)

When I try to log in as system/system using sqlplus locally on the server, it works fine. However, when I try the following I get error messages:


SQL> conn system/system@botsdb

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory


I tried the same from my laptop through sqlplus and the error message is the same.

I checked if the database was up and to check this I executed follwing commands whicle still being logged as system/system:


SQL>Select * from v$database;

SQL>Select * from v$instance;

SQL>Select * from tab;

These do bring results. Also if I try to start up the database again, it gives error message that the database is already up. I have restarted the db number of times, checked if my listener was listening on the service BOTSDB and these all seem fine.

It is very intriguing that when @BOTSDB is attached while connecting, the connection fails.

Can someone please guide me to sort this error?

Thanks and kind regards,
Aparna