Back
 

Free Health Check and Monitoring

iWare Logic > Services  > Oracle DBA and Apps DBA Remote Support > Free Health Check and Monitoring

Free Monitoring Services

** Errors/Problems found while monitoring can be fixed on agreed rates by mutual acceptance.

Click below to access the respective topics:

1. Why are we doing this for Free?
2. Key Statistics
3. Steps Involved In Free Oracle Database & Oracle Apps (E-Business) Database Monitoring
4. Deliverables in Free Oracle Database & Oracle Apps (E-Business) Database Monitoring
5. Assumptions & Terms of Services
6. Free Oracle Database & Oracle Apps (E-Business) Database Monitoring Services Are Available Only For Remote Model

Core Databases
Following things will be covered under health check
1) Checking of Oratab files
2) Review of Oracle Parameters
a) Init.ora parameters
b) Listener.ora parameters
c) Sqlnet.ora parameters
d) SQL Optimizer parameters
3) Review of Tablespace Setup
a) ASSM (beyond 9i)
b) LMT
4) Checking Dumps, Trace files
Free Monitoring – Under Free Monitoring 16×5 basis, following things can be covered
1) Space Monitoring
2) User Monitoring
3) Instance Details like SGA, Wait Events, Sessions Activities
4) Resource Hungry Programs
5) Resource Usage
Health Check – Apps  Databases
Under Free Health Check following things will be covered
1. Checking of Oratab files
2. Review of Oracle Parameters
a. Init.ora parameters
b. Listener.ora parameters
c. Sqlnet.ora parameters
d. SQL Optimizer parameters
3. Review of Tablespace Setup
a. ASSM (beyond 9i)
b. LMT
4. Checking Dumps, Trace files
5. Checks on Custom Databases
6. Password security
7. Health of Concurrent Managers
8. Profile options
9. Password Policies
10. Logs rotationsFree Monitoring – Under Free Monitoring 16×5 basis following things can be covered.
1. Space Monitoring
2. User Monitoring
3. Instance Details like SGA, Wait Events, Sessions Activities
4. Resource Hungry Programs
5. Resource Usage
6. Concurrent Managers Monitoring
7. Schedules Requests monitoring
8. Oracle Apps Front End User Monitoring
9. Workflow process monitoring.
10. Checking concurrent request.
11. Monitoring DMZ node.
12. Monitoring Database Listeners.
13. Disk space monitoring on Application and DB Node.
14. Monitoring Load on Application and Database servers.
15. Monitiroring Workflow Notification mailer.
16. Monitoring Invalid Objects.
17. Monitoring Alert Log file
18. Monitoring Startup and shutdown Logs.
19. Monitoring ASM Disk.
20. Monitoring RAC Processes.
21. Monitoring Backups.
22. Monitoring Long Running Sessions.
23. Monitoring top SQL Consuming Queries.
24. Monitoring Trace Location.
25. Monitoring Archive log Destination for space.
26. Monitoring through any third party utility if nay implemented eg Nagios, Foglight etc.
27. Report of Tickets open and Closed.
28. Monitoring Tablespace Free Space.
29. Monitoring Database Locks.
30. Monitoring Cache Hit ratio.

Free Oracle Database & Oracle Apps (E-Business) Database Monitoring Services

1. Why are we doing this for Free?
  • Demonstrate our Capabilities
  • Build strong Client Relationship
  • Explore opportunities for paid services
  • Promote Oracle Licences (For Clients who need it)
  • Social Service by offering Free Services to NGO and Non-Profit Social Organizations

Back to Top

2. Key Statistics:

About iWare Logic (Credentials):

Back to Top

3. Steps Involved In Free Oracle Database & Oracle Apps Database Monitoring:

Pre-requisites, Steps Involved, Our Approach:

  • NDA – Sample on Request
  • VPN Connectivity (Security concerns)
  • Authentication
  • Health Check Activity (One Time)
  • Report
  • Discussions Close

If Satisfied – Do it for Production environment

** What do we mean by Free Monitoring?

  • We need access to test servers

 

Pre-requisites, Steps Involved, Our Approach:

  • NDA – Sample on Request
  • VPN Connectivity
  • Authentication

Back to Top

4. Deliverables in Free Oracle Database & Oracle Apps Database Monitoring:

** Deliverables from iWare Logic (Oracle E-Business Suite Database):

  • Report (Health Check) One Time
  • Suggestions about Critical Areas
  • Sample Report Download

 

Deliverables from iWare Logic (Free Monitoring):

  • Pro-active suggestions
  • Suggestions as Best Practices
  • Sample Report Download (Upon Request)

Back to Top

5. Assumptions & Terms of Services:

Key Assumptions:

The following assumptions will guide the services as defined within this Scope of Work:

  • Client will provide iWare Logic team access to appropriate facilities such as Internet access Manuals, TRMs, Implementation related documentation and communication, etc., as required
  • Client has relevant support & licenses of Oracle Server to get desired services from Oracle Corporation
  • Availability of Domain Experts from is must during the activity to ensure the required progress in assigned task
  • Start and End timings of the above services will be based on Service schedule established between Client and iWare Logic.

 

Terms and Conditions:

  • This contract is valid for services to be performed for Remote Support only
  • The Support is on 16×5 basis (The 2 shifts as per IST)
  • iWare Logic will deploy the required strength of DBA, Apps DBA Team for supporting
  • Any problems in relation to the Hardware, Connectivity, Network environment or any other applications are not within the scope of our proposal
  • iWare Logic would not be responsible for problem solving delays caused by connectivity problems, authentication failures etc.
  • Term contract – 3 months. This agreement shall remain in effect for 3 months, can be terminated by either side with 15 days written notice period
  • Based on the review after one Quarter further Contract Period will be renewed
  • Resource rotation: iWare Logic will try its best to retain the same team members for Remote Support, but however, due to any unavoidable circumstances, iWare Logic, at times, can rotate its DBA / Apps DBA / Technical team. These team members will have a similar level of experience and expertise in Oracle Database Administration 8i, 9i, 10g, 11g etc. and Oracle Applications 11i and R12. This rotation will be however be kept at minimum frequency.

Back to Top

6.Free Oracle Database Monitoring Services Are Available Only For Remote Model

** We will do the monitoring of the Servers for:

 

** After 5 days, discuss on the Outcomes:

  • If found satisfactory
  • Go for Production with detailed discussion between both the parties
  • For One Quarter
  • With One month work
  • Decision on issue resolution mechanism and Rate Card
  • Review after One Quarter

We can also resolve the issues and provide advice on Performance Improvement.

For details contact info@iwarelogic.com