1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Problem with configuring TOAD for Oracle 10g database.

Discussion in 'Other Development Tools' started by MohammedP, May 17, 2010.

  1. MohammedP

    MohammedP Guest

    Hi all,

    I have installed Oracle 10g database and also a client for 10g, both on the same machine.
    Then I installed Toad for Oracle(version 10.5) . I am using Windows-7.

    When I start toad with the below mentioned details, I get the message " ORA-12154: TNS:could not resolve connect identifier specified(XE)"
    The details which i used are as below:

    User/Schema : system
    Password : ********
    Database : XE

    Connect as : Normal
    Connect using(drop down) : XE

    The other options in "connect using" dropdown was XE, OraClient10g_home1, OraHome92, OraHome92(Oracle Root) and Oracle.
    Of these listing only XE and OraClient10g_home1 are in normal colours.
    But OraHome92, OraHome92(Oracle Root) and Oracle are displayed in red.

    My tnsnames.ora file has the following contents :

    XE =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = Mohammed)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = XE)
    )
    )

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

    ORACLR_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
    )
    (CONNECT_DATA =
    (SID = CLRExtProc)
    (PRESENTATION = RO)
    )
    )

    Can you people please help me in resolving this issue ........................?

    Thanks in advance,
    Mohammed P.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,346
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Installing the database server also installs the client software so why did you install a separate client? My guess is you've configured ONE tnsnames.ora file and not the other (with both a server and client installation on the same server you have two tnsnames.ora files to configure).
     
    MohammedP likes this.