Results 1 to 12 of 12
  1. #1
    Join Date
    Mar 2005
    Posts
    25

    Unhappy Unanswered: Oracle configuration problems. How do I test if tnsnames.ora is being found?

    tnsnames.ora is located at:
    C:\oracle\Ora_Client\network\ADMIN

    System Variables set to:
    ORACLE_HOME C:\oracle\
    TNS_ADMIN C:\oracle\Ora_Client\network\ADMIN\

    SQLPlus returns the error "Message file SP1<lang>.msb not found"
    SQLNavigator returns the error "Cannot initialize OCI Error -1"

    How do I know where computer is looking for the Oracle settings?

    All help is appreciated.
    Thank you.
    Tiff

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    did you install the oracle software as a different user than you are currently logged in as?
    ie: installed as "Admin" but you are logged in as "Tiffany"
    Could be a permissions problem

    Solution

    1. Manually change the permissions on all directories and files so that non oracle
    user could access the mesg files . That resolves the problem
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Mar 2005
    Posts
    25
    When I right-click and go to security, its says the 'system' has read/execute access. Is that what is needed?

  4. #4
    Join Date
    Mar 2005
    Posts
    25
    I'm also getting the error "agntsrvc.exe encountered a problem and needed to close" on start-up but I'm not sure if these errors are related. Are they?

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    but what are you logged IN as???? (not SYSTEM is my guess)

    you need to add your USERNAME to the "Group or user names" window and
    then grant yourself FULL CONTROL of all folders files and subdirectories
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Mar 2005
    Posts
    25
    I'm logged in as a 'User' and Users have Read & Execute permissions.

  7. #7
    Join Date
    Jul 2003
    Posts
    2,296
    you're logged into the windows server as "user"? what kind of IT department do you have?

    Anyways, you should give full control to all users.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  8. #8
    Join Date
    Feb 2006
    Posts
    15
    Quote Originally Posted by Tiffany

    SQLPlus returns the error "Message file SP1<lang>.msb not found"
    sql*plus is looking for its message files under %ORACLE_HOME%\sqlplus\mesg

    Does this directory exist?
    Does it contain any msb files?

    This error can occur when the ORACLE_HOME is set incorrectly.

    What version of Oracle are you running?
    What do you see in the Registry under:
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE?

    Anything beginning with KEY_ ?
    Anything of the form HOMEn ?

    This is where your ORACLE_HOME should be set.
    It is not an environment variable. (TNS_ADMIN is though).

  9. #9
    Join Date
    Mar 2005
    Posts
    25

    getting better!

    ORACLE_HOME was set to C:\oracle
    I see that C:\oracle\Ora_Client\sqlplus has a mesg folder with msb files in it.

    Therefore, I'm changed the ORACLE_HOME to C:\oracle\Ora_Client
    Now SQL Plus will open and I get TNS_Entry not found error.
    SQL Navigator still says "Cannot initialize OCI Error -1"

    Oracle version is 9i.
    In the registry there are several settings under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. There's no variable names starting with KEY.

  10. #10
    Join Date
    Feb 2006
    Posts
    15
    sql*plus cannot resolve the identifier

    Switch on client tracing:

    Add the following entries to C:\oracle\Ora_Client\network\ADMIN\sqlnet.ora

    TRACE_DIRECTORY_CLIENT=C:\oracle\Ora_Client\networ k\trace
    TRACE_LEVEL_CLIENT=admin

    If the sqlnet.ora doesn't exist then create it.

    The trace files will be created under: C:\oracle\Ora_Client\network\trace

    Try to connect using sqlplus.

    Open the trace file and search for tnsnames.ora
    If there is no mention of tnsnames.ora then the file is not being picked up.
    If there is then the identifier you are using does not have a corresponding entry - add it to the tnsnames.ora file.

    And, again, what version of Oracle are you using?

    Don't forget to remove the entries from your sqlnet.ora file otherwise you will keep generating trace files.

  11. #11
    Join Date
    Mar 2005
    Posts
    25
    I added the entries to sqlnet.ora
    SQL Plus connected successfully with the trace elements included
    Inside the trace file there was no mention of tnsnames.ora
    SQL Navigator still says "Cannot initialize OCI Error -1"

    Oracle 9i 9.2.0.6.0

  12. #12
    Join Date
    Mar 2005
    Posts
    25

    Cool It works!

    I removed the TNS_ADMIN variable & value and everything works again.

    The bad ORACLE_HOME was the cause of all the pain!

    Thanks for all the help!! I'm so relieved it is fixed!

Posting Permissions

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