Oracle cataglog

[yumi_rama]

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?

[abhijit]

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

[marist89]

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.

[sysdba]

You may need to use ipcrm to remove existing
shread memory segments
if you are running Oracle on Unix.