DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: sp2-0667: message 667 not found

Hybrid View

  1. 02-07-2002, 12:40 PM #1
    jlakhani's Avatar
    jlakhani
    jlakhani is offline Learn by breaking rdbms
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    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
    "High Salaries = Happiness = Project Success."
    Reply With Quote Reply With Quote
  2. 02-07-2002, 01:56 PM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    What is your OS and oracle version? from where did you try the oerr?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  3. 02-07-2002, 05:21 PM #3
    jlakhani's Avatar
    jlakhani
    jlakhani is offline Learn by breaking rdbms
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Sam
    my OS is HPUX 64bit and this happeneed in SQL*PLUS.
    "High Salaries = Happiness = Project Success."
    Reply With Quote Reply With Quote
  4. 02-07-2002, 05:35 PM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look your

    $ORACLE_HOME/sqlplus/mesg and see if you have sp1.*.msb and sp2*.msb
    Reply With Quote Reply With Quote
  5. 02-08-2002, 01:15 PM #5
    jlakhani's Avatar
    jlakhani
    jlakhani is offline Learn by breaking rdbms
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    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?
    "High Salaries = Happiness = Project Success."
    Reply With Quote Reply With Quote
  6. 02-08-2002, 04:17 PM #6
    Shestakov
    Shestakov is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Check $ORACLE_HOME variabe in environment in your .profile (or .login or ...)

    $ set

    ...
    ORACLE_HOME=/....
    ...
    Reply With Quote Reply With Quote
  7. 02-08-2002, 05:20 PM #7
    jlakhani's Avatar
    jlakhani
    jlakhani is offline Learn by breaking rdbms
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    question:
    Is it possible that I have to relink the SQLNET Piece? I found out that this environment was copied rather then installed...

    Jigar
    "High Salaries = Happiness = Project Success."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width