Finding Oracle_Home programatically(sp?) 
Author Message
 Finding Oracle_Home programatically(sp?)

In the NT world, is there a way to determine the Oracle_home for an Oracle server?
I know we could set an environment variable, but is there another way ( like somehow reading the registry key that contains
it) ? Is there an oracle view that maybe has this?
( various versions 8.0.5 thru 8.1.7 )

Thanks for any ideas...

-----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
http://www.***.com/ - The #1 Newsgroup Service in the World!
 Check out our new Unlimited Server. No Download or Time Limits!
-----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----



Sun, 14 Mar 2004 01:01:53 GMT
 Finding Oracle_Home programatically(sp?)

Quote:

> In the NT world, is there a way to determine the Oracle_home for an Oracle server?
> I know we could set an environment variable, but is there another way ( like somehow reading the registry key that contains
> it) ? Is there an oracle view that maybe has this?
> ( various versions 8.0.5 thru 8.1.7 )

> Thanks for any ideas...

> -----=  Posted via Newsfeeds.Com, Uncensored Usenet News  =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>  Check out our new Unlimited Server. No Download or Time Limits!
> -----==  Over 80,000 Newsgroups - 19 Different Servers!  ==-----

You could use the Perl Win32::Registry module or write a
C++/VB/C#/whatever program to look through the registry.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.


Sun, 14 Mar 2004 03:38:19 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. $ORACLE_HOME not found

2. FInd Oracle_Home using SQL

3. Finding the ODBC driver version programatically

4. Finding unique keys programatically

5. finding the 'default data directory' programatically

6. Finding the Primary Key Column name programatically?

7. Finding the ODBC driver version programatically

8. How to programatically find out what are the components of a primary index

9. Finding the ODBC driver version programatically

10. SP:ExecContextHit,SP:CacheMiss,SP:CacheInsert

11. Find First, Find Next, Find Previous, Find Last

12. SP to count # times a value is found in a field for a table


 
Powered by phpBB® Forum Software