query oracle_home in sqlplus

[peterlin]

hi,



How can I query the $ORACLE_HOME in sqlplus ?





Thanks!



peter


--
Posted via http://dbforums.com

[peterlin]

Re: query oracle_home in sqlplus


Hi,



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



However select global_name from global_name returned
'computername.d omain'.



Does I have a wrong concept ?



Thanks!



Peter


--
Posted via http://dbforums.com

[Guido Konsolke]

Re: query oracle_home in sqlplus

"peterlin" <member35081@db forums.com> wrote...[color=blue]
>
> Hi,
>
> I wonder wether I have the wrong concept of $ORACLE_HOME, in my[/color]
mind[color=blue]
> the $ORACLE_HOME is a directory like 'D:\oracle\ora9 2' where[/color]
oracle[color=blue]
> is installed.
>
> However select global_name from global_name returned
> 'computername.d omain'.
>
> Does I have a wrong concept ?
>
> Thanks!
>
> Peter
>
> --
> Posted via http://dbforums.com[/color]

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]

Re: query oracle_home in sqlplus

Guido Konsolke wrote:
[color=blue]
> "peterlin" <member35081@db forums.com> wrote...
>[color=green]
>>Hi,
>>
>> I wonder wether I have the wrong concept of $ORACLE_HOME, in my[/color]
>
> mind
>[color=green]
>> the $ORACLE_HOME is a directory like 'D:\oracle\ora9 2' where[/color]
>
> oracle
>[color=green]
>> is installed.
>>
>> However select global_name from global_name returned
>> 'computername.d omain'.
>>
>> Does I have a wrong concept ?
>>
>>Thanks!
>>
>>Peter
>>
>>--
>>Posted via http://dbforums.com[/color]
>
>
> 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
>
>[/color]
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]

Re: query oracle_home in sqlplus

"Michael Willer" wrote...[color=blue]
> Guido Konsolke wrote:
>[color=green]
> >
> >
> > 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
> >
> >[/color]
> Global name can be set to whatever textstring you want with the[/color]
command:[color=blue]
>
> alter database rename global_name to whateveryouwant ;
>
>
> Michael Willer
> Cybercom Group
>[/color]

Hi Michael,

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

Greetings,
Guido

[Michael Willer]

Re: query oracle_home in sqlplus

Guido Konsolke wrote:
[color=blue]
> "Michael Willer" wrote...
>[color=green]
>>Guido Konsolke wrote:
>>
>>[color=darkred]
>>>
>>>Hi Peter,
>>>
>>>$ORACLE_HO ME 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
>>>
>>>[/color]
>>
>>Global name can be set to whatever textstring you want with the[/color]
>
> command:
>[color=green]
>>alter database rename global_name to whateveryouwant ;
>>
>>
>>Michael Willer
>>Cybercom Group
>>[/color]
>
>
> Hi Michael,
>
> any chance that you refer to another posting
> but mine? I didn't write 'global_name'.. .
>
> Greetings,
> Guido
>
>
>[/color]

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