Arvind,
Did you try to run sqlplus from dos prompt? I think you have multiple
tnsnames.ora in your system and your sqlplus (I suppose you are running GUI
front end)is picking different tnsnames.ora than the jdbc driving picking
up. In my experience, if you can run sqlplus from command prompt you will
not get this error.
In order to fix the problem make sure that your tnsnames.ora and
corresponding sqlplus are in one OracleHOME. You can do that by manipulating
your PATH variable. It just works like JAVA_HOME/jre/lib/ext files are
picked up JAVA_HOME/bin/java.exe. Obviously, if you pick up another
JAVA_HOME_OLD/bin/java.exe, you shouldn't expect it to pick
JAVA_HOME/jre/lib/ext lib files.
This may help you.
Regards,
Chandra
Disclaimer: The statements and opinions expressed here are my own and do not
necessarily represent those of Oracle Corporation.
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Dylan
Sent: Tuesday, July 10, 2001 4:05 PM
To: [EMAIL PROTECTED]
Subject: Re: Oracle error
Arvind,
Try DB2 for Linux it works much better.
Dylan
-----Original Message-----
From: A mailing list for discussion about Sun
Microsystem's Java Servlet
API Technology.
[mailto:[EMAIL PROTECTED]]On Behalf Of
Arvind Bir
Sent: Tuesday, July 10, 2001 8:59 AM
To: [EMAIL PROTECTED]
Subject: Oracle error
Hi all,
I have written a servlet which connects to
database for loading some data.
But when ever I try to run this servlet following
error is displayed:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory.
I have checked my tnsnames.ora. Everything is fine
there.
Moreover I am succesfully running sqlplus from my
machine which don't show
any error.
Can anyone tell me what this error is?
Thanks
Arvind Bir
__________________________________________________
_________________________
To unsubscribe, send email to
[EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives:
http://archives.java.sun.com/archives/servlet-inte
rest.html
Resources:
http://java.sun.com/products/servlet/external-reso
urces.html
LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
