Re: ORA-12560 in rman

John.Tind..._at_gmail.com wrote:
> Hey all,
>
> This should be easy but I'm just not seeing it...
>
>
> box a: win2k3, Oracle 9.2 catalog db, rman
> box b: aix 5.2L, Oracle 9.2 db
>
>
> C:\>set ORACLE_SID=pmmtst
>
> C:\>rman rcvcat=rman/asdf_at_catdb
>
> Recovery Manager: Release 9.2.0.1.0 - Production
>
> Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
>
> connected to recovery catalog database
> RMAN> connect target
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> ORA-12560: TNS:protocol adapter error
>
>
> The tns entry is as follows:
> PMMTST.UBI.URBANBRANDS.COM =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = pmm)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = pmmtst)
> )
> )
>
>
> I can connect via sqlplus and tnsping resolves the pmmtst database OK.
> I have rebooted the win2k3 machine.
> The entry in the dns is fine.
> I have no problems connecting to other db's from the catalog machine.
>
> Any thoughts would be greatly appreciated!
>
> Thanks

Does this work from the command line?

c:> sqlplus "/ as sysdba"

If not, then your account needs to be in the ORA_DBA goup. Received on Tue Sep 27 2005 - 13:01:31 CDT