Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> VMS BACKUP user can't see the database ORA-01034
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
$
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
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: 000:00:06.28 Received on Wed Apr 01 1998 - 00:00:00 CST
![]() |
![]() |