[NTLUG:Discuss] TOra on RH 7.2 - need help connecting to Oracle database

[kbrannen@gte.net]

Fred James wrote:
> I don't mind trying that - would that be something like 
> "//other_machine:/fullpathname"? or is that all wrong?

That looks more like an ORACLE_SID (or is it TWO_TASK?); it's been too long 
since I've done that for me to remember correctly off the top of my head.  You 
need to read the Oracle docs.  The export (whichever one you need) probably 
needs to go at the bottom of /etc/profile so every "sh" will get it (which 
should be the parent of somewhere up the process chain which will pass that 
down to the actual Oracle app).  I remember having to set 2 or 3 different 
env. vars. for Oracle to work correctly; and putting them in /etc/profile made 
sure everyone got them (yes, we discriminated against csh users. :-)

HTH,
Kevin

> 
> 
> Steve Baker wrote:
> 
>> Fred James wrote:
>>
>>> I have TOra loaded and running on my laptop (RH 7.2) and I want to 
>>> set it up to connect to Oracle databases running on Unix servers.
>>> My first error, upon opening TOra is "ORACLE_HOME environment 
>>> veritable not set".
>>
>>
>>
>> I"m guessing that you just need:
>>
>>
>>   export ORACLE_HOME=somehwere
>>
>> ...where 'somewhere' is wherever oracle is installed. (If you use csh
>> or tcsh, you'll need:
>>
>>   setenv ORACLE_HOME somewhere
>>
>> ...instead.