Re: SQLPLUS issue
- From: James Morrow <morrow.james@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 24 Jun 2009 08:27:03 -0500
Is this a new database?
It's possible that the "root.sh" script wasn't run... You may want to check
the permissions on ${ORACLE_HOME}/bin/oracle to see if it is setuid
(it should be). Also, I'd do a "ps -ef|grep ora_" to see if the processes are
indeed running as the "oracle" user.
-- James
----------------------------------------------------------------------
James J. Morrow | Senior Oracle Applications DBA | TriOra Group, LLC
morrow.james <at> gmail <dot> com
james.morrow <at> trioragroup <dot> com
On Wed, Jun 24, 2009 at 8:07 AM, 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:
