Home » RDBMS Server » Server Utilities » Strange issue in SQL Loader (SQL*Loader: Release 11.2.0.1.0 )
Strange issue in SQL Loader [message #638415] Thu, 11 June 2015 05:53 Go to next message
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
Re: Strange issue in SQL Loader [message #638420 is a reply to message #638415] Thu, 11 June 2015 06:57 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
What Operating System?
Re: Strange issue in SQL Loader [message #638421 is a reply to message #638420] Thu, 11 June 2015 07:02 Go to previous messageGo to next message
BlackSwan
Messages: 26595
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
Re: Strange issue in SQL Loader [message #638425 is a reply to message #638415] Thu, 11 June 2015 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 66554
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Strange issue in SQL Loader [message #638532 is a reply to message #638415] Sun, 14 June 2015 00:30 Go to previous messageGo to next message
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]

[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 Go to previous messageGo to next message
Michel Cadot
Messages: 66554
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Strange issue in SQL Loader [message #638534 is a reply to message #638415] Sun, 14 June 2015 02:32 Go to previous messageGo to next message
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
Re: Strange issue in SQL Loader [message #638535 is a reply to message #638534] Sun, 14 June 2015 02:44 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8919
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?
Re: Strange issue in SQL Loader [message #638536 is a reply to message #638534] Sun, 14 June 2015 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 66554
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Strange issue in SQL Loader [message #638537 is a reply to message #638536] Sun, 14 June 2015 03:52 Go to previous messageGo to next message
vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai
Member
Thanks Michel. But can you tell me, what access rights(privileges ) need to give.
Re: Strange issue in SQL Loader [message #638538 is a reply to message #638537] Sun, 14 June 2015 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 66554
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Re: Strange issue in SQL Loader [message #638540 is a reply to message #638538] Sun, 14 June 2015 07:31 Go to previous messageGo to next message
Littlefoot
Messages: 21498
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?
Re: Strange issue in SQL Loader [message #638560 is a reply to message #638540] Mon, 15 June 2015 06:45 Go to previous messageGo to next message
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.
Re: Strange issue in SQL Loader [message #638561 is a reply to message #638560] Mon, 15 June 2015 06:51 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
Again, it would be useful if you showed us what you did rather than what you think you did.
Re: Strange issue in SQL Loader [message #638562 is a reply to message #638561] Mon, 15 June 2015 07:17 Go to previous message
Michel Cadot
Messages: 66554
Registered: March 2007
Location: Nanterre, France, http://...
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.

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


Current Time: Thu Sep 19 11:43:18 CDT 2019