-
Instance won't start
Hi,
This Morning:
I have a server with 3 instances running(I can access all instances).
This Afternoon:
Tried to create a new instance but get the Oracle not available error.
UNIX admin jacks up max number of processes and users, I can then create new instance.
When doing a shutdown/startup, one of the instances I was able to access in the morning did not start. Tried to start manually but get
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
What other parameters should I be looking at on the UNIX side?
BTW...Connecting as internal and issuing a startup command gives me a
SQL> startup
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel
error.
Can anybody help?
Thanks
-
OOPS..
Forgot to specify...
Oracle 8.1.7 on UNIX 11.0
Thanks
-
And the Shared Memory and Semaphore setting in /etc/system?
Last edited by Calvin_Qiu; 11-28-2002 at 08:15 PM.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
actually u have to see
what is total memory of ur o/s
Since u say that there are 3 instances running - check the sga size.
Keep some memory free for o/s process, working.
also check the shared Memory and semaphore setting in /etc/system
Eat , Drink & Enjoy life -
pravin_kini@hotmail.com
-
Here are some of the parameters:
maxuprc 200
maxusers 251
shmmax 1073741824
shmmni 100
shmseg 10
semmni 70
semmns 200
Any other important information missing?
What do these parameters do?
I am new on UNIX so these are all new to me.
Thanks
-
Check out the installation guide for your platform, it will explain the parameters you require and how to calculate the values.
http://technet.oracle.com/docs/produ...i/content.html
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
I read that..
They really don't say much about setting the semaphores except for saying that the values should be 70 for semmni and 200 for semmns.
Seems that this is still not enough.
Are these numbers per instance? They don't say.
Oracle should specify a "rule of thumb" method for calculating number of semaphores.
-
I think the sum of the existing instances SGA + new instance's SGA and other parameters are exceeding the Operating system allocated resources fro oracle .
try to adjust the either kernel prameters or init.ora parameters of all the instances to fit into the system resource limits .
I guess ur earlier instances might be still working
u can check this by shutting down other instances and starting the enw instance which u have created .
siva prakash
DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|