Hi...
my server has ten instances. but often nine are comin up.tenth one is not coming up.what could be the possible causes?
Joe
Printable View
Hi...
my server has ten instances. but often nine are comin up.tenth one is not coming up.what could be the possible causes?
Joe
The version of OS and Oracle? What does the Alert log file show?
your post info cant make anyone help you
Hi...
My server is solaris 8 and oracle server is 8.1.5. From the alert log I found that it is a OS related problem.
May you paste the error message here? And any relevant information?
i had a similar problem, my server has 14 instances
just check the operating system swap space and RAM
try to distribute SGA of all the instances so that it can fit in the O/S RAM .
i.e reduce SGA of one instance and increase SGA of other instance all the instances would start .
sum total of all teh SGA's may be exceeding the operating system swap or RAM area .
hope fully this will fix
alternative , just shut down one or two instances and start the one which is not starting .