Home » RDBMS Server » Server Utilities » Sql Loader problem
Sql Loader problem [message #200259] Mon, 30 October 2006 02:16 Go to next message
Deepak_Shingan
Messages: 1
Registered: October 2006
Junior Member
Hi all,

I am trying to load some data into database with the help of sql loader and the error that I am getting is

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

The problem is the service name in tnsOra file is same for multiple database like for multiple host the service name is same in tnsOra file. so the sqlloader execution string

sqlldr user/password@sidName control=cntrl.ctl

is giving me problem.

My tnsnames.ora file is like this
----------------------------------------------------------------
MYHOST_1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.99.98.99)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MYSERVICE)
)
)

MYHOST_2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.99.99.99)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MYSERVICE)
)
)

----------------------------------------------------------------
In short, I have to pass Host -ip address along with sid name for conneting with proper database, but I don't know how to do that.

Please guide.
Thnaks in advance
Deepak
Re: Sql Loader problem [message #200260 is a reply to message #200259] Mon, 30 October 2006 02:25 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Are you sure you got above error


ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
http://www.dbmotive.com/oracle_error_codes.php?errcode=12514

go through above link
Previous Topic: SQL Loader
Next Topic: Sqlldr issue with Oracle 8i
Goto Forum:
  


Current Time: Mon Dec 05 21:11:49 CST 2016

Total time taken to generate the page: 0.09770 seconds