Home » RDBMS Server » Server Utilities » SQL Loader
SQL Loader [message #263215] Wed, 29 August 2007 07:20 Go to next message
Messages: 6
Registered: November 2006
Location: Kochi
Junior Member

I tried to use oracle utility named SQL * LOADER in windows.While connection it shows following error

>sqlldr qs_m/merchemltd@dump control=ctrl.ctl

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve service name

TNSNAME dump is valid and possible to make connection.

Plz give me suitable solution
Re: SQL Loader [message #263217 is a reply to message #263215] Wed, 29 August 2007 07:27 Go to previous message
Michel Cadot
Messages: 63907
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve service name
 *Cause:  The service name specified is not defined correctly in the
 *Action:  Make the following checks and correct the error:
           - Verify that a TNSNAMES.ORA file exists and is in the proper
             place and accessible. See the operating system specific manual
             for details on the required name and location.
           - Check to see that the service name exists in one of the
             TNSNAMES.ORA files and add it if necessary.
           - Make sure there are no syntax errors anywhere in the file.
             Particularly look for unmatched parentheses or stray characters.
             Any error in a TNSNAMES.ORA file makes it unusable. See
             Chapter 4 in the SQL*Net V2 Administrator's Guide. If
               possible, regenerate the configuration files using the Oracle
               Network Manager.

Previous Topic: data masker
Next Topic: DB Export problem
Goto Forum:

Current Time: Thu Oct 20 15:08:17 CDT 2016

Total time taken to generate the page: 0.08890 seconds