Oracle ORA-27121 troubleshooting

Oracle ORA-27121 troubleshooting

ORA-27121: unable to determine size of shared memory segment
Cause: shmctl () call failed
Action: check permissions on segment, contact Oracle support

Cause:

The oracle database is migrated through the cold copy (off the database) method. After the migration to the target server, if the owner of the oracle file is not changed from root to oracle, execute the startup command, and then report the ORA-27121, view the oracle process, the process is running, but the owner is the root user.

According to the alarm information and the environment in which an error is reported, It is inferred that the first time the instance is started as an oracle user and the file is the primary root user. As a result, when the oracle instance is started for memory allocation, this error is caused by unallocation.

Solution:

Kill started processes, restart the system, and start oracle instances properly.

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian