sp2-0667: message 667 not found

[jlakhani]

my client received this error today.
sp2-0667; message 667 not found; message handle not initialized
message 229 not found; message handle not initialized

when i did an oerr i received the following message:

00667, 0, "Message file %s.msb not found\n"
// *Cause:
// *Action:

Jigar

[sambavan]

What is your OS and oracle version? from where did you try the oerr?

Sam

[jlakhani]

Sam
my OS is HPUX 64bit and this happeneed in SQL*PLUS.

[pando]

look your

$ORACLE_HOME/sqlplus/mesg and see if you have sp1.*.msb and sp2*.msb

[jlakhani]

Pando,
I do all the files you listed. When I did an oerr lookup on sp2-0667 in another box I also received

00667, 0, "Message file %s.msb not found\n"
// *Cause:
// *Action:

Can you pls try it too?

[Shestakov]

Check $ORACLE_HOME variabe in environment in your .profile (or .login or ...)

$ set

...
ORACLE_HOME=/....
...

[jlakhani]

question:
Is it possible that I have to relink the SQLNET Piece? I found out that this environment was copied rather then installed...

Jigar