Re: listener process AND ORACLE_SID

Murali wrote:

> norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0202111630.3af61b1c_at_posting.google.com>...
> > This is very weird; I'd suggest a re-install.
> >
> > If you did not have an 'oracle' user created, how did you install it?
> > Did you install it under a different user and group or as root?
> >
> > I'd suggest a re-install.
>
> During installation, Oracle asks you for a sid and global name if you
> want to create that database using the Database Configuration
> Assistant. This assistant will be started after the install is
> complete. But you still need to explicitly set the ORACLE_SID in your
> UNIX environment to be able to connect to the new sid. You dont need
> to reinstall to correct this. ORACLE_SID is just an environment
> variable. Change it as you like. You havent specified where the old
> sid is showing. Check your $HOME/.profile file. You can also just do
> this at the command prompt to change the sid to newsid
>
> $ export ORACLE_SID=newsid
>
> at the command prompt to change to the new sid. Since you are running
> 8i, the instance automatically registers with the listener. That
> explains how you are able to connect from a remote client. Use the
> "lsnrctl status" command to check what databases the listener is
> actually listening to. Dont re-re-install.
>
> Murali

Hi, Murali,
Thank you so much! I will not reinstall. I believe the "lsnrctl status" will show the "newsid", because I saw the name of those oracle processes include "newsid". I just wonder why the listener can pick up the correct SID without confused by the Environment Variable. Now I understand. Y

>
> http://www.dbaquest.com/
Received on Tue Feb 12 2002 - 22:09:11 CST