Home » SQL & PL/SQL » Client Tools » Can connect to SqlPlus but not through Toad (Toad 8.5 & Oracle 8.1.7)
Can connect to SqlPlus but not through Toad [message #379828] Thu, 08 January 2009 01:20 Go to next message
virmahi
Messages: 266
Registered: April 2008
Location: India
Senior Member
Hi,
I have installed Oracle client on my computer and I am able to connect to a database through sqlplus but not through Toad.
I am getting the error:-

error while trying to retrieve text for error ORA-12154


The tnsnames.ora has following entries :-
BILL.KECRPG.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.5)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = BILL)
    )
  )


Kindly help me on this.... I have tried to search for answer but couldn't get the problem solved.

Thanks for looking into this,
Mahi
Re: Can connect to SqlPlus but not through Toad [message #379829 is a reply to message #379828] Thu, 08 January 2009 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve the connect identifier specified
 *Cause:  A connection to a database or other service was requested using
 a connect identifier, and the connect identifier specified could not
 be resolved into a connect descriptor using one of the naming methods
 configured. For example, if the type of connect identifier used was a
 net service name then the net service name could not be found in a
 naming method repository, or the repository could not be
 located or reached.
 *Action:
   - If you are using local naming (TNSNAMES.ORA file):
      - Make sure that "TNSNAMES" is listed as one of the values of the
        NAMES.DIRECTORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA)
      - Verify that a TNSNAMES.ORA file exists and is in the proper
        directory and is accessible.
      - Check that the net service name used as the connect identifier
        exists in the TNSNAMES.ORA file.
      - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA
        file.  Look for unmatched parentheses or stray characters. Errors
        in a TNSNAMES.ORA file may make it unusable.
   - If you are using directory naming:
      - Verify that "LDAP" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Verify that the LDAP directory server is up and that it is
        accessible.
      - Verify that the net service name or database name used as the
        connect identifier is configured in the directory.
      - Verify that the default context being used is correct by
        specifying a fully qualified net service name or a full LDAP DN
        as the connect identifier
   - If you are using easy connect naming:
      - Verify that "EZCONNECT" is listed as one of the values of the
        NAMES.DIRETORY_PATH parameter in the Oracle Net profile
        (SQLNET.ORA).
      - Make sure the host, port and service name specified
        are correct.
      - Try enclosing the connect identifier in quote marks.

   See the Oracle Net Services Administrators Guide or the Oracle
   operating system specific guide for more information on naming.

Regards
Michel
Re: Can connect to SqlPlus but not through Toad [message #380394 is a reply to message #379829] Sun, 11 January 2009 17:38 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
I do not believe this is his problem.

The problem is not that an error occured (ORA-12154), Oracle figured this out. The problem is that when the Oracle software tried to lookup the message text that goes along with the error, it could not find the text for it. I think there is some kind of message file that oracle uses and the client software could not find it.

My experience is that this error indicates a bad install. Try re-installing the client and make sure there are no errors during install.

Additionally, 12154 usually results from an application not being able to find the tnsnames file. Create a tns_admin environment variable and point that to the right place. That should fix the 12154 error.

Kevin
Re: Can connect to SqlPlus but not through Toad [message #483816 is a reply to message #379828] Wed, 24 November 2010 12:43 Go to previous messageGo to next message
developer79
Messages: 1
Registered: November 2010
Location: Pakistan
Junior Member

I am facing the same problem. If you are using 64 bit OS like windows 7 then this problem comes with Toad. However, it does not appear when using 32 bit OS with Oracle 10g. I am still struggling for the solution. As for now, I recommend to go for 32 bit OS like windows XP.

Amjad
Re: Can connect to SqlPlus but not through Toad [message #483817 is a reply to message #483816] Wed, 24 November 2010 12:44 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As for now I recommend to NOT use TOAD.

Regards
Michel
Previous Topic: add fucntion to existing package
Next Topic: DBMS_PROFILER not showing any data
Goto Forum:
  


Current Time: Sun Dec 04 04:35:16 CST 2016

Total time taken to generate the page: 0.08345 seconds