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

Sir,
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-12154: TNS:could not resolve service name
 *Cause:  The service name specified is not defined correctly in the
 TNSNAMES.ORA file.
 *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.

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


Current Time: Wed Dec 25 10:11:14 CST 2024