SQLPLUS issue

Hi all,

I am facing a weird issue with sqlplus.


DB connection through sqlnet works fine but when I just enter
 sqlplus username/passwd  it errors out.

Kindly let me know your inputs on this.



When Connected directly:

**********************



[oracle@oraapps2 dbs]$ echo $ORACLE_HOME

/u02/db/tech_st/10.2.0

[oracle@oraapps2 dbs]$ echo $ORACLE_SID

UPGR

[oracle@oraapps2 dbs]$ sqlplus system/manager



SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 24 17:13:36 2009



Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.



ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux Error: 2: No such file or directory





When Connected through listener:

************************************



[oracle@oraapps2 dbs]$ sqlplus system/system@UPGR



SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jun 24 17:14:34 2009



Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.





Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

With the Partitioning, OLAP and Data Mining options



SQL>





Thanks,

Kalyan




______________________________________________________________________
Disclaimer: This communication, along with any documents, files or
attachments, is confidential, intended only for the use of the
recipient(s) named above and may contain information that is legally
privileged, attorney work product or otherwise exempt from disclosure
under applicable law. If you are not the intended recipient(s) or have
received this message in error, you are hereby notified that any
dissemination, distribution or copying of any information contained in
or attached to this communication is strictly prohibited; instructed
to immediately notify the sender by return email or by a phone call to
the sender; and required to delete this message from your computer.
This communication does not form any contractual obligation on behalf
of the sender, the sender's employer or such employer's parent
company, affiliates or subsidiaries.

Other related posts: