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 -> Re: SQL*Loader-128:

Re: SQL*Loader-128:

From: <fitzjarrell_at_cox.net>
Date: Thu, 20 Sep 2007 08:27:02 -0700
Message-ID: <1190302022.255296.282540@g4g2000hsf.googlegroups.com>


On Sep 20, 9: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

It would appear the permission mask for the $ORACLE_HOME directory tree is not set properly. This is explained in Metalink Note 115753.1.

David Fitzjarrell Received on Thu Sep 20 2007 - 10:27:02 CDT

Original text of this message

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