Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> VMS BACKUP user can't see the database ORA-01034

VMS BACKUP user can't see the database ORA-01034

From: David A. Owens <daveo_at_criticaldata.com>
Date: 1998/04/01
Message-ID: <35228437.1A49@criticaldata.com>#1/1

This is a VMS 7.1 Oracle 7.3.2.3.2 question.

My oracle DBA user on this Alpha box is ORACLE732. I can manipulate the DB just fine with svrmgrl logged in as ORACLE732.

I want to give the BACKUP user ability to shutdown/startup the DB for cold backup. So I have granted the BACKUP user ORA_DBA. He can connect to svrmgrl but doesn't see the database. I currently have a TAR opened with Orasupport but have not gotten any response. Note that "RTHIRE" is the one and only SID on this BOX and is currently running.

Thanks for any clues,
- Dave

Here is a test batch command file that is run as BACKUP:

$ SET UIC [ORACLE732]
$ SET RIGHTS_LIST/ENABLE ORA_DBA

$

$ @DB_DSK1:[ORACLE732.db_RTHIRE]orauser_RTHIRE 'P1' 'P2'
$ @ora_rdbms:rdbmsuser.com
$
$ show proc/priv
$ show log ora_sid
$
$ svrmgrl

connect internal
select * from v$database;
show sga
exit
$ exit

And here is what occurs - the log file from the above submission:

$ SET NOVERIFY

 1-APR-1998 12:50:12.95   User: BACKUP           Process ID:   00000C5B
                          Node: KREST1           Process name:
"BATCH_889"   Authorized privileges:
 BYPASS       CMKRNL       LOG_IO       MOUNT        NETMBX       OPER
 PHY_IO       READALL      TMPMBX       VOLPRO
 
Process privileges:
 BYPASS               may bypass all object access controls
 CMKRNL               may change mode to kernel
 LOG_IO               may do logical i/o
 MOUNT                may execute mount acp function
 NETMBX               may create network device
 OPER                 may perform operator functions
 PHY_IO               may do physical i/o
 READALL              may read anything as the owner
 TMPMBX               may create temporary mailbox
 VOLPRO               may override volume protection
 
Process rights:
 BATCH                             
 MIS$ACCESS                        
 ORA_DBA                           
 
System rights:
 SYS$NODE_KREST1                   

   "ORA_SID" = "RTHIRE" (LNM$JOB_80E3FBC0) 1 "rthire" = "MBA474:" (LNM$SYSTEM_TABLE)

Oracle Server Manager Release 2.3.2.0.2 - Production Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.

Oracle7 Server Release 7.3.2.3.2 - Production Release PL/SQL Release 2.3.2.3.1 - Production

SVRMGR>
Connected to an idle instance.
SVRMGR>
select * from v$database
*
ORA-01034: ORACLE not available
SVRMGR>
ORA-01034: ORACLE not available
SVRMGR>
Server Manager complete.
  BACKUP job terminated at 1-APR-1998 12:50:18.77

  Accounting information:

  Buffered I/O count:                324      Peak working set
size:       8608
  Direct I/O count:                  226      Peak virtual size:        
200240
  Page faults:                      1424      Mounted
volumes:                0
  Charged CPU time:        0 00:00:00.70      Elapsed time:       0
00:00:06.28 Received on Wed Apr 01 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US