AskDba.org Weblog » Entries tagged with "11g"
Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password
You have been asked to schedule a shell script which need to connect to a particular user and perform some action? How do you pass the password to script without hardcoding it in script. If password is written in a script, isn’t it a security threat? Well with 10gR2 , Oracle Wallet provides you with facility to store database credentials in client side Oracle Wallet. Once stored, you can connect to database using sqlplus /@connect_string Let’s see … Read entire article »
Get Upgrading: Steps To Upgrade To 11gR2
As 11gR2 is out for Linux, I decided to upgrade one of my existing 10.2.0.3 database to 11.2.0.1 to get the look and feel of 11gR2. Direct upgrade to 11gR2 is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher and 11.1.0.6 or higher. If you have a database 9.2.0.6 then first you need to upgrade to intermediate release i.e 9.2.0.8 then to 11.2.0.1. 9.2.0.6==>9.2.0.8==>11.2.0.1 8.1.7.0==>8.1.7.4==>10.2.0.4==>11.2.0.1 I will discuss how to upgrade an existing Single Instance … Read entire article »
11gR2 Database Installation with ASM on OEL5
I will be listing down steps for 11g Release 2 installation on Linux x86. There has been few changes incorporated in 11gR2 which must be given due consideration before starting installation. ASM instance now runs from new Oracle Home called Grid Infrastructure. If you wish to use ASM for storing database files, then you should install first Oracle grid infrastructure for a standalone server. It is also required if you wish to use Oracle Restart feature … Read entire article »
Oracle 11gR2 on linux is out
Oracle 11gR2 has been released for linux x86 and x86-64 platform. Software can be downloaded at http://www.oracle.com/technology/software/products/database/index.html Guys start downloading..:) .. Note: – As of now documentation link is not available on http://tahiti.oracle.com (13:30 G.M.T) Update : – Thanks to H.Tonguç , documentation can be accesed at http://www.oracle.com/pls/db112/homepage?remark=tahiti Cheers Amit … Read entire article »
GATHER_STATS_JOB – Is it enabled?
Few days back , Martin had posted a series of post on a issue where GATHER_STATS_JOB was failing silently for a large object. If you have missed it, you can check following links Automated statistics gathering silently fails http://mwidlake.wordpress.com/2009/07/20/automated-statistics-gathering-silently-fails/ Automated Statistics Gathering Silently Fails #2 http://mwidlake.wordpress.com/2009/07/23/automated-statistics-gathering-silently-fails-2/ Automatic Statistics Gathering Fails #3 http://mwidlake.wordpress.com/2009/07/29/automatic-statistics-gathering-fails-3/ Automated statistics gathering silently fails Automated Statistics Gathering Silently Fails #2 Automatic Statistics Gathering Fails #3 This post is based on some of the discussions on the thread. Please note that this is not intended to discuss bugs (if any) associated with the job Gather_stats_job was introduced with Oracle 10g to gather statistics for database objects which has stale statistics (10% of data has changed, you can query dba_tab_modifications) or the tables for which the statistics has not been gathered (new tables … Read entire article »
Failed dependencies error: lib* needed by unixODBC-devel-2.2.11-7.1.i386
While trying to install 11gR1 on Oracle Enterprise Linux (OEL5), runInstaller failed for unixODBC* packages. To solve the issue , I started following OTN article http://www.oracle.com/technology/pub/articles/smiley-11gr1-install.html When trying to install RPM from CD3, faced following errors for unixODBC* rpm #rpm -ivh compat-libstdc++-33* libaio-devel* sysstat* unixODBC* warning: compat-libstdc++-33-3.2.3-61.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 error: Failed dependencies: libboundparam.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libesoobS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libgtrtst.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libmimerS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libnn.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbccr.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcdrvcfg1S.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcdrvcfg2S.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcinst.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcminiS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcnnS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbctxtS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 liboplodbcS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 liboraodbcS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libsapdbS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libtdsS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libtemplate.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 unixODBC = 2.2.11-7.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbc.so.1 is needed by … Read entire article »
Subscribe To Feed
License
AskDba.org Forum
- Mahesh.G on "DR rebuild- Data restore issue" March 11, 2010
- Saurabh Sood on "DR rebuild- Data restore issue" March 11, 2010
- sunkkuma on "DR rebuild- Data restore issue" March 11, 2010
- Amit Bansal on "DB and Listener availability monitoring script" March 11, 2010
- animesh on "DR rebuild- Data restore issue" March 11, 2010
Recent Comments