Error running sqlldr
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Error running sqlldr

  1. #1
    Join Date
    Mar 2007
    Posts
    3

    Error running sqlldr

    We have recently upgraded our system from 9i to 10g......I can access our instances fine and do all necessary work that I'ved tested so far....I was testing to see if I can remove the 9i software when I ran into a problem....

    I renamed our /u01/oracle directory to /u01/oracle_bak so that during testing if any environment variables are still pointing to the old Oracle home, i'd see a problem....During running a shell script that works on our Oracle application, I got the following error:

    /usr/lib/pa20_64/dld.sl: Unable to find library 'libwtc9.sl'.
    /sdw/massload/script/olap_load_tab_new.sh[17]: 4617 Killed
    SQL*Loader-500: Unable to open file (qtblvquery0.int)
    SQL*Loader-553: file not found
    SQL*Loader-509: System error: No such file or directory
    SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

    It appears that the sqlldr executable in our 10g directory is somehow calling the 9i lib's.....I did an ldd on our new Oracle home directory and everything looks good....See below

    /U03/app/oracle/product/10.2.0/bin>ldd -s sqlldr

    find library=libclntsh.sl.10.1; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libclntsh.sl.10.1
    trying path=/U03/app/oracle/product/10.2.0/lib//libclntsh.sl.10.1
    libclntsh.sl.10.1 => /U03/app/oracle/product/10.2.0/lib//libclntsh.s1

    find library=libnnz10.sl; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libnnz10.sl
    trying path=/U03/app/oracle/product/10.2.0/lib//libnnz10.sl
    libnnz10.sl => /U03/app/oracle/product/10.2.0/lib//libnnz10.sl

    find library=libcl.2; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libcl.2
    trying path=/U03/app/oracle/product/10.2.0/lib//libcl.2
    trying path=/usr/lib/pa20_64/libcl.2
    libcl.2 => /usr/lib/pa20_64/libcl.2

    find library=librt.2; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//librt.2
    trying path=/U03/app/oracle/product/10.2.0/lib//librt.2
    trying path=/usr/lib/pa20_64/librt.2
    librt.2 => /usr/lib/pa20_64/librt.2

    find library=libpthread.1; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libpthread.1
    trying path=/U03/app/oracle/product/10.2.0/lib//libpthread.1
    trying path=/usr/lib/pa20_64/libpthread.1
    libpthread.1 => /usr/lib/pa20_64/libpthread.1

    find library=libnss_dns.1; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libnss_dns.1
    trying path=/U03/app/oracle/product/10.2.0/lib//libnss_dns.1
    trying path=/usr/lib/pa20_64/libnss_dns.1
    libnss_dns.1 => /usr/lib/pa20_64/libnss_dns.1

    find library=libdl.1; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libdl.1
    trying path=/U03/app/oracle/product/10.2.0/lib//libdl.1
    trying path=/usr/lib/pa20_64/libdl.1
    libdl.1 => /usr/lib/pa20_64/libdl.1

    find library=libnsl.1; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libnsl.1
    trying path=/U03/app/oracle/product/10.2.0/lib//libnsl.1
    trying path=/usr/lib/pa20_64/libnsl.1
    libnsl.1 => /usr/lib/pa20_64/libnsl.1

    find library=libm.2; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libm.2
    trying path=/U03/app/oracle/product/10.2.0/lib//libm.2
    trying path=/usr/lib/pa20_64/libm.2
    libm.2 => /usr/lib/pa20_64/libm.2

    find library=libc.2; required by sqlldr
    search path=/U03/app/oracle/product/10.2.0/rdbms/lib/:/U03/app/oracle/produ)
    trying path=/U03/app/oracle/product/10.2.0/rdbms/lib//libc.2
    trying path=/U03/app/oracle/product/10.2.0/lib//libc.2
    trying path=/usr/lib/pa20_64/libc.2
    libc.2 => /usr/lib/pa20_64/libc.2

    find library=libnnz10.sl; required by /U03/app/oracle/product/10.2.0/lib//lib1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libnnz10.sl
    libnnz10.sl => /U03/app/oracle/product/10.2.0/lib/libnnz10.sl

    find library=librt.2; required by /U03/app/oracle/product/10.2.0/lib//libclnt1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/librt.2
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/librt.2
    librt.2 => /lib/pa20_64/librt.2

    find library=libpthread.1; required by /U03/app/oracle/product/10.2.0/lib//li1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libpthread.1
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/libpthread.1
    libpthread.1 => /lib/pa20_64/libpthread.1

    find library=libnss_dns.1; required by /U03/app/oracle/product/10.2.0/lib//li1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libnss_dns.1
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/libnss_dns.1
    libnss_dns.1 => /lib/pa20_64/libnss_dns.1

    find library=libdl.1; required by /U03/app/oracle/product/10.2.0/lib//libclnt1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libdl.1
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/libdl.1
    libdl.1 => /lib/pa20_64/libdl.1

    find library=libnsl.1; required by /U03/app/oracle/product/10.2.0/lib//libcln1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libnsl.1
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/libnsl.1
    libnsl.1 => /lib/pa20_64/libnsl.1

    find library=libm.2; required by /U03/app/oracle/product/10.2.0/lib//libclnts1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libm.2
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/libm.2
    libm.2 => /lib/pa20_64/libm.2

    find library=libc.2; required by /U03/app/oracle/product/10.2.0/lib//libclnts1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libc.2
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/libc.2
    libc.2 => /lib/pa20_64/libc.2

    find library=libcl.2; required by /U03/app/oracle/product/10.2.0/lib//libclnt1
    search path=/U03/app/oracle/product/10.2.0/lib (RPATH)
    trying path=/U03/app/oracle/product/10.2.0/lib/libcl.2
    search path=/lib/pa20_64:/usr/lib/pa20_64 (default)
    trying path=/lib/pa20_64/libcl.2
    libcl.2 => /lib/pa20_64/libcl.2

    find library=libdl.1; required by /usr/lib/pa20_64/libcl.2
    search path=/usr/lib/pa20_64:/usr/ccs/lib/pa20_64 (RPATH)
    trying path=/usr/lib/pa20_64/libdl.1
    libdl.1 => /usr/lib/pa20_64/libdl.1

    find library=libxti.2; required by /usr/lib/pa20_64/libnsl.1
    search path=/usr/lib/pa20_64: (RPATH)
    trying path=/usr/lib/pa20_64/libxti.2
    libxti.2 => /usr/lib/pa20_64/libxti.2


    If i rename the /u01/oracle_bak directory back to /u01/oracle, everything works fine....So somewhere 10g is pointing at the old 9i lib directory for running the 10g sqlldr executable....I've shutdown the databases and relinked all libs with the old software still named /u01/oracle_bak hoping that would correct the problem, but it didn't.....

    any ideas????????

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    your SHLIB_PATH (assuming you are on HPUX)

    also you cannot just rename directories, you mess up the inventory

  3. #3
    Join Date
    Mar 2007
    Posts
    3
    Here are the SHLIB_PATH and LD_LIBRARY_PATH variables that are set in the shell script during execution.....

    Renaming the 9i directory shouldn't matter to the inventory since the 9i instances are all shutdown.....I'm just trying to ensure that nothing is pointing to the OLD Oracle home /u01/oracle/product/9.2.0

    export SHLIB_PATH=/U03/app/oracle/product/10.2.0/lib:/usr/lib:/opt/image/lib:/opt/audio/lib

    export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib

    export LD_LIBRARY_PATH=/U03/app/oracle/product/10.2.0/lib:/usr/lib

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Log on as the user who executes the script, export the environment variables that are set in the script at the command line, then "env". Chances are something like this:

    export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib

    is the problem ($ORACLE_HOME still pointing to 9i home).
    Assistance is Futile...

  5. #5
    Join Date
    Mar 2007
    Posts
    3
    Yeah, I thought of that......But no such luck.....All the current environment variables are set looking at the new 10.2.0 directory and not the old 9i directories.....

  6. #6
    Join Date
    Jun 2006
    Posts
    259
    Do you have the shared flag enabled on sqlldr ? If not, it won't access the shlib_path environement variables. To see the state, run chatr command against the binary.

    To enable it run chatr +s enable

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width