Re: SQLPLUS issue

After creating listener from DBCA ...are you able to do tnsping to other
server or what is the output of lsnrctl status ???




On Wed, Jun 24, 2009 at 5:07 PM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx>wrote:

> 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.
> > >
> > >
> >
> >
>
>

Other related posts: