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

Thread: D2k and oracle 9i

  1. #1
    Join Date
    Nov 2004
    Location
    bangalore
    Posts
    3

    D2k and oracle 9i

    I have windows xp sp-1a, firstly i have installed developer 2000 in C:\orant and Oracle9i server in C:\oracle folders, i am unable to connect to the oracle9i database through developer 2000 form builder it gives a TNS error.

    prem.

  2. #2
    Join Date
    May 2001
    Posts
    736
    Since u have installed them in seperate directory there will be 2 TNSNAMES.ORA files in their network folder.So make appropriate changes in the c:\orant\network\tnsnames.ora file.

  3. #3
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    c:\orant\network\tnsnames.ora file.
    Ahem..... that would be
    c:\orant\network\admin\tnsnames.ora file.
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  4. #4
    Join Date
    Nov 2004
    Location
    bangalore
    Posts
    3
    Even after doing it is giving the same problem. I replaced the C:\orant\network\admin\tnsnames.ora with the oracle's tnsnames.ora, even then i am getting the same problem.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by themaskofzorro
    Even after doing it is giving the same problem. I replaced the C:\orant\network\admin\tnsnames.ora with the oracle's tnsnames.ora, even then i am getting the same problem.
    contents of tnsnames.ora and exact error please

  6. #6
    Join Date
    Nov 2004
    Location
    Mexicali.Mexico
    Posts
    13
    Also post the file SQLNET.ORA that resides in the same folder (.../network/admin)

  7. #7
    Join Date
    Nov 2004
    Location
    bangalore
    Posts
    3
    I am getting ORA-12705:INVALID OR UNKNOWN NLS PARAMETER VALUE SPECIFIED Error when i try to connect from d2k to oracle 9i server

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Originally posted by themaskofzorro
    I am getting ORA-12705:INVALID OR UNKNOWN NLS PARAMETER VALUE SPECIFIED Error when i try to connect from d2k to oracle 9i server
    SQL> !oerr ora 12705
    12705, 00000, "invalid or unknown NLS parameter value specified"
    // *Cause: The NLS parameter value specified in an alter session statement
    // is not valid or not implemented.
    // *Action:

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