Re: oraenv - what am i doing wrong?

How to use oraenv:

If you want to set a default sid:
export ORAENV_ASK=NO
export ORACLE_SID=dev1 # the SID is case-sensitive! . oraenv # don't forget to use a space between the . and the o export ORAENV_ASK=
#restore default behavior
If you want to set your own sid
You need to write an one-line bash command to dump the contents of oratab. Right now I don't have that at hand, but it should be listed in the getting started manual.
do NOT set oraenv_ask and run
. oraenv (do not forget the space or oraenv will run in it's own shell) etc..

Hth,
Sybrand Bakker, Oracle DBA

<kal121_at_my-deja.com> wrote in message news:8p9ani$vte$1_at_nnrp1.deja.com...
> In my .bash_profile, I am calling "oraenv" because I have two instances
> on one box (dev1 and dev2) and want to be prompted for my ORACLE_SID.
>
> This is what my oraenv entries look like in .bash_profile:
>
> ORAENV_ASK=yes (I'm not sure I need this?)
> oraenv
>
> I do not specify an ORACLE_SID anywhere in the file.
> I also have entries in oratab corresponding to the two different SIDs.
>
> When I log on as the "oracle" user, it prompts me for the SID like this:
> ORACLE_SID = [oracle] ?
>
> This does not look right to me. Anyways, what am I supposed to type
> here? Shouldn't it prompt me with the sid names, e.g.) dev1 and dev2?
> Well, regardless of what I type in here, it doesn't set the ORACLE_SID
> at all.
>
> What am I doing wrong?
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Sep 07 2000 - 23:26:31 CDT