RE: How can I query the SID name from the database
Thanks for all who replied. Probably I will have to solve this some other way, since the customer has several instances on the same box, but the instance name has no correlation to the SID name: they don't accept the default. Regards, Tamas Szecsy -Original Message- Sent: Tuesday, May 29, 2001 7:46 AM To: Multiple recipients of list ORACLE-L U can get the instance name from V$instance and v$database. If u have set the instance name and sid as same in init.ora, then instance name is the SID. BTW SID=system identifier for the OS to identify the Oracle to allocate resource. U can have multiple instance running in same OS. HTH -- On Mon, 28 May 2001 10:20:25 Jared Still wrote: > >machine_name is found in v$session. > >You can't query the server for the SID, as it is >simply an environment variable. > >Jared > > >On Monday 28 May 2001 10:10, Szecsy Tamas wrote: >> Hi, >> >> can I query a database's server's maschine name and SID (not database >> name) through SQL*Plus? >> >> TIA, >> >> Tamas Szecsy >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How can I query the SID name from the database
U can get the instance name from V$instance and v$database. If u have set the instance name and sid as same in init.ora, then instance name is the SID. BTW SID=system identifier for the OS to identify the Oracle to allocate resource. U can have multiple instance running in same OS. HTH -- On Mon, 28 May 2001 10:20:25 Jared Still wrote: > >machine_name is found in v$session. > >You can't query the server for the SID, as it is >simply an environment variable. > >Jared > > >On Monday 28 May 2001 10:10, Szecsy Tamas wrote: >> Hi, >> >> can I query a database's server's maschine name and SID (not database >> name) through SQL*Plus? >> >> TIA, >> >> Tamas Szecsy >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jared Still > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How can I query the SID name from the database
This is correct - $ORACLE_SID is a host environmental variable and cannot be obtained from the data dictionary. However, you can get the instance name from v$instance.instance_name in 8.x or from v$thread.instance in v7. -Don Granaman [certifiable OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, May 28, 2001 1:20 PM > > machine_name is found in v$session. > > You can't query the server for the SID, as it is > simply an environment variable. > > Jared > > > On Monday 28 May 2001 10:10, Szecsy Tamas wrote: > > Hi, > > > > can I query a database's server's maschine name and SID (not database > > name) through SQL*Plus? > > > > TIA, > > > > Tamas Szecsy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How can I query the SID name from the database
Concerning the SID, which I tend to find synonymous with instance name
(trying hard to figure out a way to have an instance name different from
the SID, but cannot come out with anything), 8i contains a column NAME
in V$INSTANCE (which has nothing in common but the name with the Oracle7
V$INSTANCE). With Oracle 7, you can't get it, for the reason that Jared
says - OS stuff, not Oracle stuff. The closer you can get to it is
SELECT VALUE FROM V$PARAMETER WHERE NAME = 'db_name' assuming, somewhat
optimistically, that people usually give the same name to their database
as to the instance when there is no parallel server running (this is
what I usually do but I have very recently met databases which were
created with different conventions). I have noticed, though, with 7.3 a
V$ACTIVE_INSTANCE view with a NAME column which only seems to contain
something when the parallel server is running (was not my case). That
said, you need to relate a name to an instance # and I have not the
slightest clue about how to get your instance # in this case since
userenv('INSTANCE') only works with Oracle8.
Jared Still wrote:
>
> machine_name is found in v$session.
>
> You can't query the server for the SID, as it is
> simply an environment variable.
>
> Jared
>
> On Monday 28 May 2001 10:10, Szecsy Tamas wrote:
> > Hi,
> >
> > can I query a database's server's maschine name and SID (not database
> > name) through SQL*Plus?
> >
> > TIA,
> >
> > Tamas Szecsy
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Regards,
Stephane Faroult
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax:+44 (0) 7050-696-449
Performance Tools & Free Scripts
--
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: How can I query the SID name from the database
THNX Tamas -Original Message- Sent: Monday, May 28, 2001 8:20 PM To: Multiple recipients of list ORACLE-L machine_name is found in v$session. You can't query the server for the SID, as it is simply an environment variable. Jared On Monday 28 May 2001 10:10, Szecsy Tamas wrote: > Hi, > > can I query a database's server's maschine name and SID (not database > name) through SQL*Plus? > > TIA, > > Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How can I query the SID name from the database
machine_name is found in v$session. You can't query the server for the SID, as it is simply an environment variable. Jared On Monday 28 May 2001 10:10, Szecsy Tamas wrote: > Hi, > > can I query a database's server's maschine name and SID (not database > name) through SQL*Plus? > > TIA, > > Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
