Re: SQLPLUS issue
- From: Fred Bbaale <bbaale@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 24 Jun 2009 15:55:51 +0300
export your ORACLE_SID
On Wed, Jun 24, 2009 at 3:49 PM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx>wrote:
> 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.
>
>
--
Fred Bbaale
eLAAB Limited
+256772499474
bbaale@xxxxxxxxxxxxxxxxx
http://www.elaab-systems.com
http://solutions.oracle.com/partners/elaab
Other related posts:
