Printable View
I was trying to create a recovery catalog database, i created the database, but the database doesnt' starts it says oracle error
ORA-27100: shared memory realm already exists.
OSD-00000: Message 0 not found; product RDBMS; facility=SOSD
Somebody said it is memory problem and need to reduce the database buffer. How do i calculate the database buffer for the database?
Shutdown your database and then open your database. If it's fail then it could be the instance which was not created properly.
Regards,
abhijit
Could be one of two things:
1. Your environment variables are not setup correctly.
2. You probably don't have enough ram to run two instances with the parameters you have specified. db_block_buffers are merely a caching parameter. If you have a low number, your performance will suck. If you have a high number, your performance will be better. There are several texts that discuss "buffer hit ratio" in detail.
You may need to use ipcrm to remove existing
shread memory segments
if you are running Oracle on Unix.