tag:blogger.com,1999:blog-81191512661415952142024-02-20T19:22:38.802-08:00Oracle - Let us make it easyHi Readers,
I want share my Oracle learning with all oracle users/ developers/DBAs and Oracle lovers.
if you would like to learn or know any oracle database feature , please leave me a comment will try to explore and post my experience ~AjayAJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-8119151266141595214.post-43681564354482179482010-03-29T13:21:00.001-07:002010-03-29T13:21:07.156-07:00<span xmlns=''><p>How to Customize Autoconfig in Oracle Apps 11i on Unix <br /></p><p>Step1: identify the configuration file you would like to customize<br /></p><p> for example jserv.properties <br /></p><p>Step2: Find out the template file related to jserv.properties<br /></p><p>Use the following script to find out the template file.<br /></p><p>$AD_TOP/bin/adtmplreport.sh contextfile=$CONTEXT_FILE target=$IAS_HOME/Apache/Jserv/etc/jserv.properties<br /></p><p>For Unix the output of above command is $FND_TOP/admin/template/jserv_ux_ias1022.properties <br /></p><p>Note: out put varies based on your OS <br /></p><p>Step3: Create custom directory under $FND_TOP/admin/template<br /></p><p>Ex: cd $FND_TOP/admin/template<br /></p><p>Mkdir custom<br /></p><p>Step 4: copy the template identified in step 2 to custom directory <br /></p><p>Cp $FND_TOP/admin/template/jserv_ux_ias1022.properties $FND_TOP/admin/template/custom<br /></p><p>Step 5: Adding Customization to template file.<br /></p><p>Add customization to $FND_TOP/admin/template/custom/jserv_ux_ias1022.properties file. Save and exit.<br /></p><p>Step6: Run autoconfig to reflect the changes.<br /></p><p>Autoconfig file can be found in $COMMON_TOP/admin/scripts/SID_Servername/adautocfg.sh<br /></p><p>Depends on your environment above steps may vary , please ensure to implement this solution in test before making any changes to production.<br /></p></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-26821338130357158732010-03-22T14:28:00.001-07:002010-03-22T14:31:01.252-07:00<span xmlns=''><p>After long time I got some time and have plan to post my leanings. Over the past one year I have learnt oracle Apps administration. Maintaining Apps is quite challenging and very interesting. <br /></p><p>In nutshell Oracle apps is a perfect environment to learn Database and Web Servers administration. <br /></p><p>Oracle Apps DBA is a huge task Where to start ? I would say start with Apps concepts <br /></p></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-18576437840237025502008-12-04T21:44:00.000-08:002008-12-05T18:24:35.423-08:00ORA-12514 TNS: listener could not resolve SERVICE_NAME given in connect descriptor<p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">This can occur when you directly connecting to database or when you try to access remote database using dblink.<br /></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">When you encounter this error first thing we should collect the following information from init.ora file.<br /></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">1.DB_NAME<br /></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">2.DB_DOMAIN</span></span></span></span></span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">3.SERVICE_NAME </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">assume that your DB_NAME value is “smplorcl” ,DB_DOMAIN is “world” and SERVICE_NAME value is “smplorcl.world”</span></span></span></span></span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"><br /></span></span> </p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">above values also can be obtained using show parameter command from SQLPLUS </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"><br /></span></span> </p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Ex: sql> show parameter DB_NAME</span></span></span></span></span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Next you need to find out the current services registered with listener.<br /></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Lsnrctl services <listener_name><br /></listener_name></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">LSNRCTL> services listener<br /></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">1. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1545)) </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">2. Services Summary... </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">3 .Service "smplorcl" has 1 instance(s). </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">4. Instance "smplorcl", status READY, has 1 handler(s) for this service... </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">5. Handler(s): </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">6. "DEDICATED" established:0 refused:0 state:ready </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">7. LOCAL SERVER </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">8. Service "smplorcl.world" has 1 instance(s). </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">9. Instance "smplorcl", status READY, has 1 handler(s) for this service... </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">10. Handler(s): </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">11."DEDICATED" established:0 refused:0 state:ready </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">12.LOCAL SERVER </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Note : I have given lines numbers for each lane in listener services output.<br /></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Now compare your service name value you have obtained from init.ora is matching with lane number 8 value . If not<br /></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">you need to make changes to init.ora or tnsnames.ora (if your init.ora has right service_name then you change your tnsnames.ora SERVICE_NAME parameter value or Vice versa) </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"><br /></span></span> </p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"><a name="top"></a> </span></span><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">this error also can occur when yo accessing remote databases using dblibk. To verify tnsname alias first test the tnsname alias by using it to connect in SQLPLUS directly . If you still get this error , that means you have issues with your tnsnames, first correct tnsnames issue.</span></span></span></span></span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"><br /></span></span> </p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">If your SQLPLUS connection is successful then you need to verify db_link connection parameter values </span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">query </span></span></span></span></span></span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">dba_db_links database table.</span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"><br /></span></span></p> <pre style="text-align: left; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Select db_link,host from dba_db_links;</span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">from the above output verify your host value is identical to your remote </span></span></span></span></span></span></span></pre><pre style="text-align: left; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">TNSNAMES ALIAS parameter values, verify the domain reference also , this should include “world” part in </span></span></span></span></span></span></span></pre><pre style="text-align: left; widows: 2; orphans: 2"><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">the domain name</span></span></span></span></span></span></span></pre><pre style="text-align: left; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"></span></span><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">ex: smplorcl.world.</span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span><span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Also try restarting listener and give some time for listener to register service names .</span></span></span></span></span></span></span></pre><p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><span class="Apple-style-span" style=" white-space: pre; font-family:-webkit-monospace;font-size:13px;"><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style=" ;font-family:verdana;"><span class="Apple-style-span" style=" ;font-size:16px;">Hope my notes help you resolving </span></span></span></span></span></span><span style="color:#000000;"><span><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style=" ;font-family:verdana;"><span class="Apple-style-span" style=" ;font-size:16px;">ORA-12514 error.</span></span></span></span></span></span></span><br /></p><pre style="text-align: left; widows: 2; orphans: 2"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"></span></span><span style="color:#000000;"><span><span style=""><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">Reference document URL.</span></span></span></span></span></span></span><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;"> </span></span></pre><p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"> <a href="http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/config_concepts.htm"><span style="color:#2a5db0;"><span><span style=""><span style="font-style: normal"><span style="font-weight: medium"><span class="Apple-style-span" style="font-family:verdana;"><span class="Apple-style-span" style="font-size:medium;">http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/config_concepts.htm</span></span></span></span></span></span></span></a></p>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-37681791965304423632008-11-05T21:03:00.001-08:002008-11-08T11:47:11.747-08:00Undo Management<p align="LEFT" style="margin-bottom: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"><span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">My Understanding on undo Tablespace and Rollback segments.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">Undo table space concept released with Oracle 9 Version , prior to 9 DBA used to manage undo management through rollback segments. It was a cumbersome process for DBAs to manage rollback segments especially sizing rollback segments.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">From Oracle 9i onwards Oracle came up with a good solution called undo tablespace where DBA does not require to worry Undo management.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">But Oracle still have the rollback segment in 9i as well as in 10g and 11g for backward compatibility. In 10g and 11g still oracle use rollback segment concept but this exclusively used by Oracle at the time of database creation. In 10g or 111g rollback segments are created and managed by oracle software and they are stored in SYSTEM tablespace, this is because at the time of database creation they may not be a undo tablespace.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">Init.ORA Undo parameters .</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">The following undo parameter controls undo management .</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">UNDO_MANAGEMENT : Possible values are 'AUTO' or 'MANUAL' , you basically speicy which undo management mode oracle database should use . If you specify AUTO database will be starting in automatic undo management mode.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">UNDO_TABLESPACE : You specify the tablespace name as a parameter value if your undo management mode is automatic. It is not a mandatory parameter though, if you forget to specify undo tablespace name , database still start with out any startup errors but you still see errors/Warnings in the Alert log. If instance starts without undo tablespace user transaction will be using rollback segment created in system to manage transaction undo data. Oracle strongly recommends not use Rollback segments created in System tablespace. Undo tableapce parameter can be modified using Alter system table space command.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">UNDO_RETENTION : Undo retention specified in seconds , Number of seonds to keep expired transaction data( undo data). default value is 900 seconds, this can be changed using alter system command.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"><br /></p> <p align="LEFT" style="margin-bottom: 0in; border: none; padding: 0in; font-style: normal; font-weight: medium; widows: 2; orphans: 2"> <span style="color:#000000;"><span style="font-family:Georgia, serif;"><span style="font-size:100%;">Will write more undo in the next posting.</span></span></span></p> <p align="LEFT" style="margin-bottom: 0in; widows: 2; orphans: 2"><br /></p>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-43691846637767908212008-10-31T19:00:00.000-07:002008-10-31T19:01:11.006-07:00Init.ora Data Dictionary Views<span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 13px; line-height: 19px; "><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">he following Data Dictionary Views provides complete list of init.ora file parameters currently set /used in the databases. for all RAC environments query gv$parameter, gv$parameter2, gv$spparameter other environments query v$parameter ,v$parameter2, v$spparameter</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">List of currently supported parameters can be vies using the following query</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">SELECT name, value<br />FROM gv$parameter<br />ORDER BY 1;</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">I strongly recommend to use GV$ views to view all data dictionary data in NON-RAC Environment also, because when you start working on RAC environment you do not have to learn or query a different views.</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">List of all parameters those you can modify using alter system command</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">SELECT name, value<br />FROM gv$parameter<br />WHERE isdefault = 'FALSE'<br />ORDER BY 1;</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">List of obsolete parameters in any environment can be found using</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">SELECT * FROM gv$obsolete_parameter ORDER BY 1;</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">You can also use <span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; ">v$spparameter</span> data dictionary view for complete list of parameters set by SPFILE and PFILE</span></p></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-41955405890719199022008-10-31T18:44:00.001-07:002008-10-31T18:44:20.055-07:00Know your INIT.ora<span class="Apple-style-span" style="font-family: 'Times New Roman'; "><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font: normal normal normal 13px/19px 'Lucida Grande', 'Lucida Sans Unicode', Tahoma, Verdana, sans-serif; padding-top: 0.6em; padding-right: 0.6em; padding-bottom: 0.6em; padding-left: 0.6em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-position: initial initial; "><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">The "init.ora" file is a parameter file that is used to startup the database. based on the database setup we can modify these parameters. The "init.ora" file is a template file is supplied with oracle software.</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">This file can be found in</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">the "ORACLE_HOME/dbs" directory on unix platforms and on Windows this can be found in ORACLE_HOME/database.</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); "> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">Filename would be initORACLE_SID.ora file ( here SID means System Identification)</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); "> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">How do i find out if my database using IFILE or SPFILE</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); "> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">connect as sqlplus "as sysdba"</span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">at the SQL prompt</span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">SQL> show parameter ifile;</span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); "> </span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "><span mce_style="color:#000000;" style="color: rgb(0, 0, 0); ">SQL> show parameter spfile</span></span></span></p><div><span mce_style="color:#333399;font-family:Courier;" style="color: rgb(51, 51, 153); font-family: Courier; "> </span></div><div><span mce_style="color:#333399;font-family:Courier;" style="color: rgb(51, 51, 153); font-family: Courier; "> </span></div><p><span mce_style="color:#333399;font-family:Courier;" style="color: rgb(51, 51, 153); font-family: Courier; "> </span></p><p></p><p><br /></p><p><span mce_style="font-size:x-small;font-family:Courier;" style="font-size: x-small; font-family: Courier; ">Sample Init.ora File</span></p><p><br /></p><div><span mce_style="font-family:Courier;" style="font-family: Courier; ">#####################################################################<br /># Common parms<br />#####################################################################<br />ifile = ?/dbs/orabase-dg.ora<br />#####################################################################<br /># Structural Parms<br />#####################################################################<br />db_domain = psoug<br />db_block_size = 8192<br />db_writer_processes = 8<br />#####################################################################<br /># Identification & Control Files<br />#####################################################################<br />db_name = orabase<br />control_files = (/app/oracle/product/orabase/control.ctl<br />/app/oracle/product/databases/orabase/control.ctl)<br />#####################################################################<br /># Version Specific<br />#####################################################################<br />compatible = 10.2.0<br />#####################################################################<br /># Platform Specific<br />#####################################################################<br />disk_asynch_io = false<br />filesystemio_options = directio<br />use_indirect_data_buffers = true<br />#####################################################################<br /># Security, Audit and Resource Limit<br />#####################################################################<br />audit_trail = DB<br />resource_limit = true<br />#####################################################################<br /># NLS Settings<br />#####################################################################<br />nls_date_format = DD-MON-YYYY<br />#####################################################################<br /># Archive & Redo Logs<br />#####################################################################<br />#log_archive_dest = /app/oracle/product/flash_recovery_area/arch<br />log_buffer = 4194304 <br />log_checkpoint_interval = 1050624<br />log_archive_max_processes = 4 <br />#_log_simultaneous_copies = 48<br />archive_lag_target = 1800<br />#####################################################################<br /># Dump & Output Directories<br />#####################################################################<br />audit_file_dest = /app/oracle/product/admin/orabase/adump<br />background_dump_dest = /app/oracle/product/admin/orabase/bdump<br />core_dump_dest = /app/oracle/product/admin/orabase/cdump<br />user_dump_dest = /app/oracle/product/admin/orabase/udump<br />utl_file_dir = /app/oracle/product/admin/orabase/output<br />#####################################################################<br /># DB & Instance Limits<br />#####################################################################<br />db_files = 512<br />sessions = 4000<br />processes = 1500 <br />transactions = 200<br />#####################################################################<br /># Process & Session Specific<br />#####################################################################<br />open_cursors = 4000<br />open_links = 10<br />session_cached_cursors = 40<br />session_max_open_files = 30<br />sort_area_retained_size = 1048576<br />sort_area_size = 4194304<br />#####################################################################<br /># Buffer Pool<br />#####################################################################<br />db_block_buffers = 300000<br />db_block_checksum = true<br />db_block_checking = true_db_block_lru_latches = 2048<br />_db_block_hash_latches = 65536</span></div><div><span mce_style="font-family:Courier;" style="font-family: Courier; ">#buffer_pool_keep = (buffers:120000, lru_latches:150)<br />#buffer_pool_recycle = (buffers:55296, lru_latches:48)<br />#####################################################################<br /># Shared Pool & Other "Pools"<br /># Sort, Hash Joins, Bitmap Indexes<br />#####################################################################<br />java_pool_size = 0<br />large_pool_size = 500M<br />pga_aggregate_target = 1024M<br />shared_pool_size = 750M<br />shared_pool_reserved_size = 96M<br />streams_pool_size = 0</span></div><p><span mce_style="font-family:Courier;" style="font-family: Courier; ">_shared_pool_reserved_min_alloc = 4000<br />#####################################################################<br /># UNDO<br />#####################################################################<br /># use automatic undo<br />undo_management = 'auto'<br /># which tablespace<br />undo_tablespace = 'undo_t1'<br /># keep 8 hours (8*3600)<br />undo_retention = 28000<br />_undo_autotune = false<br />#####################################################################<br /># Parallelism<br />#####################################################################<br />parallel_max_servers = 32<br />parallel_min_servers = 0<br />parallel_threads_per_cpu = 8<br />parallel_execution_message_size = 65535<br />recovery_parallelism = 16</span></p><p>#parallel_automatic_tuning = true (deprecated in 10g)<br />#####################################################################<br /># Shared Server<br />#####################################################################<br />dispatchers="(PROTOCOL=TCP) (SERVICE=orabaseXDB)"<br />#max_dispatchers = 40<br />#max_shared_servers = 150<br />#mts_service = orabase<br />#shared_servers = 8<br />#####################################################################<br /># Job Processing<br />#####################################################################<br />job_queue_processes = 8<br />aq_tm_processes = 1<br />#####################################################################<br /># Miscellaneous<br />#####################################################################<br />background_core_dump = partial<br />db_file_multiblock_read_count = 16<br />fast_start_parallel_rollback = FALSE<br />optimizer_index_caching = 80<br />optimizer_index_cost_adj = 10<br />recyclebin = off</p><div><span mce_style="font-family:Courier;" style="font-family: Courier; ">_disable_selftune_checkpointing = true<br />#####################################################################<br /># Undocumented Parameters & Temporary Fixes<br />#####################################################################<br />_b_tree_bitmap_plans = false<br />_shared_pool_reserved_min_alloc = 4000<br />_small_table_threshold = 2560<br />_optim_peek_user_binds = false<br />#####################################################################<br /># Events<br />#####################################################################<br />#event = "600 trace name library_cache level 10"<br /># tracing PMON actions<br />#event = "10500 trace name context forever"<br />#event = "10196 trace name context forever"<br />#event = "10246 trace name context forever"<br />##event = "4031 trace name errorstack level 10"<br />#event = "10511 trace name context forever, level 2"<br />#event = "32333 trace name context forever, level 8"</span></div><div><span mce_style="font-family:Courier;" style="font-family: Courier; "> </span></div><p><span mce_style="font-family:Courier;" style="font-family: Courier; "> </span></p></div></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-81762836208468794412008-10-31T18:43:00.001-07:002008-10-31T18:43:48.938-07:00Opatch Howto<div><br /></div><div><span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 13px; line-height: 19px; "><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">How to specify different inventory location?</span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">OPatch expects the oraInst.loc file in the standard location namely<span> </span><span mce_style="color:#0000ff;" style="color: rgb(0, 0, 255); ">/var/opt/oracle/oraInst.loc</span><span> </span>however there are some systems where this file is located in a different location other than default location</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">In order to specify a different inventory location<span> </span>when you apply a patch to oracle database you can use<span> </span>inventory API flag invPtrLoc (note the case)</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;color:#0000ff;font-family:Verdana;" style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; ">opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc .</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;color:#0000ff;font-family:Verdana;" style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; "> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;color:#0000ff;font-family:Verdana;" style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; ">Errors related Ora inventory locations are</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">“OPatch would error out saying <span mce_style="color:#ff0000;" style="color: rgb(255, 0, 0); ">"Unable to access inventory</span>"<span> </span>OR <span mce_style="color:#ff0000;" style="color: rgb(255, 0, 0); ">"Couldn't find required file liboraInstaller”</span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;color:#ff0000;font-family:Verdana;" style="font-size: 10pt; color: rgb(255, 0, 0); font-family: Verdana; "> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">What is the Default Storage location of OPATCH</span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">Opatch is usually located in the <span mce_style="color:#0000ff;" style="color: rgb(0, 0, 255); ">$ORACLE_HOME/OPatch</span> directory.</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></span></p><h2 mce_style="margin:auto 0;" style="margin-top: auto; margin-right: 0px; margin-bottom: auto; margin-left: 0px; font-size: 1.5em; "><img mce_name="a" name="_Toc44869662" class="mceItemAnchor" style="border-style: initial; border-color: initial; border-top-width: 0px; border-right-width: 0px; border-bottom-width: 0px; border-left-width: 0px; border-style: initial; border-color: initial; width: 12px; height: 12px; background-image: url(http://thesimpleoracle.wordpress.com/wp-includes/js/tinymce/themes/advanced/skins/default/img/items.gif); background-repeat: no-repeat; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: initial; background-position: initial initial; " /></h2><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "> </span></span></span><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">Opatch logs are placed as follows:</span></span></p><p><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">For opatch version 1.0.0.0.xx, logs are written into the patch storage area under<span mce_style="color:#0000ff;" style="color: rgb(0, 0, 255); ">$ORACLE_HOME/.patch_storage/<bug></span> and the log in this case starts with</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;color:#0000ff;font-family:Verdana;" style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; ">"<bugnum>_Apply_<date>.log"</span></span><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; "></span></span></p><p><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; font-family: Verdana; ">For the newer opatch versions for products installed with OUI release 10.2 and after, logs are written into the cfgtoollogs/opatch area under <span mce_style="color:#0000ff;" style="color: rgb(0, 0, 255); ">$ORACLE_HOME/</span> and the log in this case starts with</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:10pt;color:#0000ff;font-family:Verdana;" style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; ">"opatch<date>.log"</span></span></p></span></div>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-57783321699442624112008-10-31T18:42:00.000-07:002008-10-31T18:43:16.664-07:00Unable to lock Central Inventory Error<span class="Apple-style-span" style="font-family: 'Times New Roman'; "><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font: normal normal normal 13px/19px 'Lucida Grande', 'Lucida Sans Unicode', Tahoma, Verdana, sans-serif; padding-top: 0.6em; padding-right: 0.6em; padding-bottom: 0.6em; padding-left: 0.6em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-position: initial initial; "><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">When YOU encounter OPATCH error "Unable to lock Central Inventory. </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_name="em" mce_style="font-style: italic;" class="Apple-style-span" style="font-style: italic; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">Opatch usually throw below error</span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">"</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">Oracle Home : /u01/app/oraprd/product/10.2.0/db_1<br />Central Inventory : /u01/app/oraInventory<br />from : /var/opt/oracle/oraInst.loc<br />OPatch version : 10.2.0.3.2<br />OUI version : 10.2.0.3.0<br />OUI location : /u01/app/oraprd/product/10.2.0/db_1/oui<br />Log file location : /u01/app/oraprd/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2007-09-22_09-50-02AM.log</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">Unable to lock Central Inventory. OPatch will attempt to re-lock.<br />Do you want to proceed? [y|n]<br />n<br />User Responded with: N<br />Unable to lock Central Inventory. Stop trying per user-request?<br />OPatchSession cannot load inventory for the given Oracle Home /u01/app/oraprd/product/10.2.0/db_1. Possible causes are:<br />No read or write permission to ORACLE_HOME/.patch_storage<br />Central Inventory is locked by another OUI instance<br />No read permission to Central Inventory<br />The lock file exists in ORACLE_HOME/.patch_storage<br />The Oracle Home does not exist in Central Inventory</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">So how do i fix this ?</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><u><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">You can do the follwing to fix this error.</span></u></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">Go to $ORACLE_HOME/.patch_stage directory see if you can directory name called 'lock' if yes remove that direcoty and re-run opatch apply command , else go to oracle central inventory directory (ex:/u01/app/oraInventory) and see if you can find out lock directory , if yes remove this and re-rin opatch apply command.</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">Else</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">export OPATCH_DEBUG=TRUE<br />and then run opatch apply.</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:8pt;color:#000000;font-family:Verdana;" style="font-size: 8pt; color: rgb(0, 0, 0); font-family: Verdana; ">this will give you the exact phase where your patch is failing</span></p></div></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com9tag:blogger.com,1999:blog-8119151266141595214.post-36289169907068754072008-10-31T18:41:00.000-07:002008-10-31T18:42:30.645-07:00ORA-02024: database link not found<span class="Apple-style-span" style="color: rgb(51, 51, 51); font-size: 22px; white-space: pre; "><span class="Apple-style-span" style="font-family: verdana;"><br /></span></span><div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Verdana; font-size: 22px; white-space: pre;"><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: 'Lucida Grande'; font-size: 13px; line-height: 19px; white-space: normal; "><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">If you are trying to drop a database link after changing the global_name of the database , you usually end up with ora-02024: database link not found</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">But when you query user_db_links</span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span><span class="Apple-style-span" style="font-family: verdana;">view you found DB link exists .</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">Possible root cause would be</span></span></span><span class="Apple-style-span" style="font-family: verdana;"><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">Initially when we create a database without domain in the global name, a null value will be used from domain as opposed to .world in Oracle releases 9i and before.</span></span></p><p><span class="Apple-style-span" style="font-family: verdana;">Later on when the global_name is altered to contain the domain part that is “world”,</span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span><span class="Apple-style-span" style="font-family: verdana;">this domain remains even when the global_name is altered back a name without domain name.</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">In order to drop the desired database link</span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">I would recommend to try this solution in Development DB then in Test </span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">And </span><span mce_name="strong" mce_style="font-weight: bold;" class="Apple-style-span" style="font-weight: bold; "><u><span class="Apple-style-span" style="font-family: verdana;">with a cold backup in production.</span></u></span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">1)Conn sys as sysdba</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">2) find out current global_name value using below sql</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">SQL> select * from global_name;</span></span></p><p><span class="Apple-style-span" style="font-family: verdana;">GLOBAL_NAME<br />---------------------------------------------------------<br />THESIMPLEORACLE.WORLD</span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">Find out the value </span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span><span class="Apple-style-span" style="font-family: verdana;">of </span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span><span class="Apple-style-span" style="font-family: verdana;">GLOBAL_NAME FROM props$ TABLE</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">Select name, value$ from</span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span><span class="Apple-style-span" style="font-family: verdana;">props$ where name = 'GLOBAL_DB_NAME';</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">NAME</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">VALUE$</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">------------------------------------------------------------------------------------------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">----------------------------</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">GLOBAL_DB_NAME</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">THESIMPLEORACLE.WORLD</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">Step 3) Update global name value to desired name with our domain name</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">Syntax :</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">update props$ set value$ = '<globalname>' where name ='GLOBAL_DB_NAME';</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">Example :</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">update props$ set value$='THESIMPLEORACLE’</span><span><span class="Apple-style-span" style="font-family: verdana;"> </span></span><span class="Apple-style-span" style="font-family: verdana;">where name like 'GLOBAL_DB_NAME';</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">SQL>commit;</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;"> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:10pt;font-family:Verdana;" style="font-size: 10pt; "><span class="Apple-style-span" style="font-family: verdana;">3)Then connect as the schema user that owns the DBLINK and try to drop it.</span></span></p><p><span class="Apple-style-span" style="font-family: verdana;">4) Once the database link is dropped, the global_name can be changed back to the<br />desired name containing domain part using the alter database rename global_name statement</span></p></span></span></div>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-19898987444265209662008-10-31T18:39:00.000-07:002008-10-31T18:41:36.464-07:00Checking Operating System Version Must be B.11.23 Actual B.11.31<span class="Apple-style-span" style="font-family: 'Times New Roman'; "><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font: normal normal normal 13px/19px 'Lucida Grande', 'Lucida Sans Unicode', Tahoma, Verdana, sans-serif; padding-top: 0.6em; padding-right: 0.6em; padding-bottom: 0.6em; padding-left: 0.6em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-position: initial initial; "><p>The installer attempts to make sure that you are using a certified combination of product and OS.I have encourted this error while installing Oracle 10g on HP-<span class="Apple-style-span" style="font-family: Arial; line-height: normal; white-space: pre; ">itanium Server.</span><br /></p><p>If you want to override this, try using:</p><p>./runInstaller -ignoreSysPrereqs</p></div></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com1tag:blogger.com,1999:blog-8119151266141595214.post-67566609270008533372008-10-31T18:38:00.001-07:002008-10-31T18:38:50.588-07:00ORA-04043: object XDB_DATASTORE_PROC does not ...<div><span class="Apple-style-span" style="color: rgb(51, 51, 51); font-family: Verdana; font-size: 22px; white-space: pre;"><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-family: 'Lucida Grande'; font-size: 13px; line-height: 19px; white-space: normal; "><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-size:small;" style="font-size: small; "><span mce_style="font-family:Times New Roman;" style="font-family: 'Times New Roman'; ">When you upgrade(manual/DBUA) </span><span mce_style="font-family:Arial;" style="font-family: Arial; ">the DB to 10.2.0.2 or 10.2.0.3 <span> </span>you might encounter</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-family:Arial;" style="font-family: Arial; "><span mce_style="font-size:small;" style="font-size: small; "> </span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-family:Arial;" style="font-family: Arial; "><span mce_style="font-size:small;" style="font-size: small; ">ERROR at line 1:<br />ORA-04043: object XDB_DATASTORE_PROC does not exist</span></span></p><p class="MsoNormal" mce_style="margin:0;" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span mce_style="font-family:Arial;" style="font-family: Arial; "><span mce_style="font-size:small;" style="font-size: small; "> </span></span></p><p><span mce_style="font-family:Arial;" style="font-family: Arial; "><span mce_style="font-size:small;" style="font-size: small; ">In order to fix this, it is necessary to install Oracle Text and run dbmsxdbt.sql </span></span></p></span></span></div>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-5390549205615813352008-10-31T18:36:00.001-07:002008-10-31T18:36:53.222-07:00Size of a Table<span class="Apple-style-span" style="font-family: 'Times New Roman'; "><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font: normal normal normal 13px/19px 'Lucida Grande', 'Lucida Sans Unicode', Tahoma, Verdana, sans-serif; padding-top: 0.6em; padding-right: 0.6em; padding-bottom: 0.6em; padding-left: 0.6em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-position: initial initial; "><p>To find out a size of a table in Megabytes use below SQL</p><p>select segment_name,(bytes)/1024/1024 MB<br /> 2 from user_segments where<br /> 3 segment_type = 'TABLE'<br /> 4* and SEGMENT_NAME='TABLE_NAME'</p></div></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-42897191732625983572008-10-31T18:35:00.000-07:002008-10-31T18:36:01.325-07:00V$DataFile<span class="Apple-style-span" style="font-family: 'Lucida Grande'; font-size: 13px; line-height: 19px; "><p> V$DATAFILE , V_$DATAFILE , GV$DATAFILE</p><p>V_$Datafile The actual underlaying Dynamic View .V$datafile is a public synonym name of V$_Datafile.</p><p>You can use V$datafile to view information about data file related to NON-RAC Environment Use GV$Datafile to view information about datafile related to RAC Environment ,</p><p>the difference between V$ and GV$ view is INST_ID column which stores Instance ID information in RAC Environment.</p><p>V$DATAFILE reads the data file information from control file, some important information you can obtain from V$DATAFILE are Data file status( OFFLINE, ONLINE, SYSTEM, RECOVE ), SCN at last checkpoint , Size when created (in bytes) , weather this data file is enabled for DML operations or Not (see ENABLED column status)</p><p>Weirdness of v$datafile on a standby db.</p><p><br /></p><p>V$DATAFILE and Standby Database.</p><p>On a standby database "STATUS" column wouldn't get updated in some scenarios. All data files created after the standby control file creation timestamp would get "RECOVER" status as they get pushed to the standby database. Solution to this problem is to query V$datafile_header . Whenever we query v$datafile_header, Oracle retrieve the all data file header blocks, and it gives us the right "STATUS" of data files.</p><p><br /></p><p>Related Tables or Dynamic views</p><p>file$</p><p>ts$</p><p>x$ktfbhc</p><p>dba_data_files</p><p>dba_temp_files</p><p>gv$dbfile</p><p>dba_free_space</p><p>v$datafile_header</p><p>To know the view definition V$DATAFILE you can simple query</p></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-5184161976835707742008-10-31T18:27:00.000-07:002008-10-31T18:35:24.326-07:00OPatch failed with error code 104 when using OPATCH<span class="Apple-style-span" style="font-family: 'Times New Roman'; "><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 10px; background-image: initial; background-repeat: initial; background-attachment: initial; -webkit-background-clip: initial; -webkit-background-origin: initial; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font: normal normal normal 13px/19px 'Lucida Grande', 'Lucida Sans Unicode', Tahoma, Verdana, sans-serif; padding-top: 0.6em; padding-right: 0.6em; padding-bottom: 0.6em; padding-left: 0.6em; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; background-position: initial initial; "><p>Possible reasons for this error could be either a missing oraInst.loc file or permission issues with oraInst.loc file, oraInst.loc located in in /var/opt/oracle directory on unix platform. Ensure Oracle user have read/write priviligies on orainst.loc file as well as on the actual path of orainventory location.</p><p> if you could not fix the issue and if you know the inventory location you may want try following solution</p><p>"You would hardcode the orainventory location in Opatch apply command "</p><p><span class="Apple-style-span" style="font-weight: bold;"><span class="Apple-style-span" style="font-size: small;">ex :opatch apply -invPtrLoc /full/path/oraInst.loc</span></span></p><p> Here invPtrLoc is a Opatch Switch .</p></div></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com1tag:blogger.com,1999:blog-8119151266141595214.post-33415475788356758532008-10-29T18:04:00.000-07:002008-10-29T18:05:15.391-07:00Opatch Howto<span class="Apple-style-span" style="color: rgb(34, 34, 34); font-family: Verdana; font-size: 13px; "><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><strong style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">How to specify different inventory location?</span></em></strong></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">OPatch expects the oraInst.loc file in the standard location namely<span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span><span style="color: rgb(0, 0, 255); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">/var/opt/oracle/oraInst.loc</span><span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span>however there are some systems where this file is located in a different location other than default location</span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">In order to specify a different inventory location<span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span>when you apply a patch to oracle database you can use<span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span>inventory API flag invPtrLoc (note the case)</span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc .</span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Errors related Ora inventory locations are</span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">“OPatch would error out saying <span style="color: rgb(255, 0, 0); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">“Unable to access inventory</span>“<span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span>OR <span style="color: rgb(255, 0, 0); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">“Couldn’t find required file liboraInstaller”</span></span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(255, 0, 0); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><strong style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">What is the Default Storage location of OPATCH</span></em></strong></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Opatch is usually located in the <span style="color: rgb(0, 0, 255); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">$ORACLE_HOME/OPatch</span> directory.</span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span></em></p><h2 style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0.5em; margin-right: 0px; margin-bottom: 0em; margin-left: 0px; font-size: 1.25em; color: rgb(89, 163, 193); font-weight: normal; font-family: Georgia, 'Times New Roman', Times, serif; "><a name="_Toc44869662" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; color: rgb(89, 163, 193); text-decoration: none; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Where are the Opatch logs located and how to check if a patch has been applied successfully ?</span></em></a><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "></em></h2><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><strong style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span></em></strong><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Opatch logs are placed as follows:</span></em></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">For opatch version 1.0.0.0.xx, logs are written into the patch storage area under <span style="color: rgb(0, 0, 255); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">$ORACLE_HOME/.patch_storage/<bug></span> and the log in this case starts with</span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">“<bugnum>_Apply_<date>.log”</span></em><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "></span></em></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">For the newer opatch versions for products installed with OUI release 10.2 and after, logs are written into the cfgtoollogs/opatch area under <span style="color: rgb(0, 0, 255); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">$ORACLE_HOME/</span> and the log in this case starts with</span></em></p><p class="MsoNormal" style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><em style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 255); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">“opatch<date>.log”</span></em></p></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0tag:blogger.com,1999:blog-8119151266141595214.post-5225409117076057312008-10-29T17:54:00.000-07:002008-10-29T18:04:02.117-07:00Deleting Unused Oracle Services On Windows<span class="Apple-style-span" style="color: rgb(34, 34, 34); font-family: Verdana; font-size: 13px; "><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 0); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">To delete unused oracle services on windows ….</span></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 0); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Oracle Universal installer does not remove all services completely , if you are using your windows box as a test server then you would be installing /un-installing oracle software multiple times as a result you would see multiple entries for Listener/Oracle services in Windows services control panel , End result we have to cleanup all of them manually.</span></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">The Best way to manipulate windows services using<span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span>‘Service Control “ command utility called <span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span>“SC “</span></p><div style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">If you would like to delete a oracle Service you can say </span><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><strong style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="color: rgb(128, 0, 128); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">SC delete OracleServiceORCL</span></strong></span></span></div><div style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span style="font-size: 10pt; font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> <p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "> </p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "></p></span></span></div><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><span style="font-size: 10pt; color: rgb(0, 0, 0); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">The easiest way to remove windows services is deleting their entries in the registry<span style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "> </span>which is a not a recommend way.</span></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><span style="font-size: 7.5pt; color: rgb(153, 0, 0); padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services</span></p><p style="padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; line-height: 150%; margin-top: 0.5em; margin-right: 0px; margin-bottom: 1em; margin-left: 0px; "><span style="font-size: 7.5pt; color: rgb(0, 0, 0); font-family: Verdana; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Once you delete an entry its service is removed and will not show up in the services panel anymore after a system reboot.</span></p></span>AJhttp://www.blogger.com/profile/17227798304566303123noreply@blogger.com0