Home » RDBMS Server » Server Utilities » SQL Loader (Oracle 10g2 under Suse10)
SQL Loader [message #409385] Mon, 22 June 2009 07:18 Go to next message
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 #409390 is a reply to message #409385] Mon, 22 June 2009 07:35 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First you have to start the database.

Regards
Michel
Re: SQL Loader [message #409406 is a reply to message #409390] Mon, 22 June 2009 08:09 Go to previous message
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
Previous Topic: issue with import (merged 2) 10.1.0.2.0 windows
Next Topic: How to load data from a file with two types of field delimeters
Goto Forum:
  


Current Time: Tue Dec 06 14:08:51 CST 2016

Total time taken to generate the page: 0.12735 seconds