Articles Comments

AskDba.org Weblog » Archive for May 2009

Silent Install :OUI-10133:Invalid staging area Error

May 27th, 2009 | 1 Comment

While using silent install for database software installation , you could encounter following errors SEVERE:OUI-10133:Invalid staging area. There are no top level components for IBM SP AIX available for installation in this staging area. This error is reported when OUI is unable to find products.xml file. Check response file for FROM_LOCATION parameter and see if it is correct and Oracle software owner has read permission on this file. In my case it was set to /oracle/dump/Disk1/database/stage/products.xml but the actual file was present at /oracle/ora10g/Disk1/database/stage/products.xml ls -l "/oracle/ora10g/Disk1/database/stage/products.xml" -rwxr-xr-x 1 ora10g oinstall 804962 Aug 20 2005 /oracle/ora10g/Disk1/database/stage/products.xml Modify the FROM_LOCATION to correct value and re-run the installation. It should go fine. This parameter can have incorrect settings when you have copied the response file from $media/response/*rsp to … Read entire article »

Filed under: Install, oracle

You Don’t need SysDBA privilege to run Awrrpt..

May 8th, 2009 | Add a Comment

Well I tried to Sensationalize this post by using such a heading Though I just wanted to point out that Awrrpt script can be run without sysdba privilege too. Actually if you open awrrpti.sql script , it contains following line Rem NOTES Rem Run as SYSDBA. Generally this script should be invoked by awrrpt, Rem unless you want to pick a database other than the default. In actual you need only two privileges to run the script. One is SELECT_CATALOG_ROLE and other is execute permission on dbms_workload_repository procedure. If you don’t give privilege explicitly on this package you get following errors select output from table(dbms_workload_repository.awr_report_text( :dbid, … Read entire article »

Filed under: database, oracle