Quick tips on Cloning OracleCloning is not cross platformClone usually is done in 2 phases - prepare_clone.pl in source and clone.pl in targetClone does take care of inventory and relink so further patches can be applied on the new cloned homeFor Oracle database and CRS, prepare_clone.pl is not requiredORACLE_HOME and ORACLE_HOME_NAME should be specified when clone.pl is run, in 11g, ORACLE_BASE should be specified alsoIf Oracle inventory is...
Virtualization on Oracle Database Appliance (ODA) As you know, Early this year Oracle started supporting virtualization on Oracle Database Appliance which enhances the functionality of ODA. One of the main usage of this virtualization is to utilize ODA for Weblogic as well as database. I had a chance to test various Weblogic offerings on ODA and I thought to share my findings with readers, hopefully it helps readers with planning...
Become Golden DBA for GoldenGate environment (Basic) Become Golden DBA for GoldenGate environment is delivered in OOW2013 and more topics around this will come which include but not limited to the following : Golden DBA for 2 way GoldenGate replicationGolden DBA and troubleshooting GoldenGateGolden DBA and advanced configuration on GoldenGateGolden DBA and Tuning GoldenGateFor those of you who joined the session or would like to follow up,...
GoldenGate DDL replicationI have to setup a DDL replication for a customer and as usual I use include to filter schema which I want to be replicated as below :'DDL &INCLUDE ALL OBJNAME "SCHEMA1.*" &INCLUDE ALL OBJNAME "SCHEMA2.*" &EXCLUDE OBJTYPE SEQUENCE Interesting enough, I see that GoldenGate does not capture DDL although the filter should work fine. The following is reported in GoldenGate log with my surprise : Oracle...
ODA and CPU licenseLast week, I was working on a customer with ODA x4-2 which we found 5 CPU licenses are sold for EE deployment. My first reaction was on how to put 5 CPU license (10 cores) in ODA x4-2. As you may know, the multiplier of 4 cores can be activated in X3-2 and above and multiplier of 2 in ODA v1. In this post, I am trying to explain what is the minimum core requirement for various ODA server with virtualized and non-virtualized...
Quick tips on WeblogicVery often I login to a customer site and I end up to search in document for couple things :How to setup NodeManager so the customer could use Admin console for Weblogic startupHow to make username/password encrypted so the command line does not ask for username/password at time of startupQuick and easy guideline for patchingHow to check Weblogic versionAbove items are nothing new but I thought to post details here for my quick...
Documents for Oracle licensingIf you negotiate with Oracle on licensing or design/architect a solution for a customer, the following documents may come handy : Oracle process core factor : http://www.oracle.com/us/corporate/contracts/processor-core-factor-table-070634.pdfOracle software technical support policies : http://www.oracle.com/us/support/library/057419.pdfOracle partition policy : http://www.oracle.com/us/corporate/pricing/partitioning-070609.pdfLicensing...
Oracle Database Appliance - 3 Observations and 3 ResolutionsDuring last couple weeks, I have been involved in various ODA activities from patching of an existing ODA to latest version to setting up new environments on ODA X5-2I thought to share some lesson learnt : 1) Patch failure If you encounter in a situation which ODA patch fails and reports the following error Unable to get the nodenumber in the chassisThe resolution is to create /opt/oracle/oak/conf/node_num.conf on...
TIP 117#: Access to ODA ILOM is challenging ?New ODA is configured with ILOM IPs and network cable is plugged to Netmgt port. Everything is ready for connecting to the server via ILOM and bummer!, you may see the whole connection or at least the connection to remote console does not work as it is expected.The following item could come handy to troubleshoot and fix the issue:ILOM client requirements:Per the following link, the client access...
Subscribe to:
Posts (Atom)