Toad 11 is out!

OpenWorld season is open, while Oracle announced linux database appliance, Quest launched Toad11 ! I have been actively beta-testing toad 11 and I am excited to download it. 421Mb for the 11.0 Commercial installer, 41Mb for the READ-ONLY version 🙂

On the number of installed components

I recently posted about network fained fine grained security. More precisely, I posted about the new requirement to have XDB to be able to send a mail or do a nslookup on 11g. What option should you install on your database ? SQL> select COMP_NAME,VERSION from DBA_REGISTRY; COMP_NAME VERSION —————————————- ———- Oracle Database Catalog Views […]

how to run UTL_TCP, UTL_SMTP and the like in 11g

After we upgrade a db to 11g someone complained about an ORA-24248: XML DB extensible security not installed I thought, it should be easy to revert to 10g mechanism. Probably wrong after reading Marco : The default behavior for access control to network utility packages has been changed to disallow network operations to all nonprivileged […]

Do not upgrade to

If you do run @?/rdbms/admin/catupgrd for an Oracle Home on a, you may later realize some objects are missing (probably related to deferred segment creation). SQL> delete from t1 2 where id in ( 3 select from ca, p 4 where p.no_form like ‘%02.98’ 5 and = ca.prod_id 6 ); delete […]

How to change the connection string of the Oracle Enterprise Manager Grid Control 11g repository

If you moved your repository to a new host and want to change the connection string, no need to drop it, no need to messup in the properties or xml files, simply read the doc emctl config oms -store_repos_details (-repos_host -repos_port -repos_sid | -repos_conndesc ) -repos_user [-repos_pwd ] [-no_check_db] Yes it works!