704 Internal Error Ulconnect Ociserverattach 0
Contents |
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 sql * loader 704 ulconnect ociserverattach 0 this site About Us Learn more about Stack Overflow the company Business Learn sql*loader-704 erreur interne ulconnect ociserverattach 0 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question sql*loader-704 internal error ulconnect ociserverattach 0 ora-12560 x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sql*loader-704 internal error ulconnect ocienvcreate -1 ERROR 704 & 12154 while connecting sqlloader to server up vote 0 down vote favorite 1 I have a oracle database based on a server, and I want to import the data in the tables on the server. I am trying to use sqlloadr(sqlldr) for inserting all data in the oracle database, which is on localhost and there is no problem in this
Sql*loader-704 Internal Error Ulconnect Ociserverattach 0 Ora-12514
case, but the problem occurs while I try to connect a web-server(not localhost). The command that I've used in localhost case: sqlldr
here for a quick overview of the site Help Center Detailed answers to any questions
Sql*loader-704 Internal Error Ulconnect Ociserverattach 0 Ora-12545
you might have Meta Discuss the workings and policies of this sql loader 704 internal error ulconnect ociserverattach 0 ora 12541 tns no listener site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers sql*loader-704: internal error: ulconnect: ocienvcreate [-1] 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 http://stackoverflow.com/questions/6232958/error-704-12154-while-connecting-sqlloader-to-server of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQL*Loader-704 and ORA-12154 up vote 0 down vote favorite sqlldr "xxxx/xxxx@DDCPPSD" control=/home/local/INTERNAL/achand/Presc_SQLLDR_File/Presc_SQLLDR.ctl log=/home/local/INTERNAL/achand/Presc_SQLLDR_File/Presc_log.log data=home/achand/Presc_SQLLDR_File/Presc_SQLLDR.ctl Whenever i'm trying to execute sqlldr I'm getting below error SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve http://stackoverflow.com/questions/30819961/sqlloader-704-and-ora-12154 the connect identifier specified I tried tnsping DDCPPSD I got below error TNS-03505: Failed to resolve name tnsnames.ora contain DDCPPSD.WORLD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = cdtsorl308d)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = DDCPPSD) ) ) sql-loader oracle12c tnsping share|improve this question edited Jun 13 '15 at 16:20 asked Jun 13 '15 at 14:47 akhilesh chand 8219 Is DDCPPSD defined in your tnsnames.ora file, on the client machine you're running SQL*Loader from? –Alex Poole Jun 13 '15 at 15:27 Alex thanks for ur reply plz show above. –akhilesh chand Jun 13 '15 at 16:21 Does tnsping ddcppsd.world work then? If not maybe the file is in the wrong place, or TNS_ADMIN is pointing to the wrong place. Does your sqlnet.ora have a default domain entry? –Alex Poole Jun 13 '15 at 16:45 Alex tnsping ddcppsd.world is working and sqlnet.ora have a default domain entry. –akhile
Technote (troubleshooting) Problem(Abstract) Publish failing for all apps in the http://www-01.ibm.com/support/docview.wss?uid=swg21347615 environment Symptom From console error details: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] From the .out file in the temp directory: ORA-12154: TNS:could not http://vajoonoracle.blogspot.com/2012/08/ora-12154-ora-12162-calling-sqlloader.html resolve the connect identifier specified Cause The Oracle bulk load utility, sqlldr, could not successfully connect to the oracle instance. Environment Oracle Resolving internal error the problem During the publish process, a series of files are created in the TEMP directory on the job server that is processing the publish. If you open the .cmd file in the TEMP directory, you should see the sqlldr command that is being executed. Try ulconnect ociserverattach 0 running that same command in a command prompt on that server (to simulate what happens during a publish. If the command doesn't work when you try to run it manually, that could indicate an issue with the Oracle SQLLDR utility. A common problem is the @ symbol in either the oracle username or password - that's valid in other parts of Oracle, but will cause the sqlldr utility to fail. Cross Reference information Segment Product Component Platform Version Edition Business Analytics Cognos Planning Contributor Windows 8.1 Historical Number 1037914 Document information More support for: Cognos 8 Planning Contributor Software version: 8.1 Operating system(s): Windows Reference #: 1347615 Modified date: 2010-12-10 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
SQL Tuesday, January 10, 2012 ORA-12154 ORA-12162 calling SQL*Loader / SQL*Plus Problem Description Running SQL*Loader as: sqlload userid=... control=... data=... log=... HOSTSTR logical has been set to same value as your connection string butwithout domain name. When you have specified connect string (ie. SCOTT/TIGER@DATABASE) but nodomain you receive these errors: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12154: TNS:could not resolve service name When you have not specified connect string (ie. SCOTT/TIGER) you receivethese errors: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0] ORA-12162: TNS:service name is incorrectly specified Your sqlnet.ora has: names.default_domain entry = world The syntax in your tnsnames.ora entry is correct. Your entry in tnsnames.ora does not include the .WORLD extension (defaultdomain from sqlnet.ora). Solution Description Specify the .WORLD in your tnsnames.ora and also in your connect string.This will remove the error. Also, ensure you are not hitting [BUG:893290]. Source : Oracle MetalinkNote:116852.1 Posted by Vajo Lukic at 2:58 PM Labels: Oracle Database, SQL No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Labels BI (1) Java (1) OAS (9) Oracle Database (8) Oracle Forms (5) Oracle Reports (6) PL/SQL (4) SQL (6) Blog Archive August 2012 (8) April 2012 (1) March 2012 (1) February 2012 (1) January 2012 (1) December 2011 (1) November 2011 (1) October 2011 (1) September 2011 (1) November 2010 (2) October 2010 (2) September 2010 (2) August 2010 (2) July 2010 (2) June 2010 (3) About Me Vajo Lukic View my complete profile Simple template. Powered by Blogger.