SQLLDR connection error [message #564544] |
Sat, 25 August 2012 06:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/37a89908b86eca76f2d0cff551796e54?s=64&d=mm&r=g) |
vchenna
Messages: 1 Registered: August 2012
|
Junior Member |
|
|
Hello
The SQLLDR fails with connection error:
SQLLDR userid=userid/passwd@vpl01 control=OtherType.ctl log=OtherType.log bad=OtherType.bad
SQL*Loader: Release 11.2.0.1.0 - Production on Sat Aug 25 13:32:42 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]
If I provide full connection string, it gives syntax error:
sqlldr userid/passwd@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orasrv)(PORT=1526))(CONNECT_DATA=(SID=vpl01))) control=OtherType.ctl log=OtherType.log bad=OtherType.bad
LRM-00116: Message 116 not found; No message file for product=ORACORE, facility=LRM
SQL*Loader: Release 11.2.0.1.0 - Production on Sat Aug 25 09:14:18 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
SQL*Loader-100: Syntax error on command-line
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I am able to connect Oracle using SQLPLUS on cmd using full connection url:
sqlplus userid/passwd@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orasrv)(PORT=1526))(CONNECT_DATA=(SID=vpl01)))
SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 25 13:32:14 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
but it doesn't work if supplied following command:
sqlplus userid/passwd@vpl01
SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 25 13:32:14 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Even tnsping vpl01 gives error:
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 25-AUG-2012 09:14:40
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
TNS_ADMIN, ORACLE_HOME, ORACLE_SID, PATH have been set correctly.
The Oracle server is on Linux 64-bit and Oracle client is on Windows 64-bit.
Thanks for your help
Vis
|
|
|
|
Re: SQLLDR connection error [message #564554 is a reply to message #564544] |
Sat, 25 August 2012 11:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Quote:TNS_ADMIN, ORACLE_HOME, ORACLE_SID, PATH have been set correctly. You might want to check this, because I think that at least one of these is not correct. Your SQL*Plus is release 11.2.0.3.0, but your SQL*Loader and your TNS Ping are release 11.2.0.1.0. This is impossible, so there has to be some confusion between multiple Oracle Homes.
[Updated on: Sat, 25 August 2012 11:43] Report message to a moderator
|
|
|
|
|