Hi Ashish,

If you are able to make a login in remote database, query v$instance and
note down the value of "host_name" column. Then go to unix login and see if
you can ping that system. If yes, then execute following command:

#uname <host_name>

and you will get the o/s name.

Regards,

Mohit Singla, Valu America Inc.,113 Technology Drive,Pittsburgh, PA, 15275
Tel: - 412-494-0400 Ext. 8107


-----Original Message-----
From: Agarwal Ashish
[mailto:oracledba-ezmlmshield-x54473428.[Email address protected]
Sent: Wednesday, August 04, 2004 1:03 AM
To: LazyDBA Discussion
Subject: How to know the o/s for a remote database

Hi,

Which Data dictionary view will tell me the o/s on which our remote databse
is running?

Or is there any other way to know this?

Thanks
Ashish
"DISCLAIMER: PLEASE NOTE "change in our mail id. It has changed from
@hpsglobal.com to @pstsi.com".The information in this message is
confidential and may be legally privileged. It is intended solely for the
addressee. Access to this message by anyone else is unauthorised.If you are
not the intended recipient, any disclosure, copying, or distribution of the
message, or any action or omission taken by you in reliance on it,is
prohibited and may be unlawful. Please immediately contact the sender if
you have received this message in error. Thank you."


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page