Internal Error Ulconnect Ocienvcreate
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > SQL*Loader-704: Internal Error: ulconnect: OCIEnvCreate [-1] Want to Advertise Here? Solved SQL*Loader-704: Internal Error: ulconnect: OCIEnvCreate [-1] Posted on 2009-09-01 Oracle Database 1 Verified Solution 11 Comments 6,258 Views Last Modified: 2012-08-13 I ma new to using SQl Loader. I am trying to load a datafile into a table and am running sqlldr from my pc. I have oracle 10.2 client installed in my machine. The ORACLE_HOME and PATH is properly set. But when I invoke sqlldr , I am getting the following msg H:\Data>sqlldr zbc/*********@test1 control=DataLdr.ctl SQL*Loader: Release 10.2.0.1.0 - Production on Tue Sep 1 11:08:47 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] zbc is a schema in the test1 database. I am logged into the pc as say name123. Can anyone tell me what I am doing wrong. Thanks 0 Question by:happylife1234 Facebook Twitter LinkedIn Google LVL 40 Best Solution bymrjoltcola >>Strangely when I run the sqlldr from another machine, it works fine. >> >>SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 1 12:42:15 2009 Your other machine has 10.2.0.3. Your problem Go to Solution 11 Comments LVL 40 Overall: Level 40 Oracle Database 32 Message Expert Comment by:mrjoltcola2009-09-01 Can you properly connect via sqlplus from the same PC? sqlplus zbc/*****@test1 0 Message Active 1 day ago Author Comment by:happylife12342009-09-01 Yes, I can do that. 0 LVL 40 Overall: Level 40 Oracle Database 32 Message Expert Comment by:mrjoltcola2009-09-01 Can you show your tnsnames.ora and your sql loader control file? 0 LVL 11 Overall: Level 11 Oracle Database 11 Message Active 6 days ago Expert Comment by:it-rex2009-09-01 check this answer http://www.experts-exchange.com/Database/Oracle/Q_23933693.html 0 LVL 11 Overall: Level 11 Oracle Database 11 Message Active 6 days ago Expert Comment
SonicWALL User Sorry, we are having issues processing your request. If you own the SonicWALL product requested please confirm that you have registered your product at My SonicWALL . If you have already registered your product then please contact Customer Service directly for further assistance at customerservice@software.dell.com. Continue × Support Forms Under Maintenance Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience. Continue Search Sign In https://www.experts-exchange.com/questions/24698660/SQL-Loader-704-Internal-Error-ulconnect-OCIEnvCreate-1.html Sign In Create Support Account Products ActiveRoles Boomi Change Auditor Foglight Identity Manager KACE Migration Manager Rapid Recovery Recovery Manager SharePlex SonicWALL Spotlight Statistica Toad View all Products Solutions Application & Data Integration Big Data Analytics Business Intelligence Cloud Management Data Protection Overview Backup and Recovery Deduplication and Compression Database Development and Management Database Replication & Backup Endpoint Management Mobile https://support.software.dell.com/toad-for-oracle/kb/152914 Workforce Management Overview Desktop Virtualization Enterprise Mobility Management Endpoint Security Network Security Secure Remote Access Performance Monitoring Security Overview Email Security Endpoint Security Identity & Access Management Network Security Secure Remote Access Virtualization Management Microsoft Platform Management View all Solutions Solutions by Platform Active Directory Exchange Google GroupWise & NDS Hadoop Hyper-V Lotus Notes Skype for Business/Lync Office 365 Oracle SharePoint SQL Server VMware Trials Buy Support By Product Line Enterprise Reporter Foglight KACE Migration Manager Migrator NetVault One Identity Quick Connect Performance Analysis Recovery Manager Shareplex SonicWALL Spotlight SQL Navigator Toad All Products Contact Support Download Software Knowledge Base My Account My Products My Service Requests My Licenses My Groups My Profile Policies & Procedures Professional Services Technical Documentation Training & Certification User Forums Video Tutorials Support Home Communities Partners × Email Share your favorite Support content with a friend. Email To Email From Subject Information from Dell Software Support Message You might be interested in the following information For more information regarding support on your Dell Software Product, please visit www.software.dell.com/support Print Email My Downloads ()
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business http://stackoverflow.com/questions/5881282/error-in-loading-a-data-from-the-txt-file-to-oracle-table-using-sqlldr Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like http://www.solveerrors.com/forums/20/oracle/sqlloader-704-internal-error-ulconnect-ocienvcreate-1-228906 you, helping each other. Join them; it only takes a minute: Sign up Error in loading a data from the txt file to oracle table using sqlldr up vote 0 down vote favorite my .ctl file is : internal error LOAD DATA INFILE "C:\Users\nkb1\Desktop\fnames.txt" INTO TABLE MDB.TEACHERS FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (first_name,last_name) i am executing this from the windows command prompt as sqlldr system@mdb/mdb control=C:\Users\nkb1\Desktop\load.ctl and i am getting error like this. C:\Users\nkb1>sqlldr system@mdb/mdb control=C:\Users\nkb1\Desktop\load.ctl SQL*Loader: Release 10.2.0.1.0 - Production on Wed May 4 14:44:22 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] and i have set the ORACLE_HOME variable as C:\oracle\product\10.2.0\db_2 where the internal error ulconnect db stores oracle sql-loader share|improve this question edited May 4 '11 at 10:04 Dotnet 4,8371886175 asked May 4 '11 at 9:25 Navin 166715 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote Bad news, this is a bug in 10.2.0.1. Check Metalink document 361325.1 (hope you have access)! Maybe you'll just have to grant additional privileges but it is possible that you'll need to apply the 10.2.0.3 patch set share|improve this answer answered May 4 '11 at 9:47 bpgergo 11.3k12649 I suspect if @Navin had a Support account they wouldn't still be running the base release of 10g. Oracle used to host the stable 10.2.0.4 release on OTN, but it looks like they now only make 11gR2 available from that place. –APC May 4 '11 at 12:22 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged oracle sql-loader or ask your own question. asked 5 years ago viewed 3842 times active 5 years ago Blog Stack Overflow Podcast #91 - Can
data is loading without any problem. I logged in as other(sup_load) Operating system user and I tried to load data using SQLLDR for the same(sup) database user. I am getting the error " SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]" $ whoami sup_load $ pwd /home/sup_load $ export ORACLE_HOME=/u111/app/oracle/product/10.2 $ export ORACLE_SID=migsso $ ls -ltr total 96 -rw-rw-r-- 1 sup_load users 163 Nov 28 07:33 aubCO3A2006.A -rw-rw-r-- 1 sup_load users 1795 Nov 28 07:35 pir_seca.ctl -rw-rw-r-- 1 sup_load users 192 Nov 28 07:37 aubCO3A2006.log $ $ORACLE_HOME/bin/sqlldr sup/sup control=pir_seca.ctl bad=aubCO3A2006.bad log=aubCO3A2006.log data=aubCO3A2006.A SQL*Loader: Release 10.1.0.4.2 - Production on Tue Nov 28 07:37:56 2006 Copyright (c) 1982, 2005, Oracle. rights reserved. SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1] We checked as user permission and and environment variables, we checked for Oracle user, and tested in the $ORACLE_HOME/bin directory itself still we are getting the same error. Posted On:Thursday 1st of November 2012 10:23:34 PM Total Views: 376 View Complete with Replies Related Messages: ⇒ Sql*loader error:unable to open file:Tns Protocol adaptor error! ⇒ SQL Loader error! ⇒ Web approach to OEM gives error VTD-0123 ⇒ SMON: terminating instance due to error 600 ⇒ Problems with internal user ⇒ studio-internal ⇒ OleDbDataAdapter internal error: invalid rowset accessor: Ordinal=1 Status=UNSUPPORTEDCONVERSION. ⇒ startup, but got ORA-00600: internal error code, arguments: [3668], [1], [2], [205376 ⇒ 'Export2sqlce' is not recognized as an internal or external command ⇒ SP2-0642: SQL*Plus internal error state 1075 ⇒ what is password for internal user ? ⇒ Urgent: ORA-00600: internal error at sql statement ⇒ Urgent : can not connect internal ⇒ server mgr/ internal to be discontiued ⇒ TNS-12540: TNS:internal limit restriction exceeded ⇒ PLS-00801: internal error & PL/SQL: ORA-06544: PL/SQL: internal error, arguments: ⇒ problem with connect internal ⇒ help me PLS-00801- internal error ⇒ Please Help: ODP.NET Data provider internal error(-3000) ⇒ restet internal pass Sql*loader error:unable to open file:Tns Protocol adaptor error!  (18Views) Hi all! Query: 1.I am trying to load d