Home » RDBMS Server » Server Administration » Shared memory realm (merged 6) (oracle 10g , linux es 4.0)
Shared memory realm (merged 6) [message #440472] Mon, 25 January 2010 02:46 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Startup the database.

Regards
Michel
Re: Shared memory realm (merged 5) [message #440481 is a reply to message #440479] Mon, 25 January 2010 02:59 Go to previous messageGo to next message
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
Re: Shared memory realm (merged 5) [message #440484 is a reply to message #440481] Mon, 25 January 2010 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Shared memory realm (merged 5) [message #440488 is a reply to message #440484] Mon, 25 January 2010 03:26 Go to previous messageGo to next message
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>...
Re: Shared memory realm (merged 5) [message #440491 is a reply to message #440488] Mon, 25 January 2010 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 63817
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
ramoradba
Messages: 2454
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
Previous Topic: ASM Package issue
Next Topic: Data Base Configuration assistant not working in oracle 8.1.7 in windows server
Goto Forum:
  


Current Time: Fri Sep 30 19:17:57 CDT 2016

Total time taken to generate the page: 0.19691 seconds