10 Replies Latest reply: Jan 31, 2013 11:27 PM by GeetaM RSS

    RMAN - ORA-03114: not connected to ORACLE

    GeetaM
      Hi Guru

      I am getting below error message everything i am exiting from RMAN -

      Problem Summary : RMAN> exit ORA-03114: not connected to ORACLE

      Problem Description : I get this message when i exit rman:
      RMAN> exit
      
      Recovery Manager complete.
      ORACLE error from target database:
      ORA-03114: not connected to ORACLE
      Error Codes: RMAN ORA-03114
        • 1. Re: RMAN - ORA-03114: not connected to ORACLE
          Sunny kichloo
          Tell me the syntax in which you are connecting to rman??

          Also did you register your database with RMAN.

          Also is your listener up and running??
          • 2. Re: RMAN - ORA-03114: not connected to ORACLE
            yoonas
            Hi,

            Please rovide your vesion details(Database,OS...) - https://blogs.oracle.com/shay/entry/10_commandments_for_the_otn_fo

            >
            Problem Summary : RMAN> exit ORA-03114: not connected to ORACLE
            >

            Better you provide complete error stack

            Regards
            Yoonas
            • 3. Re: RMAN - ORA-03114: not connected to ORACLE
              GeetaM
              DB Version: 11.2.0.3
              OS Version: Linux **** 2.6.18-238.12.2.0.2.el5

              Commands used and error -
              rman catalog rman/*****@prman target /
              
              Recovery Manager: Release *11.2.0.3.0* - Production on Thu Jan 31 03:23:27 2013
              
              Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
              
              connected to target database: *** (DBID=1758056082)
              connected to recovery catalog database
              
              RMAN> exit
              
              
              Recovery Manager complete.
              ORACLE error from target database:
              ORA-03114: not connected to ORACLE
              Regards
              • 4. Re: RMAN - ORA-03114: not connected to ORACLE
                Niket Kumar
                check alertlog file for database prman and also check whether database is running or not

                ps -ef|grep prman

                and also post errors you find recently in alert log file.
                • 5. Re: RMAN - ORA-03114: not connected to ORACLE
                  GeetaM
                  Please find the output and alert log -
                  ps -ef |grep prman
                  oracle 4936 2377 0 Jan30 pts/1 00:00:12 rman catalog rman/Rman11r3y@prman target /
                  oracle 25537 25970 0 04:24 pts/4 00:00:00 grep prman

                  Alert Log -
                  Mon Dec 31 22:30:02 EST 2012
                  Mon Dec 31 22:42:53 2012
                  Thread 8 advanced to log sequence 12635 (LGWR switch)
                    Current log# 83 seq# 12635 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12635 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Mon Dec 31 22:42:53 2012
                  Archived Log entry 79273 added for thread 8 sequence 12634 ID 0x68c99d2e dest 1:
                  Mon Dec 31 23:09:48 2012
                  Thread 8 advanced to log sequence 12636 (LGWR switch)
                    Current log# 84 seq# 12636 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12636 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Mon Dec 31 23:09:48 2012
                  Archived Log entry 79281 added for thread 8 sequence 12635 ID 0x68c99d2e dest 1:
                  Mon Dec 31 23:24:00 2012
                  Thread 8 advanced to log sequence 12637 (LGWR switch)
                    Current log# 85 seq# 12637 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12637 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Mon Dec 31 23:24:00 2012
                  Archived Log entry 79286 added for thread 8 sequence 12636 ID 0x68c99d2e dest 1:
                  Mon Dec 31 23:29:31 2012
                  
                  
                  ***********************************************************************
                  
                  Fatal NI connect error 12170.
                  
                    VERSION INFORMATION:
                       TNS for Linux: Version 11.2.0.3.0 - Production
                       Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                       TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                    Time: 31-DEC-2012 23:29:31
                    Tracing not turned on.
                    Tns error struct:
                      ns main err code: 12535
                      
                  TNS-12535: TNS:operation timed out
                      ns secondary err code: 12560
                      nt main err code: 505
                      
                  TNS-00505: Operation timed out
                      nt secondary err code: 110
                      nt OS err code: 0
                    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.62.63.153)(PORT=59924))
                  opidcl aborting process unknown ospid (28832) as a result of ORA-2396
                  Mon Dec 31 23:50:43 2012
                  Thread 8 advanced to log sequence 12638 (LGWR switch)
                    Current log# 86 seq# 12638 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12638 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Mon Dec 31 23:50:44 2012
                  Archived Log entry 79292 added for thread 8 sequence 12637 ID 0x68c99d2e dest 1:
                  Mon Dec 31 23:54:24 2012
                  Thread 8 advanced to log sequence 12639 (LGWR switch)
                    Current log# 87 seq# 12639 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12639 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Mon Dec 31 23:54:24 2012
                  Archived Log entry 79299 added for thread 8 sequence 12638 ID 0x68c99d2e dest 1:
                  Mon Dec 31 23:57:15 2012
                  Thread 8 advanced to log sequence 12640 (LGWR switch)
                    Current log# 88 seq# 12640 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12640 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Mon Dec 31 23:57:16 2012
                  Archived Log entry 79305 added for thread 8 sequence 12639 ID 0x68c99d2e dest 1:
                  Tue Jan 01 00:02:24 2013
                  Thread 8 advanced to log sequence 12641 (LGWR switch)
                    Current log# 81 seq# 12641 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12641 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 00:02:25 2013
                  Archived Log entry 79314 added for thread 8 sequence 12640 ID 0x68c99d2e dest 1:
                  Tue Jan 01 00:10:28 2013
                  Thread 8 advanced to log sequence 12642 (LGWR switch)
                    Current log# 82 seq# 12642 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12642 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 00:10:28 2013
                  Archived Log entry 79320 added for thread 8 sequence 12641 ID 0x68c99d2e dest 1:
                  Tue Jan 01 00:47:36 2013
                  Thread 8 advanced to log sequence 12643 (LGWR switch)
                    Current log# 83 seq# 12643 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12643 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 00:47:37 2013
                  Archived Log entry 79327 added for thread 8 sequence 12642 ID 0x68c99d2e dest 1:
                  Tue Jan 01 01:25:13 2013
                  Thread 8 advanced to log sequence 12644 (LGWR switch)
                    Current log# 84 seq# 12644 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12644 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Tue Jan 01 01:25:14 2013
                  Archived Log entry 79334 added for thread 8 sequence 12643 ID 0x68c99d2e dest 1:
                  Tue Jan 01 03:05:25 2013
                  Thread 8 advanced to log sequence 12645 (LGWR switch)
                    Current log# 85 seq# 12645 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12645 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Tue Jan 01 03:05:27 2013
                  Archived Log entry 79341 added for thread 8 sequence 12644 ID 0x68c99d2e dest 1:
                  Tue Jan 01 03:12:26 2013
                  Thread 8 advanced to log sequence 12646 (LGWR switch)
                    Current log# 86 seq# 12646 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12646 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Tue Jan 01 03:12:26 2013
                  Archived Log entry 79348 added for thread 8 sequence 12645 ID 0x68c99d2e dest 1:
                  Tue Jan 01 03:20:39 2013
                  Thread 8 advanced to log sequence 12647 (LGWR switch)
                    Current log# 87 seq# 12647 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12647 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Tue Jan 01 03:20:40 2013
                  Archived Log entry 79356 added for thread 8 sequence 12646 ID 0x68c99d2e dest 1:
                  Tue Jan 01 03:34:21 2013
                  Thread 8 advanced to log sequence 12648 (LGWR switch)
                    Current log# 88 seq# 12648 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12648 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Tue Jan 01 03:34:22 2013
                  Archived Log entry 79364 added for thread 8 sequence 12647 ID 0x68c99d2e dest 1:
                  Tue Jan 01 03:41:52 2013
                  Thread 8 advanced to log sequence 12649 (LGWR switch)
                    Current log# 81 seq# 12649 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12649 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 03:41:52 2013
                  Archived Log entry 79369 added for thread 8 sequence 12648 ID 0x68c99d2e dest 1:
                  Tue Jan 01 03:47:52 2013
                  Thread 8 advanced to log sequence 12650 (LGWR switch)
                    Current log# 82 seq# 12650 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12650 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 03:47:52 2013
                  Archived Log entry 79375 added for thread 8 sequence 12649 ID 0x68c99d2e dest 1:
                  Tue Jan 01 04:03:23 2013
                  Thread 8 advanced to log sequence 12651 (LGWR switch)
                    Current log# 83 seq# 12651 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12651 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 04:03:23 2013
                  Archived Log entry 79382 added for thread 8 sequence 12650 ID 0x68c99d2e dest 1:
                  Tue Jan 01 04:06:22 2013
                  Thread 8 advanced to log sequence 12652 (LGWR switch)
                    Current log# 84 seq# 12652 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12652 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Tue Jan 01 04:06:23 2013
                  Archived Log entry 79388 added for thread 8 sequence 12651 ID 0x68c99d2e dest 1:
                  Tue Jan 01 04:12:47 2013
                  Thread 8 advanced to log sequence 12653 (LGWR switch)
                    Current log# 85 seq# 12653 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12653 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Tue Jan 01 04:12:48 2013
                  Archived Log entry 79394 added for thread 8 sequence 12652 ID 0x68c99d2e dest 1:
                  Tue Jan 01 04:19:23 2013
                  Thread 8 advanced to log sequence 12654 (LGWR switch)
                    Current log# 86 seq# 12654 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12654 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Tue Jan 01 04:19:25 2013
                  Archived Log entry 79399 added for thread 8 sequence 12653 ID 0x68c99d2e dest 1:
                  Tue Jan 01 04:57:09 2013
                  Thread 8 advanced to log sequence 12655 (LGWR switch)
                    Current log# 87 seq# 12655 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12655 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Tue Jan 01 04:57:09 2013
                  Archived Log entry 79406 added for thread 8 sequence 12654 ID 0x68c99d2e dest 1:
                  Tue Jan 01 05:05:21 2013
                  
                  
                  ***********************************************************************
                  
                  Fatal NI connect error 12170.
                  
                    VERSION INFORMATION:
                       TNS for Linux: Version 11.2.0.3.0 - Production
                       Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                       TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                    Time: 01-JAN-2013 05:05:21
                    Tracing not turned on.
                    Tns error struct:
                      ns main err code: 12535
                      
                  TNS-12535: TNS:operation timed out
                      ns secondary err code: 12560
                      nt main err code: 505
                      
                  TNS-00505: Operation timed out
                      nt secondary err code: 110
                      nt OS err code: 0
                    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.62.60.225)(PORT=51412))
                  opidcl aborting process unknown ospid (20482) as a result of ORA-2396
                  Tue Jan 01 05:05:42 2013
                  
                  
                  ***********************************************************************
                  
                  Fatal NI connect error 12170.
                  
                    VERSION INFORMATION:
                       TNS for Linux: Version 11.2.0.3.0 - Production
                       Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                       TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                    Time: 01-JAN-2013 05:05:42
                    Tracing not turned on.
                    Tns error struct:
                      ns main err code: 12535
                      
                  TNS-12535: TNS:operation timed out
                      ns secondary err code: 12560
                      nt main err code: 505
                      
                  TNS-00505: Operation timed out
                      nt secondary err code: 110
                      nt OS err code: 0
                    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.62.60.225)(PORT=51417))
                  opidcl aborting process unknown ospid (20756) as a result of ORA-2396
                  Tue Jan 01 05:15:43 2013
                  Thread 8 advanced to log sequence 12656 (LGWR switch)
                    Current log# 88 seq# 12656 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12656 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Tue Jan 01 05:15:44 2013
                  Archived Log entry 79413 added for thread 8 sequence 12655 ID 0x68c99d2e dest 1:
                  Tue Jan 01 05:19:47 2013
                  Thread 8 advanced to log sequence 12657 (LGWR switch)
                    Current log# 81 seq# 12657 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12657 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 05:19:47 2013
                  Archived Log entry 79420 added for thread 8 sequence 12656 ID 0x68c99d2e dest 1:
                  Tue Jan 01 05:33:29 2013
                  Thread 8 advanced to log sequence 12658 (LGWR switch)
                    Current log# 82 seq# 12658 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12658 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 05:33:30 2013
                  Archived Log entry 79426 added for thread 8 sequence 12657 ID 0x68c99d2e dest 1:
                  Tue Jan 01 05:46:00 2013
                  Thread 8 advanced to log sequence 12659 (LGWR switch)
                    Current log# 83 seq# 12659 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12659 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 05:46:00 2013
                  Archived Log entry 79433 added for thread 8 sequence 12658 ID 0x68c99d2e dest 1:
                  Tue Jan 01 06:00:00 2013
                  Closing Resource Manager plan via scheduler window
                  Clearing Resource Manager plan via parameter
                  Tue Jan 01 06:02:34 2013
                  Thread 8 advanced to log sequence 12660 (LGWR switch)
                    Current log# 84 seq# 12660 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12660 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Tue Jan 01 06:02:34 2013
                  Archived Log entry 79439 added for thread 8 sequence 12659 ID 0x68c99d2e dest 1:
                  Tue Jan 01 06:17:53 2013
                  Thread 8 advanced to log sequence 12661 (LGWR switch)
                    Current log# 85 seq# 12661 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12661 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Tue Jan 01 06:17:53 2013
                  Archived Log entry 79446 added for thread 8 sequence 12660 ID 0x68c99d2e dest 1:
                  Tue Jan 01 06:27:59 2013
                  Thread 8 advanced to log sequence 12662 (LGWR switch)
                    Current log# 86 seq# 12662 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12662 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Tue Jan 01 06:27:59 2013
                  Archived Log entry 79453 added for thread 8 sequence 12661 ID 0x68c99d2e dest 1:
                  Tue Jan 01 06:51:06 2013
                  Thread 8 advanced to log sequence 12663 (LGWR switch)
                    Current log# 87 seq# 12663 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12663 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Tue Jan 01 06:51:07 2013
                  Archived Log entry 79459 added for thread 8 sequence 12662 ID 0x68c99d2e dest 1:
                  Tue Jan 01 07:01:31 2013
                  Thread 8 advanced to log sequence 12664 (LGWR switch)
                    Current log# 88 seq# 12664 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12664 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Tue Jan 01 07:01:33 2013
                  Archived Log entry 79464 added for thread 8 sequence 12663 ID 0x68c99d2e dest 1:
                  Tue Jan 01 07:23:23 2013
                  Thread 8 advanced to log sequence 12665 (LGWR switch)
                    Current log# 81 seq# 12665 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12665 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 07:23:23 2013
                  Archived Log entry 79472 added for thread 8 sequence 12664 ID 0x68c99d2e dest 1:
                  Tue Jan 01 07:41:12 2013
                  Thread 8 advanced to log sequence 12666 (LGWR switch)
                    Current log# 82 seq# 12666 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12666 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 07:41:12 2013
                  Archived Log entry 79478 added for thread 8 sequence 12665 ID 0x68c99d2e dest 1:
                  Tue Jan 01 07:59:51 2013
                  Thread 8 advanced to log sequence 12667 (LGWR switch)
                    Current log# 83 seq# 12667 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12667 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 07:59:52 2013
                  Archived Log entry 79485 added for thread 8 sequence 12666 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:07:10 2013
                  Thread 8 advanced to log sequence 12668 (LGWR switch)
                    Current log# 84 seq# 12668 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12668 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Tue Jan 01 08:07:11 2013
                  Archived Log entry 79491 added for thread 8 sequence 12667 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:17:56 2013
                  
                  
                  ***********************************************************************
                  
                  Fatal NI connect error 12170.
                  
                    VERSION INFORMATION:
                       TNS for Linux: Version 11.2.0.3.0 - Production
                       Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                       TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production
                    Time: 01-JAN-2013 08:17:56
                    Tracing not turned on.
                    Tns error struct:
                      ns main err code: 12535
                      
                  TNS-12535: TNS:operation timed out
                      ns secondary err code: 12560
                      nt main err code: 505
                      
                  TNS-00505: Operation timed out
                      nt secondary err code: 110
                      nt OS err code: 0
                    Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.62.60.171)(PORT=4440))
                  opidcl aborting process unknown ospid (9144) as a result of ORA-2396
                  Tue Jan 01 08:25:08 2013
                  Thread 8 advanced to log sequence 12669 (LGWR switch)
                    Current log# 85 seq# 12669 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12669 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Tue Jan 01 08:25:08 2013
                  Archived Log entry 79498 added for thread 8 sequence 12668 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:30:33 2013
                  Thread 8 advanced to log sequence 12670 (LGWR switch)
                    Current log# 86 seq# 12670 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12670 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Tue Jan 01 08:30:34 2013
                  Archived Log entry 79504 added for thread 8 sequence 12669 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:33:00 2013
                  Thread 8 advanced to log sequence 12671 (LGWR switch)
                    Current log# 87 seq# 12671 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12671 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Tue Jan 01 08:33:02 2013
                  Archived Log entry 79510 added for thread 8 sequence 12670 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:35:15 2013
                  Thread 8 advanced to log sequence 12672 (LGWR switch)
                    Current log# 88 seq# 12672 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12672 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Tue Jan 01 08:35:16 2013
                  Archived Log entry 79516 added for thread 8 sequence 12671 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:38:04 2013
                  Thread 8 advanced to log sequence 12673 (LGWR switch)
                    Current log# 81 seq# 12673 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12673 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 08:38:04 2013
                  Archived Log entry 79521 added for thread 8 sequence 12672 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:42:01 2013
                  Thread 8 advanced to log sequence 12674 (LGWR switch)
                    Current log# 82 seq# 12674 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12674 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 08:42:01 2013
                  Archived Log entry 79528 added for thread 8 sequence 12673 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:47:47 2013
                  Thread 8 advanced to log sequence 12675 (LGWR switch)
                    Current log# 83 seq# 12675 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12675 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 08:47:50 2013
                  Archived Log entry 79534 added for thread 8 sequence 12674 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:52:12 2013
                  Thread 8 advanced to log sequence 12676 (LGWR switch)
                    Current log# 84 seq# 12676 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12676 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Tue Jan 01 08:52:12 2013
                  Archived Log entry 79540 added for thread 8 sequence 12675 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:54:45 2013
                  Thread 8 advanced to log sequence 12677 (LGWR switch)
                    Current log# 85 seq# 12677 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12677 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Tue Jan 01 08:54:45 2013
                  Archived Log entry 79546 added for thread 8 sequence 12676 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:56:48 2013
                  Thread 8 advanced to log sequence 12678 (LGWR switch)
                    Current log# 86 seq# 12678 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12678 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Tue Jan 01 08:56:48 2013
                  Archived Log entry 79552 added for thread 8 sequence 12677 ID 0x68c99d2e dest 1:
                  Tue Jan 01 08:59:00 2013
                  Thread 8 advanced to log sequence 12679 (LGWR switch)
                    Current log# 87 seq# 12679 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12679 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Tue Jan 01 08:59:01 2013
                  Archived Log entry 79558 added for thread 8 sequence 12678 ID 0x68c99d2e dest 1:
                  Tue Jan 01 09:01:16 2013
                  Thread 8 advanced to log sequence 12680 (LGWR switch)
                    Current log# 88 seq# 12680 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12680 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Tue Jan 01 09:01:16 2013
                  Archived Log entry 79564 added for thread 8 sequence 12679 ID 0x68c99d2e dest 1:
                  Tue Jan 01 09:01:24 2013
                  opidcl aborting process unknown ospid (3089) as a result of ORA-2396
                  Tue Jan 01 09:05:43 2013
                  Thread 8 advanced to log sequence 12681 (LGWR switch)
                    Current log# 81 seq# 12681 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12681 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 09:05:44 2013
                  Archived Log entry 79569 added for thread 8 sequence 12680 ID 0x68c99d2e dest 1:
                  Tue Jan 01 09:21:47 2013
                  Thread 8 advanced to log sequence 12682 (LGWR switch)
                    Current log# 82 seq# 12682 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12682 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 09:21:49 2013
                  Archived Log entry 79577 added for thread 8 sequence 12681 ID 0x68c99d2e dest 1:
                  Tue Jan 01 09:42:55 2013
                  Thread 8 advanced to log sequence 12683 (LGWR switch)
                    Current log# 83 seq# 12683 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12683 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 09:42:56 2013
                  Archived Log entry 79584 added for thread 8 sequence 12682 ID 0x68c99d2e dest 1:
                  Tue Jan 01 09:58:53 2013
                  Thread 8 advanced to log sequence 12684 (LGWR switch)
                    Current log# 84 seq# 12684 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12684 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Tue Jan 01 09:58:54 2013
                  Archived Log entry 79589 added for thread 8 sequence 12683 ID 0x68c99d2e dest 1:
                  Tue Jan 01 10:09:59 2013
                  Thread 8 advanced to log sequence 12685 (LGWR switch)
                    Current log# 85 seq# 12685 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12685 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Tue Jan 01 10:11:07 2013
                  Archived Log entry 79597 added for thread 8 sequence 12684 ID 0x68c99d2e dest 1:
                  Tue Jan 01 10:12:56 2013
                  TABLE EDW.WORK_ORDER_PRODUCT_SUM: ADDED INTERVAL PARTITION SYS_P182770 (60) VALUES LESS THAN (TO_DATE(' 2013-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
                  Tue Jan 01 10:18:42 2013
                  Thread 8 advanced to log sequence 12686 (LGWR switch)
                    Current log# 86 seq# 12686 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12686 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Tue Jan 01 10:18:51 2013
                  Archived Log entry 79602 added for thread 8 sequence 12685 ID 0x68c99d2e dest 1:
                  Tue Jan 01 10:28:04 2013
                  TABLE IKNOW.IKNOW_CUST_SEARCH_FACT: ADDED INTERVAL PARTITION SYS_P182771 (48) VALUES LESS THAN (TO_DATE(' 2013-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
                  Tue Jan 01 10:33:39 2013
                  Thread 8 advanced to log sequence 12687 (LGWR switch)
                    Current log# 87 seq# 12687 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12687 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Tue Jan 01 10:33:40 2013
                  Archived Log entry 79608 added for thread 8 sequence 12686 ID 0x68c99d2e dest 1:
                  Tue Jan 01 11:01:04 2013
                  Thread 8 advanced to log sequence 12688 (LGWR switch)
                    Current log# 88 seq# 12688 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12688 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Tue Jan 01 11:01:06 2013
                  Archived Log entry 79615 added for thread 8 sequence 12687 ID 0x68c99d2e dest 1:
                  Tue Jan 01 11:21:41 2013
                  Thread 8 advanced to log sequence 12689 (LGWR switch)
                    Current log# 81 seq# 12689 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12689 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 11:21:42 2013
                  Archived Log entry 79620 added for thread 8 sequence 12688 ID 0x68c99d2e dest 1:
                  Tue Jan 01 11:27:17 2013
                  Thread 8 advanced to log sequence 12690 (LGWR switch)
                    Current log# 82 seq# 12690 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12690 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 11:27:18 2013
                  Archived Log entry 79626 added for thread 8 sequence 12689 ID 0x68c99d2e dest 1:
                  Tue Jan 01 11:43:18 2013
                  Thread 8 advanced to log sequence 12691 (LGWR switch)
                    Current log# 83 seq# 12691 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12691 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 11:43:18 2013
                  Archived Log entry 79631 added for thread 8 sequence 12690 ID 0x68c99d2e dest 1:
                  Tue Jan 01 12:06:07 2013
                  opidcl aborting process unknown ospid (30331) as a result of ORA-2396
                  Tue Jan 01 12:34:44 2013
                  Index MSADMIN.XBTMCMB_CUSTOMER_KEY or some [sub]partitions of the index have been marked unusable
                  Tue Jan 01 12:50:42 2013
                  Thread 8 advanced to log sequence 12692 (LGWR switch)
                    Current log# 84 seq# 12692 mem# 0: +DATA/***/onlinelog/group_84.3137.785962549
                    Current log# 84 seq# 12692 mem# 1: +RECO/***/onlinelog/group_84.21719.785962559
                  Tue Jan 01 12:50:43 2013
                  Archived Log entry 79638 added for thread 8 sequence 12691 ID 0x68c99d2e dest 1:
                  Tue Jan 01 14:00:57 2013
                  Thread 8 advanced to log sequence 12693 (LGWR switch)
                    Current log# 85 seq# 12693 mem# 0: +DATA/***/onlinelog/group_85.3066.785962575
                    Current log# 85 seq# 12693 mem# 1: +RECO/***/onlinelog/group_85.31182.785962587
                  Tue Jan 01 14:01:09 2013
                  Archived Log entry 79646 added for thread 8 sequence 12692 ID 0x68c99d2e dest 1:
                  Tue Jan 01 17:02:39 2013
                  Running KSFV I/O slave I601 os pid=31716 
                  Tue Jan 01 17:02:47 2013
                  Running KSFV I/O slave I701 os pid=31965 
                  Tue Jan 01 17:02:56 2013
                  Running KSFV I/O slave I801 os pid=32520 
                  Tue Jan 01 17:03:03 2013
                  Running KSFV I/O slave I901 os pid=326 
                  Tue Jan 01 17:03:11 2013
                  Running KSFV I/O slave Ia01 os pid=623 
                  Tue Jan 01 17:03:26 2013
                  Running KSFV I/O slave Ib01 os pid=908 
                  Tue Jan 01 17:03:34 2013
                  Running KSFV I/O slave Ic01 os pid=1116 
                  Tue Jan 01 17:03:41 2013
                  Running KSFV I/O slave Id01 os pid=1215 
                  Tue Jan 01 17:03:48 2013
                  Running KSFV I/O slave Ie01 os pid=1432 
                  Tue Jan 01 17:03:55 2013
                  Running KSFV I/O slave If01 os pid=1631 
                  Tue Jan 01 17:04:01 2013
                  Running KSFV I/O slave Ig01 os pid=1880 
                  Tue Jan 01 17:04:09 2013
                  Running KSFV I/O slave Ih01 os pid=2110 
                  Tue Jan 01 18:24:33 2013
                  Thread 8 advanced to log sequence 12694 (LGWR switch)
                    Current log# 86 seq# 12694 mem# 0: +DATA/***/onlinelog/group_86.2383.785962603
                    Current log# 86 seq# 12694 mem# 1: +RECO/***/onlinelog/group_86.22134.785962615
                  Tue Jan 01 18:24:34 2013
                  Archived Log entry 79653 added for thread 8 sequence 12693 ID 0x68c99d2e dest 1:
                  Tue Jan 01 18:28:54 2013
                  ALTER SYSTEM ARCHIVE LOG
                  Tue Jan 01 18:28:54 2013
                  Thread 8 advanced to log sequence 12695 (LGWR switch)
                    Current log# 87 seq# 12695 mem# 0: +DATA/***/onlinelog/group_87.2748.785962631
                    Current log# 87 seq# 12695 mem# 1: +RECO/***/onlinelog/group_87.31260.785962641
                  Archived Log entry 79655 added for thread 8 sequence 12694 ID 0x68c99d2e dest 1:
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave I801 dp=0x3eaf09288 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave If01 dp=0x48e0206a0 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave I901 dp=0x48e236398 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave Ie01 dp=0x488d42e40 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave I601 dp=0x48e0edab8 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave I701 dp=0x3eeb04d60 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave Ib01 dp=0x48887c5c0 exiting
                  Tue Jan 01 19:29:08 2013
                  Tue Jan 01 19:29:08 2013
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave Id01 dp=0x48e2477b8 exiting
                  KSFV I/O slave Ih01 dp=0x49a6ebab0 exiting
                  KSFV I/O slave Ic01 dp=0x3eaf16150 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave Ig01 dp=0x488d42c20 exiting
                  Tue Jan 01 19:29:08 2013
                  KSFV I/O slave Ia01 dp=0x3efe627f8 exiting
                  Tue Jan 01 20:46:12 2013
                  opidcl aborting process unknown ospid (21379) as a result of ORA-2396
                  Tue Jan 01 22:00:00 2013
                  Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter
                  Tue Jan 01 22:00:00 2013
                  Starting background process VKRM
                  Tue Jan 01 22:00:00 2013
                  VKRM started with pid=166, OS id=19432 
                  Tue Jan 01 22:00:08 2013
                  Errors in file /u01/app/oracle/diag/rdbms/***/***8/trace/***8_j002_19508.trc:
                  ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_8"
                  ORA-29280: invalid directory path
                  ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436
                  ORA-06512: at line 1
                  Tue Jan 01 22:01:22 2013
                  Thread 8 advanced to log sequence 12696 (LGWR switch)
                    Current log# 88 seq# 12696 mem# 0: +DATA/***/onlinelog/group_88.2783.785962653
                    Current log# 88 seq# 12696 mem# 1: +RECO/***/onlinelog/group_88.22719.785962663
                  Tue Jan 01 22:01:23 2013
                  Archived Log entry 79661 added for thread 8 sequence 12695 ID 0x68c99d2e dest 1:
                  Tue Jan 01 22:04:01 2013
                  Thread 8 advanced to log sequence 12697 (LGWR switch)
                    Current log# 81 seq# 12697 mem# 0: +DATA/***/onlinelog/group_81.1796.785962469
                    Current log# 81 seq# 12697 mem# 1: +RECO/***/onlinelog/group_81.26269.785962479
                  Tue Jan 01 22:04:01 2013
                  Archived Log entry 79667 added for thread 8 sequence 12696 ID 0x68c99d2e dest 1:
                  Tue Jan 01 22:09:13 2013
                  Thread 8 advanced to log sequence 12698 (LGWR switch)
                    Current log# 82 seq# 12698 mem# 0: +DATA/***/onlinelog/group_82.2060.785962493
                    Current log# 82 seq# 12698 mem# 1: +RECO/***/onlinelog/group_82.30975.785962503
                  Tue Jan 01 22:09:13 2013
                  Archived Log entry 79673 added for thread 8 sequence 12697 ID 0x68c99d2e dest 1:
                  Tue Jan 01 22:29:20 2013
                  Thread 8 advanced to log sequence 12699 (LGWR switch)
                    Current log# 83 seq# 12699 mem# 0: +DATA/***/onlinelog/group_83.2152.785962521
                    Current log# 83 seq# 12699 mem# 1: +RECO/***/onlinelog/group_83.21975.785962533
                  Tue Jan 01 22:29:20 2013
                  Archived Log entry 79680 added for thread 8 sequence 12698 ID 0x68c99d2e dest 1:
                  • 6. Re: RMAN - ORA-03114: not connected to ORACLE
                    Niket Kumar
                    your catalog database and target database reside on same server?

                    ps -ef|grep pmon
                    • 7. Re: RMAN - ORA-03114: not connected to ORACLE
                      yoonas
                      if you connect only to target and exit?

                      If you connect only to catalog and exit?
                      • 8. Re: RMAN - ORA-03114: not connected to ORACLE
                        Mahir M. Quluzade
                        Hi

                        Can you try tnsping to target and catalog ?
                         
                        
                        tnsping <target sid>
                        tnsping <target sid>
                        
                        export ORACLE_SID=<target sid>
                        rman target / catalog <catalog user>/<password>@<catalog sid>
                        Regards
                        Mahir M. Quluzade
                        • 9. Re: RMAN - ORA-03114: not connected to ORACLE
                          brunors
                          The database is not Open. Check the status and run again.

                          Kind regards, Bruno Reis.
                          • 10. Re: RMAN - ORA-03114: not connected to ORACLE
                            GeetaM
                            Hi All

                            I got an update from Oracle that it is due to -

                            *The ORA-7445 is resulting in the ORA-3113 and ORA_3114 in RMAN

                            The ORA-7445 is related to :
                            Bug 14366237 ORA-7445 [qksopCheckPropOpt] during RMAN partial resync on RAC*


                            Regards