Home » RDBMS Server » Server Administration » Unable to execute sqlplus command.
Unable to execute sqlplus command. [message #223920] Mon, 12 March 2007 04:56 Go to next message
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.
Re: Unable to execute sqlplus command. [message #223931 is a reply to message #223920] Mon, 12 March 2007 05:11 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that Oracle database isn't up.
Re: Unable to execute sqlplus command. [message #223937 is a reply to message #223931] Mon, 12 March 2007 05:41 Go to previous messageGo to next message
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.
Re: Unable to execute sqlplus command. [message #223940 is a reply to message #223920] Mon, 12 March 2007 05:53 Go to previous messageGo to next message
martijn
Messages: 283
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.
Re: Unable to execute sqlplus command. [message #223951 is a reply to message #223940] Mon, 12 March 2007 06:53 Go to previous messageGo to next message
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.
Re: Unable to execute sqlplus command. [message #224006 is a reply to message #223951] Mon, 12 March 2007 11:04 Go to previous message
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
Previous Topic: Moving data across datafiles
Next Topic: Split Partitioning in Oracle 9i
Goto Forum:
  


Current Time: Sun Dec 04 02:27:41 CST 2016

Total time taken to generate the page: 0.18125 seconds