Re: SQL*Loader-128:

On Sep 20, 7:09 am, Jorge Reyes <jorg_re..._at_hotmail.com> wrote:
> Hi everyone, i hope make me sense with this issue, i want to load a
> file using the sqlldr program this is the command:
>
> sqlldr control=/export/home0/CENIT/scripts/new_avail_load.ctl data=/
> export/home0/CENIT/logs/070913.load userid=ovnoc/xxx log=/export/home0/
> CENIT/logs/070913.load.log bad=/export/home0/CENIT/logs/
> 070913.load.bad
>
> and this is the response
>
> SQL*Loader: Release 9.0.1.0.0 - Production on Wed Sep 19 18:46:58 2007
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
> SQL*Loader-128: unable to begin a session
> ORA-01034: ORACLE not available
> ORA-27123: unable to attach to shared memory segment
> SVR4 Error: 13: Permission denied
>
> and this is my enviroment variables:
>
> ORACLE_HOME=/usr/oracle
> export ORACLE_HOME
> ORACLE_BASE=/usr/oracle
> export ORACLE_BASE
> ORACLE_SID=bizarro
> export ORACLE_SID
> LD_LIBRARY_PATH=/usr/oracle/lib32
> export LD_LIBRARY_PATH
> ICM_LOCALDB=0
> export ICM_LOCALDB
> #PATH=$ORACLE_HOME/bin:/usr/xpg4/bin:/usr/openwin/bin:/usr/sbin:/usr/
> bin:/usr/ucb:/etc:/sbin
> PATH=$PATH:/usr/sbin:/usr/bin:$ORACLE_HOME/bin:/usr/ccs/bin
> export PATH
>
> so i dont know what is happening please help me,
> thanks for advanced

Also be sure and look at what the actual environment is, not just what you think a script is setting. Do other tools like sqlplus work? Are other variables like TWO_TASK set? What is umask? Since it is finding the executable, it is likely that you have an ORACLE_SID problem or a permissions problem. An obscure cause could also be if you have multiple homes and are using the wrong home, so you could be running out of shared memory (this is platform dependent - always state your exact version to four decimal places, as well as the exact platform and operating system you are using) - in some cases, this can happen if an instance was aborted and the shared memory wasn't released.

Some configurations also have ulimit issues.

jg

--
@home.com is bogus.
"He genuinely cared about the little people getting screwed."
http://www.signonsandiego.com/uniontrib/20070919/news_1b19lerach.html