Tuesday, July 6, 2010

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]

faced the following error and solution is very very simple
C:\>sqlldr gcon_user control='E:\test_ctl.ctl'
Password:
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jul 7 11:11:45 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error
as the last line show that (ora-12560) its sid is not set. please use for windows at cmd
set ORACLE_SID=YOUR_SID
for linux
ORACLE_SID=YOUR_SID

Cheers.

3 comments:

Anonymous said...

Amiable brief and this mail helped me alot in my college assignement. Thank you as your information.

Ali Howard said...

A useful benchmark for in-game frame rates is the refresh rate of your monitor. Frame rates above 60 FPS won't assist you if your monitor only has a 60Hz refresh rate because it can't update quickly enough to keep up with your GPU's output. In this article you will get information about Fortnite game Settings

Sam Salting said...

Absolutely brilliant! This article proves that brevity and effectiveness can go hand in hand. Well done! Device Checker profile provides an easy and accessible way to test your devices, including mobile phone vibration, mouse response, keyboard functionality, microphone quality, webcam performance, and FPS measurement.