Home » RDBMS Server » Server Administration » how to solve shared memory realm problem (merged)
how to solve shared memory realm problem (merged) [message #277934] Thu, 01 November 2007 04:59 Go to next message
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
Re: how to solve shared memory realm problem [message #277940 is a reply to message #277934] Thu, 01 November 2007 05:09 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Copy and paste the error message of the screen.
Re: how to solve shared memory realm problem [message #277946 is a reply to message #277940] Thu, 01 November 2007 05:19 Go to previous messageGo to next message
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...
Re: how to solve shared memory realm problem [message #277953 is a reply to message #277934] Thu, 01 November 2007 05:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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.
Re: how to solve shared memory realm problem [message #278026 is a reply to message #277946] Thu, 01 November 2007 09:13 Go to previous message
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
Previous Topic: How do I read the collection statistic generated by DBMS_STATS?
Next Topic: Indexes doubt
Goto Forum:
  


Current Time: Sat Dec 10 08:53:09 CST 2016

Total time taken to generate the page: 0.21438 seconds