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).
How can I query the SID name from the database
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: 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).
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
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
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
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).
