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

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie problem backing up 9i

Re: Newbie problem backing up 9i

From: Mike T. <trozzo_at_arcor.de>
Date: Sat, 20 Aug 2005 14:43:20 +0200
Message-ID: <43072568$0$24147$9b4e6d93@newsread4.arcor-online.net>


<fitzjarrell_at_cox.net> schrieb im Newsbeitrag news:1124499910.579441.246530_at_g49g2000cwa.googlegroups.com...

>
> The SYS as SYSDBA password is not the same as the SYS password,
> confusing as this may sound. Yes, you're using a correct password for
> SYS, but not for SYS as SYSDBA. Also, mike and admin01 haven't been
> granted SYSDBA privilege, so the logins fail when you use the 'as
> SYSDBA' credential. SYSTEM is not a SYSDBA account, so the login
> fails.
>
> Set your SYSDBA password by creating or recreating the password file
> using orapwd.exe. Then try your login again, with this reset SYSDBA
> password.
>

Aha! Many thanks! I granted mike and admin01 SYSDBA and ir worked! Now to learn how to use RMAN :-)

-- 
Mike T
Spiffy sig currently under development. 
Received on Sat Aug 20 2005 - 07:43:20 CDT

Original text of this message

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