Oracle error "Message xxx not found; No message file for product=plsql, facility=PLW" ...

Hi,

I'm running under windows using Oracle 10g, I have a sneaking suspician that I've been very silly and imported data into the SYS catalog and replaced my messages data with data from a 9i install (hence the missing "warning" information in the error).

The database is not critical (it's used for testing), but it does take about 3 hours to setup and represents about 12 hours solid work in total (4 schemas) so any way of just re-loading the messages (I have other 10g databases I can link to) would be ideal.

Does anyone know what I can do to fix it?

(apart from the obvious delete and re-install)

AndyP
apellewAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

alexnuijtenCommented:
I think it has something to do with the version of SQL*Plus you're using...
Do you use the most recent SQL*Plus?

Alex
apellewAuthor Commented:
Hi, I'm using PL/SQL developer from Allroundautomations.com ... I have no problems with other 10g databases, just this one.

AndyP
alexnuijtenCommented:
Do you have access to MetaLink? Take a look at note: 1016263.102

Quote:"You have multiple ORACLE_HOMEs, one being Oracle8i, installed on
WindowsNT 4.0.   While using Oracle command line utilities and/or applications
you are experiencing errors similar to 'Message XXX not found; No
message for product...'."

Alex
apellewAuthor Commented:
Sorry no, I don't have access to Metalink. I do have multiple homes installed, 9i and 10g. Pl/SQL developer is using the 10g home.

I'm also running XP Pro.

Does the article offer any resolution to the problem?

AndyP
alexnuijtenCommented:

 Enter the System Properties | Environment Tab and remove the ORACLE_HOME
entry from the User Variables section.

Detailed Instructions:

1) Right click My Computer on the Windows Desktop
2) Select Properties
3) Select the Environment Tab
4) Highlight the ORACLE_HOME Variable in the User Variables section
5) Click Delete
6) Select OK to exit the System Properties window.

        The above steps will remove the ORACLE_HOME variable from the
system.  This will allow the Oracle Home Selector to be used to set
the proper ORACLE_HOME.  Oracle Home Selector can be started in one
of the following 2 ways.

Start | Programs | Oracle for Windows NT| Oracle Home Selector for pre-Oracle8i
or
Start | Programs | Oracle Installation Products | Home Selector for Oracle8i



Solution Explanation:
=====================
        When the $ORACLE_HOME and the Path to the desired Oracle executables
match, the program will look for and find the correct message files under the
correct $ORACLE_HOME.
       

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.