Pages

Monday 12 March 2012

How to check ORA Error on DB Server

To check ORA errors on database server itself, go to shell prompt and type as below.

oerr ora error_number

Eg:
$ oerr ora 00845
00845, 00000, "MEMORY_TARGET not supported on this system"
// *Cause: The MEMORY_TARGET parameter was not supported on this operating system or /dev/shm was not sized correctly on Linux.
// *Action: Refer to documentation for a list of supported operating systems. Or, size /dev/shm to be at least the SGA_MAX_SIZE on each Oracle instance running on the system.

No comments:

Post a Comment