Re: RMAN error: ORA-01031 Insufficient privileges
From: joel garry <joel-garry_at_home.com>
Date: Tue, 4 Dec 2012 10:07:37 -0800 (PST)
Message-ID: <3f7df03d-c337-4f88-a930-bcacea178cad_at_qi8g2000pbb.googlegroups.com>
On Dec 4, 5:01 am, gnewsgr..._at_gmail.com wrote:
> I do have a lot of experiences in MS SQL Server, but sorta new to Oracle.
>
> I have Oracle XE on Windows 7 Enterprise. I am learning how to use RMAN to back up my database.
>
> So, I issued rman target / and got this:
>
> Recovery Manager: Release 11.2.0.2.0 - Production on Tue Dec 4 07:55:14 2012
>
> Copyright (c) 1982, 2009, 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
>
> I searched and found solutions on a Unix based system. But this is Windows, how do I make sure I can successfully launch rman? What do I need to do? Thank you!
Date: Tue, 4 Dec 2012 10:07:37 -0800 (PST)
Message-ID: <3f7df03d-c337-4f88-a930-bcacea178cad_at_qi8g2000pbb.googlegroups.com>
On Dec 4, 5:01 am, gnewsgr..._at_gmail.com wrote:
> I do have a lot of experiences in MS SQL Server, but sorta new to Oracle.
>
> I have Oracle XE on Windows 7 Enterprise. I am learning how to use RMAN to back up my database.
>
> So, I issued rman target / and got this:
>
> Recovery Manager: Release 11.2.0.2.0 - Production on Tue Dec 4 07:55:14 2012
>
> Copyright (c) 1982, 2009, 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
>
> I searched and found solutions on a Unix based system. But this is Windows, how do I make sure I can successfully launch rman? What do I need to do? Thank you!
Also note there is a .bat file you can get some clues from. If you right click on the "backup database" you get to from the start menu, click on properties, you can see where to look at it. I know I learned some new things from it.
jg
-- _at_home.com is bogus. http://www.theregister.co.uk/2012/12/04/oracle_2013_dividend_pre_paid/Received on Tue Dec 04 2012 - 19:07:37 CET