ORA-12514

Last post 05-28-2007 6:57 AM by kdyande. 3 replies.

Sort Posts:

  • ORA-12514

    12-27-2006, 6:58 AM

    I am using Oracle.DataAccess.dll and having this type of Connection string

    "User ID=ENET;Password=;Host=xxx.xxx.xxx.xxx:1522;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;"

    But it is giving me error as follows ORA-12514:TNS:listener does not currently know of service requested in connected description

    I have figure out it is asking about service name My service name is EXTST  But I am not getting that how to put service name parameter in this string. Can some body help me.

  • Re: ORA-12514

    12-27-2006, 9:19 AM
    • Loading...
    • Dejan Vesic
    • Joined on 12-04-2006, 10:08 PM
    • Belgrade, Serbia
    • Posts 461

    If you can do:

    TNSPING EXTST

    (from command prompt)

    than connection string should be:

    "User ID=xxxx;Password=yyyy;Data Source=EXTST;Pooling=true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;"

    Regards,
    Dejan Vesić

    MCAD for .Net technologies | http://www.vesic.org/english/ | Blog: http://www.vesic.org/english/blog/
  • Re: ORA-12514

    01-12-2007, 2:29 PM
    • Loading...
    • dweezil
    • Joined on 11-06-2002, 3:04 PM
    • Posts 373
    It would be helpful to include your tnsnames.ora entry.
    --dweezil

    SELECT * FROM users WHERE clue = 'yes';

    Records found: 0
  • Re: ORA-12514

    05-28-2007, 6:57 AM
    • Loading...
    • kdyande
    • Joined on 01-30-2007, 11:59 PM
    • Posts 13

    check for this file

    C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora

     

    here u c

    # tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\client_2\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.

    POWER =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.202)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = power)
        )
      )

     use POWER (in my scenario) for Data Source = POWER

     

    u will use what u have in ur  file 

     

    Sorry for my English 

     

     

    Filed under: ,
Page 1 of 1 (4 items)
Microsoft Communities
Page view counter