OraFAQ Forum: Server Administration » how to solve shared memory realm problem (merged)

Home » RDBMS Server » Server Administration » how to solve shared memory realm problem (merged)

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

how to solve shared memory realm problem (merged) [message #277934]

Thu, 01 November 2007 04:59

nick-oracle
Messages: 6
Registered: November 2007

Junior Member

hi friends,
i have installed and working in oracle9i database. but for the last two days im facing this.. i have checked all services,every one is started..
pls help me to solve this problem..

thanks in advance

Report message to a moderator

Re: how to solve shared memory realm problem [message #277940 is a reply to message #277934]

Thu, 01 November 2007 05:09

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Copy and paste the error message of the screen.

Report message to a moderator

Re: how to solve shared memory realm problem [message #277946 is a reply to message #277940]

Thu, 01 November 2007 05:19

nick-oracle
Messages: 6
Registered: November 2007

Junior Member

now, i tried to login but it shows as TNS protocol adapter error and the sql*plus screen closed automatic ally...

Report message to a moderator

Re: how to solve shared memory realm problem [message #277953 is a reply to message #277934]

Thu, 01 November 2007 05:27

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

Senior Member
Account Moderator

Just have a look at the documentation, we are not a subsitute for it.
And try to post in the correct forum.

Regards
Michel

[Updated on: Thu, 01 November 2007 05:28]

Report message to a moderator

Re: how to solve shared memory realm problem [message #277980 is a reply to message #277934]

Thu, 01 November 2007 06:26

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

What is the actual error you are getting?

I suspect that your database is not started.

Report message to a moderator

Re: how to solve shared memory realm problem [message #278026 is a reply to message #277946]

Thu, 01 November 2007 09:13

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

Senior Member

Post your Oracle Version ?
Post your OS ?
did you check Oracle Services is started ?
go start - > run - > services.msc <<hit enter>> check OracleService<sid> is start /stop
where sid is your database instance name.

did you check Oracle Database is Open MOde ?
select status from v$instance;

Regards
MOhammed Taj

Report message to a moderator

Previous Topic:	How do I read the collection statistic generated by DBMS_STATS?
Next Topic:	Indexes doubt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 04:32:50 CST 2024