tag:blogger.com,1999:blog-30466217421644559042024-03-28T03:55:30.866-07:00Chowdari's Oracle DBA Blog / WeblogLive as if you were to die tomorrow. Learn as if you were to live forever.Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.comBlogger88125tag:blogger.com,1999:blog-3046621742164455904.post-45086716862179405062023-06-14T02:52:00.007-07:002023-09-06T06:02:13.288-07:00Oracle EBS R12.2.12 with Database 19c VM Virtual Appliance for On-Premise now available<p>Oracle released the E-Business Suite Release 12.2.12 with 19c Database Single node Vision virtual appliance for On-Premise. Please note that the EBS instance that comes with Vision Instance which means you cannot use this for any Production, DEV or Test environments. Oracle EBS Vision instances are used only for Training, Demo purpose. </p><h3 style="text-align: left;"><b>12.2.12 Virtual Appliance Contains:</b></h3><p></p><ul style="text-align: left;"><li>Vision Database</li><li>DB 19c (19.18 RU)</li><li>FMW 11.1.1.9</li><li>Apr2023 EBS CPU</li><li>Jan2023 CPU/PSU for the technology components.</li><li>System schema migration completion patch</li></ul><p></p><h3 style="text-align: left;">Below are the high level steps to Deploy EBS R12.2.12 VM appliance:</h3><p></p><ul style="text-align: left;"><li>Download the Oracle EBS VM Appliance software from Oracle E-Delivery Site i.e. edelivery.oracle.com</li><li>Reconstruct and Stage the Downloaded Appliance using script-based (assemble.sh) or manual method</li><li>Import the VirtualBox Appliance Using Oracle VM VirtualBox Manager or Oracle VM Manager </li><li>Start VM and Configure EBS installation and Launch EBS console</li></ul><h3 style="text-align: left;"><br />Download Oracle EBS 12.2.12 VM Appliance:<br /><br /></h3><div><div class="separator" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEiQk-EKCL3RHdpsnSsZXbvHXZ1JF8vor0hqLSs-28DCJXmuMQXy2HSlCSmV4NqT_lN0NJ5XaxstCQmd69AsLeu21XhnmhjElxYxZYc56tcQ-2Veu_-6bFMSJpF_-vbxjGbhNIbrET4R41_N2opYT-9SYQ50JJInYwU6pDQ--fVKQqavkE3vXHtRbhP4" style="margin-left: 1em; margin-right: 1em;"><img data-original-height="517" data-original-width="1813" height="182" src="https://blogger.googleusercontent.com/img/a/AVvXsEiQk-EKCL3RHdpsnSsZXbvHXZ1JF8vor0hqLSs-28DCJXmuMQXy2HSlCSmV4NqT_lN0NJ5XaxstCQmd69AsLeu21XhnmhjElxYxZYc56tcQ-2Veu_-6bFMSJpF_-vbxjGbhNIbrET4R41_N2opYT-9SYQ50JJInYwU6pDQ--fVKQqavkE3vXHtRbhP4=w640-h182" width="640" /></a></div><br /><br /></div><div><a href="https://blogger.googleusercontent.com/img/a/AVvXsEgBsoa2vpf4aH-WswfFUf52LBpTDqm3U-Nz4oqZ3i8gnTCVhhnUD5pGLSeod8QIdvvTZ6ke3E4V8kjBiPjgX-4lu4KCJFVdySdhSnwPdHWU_hDkzoLoffQX3SGp_CBVkxefDMYkPQQFzJ9SGRV7qZmsbKPRQqnFPj6M6bLQnhMau1Djy69Gd8kEE4O7" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img data-original-height="531" data-original-width="1897" height="180" src="https://blogger.googleusercontent.com/img/a/AVvXsEgBsoa2vpf4aH-WswfFUf52LBpTDqm3U-Nz4oqZ3i8gnTCVhhnUD5pGLSeod8QIdvvTZ6ke3E4V8kjBiPjgX-4lu4KCJFVdySdhSnwPdHWU_hDkzoLoffQX3SGp_CBVkxefDMYkPQQFzJ9SGRV7qZmsbKPRQqnFPj6M6bLQnhMau1Djy69Gd8kEE4O7=w640-h180" width="640" /></a></div><div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/a/AVvXsEjepYhKvU4z89eE9EbAzNdKPyqQIwBiSSYt7eIsQVOrveaH6qJNg_VlK1Sola7RxaFj82qwG-Zj2aDEkV4pMhKOAbp8B21cE6-3LOvBurqEN3VkIg_rk9PC4bwe9dZRR9I-JSdUrpy0cWtZHfL1ydna6YdN4W1MygjpNXHOfYCJZ2ZdBl9-7JXmdS6l" style="margin-left: 1em; margin-right: 1em;"><img data-original-height="730" data-original-width="1870" height="250" src="https://blogger.googleusercontent.com/img/a/AVvXsEjepYhKvU4z89eE9EbAzNdKPyqQIwBiSSYt7eIsQVOrveaH6qJNg_VlK1Sola7RxaFj82qwG-Zj2aDEkV4pMhKOAbp8B21cE6-3LOvBurqEN3VkIg_rk9PC4bwe9dZRR9I-JSdUrpy0cWtZHfL1ydna6YdN4W1MygjpNXHOfYCJZ2ZdBl9-7JXmdS6l=w640-h250" width="640" /></a></div><div><br /></div><div><br /></div><div>Follow the MOS Note: 2933812.1 for deploying the EBS R12.2.12 VM appliance.</div><div><br /></div><div><b>Blog Article: <a href="https://blogs.oracle.com/ebstech/post/oracle-vm-virtual-appliance-for-ebs-122-now-available">https://blogs.oracle.com/ebstech/post/oracle-vm-virtual-appliance-for-ebs-122-now-available</a></b></div><div><br /></div><div>That's it, hope this information will help you.</div><div><br /></div><div>Thank You!!</div></div><div><br /></div><div><br /></div><div><br /></div><div><h3>Some Oracle EBS with database 19c based articles:</h3><p><a href="https://mbc-dba.blogspot.com/2020/07/Oracle-EBS-R12-with-Database-19c-Administration.html" target="_blank">Oracle EBS R12 with Database 19c - Administration</a></p><p><a href="https://mbc-dba.blogspot.com/2020/07/UTLFILEDIR-Desupported-with-Oracle-Database-19c.html" target="_blank">UTL_FILE_DIR Desupported with Oracle Database 19c</a></p><p><a href="https://mbc-dba.blogspot.com/2020/09/upgrade-oracle-11g12c-database-to-19c-with-EBS-R12.1-R12.2.html" target="_blank">Upgrade Oracle 11g/12c Database to 19c with EBS R12.1/R12.2</a></p><p><a href="https://mbc-dba.blogspot.com/2019/07/oracle-database-19c-installation-on.html" target="_blank">Oracle Database 19c Installation on Oracle Linux 7 (OL7)</a></p><p><a href="https://mbc-dba.blogspot.com/2020/11/how-to-rename-pluggable-database-pdb-in.html" target="_blank">How To Rename A Pluggable Database (PDB) in Oracle EBS R122 with 19c Database</a></p><p><br /></p></div><p></p>Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-15497758010749932162021-01-26T06:35:00.008-08:002021-01-26T21:25:09.784-08:00EBS 12.2.10 with Database 19c VM Virtual Appliance for On-Premise now available<p>Oracle released the E-Business Suite Release 12.2.10 with 19c Database Single node Vision with October 2020 CPU VM virtual appliance for On-Premise. Please note that the EBS instance that comes with VM Appliance is a Vision Instance which means you cannot use this for any Production, DEV or Test environments. Oracle EBS Vision instances are used only for Training, Demo purpose. </p><p>This is the first EBS Vision Instance with 19c Database VM Appliance released for On-Premise. </p><h3>Below are the high level steps to Deploy EBS R12210 VM appliance:</h3><p></p><ul><li>Download the Oracle EBS VM Appliance software from Oracle E-Delivery Site i.e. edelivery.oracle.com</li><li>Reconstruct and Stage the Downloaded Appliance using script-based (assemble.sh) or manual method</li><li>Import the VirtualBox Appliance Using Oracle VM VirtualBox Manager or Oracle VM Manager </li><li>Start VM and Configure EBS installation and Launch EBS console</li></ul><h4><br />Download Oracle EBS VM Appliance software:</h4><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs_lWQeNvkHEUdf9dbdYkNpW5GECIf04USCW28NzHJl-Dd9fdxumE4RxjVY7hqwKILrLGzGKoViK-m7IoBP_mGj7T32-9u19Ops_KVOent8WMrEAI-Zpbie7K3aROiy5jdgExW91WGmZ8/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="244" data-original-width="624" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgs_lWQeNvkHEUdf9dbdYkNpW5GECIf04USCW28NzHJl-Dd9fdxumE4RxjVY7hqwKILrLGzGKoViK-m7IoBP_mGj7T32-9u19Ops_KVOent8WMrEAI-Zpbie7K3aROiy5jdgExW91WGmZ8/w640-h250/image.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWPm-5WFF0SMr-UJOZfd7uDgfX65PllHylbGzzbF7Nn-ffXtNngDWhkuMQHWwe-ESfXTPoADp5Xd-pvw_ljdsy3a4N_7UXhRbl99mAae6SO_7gp67N_2r_G8eaVzznynAKLjCoBgr_k4/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="187" data-original-width="624" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWPm-5WFF0SMr-UJOZfd7uDgfX65PllHylbGzzbF7Nn-ffXtNngDWhkuMQHWwe-ESfXTPoADp5Xd-pvw_ljdsy3a4N_7UXhRbl99mAae6SO_7gp67N_2r_G8eaVzznynAKLjCoBgr_k4/w640-h192/image.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnq2C9cDVM7AyiyHVawc7d-SsraXrBsOeND6FMao-LaU1iL3W62h9mkxUZgk0DQZuM8vYtYVpfJO_iI8arFrebgZ72k-39YlvAhtoMTaifXk6DdBBrUYHTX9ukR9AOLeHRAOuVE9Flp_k/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="255" data-original-width="624" height="262" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnq2C9cDVM7AyiyHVawc7d-SsraXrBsOeND6FMao-LaU1iL3W62h9mkxUZgk0DQZuM8vYtYVpfJO_iI8arFrebgZ72k-39YlvAhtoMTaifXk6DdBBrUYHTX9ukR9AOLeHRAOuVE9Flp_k/w640-h262/image.png" width="640" /></a></div><br /><span>Follow the </span><span><b>MOS Note:</b> <b>2717713.1</b> for </span><span>deploying the EBS R12210 VM appliance.</span></div><div><span><br /></span></div><div><h4>Blog Article: <a href="https://blogs.oracle.com/ebstech/ebs-12210-with-database-19c-vm-virtual-appliance-for-on-premises">https://blogs.oracle.com/ebstech/ebs-12210-with-database-19c-vm-virtual-appliance-for-on-premises</a></h4><div><br /></div><div>That's it, hope this information will help you.</div><div><br /></div><div>Thank You!!</div><div><br /></div><div><h3>Some Oracle EBS with database 19c based articles:</h3><p><a href="https://mbc-dba.blogspot.com/2020/07/Oracle-EBS-R12-with-Database-19c-Administration.html" target="_blank">Oracle EBS R12 with Database 19c - Administration</a></p><p><a href="https://mbc-dba.blogspot.com/2020/07/UTLFILEDIR-Desupported-with-Oracle-Database-19c.html" target="_blank">UTL_FILE_DIR Desupported with Oracle Database 19c</a></p><p><a href="https://mbc-dba.blogspot.com/2020/09/upgrade-oracle-11g12c-database-to-19c-with-EBS-R12.1-R12.2.html" target="_blank">Upgrade Oracle 11g/12c Database to 19c with EBS R12.1/R12.2</a></p><p><a href="https://mbc-dba.blogspot.com/2019/07/oracle-database-19c-installation-on.html" target="_blank">Oracle Database 19c Installation on Oracle Linux 7 (OL7)</a></p><p><a href="https://mbc-dba.blogspot.com/2020/11/how-to-rename-pluggable-database-pdb-in.html" target="_blank">How To Rename A Pluggable Database (PDB) in Oracle EBS R122 with 19c Database</a></p><h3>Some Oracle RAC and ASM based articles:<br /><br /></h3><div><a href="https://mbc-dba.blogspot.com/2015/11/oracle-rac-11gr2-installation-on.html" target="_blank">Oracle RAC 11gR2 Installation on Virtual Box</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2016/01/overview-of-oracle-local-registry-olr.html" target="_blank">Overview of Oracle Local Registry (OLR) in RAC 11gR2</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2014/10/adding-disk-to-asm-disk-group-in-oracle.html" target="_blank">Adding disk to ASM disk group in oracle 11g</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2014/08/ora-04031-unable-to-allocate-3896-bytes.html" target="_blank">ORA-04031 unable to allocate 3896 bytes of shared memory in ASM Instance</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2013/09/export-export-dumps-to-asm-disk.html" target="_blank">Export Logical Database Backup Dumps to ASM Disk</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2015/11/default-listener-is-not-configured-when.html" target="_blank">Default "LISTENER" is not configured when running DBCA</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2014/08/crs-4639-crs-4124-oracle-high.html" target="_blank">CRS-4639 CRS-4124 Oracle High Availability Services startup failed in 11gR2 RAC</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2013/11/listener-intermediate-status-with-not.html" target="_blank">Listener INTERMEDIATE status with "Not All Endpoints Registered" in 11gR2 RAC</a></div></div><div><br /></div></div>Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com3tag:blogger.com,1999:blog-3046621742164455904.post-10106733401114215572020-11-21T09:46:00.008-08:002020-11-23T03:24:29.974-08:00How To Rename A Pluggable Database (PDB) in Oracle EBS R122 with 19c Database<p>Go through the following steps to rename the Pluggable Database (PDB) in Oracle EBS R122 with 19c database.</p><p>Here I am changing PDB name from "TESTHYD1" to "TESTBAN1".</p><p>Connect to the CDB and check the information about the PDB:</p>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "Andale Mono", "Lucida Console", Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;">SQL> select name, open_mode, restricted from v$pdbs;
NAME OPEN_MODE RES
---------- --------------- ---
PDB$SEED READ ONLY NO
TESTHYD1 READ WRITE NO
SQL></code> </pre>
<p>Close the PDB and check the status:</p>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "Andale Mono", "Lucida Console", Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;">SQL> alter pluggable database "TESTHYD1" close;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TESTHYD1 MOUNTED
SQL> </code> </pre>
<p>Unplug the "TESTHYD1" PDB database and Drop it:</p>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "Andale Mono", "Lucida Console", Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;">SQL> alter pluggable database "TESTHYD1" unplug into '/u01/HYDSER01/19.0.0/dbs/TESTHYD1_unplug.xml';
Pluggable database altered.
SQL>
SQL> drop pluggable database "TESTHYD1";
Pluggable database dropped.
SQL></code> </pre>
<p>Create pluggable database using the <DBSID>_unplug.xml file</p>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "Andale Mono", "Lucida Console", Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;">SQL> create pluggable database "TESTBAN1" using '/u01/HYDSER01/19.0.0/dbs/TESTHYD1_unplug.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_TESTHYD1','ebs_TESTBAN1','TESTHYD1_ebs_patch','TESTBAN1_ebs_patch');
Pluggable database created.
SQL></code></pre>
<p>Open "TESTBAN1" pluggable database in read write mode:</p>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "Andale Mono", "Lucida Console", Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;">SQL> alter pluggable database "TESTBAN1" open read write;
Pluggable database altered.
SQL></code> </pre>
<p>Startup the PDB and save its state by executing the following commands</p>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "Andale Mono", "Lucida Console", Monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; overflow-wrap: normal; word-wrap: normal;">SQL> alter pluggable database all open;
Pluggable database altered.
SQL> alter pluggable database all save state instances=all;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 TESTBAN1 READ WRITE NO
SQL></code> </pre>
<p>Note: The PDB should be renamed only using the above approach to retain the case of the PDB name in E-Business Suite.</p><p>That's it, hope this article will help you.</p><p>Thank you!!</p><p><br /></p><h3 style="text-align: left;">Some Oracle EBS with database 19c based articles:</h3><p><a href="https://mbc-dba.blogspot.com/2020/07/Oracle-EBS-R12-with-Database-19c-Administration.html" target="_blank">Oracle EBS R12 with Database 19c - Administration</a></p><p><a href="https://mbc-dba.blogspot.com/2020/07/UTLFILEDIR-Desupported-with-Oracle-Database-19c.html" target="_blank">UTL_FILE_DIR Desupported with Oracle Database 19c</a></p><p><a href="https://mbc-dba.blogspot.com/2020/09/upgrade-oracle-11g12c-database-to-19c-with-EBS-R12.1-R12.2.html" target="_blank">Upgrade Oracle 11g/12c Database to 19c with EBS R12.1/R12.2</a></p><p><a href="https://mbc-dba.blogspot.com/2019/07/oracle-database-19c-installation-on.html" target="_blank">Oracle Database 19c Installation on Oracle Linux 7 (OL7)</a></p><h3 style="text-align: left;">Some Oracle RAC and ASM based articles:</h3><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2015/11/oracle-rac-11gr2-installation-on.html" target="_blank">Oracle RAC 11gR2 Installation on Virtual Box</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2016/01/overview-of-oracle-local-registry-olr.html" target="_blank">Overview of Oracle Local Registry (OLR) in RAC 11gR2</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2014/10/adding-disk-to-asm-disk-group-in-oracle.html" target="_blank">Adding disk to ASM disk group in oracle 11g</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2014/08/ora-04031-unable-to-allocate-3896-bytes.html" target="_blank">ORA-04031 unable to allocate 3896 bytes of shared memory in ASM Instance</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2013/09/export-export-dumps-to-asm-disk.html" target="_blank">Export Logical Database Backup Dumps to ASM Disk</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2015/11/default-listener-is-not-configured-when.html" target="_blank">Default "LISTENER" is not configured when running DBCA</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2014/08/crs-4639-crs-4124-oracle-high.html" target="_blank">CRS-4639 CRS-4124 Oracle High Availability Services startup failed in 11gR2 RAC</a></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2013/11/listener-intermediate-status-with-not.html" target="_blank">Listener INTERMEDIATE status with "Not All Endpoints Registered" in 11gR2 RAC</a></div><div><br /></div><div><br /></div>Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0Service Rd, Sreenagar, Telangana 501359, India17.2044506 78.482637712.954349007018454 74.08810645 21.454552192981549 82.87716895tag:blogger.com,1999:blog-3046621742164455904.post-71726210640918809852020-09-22T05:06:00.010-07:002020-09-22T05:10:31.149-07:00Upgrade Oracle 11g/12c Database to 19c with EBS R12.1/R12.2<div style="text-align: left;"><span style="color: #660000; font-size: medium;">Below are the highlited steps to upgrade your Oracle 11g/12c Database to 19c with EBS R12.1/R12.2</span></div><div style="text-align: left;"><br /></div>1. Install Oracle Database 19c Binaries<br /><br />2. Apply additional 19c RDBMS patches<br /><br />3. Apply 19c interoperability patches on application R12.1/R12.2<br /><br />4. Create an empty container database (CDB) without a PDB<br /><br />5. Run pre-upgrade diagnostic reports<br /><br />6. Upgrade the database from 11g/12c to 19c using DBUA<br /><br />7. Perform post Database Upgrade steps (run post fix-up script)<br /><br />8. Convert Database to Multitenant Architecture (Non-CDB to PDB)<br /><br />9. Perform Post Database upgrade steps<br /><br />Most of the steps are similar to earlier upgrades (11g to 12c) and straightforward.<br /><br />The only tricky part in 19c is converting the Database to Multi-tenant architecture which has to be done cautiously. In database 19c version Multi-tenant conversion is compulsory.<div><br /></div><div><br /></div><div><b>Some 19c based articles:</b></div><div><br /></div><div><a href="https://mbc-dba.blogspot.com/2020/07/Oracle-EBS-R12-with-Database-19c-Administration.html" target="_blank">Oracle EBS R12 with Database 19c - Administration</a></div><div><a href="https://mbc-dba.blogspot.com/2020/07/UTLFILEDIR-Desupported-with-Oracle-Database-19c.html" target="_blank">UTL_FILE_DIR Desupported with Oracle Database 19c</a></div><div><br /></div><div><br /></div><div>Thanks You !!</div>Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-12359893365689436952020-09-03T00:45:00.009-07:002020-09-03T02:07:08.205-07:00ORA-39142: incompatible version number 5.1 in dump file<p>Recently I have encountered below error while importing database dump file on Oracle Database 11gR2 and dump file was exported from 19c database.</p><pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 667.333px;"><code style="overflow-wrap: normal;">ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 5.1 in dump file "/u01/HYDSERVER/admin/rhyddb22/dpdump/testing.dmp"</code>
</pre>This is basically downgrade situation, because we are exporting dump file in 19c database and importing it into 11g database. To overcome this error, while exporting the dump file in 19c database we need to explicitly use VERSION parameter which specified to be the target COMPATIBLE initialization parameter. <div><br /></div><div>Here in my case, the target database COMPATIBLE initialization parameter is 11.2. So need to specify same value for the VERSION parameter during export the dump file. </div><div><br /></div><div><b>Source side on 19c database with compatible 19.0.0:</b></div><div><pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 667.333px;"><code style="overflow-wrap: normal;">-bash-4.2$ expdp directory=DATA_PUMP_DIR dumpfile=testing.dmp logfile=testing.log tables=testing_tables <b>version=11.2</b>
</code></pre><b>Target side on 11gR2 database with compatible 11.2:</b><pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 667.333px;"><code style="overflow-wrap: normal;">-bash-4.2$ impdp directory=DATA_PUMP_DIR dumpfile=testing.dmp logfile=testing_imp.log tables=testing_tables
</code></pre>That's it, hope this article will help you.</div><div><br /></div><div>Thank you !!</div>Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-34773348699760090352020-07-28T09:37:00.000-07:002020-07-28T10:17:21.803-07:00Oracle EBS R12 with Database 19c - Administration<div dir="ltr" style="text-align: left;" trbidi="on">
Oracle recently announced that Oracle Database 19c is certified with Oracle E-Business Suite Release 12.1 / 12.2. You may now start planning your database upgrade from 11g or 12c to 19c. The minimum certified version of Oracle Database 19c for Oracle EBS is Oracle Database 19c (19.3). Oracle Database 19c offers customers the best performance, scalability, reliability, and security for all their operational and analytical workloads.<br />
<br />
<h3 style="text-align: left;">
What's New For EBS With Oracle Database 19c:</h3>
<div>
<br /></div>
<div>
There are several mandatory architecture updates when you upgrade your Oracle E-Business Suite database to Oracle Database 19c. The following is a summary of the key required architectural changes:<br />
<br /></div>
<h4 style="text-align: left;">
Container Database (CDB) Architecture:</h4>
<div>
<br /></div>
<div>
With the Database 19c certification EBS R12.1/R12.2 on-premises databases are now certified with the CDB architecture (multitenant architecture).<br />
<br /></div>
<div style="text-align: left;">
It is important for you to pay particular attention to the following points:</div>
<div style="text-align: left;">
</div>
<ul style="text-align: left;">
<li>A CDB with one PDB (single tenant) is currently the only certified deployment for Oracle E-Business Suite with Database 19c.</li>
<li>A CDB with multiple PDBs (multitenant) is not currently certified for Oracle E-Business Suite.</li>
<li>A non-CDB architecture is not planned to be certified or supported for EBS with Database 19c.</li>
</ul>
<div>
As part of the upgrade to Database 19c, you will convert your EBS database to the CDB architecture with a single pluggable database (PDB) i.e EBS database.</div>
<div>
<br /></div>
<div>
In EBS 19c database, it contains two environment files one for CDB and the other one for PDB and one Context file. The CONTEXT_FILE points to PDB database. when we source the PDB environment then only we can find the database CONTEXT_FILE.</div>
<div>
<br />
All EBS specific tasks on the database side should be performed only on EBS instance, which is Pluggable database (PDB) in this case. Also, EBS specific database initialization parameters must be updated only in the pluggable database (EBS_PDB).<br />
<br />
<h4 style="text-align: left;">
Database Tier Environment Sourcing:</h4>
<ol style="text-align: left;">
<li>To source EBS CDB - <EBS CDB>_<hostname>.env </li>
<li>To source EBS PDB - <EBS PDB>_<hostname>.env </li>
</ol>
</div>
<div style="text-align: left;">
<b>1) How to source and connect the Oracle E-Business Suite CDB environment as SYSDBA?</b><br />
Oracle E-Business Suite database CDB environment files are located in the database ORACLE_HOME. </div>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Run the following commands to connect the CDB dtabase
$ cd $ORACLE_HOME
$ source <CDB_NAME<cdb_name>>_<NODE_NAME<node_name>>.env
$ sqlplus "/ as sysdba"</node_name></cdb_name></code></pre>
<div>
<h4 style="text-align: left;">
2) How to start the CDB that hosts the Oracle E-Business suite PDB?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Run the following commands to start the CDB
$ source <CDB_NAME>.<NODE_NAME>.env
<cdb_name><node_name>$ sqlplus "/ as sysdba"
SQL> startup;</node_name></cdb_name></code> </pre>
<div>
<h4 style="text-align: left;">
3) How to shutdown the CDB that hosts the Oracle E-Business suite PDB?<br />
</h4>
</div>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Run the following commands to shutdown CDB database
$ source <CDB_NAME>_<NODE_NAME>.env
<cdb_name><node_name>
$ sqlplus "/ as sysdba"
SQL> shutdown normal;</node_name></cdb_name></code></pre>
<div>
Two scripts introduced in EBS Database 19c to start and stop the CDB database and listener.</div>
<div>
<ul style="text-align: left;">
<li>adcdbctl.sh</li>
<li>adcdblnctl.sh</li>
</ul>
<h4 style="text-align: left;">
4) How to source and connect the Oracle E-Business Suite PDB environment as SYSDBA?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Run the following commands to connect the EBS PDB database
$ source <CDB_NAME>_<NODE_NAME>.env
<cdb_name><node_name>
$ export ORACLE_PDB_SID=<PDB NAME>
<pdb name="">
$ sqlplus "/ as sysdba"</pdb></node_name></cdb_name></code></pre>
<div>
<h4 style="text-align: left;">
5) How to open the Oracle E-Business Suite PDB?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Source the CDB environment file, connect to the CDB as SYSDBA, then execute the SQL command to start the PDB:
$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database<ebs name="" pdb=""> open read write services=all;</ebs></code></pre>
<div>
<h4 style="text-align: left;">
6) How to close the Oracle E-Business Suite PDB?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Source the CDB environment file, connect to the CDB as SYSDBA, then execute the SQL command to stop the PDB:
$ source <cdb_name><CDB_NAME>_<NODE_NAME><node_name>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database <EBS PDB Name> <ebs name="" pdb="">close immediate;</ebs></node_name></cdb_name></code> </pre>
</div>
</div>
</div>
<div>
<h4 style="text-align: left;">
7) How to find Oracle E-Business Suite PDB information and status?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">$ source <cdb_name><CDB_NAME>_<NODE_NAME><node_name>.env
$ sqlplus "/ as sysdba"
SQL> show pdbs;
Returns the values for the con_id, con_name, open mode, restricted values of all your PDBs.
SQL> select name, open_mode from v$pdbs;</node_name></cdb_name></code> </pre>
</div>
<div>
<h4 style="text-align: left;">
8) How to connect the Oracle E-Business Suite PDB as APPS user?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Run the following commands to connect PDB as APPS user
$ source <PDB_NAME>_<NODE_NAME><pdb_name><node_name>.env
$ sqlplus apps/apps@<PDB_NAME></node_name></pdb_name></code></pre>
</div>
<div>
<h4 style="text-align: left;">
9) How to connect the Oracle E-Business Suite PDB as SYSTEM user?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Run the following commands to connect PDB as SYSTEM user
$ source <PDB_NAME>_<NODE_NAME><pdb_name><node_name>.env
$ sqlplus system/manager@<PDB_NAME></node_name></pdb_name></code></pre>
</div>
<div>
<h4 style="text-align: left;">
10) How to access the Oracle E-Business Suite PDB while logged into the CDB?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; text-align: left; width: 100%;"><code style="color: black; word-wrap: normal;">Use the following command to set the environment, show the PDB name, and then connect to that PDB:
$ source <cdb_name><CDB_NAME>_<NODE_NAME><node_name>.env
$ sqlplus "/ as sysdba"
SQL> show pdbs;
SQL> alter session set container="PDBNAME";
</node_name></cdb_name></code>
</pre>
</div>
<div style="text-align: left;">
<h4>
11) Where to look for PDB errors if encounter a problem?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; text-align: left; width: 100%;"><code style="color: black; word-wrap: normal;">Source the environment and then review any plugin violations, as shown in the following example:
$ source <CDB_NAME>_<NODE_NAME><cdb_name><node_name>.env
$ sqlplus "/ as sysdba"
SQL> select name, cause, message, status from PDB_PLUG_IN_VIOLATIONS;
</node_name></cdb_name></code></pre>
</div>
<div style="text-align: left;">
<h4>
12) How to run AutoConfig on the database tier </h4>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; text-align: left; width: 100%;"><code style="color: black; word-wrap: normal;">You should always source the Oracle E-Business Suite PDB environment before running AutoConfig. You can do so by running the following commands:
$ cd $ORACLE_HOME
$ source <pdb_name><PDB_NAME>_<NODE_NAME><node_name>.env
Then run AutoConfig script
</node_name></pdb_name></code>
</pre>
<div style="text-align: left;">
<h4>
13) How to set up the environment to run an adgrants.sql?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; text-align: left; width: 100%;"><code style="color: black; word-wrap: normal;">Execute following steps before running Oracle E-Business Suite programs such as adgrants.sql.
$ source <cdb_name><CDB_NAME>_<NODE_NAME><node_name>.env
$ export ORACLE_PDB_SID=<PDB_NAME><pdb_name>
$ sqlplus "/ as sysdba"
</pdb_name></node_name></cdb_name></code></pre>
</div>
</div>
<div style="text-align: left;">
<h4>
14) How to run the EBS Technology Codelevel Checker (ETCC) against Oracle E-Business Suite PDB?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; text-align: left; width: 100%;"><code style="color: black; word-wrap: normal;">- The EBS Technology Codelevel Checker (ETCC) utility provides two scripts to help ensure you have the necessary database and application tier patches installed on your Oracle E-Business Suite Release 12.2 instance.
- ETCC extracts environment-related information from the context file (using the location defined in $CONTEXT_FILE), so you need to source the Oracle E-Business Suite PDB environment before you run the database checker script.
$ source <ebs name="" pdb=""><EBS PDB Name>_<NODE_NAME><node_name>.env
$ ./checkDBpatch.sh</node_name></ebs></code>
</pre>
<div style="text-align: left;">
<h4>
15) How to list the OPatch inventory for a multitenant?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; text-align: left; width: 100%;"><code style="color: black; word-wrap: normal;">You can list the OPatch inventory of a multitenant database in the same way as for non-CDB.
$ source <cdb_name><CDB_NAME>_<NODE_NAME><node_name>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ opatch lsinventory –detail</node_name></cdb_name></code>
</pre>
<div style="text-align: left;">
<h4>
16) How to set up the environment to install a database patch in an Oracle E-Business Suite multitenant database?</h4>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; text-align: left; width: 100%;"><code style="color: black; word-wrap: normal;">Source the CDB environment and add the OPatch directory to the path, as shown in the following example:
$ source <cdb_name><CDB_NAME>_<NODE_NAME><node_name>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch</node_name></cdb_name></code>
</pre>
<div style="text-align: left;">
<h4>
17) Update Database Initialization Parameter at PDB level</h4>
<div>
<ul style="text-align: left;">
<li>By default, initialization parameters at the PDB level inherit the value from the initialization parameters at the CDB level.</li>
<li>There are parameters that can be changed at the PDB level and override what is being inherited from the CDB.</li>
<li>To identify which parameters can be modified for a PDB, the ISPDB_MODIFIABLE column in the V$SYSTEM_PARAMETER view must be TRUE. If the ISPDB_MODIFIABLE is TRUE then the parameter inherits the value from the CDB until it is changed with an ALTER SYSTEM SET command at the PDB.</li>
<li>The initialization parameter set at the PDB level aren't stored in the spfile. They are stored in a data dictionary table in the root of the CDB (SYS.PDB_SPFILE$).</li>
<li>When a PDB is moved around (through an unplug/plug), the initialization parameters set at the PDB level are part of the metadata stored in the XML file used for the unplug/plug.</li>
<li>To reset a database parameter at PDB level</li>
</ul>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">source <ebs cdb=""><EBS CDB>_<hostname><hostname>.env
export ORACLE_PDB_SID=<EBS PDB SID>
<ebs pdb="" sid="">
sqlplus "/as sysdba"
Example: alter system set "_disable_actualization_for_grant"=TRUE;
<b>To check what all DB parameters can be set at PDB leve, following query can be used:</b>
SELECT NAME,ISPDB_MODIFIABLE FROM V$SYSTEM_PARAMETER WHERE UPPER(NAME) IN ('PROCESSES','SESSIONS','OPEN_CURSORS','_DISABLE_ACTUALIZATION_FOR_GRANT') ORDER BY 2,1;
<b>Check value of DB parameters at CDB and PDB level:</b>
SELECT CON_ID,NAME,DISPLAY_VALUE FROM V$SYSTEM_PARAMETER WHERE UPPER(NAME) IN ('<db parameter name>') ORDER BY 1,2,3;</ebs></hostname></ebs></code></pre>
<div>
<br /></div>
</div>
</div>
</div>
</div>
</div>
<h4 style="text-align: left;">
<a href="http://mbc-dba.blogspot.com/2020/07/UTLFILEDIR-Desupported-with-Oracle-Database-19c.html">UTL_FILE_DIR:</a></h4>
<div>
UTL_FILE_DIR is desupported with 19c database. UTL_FILE_DIR is a database pfile parameter. Which is used for EBS custom code or products requres access for read write file Operations on file system. </div>
<div>
<br /></div>
<div>
Go through the article for more details - <a href="http://mbc-dba.blogspot.com/2020/07/UTLFILEDIR-Desupported-with-Oracle-Database-19c.html">UTL_FILE_DIR Desupported with Oracle Database 19c</a></div>
<br />
<div>
Hope this article will help you.</div>
<div>
<br />
Best Regards,</div>
</div>
</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com15tag:blogger.com,1999:blog-3046621742164455904.post-10375242892572006332020-07-28T04:10:00.002-07:002020-07-28T04:12:48.633-07:00UTL_FILE_DIR Desupported with Oracle Database 19c<div dir="ltr" style="text-align: left;" trbidi="on">
<div>
UTL_FILE_DIR is desupported with 19c database. UTL_FILE_DIR is a database pfile parameter. Which is used for EBS custom code or products requres access for read write file Operations on file system. </div>
<div>
<br /></div>
<div>
In Database 19c, the UTL_FILE_DIR replaced with database directory objects.</div>
<div>
<br /></div>
<div>
With the EBS database upgrade to Database 19c, an equivalent Directory Object will be created for each UTL_FILE_DIR entry Pre-existing EBS product code and custom code will continue to function.</div>
<div>
<br /></div>
<div>
Query to find UTL_FILE_DIR location in EBS Database 19c:</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">select value from APPS.v$parameter where name='utl_file_dir';</code></pre>
<div>
<br />
<div style="text-align: left;">
<b>To add a new directory path to the UTL_FILE_DIR parameter:</b></div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">1) Source the PDB environment file
. $ORACLE_HOME/<<pdb_name>>_<<hostname>>.env
2) Create the new directory path.
For example: $mkdir /u01/debuglogdir
3) run the txkCfgUtlfileDir.pl script in addUtlFileDir mode
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME \
-outdir=$ORACLE_HOME/appsutil/log -mode=addUtlFileDir
a) When prompted, enter the passwords for the APPS user (the Oracle E-Business Suite database user) and for the SYSTEM user of the root container database (CDB).
b) When prompted, enter the physical directory path you want to add.
4) Finally, synchronize the modified UTL_FILE_DIR value with the database context file. To do so, run the txkCfgUtlfileDir.pl script in syncUtlFileDir mode using the following commands:
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=syncUtlFileDir
</code></pre>
</div>
<div style="text-align: left;">
<br /></div>
<div>
<b>To modify or delete a directory path in the UTL_FILE_DIR parameter:</b><br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">1) First, retrieve the list of directory paths that are currently stored in the UTL_FILE_DIR supplemental parameter. To do so, source the PDB environment file and then run the txkCfgUtlfileDir.pl script in getUtlFileDir mode using the following commands:
$ . $ORACLE_HOME/<<pdb_name>>_<<hostname>>.env
<pdb_name><hostname> $ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=getUtlFileDir
a) With this command, the script creates a text file named <pdbname>_utlfiledir.txt in the <oracle_home>/dbs directory.
b) Edit the text file to modify any changed directory path or delete any directory path that you no longer need. If you modify a directory path, ensure that you have created the directory at the new location.
2) To update the value of the supplemental UTL_FILE_DIR parameter with the changes
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir
3) Finally, synchronize the modified UTL_FILE_DIR value with the database context file.
$ perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=syncUtlFileDir</oracle_home></pdbname></hostname></pdb_name></code></pre>
<br />
That's it. Hope this article will help you.<br />
<br />
Best Regards..</div>
</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com9tag:blogger.com,1999:blog-3046621742164455904.post-5102652059110090592020-06-26T08:46:00.001-07:002020-06-26T08:48:20.110-07:00Opatch LsInventorySession Failed: Inventory Load Failed<div dir="ltr" style="text-align: left;" trbidi="on">
Today I have hit the following issue while executing the 'opatch lsinventory' command in 11gR2 database.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">-bash-3.2$ $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/db_hyd/11.2.0.4
Central Inventory : /u01/db_hyd/oraInventory
from : /u01/db_hyd/11.2.0.4/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/db_hyd/11.2.0.4/cfgtoollogs/opatch/opatch2020-06-23_05-36-23AM_1.log
List of Homes on this system:
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo
OPatch failed with error code 73
-bash-3.2$
</code></pre>
<br />
Based on the error message "LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo", it seems to be ORACLE_HOME '<ORACLE_HOME>' is not registered in the Central Inventory i.e 'Central Inventory : /u01/db_hyd/oraInventory'. To fix this issue we can register or attach the database ORACLE_HOME information to the existing Central Inventory.<br />
<br />
<h4 style="text-align: left;">
Execute following steps to fix this issue:</h4>
<div>
<br /></div>
<div>
1) Backup the existing oraInventory (Central Inventory : /u01/db_hyd/oraInventory)</div>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">-bash-3.2$ cp -r oraInventory oraInventory.Orig
-bash-3.2$
</code></pre>
<div>
2) Register or Attach the database ORACLE_HOME information to the existing Central Inventory using following command.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">-bash-3.2$ cd $ORACLE_HOME/oui/bin
-bash-3.2$ ./attachHome.sh
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 32767 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/db_hyd/oraInventory
'AttachHome' was successful.
-bash-3.2$ </code></pre>
3) Now execute 'OPatch lsinventory' command to check the ORACLE_HOME details<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">-bash-3.2$ $ORACLE_HOME/OPatch/opatch lsinventory -detail
</code></pre>
<br />
Hope this article will help you :-)<br />
<br /></div>
</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com1tag:blogger.com,1999:blog-3046621742164455904.post-58526902259949796412020-04-20T06:58:00.004-07:002020-04-20T08:43:22.656-07:00R12 Start Apache Throws an 'Error While Loading Shared Libraries: libdb.so.2' on Linux<div dir="ltr" style="text-align: left;" trbidi="on">
After cloning an Oracle EBS Release 12 instance on a Linux server, following error occur while starting up the Apache service.<br />
<br />
<b>Apache/HTTP Startup Log:</b><br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Executing service control script:
/u01/R12EBS/inst/apps/r12hyupg_hydhost02/admin/scripts/adapcctl.sh start
script returned:
****************************************************
You are running adapcctl.sh version 120.6.12000000.4
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
================================================================================
opmn id=hydhost02:6210
0 of 1 processes started.
ias-instance id=r12hyupg_hydhost02.hydhost02.example.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server/
Error
--> Process (index=1,uid=453192016,pid=10658)
failed to start a managed process after the maximum retry limit
Log:
/u01/R12EBS/inst/apps/r12hyupg_hydhost02/logs/ora/10.1.3/opmn/HTTP_Server~1
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile /u01/R12EBS/inst/apps/r12hyupg_hydhost02/logs/appl/admin/log/adapcctl.txt for more information ...
</code></pre>
<br />
<b>HTTP/Apache log file:</b><br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
<b>Logfile:</b> /u01/R12EBS/inst/apps/r12hyupg_hydhost02/logs/ora/10.1.3/opmn/HTTP_Server~1
20/04/20 05:52:23 Start process
--------
/u01/R12EBS/inst/apps/r12hyupg_hydhost02/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/R12EBS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory
</code></pre>
<br />
Here I noticed that, the error is very clear about the Soft link libdb.so.2 is missing.<br />
<br />
<b>Status of the Apache/HTTP_server Services: </b>http web server unable to start due to missing library.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">-bash-4.1$ ./adopmnctl.sh status apps/apps
You are running adopmnctl.sh version 120.4.12000000.3
Checking status of OPMN managed processes...
Processes in Instance: r12hyupg_hydhost02.hydhost02.example.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
default_group | oafm | 10916 | Alive
default_group | forms | 10814 | Alive
default_group | oacore | 10696 | Alive
<b>HTTP_Server | HTTP_Server | N/A | Down</b>
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/R12EBS/inst/apps/r12hyupg_hydhost02/logs/appl/admin/log/adopmnctl.txt for more information ...
-bash-4.1$</code></pre>
<br />
<b>Solution for this issue:</b><br />
<ol style="text-align: left;">
<li>Shutdown all application services.</li>
<li>create soft link for library file (ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2)</li>
<li>Startup all application services.</li>
</ol>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
<b>1) Stopped Application tier services.</b>
<b>2) Create Softlink for library file.</b>
-bash-4.1$ ls -rlt libgdbm.so.2.0.0
-rwxr-xr-x. 1 ovsroot root 24800 Jul 23 2010 libgdbm.so.2.0.0
-bash-4.1$ ls -rlt /usr/lib/libdb.so.2
ls: cannot access /usr/lib/libdb.so.2: No such file or directory
-bash-4.1$
<b># ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
#</b>
-bash-4.1$ ls -rlt libgdbm.so.2.0.0
-rwxr-xr-x. 1 ovsroot root 24800 Jul 23 2010 libgdbm.so.2.0.0
-bash-4.1$ ls -rlt /usr/lib/libdb.so.2
lrwxrwxrwx 1 ovsroot root 25 Apr 20 06:08 /usr/lib/libdb.so.2 -> /usr/lib/libgdbm.so.2.0.0
-bash-4.1$
<b>3) Started Application tier services.</b>
-bash-4.1$ cd $ADMIN_SCRIPTS_HOME
-bash-4.1$ ./adopmnctl.sh status apps/apps
You are running adopmnctl.sh version 120.4.12000000.3
Checking status of OPMN managed processes...
Processes in Instance: r12hyupg_hydhost02.hydhost02.example.com
-------------------+--------------------+---------+---------
ias-component | process-type | pid | status
-------------------+--------------------+---------+---------
default_group | oafm | 14789 | Alive
default_group | forms | 14719 | Alive
default_group | oacore | 14634 | Alive
<b>HTTP_Server | HTTP_Server | 14566 | Alive</b>
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile /u01/R12EBS/inst/apps/r12hyupg_hydhost02/logs/appl/admin/log/adopmnctl.txt for more information ...
-bash-4.1$
</code> </pre>
<br />
Hope this article will help you :-)<br />
<br /></div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-11664129498570913242020-04-14T01:07:00.001-07:002020-04-14T01:24:05.767-07:00Query To Check Concurrent Program Run History in EBS<div dir="ltr" style="text-align: left;" trbidi="on">Following query will helps you to find the history of concurrent programs run in your EBS environment.<br />
<br />
You should connect to 'apps' user for executing this query and query will prompt for "NO_OF_DAYS" and "USER_CONCURRENT_PROGRAM_NAME".<br />
<br />
NO_OF_DAYS => "Enter Number of Days for History: ";<br />
USER_CONCURRENT_PROGRAM_NAME => "Enter User Concurrent Program Name: ";<br />
<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;">-- Query To Check Concurrent Program Run History
set pages 100 linesize 200
col Parameters for a20
col "Conc Program Name" for a30
col "Started at" for a20
col "Completed at" for a20
col "Username" for a10
SELECT distinct ft.user_concurrent_program_name "Conc Program Name",
fr.REQUEST_ID "Request ID",
to_char(fr.ACTUAL_START_DATE,'dd-MON-yy hh24:mi:ss') "Started at",
to_char(fr.ACTUAL_COMPLETION_DATE,'dd-MON-yy hh24:mi:ss') "Completed at",
decode(fr.PHASE_CODE,'C','Completed','I','Inactive','P','Pending','R','Running','NA') "Phasecode",
decode(fr.STATUS_CODE, 'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold', 'I','Normal', 'M',
'No Manager', 'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused', 'X','Terminated', 'Z','Waiting') "Status",fr.argument_text "Parameters",
fu.user_name "Username",
round(((nvl(fv.actual_completion_date,sysdate)-fv.actual_start_date)*24*60),2) "ElapsedTime(Mins)"
FROM
apps.fnd_concurrent_requests fr ,
apps.fnd_concurrent_programs fp ,
apps.fnd_concurrent_programs_tl ft,
apps.fnd_user fu, apps.fnd_conc_req_summary_v fv
WHERE
fr.CONCURRENT_PROGRAM_ID = fp.CONCURRENT_PROGRAM_ID
AND fr.actual_start_date >= (sysdate - &NUMBER_OF_DAYS)
AND fr.PROGRAM_APPLICATION_ID = fp.APPLICATION_ID
AND ft.concurrent_program_id=fr.concurrent_program_id
AND fr.REQUESTED_BY=fu.user_id
AND fv.request_id=fr.request_id
and ft.user_concurrent_program_name like '&USER_CONCURRENT_PROGRAM_NAME'
order by to_char(fr.ACTUAL_COMPLETION_DATE,'dd-MON-yy hh24:mi:ss') desc; </code>
</pre><br />
Hope this query helps you. Thanks :-)<br />
<br />
</div>Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com2tag:blogger.com,1999:blog-3046621742164455904.post-48695464853557991412019-08-09T07:30:00.000-07:002019-08-09T08:45:46.087-07:00Error on WLS Patching in EBS R122 - Patch was not found in the patch catalog<div dir="ltr" style="text-align: left;" trbidi="on">
Today I have faced an issue with WLS patching and observed the MT ETCC utility has listed the patches missing from the WLS home. However some of those patches are already applied and those installed patches also listed in MT ETCC report as not applied. So I have checked whether patches are properly applied or not with using following command - "bsu.sh -report | grep -i XXXX" and observed below error message.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;">$ bsu.sh -report | grep -i XXXX
ERROR..................... Patch "XXXX" was not found in the patch catalog. Make sure your catalog is up to date.
WARNING................... Archive for Patch "XXXX" is not availabe, details skipped. Download the archive to generate the full report.
Patch ID.................. XXXX <code style="color: black; word-wrap: normal;">
$</code></pre>
Then I tried to remove that WLS patch, but got error as "Encountered unrecognized patch ID"<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;">$ sh bsu.sh -remove -patchlist=XXXX -prod_dir=$MW_HOME/wlserver_10.3 -verbose
Encountered unrecognized patch ID: XXXX </pre>
Again try to install that patch, now this time noticed that "Patch already installed:XXXX in profile: Default"<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;">$ sh bsu.sh -install -patchlist=XXXX -prod_dir=$MW_HOME/wlserver_10.3 -patch_download_dir=$MW_HOME/utils/bsu/cache_dir -verbose
Patch already installed: XXXX in profile: Default </pre>
Using below command, I have confirmed that WLS patch catalog was corrupt or missing for file system "fs1". That's why the MT ETCC is listing all patches as missing for WLS as no patch data is recorded for this home. DownloadDir (/u01/HYDINFRA/working/WLSPathces) was used non-default directory for patching and that directory (/u01/HYDINFRA/working/WLSPathces) also does not exist.<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="overflow-wrap: normal;"><your code="" here=""><span style="font-size: 12px;">$ <b>cd $FMW_HOME/utils/bsu</b>
$ <b>bsu.sh -view -status=applied -prod_dir=$FMW_HOME/wlserver_10.3</b>
ProductName: WebLogic Server
ProductVersion: 10.3 MP6
Components: WebLogic Server/Core Application Server,WebLogic Server/Admi
nistration Console,WebLogic Server/Configuration Wizard and
Upgrade Framework,WebLogic Server/Web 2.0 HTTP Pub-Sub Serve
r,WebLogic Server/WebLogic SCA,WebLogic Server/WebLogic JDBC
Drivers,WebLogic Server/Third Party JDBC Drivers,WebLogic S
erver/WebLogic Server Clients,WebLogic Server/WebLogic Web S
erver Plugins,WebLogic Server/UDDI and Xquery Support,WebLog
ic Server/Evaluation Database,WebLogic Server/Workshop Code
Completion Support
BEAHome: /u01/HYDINFRA/R122EBS/fs1/FMW_Home
ProductHome: /u01/HYDINFRA/R122EBS/fs1/FMW_Home/wlserver_10.3
PatchSystemDir: /u01/HYDINFRA/R122EBS/fs1/FMW_Home/utils/bsu
PatchDir: /u01/HYDINFRA/R122EBS/fs1/FMW_Home/patch_wls1036
Profile: Default
<b><span style="color: blue;">DownloadDir: /u01/HYDINFRA/working/WLSPathces</span></b>
JavaVersion: 1.6.0_29
JavaVendor: Sun
Patch ID: XXXX
Patch ID: XXXX
Patch ID: XXXX (XXXXXXXX)
Patch ID: XXXX (XXXXXXXX)
Patch ID: XXXX (XXXXXXXX)
Patch ID: XXXX (XXXXXXXX)
Patch ID: XXXX (XXXXXXXX)
Patch ID: XXXX (XXXXXXXX)
Patch ID: XXXX (XXXXXXXX)
Patch ID: XXXX (XXXXXXXX)
$</span></your></code><span style="font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace;"><span style="font-size: 12px;">
</span></span></pre>
<br />
<h4 style="text-align: left;">
Workaround for this issue:</h4>
<div>
<br /></div>
<div>
1) Created same directory structure and copied all missing patch information.</div>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"><your code="" here="">$ mkdir -p /u01/HYDINFRA/working/WLSPathces
$ cp -r /u01/HYDINFRA/R122EBS/fs1/FMW_Home/utils/bsu/cache_dir/* /u01/HYDINFRA/working/WLSPathces</your></code></pre>
2) Re-tested BSU report and confirmed that no errors now.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"><your code="" here="">$ bsu.sh -report | grep -i XXXX
Patch ID.................. XXXX</your></code></pre>
3) Re-ran MT ETCC checker and noticed correct results returned.<br />
<br />
To overcome this issue permanently, you need to ensure the next patch will be applied on the correct/default patch_download_dir.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;"><your code="" here="">$ cd $FMW_HOME/utils/bsu
$ bsu.sh -install -verbose -patchlist=XXXX -prod_dir=$FMW_HOME/wlserver_10.3 -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir </your></code></pre>
<br />
Thats it. Hope this article will help you.<br />
<br />
Thanks,<br />
Chowdari</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com1tag:blogger.com,1999:blog-3046621742164455904.post-25710523052660577162019-07-11T08:38:00.001-07:002019-08-21T03:42:48.376-07:00Oracle Database 19c Installation on Oracle Linux 7 (OL7)<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">
This article describes the installation of Oracle Database 19c on Oracle Linux 7 (OL7) on VirtualBox.<br />
<br />
<h3 style="text-align: left;">
Introduction:</h3>
For installing 19c in your laptop or desktop, computer should have minimum 4 GB or more of RAM required, and minimum 30GB or more of storage required.<br />
<br />
This article uses the 64-bit versions of Oracle Linux 7 and Oracle 19c.<br />
<br />
<b>Prerequisite:</b> Oracle Linux 7 Install on VirtualBox<br />
<br />
<h3 style="text-align: left;">
Download Software:</h3>
Download Oracle 19c database software for Linux x86-64 from OTN or edelivery and copy the files to linux server (on VirtualBox) using winscp or shared folder.<br />
<br />
<h3 style="text-align: left;">
<b>Oracle Installation Prerequisites</b></h3>
<div>
Either you can perform Automatic setup or Manual setup to complete the prerequisites.<br />
<br /></div>
<div>
<h4 style="text-align: left;">
Automatic Setup:</h4>
Install "oracle-database-preinstall-19c" package to perform all prerequisite setup. use the following command</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># yum install -y oracle-database-preinstall-19c </code></pre>
<div>
<h4 style="text-align: left;">
Manual Setup:</h4>
</div>
<div>
If you have not used the "oracle-database-preinstall-19c" package to perform all prerequisites, you have to manually perform the following setup tasks.</div>
<div>
<br /></div>
<a name='more'></a><br />
<div style="text-align: left;">
<b>OS Configuration and Preparation:</b></div>
<div style="text-align: left;">
1) Add the following lines to the "/etc/sysctl.conf" file</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
</code></pre>
<div>
2) Run the following command to change the current kernel parameters.<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># /sbin/sysctl -p
</code></pre>
<div>
3) Add the following lines to "/etc/security/limits.conf" file</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
</code></pre>
<div>
4) The following packages are listed as required. Many of the packages should be installed already.</div>
</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"><span style="font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace;"><span style="font-size: 12px;"># OL7
yum install bc
yum install binutils
yum install compat-libcap1
yum install compat-libstdc++
yum install dtrace-modules
yum install dtrace-modules-headers
yum install dtrace-modules-provider-headers
yum install dtrace-utils
yum install elfutils-libelf
yum install elfutils-libelf-devel
yum install fontconfig-devel
yum install glibc
yum install glibc-devel
yum install ksh
yum install libaio
yum install libaio-devel
yum install libdtrace-ctf-devel
yum install libXrender
yum install libXrender-devel
yum install libX11
yum install libXau
yum install libXi
yum install libXtst
yum install libgcc
yum install librdmacm-devel
yum install libstdc++
yum install libstdc++-devel
yum install libxcb
yum install make
yum install net-tools (for Oracle RAC and Oracle Clusterware)
yum install nfs-utils (for Oracle ACFS)
yum install python (for Oracle ACFS Remote)
yum install python-configshell (for Oracle ACFS Remote)
yum install python-rtslib (for Oracle ACFS Remote)
yum install python-six (for Oracle ACFS Remote)
yum install targetcli (for Oracle ACFS Remote)
yum install smartmontools
yum install sysstat </span></span><span style="font-family: "times new roman";"><span style="white-space: normal;">
</span></span></code></pre>
To determine whether the required packages are installed, enter commands similar to the following:<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; margin: 0px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># rpm -q package_name
</code></pre>
<div class="MsoNormal">
<div style="margin: 0px;">
<span style="font-family: "calibri" , sans-serif; font-size: 11pt; line-height: 15.6933px;"><o:p></o:p></span></div>
</div>
</div>
Alternatively, if you require specific system architecture information, then enter the following command:<br />
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: "Times New Roman"; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" | grep package_name </code></pre>
</div>
You can also combine a query for multiple packages, and review the output for the correct versions. For example:<br />
<div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># rpm -q binutils compat-libstdc++ gcc glibc libaio libgcc libstdc++ make sysstat unixodbc
</code></pre>
<div class="MsoNormal">
<span style="font-family: "calibri" , sans-serif; font-size: 11pt; line-height: 15.6933px;"><o:p></o:p></span></div>
</div>
If a package is not installed, then install it from your Linux distribution media or download the required package version from your Linux distributor's website.<br />
<br />
5) Create the new groups and users.<br />
<div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">#groups for database management
# groupadd -g 2000 oinstall
# groupadd -g 2001 dba
# groupadd -g 2003 oper
</code></pre>
<div class="MsoNormal">
<span style="font-family: "calibri" , sans-serif; font-size: 11pt; line-height: 15.6933px;"><o:p></o:p></span></div>
</div>
<div>
<span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;">Add user Oracle for database software</span><br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># useradd -u 1000 -g oinstall -G dba,oper oracle
</code></pre>
6) Set the password for the "oracle" user.<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># passwd oracle
</code></pre>
</div>
<div>
<code style="overflow-wrap: normal;"></code><br />
<div style="font-family: "Times New Roman";">
7) Create directory structure as user root</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"><code style="overflow-wrap: normal;">$ mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
$ chown -R oracle:oinstall /u01
$ chmod -R 775 /u01
</code></code></pre>
<div style="font-family: "Times New Roman";">
<div>
</div>
</div>
</div>
<h3 style="text-align: left;">
Installation:</h3>
<div>
1) Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">DISPLAY=<machine-name>:0.0; export DISPLAY
</code></pre>
2) Set environment variables and copy 19c zip file to database ORACLE_HOME location and then unzip. Start the Oracle Universal Installer (OUI) by issuing the following command.<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">$ export ORACLE_BASE=/u01/app/oracle
$ export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
$ export PATH=$ORACLE_HOME/bin:$PATH
# Unzip software.
cd $ORACLE_HOME
unzip LINUX.X64_193000_db_home.zip
$ pwd
/u01/app/oracle/product/19.0.0/dbhome_1
$ ./runInstaller
Launching Oracle Database Setup Wizard...
</code></pre>
<div>
3) Here I have choosen "Set Up Software Only", to install the database software.You can choose "Create and configure a single instance database" option, If you want to install database software and create database in single shot.. In this article, I will create database separately using DBCA.<br />
<br />
Click Next to continue the 19c installation.</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilwNm3svpC2qKXzkMjtG7tEPslK0bNY-TdNKZHfGKBHcC5KAHqcfyJuHBut7DdfoVsIyBgZgHc1zLNuwf3sRp8bVGqMBJX4UyRUNZwXvnZDbFckuKWTlw2w_-KyuHBpSDomJMSyUclmpY/s1600/2_mbc-dba_19c_Installation_ConfigOption.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="607" data-original-width="803" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilwNm3svpC2qKXzkMjtG7tEPslK0bNY-TdNKZHfGKBHcC5KAHqcfyJuHBut7DdfoVsIyBgZgHc1zLNuwf3sRp8bVGqMBJX4UyRUNZwXvnZDbFckuKWTlw2w_-KyuHBpSDomJMSyUclmpY/s640/2_mbc-dba_19c_Installation_ConfigOption.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
4) Select Database Installation Option, Accept default "Single instance database installation" and click Next button </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy-_q9hK_J4lKXn3v59i_vRR7sNxrYmhqhyuNvnsyQQ2b7rWTlFTgUGAsqnvtfHeDzog1GaWiNXah_td_67Wb3tyL21uPUde6lKJ7FQjdHY5ABjj2Xm8MNgtRB45yUI6n6McEsKCEX4yk/s1600/03_mbc-dba_19c_Installation_DBInstallationOption.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="612" data-original-width="803" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjy-_q9hK_J4lKXn3v59i_vRR7sNxrYmhqhyuNvnsyQQ2b7rWTlFTgUGAsqnvtfHeDzog1GaWiNXah_td_67Wb3tyL21uPUde6lKJ7FQjdHY5ABjj2Xm8MNgtRB45yUI6n6McEsKCEX4yk/s640/03_mbc-dba_19c_Installation_DBInstallationOption.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
5) Select Database Edition, You can select here type of binaries to install. Once it’s done click Next button.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFWgJ5IVwXGr2uaUtawhYzshvGRB5xU6VH29nPwCdE9DLxZMcPGXro2F3wizGxj9WLXGC-tDxy9p7aXrlp4H5u3ENS7IjybGMyYEYvqB6KCw127_2XyNTb_iAt-LXzHd7zdQ8PtyJcLn0/s1600/04_mbc-dba_19c_Installation_DatabaseEdition.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="598" data-original-width="797" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFWgJ5IVwXGr2uaUtawhYzshvGRB5xU6VH29nPwCdE9DLxZMcPGXro2F3wizGxj9WLXGC-tDxy9p7aXrlp4H5u3ENS7IjybGMyYEYvqB6KCw127_2XyNTb_iAt-LXzHd7zdQ8PtyJcLn0/s640/04_mbc-dba_19c_Installation_DatabaseEdition.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
6) Specify Installation Location, here you should see directories for ORACLE_BASE and ORACLE_HOME for your binaries according to environmental settings. Click Next button.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl8klyRpqx8zuVfBQYZYP-xSHUNcp0pQjeUm9SxYVdtCWF2Gf2VMATDngQnz5KYxkikdi89L74aJwfZMAr6x2pcPj28K2ayyNsruU4bqOgs4J4JuFL432Vp7tCvAylrhV39libQ4R99dU/s1600/05_mbc-dba_19c_Installation_InstallationLocation.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="609" data-original-width="805" height="484" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgl8klyRpqx8zuVfBQYZYP-xSHUNcp0pQjeUm9SxYVdtCWF2Gf2VMATDngQnz5KYxkikdi89L74aJwfZMAr6x2pcPj28K2ayyNsruU4bqOgs4J4JuFL432Vp7tCvAylrhV39libQ4R99dU/s640/05_mbc-dba_19c_Installation_InstallationLocation.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
7) Operating system groups, here you can specify OS group for each oracle group. Change default groups to dba and oinstall and click Next button.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc7XjFx9FCygNqI5q2D4sseC3Pyo4XF7I1ik7cfYoBQzcr8JETPv-KAPybTiMVmMReOCVo_w3HmglDE7fQeSXMJ6PbtAme_jkeVaPBgJSO7JQZJZmrURuJC3c9obOEBc1u66mlTchK4JI/s1600/06_mbc-dba_19c_Installation_OperatingSystemGroups.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="613" data-original-width="805" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc7XjFx9FCygNqI5q2D4sseC3Pyo4XF7I1ik7cfYoBQzcr8JETPv-KAPybTiMVmMReOCVo_w3HmglDE7fQeSXMJ6PbtAme_jkeVaPBgJSO7JQZJZmrURuJC3c9obOEBc1u66mlTchK4JI/s640/06_mbc-dba_19c_Installation_OperatingSystemGroups.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Click Next</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsLhNq-er0jvlNwwxUbfRXAg4O2H5E7t3cm1TGH9qcXqGVSjOQB0yUZk_9TorEFDHV9gMEzrDT2NUYi7NbYaiZf4F1HHb-0fuGQBsv8fdRS6AxDg9faR9MYS6h1mEtuRCmwbeSZ8OTJA0/s1600/07_mbc-dba_19c_Installation_RootScriptExecution.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="611" data-original-width="803" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsLhNq-er0jvlNwwxUbfRXAg4O2H5E7t3cm1TGH9qcXqGVSjOQB0yUZk_9TorEFDHV9gMEzrDT2NUYi7NbYaiZf4F1HHb-0fuGQBsv8fdRS6AxDg9faR9MYS6h1mEtuRCmwbeSZ8OTJA0/s640/07_mbc-dba_19c_Installation_RootScriptExecution.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWNM6c5ErUGdRM4JJtFeye6Tkjharenj7H5QXmSg9k51cR1ZIfwTJrMVe64IuriwOD1SNzJjc5Xh8b89VIsQND_jDnvn86kSC9iK2Y67tzKjtbhQLivL6Dh2a5u5D09N32Al3eUQudkM8/s1600/08_mbc-dba_19c_Installation_PrereqChecks.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="604" data-original-width="801" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWNM6c5ErUGdRM4JJtFeye6Tkjharenj7H5QXmSg9k51cR1ZIfwTJrMVe64IuriwOD1SNzJjc5Xh8b89VIsQND_jDnvn86kSC9iK2Y67tzKjtbhQLivL6Dh2a5u5D09N32Al3eUQudkM8/s640/08_mbc-dba_19c_Installation_PrereqChecks.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
8) Check Prerequisite checks for 19c database installation and click Next</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk1E1AjFQcE3Yp6s6dH3n7ue_8KNeCiaj8T-pl1Piaxeeg8uA_dqwAwngEAmFNOEok9VU87zDyp0zk0ULTxcfWhax5wdjQSHARy1T3Uta60kMaPn3NWkFS0o8fZIZX3aU5NUX_Wyl7XGQ/s1600/09_mbc-dba_19c_Installation_PrereqChecks1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="616" data-original-width="806" height="488" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk1E1AjFQcE3Yp6s6dH3n7ue_8KNeCiaj8T-pl1Piaxeeg8uA_dqwAwngEAmFNOEok9VU87zDyp0zk0ULTxcfWhax5wdjQSHARy1T3Uta60kMaPn3NWkFS0o8fZIZX3aU5NUX_Wyl7XGQ/s640/09_mbc-dba_19c_Installation_PrereqChecks1.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
9) Summary, If everything is fine, then click Install button. It’s the last moment to come back to each of previous point and make changes.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRc2ASguu6W8PIEikZcIyCNnP0tGqE5rzjLGUlRKvv-QOhZDMVvKqOCJrmb0h63ggEWHl4PMg8Ovg7jCaMyrbs3MQz7TDTC5kKSnQnSIIgqSUwlkV6i7jluG3bqYZqZYypCWXXNQZEG80/s1600/10_mbc-dba_19c_Installation_Summary.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="609" data-original-width="803" height="484" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRc2ASguu6W8PIEikZcIyCNnP0tGqE5rzjLGUlRKvv-QOhZDMVvKqOCJrmb0h63ggEWHl4PMg8Ovg7jCaMyrbs3MQz7TDTC5kKSnQnSIIgqSUwlkV6i7jluG3bqYZqZYypCWXXNQZEG80/s640/10_mbc-dba_19c_Installation_Summary.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
Product Installation in-progress</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_7x3B7NxW-tCpoBNEaO5UXeXxAjG1D8lk7b5z1KZmdtq2bZsWF4JuB90o2o661HTNAztuToOAMUapUmwE6nSSpsOhclQDruUv1dkPHOCaQnd-YeO71Rh-8YayDJ0Uks7kfccp_QJwV2k/s1600/11_mbc-dba_19c_Installation_InstallProduct.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="607" data-original-width="799" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_7x3B7NxW-tCpoBNEaO5UXeXxAjG1D8lk7b5z1KZmdtq2bZsWF4JuB90o2o661HTNAztuToOAMUapUmwE6nSSpsOhclQDruUv1dkPHOCaQnd-YeO71Rh-8YayDJ0Uks7kfccp_QJwV2k/s640/11_mbc-dba_19c_Installation_InstallProduct.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
10) Execute configuration script, once binaries are installed the last step is to run root.sh script as user root. </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUXfl9U7pnnGxYB7jOJbmky_793B7yNLBEaXZMiH3UjJ9t0JTYWmlChFI1UAvKCVzgd4Ay_iWH1WHwnvYalXyHv_X8Y1OM8Dj28bzQgqDGwpdTSXbkvXVzbnQoj_S3GbGSBGB-3aAis3w/s1600/12_mbc-dba_19c_Installation_ExecuteConfigScript.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="613" data-original-width="843" height="464" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUXfl9U7pnnGxYB7jOJbmky_793B7yNLBEaXZMiH3UjJ9t0JTYWmlChFI1UAvKCVzgd4Ay_iWH1WHwnvYalXyHv_X8Y1OM8Dj28bzQgqDGwpdTSXbkvXVzbnQoj_S3GbGSBGB-3aAis3w/s640/12_mbc-dba_19c_Installation_ExecuteConfigScript.JPG" width="640" /></a></div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/19.0.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Oracle Trace File Analyzer (TFA - Standalone Mode) is available at :
/u01/app/oracle/product/19.0.0/dbhome_1/bin/tfactl
Note :
1. tfactl will use TFA Service if that service is running and user has been granted access
2. tfactl will configure TFA Standalone Mode only if user has no access to TFA Service or TFA is not installed
#
</code></pre>
<div>
11) After successful installation click Close button.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpM38s7hIXO1Mu-jABRTUDSUh77LwZU8RDf9-Eml_PPbZZCz2QGNQm3tm4QDWgeF_r2XO0Ec1CpZzAZKUqHVaOieYyt3JYeyMB6AF9RxmU4uvaUwWqDxiVvTaVLvbChQ2goOcHZkBY1TE/s1600/13_mbc-dba_19c_Installation_Completed.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="614" data-original-width="801" height="490" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpM38s7hIXO1Mu-jABRTUDSUh77LwZU8RDf9-Eml_PPbZZCz2QGNQm3tm4QDWgeF_r2XO0Ec1CpZzAZKUqHVaOieYyt3JYeyMB6AF9RxmU4uvaUwWqDxiVvTaVLvbChQ2goOcHZkBY1TE/s640/13_mbc-dba_19c_Installation_Completed.JPG" width="640" /></a></div>
<h3 style="clear: both; text-align: left;">
Database Creation:</h3>
<div>
Creating database using the Database Configuration Assistant (DBCA). </div>
<div>
<br /></div>
<div>
1) Invoke DBCA</div>
<div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;"># dbca
</code></pre>
</div>
<div>
2) Select Create a database option and click Next</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxqIbQ9a0dy5S79E4gLmfqvuzp7bXjHnTNxWJ3HyLJwLY01LalA26E1IyTZWQXQl-TLOu6MLrGSChqlqpPUaoi9JCndd9Ehj8m4ae1XOGmoMVGO9IYcTQ_tfiVpschz8DiJ3hw4jYWFfM/s1600/15_mbc-dba_19c_DBCreation_DatabaseOperation.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="610" data-original-width="801" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhxqIbQ9a0dy5S79E4gLmfqvuzp7bXjHnTNxWJ3HyLJwLY01LalA26E1IyTZWQXQl-TLOu6MLrGSChqlqpPUaoi9JCndd9Ehj8m4ae1XOGmoMVGO9IYcTQ_tfiVpschz8DiJ3hw4jYWFfM/s640/15_mbc-dba_19c_DBCreation_DatabaseOperation.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
3) Select Creation Mode as Advanced Configuration and click Next</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyRfsQ68D8EAh_swA6hrBe1wHn5hGtB0GWRPoCX1hEzQDtN-eZ3wN2Pz5oU7D0FPTnOLsEo7US1XamfBI6qcA2YiT0wqc2vYHwwm2tYYEmwP0FVyPUDHYCmyzd-WtFg7AZX1Fk22WejbE/s1600/16_mbc-dba_19c_DBCreation_CreationMode.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="615" data-original-width="800" height="492" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyRfsQ68D8EAh_swA6hrBe1wHn5hGtB0GWRPoCX1hEzQDtN-eZ3wN2Pz5oU7D0FPTnOLsEo7US1XamfBI6qcA2YiT0wqc2vYHwwm2tYYEmwP0FVyPUDHYCmyzd-WtFg7AZX1Fk22WejbE/s640/16_mbc-dba_19c_DBCreation_CreationMode.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
4) select Database Deployment as General Purpose or Transnational Processing and click Next </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiWkD-io7mjutoDPVFSybr_bX1H4Y5ps9k6OOL2SwTBgPwHYitZEIJq6Wh0xNEAIecLyuQO-7YMnzG7dGQNuQRJFLHqQ51SqxRuoVOCRuuEDNRawu1mAPxo3TvglHMjQoQ0STEYQGKHlA/s1600/17_mbc-dba_19c_DBCreation_deploymentType.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="611" data-original-width="801" height="488" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgiWkD-io7mjutoDPVFSybr_bX1H4Y5ps9k6OOL2SwTBgPwHYitZEIJq6Wh0xNEAIecLyuQO-7YMnzG7dGQNuQRJFLHqQ51SqxRuoVOCRuuEDNRawu1mAPxo3TvglHMjQoQ0STEYQGKHlA/s640/17_mbc-dba_19c_DBCreation_deploymentType.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
5) Enter Database name and If you want to create pluggable database then choose Create a container database with one or more PDBs option and creare Pluggable Database. Then Click Next</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaGGPl_hSE_me3ybNu0xYwLjuJi8DotHDHoFEdAehumFIQczatcgvkPoSZbFD_rtdmKLpkxDRqhkcANLcMeELg7cMHXEQE84dTaTGezV5nhGiC3yVUewDKrA7heVAd7TC9iu5hYEnoMtI/s1600/18_mbc-dba_19c_DBCreation_DatabaseIdentification.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="605" data-original-width="804" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaGGPl_hSE_me3ybNu0xYwLjuJi8DotHDHoFEdAehumFIQczatcgvkPoSZbFD_rtdmKLpkxDRqhkcANLcMeELg7cMHXEQE84dTaTGezV5nhGiC3yVUewDKrA7heVAd7TC9iu5hYEnoMtI/s640/18_mbc-dba_19c_DBCreation_DatabaseIdentification.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
6) Choose database file location and click Next</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQkhHm4dzAAK6NGii1ICWjgelo-MLJQY1ARgEBz3O5x30McGOhftv1KuqoAtGY0YetpiIEBHl1-KgjwWvFVNVt2TmJhLEgLt3tT-Hh_Eh3sGD0OYmtnIQbgTC2lrKM-8hPzEwcTWgjaE/s1600/19_mbc-dba_19c_DBCreation_StorageOptions.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="616" data-original-width="798" height="494" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQkhHm4dzAAK6NGii1ICWjgelo-MLJQY1ARgEBz3O5x30McGOhftv1KuqoAtGY0YetpiIEBHl1-KgjwWvFVNVt2TmJhLEgLt3tT-Hh_Eh3sGD0OYmtnIQbgTC2lrKM-8hPzEwcTWgjaE/s640/19_mbc-dba_19c_DBCreation_StorageOptions.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
7) Its a testing machine so not Enabling Archive log mode for the Database. If you want to enable Archive log mode then choose both options and Click Next</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBAm-52CO_gRGhxvF8l6h2avATVTJC9lkpsOD-pecHCL0_4EIhjDWh5saEta88N6aAq5cNVnsc6ZqxSH3-LBFfN-FQ-vV9tQMXDR1E1UNTJcXeGMEnvOHCmzqhjT_SVzpV63DNsv8V_LE/s1600/20_mbc-dba_19c_DBCreation_FlashRecoveryOption.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="612" data-original-width="808" height="484" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBAm-52CO_gRGhxvF8l6h2avATVTJC9lkpsOD-pecHCL0_4EIhjDWh5saEta88N6aAq5cNVnsc6ZqxSH3-LBFfN-FQ-vV9tQMXDR1E1UNTJcXeGMEnvOHCmzqhjT_SVzpV63DNsv8V_LE/s640/20_mbc-dba_19c_DBCreation_FlashRecoveryOption.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
8) Click Next. </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAY-kmiBEF82dnrgb7HNd6bImcM4M3oyDOURqsmkRfAVxWlrBPH2O0RUEpVKUW68Ew1obczX2_mnUH1Lsn2yf5ln-Ykxpg_vlHD6PFfqqqNPnSnBBDex_8TpXqK6QoAn8wYhDUVTZWHOI/s1600/21_mbc-dba_19c_DBCreation_NetworkConfiguration.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="604" data-original-width="803" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAY-kmiBEF82dnrgb7HNd6bImcM4M3oyDOURqsmkRfAVxWlrBPH2O0RUEpVKUW68Ew1obczX2_mnUH1Lsn2yf5ln-Ykxpg_vlHD6PFfqqqNPnSnBBDex_8TpXqK6QoAn8wYhDUVTZWHOI/s640/21_mbc-dba_19c_DBCreation_NetworkConfiguration.JPG" width="640" /></a></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicLNyIYgaGVNRuaS5LMOjKwB15YWGRgqrpI88k21lRqYkDPC8F7Xub-J2Cj7Tw1PH6xAZG33gCnNagJhe7dz92ceuZCVkxcwriOnDkf09e8h_d92-cBUE0fTIom-BMjgJcYEv9iBWPQQY/s1600/22_mbc-dba_19c_DBCreation_DataVault.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="610" data-original-width="801" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicLNyIYgaGVNRuaS5LMOjKwB15YWGRgqrpI88k21lRqYkDPC8F7Xub-J2Cj7Tw1PH6xAZG33gCnNagJhe7dz92ceuZCVkxcwriOnDkf09e8h_d92-cBUE0fTIom-BMjgJcYEv9iBWPQQY/s640/22_mbc-dba_19c_DBCreation_DataVault.JPG" width="640" /></a><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFVtrwTMfva5QzoR3RZvo_waigvW_EQ2OWj1QWMG-pJlLGHkeKEnh_tOLwRWcSYG2Qf5dZpq73fg33JT1FJxzGDp-CJBo88jc7l3BlY8NAgazq79sCzvJxT7iqy1eUT-fOQPHfPRx2BZ0/s1600/23_mbc-dba_19c_DBCreation_ConfigOptions.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="608" data-original-width="799" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFVtrwTMfva5QzoR3RZvo_waigvW_EQ2OWj1QWMG-pJlLGHkeKEnh_tOLwRWcSYG2Qf5dZpq73fg33JT1FJxzGDp-CJBo88jc7l3BlY8NAgazq79sCzvJxT7iqy1eUT-fOQPHfPRx2BZ0/s640/23_mbc-dba_19c_DBCreation_ConfigOptions.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKIuEW6VS4VRkmy3wftby3310W_RpgMdj0D5-9BErGtRLsbofYRRKeYb6OnemEao-bQkZUgtsIbtADaDnoBZzk5myaUP3zkP1u3xhRl7RnWzwqbHU1fqoXOQon183KA6H9DmzT88dmhYs/s1600/24_mbc-dba_19c_DBCreation_ManagementOptions.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="616" data-original-width="802" height="490" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhKIuEW6VS4VRkmy3wftby3310W_RpgMdj0D5-9BErGtRLsbofYRRKeYb6OnemEao-bQkZUgtsIbtADaDnoBZzk5myaUP3zkP1u3xhRl7RnWzwqbHU1fqoXOQon183KA6H9DmzT88dmhYs/s640/24_mbc-dba_19c_DBCreation_ManagementOptions.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
9) Enter Administrative password and click Next</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha9Fn3FgX4n1KWeHGJUwjK5IMgTqri8tfOW6lsw6pdKk90ckjXzIKjC7uqhjH2ZjCD81IA7anAiWirnDXhhyphenhyphen2LNJfalvuQX10N7DBwzoBQvoyAoeLVb-g0oTV7tc__XhNSBnTIn5XiliM/s1600/25_mbc-dba_19c_DBCreation_UserCredentials.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="608" data-original-width="800" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEha9Fn3FgX4n1KWeHGJUwjK5IMgTqri8tfOW6lsw6pdKk90ckjXzIKjC7uqhjH2ZjCD81IA7anAiWirnDXhhyphenhyphen2LNJfalvuQX10N7DBwzoBQvoyAoeLVb-g0oTV7tc__XhNSBnTIn5XiliM/s640/25_mbc-dba_19c_DBCreation_UserCredentials.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
10) Choose Create Database option and click Next</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgl-eQsVxCcwI6ijL3L2o0B_0mkj7OvBdQAdnZzPqLqxJW-U7umXgutoXvHXiBzFn_8vyLzgXT_s-ZumB_H2VGHvRQh4HjKM_OHygIDDwAY4bqAxSWf_AtRgCOvXg-eqGCTUdVhG-z7Tc/s1600/26_mbc-dba_19c_DBCreation_CreationOption.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="609" data-original-width="800" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhgl-eQsVxCcwI6ijL3L2o0B_0mkj7OvBdQAdnZzPqLqxJW-U7umXgutoXvHXiBzFn_8vyLzgXT_s-ZumB_H2VGHvRQh4HjKM_OHygIDDwAY4bqAxSWf_AtRgCOvXg-eqGCTUdVhG-z7Tc/s640/26_mbc-dba_19c_DBCreation_CreationOption.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
11) Summary, If everything is fine, then click Finish button to create the database. If you want to make any changes click back button and modify accordingly.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIwCwTEfm6jbItFzx_1588KpiDnKbWrrPN810hTm9ZDytO7B-HWDTe9d58S3EIsWo4FqSdkm0cDLN6DWEQcfGjb_o1LwZobVphF8Xe9vHCcmRFq3t_rE0I1AToGxSDXjHkWVvL1mnCvSc/s1600/27_mbc-dba_19c_DBCreation_Summary.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="612" data-original-width="805" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIwCwTEfm6jbItFzx_1588KpiDnKbWrrPN810hTm9ZDytO7B-HWDTe9d58S3EIsWo4FqSdkm0cDLN6DWEQcfGjb_o1LwZobVphF8Xe9vHCcmRFq3t_rE0I1AToGxSDXjHkWVvL1mnCvSc/s640/27_mbc-dba_19c_DBCreation_Summary.JPG" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWDbfHbeM7gnzzYyTLWIj52g_YJoO0q1qwv1oTDnD9RssfdAx4pl76XQgCj-SLFoa7bI8kpHmycAOAOMbzayhcdWpk-J56dkyR2XsYvWhXWhp8bdulDXT0jJFUqDQOcxiGZo9OWRfqhpA/s1600/28_mbc-dba_19c_DBCreation_ProgressPage.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="614" data-original-width="806" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgWDbfHbeM7gnzzYyTLWIj52g_YJoO0q1qwv1oTDnD9RssfdAx4pl76XQgCj-SLFoa7bI8kpHmycAOAOMbzayhcdWpk-J56dkyR2XsYvWhXWhp8bdulDXT0jJFUqDQOcxiGZo9OWRfqhpA/s640/28_mbc-dba_19c_DBCreation_ProgressPage.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
12) Click Close button.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYvUPvWC6m9GmIP2Uio2Jwq_7aKc97nq_UzInsUcC2yU2l9S7xtYMn87mx8WUKsyKYwaUHx4fWFRVCTfWF8GIX8Vv2iw7KQZzRpc4VoqteWWE2QQueBAYt4Yfcz4vdVaU5PNWYG_IELxw/s1600/29_mbc-dba_19c_DBCreation_Finish.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="608" data-original-width="798" height="486" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYvUPvWC6m9GmIP2Uio2Jwq_7aKc97nq_UzInsUcC2yU2l9S7xtYMn87mx8WUKsyKYwaUHx4fWFRVCTfWF8GIX8Vv2iw7KQZzRpc4VoqteWWE2QQueBAYt4Yfcz4vdVaU5PNWYG_IELxw/s640/29_mbc-dba_19c_DBCreation_Finish.JPG" width="640" /></a></div>
After successful creation of database check the database status.<br />
<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="overflow-wrap: normal;">$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jul 11 07:10:41 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select instance_name, status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
orcl19c OPEN
SQL> select banner from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL>
</code></pre>
<div>
<code style="overflow-wrap: normal;"><br />
</code></div>
That's it. Completed the Oracle database 19c Installation and creating a database.<br />
<br />
Hope this article will help you and please give your valuable comments !!<br />
<br />
Thanks,<br />
Chowdari</div>
</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com5tag:blogger.com,1999:blog-3046621742164455904.post-4074135998946763912019-02-21T04:08:00.000-08:002019-07-11T08:45:41.656-07:00ORA-16698: 12c Dataguard Broker Setup Error<div dir="ltr" style="text-align: left;" trbidi="on">
Recently I have configured dataguard on 12c database. While configuring dataguard broker I have encountered an "Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added"<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[oracle@primdb dbs]$ dgmgrl
DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production
Copyright (c) 2000, 2013, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/dataguard
Connected as SYSDG.
DGMGRL> CREATE CONFIGURATION 'DR_Config' AS PRIMARY DATABASE IS 'primdb' CONNECT IDENTIFIER IS primdb;
Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added
Failed.
DGMGRL>
SQL></code>
</pre>
<br />
<h2 style="text-align: left;">
<span style="font-size: x-large;">Solution:</span></h2>
Generally you will not receive this error on earlier database versions (Pre 12c). As per Oracle database 12c documentation, "Any LOG_ARCHIVE_DEST_n parameters that have the SERVICE attribute set, and if the NOREGISTER attribute is Not set, then you must remove/clear the 'LOG_ARCHIVE_DEST_n' before creating the broker configuration". Clear archive destination for both primary and standby side and then configure the Dataguard broker.<br />
<br />
Once you complete the DataGuard broker setup then revert back the LOG_ARCHIVE_DEST parameter to old values in both primary and standby side.<br />
<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; overflow-wrap: normal;"><h3 style="font-size: 12px; text-align: left;">
On Primary Side:</h3>
<span style="font-size: 12px;">
SQL> show parameter LOG_ARCHIVE_DEST_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=standb ASYNC VALID_FO
R=(ONLINE_LOGFILES,PRIMARY_ROL
E) DB_UNIQUE_NAME=standb
SQL>
SQL> alter system set LOG_ARCHIVE_DEST_2='' scope=both;
System altered.
SQL>
DGMGRL> CREATE CONFIGURATION 'DR_Config' AS PRIMARY DATABASE IS 'primdb' CONNECT IDENTIFIER IS primdb;
Configuration "DR_Config" created with primary database "primdb"
DGMGRL>
DGMGRL> show configuration;
Configuration - DR_Config
Protection Mode: MaxPerformance
Members:
primdb - Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED
DGMGRL>
</span>
<h3 style="font-size: 12px; text-align: left;">
On Standby Side:</h3>
<span style="font-size: 12px;">
SQL> show parameter LOG_ARCHIVE_DEST_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=PRIMARY ASYNC VALID_F
OR=(ONLINE_LOGFILES,PRIMARY_RO
LE) DB_UNIQUE_NAME=primdb
SQL> alter system set LOG_ARCHIVE_DEST_2='' scope=both;
System altered.
SQL>
DGMGRL> ADD DATABASE 'standb' AS CONNECT IDENTIFIER IS standb MAINTAINED AS PHYSICAL;
Database "standb" added
DGMGRL>
DGMGRL> enable configuration;
Enabled.
DGMGRL> show configuration;
Configuration - DR_Config
Protection Mode: MaxPerformance
Members:
primdb - Primary database
standb - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 10 seconds ago)
DGMGRL></span></code><span style="font-size: 12px;"> </span></pre>
That's it.. Hope this article will help you.<br />
<br />
Thanks,<br />
Chowdari<br />
<br />
<br /></div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-32408583360953557082018-02-24T00:52:00.000-08:002018-02-24T00:56:12.386-08:00Oracle Database 12c Release 2 (12.2) Installation on Oracle Enterprise Linux 6 (OEL6)<div dir="ltr" style="text-align: left;" trbidi="on">
This article describes the installation of Oracle Database 12c Release 2 on Oracle Enterprise Linux 6 (OEL6) on VirtualBox.<br />
<br />
<h3 style="text-align: left;">
Introduction:</h3>
For installing 12cR2 in your laptop or desktop computer has minimum 4 GB or more of RAM required, and minimum 30GB storage required and used oracle virtualBox showed in this article.<br />
<br />
This article uses the 64-bit versions of Oracle Enterprise Linux, and Oracle 12c Release 2 (12.2.0.1).<br />
<br />
<b>Prerequisite:</b> Oracle Enterprise Linux 6 Install on VirtualBox<br />
<br />
<h3 style="text-align: left;">
Download Software:</h3>
Download Oracle 12cR2 database software for Linux x86-64 from OTN or Edelivery and copy the files to linux server (on VirtualBox) using winscp or shared folder.<br />
<br />
<b>OS Configuration and Preparation:</b><br />
<div style="text-align: left;">
1) Add the following lines to the "/etc/sysctl.conf" file</div>
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
</code></pre>
<div>
2) Run the following command to change the current kernel parameters.<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;">/sbin/sysctl -p
</code></pre>
<div>
3) Add the following lines to "/etc/security/limits.conf" file</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;">oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
</code></pre>
<div>
4) Create the new groups and users.</div>
<pre style="-webkit-text-stroke-width: 0px; background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); color: black; font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; line-height: 14px; margin: 0px; orphans: 2; overflow: auto; padding: 5px; text-align: left; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; widows: 2; width: 653px; word-spacing: 0px;"><code style="word-wrap: normal;">#groups for database management
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
</code></pre>
<div class="MsoNormal">
<span style="font-family: "calibri" , sans-serif; font-size: 11.0pt; line-height: 107%;"><o:p></o:p></span></div>
</div>
<div>
<span style="font-family: "calibri" , sans-serif; font-size: 14.6667px;">Add user Oracle for database software</span><br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;">useradd -u 54321 -g oinstall -G dba,oper oracle
</code></pre>
5) Set the password for the "oracle" user.<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;">passwd oracle
</code></pre>
6) The following packages are listed as required, including the 32-bit version of some of the packages. Many of the packages should be installed already.</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;"> # OL6 and OL7 (RHEL6 and RHEL7)
yum install binutils -y
yum install compat-libcap1 -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install make -y
yum install nfs-utils -y
yum install net-tools -y
yum install smartmontools -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
# Required for 12.1, not listed for 12.2
yum install gcc -y
yum install gcc-c++ -y
yum install libXext -y
yum install libXext.i686 -y
yum install zlib-devel -y
yum install zlib-devel.i686 -y
# OL6 only (RHEL6 only)
yum install e2fsprogs -y
yum install e2fsprogs-libs -y
yum install libs -y
yum install libxcb.i686 -y
yum install libxcb -y
</code></pre>
7) Create directory structure as user root<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;">mkdir -p /u01/app/oracle/product/12.2.0/dbhome_1
chown -R oracle:dba /u01
chmod -R 775 /u01
</code></pre>
<br />
<h3 style="text-align: left;">
Installation:</h3>
<div>
1) Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.</div>
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;">DISPLAY=<machine-name>:0.0; export DISPLAY
</code></pre>
2) Unizp software it will create directory "database". Goto database directory and Start the Oracle Universal Installer (OUI) by issuing the following command.<br />
<pre style="background-color: #eeeeee; border: 1px dashed rgb(153, 153, 153); font-family: "andale mono", "lucida console", monaco, fixed, monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 653px;"><code style="word-wrap: normal;">-bash-4.1$ ls -rlt
total 3376056
drwxr-xr-x 7 oracle dba 4096 Jan 26 2017 database
-rw-r--r-- 1 oracle dba 3453696911 Mar 1 2017 linuxx64_12201_database.zip
-bash-4.1$
-bash-4.1$
-bash-4.1$ cd database/
-bash-4.1$ ls -rlt
total 36
-rwxr-xr-x 1 oracle dba 500 Feb 6 2013 welcome.html
drwxr-xr-x 4 oracle dba 4096 Jan 26 2017 install
-rwxr-xr-x 1 oracle dba 8771 Jan 26 2017 runInstaller
drwxr-xr-x 2 oracle dba 4096 Jan 26 2017 rpm
drwxrwxr-x 2 oracle dba 4096 Jan 26 2017 sshsetup
drwxrwxr-x 2 oracle dba 4096 Jan 26 2017 response
drwxr-xr-x 14 oracle dba 4096 Jan 26 2017 stage
-bash-4.1$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 500 MB. Actual 3752 MB Passed
Checking swap space: must be greater than 150 MB. Actual 16383 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 65536 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2018-02-23_09-32-39PM. Please wait
</code></pre>
<div>
<code style="word-wrap: normal;"><br /></code></div>
3) Uncheck checkbox "I wish to receive security updates via My Oracle Support" and then click "Next" button.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4dLfzCFOetlIJaWs04jpmQPYYfzjnwbf-j9cL6O1w_enCRHnSzZond0jlsDSxJDXtulDZ0WOS7vMMHwJfUsyxPVBL-dQo37BmKmZJLWqGT8WAMiuuBcfUi_WJTE6d_b_it2KtfUBqaS8/s1600/mbc-dba_Configure_security_updates1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="466" data-original-width="628" height="474" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh4dLfzCFOetlIJaWs04jpmQPYYfzjnwbf-j9cL6O1w_enCRHnSzZond0jlsDSxJDXtulDZ0WOS7vMMHwJfUsyxPVBL-dQo37BmKmZJLWqGT8WAMiuuBcfUi_WJTE6d_b_it2KtfUBqaS8/s640/mbc-dba_Configure_security_updates1.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
4) Ignore following message and click “Yes” button.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCCCtrAObL2cxdhEtzBPsk92MMVwjDBpvZk8_iXp7J4K3qvCSWNkXLfQw07UVH9sqKUZEr9IeRodTkkzW8nq2brrktVaeooF1FVldp2BqdH27h75e62JG293Z5a0K7OkO34lOWtWr-2nw/s1600/mbc-dba_config2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCCCtrAObL2cxdhEtzBPsk92MMVwjDBpvZk8_iXp7J4K3qvCSWNkXLfQw07UVH9sqKUZEr9IeRodTkkzW8nq2brrktVaeooF1FVldp2BqdH27h75e62JG293Z5a0K7OkO34lOWtWr-2nw/s640/mbc-dba_config2.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
5) Select install option, Here I have choosen "Install database software only", to install the database software. </div>
<div class="separator" style="clear: both; text-align: left;">
You can choose "Create and configure a database" option, If you want to install database software and create database in single shot.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi392JfeK4BEx2LbOD1N9JtC78g89_hyphenhyphenwt0pWbtRPXd5KCmuXCizWr2RyBMgttFKC94r7Oi0hoyYQ8i_8BXbuntiOLjU3vzkc9YoBAjcKgHAY_9cRaInfejjtQZDhloSBiNoNdDXwooFF8/s1600/mbc-dba_Install_option3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi392JfeK4BEx2LbOD1N9JtC78g89_hyphenhyphenwt0pWbtRPXd5KCmuXCizWr2RyBMgttFKC94r7Oi0hoyYQ8i_8BXbuntiOLjU3vzkc9YoBAjcKgHAY_9cRaInfejjtQZDhloSBiNoNdDXwooFF8/s640/mbc-dba_Install_option3.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
6) Select Database Installation Option, Accept default “Single instance database installation” and click “Next” button </div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEir7GE_q1_0YeKgNcHB4apFEhiIlKt8hOapafRAKfSmC1vXMfCaAzLSmnC_rrUDxdsfZqeWTLeAupEEXNbTEGg4Ac5EwNUM_rkGG45H3_17HpDxSVFypLDQx4r4r8ly8Xh2ZEAG-ALisxs/s1600/mbc-dba_database_install_option4.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEir7GE_q1_0YeKgNcHB4apFEhiIlKt8hOapafRAKfSmC1vXMfCaAzLSmnC_rrUDxdsfZqeWTLeAupEEXNbTEGg4Ac5EwNUM_rkGG45H3_17HpDxSVFypLDQx4r4r8ly8Xh2ZEAG-ALisxs/s640/mbc-dba_database_install_option4.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
7) Select Database Edition, You can select here type of binaries to install. Once it’s done click “Next” button.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGNNz2m0xhLst2nXyBX1r9uZcDAmZ2RaYcs8Z4K8pTRqEhsTX-mtEddvTQRvudEBvKo4zArgg6EO7hneRFvRBmKDmxwUJxVr9WYdg7SZyKY-NYs1ptPuQGL6AbL3Gtg6R8TIvouc4PVTY/s1600/mbc-dba_Database_Edition5.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGNNz2m0xhLst2nXyBX1r9uZcDAmZ2RaYcs8Z4K8pTRqEhsTX-mtEddvTQRvudEBvKo4zArgg6EO7hneRFvRBmKDmxwUJxVr9WYdg7SZyKY-NYs1ptPuQGL6AbL3Gtg6R8TIvouc4PVTY/s640/mbc-dba_Database_Edition5.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
8) Installation Location, here you should see directories for ORACLE_BASE and ORACLE_HOME for your binaries according to environmental settings. Click “Next” button.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFWS0HJFgv-rcTEmJHVfA7-z_79noTO97Lf-w0a1ZLQ1jDkT_kRlmVXIjCAhuJ8RydSi6d2dHFeCdoQhgrvHqL-GjBuNkrax_9qgfQYxu5Bs8ZPzufwdRZRqSuoSFn6ywv5YxGNHftrFA/s1600/mbc-dba_Install_location6.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFWS0HJFgv-rcTEmJHVfA7-z_79noTO97Lf-w0a1ZLQ1jDkT_kRlmVXIjCAhuJ8RydSi6d2dHFeCdoQhgrvHqL-GjBuNkrax_9qgfQYxu5Bs8ZPzufwdRZRqSuoSFn6ywv5YxGNHftrFA/s640/mbc-dba_Install_location6.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
9) Operating system groups, here you can specify OS group for each oracle group. Change default groups to dba and click “Next” button.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYOf_ioV8mG7fpF5Cd2dzkCB99tFKKluUvNMf3O6u9HlU1qnSM-RE8zmnSrS9MXnYJ3OSfmVeQGKXCbd4pzNSQh1bAuIPKxtRsG3Jcsbdgbn3-hifyFaEDsvK5-o23FVxTm7LnnnT3tP0/s1600/mbc-dba_Operating_system_groups7.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYOf_ioV8mG7fpF5Cd2dzkCB99tFKKluUvNMf3O6u9HlU1qnSM-RE8zmnSrS9MXnYJ3OSfmVeQGKXCbd4pzNSQh1bAuIPKxtRsG3Jcsbdgbn3-hifyFaEDsvK5-o23FVxTm7LnnnT3tP0/s640/mbc-dba_Operating_system_groups7.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
10) Summary, If everything isfine, then click “Install” button. It’s the last moment to come back to each of previous point and make changes.</div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUQTND7mkmCw2LKOiyBrTb5q_uRGYgeZCe9YPLeuw4ZE6LZKiQDs9AJcHMAGA73XD5BlI3k172YqXJOmaduDc_0-ZUGTRe_ZbBTigDOG5aVltRBrK9i-TbNbLhfP4NtDdPyTU27-J9RGM/s1600/mbc-dba_Summary8.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUQTND7mkmCw2LKOiyBrTb5q_uRGYgeZCe9YPLeuw4ZE6LZKiQDs9AJcHMAGA73XD5BlI3k172YqXJOmaduDc_0-ZUGTRe_ZbBTigDOG5aVltRBrK9i-TbNbLhfP4NtDdPyTU27-J9RGM/s640/mbc-dba_Summary8.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
11) Product installation</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFdSp35PZ_ms-3luZvwA9qzwKe1gqIawY2csgGkfFu6YX4ludLJTVu4ufqcpZ-q_pC79jFezyISLOlgtXDPknfp7op1jAwq5eODDGpBVBzvINV-AY8_AIGjy-B0tXVP4AIMMq9FrqSsIA/s1600/mbc-dba_Install_product9.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="469" data-original-width="626" height="478" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFdSp35PZ_ms-3luZvwA9qzwKe1gqIawY2csgGkfFu6YX4ludLJTVu4ufqcpZ-q_pC79jFezyISLOlgtXDPknfp7op1jAwq5eODDGpBVBzvINV-AY8_AIGjy-B0tXVP4AIMMq9FrqSsIA/s640/mbc-dba_Install_product9.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
12) Execute configuration script, once binaries are installed the last step is to run root.sh script as user root. </div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3LCmYmKuya_r2Jn_qdC7CUST75gvTvfGhCjGmbfovtgvUb-4SFoiXusoOYNCccMOA964oQWgihLkfVdDoB5ygkpYM-IKNoDl3hxwP9v-_Rb1V5nAZKJgrTnSB94ieuuMZxRRzuPFWMwQ/s1600/mbc-dba_Execute_scripts10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="356" data-original-width="626" height="362" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3LCmYmKuya_r2Jn_qdC7CUST75gvTvfGhCjGmbfovtgvUb-4SFoiXusoOYNCccMOA964oQWgihLkfVdDoB5ygkpYM-IKNoDl3hxwP9v-_Rb1V5nAZKJgrTnSB94ieuuMZxRRzuPFWMwQ/s640/mbc-dba_Execute_scripts10.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
13) After successful installation click "Close" button.</div>
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNtKx278K9PE5Tg9cYW4FnQR-9tTnb36wp-fyyV54_3TGxMcZdMAsRDcSrYSFrR_M0NTrkB_bPQemf0YS_E0-CC6F2BILkAus078v-CZWURYxzebONlxHKfZ4t3L_aG_NX3c2s61TFFg0/s1600/mbc-dba_Finish11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" data-original-height="468" data-original-width="626" height="476" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNtKx278K9PE5Tg9cYW4FnQR-9tTnb36wp-fyyV54_3TGxMcZdMAsRDcSrYSFrR_M0NTrkB_bPQemf0YS_E0-CC6F2BILkAus078v-CZWURYxzebONlxHKfZ4t3L_aG_NX3c2s61TFFg0/s640/mbc-dba_Finish11.jpg" width="640" /></a><br />
<br />
<br />
That's it. Installed the Oracle 12cR2 software on Oracle Enterprise linux 6.<br />
<br />
In my next post will cover database creation.<br />
<br />
Thanks,<br />
Chowdari</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com1tag:blogger.com,1999:blog-3046621742164455904.post-88969518825444344372018-02-03T04:14:00.002-08:002018-02-03T04:51:18.036-08:00ORA-04063 APPS.AD_ZD_ADOP Package Invalid After Applied Database Bundle Patch<div dir="ltr" style="text-align: left;" trbidi="on">
ADOP prepare phase was failing after applied the latest database bundle Patch on the RDBMS ORACLE_HOME of an EBS R12.2 database. The APPS.AD_ZD_ADOP Package becomes invalid and due to that all ADOP sessions got failed. See below error details.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
[oracle@ebshyd01 ]$ echo $FILE_EDITION
run
[oracle@ebshyd01 ]$ adop phase=prepare
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/EBSPRDB/fs1/inst/apps/EBSPRDB_ebshyd01/appl/admin/EBSPRDB_ebshyd01.xml
Patch edition context: /u01/EBSPRDB/fs2/inst/apps/EBSPRDB_ebshyd01/appl/admin/EBSPRDB_ebshyd01.xml
Patch file system free space: 125.88 GB
Validating system setup.
[ERROR] Failed to execute SQL statement:
select AD_ZD_ADOP.GET_INVALID_NODES() from dual
[ERROR] Error Message:
[ERROR] ORA-04063: package body "APPS.AD_ZD_ADOP" has errors (DBD ERROR: OCIStmtExecute)
[UNEXPECTED]Error determining whether this is a multi-node instance
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 2 (Fail)
[oracle@ebshyd01 ]$
</code>
</pre>
<b>And check ADOP status:</b><br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
[oracle@ebshyd01 ]$ adop -status
Enter the APPS password:
==============================================================
ADOP (C.Delta.7)
Session Id: 45
Command: status
Output: /u01/EBSPRDB/fs_ne/EBSapps/log/status_20171230_112514/adzdshowstatus.out
===================================wo============================
File System Synchronization Type: Full
declare
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_ADOP"
ORA-06512: at line 6
[STATEMENT] Please run adopscanlog utility, using the command
"adopscanlog -latest=yes"
to get the list of the log files along with snippet of the error message corresponding to each log file.
adop exiting with status = 1 (Fail)
[oracle@ebshyd01 ]$
</code>
</pre>
<br />
<h3 style="text-align: left;">
Solution:</h3>
<div>
First check the status of APPS.AD_ZD_ADOP object:</div>
<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">SQL> select owner, object_name,object_type, status from dba_objects where object_name='AD_ZD_ADOP';
OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------------------------------------------------------------------------
APPS AD_ZD_ADOP PACKAGE VALID
APPS AD_ZD_ADOP PACKAGE BODY INVALID
SQL>
</code>
</pre>
See the object APPS.AD_ZD_ADOP package body is INVALID state, so try to compile the APPS.AD_ZD_ADOP package<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">SQL> alter package AD_ZD_ADOP compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY AD_ZD_ADOP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2686/3 PL/SQL: Statement ignored
2686/7 PLS-00201: identifier 'SYS.DBMS_METADATA_UTIL' must be declared
==================
SQL>
</code></pre>
The above error indicates that, the SYS.DBMS_METADATA_UTIL object needs to be recompiled first before the APPS.AD_ZD_ADOP object can become valid. See the above error looks some privileges issue.<br />
<br />
This package became invalid due to incorrect execution of adgrants.sql script. We should always execute the correct version of the adgrants.sql. We should ensure we have applied "adgrants.sql" script from the the applied AD code level.<br />
<br />
And here I am just giving the execute privilege to APPS user on SYS.DBMS_METADATA_UTIL. Then compile the APPS.AD_ZD_ADOP Package.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">SQL> conn / as sysdba
Connected.
SQL> grant execute on DBMS_METADATA_UTIL to apps;
Grant succeeded.
SQL>
SQL> conn apps
Enter password:
Connected.
SQL>
SQL> alter package AD_ZD_ADOP compile body;
Package body altered.
SQL>
SQL> select owner, object_name,object_type, status from dba_objects where object_name='AD_ZD_ADOP';
OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------------------------------------------------------------------------
APPS AD_ZD_ADOP PACKAGE VALID
APPS AD_ZD_ADOP PACKAGE BODY VALID
SQL></code>
</pre>
<b>Rerun the ADOP utilities:</b><br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[oracle@ebshyd01 ]$ adop -status
Enter the APPS password:
==============================================================
ADOP (C.Delta.7)
Session Id: 45
Command: status
Output: /u01/EBSPRDB/fs_ne/EBSapps/log/status_20171230_121228/adzdshowstatus.out
===============================================================
File System Synchronization Type: Full
adop exiting with status = 0 (Success)
[oracle@ebshyd01 ]$ </code></pre>
So now run "adop phase=prepare", ADOP cycle will complete without any further issues.<br />
<br />
Please give your comment, If this article helps you..<br />
<br />
Thanks,<br />
Chowdari</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com1tag:blogger.com,1999:blog-3046621742164455904.post-48436340270352257362017-03-04T01:42:00.002-08:002018-02-03T04:17:13.260-08:00Logical Database Backups Using Export and Import Utilities:<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Here in this article describes how to use the original export and import utilities, invoked with the exp and imp command, respectively.<br />
<br />
<b>What happens when we export data from a database?</b><br />
<br />
When we export data from an oracle database then the export utility will simply prepare a set of sql select statements and execute them against the target database. the data that is returned by the select operation (definition and rows of the objects) will be written to a file known as the export dump(.dmp) file.<br />
This .dmp file is platform independent and can be carried to any other oracle site. when required the DBA can import the objects from the .dmp file into any oracle database. Import operation reads the definitions from the dump file and creates the objects there after it executes insert statements from the dump file against the database and loads the data back into the database objects that were created from the dump file.<br />
<br />
<b>Advantages of oracle export and import:-</b><br />
<br />
1. Using oracle export/import we can backup/restore a particular object (table). export is used to backup and import is used to restore a database object.<br />
<br />
2. Exports can be used to copy objects from one oracle schema to another.<br />
<br />
3. When performing migration of an oracle database from one o/s to another like from windows to linux then logical backups are the only way to migrate the data as export dump file is platform independent.<br />
<br />
4. When we want to migrate database objects, from one database, to another database, when both source and target databases, are running on oracle then we use export and import.<br />
<br />
5. Export can also help in performing a database re-org. when after using a database for a while, it gets fragmented and also certain segments may have too many extents which results in poor i/o performance. For this reason every 3-4 months of database usage we go for a full database re-org , which includes<br />
<div style="text-align: left;">
1. Full DB exp</div>
<div style="text-align: left;">
2. Drop the database</div>
<div style="text-align: left;">
3. Create a brand new database</div>
<div style="text-align: left;">
4. Full DB imp</div>
<br />
At the end of the import all the segments will be back within single huge extents and we will get rid of all fragmentation.<br />
<br />
6. Exports can be done at table level, schema level, tablespace level or full database.<br />
<br />
7. While exporting a table we can mention the query option from 8i onwards, example export the emp table where the deptno=10.<br />
<br />
8. If the database is too large the dump file can run into gb and this much space may not be available in a single file system, thus we can export the data to multiple files spanning across multiple file systems from 8i onwards.<br />
<br />
9. The size of an export dump file is usually 6 to 10 times smaller than the size of the database. the reasons are<br />
<br />
1. Control,redolog are not exported<br />
2. Exp does not carry any base tables (objects owned by sys).<br />
3. The temporary segments are ignored.<br />
4. Undo and rollback segments are ignored as we are interested only in commited data.<br />
5. Only table data goes into the dump file along with the table definions.<br />
<br />
10. Time taken for exp vs imp is usually 1:6 ratio as export is only a select operation where as import is a ddl+dml operation and each line goes through the undo or rollback segments and also goes to logfiles.<br />
<br />
11. Import operation will cause a lot of redo activity and hence log switching will occur.<br />
<br />
Various parameters are available to control what objects are exported or imported. To get a list of available parameters, run the exp or imp utilities with the help=yes parameter i.e. "exp help=yes" or "imp help=yes".<br />
<br />
Following two articles for export and import commands.<br />
<br />
> <a href="http://mbc-dba.blogspot.in/2017/03/useful-traditional-exp-commands.html"> Useful Traditional EXP Commands</a><br />
> <a href="http://mbc-dba.blogspot.in/2017/03/useful-traditional-imp-commands.html"> Useful Traditional IMP Commands</a><br />
<br />
Thats it. Hope this article will help you :)<br />
<br />
Regards,<br />
Chowdari<br />
<br /></div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-82837669449974118932017-03-04T01:36:00.004-08:002018-02-03T04:18:05.995-08:00Useful Traditional IMP Commands<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
Here you can find some useful Import/IMP commands:<br />
<br />
1) Command to imp full database:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ imp system/manager file=full.dmp log=full_imp.log full=y</code> </pre>
2) Command to imp all scotts objects into scott user<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ imp system/manager file=scott.dmp log=scott_imp.log fromuser=scott touser=scott</code> </pre>
3) Command to imp scotts emp table:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ imp system/manager file=emp.dmp log=emp_imp.log fromuser=scott touser=scott tables=emp</code> </pre>
4) Command to imp scotts multiple tables<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ imp system/manager file=full.dmp log=full_scott_imp.log fromuser=scott touser=scott tables=(emp,dept,salgrade)</code> </pre>
<br />
Thats it. Hope this article will help you :)<br />
<br />
Regards,<br />
Chowdari</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-64595568933378421782017-03-04T00:12:00.000-08:002018-02-03T04:18:40.335-08:00Useful Traditional EXP Commands<div dir="ltr" style="text-align: left;" trbidi="on">
Here you can find some useful Export/EXP commands:<br />
<br />
1) Command to perform full database export:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager file=full.dmp log=full.log full=y</code> </pre>
2) Command to export scott user:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp scott/tiger file=scott.dmp log=scott.log</code></pre>
3) Command to export scott user by system/manager:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager file=scott_exp_by_system.dmp log=scott_exp_by_system.log owner=scott</code> </pre>
4) Command to export multiple users by system/manager:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager file=user_exp_by_system.dmp log=user_exp_by_system.log owner=(scott,demo)</code></pre>
5) Command to export single table from scott user:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp scott/tiger file=emp.dmp log=emp.log tables=emp</code></pre>
6) Command to export multiple tables:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp scott/tiger file=emp_dept.dmp log=emp_dept.log tables=(emp,dept)</code> </pre>
7) Command to exp multiple tables from system/manager:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager file=emp_dept_system.dmp log=emp_dept_system.log tables=(scott.emp,scott.dept)
</code></pre>
8) Command to export multiple tables from multiple users:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager file=multi_user_tab_system.dmp log=multi_user_tab_system.log tables=(scott.emp,scott.dept,demo.emp,demo.dept)</code></pre>
9) Command to exp scott user without rows:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager file=scott_empty.dmp log=scott_empty.log owner=scott rows=n</code></pre>
10) Command to exp scott user without row's constraints,grants,triggers and indexes:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager file=scott_empty_cons.dmp log=scott_empty_cons.log owner=scott constraints=n rows=n grants=n indexes=n triggers=n
</code></pre>
11) Following command to export using compress=y option:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp scott/tiger tables=(emp) file=emp_compress.dmp log=emp_compress.log compress=y
</code></pre>
compress=y => when we export a table with compress=y then, the table, when ,imported back into the database will be brought into one single large extent, this will increase the i/o performance on the table.<br />
<br />
12) Command to export a single tablespace with all its contents:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager tablespaces=(users) file=users_ts.dmp log=users_ts.log</code></pre>
13) Command to export multiple tablespaces:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp system/manager tablespaces=(users,userdata) file=users_userdata_ts.dmp log=users_userdata_ts.log</code> </pre>
14) Commands to specify a query:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">[chow@hyddb exp_bkp]$ exp scott/tiger tables=emp query=\"where deptno=10\" file=query.dmp log=query.log
[chow@hyddb exp_bkp]$ exp scott/tiger file=emp_query.dmp query='"WHERE deptno = 10 AND sal > 1000"' tables=emp</code> </pre>
<br />
Thats it. Hope this article will help you :)<br />
<br />
Regards,<br />
Chowdari</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-65458124232980740802016-12-16T01:29:00.002-08:002016-12-16T05:01:35.919-08:00adstats.sql Fails With ORA-20011 and ORA-600<div dir="ltr" style="text-align: left;" trbidi="on">
Performing database upgrade from 11.2.0.4 to 12.1.0.2 with EBS version R12.1.3. When I'm executing post DB upgrade step adstats.sql, its failed with following ORA internal error.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
declare
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments:
[1350], [3], [23], [60], [AMERICAN], [0], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 36906
ORA-06512: at line 3
ORA-06512: at line 33
</code> </pre>
Looking at V$NLS_VALID_VALUES and it shows as,<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
SQL> select count(*) from V$NLS_VALID_VALUES;
select count(*) from V$NLS_VALID_VALUES
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [1350], [3], [23], [60], [AMERICAN],
[0], [], [], [], [], [], []
SQL>
</code> </pre>
<br />
<b>Follow below steps to fix this issue:</b><br />
<br />
1) Source the database environment file and check PERL5LIB variable is set correctly. If you are using RAC, then check all the nodes of a RAC environment.<br />
<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Example:
$ export
PERL5LIB=/u01/app/12102/perl/lib/5.10.0:/u01/app/12102/perl/lib/site_perl/5.10.0:/u01/app/12102/appsutil/perl
</code> </pre>
<br />
2) Run "perl $ORACLE_HOME/nls/data/old/cr9idata.pl" to create 9idata directory and set ORA_NLS10 parameter.<br />
<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">Example:
$ export ORA_NLS10=/u01/app/12102/nls/data/9idata
</code> </pre>
<br />
3) Restart the database <br />
<br />
4) Now run adstats.sql and also check at V$NLS_VALID_VALUES. If still issue exists please check with oracle support team.<br />
<br />
That's it, hope this article will help you :).<br />
<br />
Thanks,<br />
Chowdari<br />
<br /></div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-52070415706745670002016-10-29T01:52:00.001-07:002016-12-01T22:45:31.760-08:00Recreating the /appsutil/scripts/ directory in EBS<div dir="ltr" style="text-align: left;" trbidi="on">
When I have executed $AD_TOP/bin/admkappsutil.pl to generate appsutil.zip file, I didn't find the scripts directory under $ORACLE_HOME/appsutil. <br />
To fix this issue, need to run 'perl $ORACLE_HOME/appsutil/bin/adbldxml.pl' utility, this will create a new context file on the database tier.<br />
The new context file acts as a central repository for database configuration information. The adbldxml Utility is only supported on the Database Tier, not on the Applications Tier.<br />
<br />
With using newly generated DB context file need to run $ORACLE_HOME/appsutil/bin/adconfig.sh on DB tier. Now the scripts directory will be created under $ORACLE_HOME/appsutil directory.<br />
<br />
<b>Follow below detailed steps:</b><br />
<br />
1. On the Application Tier (as the APPLMGR user)<br />
<br />
2. Log in to the APPL_TOP environment (source the environment file)<br />
<br />
3. Create appsutil.zip file<br />
<br />
4. perl /bin/admkappsutil.pl<br />
<br />
5. This will create appsutil.zip in $APPL_TOP/admin/out .<br />
<br />
6. Copy or FTP the appsutil.zip file to the DB Tier RDBMS ORACLE_HOME<br />
<br />
7. Go to database ORACLE_HOME and unzip the appsutil directory .<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"> <code style="color: black; word-wrap: normal;">
unzip -o appsutil.zip
</code>
</pre>
8. Generate Database Context File and follow the steps below:<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
source DB env
cd /appsutil/bin perl adbldxml.pl
-bash-3.2$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /u01/R12EBS/12.1.0.2/appsutil/jre/bin/java to execute java programs..
APPS Password:
The log file for this adbldxml session is located at:
/u01/R12EBS/12.1.0.2/appsutil/log/adbldxml_09300206.log
Could not Connect to the Database with the above parameters, Please answer the Questions below
Enter Hostname of Database server: HYDLAB02
Enter Port of Database server: 1524
Enter SID of Database server: UPG1220
Enter Database Service Name: UPG1220
The context file has been created at:
/u01/R12EBS/12.1.0.2/appsutil/UPG1220_HYDLAB02.xml
-bash-3.2$ </code>
</pre>
9. Run adconfig.sh on DB tier. After running adconfig.sh, the scripts directory will be created under appsutil directory.<br />
<pre style="background-color: #eeeeee; border: 1px dashed #999999; color: black; font-family: "andale mono" , "lucida console" , "monaco" , "fixed" , monospace; font-size: 12px; line-height: 14px; overflow: auto; padding: 5px; width: 100%;"><code style="color: black; word-wrap: normal;">
-bash-3.2$ pwd
/u01/R12EBS/12.1.0.2/appsutil/bin
-bash-3.2$
-bash-3.2$
-bash-3.2$ ./adconfig.sh
Enter the full path to the Context file: /u01/R12EBS/12.1.0.2/appsutil/UPG1220_HYDLAB02.xml
Enter the APPS user password:
The log file for this session is located at: /u01/R12EBS/12.1.0.2/appsutil/log/UPG1220_HYDLAB02/09300209/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/R12EBS/12.1.0.2
Classpath : :/u01/R12EBS/12.1.0.2/jdbc/lib/ojdbc6.jar:/u01/R12EBS/12.1.0.2/appsutil/java/xmlparserv2.jar:/u01/R12EBS/12.1.0.2/appsutil/java:/u01/R12EBS/12.1.0.2/jlib/netcfg.jar:/u01/R12EBS/12.1.0.2/jlib/ldapjclnt12.jar
Using Context file : /u01/R12EBS/12.1.0.2/appsutil/UPG1220_HYDLAB02.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
-bash-3.2$
-bash-3.2$
-bash-3.2$ cd ../scripts/
-bash-3.2$ ls -lrt
total 4
drwxr-xr-x 2 oracle dba 4096 Sep 30 02:09 UPG1220_HYDLAB02
-bash-3.2$ cd UPG1220_HYDLAB02
-bash-3.2$ ls -rlt
total 72
-rw------- 1 oracle dba 1257 Sep 30 02:09 adstrtdb.sql
-rw------- 1 oracle dba 811 Sep 30 02:09 adstopdb.sql
-rwx------ 1 oracle dba 27246 Sep 30 02:09 adpreclone.pl
-rwx------ 1 oracle dba 3670 Sep 30 02:09 adlsnodes.sh
-rwx------ 1 oracle dba 7347 Sep 30 02:09 adexecsql.pl
-rwx------ 1 oracle dba 6724 Sep 30 02:09 addlnctl.sh
-rwx------ 1 oracle dba 2775 Sep 30 02:09 addbctl.sh
-rwx------ 1 oracle dba 5541 Sep 30 02:09 adchknls.pl
-rwx------ 1 oracle dba 1483 Sep 30 02:09 adautocfg.sh
-bash-3.2$
</code>
</pre>
<br />
That's it, hope this article will help you. :)</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-37351871980971170222016-08-18T10:00:00.000-07:002016-08-23T04:11:30.960-07:00Reorganising tablespaces using EXP/IMP<div dir="ltr" style="text-align: left;" trbidi="on">
We have many approaches to perform reorganising tablespaces to claim unused space in datafiles. Here in this article, will show you reorganising tablespaces with using EXP/IMP method.<br />
<br />
There are number of scenarios that can lead to unused space in datafiles.<br />
The most common I see are - One or more tables/indexes are truncated/deleted huge records from tables, during that time leaving empty areas in the datafiles that previously accommodated them.<br />
<br />
Please remember, take backup before you perform reorganising a tablespace because its a big structural change.<br />
<br />
<b>Follow below DEMO for reorganising tablespaces using EXP/IMP method:</b><br />
<br />
<b>Step 1:</b> Create new tablespace 'reorg_ts' and and user 'reorg_user'. Also create two dummy tables and insert some bunch of records to that tables. After that gather the tables statistics.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm3WgQw7c7ZBg1esRnIR2nFMdVYxPgx03MHNm_DFTwMkVabdkybvV5hT3MhkBn3NJaP2eAMjGjG_-fi7FEBQUxyKBES4UU4wguORKjTzTT1fbyPujRtQCis_egsBj5kNbNoMYbLAeEXLg/s1600/reorg_ts_mbc-dba01.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="358" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm3WgQw7c7ZBg1esRnIR2nFMdVYxPgx03MHNm_DFTwMkVabdkybvV5hT3MhkBn3NJaP2eAMjGjG_-fi7FEBQUxyKBES4UU4wguORKjTzTT1fbyPujRtQCis_egsBj5kNbNoMYbLAeEXLg/s640/reorg_ts_mbc-dba01.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgudMVI8AYRQ3nRjuUgu5WgXKfNdlhonkHh90wOvd5DzXU_ZZMcXKMJU3w8jt8PFBumLNZwgCoZgO8NjNYFaUW089d4QikUg3ljLGr53kYlDIZFxMD_zypCKWk_Wmu3-agEAlM1cqRG6dw/s1600/reorg_ts_mbc-dba02.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="448" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgudMVI8AYRQ3nRjuUgu5WgXKfNdlhonkHh90wOvd5DzXU_ZZMcXKMJU3w8jt8PFBumLNZwgCoZgO8NjNYFaUW089d4QikUg3ljLGr53kYlDIZFxMD_zypCKWk_Wmu3-agEAlM1cqRG6dw/s640/reorg_ts_mbc-dba02.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAU37B8cfhMOYy2VE0b2ARKBE5GXOql1pUlWOl1WOS3XwdORm0g9FLWKe20a6B7GVbnlC8tLpLfExmku0Ca0jp0JJFL1L4T13EYZu2TWPxb8eOVZhfVCggZbEffRPZZuUY6bcdERCLBVE/s1600/reorg_ts_mbc-dba03.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="185" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAU37B8cfhMOYy2VE0b2ARKBE5GXOql1pUlWOl1WOS3XwdORm0g9FLWKe20a6B7GVbnlC8tLpLfExmku0Ca0jp0JJFL1L4T13EYZu2TWPxb8eOVZhfVCggZbEffRPZZuUY6bcdERCLBVE/s640/reorg_ts_mbc-dba03.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<b>Step 2:</b> Now we can see both table segments are made up of multiple extents, each extent being made up of multiple blocks.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0ax9vIQUvUjXXIy9g14ewnrFQAwnv18RmUW7ktsptkjMOivqstm7JCH-B3ujmIExY1k1TBmAaulaGnKXl_HaYJtUDfljsNYF-nDF6QRtebJS9z9fd8tkYij4V_H7fDaowXpA7Y6Vcskk/s1600/reorg_ts_mbc-dba04.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="474" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0ax9vIQUvUjXXIy9g14ewnrFQAwnv18RmUW7ktsptkjMOivqstm7JCH-B3ujmIExY1k1TBmAaulaGnKXl_HaYJtUDfljsNYF-nDF6QRtebJS9z9fd8tkYij4V_H7fDaowXpA7Y6Vcskk/s640/reorg_ts_mbc-dba04.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinmtJgwWP6frDSlIbHDhFhQ4JNLcQYsHNQhJWLjb_Y9e8yf7U_xXIbtAXyarQGWGxoZC2TsjWBw7L_otdDK0odOWjH1oa64Bq4LizljdXX-RsRnQGVin-2mGaTQx4ADD3rD07FgEk9Tro/s1600/reorg_ts_mbc-dba05.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="110" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinmtJgwWP6frDSlIbHDhFhQ4JNLcQYsHNQhJWLjb_Y9e8yf7U_xXIbtAXyarQGWGxoZC2TsjWBw7L_otdDK0odOWjH1oa64Bq4LizljdXX-RsRnQGVin-2mGaTQx4ADD3rD07FgEk9Tro/s640/reorg_ts_mbc-dba05.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<b>Step 3: </b>Connect to reorg_user and truncate the REORG_T1 table.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVEz5Zf7oJWsy0gT4tCckmwh5CSwD0Hnch0NhyphenhyphenhtfiihPhdKZ1da2BGisyCvCW0be-QJbTlGoXNEDDwMKBaxN4el30YUlwYFzENA4iCHiLp4sReLq_nQREBn8s79sUhdHVbNz7GhKrub4/s1600/reorg_ts_mbc-dba06.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVEz5Zf7oJWsy0gT4tCckmwh5CSwD0Hnch0NhyphenhyphenhtfiihPhdKZ1da2BGisyCvCW0be-QJbTlGoXNEDDwMKBaxN4el30YUlwYFzENA4iCHiLp4sReLq_nQREBn8s79sUhdHVbNz7GhKrub4/s640/reorg_ts_mbc-dba06.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<b>Step 4: </b>Even after truncated the REORG_T1 table, there is no difference on REORG_TS tablespace size and also tried to resize the datafile.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuKLLUDs27ZR3viHvP6JTbXnt6mSHth2yGmUYxlYcOcjf3eEgPtF2yqgRnHSaJuJuhg1F02tTz8UJ1CnyUGKs1iwiKqthtc0G1o7VazrZ63SvxX1-GZpC89Rgvp3P-otamAppVeTDotMg/s1600/reorg_ts_mbc-dba07.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="178" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuKLLUDs27ZR3viHvP6JTbXnt6mSHth2yGmUYxlYcOcjf3eEgPtF2yqgRnHSaJuJuhg1F02tTz8UJ1CnyUGKs1iwiKqthtc0G1o7VazrZ63SvxX1-GZpC89Rgvp3P-otamAppVeTDotMg/s640/reorg_ts_mbc-dba07.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfefEdJnYdysOQgwDD0k-GnXVOkJAhuqLSx5vub9g6kfCDXnL1ojswessYZC999yl1M0JjrGmip1R-YF1jX7mDgRP5TVihunqNvA9zU9IS3fwLlaBMbVEhGz7lpcCVu4MjTqBtY3YhFBM/s1600/reorg_ts_mbc-dba08.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfefEdJnYdysOQgwDD0k-GnXVOkJAhuqLSx5vub9g6kfCDXnL1ojswessYZC999yl1M0JjrGmip1R-YF1jX7mDgRP5TVihunqNvA9zU9IS3fwLlaBMbVEhGz7lpcCVu4MjTqBtY3YhFBM/s640/reorg_ts_mbc-dba08.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<b>Step 5: </b>Here we can see REORG_TS tablespace with lots of free space. For tablespaces with autoextend enabled, the script calculates the maximum sizes the datafiles can grow to, but the "FREE_MB" column is based on the current file size, so use that figure for tablespaces with datafiles set to autoextend. If we switch off autoextend for the relevant datafile, the output will look more clear.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgplk4vdfGO39qBRFNcDk7B8dqZhDu6x14tL283c31yZ_AuV7H9rPKMnwdl13WH5uogWbYk-IkpZGQ4HJ0F8Laj12yEn8ypD-ae8eVKXzLcnpfmsalg55aq4iRHgokNLz_9SYFi620frg4/s1600/reorg_ts_mbc-dba09.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgplk4vdfGO39qBRFNcDk7B8dqZhDu6x14tL283c31yZ_AuV7H9rPKMnwdl13WH5uogWbYk-IkpZGQ4HJ0F8Laj12yEn8ypD-ae8eVKXzLcnpfmsalg55aq4iRHgokNLz_9SYFi620frg4/s640/reorg_ts_mbc-dba09.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh5UoumXsuxVQjkW_xknrxpHgHjMWxFz7GfdlgtpaaEA_5n0yrJSDxCP3uDwW-nEvYPo6myCY-4_xYfA6Y61sUK68C2gkB0TBAAfwc3cj6qIeFG_yyyTlxpa9W0PjAbTJtBl6oqm0VqcE/s1600/reorg_ts_mbc-dba10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjh5UoumXsuxVQjkW_xknrxpHgHjMWxFz7GfdlgtpaaEA_5n0yrJSDxCP3uDwW-nEvYPo6myCY-4_xYfA6Y61sUK68C2gkB0TBAAfwc3cj6qIeFG_yyyTlxpa9W0PjAbTJtBl6oqm0VqcE/s640/reorg_ts_mbc-dba10.jpg" width="640" /></a></div>
<br />
<b>Step 6: </b>Now start with Export/Import process:<br />
<br />
<ul style="text-align: left;">
<li>Create directory object for the export and import to work</li>
<li>Export the REORG_USER schema</li>
<li>Drop the REORG_USER</li>
<li>Resize the datafile to 5MB</li>
<li>Import the REORG_USER schema</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiinsPWmIvZILGG9oJwqvrqDwx9Q_Nx18msF_cDhFA-YxcodH1FMqoau-92pdm-x9aZA2kl4Z3CK-tAPoBdIeN09r04GFFU_V8b6YAGvx2qqaZM4cNuPEl_n1di4-TZZf5OPPUCIs5bWxU/s1600/reorg_ts_mbc-dba11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiinsPWmIvZILGG9oJwqvrqDwx9Q_Nx18msF_cDhFA-YxcodH1FMqoau-92pdm-x9aZA2kl4Z3CK-tAPoBdIeN09r04GFFU_V8b6YAGvx2qqaZM4cNuPEl_n1di4-TZZf5OPPUCIs5bWxU/s640/reorg_ts_mbc-dba11.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisclup4Afjs36OzW76NU1zUGHdIJZWBinUgmo9HxU_vxOZIzJ5DUdDX0xr1uxAKUahis0mRt3v7PElfYO4OHerW60FwkFm_r9veXN5H6i7UWWChyphenhyphenizMGmbiebTCNXBw61j03Ga8Qj7Kv4/s1600/reorg_ts_mbc-dba12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="298" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisclup4Afjs36OzW76NU1zUGHdIJZWBinUgmo9HxU_vxOZIzJ5DUdDX0xr1uxAKUahis0mRt3v7PElfYO4OHerW60FwkFm_r9veXN5H6i7UWWChyphenhyphenizMGmbiebTCNXBw61j03Ga8Qj7Kv4/s640/reorg_ts_mbc-dba12.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkSaFTFGZo3T1CPVlXJgbcz7YklHNHxgZI1o_ve7y_1m9dwhNatAeRywcIqYZgowi8KkYtOIFCm66HrAbghZEeQVYKqBrQwzwMqjikX9BtSq8kgyI1k0aLbSUhweeMCvZF9U7ayL8wmdw/s1600/reorg_ts_mbc-dba13.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="322" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgkSaFTFGZo3T1CPVlXJgbcz7YklHNHxgZI1o_ve7y_1m9dwhNatAeRywcIqYZgowi8KkYtOIFCm66HrAbghZEeQVYKqBrQwzwMqjikX9BtSq8kgyI1k0aLbSUhweeMCvZF9U7ayL8wmdw/s640/reorg_ts_mbc-dba13.jpg" width="640" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiypDKywEK1Y6Aw7OGaChVHlHC4PL-TQJyquk1ULh7UG_JergS3Oe83lBo1mzG955ddZ0YoZrPpq44UWcv9jf-dAUsfYudgqDjBeRzRdln1Sa8rAfDl1FdKLuckXFckhnzKSJnJYQChgtQ/s1600/reorg_ts_mbc-dba14.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="250" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiypDKywEK1Y6Aw7OGaChVHlHC4PL-TQJyquk1ULh7UG_JergS3Oe83lBo1mzG955ddZ0YoZrPpq44UWcv9jf-dAUsfYudgqDjBeRzRdln1Sa8rAfDl1FdKLuckXFckhnzKSJnJYQChgtQ/s640/reorg_ts_mbc-dba14.jpg" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
Now we can see the size of the datafile has been reduced from 58M to 29M.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_fUkD_aViibDiSUGOKOKU79z8Hy7RMS8SQbNF7MU_z3XQbSDIXnmVpaE_Obz1yH63T2DPhTgACOjK5ps5K-mKX4L1RCTu-BXnaB9UlGAgKyh7QU_tJqFQgGoIhgJTs3oR1jr6H4FJ5nI/s1600/reorg_ts_mbc-dba15.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_fUkD_aViibDiSUGOKOKU79z8Hy7RMS8SQbNF7MU_z3XQbSDIXnmVpaE_Obz1yH63T2DPhTgACOjK5ps5K-mKX4L1RCTu-BXnaB9UlGAgKyh7QU_tJqFQgGoIhgJTs3oR1jr6H4FJ5nI/s640/reorg_ts_mbc-dba15.jpg" width="640" /></a></div>
<div>
<br /></div>
<br />
<div>
Thats it. Hope this article will help you :)</div>
<div>
<br /></div>
<div>
Thanks,</div>
<div>
Chowdari </div>
</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-43639977016154993862016-08-18T02:40:00.001-07:002016-08-18T02:40:24.879-07:00Find Tablespace Freespace in ORACLE 11g<div dir="ltr" style="text-align: left;" trbidi="on">
Below query is useful to displays a list of tablespaces and their used/full status.<br />
<br />
COL tspace form a25 Heading "Tablespace"<br />
COL tot_ts_size form 99999999999999 Heading "Size (Mb)"<br />
COL free_ts_size form 99999999999999 Heading "Free (Mb)"<br />
COL ts_pct form 9999 Heading "% Free"<br />
COL ts_pct1 form 9999 Heading "% Used"<br />
BREAK on report<br />
COMPUTE sum of free_ts_size on report<br />
COMPUTE sum of tot_ts_size on report<br />
SELECT /* + RULE */<br />
df.tablespace_name tspace, df.BYTES / (1024 * 1024) tot_ts_size,<br />
SUM (fs.BYTES) / (1024 * 1024) free_ts_size,<br />
NVL (ROUND (SUM (fs.BYTES) * 100 / df.BYTES), 1) ts_pct,<br />
ROUND ((df.BYTES - SUM (fs.BYTES)) * 100 / df.BYTES) ts_pct1<br />
FROM dba_free_space fs,<br />
(SELECT tablespace_name, SUM (BYTES) BYTES<br />
FROM dba_data_files<br />
GROUP BY tablespace_name) df<br />
WHERE fs.tablespace_name(+) = df.tablespace_name<br />
GROUP BY df.tablespace_name, df.BYTES<br />
UNION ALL<br />
SELECT /* + RULE */<br />
df.tablespace_name tspace, fs.BYTES / (1024 * 1024) tot_ts_size,<br />
SUM (df.bytes_free) / (1024 * 1024) free_ts_size,<br />
NVL (ROUND ((SUM (fs.BYTES) - df.bytes_used) * 100 / fs.BYTES),<br />
1<br />
) ts_pct,<br />
ROUND ((SUM (fs.BYTES) - df.bytes_free) * 100 / fs.BYTES) ts_pct1<br />
FROM dba_temp_files fs,<br />
(SELECT tablespace_name, bytes_free, bytes_used<br />
FROM v$temp_space_header<br />
GROUP BY tablespace_name, bytes_free, bytes_used) df<br />
WHERE fs.tablespace_name(+) = df.tablespace_name<br />
GROUP BY df.tablespace_name, fs.BYTES, df.bytes_free, df.bytes_used<br />
ORDER BY 4 DESC<br />
/<br />
<br />
Thanks,<br />
Chowdari</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-79313194941632342522016-07-12T04:31:00.001-07:002016-07-12T04:33:19.977-07:00To get lsinventory with SQL statement in 12.1.0.2<div dir="ltr" style="text-align: left;" trbidi="on">
In Oracle Database 12c there's DBMS_QOPATCH package available which is very useful to query plenty of information about patches from within the database.<br />
<br />
The DBMS_QOPATCH package provides a PLSQL/SQL interface to view the installed database patches. The interface provides all the patch information available as part of the OPATCH LSINVENTORY -XML command. The package accesses the OUI patch inventory in real time to provide patch and meta-information.<br />
<br />
A client-server database connection won't be able to run OPatch easily and hence the DBMS_QOPATCH API is required.<br />
<br />
<b>Find below scripts to get lsinventory with SQL</b>.<br />
<br />
1) Query to find which patches have been applied:<br />
<div>
<br /></div>
<div>
SQL> set serverout on</div>
<div>
SQL> exec dbms_qopatch.get_sqlpatch_status; <br />
2) Query to find lsinventory from SQL:<br />
<br />
SQL> with a as (select dbms_qopatch.get_opatch_lsinventory patch_output from dual)<br />
select x.*<br />
from a,<br />
xmltable('InventoryInstance/patches/*'<br />
passing a.patch_output<br />
columns<br />
patch_id number path 'patchID',<br />
patch_uid number path 'uniquePatchID',<br />
description varchar2(80) path 'patchDescription',<br />
applied_date varchar2(30) path 'appliedDate',<br />
sql_patch varchar2(8) path 'sqlPatch',<br />
rollbackable varchar2(8) path 'rollbackable') x;<br />
<br />
3) Query to find ORACLE_HOME and inventory:<br />
<br />
SQL> set pagesize 0<br />
SQL> set long 1000000<br />
SQL> select xmltransform(dbms_qopatch.get_opatch_install_info, dbms_qopatch.get_opatch_xslt) "Home and Inventory" from dual;<br />
<br />
Hope these scripts will help you.<br />
<br />
Thanks,<br />
Chowdari</div>
</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com0tag:blogger.com,1999:blog-3046621742164455904.post-27002338717163969082016-06-24T04:41:00.000-07:002016-06-27T04:41:31.063-07:00Creating new CDB using DBCA in 12cR1<div dir="ltr" style="text-align: left;" trbidi="on">Oracle Database 12c allows single container database (CDB) to host multiple separate pluggable databases (PDB). This post covers creating a new CDB using DBCA.<br />
<br />
Follow below steps to create new container database using DBCA:<br />
<br />
<b>Step 1: </b>Set the base parameters and Invoke DBCA<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixTWfiOjXteJAJES9Keb_JMopm1EH7vyn8EQFA_hWJdERmCbPj9xUhx_HU_nuLLMWUFRxCAHL8jdoJbiPvYSfkV8-TJXQ38We5s_acBsgXIOMa5fzsQ9oJaKdHkrYlWd1ZsfcGJ0LNIw0/s1600/mbc-dba-dbca01.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="316" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixTWfiOjXteJAJES9Keb_JMopm1EH7vyn8EQFA_hWJdERmCbPj9xUhx_HU_nuLLMWUFRxCAHL8jdoJbiPvYSfkV8-TJXQ38We5s_acBsgXIOMa5fzsQ9oJaKdHkrYlWd1ZsfcGJ0LNIw0/s640/mbc-dba-dbca01.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYvbxJn_Vv3MomiNrm4GBFq5oulnXT48xb4n-WcGsmDIcw3IwsTDYeaEioaB3cFE3W0Pzjt0XYmyQ_AlhdsixCSTZnhejzn7ezV8137ejKIeGUAz4feiI9U3CwgObeQQkUBNE_FHTMSr0/s1600/mbc-dba-dbca02.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="314" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYvbxJn_Vv3MomiNrm4GBFq5oulnXT48xb4n-WcGsmDIcw3IwsTDYeaEioaB3cFE3W0Pzjt0XYmyQ_AlhdsixCSTZnhejzn7ezV8137ejKIeGUAz4feiI9U3CwgObeQQkUBNE_FHTMSr0/s640/mbc-dba-dbca02.jpg" width="640" /></a><br />
<br />
<b>Step 2: Database Operation -</b> Select "Create Database". Click Next.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg1AufpeFtq3nDqVpXYKNSzD95YuSw7zLitLfmZ8SszJ3gR-9tIGbKap_xPt0oGNJGvDgxejaonax2ki9n-V7Yupho-_wl28XlywTWiCl-0Tyz_9ghe_TGM30j0NRLJ5Z21y2WCizWlHE/s1600/mbc-dba-dbca03.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="364" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgg1AufpeFtq3nDqVpXYKNSzD95YuSw7zLitLfmZ8SszJ3gR-9tIGbKap_xPt0oGNJGvDgxejaonax2ki9n-V7Yupho-_wl28XlywTWiCl-0Tyz_9ghe_TGM30j0NRLJ5Z21y2WCizWlHE/s640/mbc-dba-dbca03.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><b> Step 3: Creation Mode -</b> Select "Advanced Mode". Click Next.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioJlrEDZKxtGiWIdkiNCKh5jHOf9LEvlGzhZwpuLkJiOsiEN2rn1vQjk08DFJHDoQ3l93xGkXBZ8PaDYj3Sb3XdAuKZCY2QIXQaMvCsOAKS6lRLkCAwdeYxekS_Fgt8H4nEx5AAk-xeVE/s1600/mbc-dba-dbca04.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="364" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEioJlrEDZKxtGiWIdkiNCKh5jHOf9LEvlGzhZwpuLkJiOsiEN2rn1vQjk08DFJHDoQ3l93xGkXBZ8PaDYj3Sb3XdAuKZCY2QIXQaMvCsOAKS6lRLkCAwdeYxekS_Fgt8H4nEx5AAk-xeVE/s640/mbc-dba-dbca04.jpg" width="640" /></a></div><br />
<b>Step 4: Database Template -</b> Select "General Purpose or Transaction Processing". Click Next.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXdeyiJzobWVwwOgv6i2RGjGlAl-rVTHrLT2Ms71Zx18mhVxgxGe0iLcSXvAkXwY2d4G4ZWh4aZcahhmEoegyRNI1xVrNLOtcUGnFJTFKX1H3lrAwQw2XoZ3_mXxFp5hm9XUfrhwXr27w/s1600/mbc-dba-dbca05.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXdeyiJzobWVwwOgv6i2RGjGlAl-rVTHrLT2Ms71Zx18mhVxgxGe0iLcSXvAkXwY2d4G4ZWh4aZcahhmEoegyRNI1xVrNLOtcUGnFJTFKX1H3lrAwQw2XoZ3_mXxFp5hm9XUfrhwXr27w/s640/mbc-dba-dbca05.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 5: Database Identification -</b> Enter Global Database Name: cdb2</div><div class="separator" style="clear: both;">SID: cdb2</div><div class="separator" style="clear: both;">Select "Create As Container Database"</div><div class="separator" style="clear: both;">Select "Create An Empty Container Database"</div><div class="separator" style="clear: both;">Click Next.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg97ZUu3Jh-8SKvZMaFvE7If76WDjyGYb70pXnrfD5PyQsaJm33hHnpYWXjFbZm7XzVOZGEQEcM4OS18RtKCa49OwXL9qbUolhCfKrEx-JfyhonEaf8gbKLeAnEeJAGkEf1ttM5aPkExdA/s1600/mbc-dba-dbca06.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg97ZUu3Jh-8SKvZMaFvE7If76WDjyGYb70pXnrfD5PyQsaJm33hHnpYWXjFbZm7XzVOZGEQEcM4OS18RtKCa49OwXL9qbUolhCfKrEx-JfyhonEaf8gbKLeAnEeJAGkEf1ttM5aPkExdA/s640/mbc-dba-dbca06.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 6: Management Options -</b> Deselect "Configure Enterprise Manager (EM) Database Express". Click Next.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2p6r68WPqOcj9IzK4RmLPnzsssXqzqtJWoPFzb2ls01fdhkcGIgX0gGZOPcHCoVjnjjSsiA_W2o8Q0gBwlYfKVqaTbnrehycb2BOmi0QJOwLCArNPqcfs4qTQdGFTR6JEIUI6w3Wq4Es/s1600/mbc-dba-dbca07.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2p6r68WPqOcj9IzK4RmLPnzsssXqzqtJWoPFzb2ls01fdhkcGIgX0gGZOPcHCoVjnjjSsiA_W2o8Q0gBwlYfKVqaTbnrehycb2BOmi0QJOwLCArNPqcfs4qTQdGFTR6JEIUI6w3Wq4Es/s640/mbc-dba-dbca07.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 7: Database Credentials -</b> Select "Use same Administrative password for all accounts" and Enter Password and Confirm password. Click Next.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6UicsGzwIT8FYx9RL2WwdmF8Yp5l1YKrYhgzRhGxvVECD7nGfQSuo6EyqyKBPymxwnTfqCxLZJWX54zNK-mU_Sk9F9IGOpDutt4HxEuG_YoxwXSknGNiklvxV8xpS1iaxK_WXljBAh_M/s1600/mbc-dba-dbca08.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6UicsGzwIT8FYx9RL2WwdmF8Yp5l1YKrYhgzRhGxvVECD7nGfQSuo6EyqyKBPymxwnTfqCxLZJWX54zNK-mU_Sk9F9IGOpDutt4HxEuG_YoxwXSknGNiklvxV8xpS1iaxK_WXljBAh_M/s640/mbc-dba-dbca08.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 8: Network Configuration -</b> Click Next.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFlC0m-us1fcHlAxDhTMSHw2a3UHdHE_KcplznGaYcKmcGHY1JnyDOen-e3IYA1Oru1h8ZUjhzhCK2IRDw882IRCIgjOyvnof4sbloAWqQtSuY-Us9CyoBR8w8MpT2ULknETRKeuVIKxQ/s1600/mbc-dba-dbca09.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFlC0m-us1fcHlAxDhTMSHw2a3UHdHE_KcplznGaYcKmcGHY1JnyDOen-e3IYA1Oru1h8ZUjhzhCK2IRDw882IRCIgjOyvnof4sbloAWqQtSuY-Us9CyoBR8w8MpT2ULknETRKeuVIKxQ/s640/mbc-dba-dbca09.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 9: Storage Locations -</b> Confirm Storage type is "File System". Select "Use Common Location for All Database Files". Click Next. </div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh24YvbJTu02xzRoe48RbaNg89RvwqDrqHC4UYOnrDtMnfXmbBEZlQ9SDlhZY0THocHZWdVEzZZVUeP_-SmJKLrn29U41MC8z60Q9LP6pVS3BEVVQ3Wsqr4sm1J_9LTT_LbOkteVX8lxA0/s1600/mbc-dba-dbca10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh24YvbJTu02xzRoe48RbaNg89RvwqDrqHC4UYOnrDtMnfXmbBEZlQ9SDlhZY0THocHZWdVEzZZVUeP_-SmJKLrn29U41MC8z60Q9LP6pVS3BEVVQ3Wsqr4sm1J_9LTT_LbOkteVX8lxA0/s640/mbc-dba-dbca10.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 10: Database Options -</b> Click Next. </div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidQjgjCZcTB4K-BKh9Z-Rw7aAkn8A4NLpCndh_PlSfg-VAfRczXA9NrWaCrjBnl9SrzIlvlaWxgt64Eo9ZfE_ESoUvuO3vkntX0Z-12IWjlWvnUjPBalVsdlP4Mp6ebvbMFFFvfnWjApE/s1600/mbc-dba-dbca11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidQjgjCZcTB4K-BKh9Z-Rw7aAkn8A4NLpCndh_PlSfg-VAfRczXA9NrWaCrjBnl9SrzIlvlaWxgt64Eo9ZfE_ESoUvuO3vkntX0Z-12IWjlWvnUjPBalVsdlP4Mp6ebvbMFFFvfnWjApE/s640/mbc-dba-dbca11.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 11: Initialization Parameters -</b> Select "Character Sets", Select "Use Unicode (AL32UTF8)". Click Next.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggN5eI4xbZB1jfS6uUOtQiZ7UIblzXShD0GWspVo3EgcGs2iSkfH2cqPQTXYNs01XWaQSTJUKV7867hHAiJHyHavRsjxgjjtMQEX_uhggaXLPoBPmzvtAztnRtCtAFHXg9v1r2jG2XEt0/s1600/mbc-dba-dbca12.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="370" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggN5eI4xbZB1jfS6uUOtQiZ7UIblzXShD0GWspVo3EgcGs2iSkfH2cqPQTXYNs01XWaQSTJUKV7867hHAiJHyHavRsjxgjjtMQEX_uhggaXLPoBPmzvtAztnRtCtAFHXg9v1r2jG2XEt0/s640/mbc-dba-dbca12.jpg" width="640" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM99q546lQHXIbHARrz6yJNr0ESFM39WrGygQ2_hvOjGQ_OBKmhvCik2V0-8dWVMIU4XXJCGXHcx4PQZbHv2c4nLgMmAlj2KpwaA_wtJ1GMh7iG9D1jjCfPaJK6T1PbCtCzFzoyfdYJG0/s1600/mbc-dba-dbca13.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM99q546lQHXIbHARrz6yJNr0ESFM39WrGygQ2_hvOjGQ_OBKmhvCik2V0-8dWVMIU4XXJCGXHcx4PQZbHv2c4nLgMmAlj2KpwaA_wtJ1GMh7iG9D1jjCfPaJK6T1PbCtCzFzoyfdYJG0/s640/mbc-dba-dbca13.jpg" width="640" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3junWYGEh0L3i9JBvIAJ80dEukG0gYwGEl3y2ONhO2dcOVB7PBPPyKpN0-XeBeDWs9QIoI5AYZwAjZOSqAWXWda8oyV-00lheYFr-xaFDhsT30KOsOk4zI_v1Y6Y7elgeIuPHnnCEUdA/s1600/mbc-dba-dbca14.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3junWYGEh0L3i9JBvIAJ80dEukG0gYwGEl3y2ONhO2dcOVB7PBPPyKpN0-XeBeDWs9QIoI5AYZwAjZOSqAWXWda8oyV-00lheYFr-xaFDhsT30KOsOk4zI_v1Y6Y7elgeIuPHnnCEUdA/s640/mbc-dba-dbca14.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 12: Creation Options -</b> Select "Create Database". Click Next.</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoHACC2GRhgiBESlgTl7QXCfGgeraNobIfa4yJ4Yf_A8JU5FZ-UvCo0r8NUn_tggZTSIZ2O67HT-6JwTPU_5ER2WcHK0veMqsbG-EMD-H7wY-oBoQSJdApYKhnhnyQoFW1ocS-ghI6vmw/s1600/mbc-dba-dbca15.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoHACC2GRhgiBESlgTl7QXCfGgeraNobIfa4yJ4Yf_A8JU5FZ-UvCo0r8NUn_tggZTSIZ2O67HT-6JwTPU_5ER2WcHK0veMqsbG-EMD-H7wY-oBoQSJdApYKhnhnyQoFW1ocS-ghI6vmw/s640/mbc-dba-dbca15.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;"><b>Step 13: Pre Requisite Checks and Summary -</b> Click Finish</div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzeViofuCO_c_UMk41FJaHCrEAACQ3baRDPqFnsxiwGfeIk8WpEPFRrBVv1YLT1FV7jlg2fb7JwXNtVzf1M-LGgPRwe-l5DuJlHhgbb3uqMNPcz4KoIBv9D9ZCUWlj7oOMMNEKqpPfBwQ/s1600/mbc-dba-dbca16.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="362" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzeViofuCO_c_UMk41FJaHCrEAACQ3baRDPqFnsxiwGfeIk8WpEPFRrBVv1YLT1FV7jlg2fb7JwXNtVzf1M-LGgPRwe-l5DuJlHhgbb3uqMNPcz4KoIBv9D9ZCUWlj7oOMMNEKqpPfBwQ/s640/mbc-dba-dbca16.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;">Database creation is in progress</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt0mhrn76tPzfEVR9guLyBVCaavCgudis3voSSi53oCI8h8-PXaj6lLjmE2LAVNVOS09t6FO9hTF_qDa39IhxD5S6UtL611axo0-R6YrZwLSdFpbpafQr9PW_SSerJ41Vp7HGctuJ6b2g/s1600/mbc-dba-dbca17.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt0mhrn76tPzfEVR9guLyBVCaavCgudis3voSSi53oCI8h8-PXaj6lLjmE2LAVNVOS09t6FO9hTF_qDa39IhxD5S6UtL611axo0-R6YrZwLSdFpbpafQr9PW_SSerJ41Vp7HGctuJ6b2g/s640/mbc-dba-dbca17.jpg" width="640" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTkaRt__2R6VPEQWknd4bjvrUEFoOL_enL2eZdWBzq84qAflGTPstGSCS5pHvwjC-u-G5LoIABzB6splGixaVeNXtNOhj-y_ipmUrnC4BmQlV4xTDiNr3thp4-xo9ZXgyDqizD0Afj_mk/s1600/mbc-dba-dbca18.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="368" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTkaRt__2R6VPEQWknd4bjvrUEFoOL_enL2eZdWBzq84qAflGTPstGSCS5pHvwjC-u-G5LoIABzB6splGixaVeNXtNOhj-y_ipmUrnC4BmQlV4xTDiNr3thp4-xo9ZXgyDqizD0Afj_mk/s640/mbc-dba-dbca18.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;">Database creation completed. Click close</div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSbWK9iC_-so2CxVgohAoBjnulq6JEKkh57IW5M7Yej86yvuxZ_1BQlsSAb3_kyXXRN0ag5LNnQrW15qieK1monX27at4brgPy0wVUkey_4hhFKGwDn3UEuc1bRIQkhZK-XkhklXYXZNA/s1600/mbc-dba-dbca19.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="366" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSbWK9iC_-so2CxVgohAoBjnulq6JEKkh57IW5M7Yej86yvuxZ_1BQlsSAb3_kyXXRN0ag5LNnQrW15qieK1monX27at4brgPy0wVUkey_4hhFKGwDn3UEuc1bRIQkhZK-XkhklXYXZNA/s640/mbc-dba-dbca19.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br />
</div><div class="separator" style="clear: both; text-align: left;">Thats it. Hope this article will help you :-)</div><div class="separator" style="clear: both; text-align: left;"><br />
</div><div class="separator" style="clear: both; text-align: left;">Thanks,</div><div class="separator" style="clear: both; text-align: left;">Chowdari</div></div>Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com3tag:blogger.com,1999:blog-3046621742164455904.post-8390370204550110342016-04-22T02:49:00.000-07:002016-04-22T02:53:59.907-07:00Re-Creating Appsutil directory for DB Tier in EBS R12<div dir="ltr" style="text-align: left;" trbidi="on">
Lets assume, while performing DB activities If plan to change the database port, host, SID, or database name parameter on the database server, you must also update AutoConfig on the database tier and also de-register the current database server node. So such cases we need to Re-Create Appsutil directory for DB Tier.<br />
<br />
<h4 style="text-align: left;">
<b>Follow below steps to Re-Create Appsutil and sub directories for DB Tier:</b></h4>
<div>
<b><br /></b></div>
<b>On the Application Tier:</b><br />
<br />
Step 1: Source the environment variables for Oracle Applications<br />
<br />
<i> $ source $APPL_TOP/APPS.env</i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span> <br />
Step 2: Run AutoConfig on the APPL_TOP<br />
<br />
<i>$ sh $ADMIN_SCRIPT_HOME/adautocfg.sh</i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
Step 3: Execute admkappsutil.pl utility to create the file appsutil.zip<br />
<br />
<i>$ perl $AD_TOP/bin/admkappsutil.pl</i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
admkappsutil.pl utility will create appsutil.zip in $INST_TOP/admin/out directory<br />
<br />
<b>On the Database Tier:</b><br />
<br />
Step 1: Source the environment variables for RDBMS ORACLE_HOME<br />
<br />
<i>$ source $ORACLE_HOME/.env</i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
Step 2: Copy the created appsutil.zip file from $INST_TOP/admin/out to the <RDBMS ORACLE_HOME><br />
<br />
Step 3: Uncompress appsutil.zip under the <RDBMS ORACLE_HOME> <br />
<br />
<i>$ cd $ORACLE_HOME</i><br />
<i> $ unzip -o appsutil.zip</i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
Step 4: Create Contextfile<br />
<br />
<i> $ cd $ORACLE_HOME/appsutil/bin</i><br />
<i> $ perl adbldxml.pl appsuser=apps</i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
Step 5: Create Scripts directory<br />
<br />
<i>$ cd $ORACLE_HOME/appsutil/bin</i><br />
<i> $ sh adconfig.sh contextfile=<contextfile path></i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
Step 6: Run AutoConfig on the <RDBMS ORACLE_HOME><br />
<br />
<i>$ sh $ORACLE_HOME/appsutil/scripts/<context_name>/adautocfg.sh</i><br />
<span class="Apple-tab-span" style="white-space: pre;"> </span><br />
Thats it. Hope this article will help you :)</div>
Chowdari Mathukumillihttp://www.blogger.com/profile/01522309225341023981noreply@blogger.com10