ORACLE_HOME on AIX 4.3.3

[230173]

If i log on with the user oracle i the system always asks me for the ORACLE_SID and the ORACLE_HOME.
Where can i configure this so that the next time i log on oracle will know these things.
I already looked in the .profile
I dont think this is the place to put in these things?

 

[230173]

I already put in :

ORACLE_HOME=/opt/app/oracle/product/8.1.7 (home)
export ORACLE_HOME

in the .profile.
This is not working!!!!

 

[ilev]

I think you can put all your env in .cshrc
(if you use csh )
ORACLE_HOME, add to path $ORACLE_HOME/bin
ORACLE_SID and you can use TWO_TASK too.

You can create script with all these statments and
to run it when you need it.

 

[230173]

I'm using ksh.Where can i find this file.

 

[rcurva]

I don't think there is a problem in putting these ORacle environment variables in the .profile, try;

export ORACLE_HOME=/opt/app/oracle/product/8.1.7
export ORACLE_SID=<SID>
export PATH=.:$PATH:$ORACLE_HOME/bin

These can also be put in (.cshrc, .kshrc) depends on the shell you are using just like what ilev said.

What do you specifically mean &quot;This is not working&quot;? Is there an error when you run an Oracle utility, like svrmgrl?

 

[230173]

It just doesn't help when i put this export in the .profile.
Oracle still asks me the ORACLE_HOME and ORACLE_SID.

This is the .profile:

BCK_BIN=/opt/app/oracle/admin/qualp/backup ; export BCK_BIN
PATH=/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.:/opt/app/oracle/
admin/qualp/backup:/opt/app/oracle/product/8.1.7:$BCK_BIN

ORACLE_HOME=/opt/app/oracle/product/8.1.7
export PATH
ORACLE_TERM=3151; export ORACLE_TERM
ORACLE_SID=prodenv; export ORACLE_SID
ORACLE_HOME=/opt/app/oracle/product/8.1.7; export ORACLE_HOME
#export LINES=25
#export COLUMNS=80
#export TERM=vt100
export ORAENV_ASK=YES
. oraenv
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH
PATH=$PATH:$ORACLE_HOME/bin
export PATH
set -o vi
if [ -s &quot;$MAIL&quot; ] # This is at Shell startup. In normal
then echo &quot;$MAILMSG&quot; # operation, the Shell checks
fi # periodically.
alias ls='ls -F'
alias s='cd $HOME/sql ; sqlplus system @$HOME/sql/sess.sql'
alias menu='cd $SBIN;$SBIN/smenu.sh'

cd $HOME/smenu
. ./ad

 

[sem]

Your oraenv script asks you for ORACLE_HOME and ORACLE_SID values.
Delete a call to it if you use static values.

 

[rcurva]

could you put all your variables after execution of the oraenv script? or check the oratab file.

 

[230173]

Thanx rcurva!!!
It's the oratab.
I moved it.
Do you know where it should be?

 

[230173]

I found it.
Thanx anyway