Oracle Lab - Find the ORACLE_HOME for a running instance in UNIX

Welcome

Home

Forums

OCTC

Documents

News

Tips

Articles

Source Codes

Themes

SUPINFO Labs

IBM Lab

Sun Lab

About Us

Contacts

Find the ORACLE_HOME for a running instance in UNIX

Description

Votes: 34

Comments: 0

Visits: 2427

Administration 23-MAY-2006 02:15 PM, Arnaud Bontemps

Find the ORACLE_HOME for a running instance in UNIX When you have several ORACLE_HOME, here is a way to find which is the ORACLE_HOME for a particular instance:

1) Get the pid of a background process:

ps -edf | grep [o]ra_smon_ORAPRD01
oracle 307694 1 0 Jan 24 - 1:43
ora_smon_ORAPRD01

2) Get its current working directory from /proc:

ls -l /proc/307694/cwd
lr-x------ 2 oracle dba 0 Feb 28 16:00
/proc/307694/cwd ->
/app/oracle/product/9.2.0/dbs/

Here ORACLE_HOME is /app/oracle/product/9.2.0

Comments

Articles

Oracle Installation on SUSE Linux Enterprise Server

Administration 14-JUN-2008 07:03 PM, Fabien Loudet

We will follow step-by-step the installation of Oracle Database 10g on SUSE Linux Enterprise Server. We choose here to install Oracle Enterprise Edition and create a database.

	show_item show_previous_next show_item_comments
SUSE Linux Enterprise Server for Oracle Servers Administration 14-JUN-2008 06:29 PM, Fabien Loudet	show_item show_previous_next show_item_comments
Oracle Application Server Portal 10g Installation Portal 05-NOV-2007 11:50 PM, Maxime Gontcharov	show_item show_previous_next show_item_comments

	show_item show_previous_next show_item_comments
	show_item show_previous_next show_item_comments
	show_item show_previous_next show_item_comments
Oracle Content Services 10g - Semantic API General 04-NOV-2007 10:14 PM, Frederic Humbert-Droz	show_item show_previous_next show_item_comments
1Z0-007 On Line Certifications 23-SEP-2007 10:46 PM, Jerome Alef	show_item show_previous_next show_item_comments

Tips

Windows PowerShell : Connecting to an Oracle Database Administration 16-SEP-2008 04:50 PM, Fabien Loudet	show_item show_previous_next show_item_comments
Kill Oracle session Administration 10-SEP-2008 07:27 PM, Julien Ragueneau	show_item show_previous_next show_item_comments
Installing Oracle on a Unix server without any GUI Administration 10-SEP-2008 07:05 PM, Jérémie Hodnik	show_item show_previous_next show_item_comments
Distributed requests SQL 10-SEP-2008 10:47 AM, Thibaut Maxant	show_item show_previous_next show_item_comments
Use of "readonly" on a table SQL 10-SEP-2008 10:36 AM, Rémi Olivier	show_item show_previous_next show_item_comments

More Tips

Source Codes

Add Multi-language support Portal 25-NOV-2004 10:30 AM, Pierre-Henry Tupin	show_item show_previous_next show_item_comments
Instant Messenger Communication 24-NOV-2004 10:31 AM, Arnaud Bontemps	show_item show_previous_next show_item_comments
Who is online Portal 24-NOV-2004 10:26 AM, Arnaud Bontemps	show_item show_previous_next show_item_comments
Change the Portal CSS Portal 15-JUN-2004 04:15 PM, Arnaud Bontemps, Yoan Sultan	show_item show_previous_next show_item_comments

More Source Codes

News

Oracle VM Templates 02-SEP-2008 12:15 PM, Jérémie Hodnik Further enabling customers to benefit from server consolidation, energy and space cost savings by using enterprise-class server virtualization, Oracle today announced Oracle® VM Templates.	show_item show_previous_next show_item_comments
Oracle Unbreakable Linux 02-SEP-2008 12:08 PM, Thibaut Maxant Oracle's Linux commitment began in 1998 with the first commercial database on Linux.	show_item show_previous_next show_item_comments
Oracle's Industry Strategy 01-SEP-2008 12:01 PM, Thibaut Maxant	show_item show_previous_next show_item_comments
Oracle is the #1 in Relational Database 20-AUG-2008 07:26 PM, Thibaut Maxant Gartner 2007 Worldwide RDBMS Market Share Reports 48.6% Share for Oracle.	show_item show_previous_next show_item_comments
Oracle Buys Skywire Software 02-AUG-2008 11:18 AM, Zhen Dong June 23, 2008, Oracle announced that it has reached an agreement with Skywire Software and buys of its business application software.	show_item show_previous_next show_item_comments

More News