Re: oraenv - what am i doing wrong?

i don't know all the differences between the unix shells, but in my .profile, i precede oraenv with a dot character and a space. apparently, this is required to tell the shell to 'inherit' environment variable changes exported by the called script (oraenv) i.e.

. oraenv

the oraenv script provided by oracle does not present you with a list of "valid" ORACLE_SID settings, but you can set ORACLE_SID prior to calling oraenv. also, be sure to verify that you have correctly setup the required entries for dev1 and dev2 in the oratab file.

<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 - 21:49:40 CDT