RE: unable to run RDA on primary DB
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "manuelaout@xxxxxxxxxxxxxx" <manuelaout@xxxxxxxxxxxxxx>, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2011 16:52:44 +0200
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.
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 9.2.0.1 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
