Re: SQLPLUS issue
- From: Harish Muramshetty <harish.muramshetty@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 24 Jun 2009 17:30:03 +0400
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:
