| insufficient privileges while connecting sys user [message #460442] |
Fri, 11 June 2010 04:56  |
rajabaskar
Messages: 13
Registered: June 2007
Location: chennai
|
Junior Member |
|
|
Hi,
I using active database cloning oracle 11g feature to clone the database.
I am able to connect the target database using sys user.
But while i am connecting the auxiliary database, i am getting insufficient privileges.
I have created pwd file also.
remote_login_passwordfile= EXCLUSIVE
Details
Quote:
$ rman target sys@test
Recovery Manager: Release 11.1.0.7.0 - Production on Fri Jun 11 05:37:43 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
target database Password:
connected to target database: test (DBID=1192881501)
RMAN> connect auxiliary sys@test
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
Regards
Rajabaskar Thangaraj
|
|
|
|
|
|
| Re: insufficient privileges while connecting sys user [message #460452 is a reply to message #460442] |
Fri, 11 June 2010 05:43  |
rajabaskar
Messages: 13
Registered: June 2007
Location: chennai
|
Junior Member |
|
|
Hi,
Thanks for reply.
After recreating the pwd file, i am getting same issue.
Please explain, how can i proceed further?
orapwd FILE=orapwtest ENTRIES=10 password=test123 ignorecase=y
SQL*Plus: Release 11.1.0.7.0 - Production on Fri Jun 11 06:35:12 2010
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Enter user-name: sys@test as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges
Regards
Rajabaskar Thangaraj
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
