Thanks a lot! i realized that i was using bash shell, so i did these changes
in the .bashrc file...similar to .profile for k shell.
worked!!!!!
:)
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:957303336.25778.0.pluto.d4ee154e_at_news.demon.nl...
>
> 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
