Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Basic RMAN question
> -----Original Message-----
> > rman target='backup_admin/backup as sysdba_at_foobar'
> nocatalog log="test.log"
> rman: can't open target=backup_manager/backup as sysdba_at_foobar
Get rid of the "as sysdba". rman will automatically connect however it needs to connect. Be sure you have granted sysdba to whoever you are connecting as. I always use sys or system instead of messing with yet another userid. I've not played with the single quotes; but that could be part of the problem. In general, it is not good practice to put user/password on a command line. Sometimes the program will hide its command line from the ps command, and sometimes not. I think rman does not.
>
> So I thought id start simple:
> >rman nocatalog
> rman: can't open nocatalog
> >rman
> this just hangs
>
> So what have i missed?
>
Maybe need to export ORACLE_SID=YADAYADA
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: Stephen.Lee_at_DTAG.Com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Feb 26 2003 - 10:09:27 CST
![]() |
![]() |