OraFAQ Forum: Client Tools » Oracle Instance

Home » Other » Client Tools » Oracle Instance (Oracle 10g Windows)

Mon, 09 June 2008 22:40

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.

Mon, 09 June 2008 23:25

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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

Mon, 09 June 2008 23:39

sidd_411
Messages: 30
Registered: March 2008

Member

Michel !

I meant that only.

Tue, 10 June 2008 01:01

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

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]

Tue, 10 June 2008 01:31

sidd_411
Messages: 30
Registered: March 2008

Member

Thanks a lot Michel !

Wed, 11 June 2008 16:31

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 Nov 13 04:43:53 CST 2025