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 9.2.0.6). 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.
Gerald on IT 