Styjun

Why did Tony's Arc Reactor do this?

How to restrain your dragon?

Is future tense in English really a myth?

Examples where "thin + thin = nice and thick"

I need to know information from an old German birth certificate

When did computers stop checking memory on boot?

Why does 8 bit truecolor use only 2 bits for blue?

How do you say "to hell with everything" in French?

How do English-speaking kids loudly request something?

Bacteria vats to generate edible biomass, require intermediary species?

Did "Dirty Harry" feel lucky?

Is mountain bike good for long distances?

If every star in the universe except the Sun were destroyed, would we die?

Did the Byzantines ever attempt to move their capital to Rome?

Is there a "right" way to interpret a novel, if not, how do we make sure our novel is interpreted correctly?

Furthest distance half the diameter?

How strong is aircraft-grade spruce?

Why does PAUSE key have a long make code and no break code?

Features seen on the Space Shuttle's solid booster; what does "LOADED" mean exactly?

Do aarakocra have arms as well as wings?

I won a car in a poker game. How is that taxed in Canada?

Why don't the currents clash in a 3 phase delta connection?

Why is Sojdlg123aljg a common password?

What can we do about our 9-month-old putting fingers down his throat?

Oracle database installation directory using SQL

Create dump file using Oracle SQL DeveloperOracle 11g .DMP viewerOracle impdp - Importing file from remote serverUnable to apply patch in Oracle Grid HomeImporting Oracle12c databaseOracle data pump export / import errorsSequence number shows a lower value after dump file importconfigure sql developer for oracle using IPC fails with network adapter errorOracle-xe on Ubuntu 18.04 - Installation and impdpWhat do I need to develop an integration service to extract data from an Oracle DB to a SQL Server DB using Visual Studio 2015?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I have server that has had Oracle installed by someone else. I am able to connect to it using SQL developer and do all the operations, but I want to know the location where Oracle is installed.

I need this details to execute exp, imp, expdp, impdp, etc. commands using putty to perform import/export and data dumps.

Is there any way I can get the Oracle installation directory details using SQL command? Does Oracle store the installation path in a database?

oracle

share|improve this question

edited Mar 28 at 19:05

Tony Hinkle

3,95411 gold badge77 silver badges2727 bronze badges

asked Mar 28 at 6:50

DK AnshDK Ansh

10544 bronze badges

migrated from stackoverflow.com Mar 28 at 10:22

This question came from our site for professional and enthusiast programmers.

add a comment | 

0

I have server that has had Oracle installed by someone else. I am able to connect to it using SQL developer and do all the operations, but I want to know the location where Oracle is installed.

I need this details to execute exp, imp, expdp, impdp, etc. commands using putty to perform import/export and data dumps.

Is there any way I can get the Oracle installation directory details using SQL command? Does Oracle store the installation path in a database?

oracle

share|improve this question

edited Mar 28 at 19:05

Tony Hinkle

3,95411 gold badge77 silver badges2727 bronze badges

asked Mar 28 at 6:50

DK AnshDK Ansh

10544 bronze badges

migrated from stackoverflow.com Mar 28 at 10:22

This question came from our site for professional and enthusiast programmers.

add a comment | 

I have server that has had Oracle installed by someone else. I am able to connect to it using SQL developer and do all the operations, but I want to know the location where Oracle is installed.

I need this details to execute exp, imp, expdp, impdp, etc. commands using putty to perform import/export and data dumps.

Is there any way I can get the Oracle installation directory details using SQL command? Does Oracle store the installation path in a database?

oracle

share|improve this question

edited Mar 28 at 19:05

Tony Hinkle

3,95411 gold badge77 silver badges2727 bronze badges

asked Mar 28 at 6:50

DK AnshDK Ansh

10544 bronze badges

share|improve this question

edited Mar 28 at 19:05

Tony Hinkle

3,95411 gold badge77 silver badges2727 bronze badges

asked Mar 28 at 6:50

DK AnshDK Ansh

10544 bronze badges

share|improve this question

edited Mar 28 at 19:05

Tony Hinkle

