Posted by Kashif Manzoor on 26th June 2013
Finally long-awaited Oracle 12c database is now available for download, according to the Oracle’s website. You can find initial announcement of Oracle Database 12c during OpenWorld 2012 from my previous blog Recap of OpenWorld 2012
Formal product details as per Oracle website:
||Consolidating multiple databases with Oracle Multitenant
||Automatically optimizing data storage and compression according to usage patterns
||Providing continuous access with Oracle’s Maximum Availability Architecture
||Securing enterprise data with comprehensive defense-in-depth strategy
||Simplifying in-database analysis of Big Data
||Efficient database management using Enterprise Manager Cloud Control
Oracle product info from following link:
You can also find following white papers;
Tags: 12c, Oracle Database
Posted in Database 12c | No Comments »
Posted by Kashif Manzoor on 23rd June 2013
Oracle eBusiness R12 Inventory Analyzer is a script delivered by eBusiness suite Support team for quick health checkup of most common Inventory issues usually facing by different customers, this will enable Support team to understand the basic footprint environment.
The eBusiness Inventory Analyzer sql script will review generally following:
- Inventory setup,
- Patch levels,
- Runtime tables,
It also provides helpful feedback and references on Best Practices for areas of disquiet on eBusiness Inventory module. Inventory Analyzer script does not replace existing available diagnostics, health checks, or wizards; however it is a good new addition to help in managing the overall health of Inventory Module. Many of existing scripts are combined in Inventory Analyzer as one validation script.
Let’s have a look of this tool, how to execute, we will go through step by steps
1-Down Load from MOS Note: Inventory Analyzer : Health Check For Common Inventory Data Issues, Critical Patches, And Setups [ID 1499475.1]
2-Place into your application node at custom top like xxcustom through toad ftp or winscp.
3-connect to sql and go to your custom location and run the SQL Inventory Analyzer script.
4- eBusiness Inventory Analyzer will create file with the name of inv_analyzer_<host> _<instance>_2013-Jun-23
5-ftp output of Inventory Analyzer to your local machine and open it. First part of report will show the table of contents
In this example under Critical/Recommended Patches section, this report is showing priority patches which are missing on the environment and should be applied. You can go through Abstract column of each patch descriptions.
Under Data issues section, we can see highlighted issues are on serial no 6 Lot number with leading/trailing spaces issue exists and on serial no 19 Negative TRANSACTION_SOURCE_ID and even this script will analyze the Performance of the modules, you can refer Performance section with the suggestion to what action should be performed.
MOS Note: Inventory Analyzer : Health Check For Common Inventory Data Issues, Critical Patches, And Setups [ID 1499475.1]
Tags: health check, Inventory, Inventory Analyzer
Posted in Inventory | No Comments »