| Error in using SQLLDR [message #71696] |
Fri, 20 December 2002 08:47  |
Mary Ellen
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
I get the following error when trying to use the loader utility:
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [[0]]
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
The service name is correct. I used userid/password@servicename.
Thanks
|
|
|
|
| Re: Error in using SQLLDR [message #71697 is a reply to message #71696] |
Fri, 20 December 2002 08:51  |
satish
Messages: 112
Registered: September 2000
|
Senior Member |
|
|
Hi,
Try contacting the oracle support, I think there might be some network problems, thats why it is giving internal error.
Regards,
Satish.
|
|
|
|
| Re: Error in using SQLLDR [message #73375 is a reply to message #71696] |
Mon, 05 April 2004 09:03 |
Kausar Nawaz
Messages: 1
Registered: April 2004
|
Junior Member |
|
|
Hi,
I use peoplesoft 8.44 finacials . people tools 8.43. And i get this same error almost every month. There are 3 steps to figure out the problem.
1. check the TNS names file .
2. check if the oracle listener is up
3. are you able to log on to database from your oracle or sql client
4. then check if the application server came up clean. else , stop the application server , kill all the process ( coz sometimes processes hang!) , then start the application server. if it comes back up clean , your probleem is taken care of. Its just about attaching to the processes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
