Our BPPM Webinar series hosted by Subject Matter Experts will resume in the near future, be sure to stay tuned for the dates and topics for our Webinar series. If you have ideas about topics of interest you would like us to elaborate on, please let us know and we will investigate.
Trending this month: Database Questions
There have been issues opened around the BPPM Database, database version, questions on whether it can be migrated from Sybase to Oracle and vice versa. So here are a few database basics to help in case you were wondering.
You can use either Sybase or Oracle as the BMC ProactiveNet database. You can use the Installation Guide as your reference to install either an Oracle backend or a Sybase backend. Sybase is integrated with BMC ProactiveNet.
See “Installing BMC ProactiveNet Server with Oracle as the database” on page 58 of the BMC ProactiveNet Installation and Configuration Guide available on our Support Web Site http://webapps.bmc.com/support/faces/az/prodversion.jsp?prodverseqid=316178&ic=0
If you are using Sybase ASA as the BMC ProactiveNet Database on a UNIX or Linux operating system, follow the appropriate steps for your shell to set up the environment so that you can run the Sybase client. This is detailed starting on page 113 of the ProactiveNet Installation and Configuration Guide mentioned under “Configuring the Sybase environment on UNIX or Linux”
There have been several questions about migrating the ProactiveNet database from one platform to another. For example: Is it possible to migrate BPPM from the embedded Sybase database to an Oracle database?
There is no in-house or other BMC supported mechanism to migrate from Sybase to Oracle with BPPM. If you wish to move from Sybase to Oracle backend, a fresh install of BPPM would need to be performed.
We also see version questions about different database platforms, for example: What are the supported Oracle database versions for BPPM versions 8.6.02 and 9.0.00? Does BPPM support Oracle version 188.8.131.52?
BPPM versions 8.6.02 and 9.0.00 supports Oracle version 184.108.40.206 and higher (within Oracle 11g). BMC does not validate every patch version and the assumption is that Oracle would not regress. While there are no known conflicts with Oracle 11g R2 Patch 3 (220.127.116.11), only Oracle 11g R2 Patch 2 (18.104.22.168) has been tested and validated by QA.
***NOTE*** BMC Software recommends that you back up the database regularly. Use any of the following utilities to create a backup of the BMC ProactiveNet database and restore the database when necessary:
BMC Database Recovery Manager for Oracle
Any other Oracle recommended backup and recovery utility
Here are a few of our Knowledge Articles specifically about databases in ProactiveNet:
KA350479 - Command Syntax and Parameters for Database Validation using 'pw database validate' or 'dbvalid'
KA356762 - How to check the data collection in BPPM database
KA350682 - How can I install BPPM 8.6 with Oracle as the backend database? How can I specify it is an Oracle RAC database?
KA315829 - What is the default username/password for the ProactiveNet (Sybase) database?
KA316091 - Is it possible to export BMC ProactiveNet Performance Manager (BPPM) data to an external database?
KA329501 - The BPPM 'pw database archive' command returns error on windows.
KA313513 - How to backup ProactiveNet database while database is running?
KA311853 - What is the procedure to rebuild the ProactiveNet Database?
As you can see there are many questions about the ProactiveNet Database, if you have one that needs to be answered, please do not hesitate to contact firstname.lastname@example.org, call us at 1-800-537-1813, or Chat with us online from various access points via www.bmc.com/support
Here are some of our general knowledge articles which have been helpful to other customers. Take a look to see if they may help you.
Popular Knowledge Articles:
KA355029- ProServices.log in a clustered environment shows "MCELL service is Not running" and "A CELL service is Not running"
KA287306 - How to Delete ProactiveNet Auto Sync Monitor Instances and devices from the system with respect to BMC Patrol Adapters?
KA317405 - Unable to add remote device or agent to BMC ProactiveNet Performance Management.
KA328879 - BMC ProactiveNet Performance Manager unable to authenticate with LDAP server. LDAP user groups are not returned.
KA346952 - ProactiveNet takes a long to time start.
BMC Ideas is a new way to provide enhancement requests within our growing BMC Communities. We are offering you the opportunity to submit on and vote for your requests for enhancement for your favorite BMC Products! Check out these short video presentations detailing how to get started with BMC Ideas.