OraFAQ Forum: Server Utilities » Strange issue in SQL Loader

Home » RDBMS Server » Server Utilities » Strange issue in SQL Loader (SQL*Loader: Release 11.2.0.1.0 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Strange issue in SQL Loader [message #638415]

Thu, 11 June 2015 05:53

vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai

Member

Dear All,
I am facing below issue while using SQL loader.

SQL*Loader: Release 11.2.0.1.0 - Production on Tue May 12 15:19:50 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

But when I run the sql loader through administrator, it is working properly.

Like, if open command prompt and run, then above error is coming. But if I right click on cmd prompt, and then click on run as administrator, and then run the sql loader, it works perfectly.

Kindly help. Is sql loader, depends upload user access rights??

SQL*Loader: Release 11.2.0.1.0

Vikas

Report message to a moderator

Re: Strange issue in SQL Loader [message #638420 is a reply to message #638415]

Thu, 11 June 2015 06:57

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What Operating System?

Report message to a moderator

Re: Strange issue in SQL Loader [message #638421 is a reply to message #638420]

Thu, 11 June 2015 07:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

gazzag wrote on Thu, 11 June 2015 04:57

What Operating System?

>But when I run the sql loader through administrator, it is working properly.
Windoze

Report message to a moderator

Re: Strange issue in SQL Loader [message #638425 is a reply to message #638415]

Thu, 11 June 2015 08:04

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the executed command is?
Do you think it does not matter what you execute?

ALWAYS copy and paste what you do and get.
And do it inside the post (no images) and formatted as explain in How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: Strange issue in SQL Loader [message #638532 is a reply to message #638415]

Sun, 14 June 2015 00:30

vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai

Member

Hi,

Operating system is windows 2003 server

Attached screen shot for sql loader command prompt run. Run by myself as a user, and then run command prompt run as administrator.
see the difference. I have not change any other value


SQLLDR FO_LEA/FO_LEA@FOUATD1 control=c:\test\vikas.ctl log=c:\test\vikas_log.log direct=true

/forum/fa/12726/0/

[mod-edit: image inserted into message body by bb]

Attachment: sql_loader_error.jpg
(Size: 102.93KB, Downloaded 4401 times)

[Updated on: Sun, 14 June 2015 02:40] by Moderator

Report message to a moderator

Re: Strange issue in SQL Loader [message #638533 is a reply to message #638532]

Sun, 14 June 2015 00:40

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You don't need screenshots to post text.
Please post text in text and post it formatted as explained in the link I provided above.

Report message to a moderator

Re: Strange issue in SQL Loader [message #638534 is a reply to message #638415]

Sun, 14 June 2015 02:32

vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai

Member


c:\Windows\System32>SQLLDR FO_LEA/FO_LEA@FOUATD1 control=c:\test\vikas.ctl log=c
:\test\vikas_log.log direct=true

SQL*Loader: Release 10.2.0.1.0 - Production on Sun Jun 14 09:27:30 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]

c:\Windows\System32>

Now run command prompt as administrator


Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Windows\system32>SQLLDR FO_LEA/FO_LEA@FOUATD1 control=c:\test\vikas.ctl log=c
:\test\vikas_log.log direct=true

SQL*Loader: Release 10.2.0.1.0 - Production on Sun Jun 14 09:29:46 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Load completed - logical record count 95.

C:\Windows\system32>

I hope this is ok now. I am not able to understand, same command working correctly when run as admin, but not working otherwise

Report message to a moderator

Re: Strange issue in SQL Loader [message #638535 is a reply to message #638534]

Sun, 14 June 2015 02:44

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

There seems to be a difference in drive letters between your screenshot and typed version for the failed command. One says N: and the other says c:. Which is correct?

Report message to a moderator

Re: Strange issue in SQL Loader [message #638536 is a reply to message #638534]

Sun, 14 June 2015 02:46

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

UL-00704: Internal error: %s [%d]\n
 *Cause: An internal error has occurred.
 *Action: Make a note of the message and the number, then contact customer
          support.

It seems OCIEnvCreate is unable to create the environment most likely a lack of privileges of your current user.

Check alett.log and if you have any trace file.
Check Windows application event log.

Report message to a moderator

Re: Strange issue in SQL Loader [message #638537 is a reply to message #638536]

Sun, 14 June 2015 03:52

vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai

Member

Thanks Michel. But can you tell me, what access rights(privileges ) need to give.

Report message to a moderator

Re: Strange issue in SQL Loader [message #638538 is a reply to message #638537]

Sun, 14 June 2015 04:52

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Trace file or event log will tell you, so search them.

Report message to a moderator

Re: Strange issue in SQL Loader [message #638540 is a reply to message #638538]

Sun, 14 June 2015 07:31

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What happens if you do the following: using Windows Explorer, save contents of C:\temp directory into the safe location (so that it won't be lost). Then delete c:\temp directory.

Open CMD window (not as an administrator!) and do the following:

N:\>c:

C:\>mkdir temp

Now, in Windows Explorer, restore TEMP's contents and

C:\>cd temp

C:\temp>sqlldr fo_lea/fo_lea@fouatd1 control=vikas.ctl log=vikas.log

Any improvement?

Report message to a moderator

Re: Strange issue in SQL Loader [message #638560 is a reply to message #638540]

Mon, 15 June 2015 06:45

vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai

Member

Hi littlefoot, I did exactly the same which you suggest but results are same as earlier.

Report message to a moderator

Re: Strange issue in SQL Loader [message #638561 is a reply to message #638560]

Mon, 15 June 2015 06:51

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Again, it would be useful if you showed us what you did rather than what you think you did.

Report message to a moderator

Re: Strange issue in SQL Loader [message #638562 is a reply to message #638561]

Mon, 15 June 2015 07:17

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And once again did you try to search in trace files and event log?
It is just a waste of time to try to find in the dark a way to make it work when it'd be so easy with the traces.

Report message to a moderator

Previous Topic:	Extract date from a column in SQL Loader
Next Topic:	Deploying parts of the DB including users

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 00:42:28 CST 2025