| Sql Loader problem [message #200259] |
Mon, 30 October 2006 02:16  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
