Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: oracle sid

Re: oracle sid

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Wed, 7 Sep 2005 16:48:49 -0400
Message-ID: <1a3629600509071348a0b311e@mail.gmail.com>


$ echo $SHELL
/bin/sh
 And this really worked Allen. But it should also work with simple export command.
 Why it is not working?
 Thank you...

 On 9/7/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Not sure what the problem is there, but see if this works:
> $ ORACLE_SID=admdevs4;export ORACLE_SID
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*On Behalf Of *Chirag DBA
> *Sent:* Wednesday, September 07, 2005 1:40 PM
> *To:* Kurth, Michael J.
> *Cc:* Oracle-L Freelists; askdba_at_freelists.org
> *Subject:* Re: oracle sid
>
> What m I missing?
> $ echo $ORACLE_SID
> admdev
> $ ps -ef|grep pmon
> oracle 10469 1 0 Sep 02 ? 0:00 ora_pmon_admdev
> oracle 10591 1 0 Sep 01 ? 0:00 ora_pmon_admdevs4 --> Another pmon process
> oracle 2690 27665 0 16:36:54 pts/11 0:00 grep pmon
> $ export ORACLE_SID=admdevs4
> ORACLE_SID=admdevs4: is not an identifier
> $ export ORACLE_SID admdevs4
> $ echo $ORACLE_SID
> admdev
>
> Is this Strange or Im missing something? I know there is a second case.
> but what..
> Regards - Chirag
> On 9/7/05, Kurth, Michael J. <mkurth_at_wfs-ops.org> wrote:
> >
> > export ORACLE_SID=xxx
> >
> > *Mike Kurth*
> > Senior Oracle DBA
> > Wheaton Franciscan Services, Inc.
> > 400 West River Woods Parkway
> > Glendale, Wisconsin 53212
> > 414/465-4046* Phone*
> > mkurth_at_wfs-ops.org
> >
> > -----Original Message-----
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] *On Behalf Of *Chirag DBA
> > *Sent:* Wednesday, September 07, 2005 3:23 PM
> > *To:* Oracle-L Freelists; askdba_at_freelists.org
> > *Subject:* oracle sid
> >
> > How will you change the ORACLE_SID in UNIX?
> > export ORACLE_SID temp2
> > echo $ORACLE_SID
> > temp
> > What I m missing?
> > Regards - Chirag
> >
> > Privileged/Confidential information may be contained in this message.
> > The information contained in this message is intended only for the use of
> > the recipient(s) named above and their co-workers who are working on the
> > same matter. The recipient of this information is prohibited from disclosing
> > the information to any other party unless this disclosure has been
> > authorized in advance.
> >
> > If you are not intended recipient of this message or any agent
> > responsible for delivery of the message to the intended recipient, you are
> > hereby notified that any disclosure, copying, distribution or action taken
> > in reliance on the contents of this message is strictly prohibited. You
> > should immediately destroy this message and kindly notify the sender by
> > reply E-Mail. Please advise immediately if you or your employer does not
> > consent to Internet E-Mail for messages of this kind. Opinions, conclusions
> > and other information in this message that do not relate to the official
> > business of the firm shall be understood as neither given nor endorsed by
> > it.
>
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.

>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 07 2005 - 15:50:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US