OraFAQ Forum: Server Administration » Unable to execute sqlplus command.

Home » RDBMS Server » Server Administration » Unable to execute sqlplus command.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to execute sqlplus command. [message #223920]

Mon, 12 March 2007 04:56

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

I am trying to execute sqlplus <username>/<password>
from unix prompt i am getting the following

SQL*Plus: Release 9.2.0.6.0 - Production on Mon Mar 12 09:54:27 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

Please assist in this.

Os SunOs 5.8

Thanks,
Shahnaz.

Report message to a moderator

Re: Unable to execute sqlplus command. [message #223931 is a reply to message #223920]

Mon, 12 March 2007 05:11

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It seems that Oracle database isn't up.

Report message to a moderator

Re: Unable to execute sqlplus command. [message #223937 is a reply to message #223931]

Mon, 12 March 2007 05:41

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi.

But i can able to connect using toad and command prompt on windows !!

Thanks,
Shahnaz.

Report message to a moderator

Re: Unable to execute sqlplus command. [message #223940 is a reply to message #223920]

Mon, 12 March 2007 05:53

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

Is the environment set on the unix machine ?
(like $ORACLE_HOME $ORACLE_SID)

If not, export these parameters. I probably forgot a lot of the environment parameters, so this don't need to be the only paramaters to set.

Report message to a moderator

Re: Unable to execute sqlplus command. [message #223951 is a reply to message #223940]

Mon, 12 March 2007 06:53

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

thanks a lot it is working now

i have given ORACLE_SID in small case, once i changed to UPPU one it is working.

thanks,
shahnaz.

Report message to a moderator

Re: Unable to execute sqlplus command. [message #224006 is a reply to message #223951]

Mon, 12 March 2007 11:04

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
ORACLE_SID
yes , *nix is case sensitive ( not sure) but we can set lower case in windows platform.
but we should always set upper case in oracle enviourment.

regards
Taj

Report message to a moderator

Previous Topic:	Moving data across datafiles
Next Topic:	Split Partitioning in Oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 04:37:08 CST 2025