Problem In login [message #158021] |
Wed, 08 February 2006 01:33 |
sknanda
Messages: 1 Registered: February 2006
|
Junior Member |
|
|
Hi,
I am facing a problem while login into the db.This has been a stopper for me.
I have two machines say machine1 and machine2.
In machine1 a database is already created say DB1.
Both the machines are installed with Oracle server .
In machine2 I want to login to this DB.
I updated the tnsnames.ora of machine2 for DB1 .
I tryed in machine ,to login sqlplus user/password@DB1
its working.
Now in machine2 i set ORACLE_SID DB1
and tryed to login sqlplus user/password
Its giving the following error message:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
HPUX-ia64 Error: 2: No such file or directory
Please help me.
Thanks in advance.
Santanu
|
|
|
Re: Problem In login [message #158063 is a reply to message #158021] |
Wed, 08 February 2006 06:01 |
orausern
Messages: 826 Registered: December 2005
|
Senior Member |
|
|
If i understand correctly:
1) both m/c1 and m/c2 have oracle software installed.
2) In m/c1 a database called db1 is installed. (and i assume that in machine2 the oracle DATABASE is NOT installed.)
IS THAT RIGHT?
so, from machine2,
1) when you say,
sqlplus user/password@DB1
you are in fact, connecting to the database DB1 on machine 1.
2) when you say, in machine 2:
set ORACLE_SID DB1
sqlplus user/password
it GIVES ERRORS..because it is trying to connect in machine2 to the database called db1 in machine2. But in machine 2 there is no such database , there is only software right?
So that is why you get the error.
So basically , you MUST connect to db1 using the connection string, if you try to connect from machine2.
|
|
|