SQL Loader [message #409385] |
Mon, 22 June 2009 07:18 |
mgarciagg
Messages: 2 Registered: June 2009
|
Junior Member |
|
|
I installed oracle 10g2 database for the user that I called "Oracle" in Suse. Then if execute sqlldr, everything works properly. However, if when trying to execute SQL*Loader when I logged in with anyother user, the system says :
SQL*Loader-128: unable to begin a session
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux Error: 13: Permission denied
Does anybody know how i can solve this problem and execute SQL Loader with other user different to "Oracle" ?
|
|
|
|
Re: SQL Loader [message #409406 is a reply to message #409390] |
Mon, 22 June 2009 08:09 |
mgarciagg
Messages: 2 Registered: June 2009
|
Junior Member |
|
|
Thank you, but the database was already started.
I have found the solution anyway. The problem was that the folder in which the sqlloader log file (*.log) is going to be created has to have this permission "drwxrwxrwx ", for that I executed a $chmod 7777, and everything works well.
regards!
Mónica
|
|
|