RE: unable to run RDA on primary DB

From: D'Hooge Freek <>
Date: Thu, 9 Jun 2011 16:52:44 +0200
Message-ID: <>

I don't think Oracle stores information on the installing user on windows. Information about the Oracle Home and such is stored in the registry under local_system.

The only place in which the user depends is in the "local users and groups" where you have the ORA_DBA group. Normally this group is automatically created by Oracle during installation and the current user is stored in it. So, if there is only one user in this group, it is probably the user which did the installation. But again, I don't think this make a difference.


Freek D'Hooge
Oracle Database Administrator
tel +32(0)3 451 23 82

-----Original Message-----
From: [] On Behalf Of Manuela Atoui Sent: donderdag 9 juni 2011 16:37
To: Oracle-L Group
Subject: unable to run RDA on primary DB

Dear all,

I'm currently working on a undocumented EE primary/standby DB running in maximum data protection mode, OS is Windows 2000 (also undocumented, the purpose of the different OS users isn't clear). The application consists of several forms/reports running on Oracle 10g application server, also completely undocumented, the application developers are no longer available.
The IT Manager changed, and there's no in house DBA.

The alert log on primary/standby reports network errors, resulting in immediate primary DB shutdown due to the no data loss protection mode. Furthermore, the system runs batch jobs, which sometimes fail also (queries running approx. 1 hour).
And of course, this is a production DB with no Oracle support... Migration to 11g may be possible in the future, highest priority now is to fix the network and performance issues.

To get more information about the system, I tried to run RDA on the primary/standby DB.
I have no access to the system, I depend on the IT manager to do the login and open cmd shell. Now, every time so far, the OS user has no system variables (ORACLE_HOME, ORACLE_SID) set, and as Oracle is running as a service under windows I can't check the user-/group id from the ORACLE_HOME as on a UNIX system. As a result, RDA doesn't run (can't find associated DB, can't connect
- bequeath or via Oracle*Net).

My question is:
- what is the quickest way to find out which OS user actually did the
Oracle installation on the Windows 2000 server and hence has the correct environment set to run RDA?
- what is your opinion on using RDA to get the maximum info about the
system? Do you have any other ideas, tools you are using in that situation?
- I'm no expert in forms/reports running on Oracle app server, what is
your approach to get more information about the applications?

Any input is highly welcome, thank you very much and have a nice day

Manuela Atoui

Received on Thu Jun 09 2011 - 09:52:44 CDT

Original text of this message