recently i had an oppurtuinity to install oracle 8.1.6 on windows NT and was surprised to see the number of tools that oracle offers on Nt platform.what i would like 2 know is what is this thing called DBA studio what can i do with it.how is it different from oracle enterprise manager.
Is dba studio available on linux if yes how do i start it ??
p.s:i dont have a first hand experience with O.E.M
Sorry I don't have any information for Linux. You don't need to have DBA studio on linux to use dba studio against a Linux based oracle database. Configure your tnsnames.ora with a service_name to linux based Oracle Database and use that service_ name when you connect to DBAStudio on windows.
Its component of Enterpraise Management(OEM) tool. You can access any database on any platform configuring repository for OEM(If you want used all the components of OEM with Job scheduler). For DBAStudio kinda stuff you don't need repository.
As Reddy pointed out, use your OEMon your windows to manage the instances on Linix. If it was the case of dual boot, then you can use the custom installation of oracle and choose the dba studio under the OEM. FYI, I haven't tried this installation under linux as I don't want to mess up my 2.2 kernal libraries, and so far I haven't seen oracle to release its product for the 2.4 kernal. Hoping to see the 9i to come for the 2.4 kernal/redhat 7.1.
Try using the OEM and get familiar with that rather than using the dba studio, which is an optional component of OEM.