6 Replies Latest reply on Mar 25, 2009 6:00 AM by 615123

    rman backup job Suspended on Agent Unreachable

    615123
      Hi,

      I have Oracle 10.2.0 installed on windows 2003 server. i configure oracle suggested rman backup which works fine till now. but now it shows

      Suspended on Agent Unreachable message and backup doesn't happen.

      if check like
      C:\Documents and Settings\Administrator>emctl status agen
      Oracle Enterprise Manager 10g Database Control Release 10
      Copyright (c) 1996, 2005 Oracle Corporation.  All rights
      ---------------------------------------------------------
      Agent is Not Running
      
      C:\Documents and Settings\Administrator>emctl start agent
      Oracle Enterprise Manager 10g Database Control Release 10
      Copyright (c) 1996, 2005 Oracle Corporation.  All rights
      These Windows services are started:
      
         Application Experience Lookup Service
         Application Management
         Automatic Updates
         COM+ Event System
         COM+ System Application
         Computer Browser
         Cryptographic Services
         DCOM Server Process Launcher
         DefWatch
         Distributed File System
         Distributed Transaction Coordinator
         DNS Client
         DNS Server
         Error Reporting Service
         Event Log
         File Replication Service
         FTP Publishing Service
         HTTP SSL
         IIS Admin Service
         Indexing Service
         Intel PDS
         Intersite Messaging
         IPSEC Services
         Kerberos Key Distribution Center
         Logical Disk Manager
         LogMeIn
         LogMeIn Maintenance Service
         Net Logon
         Network Connections
         Network Location Awareness (NLA)
         NT LM Security Support Provider
         OracleDBConsoleneo
         OracleOraDb10g_home1iSQL*Plus
         OracleOraDb10g_home1TNSListener
         OracleServiceNEO
         Plug and Play
         Print Spooler
         Protected Storage
         Remote Access Connection Manager
         Remote Procedure Call (RPC)
         Remote Registry
         Secondary Logon
         Security Accounts Manager
         Server
         Shell Hardware Detection
         SQL Server (MSSQLSERVER)
         SQL Server Agent (MSSQLSERVER)
         SQL Server Analysis Services (MSSQLSERVER)
         SQL Server FullText Search (MSSQLSERVER)
         SQL Server Integration Services
         SQL Server Reporting Services (MSSQLSERVER)
         Symantec AntiVirus Server
         System Event Notification
         Task Scheduler
         TCP/IP NetBIOS Helper
         Telephony
         Terminal Services
         Windows Management Instrumentation
         Windows Search
         Windows Time
         Workstation
         World Wide Web Publishing Service
      
      The command completed successfully.
      means my agent was stop but now i start it.

      i find on Google that this type of error happen when you change in database like ip address, sid etc but i haven't do any change.

      i am facing same problem so many times.

      Now how to reschedule the existing backup job so that it starts work again.

      thanks
      umesh
        • 1. Re: rman backup job Suspended on Agent Unreachable
          damorgan
          Most of what you posted doesn't help with the problem. But given that you can drop the existing agent and create a new one in just a few minutes I would recommend that or opening an SR at metalink.

          But nowhere in what you posted do I see evidence that you checked the status of the current agent or attempted to restart it. What did you actually do?
          • 2. Re: rman backup job Suspended on Agent Unreachable
            615123
            thanks for reply

            i use
            ecctl status agent
            
            then
            
            emctl start agent.
            please again have a look what i sent in my last post

            and another issue is how to reconfigure backup or i need to create new.

            and why this error occurs.

            thanks

            Edited by: Umesh Sharma on Mar 24, 2009 1:12 AM
            • 3. Re: rman backup job Suspended on Agent Unreachable
              oradba
              I see you have Database Control (standalone Enterprise Manager), not grid control. In this case the agent is an integrated part of dbconsole,not an independent utility like in grid control. You can check its status inside dbconsole,but neither start nor stop it separately. 'emctl status agent' shows 'not running', what does 'emctl status dbconsole' return? You may stop and restart dbconsole,sometimes it's a temporary problem,especially on Windows.

              Werner
              • 4. Re: rman backup job Suspended on Agent Unreachable
                615123
                thanks Werner

                my problem is basically how to reconfigure existing scheduled job which i configure for rman backup and if possible how to avoid this problem.


                Suspended on Agent Unreachable
                • 5. Re: rman backup job Suspended on Agent Unreachable
                  oradba
                  You need a running dbconsole in order to access the job system ,the agent is a part of dbconsole,but sometimes it crashes independently. Stop dbconsole and try to restart it, if it fails you have to examine the logfiles.

                  Werner
                  • 6. Re: rman backup job Suspended on Agent Unreachable
                    615123
                    thanks for reply

                    i do it.
                    C:\Documents and Settings\Administrator>emctl status dbconsole
                    Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
                    Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
                    http://Techwave:5500/em/console/aboutApplication
                    EM Daemon is not running.
                    ------------------------------------------------------------------
                    Logs are generated in directory C:\oracle\product\10.2.0\db_1/Techwave_neo/sysman/log
                    
                    C:\Documents and Settings\Administrator>emctl stop dbconsole
                    Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
                    Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
                    http://Techwave:5500/em/console/aboutApplication
                    The OracleDBConsoleneo service is stopping.....
                    The OracleDBConsoleneo service was stopped successfully.
                    
                    
                    C:\Documents and Settings\Administrator>emctl start dbconsole
                    Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
                    Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
                    http://Techwave:5500/em/console/aboutApplication
                    Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoleneo service is starting................
                    The OracleDBConsoleneo service was started successfully.
                    now it is working fine.

                    now issue is how i reschedule my suspended job.

                    i got this error.

                    Edit is not supported for this job type, only general information about the job can be updated No scheduled executions - this job can not be modified.