Непонятки с RMAN

VicZai
Дата: 09.06.2006 11:23:20
10.2.0.2 на винде

Пользователю даны права

CREATE USER RMAN
IDENTIFIED BY VALUES '123'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT CONNECT TO RMAN;
GRANT DBA TO RMAN;
ALTER USER RMAN DEFAULT ROLE ALL;

В 9 пашет если коннектиться к целевой базе, в 10 нет. Грит

C:\Documents and Settings\victor>rman target rman/123@c246

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 9 11:16:20 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

C:\Documents and Settings\victor>

Чего ему не хватает?
YAP
Дата: 09.06.2006 11:26:59
а проходит
rman target /
VicZai
Дата: 09.06.2006 11:28:00
C:\Documents and Settings\victor>rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 9 11:26:03 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

C:\Documents and Settings\victor>
VicZai
Дата: 09.06.2006 11:31:26
Вот так пашет

C:\Documents and Settings\victor>rman target sys/admincss@c246

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 9 11:26:48 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1093577641)

RMAN>
VicZai
Дата: 09.06.2006 11:34:28
Не на том сервере :) права даны
YAP
Дата: 09.06.2006 12:06:30
VicZai
C:\Documents and Settings\victor>rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 9 11:26:03 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

C:\Documents and Settings\victor>


чтобы вот так ходило, нужно чтобы пользователь ОС, из под которого запускаете, был включен в группу ОС ora_dba

Похоже что пользователю rman, которого Вы создали не хватает каких-то прав, попробуйте grant sysdba to rman.