Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader-128:
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 Received on Thu Sep 20 2007 - 09:09:30 CDT