Re: [Condor-users] How can I connect to Oracle DB on condor system ???(ORA-01034, ORA-27101)

[Jaime Frey <jfrey@xxxxxxxxxxx>]

On Oct 4, 2005, at 2:01 AM, êìí wrote:

My program can connect to oracle DB alone...

Â

ButÂthis program can`t connect to Oracle DBÂwith "condor submit" command..

Â

I thoght this is the problem about environment,

so I added "environment = ORACLE_BASE=/usr/oracle;ORACLE_HOME=/usr/oracle/product/9.2.0/; ORA_NLS33=/usr/oracle/product/9.2.0/ocommon/nls/admin/data;ORACLE_SID=alm; LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/oracle/product/9.2.0/lib;"

but couldn`t ... --;;

Help me...

Â

error message:

ÂÂÂ ORA-01034: ORACLE not available
ÂÂÂ ORA-27101: shared memory realm does not exist
ÂÂÂ SVR4 Error: 2: No such file or directory

Could there be some other environment variable you're forgetting? If you add 'GetEnv = True' to your submit file, Condor will add everything in your current environment into the job's environment.

Depending on how you submit the job, it could be executing on a remote machine. The user log will tell you what machine the job runs on. If it's not the submit machine, check that your job will run on that machine. Maybe it's missing some Oracle files or they're in a different location.

+----------------------------------+---------------------------------+

|     ÂÂJaime Frey     ÂÂ|ÂÂPublic Split on Whether   ÂÂ|

|   ÂÂjfrey@xxxxxxxxxxx   ÂÂ|ÂÂBush Is a Divider      ÂÂ|

|ÂÂhttp://www.cs.wisc.edu/~jfrey/ÂÂ|ÂÂ Â Â ÂÂ-- CNN Scrolling Banner |

+----------------------------------+---------------------------------+