Re: default ORACLE_SID

anjali <ANJIE_at_prodigy.net> schreef in berichtnieuws 8end8l$meg$1_at_newssvr03-int.news.prodigy.com...
>
> Hi!
>
> i'm learing Oracle and i have a question. How do I make a database and an
> instance a default one.
> everytime i log onto UNIX, it starts an instance but i want my instance to
> be the default one.
> i changed the ORACLE_SID but it stays only for that particular session.
 next
> time i start another session (telnet into unix), it starts the original
> instance.
>
> can someone please help me?!
>
> thanks a bunch!
> anjali.
>
>

In korn shell in .profile
export ORACLE_SID=<yoursid>
export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=""

Hth,

Sybrand Bakker, Oracle DBA Received on Tue May 02 2000 - 00:00:00 CDT