2 Replies Latest reply: Dec 5, 2012 5:05 AM by akm-2205195 RSS

    Unable to take RMAN backup after upgrade from 10g to 11gr2

    akm-2205195
      Dear All,

      Aftre upgrading db from 10 g to 11g ,unable to take rman backup.catlog also upgraded.SCAN listsner alos running



      ps -ef |grep tns
      oracle 13235 13215 0 13:23:55 pts/3 0:00 grep tns
      oracle 2968 1 0 Dec 2 ? 0:47 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
      oracle 2997 1 0 Dec 2 ? 0:51 /crshome_new/oracle/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
      oracle 19844 1 0 Dec 3 ? 0:30 /orahome_new/oracle/product/11.2.0/bin/tnslsnr LISTENER_DB -inherit
      :>
      :>
      :>tnsping IM

      TNS Ping Utility for HPUX: Version 11.2.0.3.0 - Production on 05-DEC-2012 13:24:01

      Copyright (c) 1997, 2011, Oracle. All rights reserved.

      Used parameter files:


      Used TNSNAMES adapter to resolve the alias
      Attempting to contact (DESCRIPTION = (LOAD_BALANCE = yes) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = imscan.cbec.gov.in)(PORT = 1525))) (CONNECT_DATA = (SERVICE_NAME = IM.CBEC.GOV.IN) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 200) (DELAY = 5))))
      TNS-12541: TNS:no listener

      ################
      rman
      Recovery Manager: Release 11.2.0.3.0 - Production on Wed Dec 5 13:24:28 2012

      Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

      RMAN> connect target **/**@IM

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      ORA-12541: TNS:no listener

      RMAN> connect catalog **/**@rcatalog

      connected to recovery catalog database

      ########################error

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      ORA-12541: TNS:no listener

      Recovery Manager complete.