Harish, Yes , But I just changed the LOCAL_LISTENER paramater since I could not connect with 'connect descriptor' after configuring listener. WIll that affect normal sqlplus connections?? I have one more DB on the same server. I am able to connect successfully with/without any connect descriptor. Note : The former DB was created manually and the later was created using DBCA. I guess I would have missed something.. -Kalyan On 6/24/09, Harish Muramshetty <harish.muramshetty@xxxxxxxxx> wrote: > Any latest changes in SGA or pfile ??? > > > On Wed, Jun 24, 2009 at 4: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. > > > > > >