RE: oracle sid

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: