OraFAQ Forum: Server Utilities » SQL Loader not starting from Solaris

Home » RDBMS Server » Server Utilities » SQL Loader not starting from Solaris

Mon, 18 June 2007 12:31

feroze
Messages: 144
Registered: September 2005
Location: chicago

Senior Member

Hi,

from Command Prompt i am able to run the SQL Loader Utility and the same control file when i run on Solaris 5.9 it's giving this

$ sqlldr
ksh: sqlldr:  not found

Oracle is 9.2 Version

Does the command differ in Solaris or what am i doing wrong here

Thanks

Mon, 18 June 2007 12:33

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you sure $ORACLE_HOME/bin is in your PATH?

Btw, are you sure ORACLE_HOME is set in your environment?

Regards
Michel

[Updated on: Mon, 18 June 2007 12:34]

Mon, 18 June 2007 12:34

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

did you export ORACLE_SID

like this
export ORACLE_SID=MYDB

or if you using kshell

then
. .profile_mydb

Mon, 18 June 2007 12:34

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Your environment is not set up. PATH, ORACLE_HOME, etc. are not set.

Previous Topic:	SQL * Loader Problem
Next Topic:	SQL Loader Issue

Goto Forum:

]

Current Time: Wed Jun 26 13:52:01 CDT 2024