出现状况:
[oracle@yong ~]$ rman target cata/cata@YONGDBRecovery Manager: Release 11.2.0.3.0 - Production on Sat Oct 13 16:49:13 2012Copyright (c) 1982, 2011, Oracle and/or its affiliates. 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
sqlplus scott/tiger@YONGDB
SQL> select * from v$version;BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Productioncata拥有的角色和权限: connect, resource ,recovery_catalog_owner,DBA 角色
=====================================================
select * from session_roles;01 CONNECT
02 RESOURCE
03 DBA
04 SELECT_CATALOG_ROLE
05 HS_ADMIN_SELECT_ROLE
06 EXECUTE_CATALOG_ROLE
07 HS_ADMIN_EXECUTE_ROLE
08 DELETE_CATALOG_ROLE
09 EXP_FULL_DATABASE
10 IMP_FULL_DATABASE
11 DATAPUMP_EXP_FULL_DATABASE
12 DATAPUMP_IMP_FULL_DATABASE
13 GATHER_SYSTEM_STATISTICS
14 SCHEDULER_ADMIN
15 WM_ADMIN_ROLE
16 JAVA_ADMIN
17 JAVA_DEPLOY
18 XDBADMIN
19 XDB_SET_INVOKER
20 OLAP_XS_ADMIN
21 OLAP_DBA
22 RECOVERY_CATALOG_OWNER
=================================================select * from session_privs;86 UNDER ANY TYPE
87 CREATE LIBRARY
88 CREATE ANY LIBRARY
89 ALTER ANY LIBRARY
90 DROP ANY LIBRARY
91 EXECUTE ANY LIBRARY
92 CREATE OPERATOR
93 CREATE ANY OPERATOR
94 ALTER ANY OPERATOR
95 DROP ANY OPERATOR
96 EXECUTE ANY OPERATOR
97 CREATE INDEXTYPE
98 CREATE ANY INDEXTYPE
99 ALTER ANY INDEXTYPE
100 DROP ANY INDEXTYPE
101 UNDER ANY VIEW
102 QUERY REWRITE
103 GLOBAL QUERY REWRITE
104 EXECUTE ANY INDEXTYPE
105 UNDER ANY TABLE
106 CREATE DIMENSION
107 CREATE ANY DIMENSION
108 ALTER ANY DIMENSION
109 DROP ANY DIMENSION
110 MANAGE ANY QUEUE
111 ENQUEUE ANY QUEUE
112 DEQUEUE ANY QUEUE
113 CREATE ANY CONTEXT
114 DROP ANY CONTEXT
115 CREATE ANY OUTLINE
116 ALTER ANY OUTLINE
117 DROP ANY OUTLINE
118 ADMINISTER RESOURCE MANAGER
119 ADMINISTER DATABASE TRIGGER
120 MERGE ANY VIEW
121 ON COMMIT REFRESH
122 RESUMABLE
123 SELECT ANY DICTIONARY
124 DEBUG CONNECT SESSION
125 DEBUG ANY PROCEDURE
126 FLASHBACK ANY TABLE
127 GRANT ANY OBJECT PRIVILEGE
128 CREATE EVALUATION CONTEXT
129 CREATE ANY EVALUATION CONTEXT
130 ALTER ANY EVALUATION CONTEXT
131 DROP ANY EVALUATION CONTEXT
132 EXECUTE ANY EVALUATION CONTEXT
133 CREATE RULE SET
134 CREATE ANY RULE SET
135 ALTER ANY RULE SET
136 DROP ANY RULE SET
137 EXECUTE ANY RULE SET
138 EXPORT FULL DATABASE
139 IMPORT FULL DATABASE
140 CREATE RULE
141 CREATE ANY RULE
142 ALTER ANY RULE
143 DROP ANY RULE
144 EXECUTE ANY RULE
145 ANALYZE ANY DICTIONARY
146 ADVISOR
147 CREATE JOB
148 CREATE ANY JOB
149 EXECUTE ANY PROGRAM
150 EXECUTE ANY CLASS
151 MANAGE SCHEDULER
152 SELECT ANY TRANSACTION
153 DROP ANY SQL PROFILE
154 ALTER ANY SQL PROFILE
155 ADMINISTER SQL TUNING SET
156 ADMINISTER ANY SQL TUNING SET
157 CREATE ANY SQL PROFILE
158 MANAGE FILE GROUP
159 MANAGE ANY FILE GROUP
160 READ ANY FILE GROUP
161 CHANGE NOTIFICATION
162 CREATE EXTERNAL JOB
163 CREATE ANY EDITION
164 DROP ANY EDITION
165 ALTER ANY EDITION
166 CREATE ASSEMBLY
167 CREATE ANY ASSEMBLY
168 ALTER ANY ASSEMBLY
169 DROP ANY ASSEMBLY
170 EXECUTE ANY ASSEMBLY
171 EXECUTE ASSEMBLY
172 CREATE MINING MODEL
173 CREATE ANY MINING MODEL
174 DROP ANY MINING MODEL
175 SELECT ANY MINING MODEL
176 ALTER ANY MINING MODEL
177 COMMENT ANY MINING MODEL
178 CREATE CUBE DIMENSION
179 ALTER ANY CUBE DIMENSION
180 CREATE ANY CUBE DIMENSION
181 DELETE ANY CUBE DIMENSION
182 DROP ANY CUBE DIMENSION
183 INSERT ANY CUBE DIMENSION
184 SELECT ANY CUBE DIMENSION
185 CREATE CUBE
186 ALTER ANY CUBE
187 CREATE ANY CUBE
188 DROP ANY CUBE
189 SELECT ANY CUBE
190 UPDATE ANY CUBE
191 CREATE MEASURE FOLDER
192 CREATE ANY MEASURE FOLDER
193 DELETE ANY MEASURE FOLDER
194 DROP ANY MEASURE FOLDER
195 INSERT ANY MEASURE FOLDER
196 CREATE CUBE BUILD PROCESS
197 CREATE ANY CUBE BUILD PROCESS
198 DROP ANY CUBE BUILD PROCESS
199 UPDATE ANY CUBE BUILD PROCESS
200 UPDATE ANY CUBE DIMENSION
201 ADMINISTER SQL MANAGEMENT OBJECT
202 FLASHBACK ARCHIVE ADMINISTER尝试的方法:
1.在 linstener.ora 添加:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=YONGDB.localhost)
(SID_NAME=YONGDB)
)
)2.重建密码文件
select * form v$pwfile_users;
SYS TRUE TRUE FALSE3 sqlnet.ora检查:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/app/oracle
问题还是无法解决
rman tareget / 或者 rman target cata/cata可以登陆,而rman cata/cata@YONGDB 出现上述问题,求解决方法?
[oracle@yong ~]$ rman target cata/cata@YONGDBRecovery Manager: Release 11.2.0.3.0 - Production on Sat Oct 13 16:49:13 2012Copyright (c) 1982, 2011, Oracle and/or its affiliates. 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
sqlplus scott/tiger@YONGDB
SQL> select * from v$version;BANNER
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Productioncata拥有的角色和权限: connect, resource ,recovery_catalog_owner,DBA 角色
=====================================================
select * from session_roles;01 CONNECT
02 RESOURCE
03 DBA
04 SELECT_CATALOG_ROLE
05 HS_ADMIN_SELECT_ROLE
06 EXECUTE_CATALOG_ROLE
07 HS_ADMIN_EXECUTE_ROLE
08 DELETE_CATALOG_ROLE
09 EXP_FULL_DATABASE
10 IMP_FULL_DATABASE
11 DATAPUMP_EXP_FULL_DATABASE
12 DATAPUMP_IMP_FULL_DATABASE
13 GATHER_SYSTEM_STATISTICS
14 SCHEDULER_ADMIN
15 WM_ADMIN_ROLE
16 JAVA_ADMIN
17 JAVA_DEPLOY
18 XDBADMIN
19 XDB_SET_INVOKER
20 OLAP_XS_ADMIN
21 OLAP_DBA
22 RECOVERY_CATALOG_OWNER
=================================================select * from session_privs;86 UNDER ANY TYPE
87 CREATE LIBRARY
88 CREATE ANY LIBRARY
89 ALTER ANY LIBRARY
90 DROP ANY LIBRARY
91 EXECUTE ANY LIBRARY
92 CREATE OPERATOR
93 CREATE ANY OPERATOR
94 ALTER ANY OPERATOR
95 DROP ANY OPERATOR
96 EXECUTE ANY OPERATOR
97 CREATE INDEXTYPE
98 CREATE ANY INDEXTYPE
99 ALTER ANY INDEXTYPE
100 DROP ANY INDEXTYPE
101 UNDER ANY VIEW
102 QUERY REWRITE
103 GLOBAL QUERY REWRITE
104 EXECUTE ANY INDEXTYPE
105 UNDER ANY TABLE
106 CREATE DIMENSION
107 CREATE ANY DIMENSION
108 ALTER ANY DIMENSION
109 DROP ANY DIMENSION
110 MANAGE ANY QUEUE
111 ENQUEUE ANY QUEUE
112 DEQUEUE ANY QUEUE
113 CREATE ANY CONTEXT
114 DROP ANY CONTEXT
115 CREATE ANY OUTLINE
116 ALTER ANY OUTLINE
117 DROP ANY OUTLINE
118 ADMINISTER RESOURCE MANAGER
119 ADMINISTER DATABASE TRIGGER
120 MERGE ANY VIEW
121 ON COMMIT REFRESH
122 RESUMABLE
123 SELECT ANY DICTIONARY
124 DEBUG CONNECT SESSION
125 DEBUG ANY PROCEDURE
126 FLASHBACK ANY TABLE
127 GRANT ANY OBJECT PRIVILEGE
128 CREATE EVALUATION CONTEXT
129 CREATE ANY EVALUATION CONTEXT
130 ALTER ANY EVALUATION CONTEXT
131 DROP ANY EVALUATION CONTEXT
132 EXECUTE ANY EVALUATION CONTEXT
133 CREATE RULE SET
134 CREATE ANY RULE SET
135 ALTER ANY RULE SET
136 DROP ANY RULE SET
137 EXECUTE ANY RULE SET
138 EXPORT FULL DATABASE
139 IMPORT FULL DATABASE
140 CREATE RULE
141 CREATE ANY RULE
142 ALTER ANY RULE
143 DROP ANY RULE
144 EXECUTE ANY RULE
145 ANALYZE ANY DICTIONARY
146 ADVISOR
147 CREATE JOB
148 CREATE ANY JOB
149 EXECUTE ANY PROGRAM
150 EXECUTE ANY CLASS
151 MANAGE SCHEDULER
152 SELECT ANY TRANSACTION
153 DROP ANY SQL PROFILE
154 ALTER ANY SQL PROFILE
155 ADMINISTER SQL TUNING SET
156 ADMINISTER ANY SQL TUNING SET
157 CREATE ANY SQL PROFILE
158 MANAGE FILE GROUP
159 MANAGE ANY FILE GROUP
160 READ ANY FILE GROUP
161 CHANGE NOTIFICATION
162 CREATE EXTERNAL JOB
163 CREATE ANY EDITION
164 DROP ANY EDITION
165 ALTER ANY EDITION
166 CREATE ASSEMBLY
167 CREATE ANY ASSEMBLY
168 ALTER ANY ASSEMBLY
169 DROP ANY ASSEMBLY
170 EXECUTE ANY ASSEMBLY
171 EXECUTE ASSEMBLY
172 CREATE MINING MODEL
173 CREATE ANY MINING MODEL
174 DROP ANY MINING MODEL
175 SELECT ANY MINING MODEL
176 ALTER ANY MINING MODEL
177 COMMENT ANY MINING MODEL
178 CREATE CUBE DIMENSION
179 ALTER ANY CUBE DIMENSION
180 CREATE ANY CUBE DIMENSION
181 DELETE ANY CUBE DIMENSION
182 DROP ANY CUBE DIMENSION
183 INSERT ANY CUBE DIMENSION
184 SELECT ANY CUBE DIMENSION
185 CREATE CUBE
186 ALTER ANY CUBE
187 CREATE ANY CUBE
188 DROP ANY CUBE
189 SELECT ANY CUBE
190 UPDATE ANY CUBE
191 CREATE MEASURE FOLDER
192 CREATE ANY MEASURE FOLDER
193 DELETE ANY MEASURE FOLDER
194 DROP ANY MEASURE FOLDER
195 INSERT ANY MEASURE FOLDER
196 CREATE CUBE BUILD PROCESS
197 CREATE ANY CUBE BUILD PROCESS
198 DROP ANY CUBE BUILD PROCESS
199 UPDATE ANY CUBE BUILD PROCESS
200 UPDATE ANY CUBE DIMENSION
201 ADMINISTER SQL MANAGEMENT OBJECT
202 FLASHBACK ARCHIVE ADMINISTER尝试的方法:
1.在 linstener.ora 添加:
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=YONGDB.localhost)
(SID_NAME=YONGDB)
)
)2.重建密码文件
select * form v$pwfile_users;
SYS TRUE TRUE FALSE3 sqlnet.ora检查:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/app/oracle
问题还是无法解决
rman tareget / 或者 rman target cata/cata可以登陆,而rman cata/cata@YONGDB 出现上述问题,求解决方法?
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=YONGDB)
(SID_NAME=YONGDB)
)
)