Venzi's Tech-Blog

17 April 2008

Strange Oracle errors and their real reasons

Filed under: Oracle,Work — Venzi @ 17:05

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.

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: