OID 10g Bulk Tools in Windows Using Cygwin Session Fails or Exits / Tnsping Fails With TNS-03505 (Doc ID 305338.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Internet Directory - Version 9.0.4 to 10.1.2 [Release 10gR1 to 10gR2]
Information in this document applies to any platform.
***Checked for relevance on 6-Mar-2013***

Symptoms

Bulk tools (bulkload.sh, bulkdelete.sh) in Windows platforms using Cygwin unix shell emulator fails, for example:

 

./bulkload.sh -connect < servicename, i.e. asdb > -check < path/filename, i.e. /e/user.ldif >
Returns error:
Verifying node "asdb"
-----------------------------
Unable to detect database using connect descriptor asdb
Check Net8 client connect descriptor configuration settings.



The command TNSPING asdb returns error:

Message 3511 not found; No message file for product=NETWORK, facility=TNS
TNS-03505: Message 3505 not found; No message file for product=NETWORK, facility=TNS

 


Other possible symptoms, depending on variables set:

Bulkload.sh cygwin session just exits with no error

Bulkload.sh returns:

cd: can't cd to /ldap/load
Followed by a message with the usage for bulkload.sh, i.e.:
usage: bulkload.sh -connect < connect descriptor >.... etc....

 

Bulkdelete.sh returns:

: command not foundne 6:
: command not foundne 8:
: command not foundne 27:
: No such file or directoryd: /ldap
': not a valid identifier export: `TMPDIR
': not a valid identifier export: `OLDMASK
: command not foundne 31:
'/bulkdelete.sh: line 32: syntax error near unexpected token `{
'/bulkdelete.sh: line 32: `usage() {

 

Sqlnet.ora and Tnsnames.ora files are correct and tnsping asdb works from regular cmd / dos prompt (outside of cygwin session).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms