Solved: How do I get the $ORACLE

Discussion:

Solved: How do I get the $ORACLE_SID$ to display

John.A Simpson-contr

2005-02-04 17:25:56 UTC

Thanks Frederick!

I used your suggestion $PROCESS$ @@:echo $ORACLE_SID
on our Linux server on an Active Link, Windows Loaded Action, Set
fields, and it worked great!

To answer James... "..why you want this to be displayed on a form?"

I am doing this cause I often switch Oracle instances on a Remedy
Application Server so we can use different 'versions' for development,
testing Q/A, training, etc. (and it sure is nice to know which instance
I am using.... I name them AR5DEV, AR5TRN, AR5TST etc... (AR5PRD stays
active on the production server)

Thanks everyone! for your suggestions! - (Getting help from all these
smart people makes even a not so smart guy like me look good!)
If your server has the Oracle SID as an environment variable you can do
a simple set fields
from a $PROCESS$ command

Unix server
In a Filter set fields value: $PROCESS$ echo $ORACLE_SID
In an Active Link set fields value: $PROCESS$ @@:echo $ORACLE_SID

Windows server
In a Filter set fields value: $PROCESS$ cmd /c echo %ORACLE_SID%
In an Active Link set fields value: $PROCESS$ @@:cmd /c echo
%ORACLE_SID%

If it is not in the environment you could parse the ar.conf/ar.cfg file
instead of the echo

Unix: cat <path>ar.conf|grep Oracle-SID
Windows: type <path>ar.cfg|find Oracle-SID

________________________________

From: Action Request System discussion list(ARSList)
[mailto:***@ARSLIST.ORG] On Behalf Of John.A Simpson-contr
Sent: Thursday, February 03, 2005 2:32 PM
To: ***@ARSLIST.ORG
Subject: How do I get the $ORACLE_SID$ to display

**
Hi All,

Perhaps it is a simple thing....

I would like to be able to display the Oracle SID, (the Admin Tool,
Server Information, Database tab is able to display a value labeled
System ID:

Would someone be able to tell my how I might set a field with this value
for display purposes?

Thanks!

John A. Simpson
TRW Automotive
Information Systems Program Office
Brighton MI USA
john.a.simpson-***@trw.com
810-220-4767
______________________________This posting was submitted via the Web
interface

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:***@arslist.org)

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:***@arslist.org)

James Mckenzie

2005-02-04 18:07:06 UTC

Permalink

John:

Thanks. I was guessing that you had more than one instance. I'm going to try this 'trick' and see if it works on my Solaris server. This might be a good canidate for a short Tips and Tricks article. Also, I am glad that you did not have to use SQL code to get this information. The usage of this parameter in the DBA Handbook was quite lengthy and is in both the Oracle 8i and 9i versions was the same.

James McKenzie

-----Original Message-----
From: "John.A Simpson-contr" <John.A.Simpson-***@TRW.COM>
Sent: Feb 4, 2005 10:25 AM
To: ***@ARSLIST.ORG
Subject: [ARSLIST] Solved: How do I get the $ORACLE_SID$ to display

Thanks Frederick!

I used your suggestion $PROCESS$ @@:echo $ORACLE_SID
on our Linux server on an Active Link, Windows Loaded Action, Set
fields, and it worked great!

To answer James... "..why you want this to be displayed on a form?"

I am doing this cause I often switch Oracle instances on a Remedy
Application Server so we can use different 'versions' for development,
testing Q/A, training, etc. (and it sure is nice to know which instance
I am using.... I name them AR5DEV, AR5TRN, AR5TST etc... (AR5PRD stays
active on the production server)

Thanks everyone! for your suggestions! - (Getting help from all these
smart people makes even a not so smart guy like me look good!)
If your server has the Oracle SID as an environment variable you can do
a simple set fields
from a $PROCESS$ command

Unix server
In a Filter set fields value: $PROCESS$ echo $ORACLE_SID
In an Active Link set fields value: $PROCESS$ @@:echo $ORACLE_SID

Windows server
In a Filter set fields value: $PROCESS$ cmd /c echo %ORACLE_SID%
In an Active Link set fields value: $PROCESS$ @@:cmd /c echo
%ORACLE_SID%

If it is not in the environment you could parse the ar.conf/ar.cfg file
instead of the echo

Unix: cat <path>ar.conf|grep Oracle-SID
Windows: type <path>ar.cfg|find Oracle-SID

________________________________

From: Action Request System discussion list(ARSList)
[mailto:***@ARSLIST.ORG] On Behalf Of John.A Simpson-contr
Sent: Thursday, February 03, 2005 2:32 PM
To: ***@ARSLIST.ORG
Subject: How do I get the $ORACLE_SID$ to display

**
Hi All,

Perhaps it is a simple thing....

I would like to be able to display the Oracle SID, (the Admin Tool,
Server Information, Database tab is able to display a value labeled
System ID:

Would someone be able to tell my how I might set a field with this value
for display purposes?

Thanks!

John A. Simpson
TRW Automotive
Information Systems Program Office
Brighton MI USA
john.a.simpson-***@trw.com
810-220-4767
______________________________This posting was submitted via the Web
interface

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:***@arslist.org)

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:***@arslist.org)

James McKenzie
A Proud User of Linux!

James Mckenzie

2005-02-04 18:26:51 UTC

Permalink

John:

Are you setting the ORACLE_SID as an environment variable? I was not and could not pull it through the active link on Solaris.

James McKenzie

-----Original Message-----
From: "John.A Simpson-contr" <John.A.Simpson-***@TRW.COM>
Sent: Feb 4, 2005 10:25 AM
To: ***@ARSLIST.ORG
Subject: [ARSLIST] Solved: How do I get the $ORACLE_SID$ to display

Thanks Frederick!

I used your suggestion $PROCESS$ @@:echo $ORACLE_SID
on our Linux server on an Active Link, Windows Loaded Action, Set
fields, and it worked great!

To answer James... "..why you want this to be displayed on a form?"

I am doing this cause I often switch Oracle instances on a Remedy
Application Server so we can use different 'versions' for development,
testing Q/A, training, etc. (and it sure is nice to know which instance
I am using.... I name them AR5DEV, AR5TRN, AR5TST etc... (AR5PRD stays
active on the production server)

Thanks everyone! for your suggestions! - (Getting help from all these
smart people makes even a not so smart guy like me look good!)
If your server has the Oracle SID as an environment variable you can do
a simple set fields
from a $PROCESS$ command

Unix server
In a Filter set fields value: $PROCESS$ echo $ORACLE_SID
In an Active Link set fields value: $PROCESS$ @@:echo $ORACLE_SID

Windows server
In a Filter set fields value: $PROCESS$ cmd /c echo %ORACLE_SID%
In an Active Link set fields value: $PROCESS$ @@:cmd /c echo
%ORACLE_SID%

If it is not in the environment you could parse the ar.conf/ar.cfg file
instead of the echo

Unix: cat <path>ar.conf|grep Oracle-SID
Windows: type <path>ar.cfg|find Oracle-SID

________________________________

From: Action Request System discussion list(ARSList)
[mailto:***@ARSLIST.ORG] On Behalf Of John.A Simpson-contr
Sent: Thursday, February 03, 2005 2:32 PM
To: ***@ARSLIST.ORG
Subject: How do I get the $ORACLE_SID$ to display

**
Hi All,

Perhaps it is a simple thing....

I would like to be able to display the Oracle SID, (the Admin Tool,
Server Information, Database tab is able to display a value labeled
System ID:

Would someone be able to tell my how I might set a field with this value
for display purposes?

Thanks!

John A. Simpson
TRW Automotive
Information Systems Program Office
Brighton MI USA
john.a.simpson-***@trw.com
810-220-4767
______________________________This posting was submitted via the Web
interface

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:***@arslist.org)

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:***@arslist.org)

James McKenzie
A Proud User of Linux!

Tim Widowfield

2005-02-04 19:13:12 UTC

Permalink

James,

I was unsure about bringing it up, but as you can see, sometimes the
$ORACLE_SID environment variable could be wrong or not even defined. In
fact, on my trusty Solaris development box, the effective user that runs
the AR daemons doesn't have it set. (OK, it's running as root, so shoot
me, already!) I mean, that's why it's defined in ar.conf, right?

You can, as was already pointed out here before, extract the value from
the ar.conf file with some shell magic. Assuming the current working
directory of the Remedy processes would be [ar_inst_dir]/bin, then this
will work:

grep Oracle-SID ../conf/ar.conf | cut -c 13-50

On Windows, it's probably more like this:

type conf\ar.cfg | find "Oracle-SID"

Don't forget the double-quotes around the string.

You can also get the value from the database, but it's a little tricky.
In Oracle 9i (and I *think* in 8i, as well) you can use this query in
SQL*Plus:

SQL> select instance from v$thread;

INSTANCE
----------------
saucer

SQL>

But if you're logged in as aradmin you almost certainly will get this
result:

SQL> select instance_name from v$instance;
select instance_name from v$instance
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL>

Normally, ordinary database users don't have access to the v$ tables,
and that's probably a good thing. However, you can create a public view
of v$instance and grant aradmin select permissions on that view. Is
that a wise thing to do? I suppose it wouldn't hurt anything. But it
seems like a lot of trouble to go through.

--Tim Widowfield, UWIP

Post by James Mckenzie
Are you setting the ORACLE_SID as an environment variable? I was not and could not pull it through the active link on Solaris.
James McKenzie
-----Original Message-----
Sent: Feb 4, 2005 10:25 AM
Subject: [ARSLIST] Solved: How do I get the $ORACLE_SID$ to display
Thanks Frederick!
on our Linux server on an Active Link, Windows Loaded Action, Set
fields, and it worked great!
To answer James... "..why you want this to be displayed on a form?"
I am doing this cause I often switch Oracle instances on a Remedy
Application Server so we can use different 'versions' for development,
testing Q/A, training, etc. (and it sure is nice to know which instance
I am using.... I name them AR5DEV, AR5TRN, AR5TST etc... (AR5PRD stays
active on the production server)
Thanks everyone! for your suggestions! - (Getting help from all these
smart people makes even a not so smart guy like me look good!)
If your server has the Oracle SID as an environment variable you can do
a simple set fields
from a $PROCESS$ command
Unix server
In a Filter set fields value: $PROCESS$ echo $ORACLE_SID
Windows server
In a Filter set fields value: $PROCESS$ cmd /c echo %ORACLE_SID%
%ORACLE_SID%
If it is not in the environment you could parse the ar.conf/ar.cfg file
instead of the echo
Unix: cat <path>ar.conf|grep Oracle-SID
Windows: type <path>ar.cfg|find Oracle-SID
________________________________
From: Action Request System discussion list(ARSList)
Sent: Thursday, February 03, 2005 2:32 PM
Subject: How do I get the $ORACLE_SID$ to display
**
Hi All,
Perhaps it is a simple thing....
I would like to be able to display the Oracle SID, (the Admin Tool,
Server Information, Database tab is able to display a value labeled
Would someone be able to tell my how I might set a field with this value
for display purposes?
Thanks!
John A. Simpson
TRW Automotive
Information Systems Program Office
Brighton MI USA
810-220-4767
______________________________This posting was submitted via the Web
interface
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
James McKenzie
A Proud User of Linux!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

James Mckenzie

2005-02-04 19:39:01 UTC

Permalink

Tim:

This might not work with ARS 6.3. There was no Oracle-SID parameter in my ar.conf file.

James McKenzie

-----Original Message-----
From: Tim Widowfield <***@UWIP.COM>
Sent: Feb 4, 2005 11:13 AM
To: ***@ARSLIST.ORG
Subject: Re: [ARSLIST] Solved: How do I get the $ORACLE_SID$ to display

James,

I was unsure about bringing it up, but as you can see, sometimes the
$ORACLE_SID environment variable could be wrong or not even defined. In
fact, on my trusty Solaris development box, the effective user that runs
the AR daemons doesn't have it set. (OK, it's running as root, so shoot
me, already!) I mean, that's why it's defined in ar.conf, right?

You can, as was already pointed out here before, extract the value from
the ar.conf file with some shell magic. Assuming the current working
directory of the Remedy processes would be [ar_inst_dir]/bin, then this
will work:

grep Oracle-SID ../conf/ar.conf | cut -c 13-50

On Windows, it's probably more like this:

type conf\ar.cfg | find "Oracle-SID"

Don't forget the double-quotes around the string.

You can also get the value from the database, but it's a little tricky.
In Oracle 9i (and I *think* in 8i, as well) you can use this query in
SQL*Plus:

SQL> select instance from v$thread;

INSTANCE
----------------
saucer

SQL>

But if you're logged in as aradmin you almost certainly will get this
result:

SQL> select instance_name from v$instance;
select instance_name from v$instance
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL>

Normally, ordinary database users don't have access to the v$ tables,
and that's probably a good thing. However, you can create a public view
of v$instance and grant aradmin select permissions on that view. Is
that a wise thing to do? I suppose it wouldn't hurt anything. But it
seems like a lot of trouble to go through.

--Tim Widowfield, UWIP

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:***@arslist.org)

