Home » Other » Client Tools » Oracle Instance (Oracle 10g Windows)
Oracle Instance [message #326008] Mon, 09 June 2008 22:40 Go to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Hi all,

how to find which oracle instance is running through a script (batch file, perl script) in Windows OS.
Re: Oracle Instance [message #326021 is a reply to message #326008] Mon, 09 June 2008 23:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
An Oracle instance is not running through a script.
Precise your question.
Do you want to know to which instance you are connected?

Regards
Michel
Re: Oracle Instance [message #326031 is a reply to message #326021] Mon, 09 June 2008 23:39 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Michel !

I meant that only.
Re: Oracle Instance [message #326045 is a reply to message #326031] Tue, 10 June 2008 01:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select * from global_name;
GLOBAL_NAME
---------------------------------
MIKA.XXXX

1 row selected.

Regards
Michel

[Updated on: Tue, 10 June 2008 01:01]

Report message to a moderator

Re: Oracle Instance [message #326057 is a reply to message #326045] Tue, 10 June 2008 01:31 Go to previous messageGo to next message
sidd_411
Messages: 30
Registered: March 2008
Member
Thanks a lot Michel !
Re: Oracle Instance [message #326508 is a reply to message #326057] Wed, 11 June 2008 16:31 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Are you requesting instance_name or database_name ?
Previous Topic: Code Hints: tab key, instead of enter key
Next Topic: Viewing stored proc code
Goto Forum:
  


Current Time: Thu Mar 28 04:11:07 CDT 2024