RE: Serious Weirdness: Open VMS and Oracle 7.3.3

From: Hallas, John <HallasJ_at_logicae.com>
Date: Thu, 14 Jun 2001 05:34:54 -0700
Message-ID: <F001.003293C9.20010614053531@fatcity.com>

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - lastnameinitial_at_logica.com eg SMITHK_at_logica.com. Emails using the old format will continue to be delivered until 30th June 2001.

Which user owns the process (I am assuming all processes here) show proc ORA_DSP_LGWR

14-JUN-2001 13:20:18.70   User: ORACLEV7         Process ID:   000B4A7E
                          Node: ESIS01           Process name:

"ORA_DSP_LGWR" Terminal:
User Identifier: [ORACLE,ORACLEV7]
Base priority: 4
Default file spec: Not available
Number of Kthreads: 1

If you look under authorize (if you have permissions, type mc authorize ) you will see that any user needs an identifier to start the database. On our systems the oraclev7 user has an identifier for a number of databases

Identifier                         Value           Attributes
  ORA_DBA                          %X80010003      
  ORA_LIVE_DBA                     %X8001002E      
  ORA_LOLP_DBA                     %X80010018      
  ORA_DRM_DBA                      %X8001000F      
  ORA_DBM_DBA                      %X8001000B      
  ORA_COP_DBA                      %X8001001E      
  ORA_DAR_DBA                      %X8001001A      
  ORA_RGD_DBA                      %X80010023      
  ORA_RSS_DBA                      %X80010025      
  ORA_DSP_DBA                      %X8001005D      
  ORA_PH4_DBA                      %X80010020      
  ORA_TSC98_DBA                    %X80010054

Check out if the user who owns the process currently has such an identifier and why.

HTH John

This e-mail and any files transmitted with it, are confidential to Logica and are intended solely for the use of the individual or entity to whom they are addressed.
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hallas, John
INET: HallasJ_at_logicae.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 14 2001 - 07:34:54 CDT