RE: oracle sid
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "Chirag DBA" <chiragdba@xxxxxxxxx>
- Date: Wed, 7 Sep 2005 13:52:38 -0700
I don't know for sure but it seems likely due to the shell difference - I'm
using ksh and the "export VARIABLE=value" syntax works fine for me. Try
running ksh first and then see if it works for you.
-----Original Message-----
From: Chirag DBA [mailto:chiragdba@xxxxxxxxx]
Sent: Wednesday, September 07, 2005 1:49 PM
To: Allen, Brandon
Cc: Kurth, Michael J.; Oracle-L Freelists; askdba@xxxxxxxxxxxxx
Subject: Re: oracle sid
$ 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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Chirag DBA
Sent: Wednesday, September 07, 2005 1:40 PM
To: Kurth, Michael J.
Cc: Oracle-L Freelists; askdba@xxxxxxxxxxxxx
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@xxxxxxxxxxx <mailto:mkurth@xxxxxxxxxxx>
> 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@xxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Chirag DBA
Sent: Wednesday, September 07, 2005 3:23 PM
To: Oracle-L Freelists; askdba@xxxxxxxxxxxxx
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.
Other related posts:
