Strange Oracle errors and their real reasons

Sometime Oracle is a little bit weird when it goes about error messages. Guess what the real reason of this is:

SQL> startup nomount
ORA-00449: background process ‘CKPT’ unexpectedly terminated with error 7446
ORA-07446: sdnfy: bad value ” for parameter .

Damn, checkpoint process doesn’t come up but why? The solution is simple and if you ask me the error message is bad. No not bad, it’s incomplete. The error was that there didn’t exists a bdump and udump directory where the init file pointed to (Oracle And it seems that this is a bad thing for the background process CKPT and pretty sure for all the others too. Not sure what this “sdnfy” means….

A nice other one is this:

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Not sure why this Linux error is printed out, but to be fair, that seems to be a problem with that box I’m currently working on.

Posted in Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.