+ Reply to Thread
Results 1 to 8 of 8
  1. 11-28-2004 04:45 AM #1
    themaskofzorro
    themaskofzorro is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 11-28-2004 05:21 AM #2
    akhadar
    akhadar is offline Advisor
    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.
    Reply With Quote Reply With Quote
  3. 11-28-2004 09:21 PM #3
    simply_dba's Avatar
    simply_dba
    simply_dba is offline Senior Member
    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
    Reply With Quote Reply With Quote
  4. 12-02-2004 11:51 AM #4
    themaskofzorro
    themaskofzorro is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  5. 12-02-2004 12:41 PM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    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
    Reply With Quote Reply With Quote
  6. 12-03-2004 02:33 PM #6
    pgamez
    pgamez is offline Junior Member
    Join Date
    Nov 2004
    Location
    Mexicali.Mexico
    Posts
    13
    Also post the file SQLNET.ORA that resides in the same folder (.../network/admin)
    Reply With Quote Reply With Quote
  7. 12-06-2004 05:59 AM #7
    themaskofzorro
    themaskofzorro is offline Junior Member
    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
    Reply With Quote Reply With Quote
  8. 12-06-2004 06:46 AM #8
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    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:
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

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