James McKenzie
A Proud User of Linux!

Tim Widowfield

2005-02-04 19:55:24 UTC

Permalink

Hmmmm... The 6.3 Configuration Guide says it's still a valid option.
Do you have an Oracle-Two-Task value set?

--Tim

Post by James Mckenzie
This might not work with ARS 6.3. There was no Oracle-SID parameter in my ar.conf file.
James McKenzie
-----Original Message----- From: Tim Widowfield
$ORACLE_SID$ to display
James,
I was unsure about bringing it up, but as you can see, sometimes the
$ORACLE_SID environment variable could be wrong or not even defined.
In fact, on my trusty Solaris development box, the effective user
that runs the AR daemons doesn't have it set. (OK, it's running as
root, so shoot me, already!) I mean, that's why it's defined in
ar.conf, right?
You can, as was already pointed out here before, extract the value
from the ar.conf file with some shell magic. Assuming the current
working directory of the Remedy processes would be [ar_inst_dir]/bin,
grep Oracle-SID ../conf/ar.conf | cut -c 13-50
type conf\ar.cfg | find "Oracle-SID"
Don't forget the double-quotes around the string.
You can also get the value from the database, but it's a little
tricky. In Oracle 9i (and I *think* in 8i, as well) you can use this
SQL> select instance from v$thread;
INSTANCE ---------------- saucer
SQL>
But if you're logged in as aradmin you almost certainly will get this
SQL> select instance_name from v$instance; select instance_name from
v$instance * ERROR at line 1: ORA-00942: table or view does not exist
SQL>
Normally, ordinary database users don't have access to the v$ tables,
and that's probably a good thing. However, you can create a public
view of v$instance and grant aradmin select permissions on that view.
Is that a wise thing to do? I suppose it wouldn't hurt anything.
But it seems like a lot of trouble to go through.
--Tim Widowfield, UWIP

