ORA-12154 TNS could not resolve service name
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-12154 TNS could not resolve service name

  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Lightbulb ORA-12154 TNS could not resolve service name

    Hai all,


    I have developed an application in VB and have connected to Personal Oracle 8i through ODBC. I have given the DSN name and User Name in the ODBC connection and left the Server name blank sice it is the local server. The VB applicaton and the personal oracle are in the same PC. When my client tried to open the application, he gets the error

    ORA-12154 TNS could not resolve service name. Microsoft SetConnectAttribute Failed.

    But, my client is able to start up Oracle from the start menu and also login to sqlplus by giving the user name and password.

    I am giving the configuration of tnsnames.ora, listener.ora and sqlnet.ora below. They seem to be correct.

    *************************
    tnsnames.ORA file configuration
    **************************

    # TNSNAMES.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\tnsnames.ora
    # Generated by Oracle configuration tools.


    ORACLE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = workstation8)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = Oracle)
    )
    )


    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )
    )

    ************
    LISTENER.ORA
    *************

    # LISTENER.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = workstation8)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = workstation8)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = d:\Oracle\Ora81)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = Oracle)
    (ORACLE_HOME = d:\Oracle\Ora81)
    (SID_NAME = Oracle)
    )
    )

    **********
    SQLNET.ORA
    ***********

    # SQLNET.ORA Network Configuration File: d:\Oracle\Ora81\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


    Even I had asked my client to start the listener also.

    But still, the same error is prevailing.

    Urgent help required.

    Thanks in advance.
    Angu

  2. #2
    Join Date
    May 2002
    Posts
    2,645

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