Home » RDBMS Server » Server Utilities » SQLLDR connection error (Oracle 11gR2)
SQLLDR connection error [message #564544] Sat, 25 August 2012 06:49 Go to next message
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 #564550 is a reply to message #564544] Sat, 25 August 2012 09:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 NEVER involves the listener, the database itself or anything on the DB Server.
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/
Re: SQLLDR connection error [message #564554 is a reply to message #564544] Sat, 25 August 2012 11:42 Go to previous messageGo to next message
John Watson
Messages: 8922
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

Re: SQLLDR connection error [message #569829 is a reply to message #564554] Fri, 02 November 2012 04:25 Go to previous messageGo to next message
anuragkumarjoy
Messages: 1
Registered: November 2012
Location: INDIA
Junior Member

lsnrctl start then connect the
Re: SQLLDR connection error [message #569834 is a reply to message #569829] Fri, 02 November 2012 07:20 Go to previous message
manish_vichare
Messages: 3
Registered: October 2012
Junior Member
Please Maria,
will it be posible for you to speciy each steps that you followed for Migration of Sybase 12.5 to Oracle 11g on linux ?

Thanks
Previous Topic: migration from Sybase to oracle 1 table fails with SQL Error: ORA-01841: (full) year must be between
Next Topic: ORA-31684 and ORA-39082 while exp/imp
Goto Forum:
  


Current Time: Thu Mar 28 18:18:40 CDT 2024