3,95411 gold badge77 silver badges2727 bronze badges

asked Mar 28 at 6:50

DK AnshDK Ansh

10544 bronze badges

edited Mar 28 at 19:05

Tony Hinkle

3,95411 gold badge77 silver badges2727 bronze badges

edited Mar 28 at 19:05

Tony Hinkle

3,95411 gold badge77 silver badges2727 bronze badges

asked Mar 28 at 6:50

DK AnshDK Ansh

10544 bronze badges

asked Mar 28 at 6:50

DK AnshDK Ansh

10544 bronze badges

2 Answers
2

active

oldest

votes

1

I am sure there is a even smarter way, but if you use the default trace file directories, which is usually the case, you will in most cases find both ORACLE_BASE and ORACLE_HOME via

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

This gives you the absolute path to the trace files and they are inside ORACLE_BASE and ORACLE_HOME respectively.

HTH KR Peter

Edit: Have a look here for a more straight forward approach: https://dba.stackexchange.com/questions/97390/query-to-get-oracle-home-path-in-oracle-11g

share|improve this answer

answered Mar 28 at 10:01

PeterPeter

12622 bronze badges

add a comment | 

-1

On the database server (VM), use the provided oraenv script to set up your working environment. This reads the entries in /etc/oratab and sets not only the PATH environment variable, but also the Library Include Paths as well.

$ source oraenv 
ORACLE_SID = [grid] ? MYSID
The Oracle base remains unchanged with value /u01/app/oracle_homes/product/dbhome_1

Of course, for this to work, you have to have the Oracle binaries in your PATH already, so that the shell can find oraenv! To set this up by default, copy part of the entry from /etc/oratab into your .bash_profile:

[/etc/oratab]
MYSID:/u01/app/oracle_homes/product/dbhome_1:N

[~/.bash_profile]
export PATH=$PATH:/u01/app/oracle_homes/product/dbhome_1/bin

share|improve this answer

answered Mar 28 at 12:11

Phill W.Phill W.

1,48455 silver badges66 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes, the OP can do what he needs by using oraenv, but no he does not have to know where the binaries are to put them in the path. By default, the installation of oracle will put oraenv into /usr/local/bin, which is already in the PATH.
  
  – EdStevens
  Mar 28 at 21:36
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/4.0/"u003ecc by-sa 4.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f233358%2foracle-database-installation-directory-using-sql%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

I am sure there is a even smarter way, but if you use the default trace file directories, which is usually the case, you will in most cases find both ORACLE_BASE and ORACLE_HOME via

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

This gives you the absolute path to the trace files and they are inside ORACLE_BASE and ORACLE_HOME respectively.

HTH KR Peter

Edit: Have a look here for a more straight forward approach: https://dba.stackexchange.com/questions/97390/query-to-get-oracle-home-path-in-oracle-11g

share|improve this answer

answered Mar 28 at 10:01

PeterPeter

12622 bronze badges

add a comment | 

1

I am sure there is a even smarter way, but if you use the default trace file directories, which is usually the case, you will in most cases find both ORACLE_BASE and ORACLE_HOME via

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

This gives you the absolute path to the trace files and they are inside ORACLE_BASE and ORACLE_HOME respectively.

HTH KR Peter

Edit: Have a look here for a more straight forward approach: https://dba.stackexchange.com/questions/97390/query-to-get-oracle-home-path-in-oracle-11g

share|improve this answer

answered Mar 28 at 10:01

PeterPeter

12622 bronze badges

add a comment | 

I am sure there is a even smarter way, but if you use the default trace file directories, which is usually the case, you will in most cases find both ORACLE_BASE and ORACLE_HOME via

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

This gives you the absolute path to the trace files and they are inside ORACLE_BASE and ORACLE_HOME respectively.

HTH KR Peter

Edit: Have a look here for a more straight forward approach: https://dba.stackexchange.com/questions/97390/query-to-get-oracle-home-path-in-oracle-11g

share|improve this answer

answered Mar 28 at 10:01

PeterPeter

12622 bronze badges

SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';

share|improve this answer

answered Mar 28 at 10:01

