Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    India
    Posts
    9

    Thumbs up Unanswered: ORA-12154 error-Urgent Help required

    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
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    If it is a client server application, the client would need TNS entries for the database you are connecting to. And when connecting from cleint to server, you cannot leave the server name blank.
    Oracle can do wonders !

  3. #3
    Join Date
    Oct 2003
    Location
    India
    Posts
    9

    ORA-12154 Error

    But the same ODBC settings work well in all the other client locations. What could be wrong?

  4. #4
    Join Date
    Dec 2003
    Location
    Noida, India.
    Posts
    171
    It defi has to do with settings in client machine.
    Try replacing tnsnames.ora & sqlnet.ora files from client it works to client it does not work. Also compare the ODBC setting in these 2 client machine and bring them in sync.
    Oracle can do wonders !

Posting Permissions

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