Solved

Cannot start the database - ORA -27121

Posted on 2001-07-19
5
949 Views
Last Modified: 2012-05-04
I encountered the following error when attempting to start the database:

SVRMGR> startup
ORA-27121: unable to determine size of shared memory segment
SVR4 Error: 13: Permission denied


Any help is appreciated.

Thanks.
0
Comment
Question by:jadecloud98
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 2

Expert Comment

by:Kong
ID: 6300520
1) Increase the size of shared memory in your /etc/system file (if on UNIX/LINUX):

set shmsys:shminfo_shmmax=<size in bytes>

Recommended size (debatable) is real memory.

2) Decrease the number of db_block_buffers (initialisation parameter)

3) Decrease your block size (which would mean rebuilding DB).
0
 
LVL 3

Expert Comment

by:UsamaMunir
ID: 6300998
If You are working on Unix based system, try to start the database as root and as an administrator on NT plateform. If that doesn't solve the problem, u will have to contact oracle support.

Regards
UsamaMunir
0
 

Expert Comment

by:sunsapollos
ID: 6301048

  Your os platform?
  Is your frist startup or no?
  If your os is unix,run ipcs command,see below:

  $ ipcs
IPC status from /dev/mem as of Fri Jul 20 13:19:24 CDT 2001
T        ID     KEY        MODE       OWNER    GROUP
Message Queues:
q         0 0x4107001c -Rrw-rw----     root   printq
Shared Memory:
m         0 0x0d05016b --rw-rw-rw-     root   system
m   5242881 0x0018084f --rw-rw----      mqm      mqm
m    917506 0x58059034 --rw-rw-rw-     root   system
m    393219 0x45567834 --rw-r-----   oracle      dba
 
  you can check the mode options.
  check oracle file attribe,It should be 6751
  $ ls -l oracle
-rwsr-s--x   1 oracle   dba      23112746 Jun 07 14:10 oracle

  I suggest you restart os and retry it.



   

0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7038156
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
LVL 1

Accepted Solution

by:
Moondancer earned 0 total points
ID: 7054351
Inconclusive, lacking Asker input, 50 points refunded and closed.
Moondancer - EE Moderator
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question