Home » RDBMS Server » Backup & Recovery » insufficient privileges while connecting sys user (Sun Solaris, 11.1.0.7)
insufficient privileges while connecting sys user [message #460442] Fri, 11 June 2010 04:56 Go to next message
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 #460449 is a reply to message #460442] Fri, 11 June 2010 05:20 Go to previous messageGo to next message
John Watson
Messages: 4793
Registered: January 2010
Location: Global Village
Senior Member
There are problems with the 11.1 passwordfile and distributed environments, you need use the ignorecase switch when you create it, and copy it (not create another.)
Re: insufficient privileges while connecting sys user [message #460452 is a reply to message #460442] Fri, 11 June 2010 05:43 Go to previous messageGo to next message
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
Re: insufficient privileges while connecting sys user [message #460456 is a reply to message #460452] Fri, 11 June 2010 05:50 Go to previous message
John Watson
Messages: 4793
Registered: January 2010
Location: Global Village
Senior Member
Quote:
and copy it
?
Previous Topic: whole backup
Next Topic: Log file Corrupted
Goto Forum:
  


Current Time: Sun Nov 23 00:22:44 CST 2014

Total time taken to generate the page: 0.07155 seconds