OraFAQ Forum: Server Administration » Shared memory realm (merged 6)

Home » RDBMS Server » Server Administration » Shared memory realm (merged 6) (oracle 10g , linux es 4.0)

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

Shared memory realm (merged 6) [message #440472]

Mon, 25 January 2010 02:46

sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow

Junior Member

dear all,

I am facing a problem as listed below:

$sqlplus /nolog
SQL>conn /as sydba
connected.
SQL>conn upt/upt

not connected
ora-01034 not available
ora-27101 shared memory realm doesntnot exists
linux error-2 no such file ...

SQL>...

UPT is the user in which our data resides.
wat cud be the problem??????
I tried increasing sizes in INIT.ORA....
listener,tns is OK
.bash_profile of ORACLE user is also correct.

help is appreciated....
thanks in advance...

[Updated on: Mon, 25 January 2010 03:07] by Moderator

Report message to a moderator

Re: Shared memory realm (merged 5) [message #440479 is a reply to message #440472]

Mon, 25 January 2010 02:56

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Startup the database.

Regards
Michel

Report message to a moderator

Re: Shared memory realm (merged 5) [message #440481 is a reply to message #440479]

Mon, 25 January 2010 02:59

sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow

Junior Member

i tried starting up the database...
by logging in as sysbda i gave STARTUP but it
again gives the same 3 errors....

regards,
sudhanshu

Report message to a moderator

Re: Shared memory realm (merged 5) [message #440484 is a reply to message #440481]

Mon, 25 January 2010 03:08

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste what you did.
Before please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: Shared memory realm (merged 5) [message #440488 is a reply to message #440484]

Mon, 25 January 2010 03:26

sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow

Junior Member

$sqlplus /nolog
SQL>conn /as sydba
connected.
SQL>startup
succeded
SQL>conn upt/upt

not connected
ora-01034 not available
ora-27101 shared memory realm doesntnot exists
linux error-2 no such file ...

SQL>...

Report message to a moderator

Re: Shared memory realm (merged 5) [message #440491 is a reply to message #440488]

Mon, 25 January 2010 03:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

SQL>startup
succeded

Oracle NEVER says that.
Do not fake your output and copy and paste what you ACTUALLY get with SQL*PLus.
And FORMAT your post.

Regards
Michel

[Updated on: Mon, 25 January 2010 03:40]

Report message to a moderator

Re: Shared memory realm (merged 5) [message #440513 is a reply to message #440488]

Mon, 25 January 2010 05:40

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

SQL>startup
succeded

Greate Message! Is it from Your Version(Own) of Oracle ? Smile

Do as Michel Suggested.
Else Follow the links..
ora_27101_shared_memory_realm_does_not_exist1

ora_27101

sriram Smile

Report message to a moderator

Previous Topic:	ASM Package issue
Next Topic:	Data Base Configuration assistant not working in oracle 8.1.7 in windows server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 11:32:06 CST 2024