Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: what user privileges do I need to create the repository

Re: what user privileges do I need to create the repository

From: JS <ghp_at_videotron.ca>
Date: Sat, 14 Oct 2000 22:50:57 -0700
Message-ID: <M09G5.7199$mY.169661@weber.videotron.net>

for rman:
first, set oracle_sid=your database name (4 character) then, from O/S prompt, rman80 nocatalog then, connect target userid/password, (, this is userid/password from your current Oracle database, userid show have sysdba priv) rman/rman only used if you are going to use the recovery catalog option, to do this you need to set up a tablespace in a database other than the database you want to backup, preferably on a seperate disk, the usual practise is to set up user rman as the owner of the tablespace check documentation Backup and Recovery for complete info JS

Rob <rfreez_at_gte.net> wrote in message
news:M_GE5.426$9n6.89370_at_dfiatx1-snr1.gtei.net...
> Hi,
>
> I just installed OEM on my Oracle database and I was wondering what user I
> can use for the repository, or what privileges do I need to grant to an
> existing user to own the repository. Also, how can I view all possible
> privileges?
>
> Finally, I have Oracle 8i and I can't get rman to work. Is rman/rman a
> valid user and password? Where do I even start to get rman running?
> Thanks.
>
> Rob Freeman
> rfreez_at_gte.net
>
>
Received on Sun Oct 15 2000 - 00:50:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US