-
-
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
-
Re: query oracle_home in sqlplus
"peterlin" <member35081@db forums.comwrote ...mind>
Hi,
>
I wonder wether I have the wrong concept of $ORACLE_HOME, in myoraclethe $ORACLE_HOME is a directory like 'D:\oracle\ora9 2' whereHi Peter,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
$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
Comment
-
Re: query oracle_home in sqlplus
Guido Konsolke wrote:
Global name can be set to whatever textstring you want with the command:"peterlin" <member35081@db forums.comwrote ...
>>>>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
>
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
>
>
alter database rename global_name to whateveryouwant ;
Michael Willer
Cybercom Group
Comment
-
Re: query oracle_home in sqlplus
"Michael Willer" wrote...command:Guido Konsolke wrote:
>Global name can be set to whatever textstring you want with the
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
Hi Michael,>
alter database rename global_name to whateveryouwant ;
>
>
Michael Willer
Cybercom Group
>
any chance that you refer to another posting
but mine? I didn't write 'global_name'.. .
Greetings,
Guido
Comment
-
Re: query oracle_home in sqlplus
Guido Konsolke wrote:
Hi Guido,"Michael Willer" wrote...
>>>>Guido Konsolke wrote:
>>
>>>>>>>
>>>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
>>>
>>>
>>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
>
>
>
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:
SQLhost echo $ORACLE_HOME , on UNIX/Linux
SQLhost echo %ORACLE_HOME% , on Window$
/Michael
Comment
Comment