Internal Error Ulconnect Ociserverattach
Contents |
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #69237] Tue, 27 November 2001 10:28 Wally Messages: 3Registered: November 2001 Junior Member I tried using the sqlldr locally to load data to the server. I received the error message. SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [[0]] ORA-12560: TNS:protocol sql*loader-704 internal error ulconnect ociserverattach 0 ora-12560 adapter error Is there any ora file that I should change or update to be sql*loader-704 internal error ulconnect ocienvcreate -1 able to use sqlldr from client to load data in the server. Thanks in advance!!! ---------------------------------------------------------------------- Report message to a moderator
Sql*loader-704 Internal Error Ulconnect Ociserverattach 0 Ora-12545
Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #69603 is a reply to message #69237] Wed, 06 February 2002 11:21 Thomas Zezulka Messages: 1Registered: February 2002 Junior Member Wally, I was having the same problem when
Sql*loader-704 Internal Error Ulconnect Ociserverattach 0 Ora-12514
my machine crashed and I had to put on Oracle8si. The problem is Oracle8si no longer will look directly at your database sid name so you can't use it in the sql loader command line. You have to create a local service name calling your database. So what you call in the command line is the name of your local service name. Let me know if you need more help. Thanks, Thomas Report message to sql*loader-704: internal error: ulconnect: ociserverattach [0] ora-12170 a moderator Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #70162 is a reply to message #69237] Tue, 23 April 2002 08:08 Anurag Garg Messages: 1Registered: April 2002 Junior Member Try using this command sqlldr username/password@service control='controlfile.ctl' log='logfile.log' make sure that ur .dat file is in the path. Hope this helps Regds Anurag garg Report message to a moderator Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #70187 is a reply to message #69237] Fri, 26 April 2002 09:53 Bernardo Zamora Messages: 1Registered: April 2002 Junior Member This really really helped a lot, it was exactly what was happening! (and nowhere had I seen the @.... parameter) Report message to a moderator Re: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] [message #71939 is a reply to message #69237] Fri, 07 February 2003 22:51 Sethuram Messages: 2Registered: February 2003 Junior Member As kant has asked this is not a bug, It is the way Oracle has designed it. SQL Loader uses all internals of oracle to push in the files to the database. So Oracle not concerned with the ip or anything which you specify externally. He uses the service name which you have in the tnsnames.ora. If you think around this is the efficient way for inserting. Report message to a moderator Re: S
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this
Sql*loader-704: Internal Error: Ulconnect: Ociserverattach [0] Ora-12541: Tns:no Listener
page. Please enter a title. You can not post a blank message. sql*loader-704: internal error: ulconnect: ocienvcreate [-1] Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions sql*loader-704: internal error: ulconnect: ociserverattach [0] ora-12560: tns:protocol adapter error This discussion is archived 5 Replies Latest reply on Jul 28, 2010 9:49 AM by OraMol ORA-12154: TNS:could not resolve the connect identifier specified 718177 Jul 28, 2010 6:58 http://www.orafaq.com/forum/t/25048/ AM Hi everyone, I am getting this error when I am trying to use SQLLDR ORA-12154: TNS:could not resolve the connect identifier specified -- tns entry is xyz = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xxx.xx)(PORT = 1526)) ) (CONNECT_DATA = (SID = xyz) ) ) https://community.oracle.com/thread/1108264 -- I am able to connect using sqlplus sqlplus user/pwd@xyz -- but when I am trying to use sqlldr as follows, I am getting ORA-12154 error sqlldr userid=user/pwd@xyz DATA=test_sql_ldr.txt CONTROL=test_sql_ldr.ctl LOG=test_sql_ldr.log SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jul 28 11:42:53 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve the connect identifier specifiedI also read following thread for same type of error : ORA-12154: TNS:could not resolve the connect identifier specified But unable to resolve my issue Please let me know what is wrong here? Thanks, Abhi I have the same question Show 0 Likes(0) 8025Views Tags: none (add) ora-12154Content tagged with ora-12154, sqlldrContent tagged with sqlldr This content has been marked as final. Show 5 replies 1. Re: ORA-12154: TNS:could not resolve the connect identifier specified 618702 Jul 28, 2010 7:10 AM (in response to 718177) Dear Abhi.k, Use single quotes around the .ctl, .txt and .log files. Like; sqlldr userid=user/pwd@xyz DATA='test_sql_ldr.txt' CONTROL='test_sql_ldr.ctl' LOG='test_sql_ldr.log'Hope That Helps. Ogan Like Show 0 Likes(
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 https://www.experts-exchange.com/questions/24061281/SQL-Loader-704-Internal-error-ulconnect-OCIServerAttach-0.html 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 http://digitalsanctum.com/2008/08/20/sqlloader-704-error/ error: ulconnect: OCIServerAttach [0] Want to Advertise Here? Solved SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] Posted on 2009-01-17 Oracle Database 1 Verified Solution 13 Comments 6,951 Views 1 Ratings Last Modified: 2016-08-11 When internal error my application calls the sql loader to update the data fron csv file to database, i am getting this error SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve the connect identifier specified I have verified the TNSNames.ora file , it has all the connect identifiers mentioned perfect. Could you please help me to find a solution for this. 1 Question by:balatrue Facebook Twitter LinkedIn internal error ulconnect Google LVL 27 Best Solution bysujith80 What was the issue? Go to Solution 13 Comments Message Author Comment by:balatrue2009-01-17 More over I could not find the oracle service in Administrative tools>Services of windows. how it's possible. I am using the Oracle 10.2 client 0 LVL 27 Overall: Level 27 Oracle Database 27 Message Expert Comment by:sujith802009-01-17 Do you have the environement variable TNS_ADMIN set correctly? It should point to the directory where you have the tnsnames.ora file. Try to run sqlloader from command line to see whether it loads the data. 0 Message Author Comment by:balatrue2009-01-19 I have set the TNS_ADMIN environment variable and ran the sqlloader from command line. I got this error SQL*Loader: Release 10.2.0.1.0 - Production on Mon Jan 19 10:08:19 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-500: Unable to open file (Premiums.ctl) SQL*Loader-553: file not found SQL*Loader-509: System error: The system cannot find the file specified. But Premiums.ctl is available in that folder. Could you please help me here. 0 LVL 27 Overall: Level 27 Oracle Database 27 Message Expert Comment by:sujith802009-01-19 What is the OS? Any file permission issues? 0 Message Author Comment