From oracle-l-bounce@freelists.org Wed Sep 7 15:53:52 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j87KrpDC002150 for ; Wed, 7 Sep 2005 15:53:51 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j87KrPIP002072 for ; Wed, 7 Sep 2005 15:53:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BD3391EB0F0; Wed, 7 Sep 2005 15:52:56 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03242-01; Wed, 7 Sep 2005 15:52:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0E1CA1EB0EB; Wed, 7 Sep 2005 15:52:56 -0500 (EST) Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.326 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5B3EE.1511B47F" Subject: RE: oracle sid Date: Wed, 7 Sep 2005 13:52:38 -0700 Message-ID: <04DDF147ED3A0D42B48A48A18D574C4502361559@NT15.oneneck.corp> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: oracle sid thread-index: AcWz7cZvxqWmduKeSve6I/9qLuNtQwAAA/hA From: "Allen, Brandon" To: "Chirag DBA" Cc: "Oracle-L Freelists" , X-archive-position: 25126 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Brandon.Allen@OneNeck.com Precedence: normal Reply-To: Brandon.Allen@OneNeck.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-4.7 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE autolearn=no version=2.63 ------_=_NextPart_001_01C5B3EE.1511B47F Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I don't know for sure but it seems likely due to the shell difference - = I'm using ksh and the "export VARIABLE=3Dvalue" syntax works fine for = me. Try running ksh first and then see if it works for you. =20 =20 -----Original Message----- From: Chirag DBA [mailto:chiragdba@gmail.com] Sent: Wednesday, September 07, 2005 1:49 PM To: Allen, Brandon Cc: Kurth, Michael J.; Oracle-L Freelists; askdba@freelists.org Subject: Re: oracle sid $ echo $SHELL /bin/sh =20 And this really worked Allen. But it should also work with simple export = command. =20 Why it is not working? =20 Thank you...=20 =20 On 9/7/05, Allen, Brandon < Brandon.Allen@oneneck.com> wrote:=20 Not sure what the problem is there, but see if this works: =20 $ ORACLE_SID=3Dadmdevs4;export ORACLE_SID =20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto: = oracle-l-bounce@freelists.org]On Behalf Of Chirag DBA=20 Sent: Wednesday, September 07, 2005 1:40 PM To: Kurth, Michael J. Cc: Oracle-L Freelists; askdba@freelists.org Subject: Re: oracle sid What m I missing? =20 $ 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=20 oracle 2690 27665 0 16:36:54 pts/11 0:00 grep pmon $ export ORACLE_SID=3Dadmdevs4 ORACLE_SID=3Dadmdevs4: 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..=20 =20 Regards - Chirag =20 =20 On 9/7/05, Kurth, Michael J. < mkurth@wfs-ops.org = > wrote:=20 export ORACLE_SID=3Dxxx =20 =20 Mike Kurth=20 Senior Oracle DBA Wheaton Franciscan Services, Inc. 400 West River Woods Parkway Glendale, Wisconsin 53212 414/465-4046 Phone=20 mkurth@wfs-ops.org=20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto: = oracle-l-bounce@freelists.org] On Behalf Of Chirag DBA=20 Sent: Wednesday, September 07, 2005 3:23 PM To: Oracle-L Freelists; askdba@freelists.org=20 Subject: oracle sid How will you change the ORACLE_SID in UNIX? =20 export ORACLE_SID temp2 =20 echo $ORACLE_SID=20 temp =20 What I m missing? =20 Regards - Chirag =20 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.=20 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.=20 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.=20 ------_=_NextPart_001_01C5B3EE.1511B47F Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I=20 don't know for sure but it seems likely due to the shell difference = - I'm=20 using ksh and the "export VARIABLE=3Dvalue" syntax works fine for = me.  Try=20 running ksh first and then see if it works for you.
 
 
-----Original Message-----
From: Chirag DBA=20 [mailto:chiragdba@gmail.com]
Sent: Wednesday, September 07, = 2005=20 1:49 PM
To: Allen, Brandon
Cc: Kurth, Michael J.; = Oracle-L=20 Freelists; askdba@freelists.org
Subject: Re: oracle=20 sid

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

 
On 9/7/05, Allen,=20 Brandon <Brandon.Allen@oneneck.com&g= t;=20 wrote:=20
Not sure what = the problem=20 is there, but see if this works:
 
$=20 ORACLE_SID=3Dadmdevs4;export ORACLE_SID
 
-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of = Chirag=20 DBA
Sent: Wednesday, September = 07, 2005=20 1:40 PM
To: Kurth, Michael J.
Cc: Oracle-L = Freelists;=20 askdba@freelists.org
Subject: Re: = oracle=20 sid

What m I missing?
 
$ echo $ORACLE_SID
admdev
$ ps -ef|grep = pmon
  oracle 10469     1  = 0  =20 Sep 02 ?        0:00=20 ora_pmon_admdev
  oracle 10591     = 1 =20 0   Sep 01 ?        = 0:00=20 ora_pmon_admdevs4 --> Another pmon process
  = oracle  2690=20 27665  0 16:36:54 pts/11   0:00 grep = pmon
$ export ORACLE_SID=3Dadmdevs4
ORACLE_SID=3Dadmdevs4: = is not an=20 identifier
$ export ORACLE_SID admdevs4
$ echo=20 $ORACLE_SID
admdev

Is = this Strange=20 or Im missing something? I know there is a second case. but what.. =
 
Regards - Chirag
 
 
On 9/7/05, Kurth,=20 Michael J. <mkurth@wfs-ops.org >=20 wrote:=20
export=20 ORACLE_SID=3Dxxx
 
 

Mike = Kurth
Senior Oracle DBA
Wheaton Franciscan Services, = Inc.
400 West River Woods = Parkway
Glendale, Wisconsin 53212
414/465-4046 Phone
mkurth@wfs-ops.org


-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On = Behalf Of=20 Chirag DBA
Sent: Wednesday, September 07, 2005 = 3:23=20 PM
To: Oracle-L Freelists; askdba@freelists.org =
Subject:=20 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=20 may be contained in this message. The information contained in = this=20 message is intended only for the use of the recipient(s) named = above and=20 their co-workers who are working on the same matter. The = recipient of=20 this information is prohibited from disclosing the information = to any=20 other party unless this disclosure has been authorized in = advance.=20

If you are not intended recipient of this message or any = agent=20 responsible for delivery of the message to the intended = recipient, you=20 are hereby notified that any disclosure, copying, distribution = or action=20 taken in reliance on the contents of this message is strictly=20 prohibited. You should immediately destroy this message and = kindly=20 notify the sender by reply E-Mail. Please advise immediately if = you or=20 your employer does not consent to Internet E-Mail for messages = of this=20 kind. Opinions, conclusions and other information in this = message that=20 do not relate to the official business of the firm shall be = understood=20 as neither given nor endorsed by it.=20

Privileged/Confidential Information may be contained in this = message or=20 attachments hereto. Please advise immediately if you or your = employer do not=20 consent to Internet email for messages of this kind. Opinions, = conclusions=20 and other information in this message that do not relate to the = official=20 business of this company shall be understood as neither given nor = endorsed=20 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.

------_=_NextPart_001_01C5B3EE.1511B47F-- -- http://www.freelists.org/webpage/oracle-l