Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORACLE_HOME=[/orabase]

Status
Not open for further replies.

saw15

Technical User
Jan 24, 2001
468
US
Using Rexex.exe, I pass the following command from a VB app to a Unix server trying to connect to Oracle:

rexec.exe -h -l userID -p password IPAddress /a/db/now/.ora9ienv;


The command stalls, and displays the following in a command prompt. What does it want ?

ORACLE_HOME=[/orabase]?


Help is appreciated.
 
Saw,

It is asking you to enter the directory that is your database's ORACLE_HOME (and it is telling you that if you don't enter the ORACLE_HOME path explicitly, it will use, by default, "/orabase"...which I'll bet is incorrect for your installation.) To determine the correct value to enter for this prompt, issue the following command at your Unix prompt:
Code:
cat /var/opt/oracle/oratab (<- this is for Sun and some others)
or
cat /etc/oratab (<- for AIX, HP-UX, and some others)
The string value that follows the ORACLE_SID string is the value of your ORACLE_HOME that you should supply in response to the prompt, above.

Let us know your findings/results.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA @ 22:11 (19Aug04) UTC (aka "GMT" and "Zulu"), 15:11 (19Aug04) Mountain Time)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top