query oracle_home in sqlplus

[peterlin]

hi,

How can I query the $ORACLE_HOME in sqlplus ?

Thanks!

peter
--
Posted via http://dbforums.com

[peterlin]

Hi,

I wonder wether I have the wrong concept of $ORACLE_HOME, in my mind
the $ORACLE_HOME is a directory like 'D:\oracle\ora92' where oracle
is installed.

However select global_name from global_name returned
'computername.domain'.

Does I have a wrong concept ?

Thanks!

Peter
--
Posted via http://dbforums.com

[Guido Konsolke]

"peterlin" <me*********@dbforums.com> wrote...

Hi,

I wonder wether I have the wrong concept of $ORACLE_HOME, in my mind the $ORACLE_HOME is a directory like 'D:\oracle\ora92' where oracle is installed.

However select global_name from global_name returned
'computername.domain'.

Does I have a wrong concept ?

Thanks!

Peter

--
Posted via http://dbforums.com

Hi Peter,

$ORACLE_HOME is a parameter that contains the home directory
of an oracle installation. Could you please explain:
- what are you trying to do and why
- are you on client or server side
- what is your oracle version
- what is your OS?

UTL_FILE package *could* be what you're looking for.

Greetings,
Guido

[Michael Willer]

Guido Konsolke wrote:

"peterlin" <me*********@dbforums.com> wrote...

Hi,

I wonder wether I have the wrong concept of $ORACLE_HOME, in my

mind

the $ORACLE_HOME is a directory like 'D:\oracle\ora92' where

oracle

is installed.

However select global_name from global_name returned
'computername.domain'.

Does I have a wrong concept ?

Thanks!

Peter

--
Posted via http://dbforums.com

Hi Peter,

$ORACLE_HOME is a parameter that contains the home directory
of an oracle installation. Could you please explain:
- what are you trying to do and why
- are you on client or server side
- what is your oracle version
- what is your OS?

UTL_FILE package *could* be what you're looking for.

Greetings,
Guido

Global name can be set to whatever textstring you want with the command:

alter database rename global_name to whateveryouwant;
Michael Willer
Cybercom Group

[Guido Konsolke]

"Michael Willer" wrote...

Guido Konsolke wrote:

Hi Peter,

$ORACLE_HOME is a parameter that contains the home directory
of an oracle installation. Could you please explain:
- what are you trying to do and why
- are you on client or server side
- what is your oracle version
- what is your OS?

UTL_FILE package *could* be what you're looking for.

Greetings,
Guido

Global name can be set to whatever textstring you want with the

command:
alter database rename global_name to whateveryouwant;
Michael Willer
Cybercom Group

Hi Michael,

any chance that you refer to another posting
but mine? I didn't write 'global_name'...

Greetings,
Guido

[Michael Willer]

Guido Konsolke wrote:

"Michael Willer" wrote...

Guido Konsolke wrote:

Hi Peter,

$ORACLE_HOME is a parameter that contains the home directory
of an oracle installation. Could you please explain:
- what are you trying to do and why
- are you on client or server side
- what is your oracle version
- what is your OS?

UTL_FILE package *could* be what you're looking for.

Greetings,
Guido

Global name can be set to whatever textstring you want with the

command:

alter database rename global_name to whateveryouwant;
Michael Willer
Cybercom Group

Hi Michael,

any chance that you refer to another posting
but mine? I didn't write 'global_name'...

Greetings,
Guido

Hi Guido,
Sorry, I read it as a question on global name. I jumped into the discussion.

Anyway, $ORACLE_HOME can, to my knowledge, not be queried from the
database. The main question here why would someone want to. It is
possible however to display it using:

SQL> host echo $ORACLE_HOME , on UNIX/Linux

SQL> host echo %ORACLE_HOME% , on Window$
/Michael