Oracle-L: RE: RMAN: connecting target DB with SYS account using connect string

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Tue, 04 Nov 2003 11:59:25 -0800
Message-ID: <F001.005D5915.20031104115925@fatcity.com>

IF you set your ORACLE_SID to the target database as the Oracle user, all you have to do is say >RMAN connect target and it will automatically connect. If you are working from the command line you connect user_with_sysdba_privs/password_at_target.domain and you will be connected. If does not recognize the "as sysdba".

HTH,
Ruth

  -----Original Message-----
  From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of   Saminathan
  Sent: Tuesday, November 04, 2003 10:15 AM   To: Multiple recipients of list ORACLE-L   Subject: RMAN: connecting target DB with SYS account using connect   string

Hi list,

I have problem connecting to target DB using account SYS with connect string. But SQL*Plus works fine.

For example,

SQL>connect sys/password_at_connectstring connected.

but in RMAN (using same OS account and server)

RMAN> connect target sys/password_at_connectstring failed

  RMAN-00571: ===========================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  RMAN-00571: ===========================================================

RMAN-04005: error from target database: ORA-01017: invalid username/password; logon denied

Any help will be really appreciated.

-Sami

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net   --
  Author: Saminathan
    INET: saminathans_at_myrealbox.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------