Message 26 not found
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Message 26 not found

  1. #1
    Join Date
    Dec 2006
    Posts
    11

    Message 26 not found

    Currently using Oracle 8.1.7.

    I am trying to access some data in a table and I connect to the database fine but when I try to do a select statement, I receive the following message:

    Message 26 not found; no message folder for product = SVRMGR; facility = MGR

    What is missing?

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Are you sure you have set the proper oracle_home, oracle_sid?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Dec 2006
    Posts
    11
    No...unfortunately I am going at this blindly because we are accessing a server/database that is not local and outsourced by another company. I am using SQL Plus to get what I need.

    Thank you.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    OK...
    are you positive the target database is up-and-running and, in good shape?
    what's the ORA error you are getting after your "Message 26..." one?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Dec 2006
    Posts
    11
    I can access the data fine using SQL Plus so I will assume it is up and running. I am not getting an ORA message in SQL Worksheet just the Message 26... The message appears below the list of column names.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Does it means you are able to connect/query with no problems using SQL Plus?... same table, same everything?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Dec 2006
    Posts
    11
    That is correct.

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    I'm assuming you are running both SQLPlus and SQLPlus Worksheet on the same client machine, am I right?

    If that is the case, how many ORACLE_HOMEs do you have in that machine? do you have just one client or do you have multiple Oracle clients each one with its own ORACLE_HOME therefore, multiple TNSNAMES.ORA files?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Dec 2006
    Posts
    11
    To be honest, I don't know. I did a search on ORA_HOMES and it found a lot of areas as well as finding a bunch of tsnames.ora in many places. I just started looking at this database yesterday.

    I am just going to go back to the source and see if they can just provide us with the information so we are not fishing for information.

    You don't have to pursue this anymore, but I really do appreciate your help.

Posting Permissions

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



Click Here to Expand Forum to Full Width