Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader-128:

SQL*Loader-128:

From: Jorge Reyes <jorg_reyes_at_hotmail.com>
Date: Thu, 20 Sep 2007 07:09:30 -0700
Message-ID: <1190297370.378117.239640@22g2000hsm.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US