PeterPeter

12622 bronze badges

answered Mar 28 at 10:01

PeterPeter

12622 bronze badges

answered Mar 28 at 10:01

PeterPeter

12622 bronze badges

-1

On the database server (VM), use the provided oraenv script to set up your working environment. This reads the entries in /etc/oratab and sets not only the PATH environment variable, but also the Library Include Paths as well.

$ source oraenv 
ORACLE_SID = [grid] ? MYSID
The Oracle base remains unchanged with value /u01/app/oracle_homes/product/dbhome_1

Of course, for this to work, you have to have the Oracle binaries in your PATH already, so that the shell can find oraenv! To set this up by default, copy part of the entry from /etc/oratab into your .bash_profile:

[/etc/oratab]
MYSID:/u01/app/oracle_homes/product/dbhome_1:N

[~/.bash_profile]
export PATH=$PATH:/u01/app/oracle_homes/product/dbhome_1/bin

share|improve this answer

answered Mar 28 at 12:11

Phill W.Phill W.

1,48455 silver badges66 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes, the OP can do what he needs by using oraenv, but no he does not have to know where the binaries are to put them in the path. By default, the installation of oracle will put oraenv into /usr/local/bin, which is already in the PATH.
  
  – EdStevens
  Mar 28 at 21:36
  
  

  
  
  
  

add a comment | 

-1

On the database server (VM), use the provided oraenv script to set up your working environment. This reads the entries in /etc/oratab and sets not only the PATH environment variable, but also the Library Include Paths as well.

$ source oraenv 
ORACLE_SID = [grid] ? MYSID
The Oracle base remains unchanged with value /u01/app/oracle_homes/product/dbhome_1

Of course, for this to work, you have to have the Oracle binaries in your PATH already, so that the shell can find oraenv! To set this up by default, copy part of the entry from /etc/oratab into your .bash_profile:

[/etc/oratab]
MYSID:/u01/app/oracle_homes/product/dbhome_1:N

[~/.bash_profile]
export PATH=$PATH:/u01/app/oracle_homes/product/dbhome_1/bin

share|improve this answer

answered Mar 28 at 12:11

Phill W.Phill W.

1,48455 silver badges66 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  yes, the OP can do what he needs by using oraenv, but no he does not have to know where the binaries are to put them in the path. By default, the installation of oracle will put oraenv into /usr/local/bin, which is already in the PATH.
  
  – EdStevens
  Mar 28 at 21:36
  
  

  
  
  
  

add a comment | 

On the database server (VM), use the provided oraenv script to set up your working environment. This reads the entries in /etc/oratab and sets not only the PATH environment variable, but also the Library Include Paths as well.

$ source oraenv 
ORACLE_SID = [grid] ? MYSID
The Oracle base remains unchanged with value /u01/app/oracle_homes/product/dbhome_1

Of course, for this to work, you have to have the Oracle binaries in your PATH already, so that the shell can find oraenv! To set this up by default, copy part of the entry from /etc/oratab into your .bash_profile:

[/etc/oratab]
MYSID:/u01/app/oracle_homes/product/dbhome_1:N

[~/.bash_profile]
export PATH=$PATH:/u01/app/oracle_homes/product/dbhome_1/bin

share|improve this answer

answered Mar 28 at 12:11

Phill W.Phill W.

1,48455 silver badges66 bronze badges

$ source oraenv 
ORACLE_SID = [grid] ? MYSID
The Oracle base remains unchanged with value /u01/app/oracle_homes/product/dbhome_1

[/etc/oratab]
MYSID:/u01/app/oracle_homes/product/dbhome_1:N

[~/.bash_profile]
export PATH=$PATH:/u01/app/oracle_homes/product/dbhome_1/bin

share|improve this answer

answered Mar 28 at 12:11

Phill W.Phill W.

1,48455 silver badges66 bronze badges

answered Mar 28 at 12:11

Phill W.Phill W.

1,48455 silver badges66 bronze badges

answered Mar 28 at 12:11

Phill W.Phill W.

1,48455 silver badges66 bronze badges