Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rman and Insufficient Privileges Error
You might need to find out whether the vendor has created the catalog for
you.
If not, either you can create the catalog (make sure the catalog is located
in a separate db and not within the same machine as your production db) or
you can use RMAN to do the backup without the catalog.
If no catalog is used, you can carry out the RMAN work in your production
server using an account with SYSDBA privilege
such as
rman target / nocatalog
Alvin
"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
news:n9c2a0hvho4a2rmssb8s3ak8jvg00rnfen_at_4ax.com...
> On Tue, 11 May 2004 19:08:00 GMT, "Mark Brown"
> <mbrown_at_echd.nospam.org> wrote:
>
> >I don't seem to have a password for sys.
> >
>
>
> connect target /
> should work
>
> in sql*plus
> sqlplus /nolog
> connect / as sysdba
> should get you in
> Then
> alter user sys identified by password;
> (without quotes)
> >How do I connect with a catalog and how do I select the right catalog?
>
> connect catalog <username>/<password>
>
> the catalog is usually located in the user rman or rcat
>
> Please do not expect this forum to abstract the fulll rman docs for
> you.
> They are online at http://tahiti.oracle.com
>
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed May 12 2004 - 20:15:44 CDT