tag:blogger.com,1999:blog-11340623750011708102024-03-22T05:08:09.672+13:00Oracle DBA and APPS DBA ThingsThis blog contains different things for Oracle DBA and APPS DBA. All these things should be tested first on test environments.
Also to make this blog more useful, please give your comments and share your experience. ThanksMehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.comBlogger70125tag:blogger.com,1999:blog-1134062375001170810.post-67470020649348472652022-09-20T19:16:00.001+12:002022-09-20T19:17:05.070+12:00<p><b><span style="font-size: medium;"> Oracle Weblogic 12.2.1.3.0</span></b></p><p><b style="font-family: "Courier New", Courier, monospace; font-size: large;">60820: Select a domain which is a compatible with this environment.</b></p><p><span style="font-family: Courier New, Courier, monospace;"><br /></span></p><p><span style="font-family: Courier New, Courier, monospace;">stopComponent.sh and start</span><span style="font-family: "Courier New", Courier, monospace;">Component.sh gives the following errors</span></p><p><span style="font-family: "Courier New", Courier, monospace;">W</span><span style="font-family: Courier New, Courier, monospace;">elcome to WebLogic Server Administration Scripting Shell</span></p><p><span style="font-family: Courier New, Courier, monospace;"><br /></span></p><p><span style="font-family: Courier New, Courier, monospace;">Type help() for help on available commands</span></p><p><span style="font-family: Courier New, Courier, monospace;"><br /></span></p><p><span style="font-family: Courier New, Courier, monospace;">Reading domain from /<PATH>/user_projects/domains/IDMDomain</span></p><p><span style="font-family: Courier New, Courier, monospace;">Error: runCmd() failed. Do dumpStack() to see details.</span></p><p><span style="font-family: Courier New, Courier, monospace;">Error: Error reading domain:</span></p><p><span style="font-family: Courier New, Courier, monospace;">60820: Unsupported Domain</span></p><p><span style="font-family: Courier New, Courier, monospace;">60820: This domain is a managed domain. It has been scaled out from the original domain.</span></p><p><span style="font-family: Courier New, Courier, monospace;">60820: Select a domain which is a compatible with this environment.</span></p><p><span style="font-family: Courier New, Courier, monospace;"><br /></span></p><p><span style="font-family: Courier New, Courier, monospace;">Exiting WebLogic Scripting Tool.</span></p><div><br /></div><div><b><span style="font-size: medium;">Solution: </span></b></div><div><span style="font-size: x-small;">Oracle Doc <span face="Tahoma, Verdana, Helvetica, sans-serif" style="background-color: white; text-align: right;">2380467.1</span></span></div><div><b><span style="font-size: medium;"><br /></span></b></div><div><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">This condition is a result of Bug 25964279 (internal / not published in MOS). Due to Bug 25964279, the startComponent.sh and stopComponent.sh scripts can only successfully complete from the first node in an OID 12c collocated cluster.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"> </p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Execute the startComponent.sh and stopComponent.sh scripts only from the first server node in the collocated cluster.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Alternately an OID instance may be started from a WLST session with one of the following commands :</p><div class="kmcodeblock" style="background-color: #e0eaf1; border-color: rgb(196, 209, 230); border-style: solid; border-width: 1px; font-family: "Courier New", Courier, monospace; font-size: 11.7px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;"><span style="font-size: small;">WLST connected to the AdminServer:</span><br /><span style="font-size: small;">start('<COMPONENT_NAME>')</span><p><span style="font-size: small;">WLST connected to the target NodeManager:</span><br /><span style="font-size: small;">nmStart(serverName='<COMPONENT_NAME>',serverType='OID')</span></p><p><span style="font-size: small;"><br /></span></p><p><span style="font-size: small;"><span style="background-color: #fff9d7; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Replace '<COMPONENT_NAME>' with the OID component name, e.g. 'oid1' or 'oid2'</span></span></p></div></div><div><br /></div>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-46836587380771602272022-09-20T18:51:00.003+12:002022-09-20T18:51:13.199+12:00<p><b> Oracle FMW 12.2.1.3.0 Error: Error reading domain: 60820: Unsupported Domain</b></p><p><b>60820: This domain is a managed domain. It has been scaled out from the original domain.</b></p><p><br /></p><p>Starting system Component ohs01 ...</p><p><br /></p><p>Initializing WebLogic Scripting Tool (WLST) ...</p><p><br /></p><p>Welcome to WebLogic Server Administration Scripting Shell</p><p><br /></p><p>Type help() for help on available commands</p><p><br /></p><p>Reading domain from /u01/oracle/product/fmw/wl_home/user_projects/domains/wl_domain</p><p>Error: runCmd() failed. Do dumpStack() to see details.</p><p>Error: Error reading domain:</p><p>60820: Unsupported Domain</p><p>60820: This domain is a managed domain. It has been scaled out from the original domain.</p><p>60820: Select a domain which is a compatible with this environment.</p><p>Exiting WebLogic Scripting Tool.</p><p>Done</p><p><br /></p><p><b>Cause:</b></p><p>Oracle Support Document: 2<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14.3px; text-align: right;">723339.1</span></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">The issue was happening because the pack command is being run using -managed=true option on a domain that's already created using unpack command, as following:</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"> a. Host 1 has a WebLogic domain with Admin and a managed server - Execute pack command with -managed=true option.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"> b. Host 2 - Execute unpack command.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"> c. Host 2 - Execute pack command with -managed=true option.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"> d. Host 3 - Execute unpack command and it will fail with 60820: This domain is a managed domain. It has been scaled out from the original domain</p><p><b> Solution:</b></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Do not extend a domain which is already created using unpack after it's pack was run using -managed=true option.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">In order to extend a domain pack should be executed on the host where the domain was created originally using the config wizard or unpack was executed on a host after it's pack was run using -managed=false option</p><p><b><br /></b></p><p><br /></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-87105063940228418662022-08-07T16:30:00.007+12:002022-08-07T16:48:02.962+12:00<p style="text-align: center;"><b><span style="font-family: verdana; font-size: large;">ASM instance warning message in alert log file</span></b></p><p style="text-align: center;"><b><span style="font-family: verdana; font-size: large;"><span style="background-color: white; text-align: right;">“Warning: VKTM detected a time drift”</span></span></b></p><p style="text-align: center;"><b><span style="font-family: verdana; font-size: large;"><span style="background-color: white; text-align: right;"><br /></span></span></b></p><p style="text-align: left;"><span style="font-family: verdana; font-size: large; font-weight: bold;"><span style="background-color: white; text-align: right;"> </span> Solution</span></p><p><span style="font-family: verdana;">Usually VKTM and VKRM issues come together, at least when you are using the resource manager. </span></p><p><span style="font-family: verdana;">The VTKM is the Virtual Keeper of Time Process. The VKTM acts as a time publisher for an Oracle instance. VKTM publishes two sets of time: a wall clock time using a seconds interval and a higher resolution time (which is not wall clock time) for interval measurements. </span></p><p><span style="font-family: verdana;">The VKTM process is a process that is available in ASM instances and RDBMS instances. So if you see issues with VKTM process, it usually pops up on both. VKTM usage is affected mainly by two hidden parameters _timer_precision and _disable_highres_ticks. So, tuning these parameters can bring down VKTM CPU consumption.</span></p><p><span style="font-family: verdana;">The VKRM process is the Virtual Scheduler for Resource Manager Process, and it serves as centralized scheduler for Resource Manager activity. As there is no resource manager on a ASM instance, you will see this process only on RDBMS instances.</span></p><p><span style="font-family: verdana;"><br /></span></p><p style="background-color: white;"><span style="font-family: verdana;">For version 11.2.0.1, Apply patch for <a href="https://support.oracle.com/epmos/faces/BugDisplay?parent=DOCUMENT&sourceId=1185093.1&id=9843304" target="_blank">Bug 9843304</a>. This Bug is already fixed in 11.2.0.2</span></p><p style="background-color: white;"><span style="font-family: verdana;">For 11.2.0.2 and 11.2.0.3, apply patch for <a alt="Bug 11837095" href="https://support.oracle.com/epmos/faces/BugDisplay?parent=DOCUMENT&sourceId=1185093.1&id=11837095" target="_blank" title="Bug 11837095">Bug 11837095</a>, This Bug is already fixed in 11.2.0.4</span></p><p style="background-color: white;"><span style="font-family: verdana;">If patch is not available then please raise SR with Oracle Support.</span></p><p style="background-color: white;"><span style="font-family: verdana;"><br /></span></p><p style="background-color: white;"><span face="Tahoma, Verdana, Helvetica, sans-serif" style="font-family: verdana;">Add the following even in spfile or pfile.</span></p><p style="background-color: white;"><span face="Tahoma, Verdana, Helvetica, sans-serif" style="font-family: verdana; font-size: small;">event="10795 trace name context forever, level 2"</span></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><span style="background-color: #e0eaf1; font-family: "Courier New", Courier, monospace; font-size: 11.7px;"><br /></span></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><span style="background-color: #e0eaf1; font-family: "Courier New", Courier, monospace; font-size: 11.7px;"><br /></span></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-55949001173031009932022-08-04T20:37:00.004+12:002022-08-04T20:37:56.282+12:00<p style="text-align: center;"><span style="font-size: large;"><b>Oracle Grid Infrastructure CRS status showing offline</b></span></p><p style="text-align: left;"><span style="font-size: large;"><b><br /></b></span></p><p style="text-align: left;"><span style="font-size: medium;">Oracle GI CRS status is showing offline in Red Hat Linux, and because CRS is not up and running, it won't allow ASM instance to start.</span></p><p style="text-align: left;"><br /></p><p style="text-align: left;">check the status of the GI resource</p><p style="text-align: left;"><br /></p><p style="text-align: left;">login with "grid" os user and run the following command</p><p style="text-align: left;"><br /></p><p>[root@oracle12cdb1 bin]# ./crsctl status res -t</p><p>--------------------------------------------------------------------------------</p><p>Name Target State Server State details</p><p>--------------------------------------------------------------------------------</p><p>Local Resources</p><p>--------------------------------------------------------------------------------</p><p>ora.CRS.dg</p><p> OFFLINE OFFLINE oracle12cdb1 STABLE</p><p>ora.DATA.dg</p><p> OFFLINE OFFLINE oracle12cdb1 STABLE</p><p>ora.FRS.dg</p><p> OFFLINE OFFLINE oracle12cdb1 STABLE</p><p>ora.LISTENER.lsnr</p><p> ONLINE ONLINE oracle12cdb1 STABLE</p><p>ora.LISTENER12C.lsnr</p><p> ONLINE ONLINE oracle12cdb1 STABLE</p><p>ora.asm</p><p> OFFKINE OFFLINE oracle12cdb1 STABLE</p><p>ora.ons</p><p> OFFLINE OFFLINE oracle12cdb1 STABLE</p><p>--------------------------------------------------------------------------------</p><p>Cluster Resources</p><p>--------------------------------------------------------------------------------</p><p>ora.cssd</p><p> 1 ONLINE ONLINE oracle12cdb1 STABLE</p><p>ora.diskmon</p><p> 1 OFFLINE OFFLINE STABLE</p><p>ora.evmd</p><p> 1 ONLINE ONLINE oracle12cdb1 STABLE</p><p>ora.ora12cr2global.db</p><p> 1 ONLINE OFFLINE STABLE</p><p>--------------------------------------------------------------------------------</p><div><br /></div><div>- To resolve the issue, do the following command, please take all the backups of GI , CRS </div><div><br /></div><div>run the following command</div><div><br /></div><div><div><span> </span><span> </span><span> <span> <span> </span></span></span>crsctl stop res ora.CRS.dg -init</div><div> <span> </span><span> </span> <span> </span><span> </span></div><div><span> </span><span> </span><span> </span><span> </span><span> </span>crsctl status res -t</div><div> <span> </span><span> </span> <span> </span><span> <span> </span></span></div><div><span></span><span> </span><span> </span><span> </span><span> </span><span> </span>crsctl modify res ora.CRS.dg -attr ENABLED=0 -init</div><div> <span> </span><span> </span><span> </span><span> <span> </span></span></div><div><span> </span><span> </span><span> </span><span> </span><span> </span><span> </span>crsctl status res -t</div><div> <span> </span><span> </span> <span> </span><span> </span></div><div><span> </span><span> </span><span> </span><span> </span><span> </span>crsctl modify res ora.CRS.dg -attr ENABLED=1 -init</div><div> <span> </span><span> </span> <span> </span><span> </span></div><div><span> </span><span> </span><span> </span><span> </span><span> </span>crsctl status res -t</div><div><br /></div><div> <span> </span><span> <span> </span><span> </span></span>crsctl start res ora.CRS.dg -init</div></div><div><br /></div><div><br /></div><div><div>[grid@oracle12cdb1 ~]$ crsctl status res -t</div><div>--------------------------------------------------------------------------------</div><div>Name Target State Server State details</div><div>--------------------------------------------------------------------------------</div><div>Local Resources</div><div>--------------------------------------------------------------------------------</div><div>ora.CRS.dg</div><div> ONLINE ONLINE oracle12cdb1 STABLE</div><div>ora.DATA.dg</div><div> ONLINE ONLINE oracle12cdb1 STABLE</div><div>ora.FRS.dg</div><div> ONLINE ONLINE oracle12cdb1 STABLE</div><div>ora.LISTENER.lsnr</div><div> ONLINE ONLINE oracle12cdb1 STABLE</div><div>ora.LISTENER12C.lsnr</div><div> ONLINE ONLINE oracle12cdb1 STABLE</div><div>ora.asm</div><div> ONLINE ONLINE oracle12cdb1 Started,STABLE</div><div>ora.ons</div><div> OFFLINE OFFLINE oracle12cdb1 STABLE</div><div>--------------------------------------------------------------------------------</div><div>Cluster Resources</div><div>--------------------------------------------------------------------------------</div><div>ora.cssd</div><div> 1 ONLINE ONLINE oracle12cdb1 STABLE</div><div>ora.diskmon</div><div> 1 OFFLINE OFFLINE STABLE</div><div>ora.evmd</div><div> 1 ONLINE ONLINE oracle12cdb1 STABLE</div><div>ora.ora12cr2global.db</div><div> 1 ONLINE OFFLINE STABLE</div></div><div><br /></div><div><br /></div><div><br /></div><div><br /></div>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-39654228348220669482022-07-07T12:43:00.001+12:002022-07-07T12:43:40.651+12:00<p style="text-align: center;"><b><span style="font-size: large;">Oracle Weblogic handson labs </span></b></p><p style="text-align: center;"><b><span style="font-size: large;"><br /></span></b></p><p style="text-align: left;"><span style="font-size: medium;">Following link is very useful to practice the Oracle Weblgoic basics, it will give you a lab where you can do hanson practice and learn and clear your concepts, enjoy :)</span></p><p style="text-align: left;"><span style="font-size: medium;"><br /></span></p><p style="text-align: left;"><span style="font-size: medium;"><br /></span></p><p style="text-align: left;"><span style="font-size: medium;"><br /></span></p><p style="text-align: left;"><span style="font-size: medium;">https://luna.oracle.com/lab/77b25364-204a-4ed0-9dc8-6e993fe1e659</span></p><p style="text-align: left;"><span style="font-size: medium;"><br /></span></p><p style="text-align: left;"><span style="font-size: medium;"><br /></span></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-46398035909917949732022-06-21T20:09:00.001+12:002022-06-21T20:09:08.834+12:00<p style="text-align: center;"><span style="font-size: large;">open a EM express port 5500 in Oracle Linux</span></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><p>[root@oracle12cdb1 ~]# firewall-cmd --permanent --add-port=5500/tcp</p><p>success</p><p>[root@oracle12cdb1 ~]# firewall-cmd --reload</p><p>success</p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><p style="text-align: left;"> </p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-46930028418422396822022-06-19T01:07:00.006+12:002022-06-19T01:07:42.198+12:00<p style="text-align: center;"><b><span style="font-size: large;">orainstRoot.sh and root.sh scripts post CRS install</span></b></p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p><p>[root@oracle12cdb1 app]# /u01/app/oraInventory/orainstRoot.sh</p><p>Changing permissions of /u01/app/oraInventory.</p><p>Adding read,write permissions for group.</p><p>Removing read,write,execute permissions for world.</p><p><br /></p><p>Changing groupname of /u01/app/oraInventory to oinstall.</p><p>The execution of the script is complete.</p><p>[root@oracle12cdb1 app]# /u01/app/grid/12.2.0/grid_home/root.sh</p><p>Performing root user operation.</p><p><br /></p><p>The following environment variables are set as:</p><p> ORACLE_OWNER= grid</p><p> ORACLE_HOME= /u01/app/grid/12.2.0/grid_home</p><p><br /></p><p>Enter the full pathname of the local bin directory: [/usr/local/bin]:</p><p> Copying dbhome to /usr/local/bin ...</p><p> Copying oraenv to /usr/local/bin ...</p><p> Copying coraenv to /usr/local/bin ...</p><p><br /></p><p><br /></p><p>Creating /etc/oratab file...</p><p>Entries will be added to the /etc/oratab file as needed by</p><p>Database Configuration Assistant when a database is created</p><p>Finished running generic part of root script.</p><p>Now product-specific root actions will be performed.</p><p>Using configuration parameter file: /u01/app/grid/12.2.0/grid_home/crs/install/crsconfig_params</p><p>The log of current session can be found at:</p><p> /u01/app/grid/crsdata/oracle12cdb1/crsconfig/roothas_2022-06-19_00-38-46AM.log</p><p>2022/06/19 00:38:47 CLSRSC-363: User ignored prerequisites during installation</p><p>LOCAL ADD MODE</p><p>Creating OCR keys for user 'grid', privgrp 'oinstall'..</p><p>Operation successful.</p><p>LOCAL ONLY MODE</p><p>Successfully accumulated necessary OCR keys.</p><p>Creating OCR keys for user 'root', privgrp 'root'..</p><p>Operation successful.</p><div><br /></div>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-63074092235520977642022-06-18T21:26:00.004+12:002022-06-18T21:26:22.429+12:00<blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p style="text-align: center;"><span style="font-size: large;"><b>how to change hostname in Oracle Linux 7.2</b></span></p></blockquote></blockquote><p><br /></p><p><br /></p><p>[root@localhost ~]# hostname</p><p>oracle12cdb1</p><p>[root@localhost ~]# hostnamectl</p><p> Static hostname: oracle12cdb1</p><p> Icon name: computer-vm</p><p> Chassis: vm</p><p> Machine ID: 8ced32e2f6ce7e4182560e468ff0fb52</p><p> Boot ID: 07e076fe742343a68c9c022c10b0911b</p><p> Virtualization: kvm</p><p> Operating System: Oracle Linux Server 7.2</p><p> CPE OS Name: cpe:/o:oracle:linux:7:2:server</p><p> Kernel: Linux 3.8.13-98.7.1.el7uek.x86_64</p><p> Architecture: x86-64</p><p>[root@localhost ~]# hostnamectl set-hostname oracle12cdb1.testlab.com</p><p>[root@localhost ~]# hostname</p><p>oracle12cdb1.testlab.com</p><div><br /></div><p> </p><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><blockquote style="border: none; margin: 0 0 0 40px; padding: 0px;"><p style="text-align: center;"> </p></blockquote></blockquote>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-45005128700536224742022-06-17T20:31:00.002+12:002022-06-17T20:31:33.099+12:00<p style="text-align: center;"><b><span style="font-size: large;">Grid infrastructure installer error </span><span style="font-size: x-large;">error while loading shared libraries: libnsl.so.1</span></b></p><p style="text-align: center;"><span style="font-size: x-large;"><br /></span></p><p style="text-align: left;">[grid@oracle12cdb1 grid_home]$ sh gridSetup.sh</p><p style="text-align: left;">/u01/app/grid/12.2.0/grid_home/perl/bin/perl: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory</p><p style="text-align: left;"> </p><p style="text-align: left;"><br /></p><p>[root@oracle12cdb1 u01]# yum install libnsl.x86_64</p><p>Last metadata expiration check: 2:39:16 ago on Fri 17 Jun 2022 05:46:12 PM NZST.</p><p>Dependencies resolved.</p><p>=====================================================================================================================</p><p> Package Architecture Version Repository Size</p><p>=====================================================================================================================</p><p>Installing:</p><p> libnsl x86_64 2.28-189.1.0.1.el8 ol8_baseos_latest 103 k</p><p>Upgrading:</p><p> glibc i686 2.28-189.1.0.1.el8 ol8_baseos_latest 2.0 M</p><p> glibc x86_64 2.28-189.1.0.1.el8 ol8_baseos_latest 2.2 M</p><p> glibc-common x86_64 2.28-189.1.0.1.el8 ol8_baseos_latest 1.3 M</p><p> glibc-devel x86_64 2.28-189.1.0.1.el8 ol8_baseos_latest 80 k</p><p> glibc-headers x86_64 2.28-189.1.0.1.el8 ol8_baseos_latest 485 k</p><p> glibc-langpack-en x86_64 2.28-189.1.0.1.el8 ol8_baseos_latest 835 k</p><p><br /></p><p>Transaction Summary</p><p>=====================================================================================================================</p><p>Install 1 Package</p><p>Upgrade 6 Packages</p><p><br /></p><p>Total download size: 6.9 M</p><p>Is this ok [y/N]: y</p><p>Downloading Packages:</p><p>(1/7): libnsl-2.28-189.1.0.1.el8.x86_64.rpm 257 kB/s | 103 kB 00:00</p><p>(2/7): glibc-2.28-189.1.0.1.el8.x86_64.rpm 1.7 MB/s | 2.2 MB 00:01</p><p>(3/7): glibc-common-2.28-189.1.0.1.el8.x86_64.rpm 1.4 MB/s | 1.3 MB 00:00</p><p>(4/7): glibc-devel-2.28-189.1.0.1.el8.x86_64.rpm 1.9 MB/s | 80 kB 00:00</p><p>(5/7): glibc-2.28-189.1.0.1.el8.i686.rpm 1.4 MB/s | 2.0 MB 00:01</p><p>(6/7): glibc-langpack-en-2.28-189.1.0.1.el8.x86_64.rpm 2.4 MB/s | 835 kB 00:00</p><p>(7/7): glibc-headers-2.28-189.1.0.1.el8.x86_64.rpm 1.2 MB/s | 485 kB 00:00</p><p>---------------------------------------------------------------------------------------------------------------------</p><p>Total 4.0 MB/s | 6.9 MB 00:01</p><p>Running transaction check</p><p>Transaction check succeeded.</p><p>Running transaction test</p><p>Transaction test succeeded.</p><p>Running transaction</p><p> Preparing : 1/1</p><p> Upgrading : glibc-common-2.28-189.1.0.1.el8.x86_64 1/13</p><p> Upgrading : glibc-langpack-en-2.28-189.1.0.1.el8.x86_64 2/13</p><p> Running scriptlet: glibc-2.28-189.1.0.1.el8.x86_64 3/13</p><p> Upgrading : glibc-2.28-189.1.0.1.el8.x86_64 3/13</p><p> Running scriptlet: glibc-2.28-189.1.0.1.el8.x86_64 3/13</p><p> Running scriptlet: glibc-headers-2.28-189.1.0.1.el8.x86_64 4/13</p><p> Upgrading : glibc-headers-2.28-189.1.0.1.el8.x86_64 4/13</p><p> Upgrading : glibc-devel-2.28-189.1.0.1.el8.x86_64 5/13</p><p> Running scriptlet: glibc-devel-2.28-189.1.0.1.el8.x86_64 5/13</p><p> Installing : libnsl-2.28-189.1.0.1.el8.x86_64 6/13</p><p> Running scriptlet: glibc-2.28-189.1.0.1.el8.i686 7/13</p><p> Upgrading : glibc-2.28-189.1.0.1.el8.i686 7/13</p><p> Running scriptlet: glibc-2.28-189.1.0.1.el8.i686 7/13</p><p> Running scriptlet: glibc-devel-2.28-164.0.4.el8.x86_64 8/13</p><p> Cleanup : glibc-devel-2.28-164.0.4.el8.x86_64 8/13</p><p> Cleanup : glibc-2.28-164.0.4.el8.i686 9/13</p><p> Cleanup : glibc-headers-2.28-164.0.4.el8.x86_64 10/13</p><p> Cleanup : glibc-2.28-164.0.4.el8.x86_64 11/13</p><p> Cleanup : glibc-langpack-en-2.28-164.0.4.el8.x86_64 12/13</p><p> Cleanup : glibc-common-2.28-164.0.4.el8.x86_64 13/13</p><p> Running scriptlet: glibc-common-2.28-164.0.4.el8.x86_64 13/13</p><p> Running scriptlet: glibc-common-2.28-189.1.0.1.el8.x86_64 13/13</p><p> Verifying : libnsl-2.28-189.1.0.1.el8.x86_64 1/13</p><p> Verifying : glibc-2.28-189.1.0.1.el8.i686 2/13</p><p> Verifying : glibc-2.28-164.0.4.el8.i686 3/13</p><p> Verifying : glibc-2.28-189.1.0.1.el8.x86_64 4/13</p><p> Verifying : glibc-2.28-164.0.4.el8.x86_64 5/13</p><p> Verifying : glibc-common-2.28-189.1.0.1.el8.x86_64 6/13</p><p> Verifying : glibc-common-2.28-164.0.4.el8.x86_64 7/13</p><p> Verifying : glibc-devel-2.28-189.1.0.1.el8.x86_64 8/13</p><p> Verifying : glibc-devel-2.28-164.0.4.el8.x86_64 9/13</p><p> Verifying : glibc-headers-2.28-189.1.0.1.el8.x86_64 10/13</p><p> Verifying : glibc-headers-2.28-164.0.4.el8.x86_64 11/13</p><p> Verifying : glibc-langpack-en-2.28-189.1.0.1.el8.x86_64 12/13</p><p> Verifying : glibc-langpack-en-2.28-164.0.4.el8.x86_64 13/13</p><p><br /></p><p>Upgraded:</p><p> glibc-2.28-189.1.0.1.el8.i686 glibc-2.28-189.1.0.1.el8.x86_64</p><p> glibc-common-2.28-189.1.0.1.el8.x86_64 glibc-devel-2.28-189.1.0.1.el8.x86_64</p><p> glibc-headers-2.28-189.1.0.1.el8.x86_64 glibc-langpack-en-2.28-189.1.0.1.el8.x86_64</p><p>Installed:</p><p> libnsl-2.28-189.1.0.1.el8.x86_64</p><p><br /></p><p>Complete!</p><p>[root@oracle12cdb1 u01]#</p><p>[root@oracle12cdb1 u01]#</p><p>[root@oracle12cdb1 u01]# sudo su - grid</p><p>[grid@oracle12cdb1 ~]$ cd $ORACLE_HOME</p><p><br /></p><p><br /></p><p>[grid@oracle12cdb1 grid_home]$ sh gridSetup.sh</p><p>Launching Oracle Grid Infrastructure Setup Wizard...</p><div><br /></div>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-28315712392410309812022-06-17T18:20:00.002+12:002022-06-17T18:20:29.253+12:00<p style="text-align: center;"><span style="font-size: large;"><b>oracleasm command</b></span></p><p style="text-align: left;"><br /></p><p>[root@oracle12cdb1 /]# oracleasm -V</p><p>oracleasm version 2.1.8</p><p><br /></p><p>------------------------------------------</p><p>[root@oracle12cdb1 /]# oracleasm -h</p><p>Usage: oracleasm [--exec-path=<exec_path>] <command> [ <args> ]</p><p> oracleasm --exec-path</p><p> oracleasm -h</p><p> oracleasm -V</p><p><br /></p><p>The basic oracleasm commands are:</p><p> configure Configure the Oracle Linux ASMLib driver</p><p> init Load and initialize the ASMLib driver</p><p> exit Stop the ASMLib driver</p><p> scandisks Scan the system for Oracle ASMLib disks</p><p> status Display the status of the Oracle ASMLib driver</p><p> listdisks List known Oracle ASMLib disks</p><p> querydisk Determine if a disk belongs to Oracle ASMlib</p><p> createdisk Allocate a device for Oracle ASMLib use</p><p> deletedisk Return a device to the operating system</p><p> renamedisk Change the label of an Oracle ASMlib disk</p><p> update-driver Download the latest ASMLib driver</p><p style="text-align: left;">-------------------------------------------------------------</p><p>[root@oracle12cdb1 /]# oracleasm status</p><p>Checking if ASM is loaded: yes</p><p>Checking if /dev/oracleasm is mounted: yes</p><p><br /></p><p>----------------------------------------------------------</p><p>[root@oracle12cdb1 /]# oracleasm listdisks</p><p>CRS1</p><p>DATA1</p><p>FRA1</p><p>---------------------------------</p><p>[root@oracle12cdb1 /]# oracle querydisk CRS1</p><p>bash: oracle: command not found...</p><p>[root@oracle12cdb1 /]# oracleasm querydisk CRS1</p><p>Disk "CRS1" is a valid ASM disk</p><p>[root@oracle12cdb1 /]# oracleasm querydisk CRS2</p><p>Disk "CRS2" does not exist or is not instantiated</p><p>[root@oracle12cdb1 /]# oracleasm querydisk DATA1</p><p>Disk "DATA1" is a valid ASM disk</p><p>[root@oracle12cdb1 /]# oracleasm querydisk FRA1</p><p>Disk "FRA1" is a valid ASM disk</p><div>-----------------------------------------------------------</div><div><br /></div><div><div>[root@oracle12cdb1 /]# oracleasm listdisks</div><div>CRS1</div><div>DATA1</div><div>FRA1</div><div><br /></div><div>---------------------------------</div><div><br /></div><div><br /></div><div>[root@oracle12cdb1 /]# oracleasm scandisks</div><div>Reloading disk partitions: done</div><div>Cleaning any stale ASM disks...</div><div>Scanning system for ASM disks...</div></div><div><br /></div><div><br /></div><div><br /></div><p style="text-align: left;"> </p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-32755508813902018452022-06-17T15:42:00.000+12:002022-06-17T15:42:07.301+12:00<p style="text-align: center;"><b><span style="font-size: medium;">oracleasm createdisk command </span></b></p><p style="text-align: left;"><b><span style="font-size: medium;"><br /></span></b></p><p><span style="font-size: medium;">[root@oracle12cdb1 ~]# oracleasm createdisk CRS1 /dev/sdb1</span></p><p><span style="font-size: medium;">Writing disk header: done</span></p><p><span style="font-size: medium;">Instantiating disk: done</span></p><p><span style="font-size: medium;">[root@oracle12cdb1 ~]# oracleasm createdisk DATA1 /dev/sdb2</span></p><p><span style="font-size: medium;">Writing disk header: done</span></p><p><span style="font-size: medium;">Instantiating disk: done</span></p><p><span style="font-size: medium;">[root@oracle12cdb1 ~]# oracleasm createdisk FRA1 /dev/sdb3</span></p><p><span style="font-size: medium;">Writing disk header: done</span></p><p><span style="font-size: medium;">Instantiating disk: done</span></p><p><span style="font-size: medium;">[root@oracle12cdb1 ~]# oracleasm listdisks</span></p><p><span style="font-size: medium;">CRS1</span></p><p><span style="font-size: medium;">DATA1</span></p><p><span style="font-size: medium;"></span></p><p><span style="font-size: medium;">FRA1</span></p><div><br /></div>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-27209503011538091052022-06-17T14:46:00.000+12:002022-06-17T14:46:01.875+12:00<p style="text-align: center;"><b><span style="font-size: medium;"> use of linux command fdisk to partition the raw device for ASM Disks</span></b></p><p style="text-align: center;"><b><span style="font-size: medium;"><br /></span></b></p><p><span style="font-size: medium;">[root@oracle12cdb1 ~]# fdisk -l</span></p><p><span style="font-size: medium;">Disk /dev/sda: 40.9 GiB, 43925766144 bytes, 85792512 sectors</span></p><p><span style="font-size: medium;">Units: sectors of 1 * 512 = 512 bytes</span></p><p><span style="font-size: medium;">Sector size (logical/physical): 512 bytes / 512 bytes</span></p><p><span style="font-size: medium;">I/O size (minimum/optimal): 512 bytes / 512 bytes</span></p><p><span style="font-size: medium;">Disklabel type: dos</span></p><p><span style="font-size: medium;">Disk identifier: 0xb4face83</span></p><p><span style="font-size: medium;"><br /></span></p><p><span style="font-size: medium;">Device Boot Start End Sectors Size Id Type</span></p><p><span style="font-size: medium;">/dev/sda1 * 2048 2099199 2097152 1G 83 Linux</span></p><p><span style="font-size: medium;">/dev/sda2 2099200 85790719 83691520 39.9G 8e Linux LVM</span></p><p><span style="font-size: medium;"><br /></span></p><p><span style="font-size: medium;"><br /></span></p><p><span style="font-size: medium;">Disk /dev/sdb: 30.4 GiB, 32651509760 bytes, 63772480 sectors</span></p><p><span style="font-size: medium;">Units: sectors of 1 * 512 = 512 bytes</span></p><p><span style="font-size: medium;">Sector size (logical/physical): 512 bytes / 512 bytes</span></p><p><span style="font-size: medium;">I/O size (minimum/optimal): 512 bytes / 512 bytes</span></p><p><span style="font-size: medium;"></span></p><p><br /></p><p>[root@oracle12cdb1 ~]# fdisk /dev/sdb</p><p><br /></p><p>Welcome to fdisk (util-linux 2.32.1).</p><p>Changes will remain in memory only, until you decide to write them.</p><p>Be careful before using the write command.</p><p><br /></p><p>Device does not contain a recognized partition table.</p><p>Created a new DOS disklabel with disk identifier 0x01e28984.</p><p><br /></p><p>Command (m for help): n</p><p>Partition type</p><p> p primary (0 primary, 0 extended, 4 free)</p><p> e extended (container for logical partitions)</p><p>Select (default p): o</p><p>Value out of range.</p><p> p primary (0 primary, 0 extended, 4 free)</p><p> e extended (container for logical partitions)</p><p>Select (default p): p</p><p>Partition number (1-4, default 1):</p><p>First sector (2048-63772479, default 2048):</p><p>Last sector, +sectors or +size{K,M,G,T,P} (2048-63772479, default 63772479): +10G</p><p><br /></p><p>Created a new partition 1 of type 'Linux' and of size 10 GiB.</p><p><br /></p><p>Command (m for help): n</p><p>Partition type</p><p> p primary (1 primary, 0 extended, 3 free)</p><p> e extended (container for logical partitions)</p><p>Select (default p): p</p><p>Partition number (2-4, default 2):</p><p>First sector (20973568-63772479, default 20973568):</p><p>Last sector, +sectors or +size{K,M,G,T,P} (20973568-63772479, default 63772479): +15G</p><p><br /></p><p>Created a new partition 2 of type 'Linux' and of size 15 GiB.</p><p><br /></p><p>Command (m for help): n</p><p>Partition type</p><p> p primary (2 primary, 0 extended, 2 free)</p><p> e extended (container for logical partitions)</p><p>Select (default p): p</p><p>Partition number (3,4, default 3):</p><p>First sector (52430848-63772479, default 52430848):</p><p>Last sector, +sectors or +size{K,M,G,T,P} (52430848-63772479, default 63772479):</p><p><br /></p><p>Created a new partition 3 of type 'Linux' and of size 5.4 GiB.</p><p><br /></p><p>Command (m for help): w</p><p>The partition table has been altered.</p><p>Calling ioctl() to re-read partition table.</p><p>Syncing disks.</p><p><br /></p><p>[root@oracle12cdb1 ~]# fdisk -l</p><p>Disk /dev/sda: 40.9 GiB, 43925766144 bytes, 85792512 sectors</p><p>Units: sectors of 1 * 512 = 512 bytes</p><p>Sector size (logical/physical): 512 bytes / 512 bytes</p><p>I/O size (minimum/optimal): 512 bytes / 512 bytes</p><p>Disklabel type: dos</p><p>Disk identifier: 0xb4face83</p><p><br /></p><p>Device Boot Start End Sectors Size Id Type</p><p>/dev/sda1 * 2048 2099199 2097152 1G 83 Linux</p><p>/dev/sda2 2099200 85790719 83691520 39.9G 8e Linux LVM</p><p><br /></p><p><br /></p><p>Disk /dev/sdb: 30.4 GiB, 32651509760 bytes, 63772480 sectors</p><p>Units: sectors of 1 * 512 = 512 bytes</p><p>Sector size (logical/physical): 512 bytes / 512 bytes</p><p>I/O size (minimum/optimal): 512 bytes / 512 bytes</p><p>Disklabel type: dos</p><p>Disk identifier: 0x01e28984</p><p><br /></p><p>Device Boot Start End Sectors Size Id Type</p><p>/dev/sdb1 2048 20973567 20971520 10G 83 Linux</p><p>/dev/sdb2 20973568 52430847 31457280 15G 83 Linux</p><p>/dev/sdb3 52430848 63772479 11341632 5.4G 83 Linux</p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-81247492556146761942022-06-17T14:43:00.000+12:002022-06-17T14:43:02.925+12:00<p style="text-align: center;"><b> oracleasmlib-2.0.17-1.el8.x86_64 download for Oracle Enterprise Linux 8</b></p><p style="text-align: center;"><b><br /></b></p><p style="text-align: left;">oracleasmlib-2.0.17-1.el8.x86_64 can be downloaded from the following url</p><p style="text-align: left;"><br /></p><p style="text-align: left;">https://www.oracle.com/linux/downloads/linux-asmlib-v8-downloads.html</p><p style="text-align: left;"><br /></p><p style="text-align: left;"><br /></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-13200540114810434392022-06-17T11:01:00.002+12:002022-06-17T11:01:46.213+12:00<p><b>oracleasm-support package install issue on Oracle Enterprise Linux 8</b></p><p><br /></p><p>[root@oracle12cdb1 stage]# yum install oracleasm-support</p><p>Last metadata expiration check: 2:05:15 ago on Fri 17 Jun 2022 08:46:17 AM NZST.</p><p>Dependencies resolved.</p><p>===================================================================================================================================================================</p><p> Package Architecture Version Repository Size</p><p>===================================================================================================================================================================</p><p>Installing:</p><p> oracleasm-support x86_64 2.1.8-1.el5 el5_latest 88 k</p><p><br /></p><p>Transaction Summary</p><p>===================================================================================================================================================================</p><p>Install 1 Package</p><p><br /></p><p>Total size: 88 k</p><p>Installed size: 213 k</p><p>Is this ok [y/N]: y</p><p>Downloading Packages:</p><p>[SKIPPED] oracleasm-support-2.1.8-1.el5.x86_64.rpm: Already downloaded</p><p>Oracle Linux 8 Latest (x86_64) 3.0 MB/s | 3.1 kB 00:00</p><p>GPG key at file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle (0xAD986DA3) is already installed</p><p>The GPG keys listed for the "Oracle Linux 8 Latest (x86_64)" repository are already installed but they are not correct for this package.</p><p>Check that the correct key URLs are configured for this repository.. Failing package is: oracleasm-support-2.1.8-1.el5.x86_64</p><p> GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle</p><p>The downloaded packages were saved in cache until the next successful transaction.</p><p>You can remove cached packages by executing 'yum clean packages'.</p><p>Error: GPG check FAILED</p><p>[root@oracle12cdb1 stage]# find / -name oracleasm-support-2.1.8-1.el5.x86_64* -print</p><p>find: ‘/run/user/54321/gvfs’: Permission denied</p><p>/var/cache/PackageKit/8.5/metadata/el5_latest-8-x86_64/packages/oracleasm-support-2.1.8-1.el5.x86_64.rpm</p><p>/var/cache/dnf/el5_latest-20127a734157f70c/packages/oracleasm-support-2.1.8-1.el5.x86_64.rpm</p><p>[root@oracle12cdb1 stage]# cp /var/cache/dnf/el5_latest-20127a734157f70c/packages/oracleasm-support-2.1.8-1.el5.x86_64.rpm /stage/.</p><p>[root@oracle12cdb1 stage]# ls -ltrh</p><p>total 120K</p><p>-rw-r--r--. 1 oracle oinstall 27K Jun 17 10:25 oracleasmlib-2.0.17-1.el8.x86_64.rpm</p><p>-rw-r--r--. 1 root root 89K Jun 17 10:52 oracleasm-support-2.1.8-1.el5.x86_64.rpm</p><p>[root@oracle12cdb1 stage]# rpm -ivh oracleasm-support-2.1.8-1.el5.x86_64.rpm</p><p>warning: oracleasm-support-2.1.8-1.el5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 1e5e0159: NOKEY</p><p>Verifying... ################################# [100%]</p><p>Preparing... ################################# [100%]</p><p>Updating / installing...</p><p> 1:oracleasm-support-2.1.8-1.el5 ################################# [100%]</p><p>[root@oracle12cdb1 stage]# oracleasm configure -i</p><p>Configuring the Oracle ASM library driver.</p><p><br /></p><p>This will configure the on-boot properties of the Oracle ASM library</p><p>driver. The following questions will determine whether the driver is</p><p>loaded on boot and what permissions it will have. The current values</p><p>will be shown in brackets ('[]'). Hitting <ENTER> without typing an</p><p>answer will keep that current value. Ctrl-C will abort.</p><p><br /></p><p>Default user to own the driver interface []: grid</p><p>Default group to own the driver interface []: dba</p><p>Start Oracle ASM library driver on boot (y/n) [n]: y</p><p>Scan for Oracle ASM disks on boot (y/n) [y]: y</p><p>Writing Oracle ASM library driver configuration: done</p><p>[root@oracle12cdb1 stage]# oracleasm init</p><p>Creating /dev/oracleasm mount point: /dev/oracleasm</p><p>Loading module "oracleasm": oracleasm</p><p>Configuring "oracleasm" to use device physical block size</p><p>Mounting ASMlib driver filesystem: /dev/oracleasm</p><p> </p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-24780604425126020572022-04-30T17:00:00.004+12:002022-04-30T17:00:45.568+12:00<p><b> Oracle 12c EM console not showing up on browser</b></p><p><b></b></p><div class="separator" style="clear: both; text-align: center;"><b><br /></b></div><div class="separator" style="clear: both; text-align: center;"><b><a href="https://blogger.googleusercontent.com/img/a/AVvXsEh9GhasxT4Ee-wijLXNrcnUngX8ZLiDO6s513fRVw_T_ojpG7z2rZURIRlLOqjGvkbjnpDuJPO1_5S9FNYdh7ZU4Qq8dS8D93IxpncvMgDy1XG29kcOQ0Rq63skMV8egMj2C_UbQpWp13C-uGwxgsqUMahhkky2AqFj2AuEjJ-818z-IOLHspgCkihv" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="96" data-original-width="1027" height="30" src="https://blogger.googleusercontent.com/img/a/AVvXsEh9GhasxT4Ee-wijLXNrcnUngX8ZLiDO6s513fRVw_T_ojpG7z2rZURIRlLOqjGvkbjnpDuJPO1_5S9FNYdh7ZU4Qq8dS8D93IxpncvMgDy1XG29kcOQ0Rq63skMV8egMj2C_UbQpWp13C-uGwxgsqUMahhkky2AqFj2AuEjJ-818z-IOLHspgCkihv" width="320" /></a></b></div><b><br /><br /></b><p></p><p><b><br /></b></p><p>Download the latest flashplayer rpm and install on database host server.</p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-64119142471282355032022-04-30T14:02:00.001+12:002022-04-30T14:02:34.251+12:00<p> <b>Oracle Database Incarnation concept:</b></p><p>Its very common concept for Oracle DBAs. Incarnation is the new version of the database and it happens when database is opened with "reset logs" option after an in complete recovery.</p><p><br /></p><p>The view V$DATABASE_INCARNATION can be checked for all the database versions / incarnations. </p><p><br /></p><p><br /></p><p><br /></p><p><br /></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-34240875327629505502022-03-24T15:08:00.007+13:002022-03-24T15:11:07.272+13:00openssl command hangs while generating .p12 file - Git Bash environment<b>openssl commands hangs while generating .p12 file - Git Bash environment</b> <div><br /></div><div><br /></div><div> openssl command will remain hang if you are trying to generate the .p12 file
from the SSL cert , the only option to come out of hung state is to use the
Ctrl+C and it will not generate the .p12 file. </div><div><br /></div><div><br /></div><div>The issue can be resolved to use
the winpty before the openssl command and it will generate the .p12 file. </div><div><br /></div><div><br /></div><div>$
openssl pkcs12 -export -in ssl_cert_file.crt -inkey ssl_crt_key_file.key -out
ssl_cert_file.p12 -name "test command to generate the p12 file" </div><div><br /></div><div>Ctrl+C </div><div><br /></div><div><br /></div><div>use the
winpty command and it will work </div><div><br /></div><div><br /></div><div>$ winpty openssl pkcs12 -export -in
ssl_cert_file.crt -inkey ssl_crt_key_file.key -out ssl_cert_file.p12 -name "test
command to generate the p12 file" </div><div><br /></div><div>Enter Export Password: </div><div>Verifying - Enter
Export Password:
</div>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-68962400496936668572022-03-06T14:13:00.001+13:002022-03-07T15:52:11.399+13:00Oracle 12c install error - Oracle Net Configuration Assistant keep searching the listener ports - Checking for free port in range: 1521-1540 - Validating end-point: TCP:1521<p><b><span style="font-size: large;">Oracle 12c install error - Oracle Net Configuration Assistant keep searching the listener ports </span></b></p><p>The installer will stuck on the Oracle Net Configuration Assistant and will never complete, it will keep searching the listener ports, starting from 1521, it will keep searching the next port 1522, then so on. </p><p>Even the listener port 1521 is free and not being used, but Net Configuration Assistant keep putting the following messages in the directory "cfgtoollogs/netca"</p><p><br /></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.isHASConfigured:1648] Is Oracle Restart configured: false</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.isHASRunning:1677] Is Oracle Restart running: false</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.listenerExists:411] Is listener "LISTENER" already exists: false</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.typicalConfigure:272] Checking for free port in range: 1521-1540</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:36:59.285 NZDT ] [ConfigureListener.validateEndPoint:1074] Validating end-point: TCP:1521</span></p><p><span style="font-size: x-small;">oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.NetCA.main(NetCA.java:452)</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:39:15.023 NZDT ] [ConfigureListener.typicalConfigure:283] The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:39:15.023 NZDT ] [ConfigureListener.validateEndPoint:1074] Validating end-point: TCP:1522</span></p><p><span style="font-size: x-small;">oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.NetCA.main(NetCA.java:452)</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:41:30.083 NZDT ] [ConfigureListener.typicalConfigure:283] The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:41:30.083 NZDT ] [ConfigureListener.validateEndPoint:1074] Validating end-point: TCP:1523</span></p><p><span style="font-size: x-small;">oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.NetCA.main(NetCA.java:452)</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:43:45.041 NZDT ] [ConfigureListener.typicalConfigure:283] The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:43:45.041 NZDT ] [ConfigureListener.validateEndPoint:1074] Validating end-point: TCP:1524</span></p><p><span style="font-size: x-small;">oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.NetCA.main(NetCA.java:452)</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:46:00.082 NZDT ] [ConfigureListener.typicalConfigure:283] The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:46:00.083 NZDT ] [ConfigureListener.validateEndPoint:1074] Validating end-point: TCP:1525</span></p><p><span style="font-size: x-small;">oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.InitialSetup.<init>(NetCA.java:4353)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.NetCA.main(NetCA.java:452)</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:48:17.004 NZDT ] [ConfigureListener.typicalConfigure:283] The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;">[main] [ 2022-03-06 13:48:17.005 NZDT ] [ConfigureListener.validateEndPoint:1074] Validating end-point: TCP:1526</span></p><p><span style="font-size: x-small;">oracle.net.ca.IllegalEndpointException: The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.validateEndPoint(ConfigureListener.java:1102)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.ConfigureListener.typicalConfigure(ConfigureListener.java:279)</span></p><p><span style="font-size: x-small;"> at oracle.net.ca.SilentConfigure.performSilentConfigure(SilentConfigure.java:212)</span></p><div><br /></div><h2 style="text-align: left;">Resolution:</h2><p>- check the /etc/hosts file, it should contain the fully qualified name of the host machine with the IP.</p><p>- update the /etc/hosts with the correct hostname / ip and Oracle Net Configuration Assistant will pick the right hostname and will get the listener port for the configuration.</p><p><br /></p><p>- to make sure check the installer screen , also log file can be checked under "cfgtoollogs/netca"</p><p><br /></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 13:59:35.198 NZDT ] [ConfigureListener.typicalConfigure:283] The information provided for this listener is currently in use by other software on this computer.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 13:59:35.198 NZDT ] [ConfigureListener.validateEndPoint:1074] Validating end-point: TCP:1531</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.125 NZDT ] [ConfigureListener.isPortFree:1155] Checking if port 1531 is free on local machine...</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.126 NZDT ] [ConfigureListener.isPortFree:1170] InetAddress.getByName(127.0.0.1): /127.0.0.1</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.126 NZDT ] [ConfigureListener.isPortFree:1172] Local host IP address: oracle12cdb.testlab.com/192.168.1.100</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1174] Local host name: oracle12cdb.testlab.com</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1207] IP Address: oracle12cdb.testlab.com/192.168.1.100, Is IPv6 Address: false</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1210] IP Address: oracle12cdb.testlab.com/192.168.1.100, Is Link-Local Address: false</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.127 NZDT ] [ConfigureListener.isPortFree:1235] Creating ServerSocket on Port:1531, IP Address: oracle12cdb.testlab.com/192.168.1.100</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.130 NZDT ] [ConfigureListener.isPortFree:1238] Created ServerSocket successfully.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.130 NZDT ] [ConfigureListener.isPortFree:1250] Creating ServerSocket on Port:1531, Local IP Address: /127.0.0.1</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1254] Created ServerSocket successfully.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1260] Creating ServerSocket on Port:1531</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1263] Created ServerSocket successfully.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.isPortFree:1283] Returning is Port 1531 free: true</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.validateEndPoint:1129] Validation...Complete for TCP/TCPS.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.131 NZDT ] [ConfigureListener.typicalConfigure:289] Using port: 1531</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1155] Checking if port 1531 is free on local machine...</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1170] InetAddress.getByName(127.0.0.1): /127.0.0.1</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1172] Local host IP address: oracle12cdb.testlab.com/192.168.1.100</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1174] Local host name: oracle12cdb.testlab.com</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1207] IP Address: oracle12cdb.testlab.com/192.168.1.100, Is IPv6 Address: false</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1210] IP Address: oracle12cdb.testlab.com/192.168.1.100, Is Link-Local Address: false</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1235] Creating ServerSocket on Port:1531, IP Address: oracle12cdb.testlab.com/192.168.1.100</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1238] Created ServerSocket successfully.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.136 NZDT ] [ConfigureListener.isPortFree:1250] Creating ServerSocket on Port:1531, Local IP Address: /127.0.0.1</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1254] Created ServerSocket successfully.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1260] Creating ServerSocket on Port:1531</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1263] Created ServerSocket successfully.</span></p><p><span style="font-size: xx-small;">[main] [ 2022-03-06 14:00:50.137 NZDT ] [ConfigureListener.isPortFree:1283] Returning is Port 1531 free: true</span></p><div><br /></div><p><br /></p><p><br /></p><p><br /></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-54334494951249640842022-03-06T13:04:00.004+13:002022-03-07T15:49:17.574+13:00Oracle 12c Installer error -- no oraInstaller in java.library.path<div style="background-color: white; border: 0px; box-sizing: border-box; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 1.875rem; margin: 0px; padding-bottom: 20px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; vertical-align: baseline;"><b style="color: #323232; font-family: "IBM Plex Sans", "IBM Plex Mono"; font-size: 1.5625rem; font-weight: 400;"> Oracle 12c Installer error - <br /></b><h4 style="background-color: white; border: 0px; box-sizing: border-box; color: #323232; font-family: "IBM Plex Sans", "IBM Plex Mono"; font-size: 1.5625rem; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; font-weight: 400; line-height: 1.875rem; margin: 0px; padding-bottom: 20px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; vertical-align: baseline;"><span class="field field--name-title field--type-string field--label-hidden" style="border: 0px; box-sizing: border-box; font: inherit; margin: 0px 0px 0.8em; padding: 0px; vertical-align: baseline;">[INS-10102] Installer initialization failed<br /></span><span class="hljs-operator" style="background-color: transparent; border: 0px; box-sizing: inherit; color: var(--highlight-color); font-family: inherit; font-size: x-large; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;">-</span><span style="background-color: transparent; color: var(--highlight-color); font-family: inherit; font-size: x-large; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: inherit; white-space: inherit;"> </span><span class="hljs-keyword" style="background-color: transparent; border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-size: x-large; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;">no</span><span style="background-color: transparent; color: var(--highlight-color); font-family: inherit; font-size: x-large; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: inherit; white-space: inherit;"> oraInstaller </span><span class="hljs-keyword" style="background-color: transparent; border: 0px; box-sizing: inherit; color: var(--highlight-keyword); font-family: inherit; font-size: x-large; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline; white-space: inherit;">in</span><span style="background-color: transparent; color: var(--highlight-color); font-family: inherit; font-size: x-large; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: inherit; white-space: inherit;"> java.library.path</span></h4><div style="color: #323232; font-family: "IBM Plex Sans", "IBM Plex Mono"; font-size: 1.5625rem; font-weight: 400;"><span style="background-color: transparent; color: var(--highlight-color); font-family: inherit; font-size: x-large; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: inherit; white-space: inherit;"><br /></span></div><h1 style="text-align: left;"><span style="background-color: transparent;"><span style="font-size: small;"><span style="font-family: inherit;"><span style="font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: normal; white-space: inherit;">- make sure oraInst.loc file has the valid </span></span><span style="font-family: IBM Plex Sans, IBM Plex Mono;"><span style="font-weight: 400;">location</span></span><span style="font-family: inherit;"><span style="font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: normal; white-space: inherit;"> of oraInventory path and oracle os user has the </span></span><span style="font-weight: 400;">permissions</span><span style="font-family: inherit;"><span style="font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: normal; white-space: inherit;"> to read the oraInst.loc file and read / write on oraInventory.</span></span></span></span></h1><h1 style="text-align: left;"><span style="font-size: small;"><span style="background-color: transparent; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: normal; white-space: inherit;"><br /></span><span style="background-color: transparent; font-family: inherit; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: normal; white-space: inherit;">- install the following package </span><span style="font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", "Liberation Sans", sans-serif; font-weight: normal;"> </span><span style="font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", "Liberation Sans", sans-serif; font-weight: normal;">libnsl.so.1 with root user<br /></span><span style="font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", "Liberation Sans", sans-serif; font-weight: normal;">#dnf install libnsl</span></span></h1><div style="color: #323232; font-family: "IBM Plex Sans", "IBM Plex Mono"; font-size: 1.5625rem; font-weight: 400; text-align: left;"><span style="color: #232629; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", "Liberation Sans", sans-serif; font-size: 15px;"><br /></span></div><div style="color: #323232; font-family: "IBM Plex Sans", "IBM Plex Mono"; font-size: 1.5625rem; font-weight: 400;"><span style="background-color: transparent; color: var(--highlight-color); font-family: inherit; font-size: x-large; font-style: inherit; font-variant-caps: inherit; font-variant-ligatures: inherit; font-weight: inherit; white-space: inherit;"><br /></span></div></div><div style="background-color: white; border: 0px; box-sizing: border-box; color: #323232; font-family: "IBM Plex Sans", "IBM Plex Mono"; font-size: 1.5625rem; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; font-weight: 400; line-height: 1.875rem; margin: 0px; padding-bottom: 20px !important; padding-left: 0px; padding-right: 0px; padding-top: 0px; text-align: left; vertical-align: baseline;"><br /></div>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com04V6JP9PC+26-45.2648861 172.3705368-73.575119936178851 137.2142868 -16.954652263821153 -152.47321320000003tag:blogger.com,1999:blog-1134062375001170810.post-61641774089697531832020-10-22T14:08:00.000+13:002020-10-22T14:08:15.222+13:00<p style="text-align: center;"> <b>Error "-bash: !2: event not found" while converting the PKCS12 keystore <span style="font-family: "Times New Roman", serif; font-size: 12pt;">(.p12/.pfx)</span> to the Java Keystore (.jks)</b></p><p style="text-align: center;"><b><br /></b></p><p><b>Introduction:</b></p><p>Some times there is a need to convert the PKCS12 keystore to the Java Keystore or vice versa. This post will cover how to convert the PKCS12 keystore to the java keystore.</p><p><br /></p><p><b>Commands and details:</b></p><p>* Please do no apply any of the following command on the PROD, always test the commands on TEST or DEV machine and if you think its fine then do on PROD with full responsibility of your own.*</p><p>1- make a test / working directory</p><p>2- copy the PKCS12 keystore in that directory, make a backup of the original PKCS12 keystore</p><p>3- run the following command</p><p>[testuser@testserver1020 workingdirectory]# keytool -importkeystore -deststorepass KeepTheStrongPassword4TargetKeystore -destkeypass KeepTheStrongPassword4TargetKeystore -destkeystore new_java_keystore_name.jks -destalias AliasOfTheCert -srckeystore server.pfx -srcstoretype PKCS12 -srcstorepass TheSourcePKCS12KeystorePassword</p><p>output: </p><p>Above command might give the following error</p><p>-bash: !2: event not found</p><p><br /></p><p>Resolution of the error:</p><p>give the following command with out "-srcstorepass TheSourcePKCS12KeystorePassword", and the command will ask you the password on the prompt, give the password and it will convert the PKCS12 file to JKS keystore</p><p><br /></p><p>[testuser@testserver1020 workingdirectory]# keytool -importkeystore -deststorepass KeepTheStrongPassword4TargetKeystore -destkeypass KeepTheStrongPassword4TargetKeystore -destkeystore new_java_keystore_name.jks -destalias AliasOfTheCert -srckeystore server.pfx -srcstoretype PKCS12</p><p>Enter source keystore password:</p><p>Entry for alias SourceAlias successfully imported.</p><p>Import command completed: 1 entries successfully imported, 0 entries failed or cancelled</p><p><br /></p><p><br /></p>Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-60700084749695549732014-04-06T10:53:00.003+12:002022-03-07T15:53:28.731+13:00error ORA-27154: post/wait create failed - while starting ASM instance<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Objective:</b><br />
<br />
Got the following issue while starting up ASM instance.<br />
<br />
<span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.479999542236328px;">ORA-27154: post/wait create failed</span><br style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.479999542236328px;" /><span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.479999542236328px;">ORA-27300: OS system dependent operation:semget failed with status: 28</span><br style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.479999542236328px;" /><span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.479999542236328px;">ORA-27301: OS failure message: No space left on device</span><br style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.479999542236328px;" /><span style="background-color: white; color: #222222; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; line-height: 18.479999542236328px;">ORA-27302: failure occurred at: sskgpcreates</span><br />
<b><br /></b>
<b>Cook Book:</b><br />
<b><br /></b>
Checked the sysctl.conf file and found the following entry<br />
<br />
kernel.sem = 275 100<br />
<br />
Updated the above with the following and executed command "sysctl -p"<br />
<br />
kernel.sem = 250 32000 100 256<br />
<br />
Started the ASM instance and it came up :)<br />
<br />
<br />
<div>
<br /></div>
<b><u><br /></u></b>
<b><u><br /></u></b></div>
Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-16385066374101647122012-08-23T03:58:00.001+12:002012-08-23T04:01:10.467+12:00how to delete files in UNIX which contains special characters like " , ( , ',)<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Objective:</b>
If the file in Unix contains special characters in its name, then a simple "rm" command will not work, so what is the solution!<br />
<br />
<b>Cook Book:</b><br />
<br />
We can use the escape character "\" to remove such files.
<br />
<br />
Following is an example<br />
<br />
<br />
[oracle@TESTServer]>ls -ltrh<br />
total 129<br />
<br />
-rw-r--r-- 1 oracle oinstall 0 Aug 21 14:54 to_date('22-FEB-2012')"<br />
-rw------- 1 oracle oinstall 723 Aug 21 14:55 nohup.out<br />
<br />
[oracle@TESTServer]>rm to_date\(\'22-FEB-2012\'\)\"<br />
<br />
<br />
[oracle@TESTServer]>ls -ltrh<br />
total 110<br />
-rw------- 1 oracle oinstall 723 Aug 21 14:55 nohup.out<br />
</div>
Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-43969296630584316182011-11-18T02:52:00.005+13:002022-03-07T15:54:08.861+13:00shell script to check if the Workflow mailer is down in APPS R12<span style="font-weight:bold;">Introduction:</span>
We can use the following shell script and can schedule it with crontab. It is very handy, it will check the workflow mailer and if it is down it will send email to APPS DBA.
<span style="font-weight:bold;">Cookbook:
</span>
Following is the script.
#!/bin/sh
## ORACLE_HOME=`cat /etc/var/opt/oratab | grep ^TESTDB: | cut -f2 -d':'`
ORACLE_HOME=/erptest/TST/db/tech_st/11.1.0
export ORACLE_HOME
ORACLE_SID=ERPTEST
export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin:.
export PATH
SCRIPT_DIR=/erptestdb/home/scripts
export SCRIPT_DIR
# check_ts.log
$ORACLE_HOME/bin/sqlplus -s test_user/test_user <<!
spool /erptestdb/home/scripts/check_wf_mailer.log
set lines 1000
set head off
# column tablespace_name format a50
select COMPONENT_STATUS
from apps.FND_SVC_COMPONENTS
where component_type='WF_MAILER'
/
spool off
exit
!
#SCRIPT_DIR=/test/appl/homes/oratest/scripts
if [ -s $SCRIPT_DIR/check_wf_mailer.log ]; then
#COUNT=`cat check_ts.log | wc -l `
COUNT=0
STATUS=`cat $SCRIPT_DIR/check_wf_mailer.log | awk '{print $1}'`
VSTATUS='RUNNING'
echo "v status is: " $VSTATUS
echo "file is present"
echo "Script Dir: " $SCRIPT_DIR
echo "status is " $STATUS
if [ $STATUS != $VSTATUS ] ; then
echo "status is in the if stmt " $STATUS
mailx -s "Oracle Workflow Mailer is down in APPS R12, please check " appsdba@test.com < /erptestdb/home/scripts/check_wf_mailer.log
fi
fiMehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-41513723560116056762011-10-14T00:45:00.002+13:002022-03-07T15:55:03.754+13:00APPS R12.1.1 post cloning for Database Tier error - ORA-12547: TNS:lost contactIntroduction:
On post cloning of database tier of APPS R12.1.1 , it ended with errors "ORA-12547: TNS:lost contact"
Resolution:
Following were the errors which we got in ApplyDbTier.
===============
LD_LIBRARY_PATH : /erptst/TST/db/tech_st/11.1.0/lib:/usr/dt/lib:/usr/openwin/lib:/erptst/TST/db/tech_st/11.1.0/ctx/lib:/erptst/TST/db/tech_st/11.1.0/lib32
Executable : /erptst/TST/db/tech_st/11.1.0/bin/sqlplus
The log information will be written to
/erptst/TST/db/tech_st/11.1.0/appsutil/log/TST_testmachine/adcrdb_TST.txt
Creating the control file for TST_testm1 database ...
SQL*Plus: Release 11.1.0.7.0 - Production on Mon Oct 10 16:00:59 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
ORA-12547: TNS:lost contact
ERROR:
ORA-12547: TNS:lost contact
ORA-12547: TNS:lost contact
SP2-0640: Not connected
==============================
We tried to connect from sqlplus but after few seconds of wait it again gave the same error.
We checked the inventory location and permission and it was all ok.
We tried again the post clone, but this time we choose the different SID as CLN and gave the different port number, previously it was 01 and this time we chose 79. And this time the post clone went successful without any errors, this is so weird, but this is just what happened!Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0tag:blogger.com,1999:blog-1134062375001170810.post-64619560852686871592011-07-09T22:00:00.002+12:002022-03-07T15:55:39.320+13:00Oracle Application APEX admin user password reset by script<span style="font-weight:bold;">Introduction:</span>
If you dont know the password for admin user of Oracle Application APEX, and if version of APEX is 3 or higer then the password of admin can be reset by a script.
<span style="font-weight:bold;">CookBook:</span>
There is script in the directory of apex softwae and the script name is apxchpwd.sql, this can be run with sys user on sqlplus and it will ask the new password for admin, just type the new password and use it.Mehmood Rehmanhttp://www.blogger.com/profile/06794905310449282349noreply@blogger.com0