Post by James Mckenzie
Are you setting the ORACLE_SID as an environment variable? I was
not and could not pull it through the active link on Solaris.
James McKenzie
-----Original Message----- From: "John.A Simpson-contr"
$ORACLE_SID$ to display
Thanks Frederick!
server on an Active Link, Windows Loaded Action, Set fields, and it
worked great!
To answer James... "..why you want this to be displayed on a form?"
I am doing this cause I often switch Oracle instances on a Remedy
Application Server so we can use different 'versions' for
development, testing Q/A, training, etc. (and it sure is nice to
know which instance I am using.... I name them AR5DEV, AR5TRN,
AR5TST etc... (AR5PRD stays active on the production server)
Thanks everyone! for your suggestions! - (Getting help from all
these smart people makes even a not so smart guy like me look
good!)
If your server has the Oracle SID as an environment variable you
can do a simple set fields from a $PROCESS$ command
Unix server In a Filter set fields value: $PROCESS$ echo
$ORACLE_SID
Windows server In a Filter set fields value: $PROCESS$ cmd /c echo
/c echo %ORACLE_SID%
If it is not in the environment you could parse the ar.conf/ar.cfg
file instead of the echo
Unix: cat <path>ar.conf|grep Oracle-SID Windows: type
<path>ar.cfg|find Oracle-SID
________________________________
From: Action Request System discussion list(ARSList)
Subject: How do I get the $ORACLE_SID$ to display
** Hi All,
Perhaps it is a simple thing....
I would like to be able to display the Oracle SID, (the Admin Tool,
Server Information, Database tab is able to display a value
Would someone be able to tell my how I might set a field with this
value for display purposes?
Thanks!
John A. Simpson TRW Automotive Information Systems Program Office
______________________________This posting was submitted via the
Web interface
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
James McKenzie A Proud User of Linux!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
James McKenzie A Proud User of Linux!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org

James Mckenzie

2005-02-04 21:06:07 UTC

Permalink

Tim:

Yes, and I changed your code to work with it:

$PROCESS$ @@:grep Oracle-Two-Task ../conf/ar.conf | cut 18-50

This will pull out the name.

James McKenzie

-----Original Message-----
From: Tim Widowfield <***@UWIP.COM>
Sent: Feb 4, 2005 12:55 PM
To: ***@ARSLIST.ORG
Subject: Re: [ARSLIST] Solved: How do I get the $ORACLE_SID$ to display

Hmmmm... The 6.3 Configuration Guide says it's still a valid option.
Do you have an Oracle-Two-Task value set?

--Tim

Post by James Mckenzie
This might not work with ARS 6.3. There was no Oracle-SID parameter
in my ar.conf file.
James McKenzie
-----Original Message----- From: Tim Widowfield
$ORACLE_SID$ to display
James,
I was unsure about bringing it up, but as you can see, sometimes the
$ORACLE_SID environment variable could be wrong or not even defined.
In fact, on my trusty Solaris development box, the effective user
that runs the AR daemons doesn't have it set. (OK, it's running as
root, so shoot me, already!) I mean, that's why it's defined in
ar.conf, right?
You can, as was already pointed out here before, extract the value
from the ar.conf file with some shell magic. Assuming the current
working directory of the Remedy processes would be [ar_inst_dir]/bin,
grep Oracle-SID ../conf/ar.conf | cut -c 13-50
type conf\ar.cfg | find "Oracle-SID"
Don't forget the double-quotes around the string.
You can also get the value from the database, but it's a little
tricky. In Oracle 9i (and I *think* in 8i, as well) you can use this
SQL> select instance from v$thread;
INSTANCE ---------------- saucer
SQL>
But if you're logged in as aradmin you almost certainly will get this
SQL> select instance_name from v$instance; select instance_name from
v$instance * ERROR at line 1: ORA-00942: table or view does not exist
SQL>
Normally, ordinary database users don't have access to the v$ tables,
and that's probably a good thing. However, you can create a public
view of v$instance and grant aradmin select permissions on that view.
Is that a wise thing to do? I suppose it wouldn't hurt anything.
But it seems like a lot of trouble to go through.
--Tim Widowfield, UWIP

Post by James Mckenzie
Are you setting the ORACLE_SID as an environment variable? I was
not and could not pull it through the active link on Solaris.
James McKenzie
-----Original Message----- From: "John.A Simpson-contr"
$ORACLE_SID$ to display
Thanks Frederick!
server on an Active Link, Windows Loaded Action, Set fields, and it
worked great!
To answer James... "..why you want this to be displayed on a form?"
I am doing this cause I often switch Oracle instances on a Remedy
Application Server so we can use different 'versions' for
development, testing Q/A, training, etc. (and it sure is nice to
know which instance I am using.... I name them AR5DEV, AR5TRN,
AR5TST etc... (AR5PRD stays active on the production server)
Thanks everyone! for your suggestions! - (Getting help from all
these smart people makes even a not so smart guy like me look
good!)
If your server has the Oracle SID as an environment variable you
can do a simple set fields from a $PROCESS$ command
Unix server In a Filter set fields value: $PROCESS$ echo
$ORACLE_SID
Windows server In a Filter set fields value: $PROCESS$ cmd /c echo
/c echo %ORACLE_SID%
If it is not in the environment you could parse the ar.conf/ar.cfg
file instead of the echo
Unix: cat <path>ar.conf|grep Oracle-SID Windows: type
<path>ar.cfg|find Oracle-SID
________________________________
From: Action Request System discussion list(ARSList)
Subject: How do I get the $ORACLE_SID$ to display
** Hi All,
Perhaps it is a simple thing....
I would like to be able to display the Oracle SID, (the Admin Tool,
Server Information, Database tab is able to display a value
Would someone be able to tell my how I might set a field with this
value for display purposes?
Thanks!
John A. Simpson TRW Automotive Information Systems Program Office
______________________________This posting was submitted via the
Web interface
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
James McKenzie A Proud User of Linux!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org