tag:blogger.com,1999:blog-76200612389171871202024-03-28T19:38:10.240+05:30Oracle Business IntelligenceYet another Oracle BI BlogBose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.comBlogger139125tag:blogger.com,1999:blog-7620061238917187120.post-84856135051400545912024-03-01T00:08:00.000+05:302024-03-01T00:08:11.284+05:30What is Oracle Database Link and How to create database link (DB Link)<p> https://www.oracletutorial.com/oracle-administration/oracle-create-database-link/</p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-46529829466698704862023-04-13T04:32:00.004+05:302023-04-13T04:54:26.580+05:30OBIEE 12c to OAS Migration<p> Hi All,</p><p>I have migrated successfully few projects from BI 12c to OAS 6.4. If anyone wants help then please reach Me!</p><p>Cheers!</p><p>Bose</p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com2tag:blogger.com,1999:blog-7620061238917187120.post-37122936483908069992023-04-05T04:30:00.001+05:302023-04-13T04:54:46.333+05:30Oracle Analytics Server 7.0.0.0.0 is Available for Download<p> After OAS 5.5, 5.9 and 6.4, Now Oracle has release OAS 7.0.0.0 and it is available for download and Install.</p><p><br /></p><p>OAS 7.0 Home Page: </p><p>https://www.oracle.com/solutions/business-analytics/analytics-server/analytics-server.html</p><p><br /></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-23352943767323214762021-01-21T22:41:00.012+05:302021-08-10T22:54:57.727+05:30Searching a log files in Linux<p><span style="font-family: georgia;"> Being a Developer and Administrator, It is our everyday duty to analyze log files of bi server, scheduler, presentation or nodemanager log. </span></p><p><span style="font-family: georgia;">When logs are growing, it is difficult to identify and track it. For e.g: When hundred Agents are scheduled, it is creating 200 files everyday with .log and .err files in scheduler log location. </span></p><p><span style="font-family: georgia;">When you want to search yesterday or today or 10 days before with the particular agent log file, the following syntax will help you to bring up the files.</span></p><p><span style="color: #2b00fe; font-family: georgia;">[logs]$ find . -iname "Agent-111-*" -atime -2 -type f -ls</span></p><p><span style="font-family: georgia;">The above syntax will list out all the files starts with Agent id 111 before 2 days.</span></p><p><span style="font-family: georgia;">Customize the syntax based on your need.</span></p><p><span style="font-family: georgia;"><br /></span></p><p><span style="font-family: georgia;">Cheers!</span></p><p>Bose </p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com21tag:blogger.com,1999:blog-7620061238917187120.post-40419444211638466582020-12-06T22:32:00.013+05:302020-12-24T10:59:30.189+05:30 Oracle Analytics Server Step by Step Installation in Windows | OAS 5.5 Installation in Windows<p><span style="font-family: helvetica;">Surprisingly Oracle has released OAS for windows and I gave a try to install OAS 5.5 in windows to check out the look and features. This post has the steps how I have installed OAS 5.5 in windows.</span></p><p><b><span style="font-family: helvetica;">Prerequisite:</span></b></p><p><span style="font-family: helvetica;">1. Java JDK1.8 221 or Above.<a href="http://allaboutobiee.blogspot.com/2020/08/installing-jdk-8u271in-windows.html" target="_blank"><b> (Step by Step installation of Java)</b></a></span></p><p><span style="font-family: helvetica;">2. Oracle Database 11g Release 2 and above. <b><a href="http://allaboutobiee.blogspot.com/2020/08/oracle-database-12c-step-by-step.html" target="_blank">(Step by step Installation of Oracle DB 12c)</a></b></span></p><p><span style="font-family: helvetica;">3. I would highly recommend to have minimum of 16 GB Memory and 50GB Disk Space to Install in your windows machine.</span></p><p><span style="font-family: helvetica;">OAS 5.5 has 4 Major stages of Installation in Windows</span></p><p><span style="color: #2b00fe; font-family: helvetica;">1. Oracle Fusion Middleware Installation</span></p><p><span style="color: #2b00fe; font-family: helvetica;">2. OAS Platform Installation</span></p><p><span style="color: #2b00fe; font-family: helvetica;">3. RCU (Repository Creation Utility) </span></p><p><span style="color: #2b00fe; font-family: helvetica;">4. OAS Configuration</span></p><p><span style="font-family: helvetica;"><b>Note: </b></span><span style="font-family: helvetica;">Interim FMW Patch is </span><span style="font-family: helvetica;">only for Linux and</span><span style="font-family: helvetica;"> not required for Windows. </span></p><p><span style="font-family: helvetica;">Download the OAS 5.5 software's files and extract it in a folder.</span></p><p><span style="font-family: helvetica;">Download Link: </span></p><p><span><span style="color: #2b00fe; font-family: georgia;">https://www.oracle.com/solutions/business-analytics/analytics-server/analytics-server.html</span></span></p><p><span></span></p><div class="separator" style="clear: both; font-family: helvetica; text-align: center;"><span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkcn8kysbk7uxPhEUkh5vTd5DdMe7TanDTlp8JAYYMf-zYEabGWA4E8_kHVfon68WrwqwXLyWAM6Lk_kR1Ogv-YjrUBwi0bMaAjh8B0w3YdrpQjEwEMIn3msuIG6I7gN1hZM4Pk0SXj7c/s865/OAS+Download.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="642" data-original-width="865" height="475" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkcn8kysbk7uxPhEUkh5vTd5DdMe7TanDTlp8JAYYMf-zYEabGWA4E8_kHVfon68WrwqwXLyWAM6Lk_kR1Ogv-YjrUBwi0bMaAjh8B0w3YdrpQjEwEMIn3msuIG6I7gN1hZM4Pk0SXj7c/w640-h475/OAS+Download.png" width="640" /></a></span></div><p></p><p><span style="font-family: helvetica;">Check if JAVA_HOME and ORACLE_HOME variable are set in Environment variable. If it is not set, then Create the environment variable.</span></p><p><span style="font-family: helvetica;">example: </span></p><p><span style="font-family: helvetica;">JAVA_HOME=C:\Program Files\Java\jre1.8.0_271</span></p><p><span style="font-family: helvetica;">ORACLE_HOME=C:\oracle\app\oracle\product\11.2.0\db_1</span></p><p><span style="color: #2b00fe; font-family: helvetica;"><b>Step1: Oracle Fusion Middleware Installation</b></span></p><p><span style="font-family: helvetica;">Open the Command Prompt with 'Run as administrator' and go to JAVA bin location to start the fusion middleware installation. The whole OAS installation going to be done in command prompt with the same manner.</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEJI_G8upoTa5XFzuIrej50ODvDyarik9egLH4ed-m6y2k229zGn-bnBg1Rb7B97Pj0cRZKGmBtad4toszrnMHV0RsB-XcMPys5KMW98U535MupipJ1eKVv27tXAitLwrt7JBYCLHx8xk/s653/command+prompt.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="360" data-original-width="653" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEJI_G8upoTa5XFzuIrej50ODvDyarik9egLH4ed-m6y2k229zGn-bnBg1Rb7B97Pj0cRZKGmBtad4toszrnMHV0RsB-XcMPys5KMW98U535MupipJ1eKVv27tXAitLwrt7JBYCLHx8xk/w400-h220/command+prompt.png" width="400" /></a></div><p></p><p><span style="font-family: helvetica;">cd C:\Program Files\Java\jre1.8.0_271\bin</span></p><p><span style="font-family: helvetica;">C:\Program Files\Java\jre1.8.0_271\bin> java -jar D:\OAS\fmw_12.2.1.4.0_infrastructure.jar</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFm-hR7ZYAphPoM5VNiT85skZV3hu3VPqTW3ZzwvsbM88ZmnOpoqd50AyGJ39KwOlUKR6pEAYu4kOxJgSO7okP0AEW2I2pczo0P7XAyZwqCNt8CHu5fnq2BdrZUDSmHQsxpciFVpyEbkA/s979/oas1.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="298" data-original-width="979" height="194" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFm-hR7ZYAphPoM5VNiT85skZV3hu3VPqTW3ZzwvsbM88ZmnOpoqd50AyGJ39KwOlUKR6pEAYu4kOxJgSO7okP0AEW2I2pczo0P7XAyZwqCNt8CHu5fnq2BdrZUDSmHQsxpciFVpyEbkA/w640-h194/oas1.png" width="640" /></span></a></div><span style="font-family: helvetica;">It will check the prerequisite and starts the installation. Just click 'Next' with the below screen.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwHgIndbzHWA01pnP5D4um_6g3T-V5h2nOV0uafCtvQ-zg8s_sg-BA_TbfPAq7yXJ0hN2pya_53lbwIv8kNdG0I8pz6Bga9Zn1NHg_vTlrwEF1cmSqLz-m0resAIiFjBQQSLC6ZbVs9vI/s786/oas2.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwHgIndbzHWA01pnP5D4um_6g3T-V5h2nOV0uafCtvQ-zg8s_sg-BA_TbfPAq7yXJ0hN2pya_53lbwIv8kNdG0I8pz6Bga9Zn1NHg_vTlrwEF1cmSqLz-m0resAIiFjBQQSLC6ZbVs9vI/w640-h504/oas2.png" width="640" /></span></a></div><span style="font-family: helvetica;">Select the installation directory where you want to install OAS.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxxr0MxrLtupKUr0pzPL3kmfB7RIi6ZgykohH1F6xkFGB-9as5PYuJhXDRNuS-WTke6KHCA25Vt9wLKzE-ZSg1FdYN0rzlhqXTDGuI-DGK_Ej9shuShqoJsDFfS_arWErCrf1wsyxNKac/s786/4.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxxr0MxrLtupKUr0pzPL3kmfB7RIi6ZgykohH1F6xkFGB-9as5PYuJhXDRNuS-WTke6KHCA25Vt9wLKzE-ZSg1FdYN0rzlhqXTDGuI-DGK_Ej9shuShqoJsDFfS_arWErCrf1wsyxNKac/w640-h504/4.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">Just keep the default selection 'Fusion Middleware Infrastructure' and Click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk6CV73eKgJx6cJ7N-XIt3OKjc1YfCdDWEtJjfYAzR8hFmRGdiYRDK9i2BO8ysVrW70QF1sahGin7A-rvXJ1PJ_4_dnxeZRx6rXHp4vwgyfgdyIq9LCquS2CwM3lpYSP7q3wiY7fdAEjY/s786/oas5.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk6CV73eKgJx6cJ7N-XIt3OKjc1YfCdDWEtJjfYAzR8hFmRGdiYRDK9i2BO8ysVrW70QF1sahGin7A-rvXJ1PJ_4_dnxeZRx6rXHp4vwgyfgdyIq9LCquS2CwM3lpYSP7q3wiY7fdAEjY/w640-h504/oas5.png" width="640" /></span></a></div><span style="font-family: helvetica;">Now the installer checks the system certification and java version. Just click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDhcu-BcufuD4_unSR5V0t8fflkjMPtnowrzXUMrrTywkLrnBz56nENzLWv2QmKbQrAs2bKVYaXBSmcbg_kV2luJcBABWhOP11KK6L6St2HnXkAK2_3fpyCKJ6-GT4hxedmCIvHTI2_xw/s786/oas6.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDhcu-BcufuD4_unSR5V0t8fflkjMPtnowrzXUMrrTywkLrnBz56nENzLWv2QmKbQrAs2bKVYaXBSmcbg_kV2luJcBABWhOP11KK6L6St2HnXkAK2_3fpyCKJ6-GT4hxedmCIvHTI2_xw/w640-h504/oas6.png" width="640" /></span></a></div><span style="font-family: helvetica;">With this step, I have saved the response file for silent installation. If you don't want, then just click 'Install' to start the installation of OAS FMW.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYvs7gvQ0pefFy_VQLO-tFWIh-zVuJdj3_HiW0f-9n6WH1MUqqnyJYR3ILUXB8Da4TQ4UQujxYb9qCcLH0zyXCKnN1pPBeUCgIG8LqXTzHtdD_0PI1D463Dmx3neEz9UWjfFMout6FaiA/s1366/oas7.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="768" data-original-width="1366" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYvs7gvQ0pefFy_VQLO-tFWIh-zVuJdj3_HiW0f-9n6WH1MUqqnyJYR3ILUXB8Da4TQ4UQujxYb9qCcLH0zyXCKnN1pPBeUCgIG8LqXTzHtdD_0PI1D463Dmx3neEz9UWjfFMout6FaiA/w640-h360/oas7.png" width="640" /></span></a></div><span style="font-family: helvetica;">Just click 'Install'.</span><div><span style="font-family: helvetica;">Save response file if you would like to use it later for silent installation in another environment.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-NuuAmkqvHeuthZv4MvHCmwaJOL_BOUhMFwntu6kqQkQX4O_sxltFMBSjJN-bKv6Z4n38rn8pLW-mTHMu2h5tTsSs5UjGY5slyGwbkTeKvb3OSTaDnw-hdYvHGGuC57mMVndZIAeIBIU/s786/7.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi-NuuAmkqvHeuthZv4MvHCmwaJOL_BOUhMFwntu6kqQkQX4O_sxltFMBSjJN-bKv6Z4n38rn8pLW-mTHMu2h5tTsSs5UjGY5slyGwbkTeKvb3OSTaDnw-hdYvHGGuC57mMVndZIAeIBIU/w640-h504/7.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">OAS FMW installation is in progress....<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1ajDNXu_nO-6a6Wp84HchksGGI7kIEvrNY9NgdEA0yDBM1_jODHLnqHQfA5ng7K7zHWnRBEdVxmeUN9MvqwZt1s6xC3fS8ZbIuKflGqPi_0CS2DlLkn6mX_Z8TqReU5VXRTzL5FcAEiA/s786/oas9.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1ajDNXu_nO-6a6Wp84HchksGGI7kIEvrNY9NgdEA0yDBM1_jODHLnqHQfA5ng7K7zHWnRBEdVxmeUN9MvqwZt1s6xC3fS8ZbIuKflGqPi_0CS2DlLkn6mX_Z8TqReU5VXRTzL5FcAEiA/w640-h504/oas9.png" width="640" /></span></a></div><span style="font-family: helvetica;">If all the steps are successful, it will complete with 100%. Just click 'Next' Here<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYXVXOeGo5HoE1sj3HwI1MhGb6ytQx7gUmx_IDYIwVaBbvC0zw4vrP8iwyn9wBjI3ft3g4hhRwMJVYeFn1G8qYsNVLFYOuH6YnpJ5pegqSDict-8_DGd8hxV35uBtuIbwByl5AJLjZ-pE/s786/oas10.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYXVXOeGo5HoE1sj3HwI1MhGb6ytQx7gUmx_IDYIwVaBbvC0zw4vrP8iwyn9wBjI3ft3g4hhRwMJVYeFn1G8qYsNVLFYOuH6YnpJ5pegqSDict-8_DGd8hxV35uBtuIbwByl5AJLjZ-pE/w640-h504/oas10.png" width="640" /></span></a></div><span style="font-family: helvetica;">We have come to the last step of OAS FMW installation. Just click 'Finish' the complete the installation.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGeP89PoVEviEMcHO-Qnm50qXFd5flZwoeXI6_7XbCCWuWHE29lcD7i4heK29UEm18O0XI-BbKB6fHvmiTq1Wr8vU5dUDEXjvNN_cnLXhSStxuossWa7VbW5lci8LsXddSKvxQXxCw7ts/s786/oas11.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGeP89PoVEviEMcHO-Qnm50qXFd5flZwoeXI6_7XbCCWuWHE29lcD7i4heK29UEm18O0XI-BbKB6fHvmiTq1Wr8vU5dUDEXjvNN_cnLXhSStxuossWa7VbW5lci8LsXddSKvxQXxCw7ts/w640-h504/oas11.png" width="640" /></span></a></div><div><br /></div><div><p><span style="color: #2b00fe; font-family: helvetica;"><b>2. OAS Platform Installation</b></span></p><p><span style="font-family: helvetica;">Go to Java bin directory and execute the OAS Platform JAR file with the below command from command prompt.</span></p><p><span style="font-family: helvetica;">cd C:\Program Files\Java\jdk1.8.0_271\bin</span></p><p><span style="font-family: helvetica;">C:\Program Files\Java\jdk1.8.0_271\bin> java -jar D:\OAS\oa_platform-5.5.0.0.0-20200829051051-win64.jar</span></p><p><span style="font-family: helvetica;">It will take a while as the jar file is huge and will start the install window.</span></p><p></p><div class="separator" style="clear: both; color: #2b00fe; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaja8NdryEQgNcOiQHSvB8bUH-4NgEo1V8BQeugQKEITG7W_11EE1BRVkMtZSkkhwkQQ8KyCgK-sYeUE9kU6LuXPMtSGO8UJtFAZ46O8j5k23mWC3ByYn5zJcPc06SfQsei57mgRH0GcE/s979/oasin1.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="512" data-original-width="979" height="334" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaja8NdryEQgNcOiQHSvB8bUH-4NgEo1V8BQeugQKEITG7W_11EE1BRVkMtZSkkhwkQQ8KyCgK-sYeUE9kU6LuXPMtSGO8UJtFAZ46O8j5k23mWC3ByYn5zJcPc06SfQsei57mgRH0GcE/w640-h334/oasin1.png" width="640" /></span></a></div><span style="font-family: helvetica;">Just Click 'Next' with the first step<br /></span><p></p><p><span style="color: #2b00fe; font-family: helvetica;"></span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7sXABi2WOnVaK4npfrLA40L6JBcVEvj89p5nGDGPKjqDaAjYmT1N42dYjFgMoMHGLuRKP46eZmXdrVC4oTMSuRY5LyRtFLXZiJXcV8wwWt93btduf63rEK7J1bqKiSdKypw9CeNNmYXg/s786/oasin2.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7sXABi2WOnVaK4npfrLA40L6JBcVEvj89p5nGDGPKjqDaAjYmT1N42dYjFgMoMHGLuRKP46eZmXdrVC4oTMSuRY5LyRtFLXZiJXcV8wwWt93btduf63rEK7J1bqKiSdKypw9CeNNmYXg/w640-h504/oasin2.png" width="640" /></span></a></div><span style="font-family: helvetica;">Leave with default selection 'Skip Auto Updates' and click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvaGmWX6M5JRBPHlh5gkPiKgDvk4_tWEi47Pd6hB8RtYH-44TnyvomMvw7hZOuBqcH2hQlU07zmgcdVKUOZDohgXS8KGjCBEEKmSB69w8RoKeHddDkQXYiG0S2dzIVR6qy2NoKtPksOTg/s786/oasin3.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgvaGmWX6M5JRBPHlh5gkPiKgDvk4_tWEi47Pd6hB8RtYH-44TnyvomMvw7hZOuBqcH2hQlU07zmgcdVKUOZDohgXS8KGjCBEEKmSB69w8RoKeHddDkQXYiG0S2dzIVR6qy2NoKtPksOTg/w640-h504/oasin3.png" width="640" /></span></a></div><span style="font-family: helvetica;">In this step, select your Oracle Home from your fusion middleware directory and click 'Next'. Here I created my own directory OAS55 in D drive and selected that directory.</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5wKLeghVFL5f2P0XRpPMAgqy58uJiZXc3rOIQi7wXRNWSXmGs0JVQD8qltVsFTxuExslpsTlks4Vdh3JU5IzdUSBWWKZGvYwAKp7J9lgzPZBGcWYI9IjJwAAeRnVil2g1v4WlioxrvF0/s786/4.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5wKLeghVFL5f2P0XRpPMAgqy58uJiZXc3rOIQi7wXRNWSXmGs0JVQD8qltVsFTxuExslpsTlks4Vdh3JU5IzdUSBWWKZGvYwAKp7J9lgzPZBGcWYI9IjJwAAeRnVil2g1v4WlioxrvF0/w640-h504/4.png" width="640" /></a></div><br /><span style="font-family: helvetica;"><br /></span><span style="font-family: helvetica;">It will check the prerequisite. Just click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQhaPwR4_w6IWmdPzTkykzCCOB54txZp5nHh7QuNo_sIXJSsvHVxoq5fR-eyqIxCGRSfJmScY_1LMXsuLQ0DaGremsHnZigUZlFNxqjCPqJAytsLpaDi7F8DNrdiK4P8P01cwwmqmJxSM/s786/oasin5.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgQhaPwR4_w6IWmdPzTkykzCCOB54txZp5nHh7QuNo_sIXJSsvHVxoq5fR-eyqIxCGRSfJmScY_1LMXsuLQ0DaGremsHnZigUZlFNxqjCPqJAytsLpaDi7F8DNrdiK4P8P01cwwmqmJxSM/w640-h504/oasin5.png" width="640" /></span></a></div><span style="font-family: helvetica;">With the below step, Save response file if you would like to use it for silent installation in any other system. otherwise just click 'Install'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDWVsN_bbK7gXts7m8pnKDukP15dyTxAjDRC_Ck1ma9INa-GmRL-8wW8KSZcxUDDQLnsLLUh_C40UR8sYhYxVqMtmfaMHdyd481ptAu88oh61i9LnDarsVDC6yFtr6kUIsIra1O-0l3iw/s786/6.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDWVsN_bbK7gXts7m8pnKDukP15dyTxAjDRC_Ck1ma9INa-GmRL-8wW8KSZcxUDDQLnsLLUh_C40UR8sYhYxVqMtmfaMHdyd481ptAu88oh61i9LnDarsVDC6yFtr6kUIsIra1O-0l3iw/w640-h504/6.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">Installation is in progress......<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHH6lk4MAi8IljUM4wS8INo0SCCzZaOuZQUsg0_PX0fqDDo896fusq5CkvGJVifJ2msAB9H52gxvN_L_fcBTohzV4jjV1oMB8E3Nj1gTkxwX_nHd866b3qglYiJWplsTxNoF3gnqsekBo/s786/oasin7.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHH6lk4MAi8IljUM4wS8INo0SCCzZaOuZQUsg0_PX0fqDDo896fusq5CkvGJVifJ2msAB9H52gxvN_L_fcBTohzV4jjV1oMB8E3Nj1gTkxwX_nHd866b3qglYiJWplsTxNoF3gnqsekBo/w640-h504/oasin7.png" width="640" /></span></a></div><span style="font-family: helvetica;">If it prompts for MS Visual package, just click Allow and close once it is completed.</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJKNGJng5d034mC52nc6rnjkfDBTZcMuKzyXT5q7f2EzbPMOUK-7I4Gvrwewlyc-QZRCep0JDPIqqOYHh-Mypx4V5T0Wpqw0m2nQXsTYwyAZGyaJNqqXxXiPsxSrBiiMsDL9q5rWFrLPI/s481/oasin8.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="298" data-original-width="481" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJKNGJng5d034mC52nc6rnjkfDBTZcMuKzyXT5q7f2EzbPMOUK-7I4Gvrwewlyc-QZRCep0JDPIqqOYHh-Mypx4V5T0Wpqw0m2nQXsTYwyAZGyaJNqqXxXiPsxSrBiiMsDL9q5rWFrLPI/w400-h248/oasin8.png" width="400" /></span></a></div><span style="font-family: helvetica;">OAS Platform installation is completed successfully with 100%. Click '<b>Next</b>'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtDqvn8kNViv8QTeTpkPLObXvJvXgllG3rD5n7MwEKO1vYY0GCXPzU5Lo3dID0P_GoVYkVWwwBxfbYE1sKUx9BaXCxuPT25X6oTmLdKSmTWjS_frJ_v0CpwYspxpUmqKq3W6RPU95M0ZY/s786/oasin9.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtDqvn8kNViv8QTeTpkPLObXvJvXgllG3rD5n7MwEKO1vYY0GCXPzU5Lo3dID0P_GoVYkVWwwBxfbYE1sKUx9BaXCxuPT25X6oTmLdKSmTWjS_frJ_v0CpwYspxpUmqKq3W6RPU95M0ZY/w640-h504/oasin9.png" width="640" /></span></a></div><span style="font-family: helvetica;">Click '<b>Finish</b>' with the last step to complete the installation.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXtonBiJd8Tdz_QmZPfbFPN0WUwV3-fx_bj61RSbll9ISUJFP6JZHzSXh-G7pPM01hKtHH6E3uey4sasgb7YhEPyfUwONfJH_BRLau_VqXSY1d_Y-zwhHHyAedoFvFfo6WUic1OcZiu8M/s786/9.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXtonBiJd8Tdz_QmZPfbFPN0WUwV3-fx_bj61RSbll9ISUJFP6JZHzSXh-G7pPM01hKtHH6E3uey4sasgb7YhEPyfUwONfJH_BRLau_VqXSY1d_Y-zwhHHyAedoFvFfo6WUic1OcZiu8M/w640-h504/9.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">Command prompt window after OA Platform installation.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTpwcM5Pu15EPyptC7O8YpLi0pSvL4G-mD6SqV7hn_MPSIRJONFfP9-veS6ZkwfC3ebvH2q2L499SDcYIIMc8dImup3L84NELknQnIbJXykakxSx4ytIiBZS6-j-7-SH9acWJmY4GA2iY/s979/10.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="329" data-original-width="979" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTpwcM5Pu15EPyptC7O8YpLi0pSvL4G-mD6SqV7hn_MPSIRJONFfP9-veS6ZkwfC3ebvH2q2L499SDcYIIMc8dImup3L84NELknQnIbJXykakxSx4ytIiBZS6-j-7-SH9acWJmY4GA2iY/w640-h216/10.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><p></p><p><span style="font-family: helvetica;"><span style="color: #2b00fe;"><b>4</b></span><b style="color: #2b00fe;">. RCU (Repository Creation Utility) </b></span></p><p><span style="font-family: helvetica;">Go to the OAS Middleware common bin directory bi\bin and run command.</span></p><p><span style="font-family: helvetica;">cd D:\OAS55\oracle_common\bin</span></p><p><span style="font-family: helvetica;">D:\OAS55\oracle_common\bin> rcu.bat</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ1BiY_FWPbP-tPTYI2d8UkXnvQeODoJNsWsHaK0RUUdcoa4fTB-SBZmzyzq8faVbXidJN3N6GaH-3tic0RzcdhGMfCeKcXauiXsQ1ZJF7_Bhgrj_BycA1Js3QBr4Z3Z-jYWV_uqWXTB8/s979/1.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="329" data-original-width="979" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ1BiY_FWPbP-tPTYI2d8UkXnvQeODoJNsWsHaK0RUUdcoa4fTB-SBZmzyzq8faVbXidJN3N6GaH-3tic0RzcdhGMfCeKcXauiXsQ1ZJF7_Bhgrj_BycA1Js3QBr4Z3Z-jYWV_uqWXTB8/w640-h216/1.png" width="640" /></a></div><span style="font-family: helvetica;">Just click 'Next' with the first step</span><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-ICex51YhbB_XoA42shcKmB6vNpWg8bUC_I7k_EruQ1u_u4J9sYr116VsxVlvcxClGutTIX-6fK-mksgBJWdJyJ-BzGvQ_vPbu4E1cxGQTaAzQyCvqQYmJu9i3_glk5kWewug618zEEg/s802/oasrcu2.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-ICex51YhbB_XoA42shcKmB6vNpWg8bUC_I7k_EruQ1u_u4J9sYr116VsxVlvcxClGutTIX-6fK-mksgBJWdJyJ-BzGvQ_vPbu4E1cxGQTaAzQyCvqQYmJu9i3_glk5kWewug618zEEg/w640-h504/oasrcu2.png" width="640" /></span></a></div><span style="font-family: helvetica;">Go with default selection 'Create Repository' and 'System Load and Product Load' then click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-87BzlcNYny9B_RxJpaPX1YKjbOlzEjG8llE_4XWk-oKEnZpjSU3APHoLzibUFwkY-7D2eR0ITmHOHGtmqd64O7RMK8cHap9g-8K8SmVG_DlxuT50n2pbiYyYYfOjBXkfUtgTMWGgCe8/s802/oasrcu3.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-87BzlcNYny9B_RxJpaPX1YKjbOlzEjG8llE_4XWk-oKEnZpjSU3APHoLzibUFwkY-7D2eR0ITmHOHGtmqd64O7RMK8cHap9g-8K8SmVG_DlxuT50n2pbiYyYYfOjBXkfUtgTMWGgCe8/w640-h504/oasrcu3.png" width="640" /></span></a></div><span style="font-family: helvetica;">Enter all your parameters with step3 below</span></div><div><span style="font-family: helvetica;">Host Name: Bose</span></div><div><span style="font-family: helvetica;">Port: 1521</span></div><div><span style="font-family: helvetica;">Service: ORCLPDB</span></div><div><span style="font-family: helvetica;">User Name: Sys</span></div><div><span style="font-family: helvetica;">Password: Admin123</span></div><div><span style="font-family: helvetica;">Role: SYSDBA<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibJpGJa5YWiDzR8Wh8bEgVW-uz8Yl28WzThBY_W6f9G6Sw1ow5pI1ipjtYgsGPlA5v61XG5Hdz8oCALZ_a2jBr5A-65HtvRMKpGYKTCSBVlNdB8q4qLvqvnCzSQqPRpS06hXXUIgjRZTU/s802/4.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibJpGJa5YWiDzR8Wh8bEgVW-uz8Yl28WzThBY_W6f9G6Sw1ow5pI1ipjtYgsGPlA5v61XG5Hdz8oCALZ_a2jBr5A-65HtvRMKpGYKTCSBVlNdB8q4qLvqvnCzSQqPRpS06hXXUIgjRZTU/w640-h504/4.png" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">Checking RCU Prerequisites. Just click 'OK' once it is done.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgharOA41AA5JI6DM2ECPHajUWbSNFtiw2UkIbEzsoqa1l2nG1PjtYO39jNqFtuGBKKGDr5AKh0ozvr6LUBF4dIxspbK1TOtryGs6iFOlc6-HYJut2dTlHWv12ChQx_HRehEU4yuKTgNDw/s528/oasrcu5.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="198" data-original-width="528" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgharOA41AA5JI6DM2ECPHajUWbSNFtiw2UkIbEzsoqa1l2nG1PjtYO39jNqFtuGBKKGDr5AKh0ozvr6LUBF4dIxspbK1TOtryGs6iFOlc6-HYJut2dTlHWv12ChQx_HRehEU4yuKTgNDw/w640-h240/oasrcu5.png" width="640" /></span></a></div><span style="font-family: helvetica;">We could name prefix of all the RCU accounts. I have select as DEV as a prefix for all my RCU schemas.</span></div><div><span style="font-family: helvetica;">Don't forget to select 'Oracle Business Intelligence' with the below step<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtNs1vG8a9xEY1eCs5F5PzwreOFwZf_aKmlgCvOueDPXb18pB_LUEP69YH5qvYcV3PQinZbKU81tV3r87t09N5y7Pr4f6V2MURcvUCfuuHfFMneYBl0BRqG8-aMd1IfULvw2phaQxVo34/s802/oasrcu6.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtNs1vG8a9xEY1eCs5F5PzwreOFwZf_aKmlgCvOueDPXb18pB_LUEP69YH5qvYcV3PQinZbKU81tV3r87t09N5y7Pr4f6V2MURcvUCfuuHfFMneYBl0BRqG8-aMd1IfULvw2phaQxVo34/w640-h504/oasrcu6.png" width="640" /></span></a></div><span style="font-family: helvetica;">Running Prerequisites for all the schemas. Just click 'OK' once it is done.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRctt9kusovrlOvmbdRM6QkgraIAGCMcMYWoTUAsocrIbMDWk3NKsoBiY4FkBqlD3PHmQB1Gp6aV52oICqJofcWQCFZ_2MKQB-SroJ9DWjfM5isbje5jWmW6rcd3clzO4X2Qgzv_9AIk8/s528/oasrcu7.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="297" data-original-width="528" height="360" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRctt9kusovrlOvmbdRM6QkgraIAGCMcMYWoTUAsocrIbMDWk3NKsoBiY4FkBqlD3PHmQB1Gp6aV52oICqJofcWQCFZ_2MKQB-SroJ9DWjfM5isbje5jWmW6rcd3clzO4X2Qgzv_9AIk8/w640-h360/oasrcu7.png" width="640" /></span></a></div><span style="font-family: helvetica;">Type Password that you would like keep for all your RCU Schemas and click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJ9eEU8CyFYDGHJ9hawxF6877BZW0M7fST5npd53VMxKEuz-nR4ZgIuYF7u1wF9LbH0PVvZLLbyDk0KqOzkcWSs9Q3jbEhHRieb9lcKTGDxvJ17WnPIOsZ5OcHuRSmE8Ao5GoJ7a1gS4M/s802/oasrcu8.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJ9eEU8CyFYDGHJ9hawxF6877BZW0M7fST5npd53VMxKEuz-nR4ZgIuYF7u1wF9LbH0PVvZLLbyDk0KqOzkcWSs9Q3jbEhHRieb9lcKTGDxvJ17WnPIOsZ5OcHuRSmE8Ao5GoJ7a1gS4M/w640-h504/oasrcu8.png" width="640" /></span></a></div><span style="font-family: helvetica;">It will show all the schema, tablespace and temp tablespace name that is going to be created. Just click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7TAvvIhsx62PZz3ExgkSmWkT2qPytJwzFlL5UFmd4ymChAosxN6U9kb0EwpcqElUufvwwqYpsYeXZ0O_r7vG7Der53wvhOy9pySnEzxaB1R0ctO6USm7-QWq9j7vJ3bPOixiv6SVN5Og/s802/oasrcu9.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7TAvvIhsx62PZz3ExgkSmWkT2qPytJwzFlL5UFmd4ymChAosxN6U9kb0EwpcqElUufvwwqYpsYeXZ0O_r7vG7Der53wvhOy9pySnEzxaB1R0ctO6USm7-QWq9j7vJ3bPOixiv6SVN5Og/w640-h504/oasrcu9.png" width="640" /></span></a></div><span style="font-family: helvetica;">Just click 'OK' with the confirmation window.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXwT5whV4sepAibtSMgtsfNipTgNAlT4cFsm04tbzUJYrq9EQzwS-TJzk-1Z3tVCaiszxL2_lizovb2Zdy5lyZobnygYfxId8L1kxNMC6-RdqjMjixEQumi769MeigFpdzSLLhn6vpex8/s333/oasrcu10.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="189" data-original-width="333" height="228" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXwT5whV4sepAibtSMgtsfNipTgNAlT4cFsm04tbzUJYrq9EQzwS-TJzk-1Z3tVCaiszxL2_lizovb2Zdy5lyZobnygYfxId8L1kxNMC6-RdqjMjixEQumi769MeigFpdzSLLhn6vpex8/w400-h228/oasrcu10.png" width="400" /></span></a></div><span style="font-family: helvetica;">Creating Tablespaces. Just click "OK' once it is done.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSpSAS2_JDGyFP4VlPxE1VtGswStqk_27EOjNH4TO7v5T8h5ffDRSVFG_GcVcUxbpNqbufmWT-lSrZNpCvYuuAx_eQ6KzIix2_cXccuDrDYOeMk8LKIFZYoeyRq45gWSF-ZsI6h7TcTNQ/s528/oasrcu11.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="195" data-original-width="528" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhSpSAS2_JDGyFP4VlPxE1VtGswStqk_27EOjNH4TO7v5T8h5ffDRSVFG_GcVcUxbpNqbufmWT-lSrZNpCvYuuAx_eQ6KzIix2_cXccuDrDYOeMk8LKIFZYoeyRq45gWSF-ZsI6h7TcTNQ/w400-h148/oasrcu11.png" width="400" /></span></a></div><span style="font-family: helvetica;">Step 7 is the actual step where it is going to create all the schemas. Click 'Create' with the below step.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje5MHLMPyfjvcdNu2w4N3GxMuMBQV9aNOhO63ZoY57vhvJVDx_lnmivFGvfZgcJAu5DY-q-NCfwp5CNoynn4Q2P1B5bDJlOSd36xMiH5AWTgcKmSohlfsic433ZLYGKDffgFavEWS74so/s802/oasrcu12.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje5MHLMPyfjvcdNu2w4N3GxMuMBQV9aNOhO63ZoY57vhvJVDx_lnmivFGvfZgcJAu5DY-q-NCfwp5CNoynn4Q2P1B5bDJlOSd36xMiH5AWTgcKmSohlfsic433ZLYGKDffgFavEWS74so/w640-h504/oasrcu12.png" width="640" /></span></a></div><span style="font-family: helvetica;">Once we clicked 'Create' with the above step, it will start creating and runs the below window.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFzTNAgp7fWmrzcZTQOdlRnWPH7Stu978fK0Zr0vJtV1BKxLirSIdRTsLWQtxaPKCPcwrd7c4HOF3JWdToiunDi4FL0Mx8ihuyBuVpUvQFMQK4c6u-VdEoEhUuky9jdMdK6sqGjRoP2Fg/s528/oasrcu13.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="317" data-original-width="528" height="384" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFzTNAgp7fWmrzcZTQOdlRnWPH7Stu978fK0Zr0vJtV1BKxLirSIdRTsLWQtxaPKCPcwrd7c4HOF3JWdToiunDi4FL0Mx8ihuyBuVpUvQFMQK4c6u-VdEoEhUuky9jdMdK6sqGjRoP2Fg/w640-h384/oasrcu13.png" width="640" /></span></a></div><span style="font-family: helvetica;">Once it is created successfully click 'Close' to complete the RCU Creation.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6HGy9G62AHTh1JZqHgZovhMSFHV5xvq2Lo99o0Qu5rGZsf3lHsxBkxfVmybgKsIzVc9-jZAQ4CDcB1XQfT7HAulwkx9Dw4d5qec9lVOeV4l4RAGTMNbMqQNzxsIZYybd-7keux6z7xdc/s802/oasrcu14.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="632" data-original-width="802" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6HGy9G62AHTh1JZqHgZovhMSFHV5xvq2Lo99o0Qu5rGZsf3lHsxBkxfVmybgKsIzVc9-jZAQ4CDcB1XQfT7HAulwkx9Dw4d5qec9lVOeV4l4RAGTMNbMqQNzxsIZYybd-7keux6z7xdc/w640-h504/oasrcu14.png" width="640" /></span></a></div><span style="font-family: helvetica;"><br /><span style="color: #2b00fe;"><b>5. OAS Configuration</b></span></span></div><div><b><span style="color: #2b00fe; font-family: helvetica;"><br /></span></b></div><div><span style="font-family: helvetica;">In command prompt, Go to fusion middleware bi/bin directory to run the OAS configuration.</span></div><div><span style="font-family: helvetica;">cd D:OAS55\bi\bin</span></div><div><span style="font-family: helvetica;">D:OAS55\bi\bin>config.cmd<br /></span><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhucn-xIcxQGy0hytmdATTeMYNb49LWx8pxq0mnVdzYau6vYsAhyphenhyphenxOSerQjLDBORTVkwmHfAuJFr-U2OpmiiLe-pu_XFw-2SgU_RtjLrz7ajF8w44rV48lLkurle61nw13aa17xNXNVL7I/s979/1.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="531" data-original-width="979" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhucn-xIcxQGy0hytmdATTeMYNb49LWx8pxq0mnVdzYau6vYsAhyphenhyphenxOSerQjLDBORTVkwmHfAuJFr-U2OpmiiLe-pu_XFw-2SgU_RtjLrz7ajF8w44rV48lLkurle61nw13aa17xNXNVL7I/w640-h348/1.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">Just click 'Next' with the first step of OAS Configuration.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfyoKokSaR-0mjAoLy4WSavSNZO0792UtEYISeDlWXB0ee_aqwWXqgEkbg3yRwQaak4ULdEd6OQU5xlcnmufgtJDwzDr_bawgc-g7SJNk5IBmxnrRr_jaovx2TUkBgJAguas_H1mbpVIE/s786/oasconfig2.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfyoKokSaR-0mjAoLy4WSavSNZO0792UtEYISeDlWXB0ee_aqwWXqgEkbg3yRwQaak4ULdEd6OQU5xlcnmufgtJDwzDr_bawgc-g7SJNk5IBmxnrRr_jaovx2TUkBgJAguas_H1mbpVIE/w640-h504/oasconfig2.png" width="640" /></span></a></div><span style="font-family: helvetica;">With the second step, we could keep BI Publisher if we want with our installation otherwise we could uncheck it. I have selected both and clicked 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8Kvf3MopdzZ0dzAbv0G6Cam0k8VN6mCp-ZlvW53YoFnrRQPLz36scn5UKiTKhnjMLGSeaJ8s5PMvlL5SsaYQIzxcgN5Msb-KO2dnfPOjNwXg9pAw-s_a3U3VzzaCGAeG1nUkasOMovnQ/s786/oasconfig3.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8Kvf3MopdzZ0dzAbv0G6Cam0k8VN6mCp-ZlvW53YoFnrRQPLz36scn5UKiTKhnjMLGSeaJ8s5PMvlL5SsaYQIzxcgN5Msb-KO2dnfPOjNwXg9pAw-s_a3U3VzzaCGAeG1nUkasOMovnQ/w640-h504/oasconfig3.png" width="640" /></span></a></div><span style="font-family: helvetica;">It run the system prerequisite check. Just click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUDOoPI3JuVc_iT_cXjVh5MAfTb7DONpwNosVB8gg2_LzX7nzkn51JVLb8L3R-QuiV_XrhRO86KsJ4CFIXs2sJXtlbpteFu6CHDs4R1PjOs1S4e0X8c8BxjA8vt_5rLbp7SBYw2taJp60/s786/oasconfig4.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUDOoPI3JuVc_iT_cXjVh5MAfTb7DONpwNosVB8gg2_LzX7nzkn51JVLb8L3R-QuiV_XrhRO86KsJ4CFIXs2sJXtlbpteFu6CHDs4R1PjOs1S4e0X8c8BxjA8vt_5rLbp7SBYw2taJp60/w640-h504/oasconfig4.png" width="640" /></span></a></div><span style="font-family: helvetica;">With the step4, It will select the domain directory by default. If we want to change, we could click 'Browse' and can change the directory.</span></div><div><span style="font-family: helvetica;">Type the weblogic password and confirm password with this step.</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFmmdpwD5ZOm4Ct0nFWQf9nx2EmtMqZcE8-8gkSPbDgwUqtxXwcfE4uQjT6mMTgll_uwWnnj5tKEnkMZ8jmjA9PJteImr2yYB6GWW5fYAXG4QP3LJynUekXfsJQJOxBOBpqQxnxboGdiI/s786/5.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFmmdpwD5ZOm4Ct0nFWQf9nx2EmtMqZcE8-8gkSPbDgwUqtxXwcfE4uQjT6mMTgll_uwWnnj5tKEnkMZ8jmjA9PJteImr2yYB6GWW5fYAXG4QP3LJynUekXfsJQJOxBOBpqQxnxboGdiI/w640-h504/5.png" width="640" /></a></div><span style="font-family: helvetica;">In Step5, select 'Use existing Schemas' as we have already created all the RCU schemas and enter the details.</span></div><div><span style="font-family: helvetica;">Database Type: Oracle</span></div><div><span style="font-family: helvetica;">Simple connection String: Bose:1521:ORCLPDB ( HostName:Port:Service)</span></div><div><span style="font-family: helvetica;">Prefix: DEV</span></div><div><span style="font-family: helvetica;">Password: Admin123</span></div><div><span style="font-family: helvetica;">After all the details entered, click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5uPr0ZmvDJ2FvADm1Nf1mSqKLMPVryx8qPi0_3g3S-Tg62e2qmXJam1fv4PCRHGONiO1Yd3xFTUFx2aQ45Efglv1pf9FKz87ywnh14kxUfu0O05URcWrQc2blRU_ZhILfTkHuCTgUHjc/s786/6.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj5uPr0ZmvDJ2FvADm1Nf1mSqKLMPVryx8qPi0_3g3S-Tg62e2qmXJam1fv4PCRHGONiO1Yd3xFTUFx2aQ45Efglv1pf9FKz87ywnh14kxUfu0O05URcWrQc2blRU_ZhILfTkHuCTgUHjc/w640-h504/6.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">in Step6, It would select the port range. we could change based on our criteria. I just left with the default port selection and clicked 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCJX2NFJrsiqR2NXnBsqQxyPAcNMMZIDGYMPr-pW2SOQWTFBi_Kd052zyzdB-1qPOd7w_X6dyocH0U4AznR1vPvGRQawW0T9IqNmjZC0isOAgiGqsS1yF_2sNb8CdviolOhUF6AMy68l8/s786/oasconfig7.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCJX2NFJrsiqR2NXnBsqQxyPAcNMMZIDGYMPr-pW2SOQWTFBi_Kd052zyzdB-1qPOd7w_X6dyocH0U4AznR1vPvGRQawW0T9IqNmjZC0isOAgiGqsS1yF_2sNb8CdviolOhUF6AMy68l8/w640-h504/oasconfig7.png" width="640" /></span></a></div><span style="font-family: helvetica;">with step7, we could select the first option to install with sample application. I have selected second option since I want clean installation and clicked 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCz-AmBTRV6ynuYpRMpv2JtaRuLK0QPGAPY278wI5FvK_vgH9Dz8K5bM-oiIicu1eDOOwkki3QzWxy6W532srqdg2dwjgeBw8Sc6ERgeC_RfMmkQ35wSc3GhLgpZYOgcuBpYGGcIpIPuU/s786/oasconfig8.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCz-AmBTRV6ynuYpRMpv2JtaRuLK0QPGAPY278wI5FvK_vgH9Dz8K5bM-oiIicu1eDOOwkki3QzWxy6W532srqdg2dwjgeBw8Sc6ERgeC_RfMmkQ35wSc3GhLgpZYOgcuBpYGGcIpIPuU/w640-h504/oasconfig8.png" width="640" /></span></a></div><span style="font-family: helvetica;">with Step8, we could save response file for future use. and click 'Configure' to start OAS configuration.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0rFCttnaMgACe09ekLkBMI8em97-8l1ZUsMnYR_hi-oo6cLg1nfzgzgopbhX7BZesRq5j4DQZn6IwNzGqXbMO1dIaXjhoxfCUoHLTISn8fw_numuuMcBLFkLqYsBsxL031lBIye_pNlI/s786/9.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0rFCttnaMgACe09ekLkBMI8em97-8l1ZUsMnYR_hi-oo6cLg1nfzgzgopbhX7BZesRq5j4DQZn6IwNzGqXbMO1dIaXjhoxfCUoHLTISn8fw_numuuMcBLFkLqYsBsxL031lBIye_pNlI/w640-h504/9.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><br /></div><span style="font-family: helvetica;">with step9, OAS Configuration will progress. It takes a while to complete the everything. We are good if it is completed 100%<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgu6Q71M9eU-s2dahgyFhQSp1_jxmi6tGoBSqtFcIWiLLe7QwsSzIYkBNcvd_hcdQN1POnAxy0RVbPZ2teL3uQA8mK4iO38JuiDQuHHwTG45VyiLuP4uo4yyoeVCsN7USh1G_78oJ177kQ/s786/oasconfig10.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgu6Q71M9eU-s2dahgyFhQSp1_jxmi6tGoBSqtFcIWiLLe7QwsSzIYkBNcvd_hcdQN1POnAxy0RVbPZ2teL3uQA8mK4iO38JuiDQuHHwTG45VyiLuP4uo4yyoeVCsN7USh1G_78oJ177kQ/w640-h504/oasconfig10.png" width="640" /></span></a></div><span style="font-family: helvetica;">Completed 100% successfully with the configuration.</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjR4l4Ru27y4OqtEaLJct44LamKCDxEO6lAs9NCbW-ktvEbrSS6n9aDH7fayYQjvzU9mtlSPl0t6sdlhjFGwUtU2XMD0bYSL4IE1nPSdvpUmlJjU3MjMeK3gNlfME-CWfUytW2WiuslPyo/s786/oasconfig11.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="618" data-original-width="786" height="504" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjR4l4Ru27y4OqtEaLJct44LamKCDxEO6lAs9NCbW-ktvEbrSS6n9aDH7fayYQjvzU9mtlSPl0t6sdlhjFGwUtU2XMD0bYSL4IE1nPSdvpUmlJjU3MjMeK3gNlfME-CWfUytW2WiuslPyo/w640-h504/oasconfig11.png" width="640" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><span style="font-family: helvetica; text-align: left;">Once it is completed successfully then click 'Next' with the above step to come to last step.</span></div></div><div><span style="font-family: helvetica;"><br /></span></div><div><span style="font-family: helvetica;">Save the log file with the last step which will have all the analytics, em, console URL and other details then click 'Finish' to complete the OAS Configuration.</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8_cM_QbAaJifN-HEB9f4GtEBSsB60Bv6dxz9ZaoD4P8UlUIF0Oj81JgNX4c5MmgwU_hHk9Ppigi3tPNaTs00uukxL2TEt4XL-I7ruN3Z1y-JwfmLtoWWruExAehzc7PFMfGmrqaqBIls/s796/11.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="623" data-original-width="796" height="501" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8_cM_QbAaJifN-HEB9f4GtEBSsB60Bv6dxz9ZaoD4P8UlUIF0Oj81JgNX4c5MmgwU_hHk9Ppigi3tPNaTs00uukxL2TEt4XL-I7ruN3Z1y-JwfmLtoWWruExAehzc7PFMfGmrqaqBIls/w640-h501/11.png" width="640" /></a></div><br /><span style="font-family: helvetica;">EM:</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitzdfaWvXXt7QR2QrzMzeyKJ0F9QAwr05rPa4HQNzdqwoVPxXWMTaP4Rl_LVwHdJU6KJRVOy-aFEgBcVujykyBxSWvVqhyphenhyphenV0umoU0XLz9MbX7iFU2QtO80ctKsVzm0rEksq5aMOudVzbo/s1366/EM.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="728" data-original-width="1366" height="341" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitzdfaWvXXt7QR2QrzMzeyKJ0F9QAwr05rPa4HQNzdqwoVPxXWMTaP4Rl_LVwHdJU6KJRVOy-aFEgBcVujykyBxSWvVqhyphenhyphenV0umoU0XLz9MbX7iFU2QtO80ctKsVzm0rEksq5aMOudVzbo/w640-h341/EM.png" width="640" /></a></div><br /><span style="font-family: helvetica;"><br /></span></div><div><span style="font-family: helvetica;">Console:</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOtT7tLPunM0qVRy8Sbc3e0LElFpyYKiBCuQVziu-JLqy5W8x3B4ExWqxA4Zgb-iXfi9EnSKzKh6xuHr7nA0ohyphenhyphenrI9cS78d4fReT9msjoIP84kXWMm7HY_GijNgaqEEx57Fby8Gb7B-AY/s888/Console.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="518" data-original-width="888" height="374" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOtT7tLPunM0qVRy8Sbc3e0LElFpyYKiBCuQVziu-JLqy5W8x3B4ExWqxA4Zgb-iXfi9EnSKzKh6xuHr7nA0ohyphenhyphenrI9cS78d4fReT9msjoIP84kXWMm7HY_GijNgaqEEx57Fby8Gb7B-AY/w640-h374/Console.png" width="640" /></a></div><br /><span style="font-family: helvetica;">Analytics:</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizeX17HqEqU0Mlq8hRfv_qTc7qhogW0YOo9vkh9M2Xd9QSHZbAvFIRxJDFC6fXC-Qr82dxwaWmw9Wx-XWZwdpaA7ffK-0Rll-2JfPzJrb-wpWR1xmv39m0UCJZKrBaxObFN3Ortp2B4IE/s888/Analytics.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="518" data-original-width="888" height="374" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizeX17HqEqU0Mlq8hRfv_qTc7qhogW0YOo9vkh9M2Xd9QSHZbAvFIRxJDFC6fXC-Qr82dxwaWmw9Wx-XWZwdpaA7ffK-0Rll-2JfPzJrb-wpWR1xmv39m0UCJZKrBaxObFN3Ortp2B4IE/w640-h374/Analytics.png" width="640" /></a></div><p><span style="font-family: helvetica;">Hurray!!!! We have successfully installed OAS 5.5 in windows with the above step. Check OAS Analytics, EM and all the components and Enjoy :)</span></p><p><span style="font-family: helvetica;">Cheers! Bose</span></p></div></div>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com20tag:blogger.com,1999:blog-7620061238917187120.post-787205950211292822020-12-04T21:26:00.010+05:302020-12-10T21:06:15.698+05:30Exporting and Importing BAR file OBIEE 12.2.1.4.x<p class="MsoNormal"><span style="font-family: georgia;">We have an utility to export OBIEE Catalog, RPD, security model and all other relevant objects to be exported into a .bar file and the same could be imported if we have to migrate to any other environment or as a backup. Please follow the below steps for the same.</span></p><p class="MsoNormal">Upto 12.2.1.3, We have export_service_instance and import_service_instance command but 12.2.1.4 those commands are deprecated and introduced exportarchive and importarchive.</p><p class="MsoNormal"><b><span style="color: #2b00fe; font-family: georgia;">Exporting BAR File in OBIEE 12c:</span></b></p><p class="MsoNormal"><b> </b><b style="background-color: white; font-family: Tahoma, sans-serif; font-size: 16px;">***********************************************************</b></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: georgia;">1.
Make sure that the below environment variables are set:</span><span face="Tahoma, sans-serif" style="font-size: 12pt;"><o:p></o:p></span></p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: courier;">BI_PRODUCT_HOME=$ORACLE_HOME/bi<br />
ORACLE_HOME=/obiee12c (where OBIEE installed)<br />
DOMAIN_HOME=/obiee12c/user_projects/domains (Where domain is located)</span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: georgia;">
2. Run the below command with exportarchive.sh</span><span face="Tahoma, sans-serif" style="font-size: 12pt;"><o:p></o:p></span></p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: courier;"><b>Syntax:</b><o:p></o:p></span></p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: courier;">[DOMAIN_HOME]/bitools/bin/exportarchive.sh
ssi <Bar file name>.bar encryptionpassword=<password><o:p></o:p></span></p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: courier;"><b>Example:</b></span></p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: courier;">[DOMAIN_HOME]/bitools/bin/exporarchive.sh
ssi /obiee12c/backup/obitest.bar encryptionpassword='Admin123'</span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="color: #2b00fe; font-family: georgia;"><b>Note: </b></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: georgia;">Encryption password is optional. If you are chosen with password, you have to use the same while importing</span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><b><span style="color: #2b00fe; font-family: georgia;">Importing
BAR File in OBIEE 12c:</span></b><span face="Tahoma, sans-serif" style="font-size: 12pt;"><o:p></o:p></span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><b> </b><b style="font-family: Tahoma, sans-serif; font-size: 16px;">***********************************************************</b></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: georgia;">The import_bar.sh
|. cmd command is deprecated in OBI 12.2.1.4. </span></p><p class="MsoNormal" style="background: white; line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: georgia;">With
12.2.1.4, use the importarchive.sh (Linux) | importarchive.cmd (for windows) command.</span></p><p class="MsoNormal" style="background: white; line-height: normal; margin-bottom: 12pt; mso-margin-top-alt: auto;"><span style="font-family: georgia;">
You may use the -h switch for syntax</span><span face="Tahoma, sans-serif" style="font-size: 12pt;"><o:p></o:p></span></p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: "Courier New";">[DOMAIN_HOME]</span><span style="font-family: "Courier New";">/bi/bitools/bin/importarchive.sh -h</span><span style="font-family: "Courier New"; font-size: 10pt;"><br /></span></p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: courier;">USAGE : <service instance key>
<location of bar file to import> [nodatamodel] [nocontent]
[noauthorization] [nodatasets] [nosearch] [noaction]
[encryptionpassword=<encryption password for connections>]<br />
Description
: Import bar as a service instance<br />
Mandatory Arguments : service instance key
and location of bar file<br />
Optional Arguments : exclude list of
values:nodatamodel nocontent <span> </span><span> </span><span> </span><span> </span><span> </span><span> </span>noauthorization nodatasets nosearch<br /> nodatamodel : Do not import RPD
metadata content<br />
nocontent : Do not import
WEBCAT metadata content<br />
noauthorization : Do not import JAZN metadata content<br />
nodatasets : Do not import DSS
metadata content<br />
nosearch : Do not
import Search metadata content<br />
noaction : Do not
import Action metadata content<br />
encryptionpassword : Encryption password for connections if
any<span style="background-color: transparent; text-align: justify; text-indent: 0.5in;"> </span></span></p><p style="background: white;"><b><span style="font-family: courier;">Syntax:</span></b></p><p style="background: white;"><span class="kmfixedwidthfont"><span style="background-color: #e0eaf1; font-family: courier;">./importarchive.sh ssi </span><span style="background-color: #e0eaf1; font-family: courier;">/obiee12c/backup/obitest.bar</span><span style="background-color: #e0eaf1; font-family: courier;"> <span> </span><span> </span><span> </span><span> </span> encryptionpassword=<password> </span></span></p><p style="background: white;">
</p><p class="MsoNormal" style="background: rgb(224, 234, 241); line-height: normal; margin-bottom: 0in;"><span style="font-family: courier;"><b style="background-color: white; font-family: "Times New Roman";"><span style="font-family: courier;">Example: <span> </span></span></b></span><span style="font-family: courier;">./importarchive.sh ssi /obiee12c/backup/obitest.bar encryptionpassword=Admin123</span></p><p style="background: white;"><span class="kmfixedwidthfont"><span style="font-family: georgia;">Cheers!</span></span></p><p style="background: white;"><span class="kmfixedwidthfont"><span style="font-family: georgia;">Bose</span></span></p><p></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com10tag:blogger.com,1999:blog-7620061238917187120.post-43661444531980586892020-10-25T22:12:00.009+05:302020-12-20T22:53:07.293+05:30AWS RDS Oracle Frequently used SQL Queries<p><span style="font-family: georgia;"> Recently I came across working on Amazon Oracle RDS database where I have to migrate the in-place oracle database to Amazon RDS. Here is my learning from that implementation of frequently used queries in Oracle / Amazon RDS.</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>1. Getting all the tablespace file from database</b></span></p><p><span><span style="font-family: georgia;"> </span><span style="font-family: courier;">select tablespace_name, bytes from dba_data_files;</span></span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>2. Getting long running job status from database</b></span></p><p><span style="font-family: courier;"><span> </span>SELECT SID, SERIAL#, OPNAME, CONTEXT, SOFAR, </span></p><p><span style="font-family: courier;"> <span> </span>TOTALWORK,ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" </span></p><p><span style="font-family: courier;"> <span> </span>FROM V$SESSION_LONGOPS </span></p><p><span style="font-family: courier;"> <span> </span>WHERE OPNAME NOT LIKE '%aggregate%' </span></p><p><span style="font-family: courier;"> AND TOTALWORK != 0 </span></p><p><span style="font-family: courier;"> AND SOFAR <> TOTALWORK;</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b> 3. How to get all the files from a directory?</b></span></p><p><span style="font-family: courier;"><span>select * from table </span><span>(rdsadmin.rds_file_util.listdir(p_directory => 'DATA_PUMP_DIR'));</span></span></p><p><span style="font-family: georgia;"><span style="color: #2b00fe;"><b>4. Getting details from import Log files </b> </span> </span></p><p><span><span><span style="font-family: georgia;"> </span><span style="font-family: courier;"> </span></span><span style="font-family: courier;">select * from table </span></span><span style="font-family: courier;">(rdsadmin.rds_file_util.read_text_file(</span></p><p><span style="font-family: courier;"> <span> </span>p_directory => 'DATA_PUMP_DIR',</span></p><p><span style="font-family: courier;"> p_filename => 'abc.log'));</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>5. Removing a file from a directory</b></span></p><p><span><span style="font-family: georgia;"> </span><span style="font-family: courier;">exec utl_file.fremove('DATA_PUMP_DIR','IMPORT.LOG');</span></span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>6. How to kill a job in RDS Oracle</b></span></p><p><span><span style="font-family: courier;">begin</span></span></p><p><span style="font-family: courier;">rdsadmin.rdsadmin_util.kill(sid => sid, serial => serial_number);</span></p><p><span style="font-family: courier;">end;</span></p><p><span style="font-family: courier;">/</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>7. Providing Grant issues</b></span></p><p><span style="font-family: courier;"><span> </span>GRANT EXEMPT ACCESS POLICY TO "SYSTEM"</span></p><p><span style="font-family: courier;"><span> </span>GRANT GRANT ANY ROLE TO "SYSTEM" with admin option; </span></p><p><span style="font-family: courier;"><span> </span>GRANT DEBUG ANY PROCEDURE TO "HR"</span></p><p><span style="font-family: courier;"><span> </span>GRANT CREATE VIEW TO "HR"</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>7. Granting Permissions to SYS Objects in AWS RDS</b></span></p><p><span style="font-family: courier;">begin</span></p><p><span style="font-family: courier;">rdsadmin.rdsadmin_util.grant_sys_object(</span><span style="font-family: courier;">p_obj_name => 'V_$SESSION',</span><span style="font-family: courier;">p_grantee => 'HR',</span><span style="font-family: courier;">p_privilege => 'SELECT');</span></p><p><span style="font-family: courier;">end;</span></p><p><span style="font-family: courier;">/</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>8. Exporting a Schema from a database in AWS RDS / Oracle</b></span></p><p><span style="font-family: georgia;">================================================================</span></p><p><span style="font-family: courier;">DECLARE</span></p><p><span style="font-family: courier;">hdnl NUMBER;</span></p><p><span style="font-family: courier;">BEGIN</span></p><p><span style="font-family: courier;">hdnl := DBMS_DATAPUMP.OPEN( operation => 'EXPORT', job_mode => 'SCHEMA', job_name=>null);</span></p><p><span style="font-family: courier;">DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'ABC.dmp', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_dump_file);</span></p><p><span style="font-family: courier;">DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'ABC.log', directory => 'DATA_PUMP_DIR', filetype => dbms_datapump.ku$_file_type_log_file);</span></p><p><span style="font-family: courier;">DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''ABC'')');</span></p><p><span style="font-family: courier;">DBMS_DATAPUMP.START_JOB(hdnl);</span></p><p><span style="font-family: courier;">END;</span></p><p><span style="font-family: courier;">/</span></p><p><span style="font-family: georgia;">================================================================</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>9. Getting number of tables from a database</b></span></p><p><span style="font-family: courier;">select count(*) from all_objects where object_type = 'TABLE';</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>10. How to drop a AQ Tables:</b></span></p><p><span style="font-family: courier;">EXEC dbms_aqadm.drop_queue_table ( queue_table => </span><span style="font-family: courier;">'HR.AQ$_HR_EMP_SQ_I',force=>true);</span></p><div><span style="color: #2b00fe; font-family: georgia;"><br /></span></div><div><div><span style="color: #2b00fe; font-family: georgia;"><b>11. How to copy dump files from s3 bucket to database</b></span></div><div><span style="font-family: georgia;"><br /></span></div><div><span><span style="font-family: courier;">SELECT rdsadmin.rdsadmin_s3_tasks.download_from_s3(</span></span></div><div><span style="font-family: courier;">p_bucket_name => 'mys3bucketname', </span></div><div><span style="font-family: courier;">p_s3_prefix => 'db', </span></div><div><span style="font-family: courier;">p_directory_name => 'DATA_PUMP_DIR') </span></div><div><span style="font-family: courier;">AS TASK_ID FROM DUAL; </span></div></div><div><span style="font-family: georgia;"><br /></span></div><div><div><span style="color: #2b00fe; font-family: georgia;"><b>12. How to get the query of any view or table from a schema:</b></span></div><div><span style="font-family: georgia;"><br /></span></div><div><span style="font-family: courier;"><b>syntax:</b></span></div><div><span style="font-family: courier;">select dbms_metadata.get_ddl('object_type','object_name','schema nme') from dual;</span></div><div><span style="font-family: courier;"><b>e.g:</b></span></div><div><span style="font-family: courier;">select dbms_metadata.get_ddl('VIEW','EMPLOYEE','HR') from dual;</span></div></div><div><span style="font-family: georgia;"><br /></span></div><div><div><span style="color: #2b00fe; font-family: georgia;"><b>13. How to know when is an object created</b></span></div><div><b style="font-family: courier;">syntax:</b></div><div><span style="font-family: courier;">SELECT created FROM dba_objects WHERE object_name = 'object_name' <span> </span>AND owner = <span> </span>'schema_name' AND object_type = 'object_type';</span></div><div><span style="font-family: courier;"><br /></span></div><div><span style="font-family: courier;"><b>e.g:</b></span></div><div><span style="font-family: courier;">SELECT created FROM dba_objects WHERE object_name = <span> </span><span> </span><span> </span><span> </span>'EMPLOYEE' </span><span style="font-family: courier;">AND owner = </span><span style="font-family: courier;"> </span><span style="font-family: courier;">'APPS' AND object_type = 'VIEW';</span></div></div><div><span style="font-family: georgia;"><b><br /></b></span></div><div><span style="color: #2b00fe; font-family: georgia;"><b>14. checking data dumping directory to check the dump files</b></span></div><p class="MsoNormal"><span style="font-family: georgia;"><o:p></o:p></span></p><div><span><span><span style="font-family: georgia;"> </span><span style="font-family: courier;"> </span></span><span style="font-family: courier;"><span> </span>select * from <span> </span><span> </span><span> </span><span> </span></span></span></div><div><span><span style="font-family: courier;"><span> </span>table(RDSADMIN.RDS_FILE_UTIL.LISTDIR('DATA_PUMP_DIR')) order <span> </span><span> <span> </span></span>by mtime; </span></span></div><p class="MsoNormal"><span style="font-family: georgia;"><o:p></o:p></span></p><div><span style="color: #2b00fe; font-family: georgia;"><b>15. Creating Tablespaces</b></span></div>
<p class="MsoNormal"><span><span><span style="font-family: georgia;"> </span><span style="font-family: courier;"> </span></span><span style="font-family: courier;">create tablespace TEMP1 datafile size 5G autoextend on
maxsize 10G;</span><span style="font-family: georgia;"><o:p></o:p></span></span></p><p class="MsoNormal"><span style="color: #2b00fe; font-family: georgia;"><b>16. creating a database in Oracle or Amazon RDS database</b></span></p><p class="MsoNormal"><span style="font-family: courier;"><b>Sample Syntax:</b></span></p><p class="MsoNormal"><span style="font-family: courier;">create user schema_1 identified by <password>;</span></p><p class="MsoNormal"><span style="font-family: courier;">grant create session, resource to schema_1;</span></p><p class="MsoNormal"><span style="font-family: courier;"></span></p><p class="MsoNormal"></p><p class="MsoNormal"><span style="font-family: courier;"><o:p></o:p></span></p><p></p><p class="MsoNormal"><span style="font-family: courier;"></span></p><p class="MsoNormal"><span style="font-family: courier;">alter user schema_1 quota 100M on users;</span></p><p class="MsoNormal"><b style="font-family: courier;">Example:</b></p><p class="MsoNormal"><span style="font-family: courier;">CREATE USER HR IDENTIFIED BY HR<o:p></o:p></span></p><p class="MsoNormal"><span style="font-family: courier;">DEFAULT TABLESPACE
USERS<o:p></o:p></span></p><p class="MsoNormal"><span style="font-family: courier;">TEMPORARY TABLESPACE
TEMP<o:p></o:p></span></p><p class="MsoNormal"><span style="font-family: courier;">QUOTA UNLIMITED ON
USERS;<o:p></o:p></span></p><p class="MsoNormal"><span style="font-family: courier;">GRANT CREATE SESSION, CREATE TABLE to HR;</span></p><p class="MsoNormal"><span style="color: #2b00fe; font-family: georgia;"><b>17. Importing Dump file in Amazon RDS</b></span></p><p class="MsoNormal"><span style="font-family: georgia;">Now we could start running the import process with the following command:</span></p><p class="MsoNormal"><span style="font-family: georgia;">================================================================</span></p><p class="MsoNormal"><span style="font-family: courier;">DECLARE</span></p><p class="MsoNormal"><span style="font-family: courier;">hdnl NUMBER;</span></p><p class="MsoNormal"><span style="font-family: courier;">BEGIN</span></p><p class="MsoNormal"><span style="font-family: courier;">hdnl := DBMS_DATAPUMP.OPEN( operation => 'IMPORT', job_mode => <span> </span><span> </span>'SCHEMA',job_name=>null);</span></p><p class="MsoNormal"><span style="font-family: courier;">DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => 'HR.dmp', <span> </span><span> </span>directory => 'DATA_PUMP_DIR', filetype => </span><span style="font-family: courier;">dbms_datapump.ku$_file_type_dump_file);</span></p><p class="MsoNormal"><span style="font-family: courier;">DBMS_DATAPUMP.ADD_FILE( handle => hdnl, filename => <span> <span> </span></span></span><span style="font-family: courier;">'HR.log', </span><span style="font-family: courier;">directory => </span><span style="font-family: courier;">'</span><span style="font-family: courier;">DATA_PUMP_DIR', filetype => <span> </span></span><span style="font-family: courier;">dbms_datapump.ku$_file_type_log_file);</span></p><p class="MsoNormal"><span style="font-family: courier;">DBMS_DATAPUMP.METADATA_FILTER(hdnl,'SCHEMA_EXPR','IN (''HR'')');</span></p><p class="MsoNormal"><span style="font-family: courier;">DBMS_DATAPUMP.START_JOB(hdnl);</span></p><p class="MsoNormal"><span style="font-family: courier;"><span> E</span>ND;</span></p><p class="MsoNormal"><span style="font-family: courier;"></span></p><p class="MsoNormal"><span style="font-family: courier;"><span> </span>/</span></p><p class="MsoNormal"><span style="font-family: georgia;">================================================================</span></p><p class="MsoNormal"><span style="color: #2b00fe; font-family: georgia;"><b>18. How to copy your dump files to S3 bucket from Linux Server</b></span></p><div><span><b><span style="font-family: courier;">syntax:</span></b><span style="font-family: courier;"> </span></span></div><div><span style="font-family: courier; font-size: medium;">aws s3 cp /data/dumps/HR.dmp s3://s3-bucket-name</span></div><div><br /></div>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com8tag:blogger.com,1999:blog-7620061238917187120.post-62666261804398053362020-10-21T14:30:00.008+05:302020-10-21T14:30:56.312+05:30Log files Location/directory in OBIEE 12c / OAS<p style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px; margin: 0px 0px 1em;"><b>OBIEE 12c Log Locations:</b></p><p style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px; margin: 0px 0px 1em;">First We should know our fusion middleware home or oracle BI Home directory location and then search in the relevant folder/directory for logs.</p><ul style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px; margin: 0px 0px 1em;"><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">AdminServer logs</strong> – <FMW_HOME>/user_projects/domains/bi/servers/AdminServer/logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">bi_server1 logs </strong>– <FMW_HOME>/user_projects/domains/bi/servers/bi_server1/logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Presentation Server logs</strong> – <FMW_HOME>/user_projects/domains/bi/servers/obips1/logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">JavaHost logs</strong> – <FMW_HOME>/user_projects/domains/bi/servers/obijh1/logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Cluster Components logs</strong> – <FMW_HOME>/user_projects/domains/bi/servers/obiccs1/logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Scheduler Server logs</strong> – <FMW_HOME>/user_projects/domains/bi/servers/obisch1/logs</li></ul><p>If it is 2 Node Servers, then </p><p><strong style="box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px;">Presentation Server logs 2nd Node </strong><span style="color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px;">– <FMW_HOME>/user_projects/domains/bi/servers/obips2/logs</span></p><p><strong style="box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px;">Scheduler Server logs For 2nd Node</strong><span style="color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px;">– <FMW_HOME>/user_projects/domains/bi/servers/obisch2/logs</span></p><p><b>OBIEE 11g Locations:</b></p><ul style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px; margin: 0px 0px 1em;"><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Upgrade logs</strong> – Middleware\Oracle_BI1\upgrade\logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Admin Server logs </strong>– <FMW_HOME>\user_projects\domains\bifoundation_domain\servers\AdminServer\logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Managed Server logs</strong> – <FMW_HOME>\user_projects\domains\bifoundation_domain\servers\bi_server1\logs</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">BI Server logs</strong> – <FMW_HOME>\instances\instance1\diagnostics\logs\OracleBIServerComponent\coreapplication_obis1</li><li style="box-sizing: border-box;"><strong style="box-sizing: border-box;">Presentation Server logs </strong>– <FMW_HOME>\instances\instance1\diagnostics\logs\OracleBIPresentationServicesComponent\coreapplication_obips1</li></ul><p style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px; margin: 0px 0px 1em;"><br /></p><p style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px; margin: 0px 0px 1em;">Cheers!</p><p style="background-color: white; box-sizing: border-box; color: #333333; font-family: "Open Sans", sans-serif; font-size: 14px; margin: 0px 0px 1em;">Bose</p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com4tag:blogger.com,1999:blog-7620061238917187120.post-59656846269801978782020-10-11T21:59:00.000+05:302021-01-12T18:25:25.338+05:30[nQSError: 13042] Repository password is wrong in OBIEE 12c<p>Issue;</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">On Oracle Business Intelligence Enterprise Edition (OBIEE) 12c, Below error occurs while uploading RPD in OBIEE 12c environment, even though RPD password is correct and can be opened with same password in offline mode.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><b><em>[nQSError: 13042] Repository password is wrong</em></b></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Issue 1. After uploading the RPD, if we download and try to open offline, we will get the same issue of 'Repository Password is Wrong'</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Issue 2. If we are validating with validaterpd.sh command then also, we will get the same issue and will not be able to open the RPD.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Issue 3. obieerpdpwdchange utility also would not help in resetting or opening the rpd.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Issue 4. We would be able to open the RPD online but the same wouldnot be able to open if we download and try to open offline.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><span style="font-size: 14.3px; font-weight: 700; text-align: right;">(Doc ID 2721582.1)</span></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">After uploading new rpd, Unable to open a downloaded rpd in offline mode in admin client tool</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">"Logon Failed" message is displayed and following error shown in the admin log:</p><div class="kmcodeblock" style="background-color: #e0eaf1; border-color: rgb(196, 209, 230); border-style: solid; border-width: 1px; font-family: "Courier New", Courier, monospace; font-size: 11.7px; margin: 5px 0px 0px; overflow: auto; padding: 0.5em;"><span style="font-size: 8pt;">----NQSAdminTool.log -------------------------</span><br /><br /><span style="font-size: 8pt;">[OBIS] [NOTIFICATION:1] Opening call for File=C:\xxx\xxx\xxx.rpd, LogicalName: OfflineRepository</span><br /><span style="font-size: 8pt;">[OBIS] [ERROR:1] [tid: xxx] [nQSError: 13042] Repository password is wrong. [[</span><br /><span style="font-size: 8pt;">file: server\objectmodel\Src\SOPersistRp.cpp; line: 672</span></div><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><b>Cause:</b></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">This issue is due to known internal Bug: <a alt="Bug 29376866 - RFA : WRONG PASSWORD ERROR IN ADMIN TOOL AFTER DOWNLOADRPD" href="https://support.oracle.com/epmos/faces/BugDisplay?parent=DOCUMENT&sourceId=2721582.1&id=29376866" target="_blank" title="Bug 29376866 - RFA : WRONG PASSWORD ERROR IN ADMIN TOOL AFTER DOWNLOADRPD">Bug 29376866</a> - RFA : WRONG PASSWORD ERROR IN ADMIN TOOL AFTER DOWNLOADRPD</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><span style="background-color: #777773; color: white; font-family: Arial, Helvetica, sans-serif; font-size: 16.25px; text-transform: uppercase;"><b>SOLUTION:</b></span></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Follow the steps to fix the issue:</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Step1: Open the RPD in online Mode and save the RPD suing copy as option to have working repository copy.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><br />Step 2: Login to EM->Weblogic Domain->Security->Credentials->oracle.bi.enterprise->metadata.encryption->Edit->password =>update the same password.<br /><br />Step 3: Upload the working version of RPD and then Download.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Step 3: Try opening the RPD in offline mode.</p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;"><br /></p><p style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: small;">Cheers! Bose</p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com1tag:blogger.com,1999:blog-7620061238917187120.post-90215950006959938872020-08-31T23:21:00.001+05:302020-12-24T15:39:22.552+05:30Installing JDK-8u271in Windows<p><span style="font-family: georgia;"> Here is step by step by Guide for JDK Version 271. Download JDK from <b><a href="https://www.oracle.com/java/technologies/javase/javase-jdk8-downloads.html" target="_blank">This Link</a></b></span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjH6b8-wPeYjTnRk91mFEQSnwOSKpTWyDTosOff4-KBBusUKpwnJzIJQfSDwXS_00HZb8kSVuNOf2YZTJfpqPIk0IU34MuKv2NO2U3u9hViQXAJ3n_M8e2az3Ze8GjEsZFbjvp2P4sRaEs/s959/java1.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="316" data-original-width="959" height="210" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjH6b8-wPeYjTnRk91mFEQSnwOSKpTWyDTosOff4-KBBusUKpwnJzIJQfSDwXS_00HZb8kSVuNOf2YZTJfpqPIk0IU34MuKv2NO2U3u9hViQXAJ3n_M8e2az3Ze8GjEsZFbjvp2P4sRaEs/w640-h210/java1.png" width="640" /></span></a></div><p><span style="font-family: georgia;">jdk-8u271-windows-x64.exe file will be downloaded. Just double click the download .exe file to start the Java Installation. When It prompt for permission, just click 'Allow' to start the installation.</span></p><p><span style="font-family: georgia;">Installer will start the Installation with the below screen. Just Click 'Next'</span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFqOKSl5JBOh3cIsR_cipGPQ7aGQJBj4AE7Jnswm4x950ZSlYAkI9yANrtEm3dS5W2ncPWMXBvQfZZ-m4EfOUCRuS_AO8njGFFI836E6HIu9_QLsmAKcOn97l1pjURXMjmUKvzDGYZCSU/s702/java2.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="386" data-original-width="702" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFqOKSl5JBOh3cIsR_cipGPQ7aGQJBj4AE7Jnswm4x950ZSlYAkI9yANrtEm3dS5W2ncPWMXBvQfZZ-m4EfOUCRuS_AO8njGFFI836E6HIu9_QLsmAKcOn97l1pjURXMjmUKvzDGYZCSU/w400-h220/java2.png" width="400" /></span></a></div><div><span style="font-family: georgia;"><br /></span></div><span style="font-family: georgia;">Installer is preparing the installation<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHYWJboGaB1TD2HEy1cbacUaNHpRn0aG9oqOimc9gKQ0krBOh_f6UfkTs-bnsggsh-DK-V91zenECvv0LzvagpuolEuyhnT1h70l81Z6Ube8t475czHLt2cfOgpkLD9Ed-TjtTXIluzMQ/s394/java3.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="149" data-original-width="394" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHYWJboGaB1TD2HEy1cbacUaNHpRn0aG9oqOimc9gKQ0krBOh_f6UfkTs-bnsggsh-DK-V91zenECvv0LzvagpuolEuyhnT1h70l81Z6Ube8t475czHLt2cfOgpkLD9Ed-TjtTXIluzMQ/s320/java3.png" width="320" /></span></a></div><span style="font-family: georgia;">Here is the actual first step of Installation starts. If you are having your own directory to install Java then click 'Change' and choose the directory. Otherwise Just click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB9Y6fOPlU8rEWx7Ny8Oo6RmhOBX9GVNYkVYilgom3X4eVIwd7_eKpJ8hH3v0hReYSoIupNTKjjK7d0NiHGs4QvN5ZoaIDqKC69Kd-y-HeSF8nIYaCHOqvkGJESNLVL7yTisJfhKfcS_k/s500/java4.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="381" data-original-width="500" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiB9Y6fOPlU8rEWx7Ny8Oo6RmhOBX9GVNYkVYilgom3X4eVIwd7_eKpJ8hH3v0hReYSoIupNTKjjK7d0NiHGs4QvN5ZoaIDqKC69Kd-y-HeSF8nIYaCHOqvkGJESNLVL7yTisJfhKfcS_k/w400-h305/java4.png" width="400" /></span></a></div><span style="font-family: georgia;">Then JDK 8 installation is extracting to install<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtuxjpgRlxwzX4oI_MRX-GQA0rwRHS4d858PlASAIOfCjh6rdyvEunJkIzOJXSd4V_3YTtzLhaJ3u7NhELMpPWU-TqtdOPPzv-Ly-F9BoB_faO2eCB4Yl5ykePqOzdJR-SWwHiq7lTLvo/s500/java5.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="381" data-original-width="500" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtuxjpgRlxwzX4oI_MRX-GQA0rwRHS4d858PlASAIOfCjh6rdyvEunJkIzOJXSd4V_3YTtzLhaJ3u7NhELMpPWU-TqtdOPPzv-Ly-F9BoB_faO2eCB4Yl5ykePqOzdJR-SWwHiq7lTLvo/w400-h305/java5.png" width="400" /></span></a></div><span style="font-family: georgia;">With the below screen, Again you could change the destination folder where Java should be installed. If you do not want to change the default folder, then Just click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGH8M_V7U7r5dYvC5p59ILaaz_9EN2o7LlXv1k8WKKUGPs5r6cJupmdpZ9wfczd0ZOVknlf7HYJwooN3Ijp93ThSr57S655PhOXwnciZjCmGXwG0P3xjlDqClBRzBxKBYP4ZvFUJCUaqQ/s702/java6.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="386" data-original-width="702" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGH8M_V7U7r5dYvC5p59ILaaz_9EN2o7LlXv1k8WKKUGPs5r6cJupmdpZ9wfczd0ZOVknlf7HYJwooN3Ijp93ThSr57S655PhOXwnciZjCmGXwG0P3xjlDqClBRzBxKBYP4ZvFUJCUaqQ/w400-h220/java6.png" width="400" /></span></a></div><span style="font-family: georgia;">Installer window will progress and took few few minutes to complete the installation.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyxL1_9iOnnyR2eYmZ84_kj5TPzafs6GGQY1swLsQSKlwOLsza1vrgMMhtVkThUlIxmzg-uzea2C69vu3_3QpOuwlZmKVCPokHf3NCmJXFoMWJCp2uveBhZN8axhpVsPiNpzzBb15Pe3o/s702/java7.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="386" data-original-width="702" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyxL1_9iOnnyR2eYmZ84_kj5TPzafs6GGQY1swLsQSKlwOLsza1vrgMMhtVkThUlIxmzg-uzea2C69vu3_3QpOuwlZmKVCPokHf3NCmJXFoMWJCp2uveBhZN8axhpVsPiNpzzBb15Pe3o/w400-h220/java7.png" width="400" /></span></a></div><span style="font-family: georgia;">Once It is installed successfully, screen will prompt the below screen. Just click 'Close' to complete the installation.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTfrMSOlf6kuOXtgATXmbut0PcLYsC8OWyPMoYNqmtrWvQwJNLAu4GWPU_oLcx1qfLrD8JgDnt9vVpnr2OE7W6yJ7hsFg1Av5AxCFeymQli-MlAOCGwJ1dP4oqqWCOfZvOi0vhv-NVHzM/s500/java8.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="381" data-original-width="500" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTfrMSOlf6kuOXtgATXmbut0PcLYsC8OWyPMoYNqmtrWvQwJNLAu4GWPU_oLcx1qfLrD8JgDnt9vVpnr2OE7W6yJ7hsFg1Av5AxCFeymQli-MlAOCGwJ1dP4oqqWCOfZvOi0vhv-NVHzM/w400-h305/java8.png" width="400" /></span></a></div><p><span style="font-family: georgia;">You can confirm the version installed in our windows by running the "java -version" in command prompt.</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij1dgP71UYtENEqAQCIc3jLpB18DLB-SsLMB_ggyr51m2_HieIvL_n98NPIlN_j9wZfTH9DHe-11OXRCAJ6eVyNPdIvU2QzIsQ0qRQhCx9gq6NkNQrH4UndCH2Tao0cpTavEM00ADobDc/s556/java+version.png" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="212" data-original-width="556" height="153" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEij1dgP71UYtENEqAQCIc3jLpB18DLB-SsLMB_ggyr51m2_HieIvL_n98NPIlN_j9wZfTH9DHe-11OXRCAJ6eVyNPdIvU2QzIsQ0qRQhCx9gq6NkNQrH4UndCH2Tao0cpTavEM00ADobDc/w400-h153/java+version.png" width="400" /></a></div><p></p><p><span style="font-family: georgia;">Cheers!</span></p><p><span style="font-family: georgia;">Bose</span></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-9544170643137179862020-08-06T19:32:00.002+05:302020-08-06T19:32:16.416+05:30OAS (Oracle Analytics Server) and OAC - The Next Gen OBIEE is HereAfter OBIEE 12c release, Oracle is keenly looking for cloud solutions and released OAS and OAC.<div><br /></div><div>OAS is more like a in-place installation OBIEE Version which is available for download and can be installed in in-place servers or cloud server.</div><div><br /></div><div>Otherwise, We could go for Oracle based Cloud version (OAC) of OBIEE.</div><div><br /></div><div>Here is you can download OAS:</div><div><a href="https://www.oracle.com/solutions/business-analytics/analytics-server/analytics-server.html">https://www.oracle.com/solutions/business-analytics/analytics-server/analytics-server.html</a></div><div><br /></div><div>Step by step guide by Rittman-Mead:</div><div><br /></div><div><a href="https://www.rittmanmead.com/blog/2020/02/oracle-analytics-server-step-by-step-installation/">https://www.rittmanmead.com/blog/2020/02/oracle-analytics-server-step-by-step-installation/</a></div><div><br /></div><div>Here is a Oracle Blog for OAS Installation;</div><div><a href="https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/installing-product-software.html#GUID-D5AFD830-8A7D-42CC-8C22-CE68C452CF4A">https://docs.oracle.com/en/middleware/bi/analytics-server/install-config-oas/installing-product-software.html#GUID-D5AFD830-8A7D-42CC-8C22-CE68C452CF4A</a></div><div><br /></div>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com1tag:blogger.com,1999:blog-7620061238917187120.post-447606651130679152020-08-01T19:52:00.001+05:302020-11-17T20:05:21.900+05:30Oracle Business Intelligence Applications (OBIA) 11.1.1.10.3 is available for Download<p><span style="font-family: georgia;">Oracle has released the latest version of OBIA - </span><span style="background-color: white; color: #100f0e; font-family: georgia; text-align: center;">Oracle Business Intelligence (BI) Applications 11.1.1.10.3.</span></p><p><span style="background-color: white; color: #100f0e; font-family: georgia; text-align: center;"><br /></span></p><p><span style="color: #100f0e; font-family: georgia; text-align: center;"><b>What's</b></span><span style="background-color: white; color: #100f0e; font-family: georgia; text-align: center;"><b> New:</b></span></p><p><span style="background-color: white; color: #100f0e; font-family: georgia; text-align: center;">BI Applications with OBIEE 12c</span></p><p><span style="background-color: white; color: #100f0e; font-family: georgia; text-align: center;">ODI 12c</span></p><p>Look <b><a href="https://blogs.oracle.com/proactivesupportepm/obia_1111103">Oracle Blog Here for More Details</a></b></p><p><a href="https://blogs.oracle.com/proactivesupportepm/aw_obia-1111103-technology-upgrade-overview"><b>Upgrade Overview</b></a></p><p>Cheers!</p><p>Bose</p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-86163663983591314862020-08-01T08:18:00.016+05:302020-12-22T09:04:19.488+05:30Oracle Database 12c Step by Step Installation in Windows.<p><span style="font-family: helvetica;">With this post, I am sharing oracle database 12c Release 2 installation in windows. </span><span style="font-family: helvetica;">I have downloaded Oracle Database 12c software which is around 2.8GB from oracle Site.</span></p><p><span style="font-family: helvetica;">File Name: winx64_12201_database</span></p><p><span style="font-family: helvetica;">Extract the software zip file and go to the extracted folder and double click on setup.exe file to start the DB installation.</span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihZAvvxHaPeoGt_tbHSOQBVnywWaEvk17ljwsGCCw5VPwv_eU5nueQg6c5LxnzqMRCZhQAkT2hrbriK2Qf9AQlIuzYbiw0xzovzkI5HUMAXHvZ5_OgD2-8J3YQ8D1lH_oGcBAjXazfH9M/s708/db.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="204" data-original-width="708" height="115" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihZAvvxHaPeoGt_tbHSOQBVnywWaEvk17ljwsGCCw5VPwv_eU5nueQg6c5LxnzqMRCZhQAkT2hrbriK2Qf9AQlIuzYbiw0xzovzkI5HUMAXHvZ5_OgD2-8J3YQ8D1lH_oGcBAjXazfH9M/w400-h115/db.png" width="400" /></span></a></div><p><span style="font-family: helvetica;">Oracle Universal Installer checks the system prerequisite and will start the installation window. </span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGTYOV1dNZOJ7Dg5axehAXhVnNZLDllBmp3bu8_Y7NVnMMojTVEwcvPBUsABQlrd4MrnT4ovGfpM8XHSXLC96gCFTanP3zJ9ydJ8I7QNd2BMspws_DxbCwpOu8blet9J1MDvAmuvKg3j0/s977/0.1.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="200" data-original-width="977" height="132" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGTYOV1dNZOJ7Dg5axehAXhVnNZLDllBmp3bu8_Y7NVnMMojTVEwcvPBUsABQlrd4MrnT4ovGfpM8XHSXLC96gCFTanP3zJ9ydJ8I7QNd2BMspws_DxbCwpOu8blet9J1MDvAmuvKg3j0/w640-h132/0.1.png" width="640" /></span></a></div><div><span style="font-family: helvetica;">Uncheck 'My oracle Support' and click <span style="color: #2b00fe;">'<b>Next</b>'</span><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNOIODdiueRDxpd1M0K1bPJFTsrEHHb7BNkXBeiMGc3VdZ5s_WHRj7RFrBEy3reD8tgMeELV_NM0R3G8_2WS6NswuQRGkH07I565LW7u5y0qwH82M8mdSu9cIxP4eJkd2OUcCfmE4ZvRQ/s786/1.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgNOIODdiueRDxpd1M0K1bPJFTsrEHHb7BNkXBeiMGc3VdZ5s_WHRj7RFrBEy3reD8tgMeELV_NM0R3G8_2WS6NswuQRGkH07I565LW7u5y0qwH82M8mdSu9cIxP4eJkd2OUcCfmE4ZvRQ/w640-h482/1.png" width="640" /></span></a></div><span style="font-family: helvetica;">When it prompts the below window, Click<span style="color: #2b00fe;"> '<b>Yes</b>'</span><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2LXuL3XHgMaurFyW_DxqxLqJa7DB-kaFUr_2vDXF7XYb1EmGGHeujFdux8XN8fzKP3ZZ3rcQrPPKkE4xiJQvZ8894xmY7IGOJhFVfd7HT1ctLLjAmqsUGRKHtFzD2cfjha4isQr87IV4/s512/2.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="190" data-original-width="512" height="149" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg2LXuL3XHgMaurFyW_DxqxLqJa7DB-kaFUr_2vDXF7XYb1EmGGHeujFdux8XN8fzKP3ZZ3rcQrPPKkE4xiJQvZ8894xmY7IGOJhFVfd7HT1ctLLjAmqsUGRKHtFzD2cfjha4isQr87IV4/w400-h149/2.png" width="400" /></span></a></div></div><div><span style="font-family: helvetica;">Select 'Create and configure a database' and click '<b>Next</b>'</span></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnz3KOar_KUOSr6c5AOqzrMRWFQsglgY8IdddhfjNV9q9IYmIkU4gVjLY46YUc5A4CgsnWv6ScSlJo6E9vT2L4hy0skikx-PBAHHyPQ_sLKAjYU8q3O-zS7AbXyKDtY1c0TxQictHvRaY/s786/3.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhnz3KOar_KUOSr6c5AOqzrMRWFQsglgY8IdddhfjNV9q9IYmIkU4gVjLY46YUc5A4CgsnWv6ScSlJo6E9vT2L4hy0skikx-PBAHHyPQ_sLKAjYU8q3O-zS7AbXyKDtY1c0TxQictHvRaY/w640-h482/3.png" width="640" /></span></a></div></div><div><span style="font-family: helvetica;">I have selected 'Server class' and clicked <b><span style="color: #2b00fe;">'Next'.</span></b></span></div><div><span style="font-family: helvetica;">Since I want to check all the feature of this database 12c, I installed with 'Server Class'. We could go with 'Desktop Class' which is light and easy. Server class is heavy and takes 6 GB disk space.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjEx1oDi60UI1WsgJneuMKit7o1d7ibOqJ_XGBRx24qM32pQE1SkM9qJ4Kim5Ua7aW_YaUCySpk_yQpqj9lNLSP6jGKm1A1wus3ZOmmyWucfRhDG79Xyv16Jt9gsslqUMEkZ8Q5Lv8HuI/s786/4.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhjEx1oDi60UI1WsgJneuMKit7o1d7ibOqJ_XGBRx24qM32pQE1SkM9qJ4Kim5Ua7aW_YaUCySpk_yQpqj9lNLSP6jGKm1A1wus3ZOmmyWucfRhDG79Xyv16Jt9gsslqUMEkZ8Q5Lv8HuI/w640-h482/4.png" width="640" /></span></a></div></div><div><span style="font-family: helvetica;">Select 'Single instance database installation' and click<b><span style="color: #2b00fe;"> 'Next'</span></b><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF9EDMNDxx30V_Srk5WxyPQyQQjWRe1-SV1d7AkK3kmj6HUReqt26ZBdIFzraZ2n7vA46VFjF5tk5dh-3ADWYKsJ8Q5X4XuQ-gjv-PEZOt-2RJbuJz9d-6GUd6dc8tHFKZcscZTLNpD5w/s786/5.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF9EDMNDxx30V_Srk5WxyPQyQQjWRe1-SV1d7AkK3kmj6HUReqt26ZBdIFzraZ2n7vA46VFjF5tk5dh-3ADWYKsJ8Q5X4XuQ-gjv-PEZOt-2RJbuJz9d-6GUd6dc8tHFKZcscZTLNpD5w/w640-h482/5.png" width="640" /></span></a></div></div><div><span style="font-family: helvetica;">Select 'Typical Install' and click <b><span style="color: #2b00fe;">'Next'</span></b><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFoqjFBFgKnrUPX-AQimbCKKZlEoJmxL-LqAeGJxhtSNktpb0Sed2fqprYqAUVYVDY6tOmC7zBOKhWvrAU87it1qVxlU1cLE23nYQQySuWprbu-4FKjP9dyVwaOgZN2UxkmOeeoz8Kh2c/s786/6.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFoqjFBFgKnrUPX-AQimbCKKZlEoJmxL-LqAeGJxhtSNktpb0Sed2fqprYqAUVYVDY6tOmC7zBOKhWvrAU87it1qVxlU1cLE23nYQQySuWprbu-4FKjP9dyVwaOgZN2UxkmOeeoz8Kh2c/w640-h482/6.png" width="640" /></span></a></div><span style="font-family: helvetica;">Select the Oracle Base folder if you have your folder to install Oracle DB 12c. I have 'DB12c' in D drive. If we select the base path, all the other path will be loaded automatically.</span></div><div><span style="font-family: helvetica;"><br /></span></div><div><span style="font-family: helvetica;">In this step, enter database password and remember it.</span></div><div><span style="font-family: helvetica;"><br /></span></div><div><span style="font-family: helvetica;">Check 'Create as container Database' and Keep pluggable DB. because pluggable DB is required for all our RCU installation required for OBIEE later.</span></div><div><span style="font-family: helvetica;"><br /></span></div><div><span style="font-family: helvetica;">Finally Click 'Next'<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpB_hOpy5UucvQQL3mEgWNE3Ai0GcCrT_8NGtjR45UotwFUGSS-nfXR4qxk6YUvONnd_wtCzwy5lEWsYCXXu2Ls4IX9-5u_Xbph0VmIBnNr-QFAbXeZtYzJXDWyu-jKhYui3DXacGLAm8/s786/8.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpB_hOpy5UucvQQL3mEgWNE3Ai0GcCrT_8NGtjR45UotwFUGSS-nfXR4qxk6YUvONnd_wtCzwy5lEWsYCXXu2Ls4IX9-5u_Xbph0VmIBnNr-QFAbXeZtYzJXDWyu-jKhYui3DXacGLAm8/w640-h482/8.png" width="640" /></span></a></div><span style="font-family: helvetica;">Installer will run the prerequisite checks..<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-RJ5xMvlc0-AppzT9ik9TV9cjv9Toj4cwe65_uKA5CHNY9Td1cJ-m0H0YjiJe9fUc39YgCIu8Hs7j9xJueryG-Z868zKmULKkspKUA1xdNRL0RSc0ynUljAmmNyNllVoPLSpsgxhQNqU/s786/9.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-RJ5xMvlc0-AppzT9ik9TV9cjv9Toj4cwe65_uKA5CHNY9Td1cJ-m0H0YjiJe9fUc39YgCIu8Hs7j9xJueryG-Z868zKmULKkspKUA1xdNRL0RSc0ynUljAmmNyNllVoPLSpsgxhQNqU/w640-h482/9.png" width="640" /></span></a></div><span style="font-family: helvetica;">With this step, We could save the response file which could be used to silent install for other environments.</span></div><div><span style="font-family: helvetica;">Click <b><span style="color: #2b00fe;">'Install'</span></b><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6hCuQzGeTgC8W6nXZNBMJSgc8M1rPklSoK6G1HvSwDFwmSa95PyCIhRkW7KUWNASoJlVm5ixXuG_2rlXsr0-OYJO7vLqW1bS5blPcLmMzZCq-SkzORLmmbYaYifNRZk_pPXiXZEgG_Gs/s786/10.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6hCuQzGeTgC8W6nXZNBMJSgc8M1rPklSoK6G1HvSwDFwmSa95PyCIhRkW7KUWNASoJlVm5ixXuG_2rlXsr0-OYJO7vLqW1bS5blPcLmMzZCq-SkzORLmmbYaYifNRZk_pPXiXZEgG_Gs/w640-h482/10.png" width="640" /></span></a></div><span style="font-family: helvetica;">It would take some time to complete the installation. <br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDBzWt4oBMuL0ay_BcBy58KMK2PFgWgWaNC1sxfmFWOLunOzK4mOumgiqGuMm6EE3XVHt2J3bTYEHIGrYnMBPnwkP3ElCqMcSN1XCmU4DBtQNHGWyKsb917feU4q5NT1yVh32AE3RvozM/s786/11.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhDBzWt4oBMuL0ay_BcBy58KMK2PFgWgWaNC1sxfmFWOLunOzK4mOumgiqGuMm6EE3XVHt2J3bTYEHIGrYnMBPnwkP3ElCqMcSN1XCmU4DBtQNHGWyKsb917feU4q5NT1yVh32AE3RvozM/w640-h482/11.png" width="640" /></span></a></div><span style="font-family: helvetica;">Oracle DB installation is in progress....<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjc_GymZzPQj5qpA1zySqxoUaGYQkBdTXqUJy0p0y423DCLTHyVeVpBUrejfvRQ8HeiAazTa9EuYZImCanghZrh1e-gN3gLHjVq0qFcdGFdDZ0VA6G39tX9mBStrdWRJx76eHlf_6bmipc/s786/12.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjc_GymZzPQj5qpA1zySqxoUaGYQkBdTXqUJy0p0y423DCLTHyVeVpBUrejfvRQ8HeiAazTa9EuYZImCanghZrh1e-gN3gLHjVq0qFcdGFdDZ0VA6G39tX9mBStrdWRJx76eHlf_6bmipc/w640-h482/12.png" width="640" /></span></a></div><span style="font-family: helvetica;">Oracle DB 12c is successfully installed. Just click <b><span style="color: #2b00fe;">'Close' </span></b>to complete the installation.<br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8RYU1TXynh18d6D1vFmZmtLlaIgMHpdAKhWaNwNNVN8uSXfDLZ2SJB2Fuh2Tx_JUoBnLOlFga6lFYMxm_y3246jQNYJ0oHTQtBovGYqr-W-hUIoK00wrb4dJSt3RrNaf4aGTg4nLtf7s/s786/13.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: helvetica;"><img border="0" data-original-height="593" data-original-width="786" height="482" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8RYU1TXynh18d6D1vFmZmtLlaIgMHpdAKhWaNwNNVN8uSXfDLZ2SJB2Fuh2Tx_JUoBnLOlFga6lFYMxm_y3246jQNYJ0oHTQtBovGYqr-W-hUIoK00wrb4dJSt3RrNaf4aGTg4nLtf7s/w640-h482/13.png" width="640" /></span></a></div><div><span style="font-family: helvetica;"><br /></span></div><span style="font-family: helvetica;">Now check all the services and connect to DB. Ready to rock an roll :)</span></div><div><span style="font-family: helvetica;"><br /></span></div><div><span style="font-family: helvetica;">Cheers! Bose</span></div>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com5tag:blogger.com,1999:blog-7620061238917187120.post-65493905031281798362020-05-01T07:07:00.003+05:302022-07-20T08:02:00.637+05:30Automating the BAR Backup in a script file in OBIEE 12c<p>Following script will be put into exportarchive.sh files and added to the cronjob in linux server to run and export archive file everyday for backup.</p><p>exportarchive.sh</p><p>================================================</p><p>#!/bin/bash</p><p>folderName= `date +%Y%m%d`</p><p>export SCRIPT_PATH=/obiee12c/scripts</p><p>export DOMAIN_PATH=/obiee12c/user_projects/domains/bi/bitools/bin</p><p>export EXPORT_DIR=/obishare/barbackup/migration</p><p>MAIL_TO=bose.obiee@gmail.com,xyz@gmail.com,abc@gmail.com</p><p>#MAIL_TO=bose.obiee@gmail.com,xyz@gmail.com,abc@gmail.com</p><p>mkdir -p $EXPORT_DIR/$folderName</p><p>echo "Running the export archive script"</p><p>echo "Exporting............................."</p><p><br /></p><p>$DOMAIN_PATH/exportarchive.sh ssi $EXPORT_DIR/$folderName encryptionpassword=admin123 >> $EXPORT_DIR/$folderName/export.log</p><p><br /></p><p>SUCCESS_COUNT=`grep "Export archive completed successfully" $EXPORT_DIR/$folderName/export.log | wc -l`</p><p><br /></p><p>if [ "${SUCCESS_COUNT}" -eq "l" ]</p><p>then</p><p>echo -e "Hi Team, \nThe export of BAR in `hostname` is completed and the export is available in ${EXPORT_DIR} \n\nThanks" | mail -s "BAR export is completed successfully in `hostname`" ${MAIL_TO}</p><p>else</p><p>echo -e "Hi Team, \nThe export of BAR in `hostname` is not completed and the export log is available in ${EXPORT_DIR} \n\nThanks" | mail -s "BAR export has failed in `hostname`" ${MAIL_TO} -a $EXPORT_DIR/$folderName/export.log ${MAIL_TO}</p><p>exit</p><p>fi</p><p>#Cleaning BAR files which are older than 7 days</p><p>find ${EXPORT_DIR} -name "20*" -type d -mtime +7 -exec rm rf {} \;</p><p>==========================================</p><p><br /></p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><br /></div><br /><p></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-71157842493734477372020-03-01T14:32:00.079+05:302020-10-21T16:44:37.417+05:30How to tar/untar , zip/unzip a file or directory in Linux Server<span style="font-family: georgia;">Frequently working in BI Administration, we would work on packing/unpacking the tar and zip files for installation, patching or packing the old files as backup. This command is handy and useful:</span><div><span style="font-family: georgia;"><br /></span></div><div><b><span style="font-family: georgia;">To Unpack/Untar the tar.gz file:</span></b></div><div><span style="font-family: georgia;"><br /></span></div><div><span style="color: #20124d; font-family: georgia;"><b style="background-color: #f9f9f9;">syntax: </b><span style="background-color: #f9f9f9;">tar - xvzf <zip_or_tar.gz_file_Name></span></span></div><div><span style="background-color: #f9f9f9;"><span style="color: #20124d; font-family: georgia;"><b>e.g.:</b> tar -xvzf java8u251.tar.gz</span></span></div><div><span style="font-family: georgia;"><br /></span></div><div><span style="background-color: #f9f9f9;"><span style="font-family: georgia;"><br /></span></span></div><div><span style="background-color: #f9f9f9;"><span style="font-family: georgia;">The above command will untar the java8u251.tar.gz file.</span></span></div><div><span style="background-color: #f9f9f9;"><span style="font-family: georgia;"><br /></span></span></div><div><span style="background-color: #f9f9f9;"><b><span style="font-family: georgia;">To Pack/Tar the file or directory:</span></b></span></div><div><span style="background-color: #f9f9f9;"><span style="font-family: georgia;"><br /></span></span></div><div><span style="color: #20124d; font-family: georgia;"><b style="background-color: #f9f9f9;">Syntax: </b><span style="background-color: #f9f9f9;">tar -cvzf <target_file_name> <source_file_Or_Directory_Name></span></span></div><div><span style="background-color: #f9f9f9;"><span style="color: #20124d; font-family: georgia;"><b>e.g.:</b> tar -cvzf jdk1.8_241.tar.gz jdk1.8_241</span></span></div><div><span style="font-family: georgia;"><br /></span></div><div><div><span style="color: #404040; font-family: georgia;"><b>How to unpack .zip file:</b></span></div><div><span style="color: #404040; font-family: georgia;"><br /></span></div><div><span style="color: #404040; font-family: georgia;">Unzipping in the same directory where the zip file is:</span></div><div><span style="color: #20124d; font-family: georgia;"><b>Syntax:</b> unzip <Source_Zip_File></span></div><div><span style="color: #20124d; font-family: georgia;"><b>e.g: </b>unzip music.zip</span></div><div><span style="color: #404040; font-family: georgia;"><br /></span></div><div><span style="color: #404040; font-family: georgia;">Unzipping the file to a particular directory:</span></div><div><span style="color: #20124d; font-family: georgia;"><b>Syntax: </b>unzip <source<zip_file> -d <target_directory_to_unzip></span></div><div><span style="color: #20124d; font-family: georgia;"><b>e.g: </b>unzip music.zip -d \home\music</span></div></div><div><span style="font-family: georgia;"><br /></span></div><div><div><span style="color: #404040; font-family: georgia;"><b>How to pack .zip file:</b></span></div><div><span style="color: #404040; font-family: georgia;"><br /></span></div><div><span style="color: #404040; font-family: georgia;">zipping the directory:</span></div><div><span style="color: #20124d; font-family: georgia;"><b>Syntax:</b> zip -r <target_zip_file_name> <Source_Directory></span></div><div><span style="color: #20124d; font-family: georgia;"><b>e.g: </b>zip -r music.zip /home/music</span></div><div><span style="color: #404040; font-family: georgia;"><br /></span></div><div><span style="color: #404040; font-family: georgia;">Zipping a file</span></div><div><span style="color: #20124d; font-family: georgia;">zip names.zip names.txt</span></div><div><span style="color: #404040; font-family: georgia;"><br /></span></div><div><b style="color: #404040;"><span style="font-family: georgia;">How to Unpack .zip file:</span></b></div><div><span style="color: #404040; font-family: georgia;">Unzipping the file to a particular directory:</span></div><div><span style="color: #20124d; font-family: georgia;"><b>Syntax: </b>unzip <source<zip_file> -d <target_directory_to_unzip></span></div><div><span style="color: #20124d; font-family: georgia;"><b>e.g: </b>unzip music.zip -d /home/music</span></div></div><div><span style="color: #20124d; font-family: georgia;"><br /></span></div><div><span style="color: #20124d; font-family: georgia;">To unzip within the same directory, use the without -d</span></div><div><span style="color: #20124d; font-family: georgia;">unzip music.zip</span></div><div><span style="color: #20124d; font-family: georgia;"><br /></span></div><div><span style="color: #20124d; font-family: georgia;"><div>You can encrypt .zip with a password by passing the -e option:</div><div>zip -r -e music.zip /home/music</div><div><br /></div><div><div><b>Verify file with the ls command:</b></div><div>ls -l music.zip</div></div></span></div><div><span style="font-family: georgia;"><br /></span></div><div><span style="font-family: georgia;">This is the meaning for each letter in -xvzf or cvzf </span></div><div><span style="background-color: #f9f9f9; font-size: 14px;"><span style="font-family: georgia;"><br /></span></span></div><div><ul style="background-color: white; box-sizing: inherit; color: #404040; font-size: 16px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 1.5em 20px; padding-left: 10px;"><li style="box-sizing: inherit; margin-bottom: 10px;"><span style="font-family: georgia;"><span style="box-sizing: inherit; font-weight: 600;">-x</span>: Extract, retrieve the files from the tar file.</span></li><li style="box-sizing: inherit; margin-bottom: 10px;"><span style="font-family: georgia;"><span style="box-sizing: inherit; font-weight: 600;">-v</span>: Verbose, list the files as they are being extracted.</span></li><li style="box-sizing: inherit; margin-bottom: 10px;"><span style="font-family: georgia;"><b>-c:</b> Create, Create a tar or zip file</span></li><li style="box-sizing: inherit; margin-bottom: 10px;"><span style="font-family: georgia;"><span style="box-sizing: inherit; font-weight: 600;">-z</span>: Zip, use gzip, zip or tar.gz to decompress the tar file.</span></li><li style="box-sizing: inherit; margin-bottom: 10px;"><span style="font-family: georgia;"><span style="box-sizing: inherit; font-weight: 600;">-f</span>: File, the name of the tar file we want <code style="box-sizing: inherit; font-size: 14px !important;">tar</code> to work with. </span></li></ul><div><span style="color: #404040; font-family: georgia;">Cheers!</span></div></div><div><span style="color: #404040; font-family: georgia;">Bose</span></div>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-62615501082424578652020-02-06T19:38:00.028+05:302020-12-04T21:29:15.703+05:30OBIEE 12c Client Tool step by step installation<p><span style="font-family: georgia;">Here is the steps on how to download and Install OBIEE 12c client tool installaton.</span></p><p><span style="font-family: georgia;"><b>Download Link: </b></span></p><p><span style="font-family: georgia;"><a href="https://www.oracle.com/in/middleware/technologies/business-intelligence-v12214-downloads.html">https://www.oracle.com/in/middleware/technologies/business-intelligence-v12214-downloads.html</a></span></p><p><span style="font-family: georgia;">Go to </span><span style="background-color: #fbf9f8; font-family: georgia;"><b>Oracle Business Intelligence Developer Client Tool (12.2.1.4.0)</b> section and download the client tool.</span></p><p><span style="background-color: #fbf9f8; font-family: georgia;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAVaG8PzJo4SfVkPW9d7IS7BQ6RhZwQssY2vC23weROf6AadNDZPUN57pR01HrqKEiHEyI0N8sug8NWDZXtuIaAH7rM_EdF6Rjdas83C2Pc1Biq-fr9Hg_Jys8hK2XAMs9hD8bPNh_tZKF/" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img alt="" data-original-height="330" data-original-width="946" height="224" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAVaG8PzJo4SfVkPW9d7IS7BQ6RhZwQssY2vC23weROf6AadNDZPUN57pR01HrqKEiHEyI0N8sug8NWDZXtuIaAH7rM_EdF6Rjdas83C2Pc1Biq-fr9Hg_Jys8hK2XAMs9hD8bPNh_tZKF/w640-h224/image.png" width="640" /></a></span></p><p><span style="font-family: georgia;">once Downloaded, Copy into a new folder and unarchive/unzip the zip file.</span></p><p><span style="font-family: georgia;"><b>Step1: </b></span></p><p><span style="font-family: georgia;">Double click on the 'setup_bi_client-12.2.1.4.0-win64' file and the installation window will open</span></p><p><span style="font-family: georgia;"><br /></span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje_E3KQ6JpWrNJCiwTJ_NmPgsxwk8FNeUx3Z911rtYSoOzCFki8ugQPQfNR6SXpchBTz_AOUTxaA9O0oHUfEor0QlgqrsdLkiTxvLRXP0sM4Jv-35-dc2dGWAQE5gpvKks2nKop-VnyhI/s604/1.PNG" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="179" data-original-width="604" height="190" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEje_E3KQ6JpWrNJCiwTJ_NmPgsxwk8FNeUx3Z911rtYSoOzCFki8ugQPQfNR6SXpchBTz_AOUTxaA9O0oHUfEor0QlgqrsdLkiTxvLRXP0sM4Jv-35-dc2dGWAQE5gpvKks2nKop-VnyhI/w640-h190/1.PNG" width="640" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgSN8ifAnDaqgEHm80UnbjlzP_Ou1tdTvVjGLie5dgbGbq5qAONVTFR3lyNQ21rUB26mu5FBdUUssBI10WxPf294nE2OTYTM-Hi6g2n1NoDX-RT-8QPCJr4ivcUBk1ROh55OfJwmfEVlA/s442/2.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="379" data-original-width="442" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgSN8ifAnDaqgEHm80UnbjlzP_Ou1tdTvVjGLie5dgbGbq5qAONVTFR3lyNQ21rUB26mu5FBdUUssBI10WxPf294nE2OTYTM-Hi6g2n1NoDX-RT-8QPCJr4ivcUBk1ROh55OfJwmfEVlA/s320/2.jpg" width="320" /></span></a></div><span style="font-family: georgia;"><br /></span><div class="separator" style="clear: both; text-align: center;"><span style="font-family: georgia;"><br /></span></div><p><span style="font-family: georgia;"><b>Step2:</b></span></p><p><span style="font-family: georgia;">Oracle Universal Installer Window will open. Just Click 'Next'</span></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG2ne2FZTANV8ZzIqxbHXWoTQRvVlFwcaq_J_lCFJ5xFEwgSx_DtHj2QKA4gTcf4PiqckBeSELQyo1qAyNj7H6YwMZIbEhJWphGCyF4iAQhrya9Ig2B7TM3ej_xPbCPjBAfnGg72DuhJw/s810/3.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="635" data-original-width="810" height="502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiG2ne2FZTANV8ZzIqxbHXWoTQRvVlFwcaq_J_lCFJ5xFEwgSx_DtHj2QKA4gTcf4PiqckBeSELQyo1qAyNj7H6YwMZIbEhJWphGCyF4iAQhrya9Ig2B7TM3ej_xPbCPjBAfnGg72DuhJw/w640-h502/3.jpg" width="640" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><b>Step3:</b></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Check the default selected folder is good to install or create your folder and select the folder here to install and click 'Next'</span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIiWK5CBI-Ig_SqP5lGnRaYEt4BlWVN7yPMGdOuMQDsc93rhhoMg89xXseUEVGyzD3YnPaNJlRt7NPc4Ck8XY4NI6EeWmJM9l1QoxFxCEj1K2trll0PsWmcme9n2KDnnaNRw8NZirsyEg/s810/4.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="635" data-original-width="810" height="502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIiWK5CBI-Ig_SqP5lGnRaYEt4BlWVN7yPMGdOuMQDsc93rhhoMg89xXseUEVGyzD3YnPaNJlRt7NPc4Ck8XY4NI6EeWmJM9l1QoxFxCEj1K2trll0PsWmcme9n2KDnnaNRw8NZirsyEg/w640-h502/4.jpg" width="640" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><b>Step4:</b></span></div><span style="font-family: georgia;">The actual installation starts here. Just Click 'install' to install OBIEE Client 12c. </span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Note: If you want to save the details, you could click and save the responsible file.</span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9N0v1PamMorkMD-iHU6iR4M5IShVBH0sgBHThje-UFjO1TZOmj6zblXiKDMcYbch6BJW4pWbw-Rc44VdR5-TH0_6pxNHEv3nXt4Opj5efIZ9SwRN91ei91-FgQ1msCdlzUCXojg0XMrM/s810/5.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="635" data-original-width="810" height="502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9N0v1PamMorkMD-iHU6iR4M5IShVBH0sgBHThje-UFjO1TZOmj6zblXiKDMcYbch6BJW4pWbw-Rc44VdR5-TH0_6pxNHEv3nXt4Opj5efIZ9SwRN91ei91-FgQ1msCdlzUCXojg0XMrM/w640-h502/5.jpg" width="640" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><b>Step5: </b></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Installation will progress and completes the client tool installation. Just click 'Next'</span></div><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsJFdOD850gDbsRmJzNV9CSdX5OJ-xKLAeYjRDqHac38gK1wvsXQAVK2WcZm3RyXOwnOxZTUX29OB4GA-EKD2gB4xv8d6eYCBXof2eWRTG8kkSIHSrJMApdRKB7lg_J4IEVGx6Ox0ifBA/s810/6.jpg" style="margin-left: 1em; margin-right: 1em; text-align: center;"><span style="font-family: georgia;"><img border="0" data-original-height="635" data-original-width="810" height="502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjsJFdOD850gDbsRmJzNV9CSdX5OJ-xKLAeYjRDqHac38gK1wvsXQAVK2WcZm3RyXOwnOxZTUX29OB4GA-EKD2gB4xv8d6eYCBXof2eWRTG8kkSIHSrJMApdRKB7lg_J4IEVGx6Ox0ifBA/w640-h502/6.jpg" width="640" /></span></a><span style="font-family: georgia;"><br /></span><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><b>Step6:</b></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Click 'Finish' to complete the installation.</span></div><div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtcFu7K7lupi_dbtjuVqIy7NLkkjiHmEtwvYHfc6m_9-biGIccxp4KUABVFe00Geb3vnOUeNkzcR7vnCYygf-aWhyphenhyphenbllqdGUViLUqNCEu4g9j1qhe36HSC-64RvGxsAmf4ZLGF0wZ21P0/s810/7.jpg" style="margin-left: 1em; margin-right: 1em; text-align: center;"><span style="font-family: georgia;"><img border="0" data-original-height="635" data-original-width="810" height="502" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtcFu7K7lupi_dbtjuVqIy7NLkkjiHmEtwvYHfc6m_9-biGIccxp4KUABVFe00Geb3vnOUeNkzcR7vnCYygf-aWhyphenhyphenbllqdGUViLUqNCEu4g9j1qhe36HSC-64RvGxsAmf4ZLGF0wZ21P0/w640-h502/7.jpg" width="640" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">To Verify the client is installed in windows machine whether correctly or not, verify below</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Start -> Programs -> Oracle Business Intelligence Client.</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI92k-SBoolb5P5RluwN5QHdWocOw-dTgbg7XY8q5eqkTkNIOU5eaMOlVIFafXwK2h_ADWDxsbenZKtURk5qZQV1MS2xS5WraI6wvkP_FQHnnd4aSUfTiU5R4gTSKFXbGICec8SEvVIjs/s388/8.jpg" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="270" data-original-width="388" height="279" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI92k-SBoolb5P5RluwN5QHdWocOw-dTgbg7XY8q5eqkTkNIOU5eaMOlVIFafXwK2h_ADWDxsbenZKtURk5qZQV1MS2xS5WraI6wvkP_FQHnnd4aSUfTiU5R4gTSKFXbGICec8SEvVIjs/w400-h279/8.jpg" width="400" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Happy Blogging!</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Cheers!</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Bose</span></div><p></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-86562020648663836812020-01-19T16:16:00.006+05:302020-12-05T16:51:54.142+05:30Use the validaterpd Utility to Check Repository Consistency<p style="text-align: justify;"><span style="color: #1a1816; font-family: georgia;">In a development a project, we are deploying RPD multiple times and checking the RPD consistency after each deployment would be task.</span></p><p style="text-align: justify;"><span style="font-family: georgia;"><span style="color: #1a1816;">We could use the Oracle BI Server </span><span style="color: #1a1816;">validaterpd</span><span style="color: #1a1816;"> utility to check the validity of all
metadata objects in a repository in command prompt.</span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin-bottom: 8.05pt; text-align: justify;"><span style="color: #1a1816;"><span style="font-family: georgia;">Running this utility
performs the same validation checks as the Consistency Check Manager in
the Administration Tool.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: #FCFBFA; line-height: normal; margin-bottom: 8.05pt; margin-left: 0in; margin-right: 0in; margin-top: 8.05pt; text-align: justify;"><span style="font-family: georgia;"><span style="color: #1a1816;">The </span><span style="color: #1a1816;">validaterpd</span><span style="color: #1a1816;"> utility is available on both Windows (</span></span><span style="color: #1a1816; font-family: georgia;">validaterpd</span><span style="color: #1a1816; font-family: georgia;">.cmd) and Linux (</span><span style="color: #1a1816; font-family: georgia;">validaterpd</span><span style="color: #1a1816; font-family: georgia;">.sh)
systems. </span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><span style="color: #1a1816;">The location of the </span><span style="color: #1a1816;">validaterpd</span><span style="color: #1a1816;"> utility is:<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="color: #800180; font-family: courier;"><b><i>$BI_DOMAIN</i>/bitools/bin</b></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin-bottom: 8.05pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="font-family: georgia;"><span style="color: #2b00fe;">Syntax</span><span style="color: #1a1816;"><o:p></o:p></span></span></b></p><p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin-bottom: 8.05pt; text-align: justify;"><span style="color: #2b00fe; font-family: georgia;"><b>****************</b></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><span style="color: #1a1816;">The </span><span style="color: #1a1816;">validaterpd</span><span style="color: #1a1816;"> utility takes the following parameters:<o:p></o:p></span></span></p>
<div style="background: white; border: solid #DEDAD6 1.0pt; mso-element: para-border-div; padding: 10.0pt 10.0pt 10.0pt 12.0pt;">
<p class="MsoNormal" style="background: white; border: none; line-height: normal; margin: 12pt 0in; padding: 0in; text-align: left;"><span style="color: #800180; font-family: courier;"><b>validaterpd
{-R <i>repository_name</i> | -I <i>input_file_pathname </i>|-D
<i>MDS_XML_document_directory</i>} [-P <i>repository_password</i>]
{-O <i>output_txt_file_name</i> |-C
<i>output_csv_file_name</i> | -X <i>output_xml_file_name</i>}
[-8] [-F <i>fixed_rpd_name</i>|-E] [-S] [-B]</b></span></p>
</div>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="color: #1a1816;"><span style="font-family: georgia;">Where:<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><i><span style="color: #1a1816;">repository_name</span></i><span style="color: #1a1816;"> is the name and path of the binary
Oracle BI repository file that you want to validate.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><i><span style="color: #1a1816;">input_file_pathname</span></i><span style="color: #1a1816;"> is the name and path of the XML input
file that you want to validate.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><i><span style="color: #1a1816;">MDS_XML_document_directory</span></i><span style="color: #1a1816;"> is the location of the input MDS XML
documents.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><i><span style="color: #1a1816;">repository_password</span></i><span style="color: #1a1816;"> is the password for the repository that
you want to validate.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><span style="color: #1a1816;">The </span><i><span style="color: #1a1816;">repository_password</span></i><span style="color: #1a1816;"> argument is optional. If you don't
provide the password argument, you're prompted to enter the password when you
run the command. <o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><i><span style="color: #1a1816;">output_txt_file_name</span></i><span style="color: #1a1816;"> is the name and path of a text(.txt or .log) file
where the validation results are recorded.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><i><span style="color: #1a1816;">output_csv_file_name</span></i><span style="color: #1a1816;"> is the name and path of a csv file where
the validation results are recorded.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><i><span style="color: #1a1816;">output_xml_file_name</span></i><span style="color: #1a1816;"> is the name and path of an XML file
where the validation results are recorded.<o:p></o:p></span></span></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin-bottom: 8.05pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="font-family: georgia;"><span style="color: #2b00fe;">Examples</span><span style="color: #1a1816;"><o:p></o:p></span></span></b></p><p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin-bottom: 8.05pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="font-family: georgia;"><span style="color: #2b00fe;">******************</span></span></b></p>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><span style="color: #1a1816;">The following example generates an output file
called </span><i><span style="color: #1a1816;">results.log </span></i><span style="color: #1a1816;">that
contains validation information for the repository called </span><i><span style="color: #1a1816;">repository.rpd</span></i></span></p><p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="color: #1a1816; font-family: georgia;">You must provide the full path names to your repository files, both the input files and the output files, if they're located in a different directory.</span></p>
<div style="background: white; border: solid #DEDAD6 1.0pt; mso-element: para-border-div; padding: 10.0pt 10.0pt 10.0pt 12.0pt;">
<p class="MsoNormal" style="background: white; border: none; line-height: normal; margin: 12pt 0in; padding: 0in; text-align: left;"><span style="color: #800180; font-family: courier;"><b>./validaterpd.sh -R /home/bose/repository.rpd -O /home/bose/repository.log<o:p></o:p></b></span></p>
<p class="MsoNormal" style="background: white; border: none; line-height: normal; margin: 12pt 0in; padding: 0in; text-align: left;"><span style="color: #800180; font-family: courier;"><b>Repository password: Type_Your_Repository_Password</b></span><span style="color: #1a1816; font-family: georgia;"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="background: rgb(252, 251, 250); line-height: normal; margin: 8.05pt 0in; text-align: justify;"><span style="font-family: georgia;"><span style="color: #1a1816;">The following example generates an output file
called </span><i><span style="color: #1a1816;">results.csv</span></i><span style="color: #1a1816;"> that
contains validation information for the repository contained in the MDS XML
documents located at C:\MDS_dir:<o:p></o:p></span></span></p>
<div style="background: white; border: solid #DEDAD6 1.0pt; mso-element: para-border-div; padding: 10.0pt 10.0pt 10.0pt 12.0pt;">
<p class="MsoNormal" style="background: white; border: none; line-height: normal; margin: 12pt 0in; padding: 0in; text-align: justify;"><span style="color: #800180; font-family: courier;"><b>./validaterpd.sh -D C:\MDS_dir -C results.csv<o:p></o:p></b></span></p>
<p class="MsoNormal" style="background: white; border: none; line-height: normal; margin: 12pt 0in; padding: 0in; text-align: justify;"><span style="color: #800180; font-family: courier;"><b>Give
password: my_rpd_password</b></span><span style="color: #1a1816; font-family: georgia;"><o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="text-align: justify;"><span style="font-family: georgia;">Just run head -n10 of the output text, log, csv or XML file to see the first 10 lines of the results. We are good with the deployed repository if there is no errors.</span></p><p class="MsoNormal" style="text-align: justify;"><span style="color: #800180;"><b><span style="background-color: white; font-family: courier; text-align: left;">$ head -n10 /home/bose/</span><span style="background-color: white; font-family: courier; text-align: left;">repository</span><span style="background-color: white; font-family: courier; text-align: left;">.log</span></b></span></p><p class="MsoNormal" style="text-align: justify;"><span style="font-family: georgia;">Cheers!</span></p><p class="MsoNormal" style="text-align: justify;"><span style="font-family: georgia;">Bose</span></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com1tag:blogger.com,1999:blog-7620061238917187120.post-65988951836177421062019-08-14T14:05:00.026+05:302020-12-19T22:50:00.661+05:30Automated Cache purging in OBIEE 12c<p><span style="font-family: georgia;">In this post We are going to create a shell script which will purge all the cache in OBIEE. This file could be scheduled in a cronjob OR added in informatica or ODI to run everyday once all the loads are completed or Run manually whenever you would like to run.</span></p><p><span style="font-family: georgia;"><span style="color: #2b00fe;"><b>Step1:</b> </span>Create purgecache.txt file like below</span></p><p></p><table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="background: white; mso-cellspacing: 0in; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184; width: 480px;">
<thead>
<tr style="height: 13pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: white; height: 13pt; mso-background-themecolor: background1; padding: 0in; width: 359.95pt;" width="480">
<p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="font-family: courier;"><span style="color: black;">Purgecache.txt</span><span style="color: black;"><o:p></o:p></span></span></p>
</td>
</tr>
</thead>
<tbody><tr style="height: 13pt; mso-yfti-irow: 1; mso-yfti-lastrow: yes;">
<td style="background: azure; height: 13pt; padding: 0in; width: 359.95pt;" width="480">
<p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"><span style="color: black;"><span style="font-family: courier;">call SAPurgeAllcache()</span></span><span face=""Arial","sans-serif"" style="color: black; font-size: 8.5pt; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
</td>
</tr>
</tbody></table><p></p><p><span style="color: #2b00fe; font-family: georgia;"><b>Step2:</b> </span><span style="font-family: georgia;">Create a shell script to call the above file and clear the purge.</span></p><p><span style="font-family: georgia;">****************************************************************************************</span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#purgeCache12c file is created for clearing BI
12c cache#<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#File Name - purgecache.sh</span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#!/bin/bash<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#OBIEE12c Home Location<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">export MW_HOME=/OBIEE12c<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#Location of the Purgecache script file<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">export
SCRIPT_PATH=/OBIEE12c/scripts/purgeCache<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;"># Timestamp for Log file creation<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">TIME_STAMP=`date
'+%Y%m%d_%H%M'`<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#Log File directory and filename creation<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">export
LOG_FILE=$SCRIPT_PATH/purgecache_${TIME_STAMP}.log<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#Mail Group that you want to send (Optional)<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">MAIL_LIST="#bisupport@oracle.com"<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#Command to clear BI Server Cache<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">$MW_HOME/user_projects/domains/bi/bitools/bin/nqcmd.sh
-d AnalyticsWeb -u weblogic -p weblogicpwd -s $SCRIPT_PATH/purgecache.txt -o
$LOG_FILE;<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;"># Finding Purge cache Line Count for Cache Clear
success or Fail<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">line_cnt=`cat
$SCRIPT_PATH/purgecache.txt|wc -l`<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">SUCCESS_FLG=`grep
-E 'Operation SAPurgeAllCache succeeded' $LOG_FILE|wc -l`;<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">if [
$SUCCESS_FLG = $line_cnt ]<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">then<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">
echo "Cache Cleared Successfully " >>
$LOG_FILE<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">
echo `hostname` >> $LOG_FILE<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">
mailx -s "Cache Clearance Successful on
`hostname`" $MAIL_LIST < $LOG_FILE<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">else<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">
echo "Cache clearance Failed" >> $LOG_FILE<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">
mailx -s "Cache Clearance Failed on `hostname`"
$MAIL_LIST << EOT<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">
GCWUAT Cache clearance Failed, please verify<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">EOT<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">fi<o:p></o:p></span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0in; mso-margin-top-alt: auto;"><span style="font-family: Courier; font-size: 12pt;">#Command to Delete the log files which is older
than 5 days<o:p></o:p></span></p><p><span style="font-family: georgia;">
</span></p><p class="MsoNormal" style="background: whitesmoke; line-height: normal; margin-bottom: 0.0001pt;"><span style="font-family: Courier; font-size: 12pt;">find $SCRIPT_PATH/
-name "*.log" -type f -mtime +2 -exec rm -rf {} \;<o:p></o:p></span></p><p><span style="font-family: georgia;"><b>**************************************************************************************</b></span></p><p><b><span style="color: #2b00fe; font-family: georgia;">Note:</span></b></p><p><span style="font-family: georgia;">MW_HOME environment variable value should be updated based on you BI 12c environment.</span></p><p><span style="font-family: georgia;">You can test this script file by running manually once in your environment by the below command.</span></p><p><span style="font-family: georgia;">./purgecache.sh</span></p><p><br /></p><p><span style="font-family: georgia;">Happy Blogging!</span></p><p><span style="font-family: georgia;">Bose</span></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com2tag:blogger.com,1999:blog-7620061238917187120.post-60262707520271104082019-02-14T22:24:00.001+05:302020-10-27T14:54:47.168+05:30How to download Oracle Software directly in Servers using wget.sh file | How to download using wget.sh file<p><span style="font-family: georgia;">I often wonder that how do we download GB size of oracle softwares and move it server and Install the same until I get to know how simple is that downloading any size of software using wget.sh shell script file directly in server.</span></p><p><span style="font-family: georgia;">Steps are very Simple. But as a first thing, Create/Have an Oracle account for You!</span></p><p><b><span style="font-family: georgia;">Step1:</span></b></p><p><span style="font-family: georgia;">Either <a href="https://edelivery.oracle.com/">Oracle eDelivery</a> or <a href="http://Support.oracle.com">Support.oracle.com</a>, get the wget.sh file for the software that you would like to download</span></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimfbz0pyPkQ2XZTqaUWHSHeHN08nu6WaRLchwrpNJuuDVr5OJc-CyZy8USoZA42N18ySWFbsFry2rgUFA75HWlgBNUlQq2ZjRr7A5Rflj6ix9Bv6QWPxkldjuOqFkjGu14FvQFpArDGxI/s987/1.1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="493" data-original-width="987" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimfbz0pyPkQ2XZTqaUWHSHeHN08nu6WaRLchwrpNJuuDVr5OJc-CyZy8USoZA42N18ySWFbsFry2rgUFA75HWlgBNUlQq2ZjRr7A5Rflj6ix9Bv6QWPxkldjuOqFkjGu14FvQFpArDGxI/w640-h320/1.1.jpg" width="640" /></span></a></div><span style="font-family: georgia;"><br /></span><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQsOwlx9t9E8Ak44h_YSCbaxzHOWjhpNSbhccTHHwjkCxWgII98UTsGX7X-9DD6x14RcOY_akUS-CHCgbS6xUzHGcq7ZJa3NajIoZlRLE3IQPwtqqv6edFX9hE65PR17wFmBlHCk8DZ2k/s361/1.2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="361" data-original-width="285" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQsOwlx9t9E8Ak44h_YSCbaxzHOWjhpNSbhccTHHwjkCxWgII98UTsGX7X-9DD6x14RcOY_akUS-CHCgbS6xUzHGcq7ZJa3NajIoZlRLE3IQPwtqqv6edFX9hE65PR17wFmBlHCk8DZ2k/s320/1.2.jpg" /></span></a></div><div class="separator" style="clear: both; text-align: center;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Download .sh and move the file to server where you want to download.</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><b><span style="font-family: georgia;">Step2:</span></b></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Open shell scripts or command prompt just run the below command</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">[$] ./wget.sh</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">enter your username: bose.obiee@gmail.com + enter</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">[type your password] + enter</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><b><span style="font-family: georgia;">Note:</span></b></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">i. Enter the same username and password which you used to download the software</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">ii. After entering the username, just enter it </span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">iii. Second line will be blank but enter the oracle account password and click enter</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">iv. Check if you have proper privileges with read+write+execute permission in the target directory <span> </span><span> </span><span> </span>when you are downloading.</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">If it is a bigger a software then it would take sometime based on the network speed in server and will complete the download.</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;"><br /></span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Happy Blogging!</span></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: georgia;">Bose</span></div><p></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-54230374601706110822019-01-26T23:08:00.025+05:302020-12-14T23:30:57.183+05:30OBIEE 12c Lift and Shift<p><span style="font-family: georgia;">When we are doing the lift and shift of OBIEE 12c, We would be copying the entire OBIEE 12c installed directory to the new server. </span></p><p><span style="font-family: georgia;">When we are doing this change, We have to complete prerequisite check first and then we have to update the hostname and IP Address of the new server in the following locations in OBIEE 12c files.</span></p><p><span style="font-family: georgia;">Following are the file locations and file names for two Node clustered Servers:</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>Node1</b></span></p><p><span style="color: #2b00fe; font-family: georgia;">Update the IP address in <b>startup.properties </b>file in the following locations.</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/servers/bi_server1/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/servers/bi_server3/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/servers/bi_server5/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs1/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh1/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips1/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch1/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis1/data/nodemanager</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update IP address of the new server in <b>nodemanager.properties </b>file in below location</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/nodemanager</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update IP address of the new server in </span><span style="color: #2b00fe; font-family: georgia;"><b>config.xml </b></span><span style="color: #2b00fe; font-family: georgia;">file in below location</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/config</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update IP address of the new server in </span><span style="color: #2b00fe; font-family: georgia;"><b>admin.conf</b> </span><span style="color: #2b00fe; font-family: georgia;"><b> </b></span><span style="color: #2b00fe; font-family: georgia;">file in below location</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs1</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update IP address of the new server in </span><span style="color: #2b00fe; font-family: georgia;"><b>wsm-ccw-config.xml </b></span><span style="color: #2b00fe; font-family: georgia;">file in below location</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/config/fmwconfig</span></p><p><span style="color: #2b00fe; font-family: georgia;"><b><br /></b></span></p><p><span style="color: #2b00fe; font-family: georgia;"><b>Node2:</b></span></p><p><span style="color: #2b00fe; font-family: georgia;">Update the IP address in </span><span style="color: #2b00fe; font-family: georgia;"><b>startup.properties</b></span><span style="color: #2b00fe; font-family: georgia;"> file in the following locations.</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/servers/bi_server2/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/servers/bi_server4/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/servers/bi_server6/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs2/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh2/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips2/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch2/data/nodemanager</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis2/data/nodemanager</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update the IP address in </span><span style="font-family: georgia;"><b><span style="color: #2b00fe;">nodemanager.properties</span></b> </span><span style="color: #2b00fe; font-family: georgia;">file in the following location.</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/nodemanager</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update the IP address in </span><span style="font-family: georgia;"><b><span style="color: #2b00fe;">config.xml</span></b></span><span style="font-family: georgia;"> </span><span style="color: #2b00fe; font-family: georgia;">file in the following location.</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/config</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update the IP address in </span><span style="color: #2b00fe; font-family: georgia;"><b>admin.conf </b></span><span style="color: #2b00fe; font-family: georgia;">file in the following location.</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs2</span></p><p><span style="color: #2b00fe; font-family: georgia;">Update the IP address in </span><span style="color: #2b00fe; font-family: georgia;"><b>wsm-ccw-config.xml </b></span><span style="color: #2b00fe; font-family: georgia;">file in the following location.</span></p><p><span style="font-family: courier;">/OBIEE12C/user_projects/domains/bi/config/fmwconfig</span></p><div><br /></div><div><span style="font-family: georgia;">Cheers!</span></div><div><span style="font-family: georgia;">Bose</span></div>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com1tag:blogger.com,1999:blog-7620061238917187120.post-80086054316557029422019-01-23T19:15:00.128+05:302020-12-18T20:12:51.792+05:30OBIEE 12c BIPLATFORM / MDS Account Password Expired or Account locked<p></p><p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="color: black; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">I have recently come across an issue where few of our BI components
went down and while stopping/restarting the services, It prompts for weblogic
User Name and Password and also failing to start the services.<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="color: black; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">I have started analyzing the <a href="http://allaboutobiee.blogspot.com/2020/10/log-files-locationdirectory-in-obiee.html" target="_blank">AdminServer log files</a> in OBIEE 12c where I found the issue details like <o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="color: #0070c0; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">[jdbc:oracle:thin:@//biapp:1521/bidev]<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="color: #0070c0; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">caused by java.sql.SQLException: ORA-28001: the password
expired.<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="color: black; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">Then I understand that the supporting schemas like MDS,
BIPLATFORM, IAU, OPSS and etc., accounts are expired in database. Here is the
steps that how I have resolved that.<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="color: black; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><b>Step1: </b></span><span style="font-family: Georgia, serif; font-size: 12pt;">Connect to oracle database as a sys user and run the below query
to get the expired accounts.</span></p>
<div style="background: whitesmoke; border: 1pt solid rgb(204, 204, 204); mso-border-alt: solid #CCCCCC .5pt; mso-element: para-border-div; padding: 7pt;"><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE ACCOUNT_STATUS LIKE 'EXPIRED%';<o:p></o:p></span></pre></div>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="background: white; color: black; font-family: Georgia, serif;">Above query will result all the expired account details.</span><span style="color: black; font-family: Georgia, serif;"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="background: white; color: black; font-family: Georgia, serif;">OR</span><span style="color: black; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<div style="background: whitesmoke; border: 1pt solid rgb(204, 204, 204); mso-border-alt: solid #CCCCCC .5pt; mso-element: para-border-div; padding: 7pt;"><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME LIKE 'DEV_%'<o:p></o:p></span></pre></div>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="background: white; color: black;"><span style="font-family: Georgia, serif;">Above query will result all the</span><span style="font-family: Georgia, serif;"> accounts</span><span style="font-family: georgia;"> starting with the name 'DEV_'</span></span><span style="color: black; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit2C3fQoib5NnnphTGONMwRNri5vBr-O6UNsl0GV-jN1qOkWFPf2e8h3dt27J2zCBbMTKBVGBxflLIwujPYJptIIgIyw5bzuHJf-FixwcOXzMaWqM6jKvdgrrS98WYAL8zCF5YsxhwVA0/s379/apassword.PNG" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="140" data-original-width="379" height="148" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEit2C3fQoib5NnnphTGONMwRNri5vBr-O6UNsl0GV-jN1qOkWFPf2e8h3dt27J2zCBbMTKBVGBxflLIwujPYJptIIgIyw5bzuHJf-FixwcOXzMaWqM6jKvdgrrS98WYAL8zCF5YsxhwVA0/w400-h148/apassword.PNG" width="400" /></a><span style="font-family: Georgia, serif; font-size: 12pt;"> </span></div>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span style="font-family: georgia;">If you see the above
screenshot, 6 accounts are expired. Lets start fixing it.</span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span style="font-family: georgia;"><b>Step2: </b>First we have to get
the existing password for the expired accounts. For that run below query.</span></p>
<div style="background: whitesmoke; border: 1pt solid rgb(204, 204, 204); mso-border-alt: solid #CCCCCC .5pt; mso-element: para-border-div; padding: 7pt;"><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SQL> SELECT USERNAME, PASSWORD FROM DBA_USERS WHERE USERNAME = 'DEV_BIPLATFORM';</span></pre></div>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span style="font-family: georgia;">This query will give
the password for only DEV_BIPLATFORM account. same like, get the password for
all the accounts.</span></p>
<p class="MsoNormal" style="line-height: normal; margin-bottom: 0in;"><span style="font-family: georgia;"><b>Step3: </b>Reset the password for the account</span><span style="font-family: Georgia, serif; font-size: 12pt;"><o:p></o:p></span></p>
<div style="background: whitesmoke; border: 1pt solid rgb(204, 204, 204); mso-border-alt: solid #CCCCCC .5pt; mso-element: para-border-div; padding: 7pt;"><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SQL> ALTER USER DEV_BIPLATFORM IDENTIFIED BY 'Admin123';<o:p></o:p></span></pre></div>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: georgia;"><b>Step4:</b>
(Optional: If any account is locked)</span><span style="font-family: Georgia, serif; font-size: 12pt;"><o:p></o:p></span></p>
<div style="background: whitesmoke; border: 1pt solid rgb(204, 204, 204); mso-border-alt: solid #CCCCCC .5pt; mso-element: para-border-div; padding: 7pt;"><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SQL> ALTER USER DEV_BIPLATFORM ACCOUNT UNLOCK;<o:p></o:p></span></pre></div>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><b>Step5:
</b>Disable Password expiry<o:p></o:p></span></p>
<div style="background: whitesmoke; border: 1pt solid rgb(204, 204, 204); mso-border-alt: solid #CCCCCC .5pt; mso-element: para-border-div; padding: 7pt;"><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;<o:p></o:p></span></pre></div>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="background: white; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><b><span style="color: #2b00fe;">Note:</span></b></span><span style="font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height: normal; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;"><span style="background: white; font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";">If you need to know the Profile name , then Please run the
below Query:</span><span style="font-family: "Georgia","serif"; font-size: 12pt; mso-bidi-font-family: "Times New Roman"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></p>
<div style="background: whitesmoke; border: 1pt solid rgb(204, 204, 204); mso-border-alt: solid #CCCCCC .5pt; mso-element: para-border-div; padding: 7pt;"><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SYNTAX: <o:p></o:p></span></pre><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SELECT PROFILE FROM DBA_USERS WHERE USERNAME = '<USERNAME>';<o:p></o:p></span></pre><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">E.G: <o:p></o:p></span></pre><pre style="background: whitesmoke; border: none; mso-border-alt: solid #CCCCCC .5pt; mso-padding-alt: 7.0pt 7.0pt 7.0pt 7.0pt; padding: 0in;"><span style="color: black; font-family: Consolas; font-size: 9pt;">SELECT PROFILE FROM DBA_USERS WHERE USERNAME = 'DEV_BIPLATFORM';</span></pre></div><p></p>Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-30078825068251828392018-11-12T13:14:00.000+05:302018-11-22T18:52:33.451+05:30OBIEE 12c File Locations<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-family: "trebuchet ms" , sans-serif;">If you wonder, where are RPD, Catalog and all the other locations in OBIEE 12c. Here is the path to few files:</span><br />
<br />
<span style="font-family: "trebuchet ms" , sans-serif;"><b>Live RPD Path:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/datamodel/customizations</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>Catalog Path:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/content</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>To Start, Stop or Start and Deploy RPD BI Sevices [start.sh, stop.sh, status.sh, datamodel.sh]:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/bitools/bin</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>To Start/ Stop Weblogic Server, NodeManager </b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><b>[startNodeManager.sh, stopNodeManager.sh, stopWeblogic.sh, startWeblogic.sh]:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/bin</span><span style="font-family: "trebuchet ms" , sans-serif;"></span><br />
<div>
<br /></div>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>InstanceConfig.xml Path:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIPS</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>NQSConfig.INI Path:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIS</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>ssl Path:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/core/ssl</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>ODBC.ini Path:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/core</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;"><b>obis.properties Path:</b></span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/OBIS</span><br />
<br />
<b><span style="font-family: Trebuchet MS, sans-serif;">Catalog Manager:</span></b><br />
<span style="font-family: Trebuchet MS, sans-serif;">[ORACLE_BI_HOME]/bi/bifoundation/web/catalogmanager</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;"><br /></span>
<span style="font-family: "trebuchet ms" , sans-serif;">Cheers!</span><br />
<span style="font-family: "trebuchet ms" , sans-serif;">Bose</span></div>
Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0tag:blogger.com,1999:blog-7620061238917187120.post-19376370666469494092018-11-10T18:00:00.000+05:302018-11-26T12:55:17.137+05:30OBIEE 12c with MySQL Community Edition Connectivity<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="background-color: white; font-size: 13.2px;"><span style="font-family: "verdana" , sans-serif;">This post brings the workaround on How to connect OBIEE 12c Environment with MySQL Server Community Edition.</span></span><br />
<span style="font-family: "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;">This is Tested on OBIEE </span><span style="background-color: #f9f9f9; font-size: 12px;">12.2.1.3.0</span><br style="background-color: white; font-size: 13.2px;" /><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;"><b><span style="color: blue;">Assumption :</span></b></span></span><br />
<span style="font-family: "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;">OBIEE 12c comes with DataDirect Connections and support only for Enterprise Edition. But our requirement is to connect Community Edition as our DW is developed in there.</span></span><br />
<span style="font-family: "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span>
<span style="font-family: "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;">MySQL Community Edition ( i.e. FREE edition )</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">Server OS is Redhat 7 64-bit</span><br style="background-color: white; font-size: 13.2px;" /><span style="color: blue;"><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;"><b>Import tables in OBIEE Admin Tool</b></span></span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">Download latest ODBC Driver and Install, set up DSN, , Create connection pool, Import metadata, Define business and presentation layers.</span><br style="background-color: white; font-size: 13.2px;" /><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;"><span style="color: blue;"><b>Problem:</b> </span> </span></span><br />
<span style="font-family: "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;">Data Direct Drivers are shipped to connect OBIEE to MySQL. Unfortunately these do not work as you get a message "[nQSError: 16001] ODBC error state: S1000 code: 0 message: [DataDirect][ODBC MySQL Wire Protocol driver]Connections to MySQL Community Servers are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.."</span><br style="background-color: white; font-size: 13.2px;" /><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;"><b><span style="color: purple;">Solution:</span></b></span></span><br />
<b style="background-color: white; color: blue; font-family: Verdana, sans-serif; font-size: 13.2px;">Step1:</b><br />
<span style="background-color: white; font-family: "verdana" , sans-serif; font-size: 13.2px;">Use MySQL native ODBC instead of DataDirect ODBC.</span><br />
<br style="background-color: white; font-size: 13.2px;" />
<span style="background-color: white; font-family: "verdana" , sans-serif; font-size: 13.2px;">You can get these from</span><br />
<a href="http://dev.mysql.com/downloads/connector/odbc/#downloads">http://dev.mysql.com/downloads/connector/odbc/#downloads</a><br />
<br style="background-color: white; font-size: 13.2px;" />
<span style="background-color: white; font-family: "verdana" , sans-serif; font-size: 13.2px;">This is an rpm download and install, you need root privileges to do this. DO NOT DOWNLOAD THE ANSI driver as it does not work. </span><br />
<span style="background-color: white; font-family: "verdana" , sans-serif; font-size: 13.2px;">We have to download for Redhat 64bit Server:</span><br />
<span style="background-color: #f3f3f3; color: #666666;"><span style="font-family: "trebuchet ms" , sans-serif; font-size: x-small;">mysql-connector-odbc-setup-8.0.13-1.el7.x86_64.rpm</span></span><br />
<span style="font-family: "verdana" , sans-serif;"><br style="background-color: white; font-size: 13.2px;" /></span><span style="background-color: white; font-family: "verdana" , sans-serif; font-size: 13.2px;"><span style="color: blue;"><b>Step2:</b></span></span><br />
<span style="font-family: "verdana" , sans-serif;"><span style="font-size: x-small;">Update the configuration in ODBC.ini</span></span><br />
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif; font-size: x-small;">Go to the following directory and update the ODBC.ini file like below:</span></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><span style="font-size: 13.2px;">ORACLE_BI_HOME/domains/biee/config/fmwconfig/bienv/core</span></span><br />
<div>
<br /></div>
<div>
<span style="font-family: "verdana" , sans-serif; font-size: x-small;"><b>Note:</b> We can use either OBDC Driver (<span style="background-color: white;">libmyodbc8w) </span>or ANSI Driver(<span style="background-color: white;">libmyodbc8a)</span>.</span></div>
<div>
<br /></div>
<span style="font-family: "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;">[MySQLDevTest]</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">Driver = /usr/lib64/libmyodbc8a.so</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">Description = Connector/ODBC 8.0 ANSI Driver DSN</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">SERVER = mysql.dbhostname.com</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">PORT = 3306</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">USER = username</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">Password = password</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">Database = dbname</span><br style="background-color: white; font-size: 13.2px;" /><span style="background-color: white; font-size: 13.2px;">OPTION = 3</span></span><br />
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbZtqzDEyprM_Dv2YYj-3hYxIp8cF5J2GK-QA3igizjgNhxcPEdlw3t08tB4nO4DluUL6RpcNKXUmoI0z1QI5Usb8T2CiKaH6ii6C06ldvcH1ommVIBn0aocOOyD5mQI2hCGR2mZxDzz8/s1600/mysqlodbc.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="283" data-original-width="510" height="221" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjbZtqzDEyprM_Dv2YYj-3hYxIp8cF5J2GK-QA3igizjgNhxcPEdlw3t08tB4nO4DluUL6RpcNKXUmoI0z1QI5Usb8T2CiKaH6ii6C06ldvcH1ommVIBn0aocOOyD5mQI2hCGR2mZxDzz8/s400/mysqlodbc.png" width="400" /></a></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><b><span style="color: blue;">Step3:</span></b> </span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;">Go to the following directory and update the obis.properties file for LD_LIBRARY_PATH to point OBDC Driver.</span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="background-color: white;">
<span style="font-family: "verdana" , sans-serif;"><span style="font-size: 13.2px;">ORACLE_BI_HOME/domains/biee/config/fmwconfig/bienv/OBIS</span></span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-fDuoOzu-Tl3IMqhtpNbZ5WaF4uFmfvde4e_Bz57Xa0I4tTqefXFXh-r4KjC-YbG2MUzzzNtk2o75F9MPHAiFer-huBJFupha8MyBonvE8GW-8Mz6kfps2rZ12hhqjRznVi21Jg7_3Zg/s1600/mysqlobdcobis.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="470" data-original-width="897" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-fDuoOzu-Tl3IMqhtpNbZ5WaF4uFmfvde4e_Bz57Xa0I4tTqefXFXh-r4KjC-YbG2MUzzzNtk2o75F9MPHAiFer-huBJFupha8MyBonvE8GW-8Mz6kfps2rZ12hhqjRznVi21Jg7_3Zg/s400/mysqlobdcobis.PNG" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;">e.g. </span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;">"LD_LIBRARY_PATH" value="/usr/lib64:$ORACLE_HOME/common/ODBC/Merant/6.0SP1/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib"</span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="color: blue; font-family: "verdana" , sans-serif;"><b>Import Points to Note:</b></span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;">Connection Pool Name, ODBC.ini configuration in OBDC Data Sources name and MYSQL configuration name has to be same.</span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div style="background-color: white; font-size: 13.2px;">
<span style="font-family: "verdana" , sans-serif;">E.g: MySQLConnTest</span></div>
<div style="background-color: white;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: x-small;">Cheers!</span></div>
<div style="background-color: white;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: x-small;">Bose</span></div>
</div>
Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com4tag:blogger.com,1999:blog-7620061238917187120.post-51919201108884417502018-11-10T13:30:00.000+05:302018-11-12T16:54:47.771+05:30Starting and Stopping OBIEE 12c Services in Linux<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Go to the following directory:</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<b><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">/obiee/Oracle/Middleware/<wbr></wbr>Oracle_Home/user_projects/<wbr></wbr>domains/biee/bitools/bin</span></b></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Run the below commands to start, stop or to know the status of entire services.</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<b><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">To Stop All the Services</span></b></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">[root@obiee bin] ./stop.sh</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><b>To Know the Status of All Services:</b> </span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">[root@obiee bin] ./status.sh</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<b><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">To Start all BI Services</span></b></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">[root@obiee bin] ./start.sh</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">To particularly start or stop one or few services use below commands</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><b>Syntax:</b></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">./start.sh -i service_name1, service_name2</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">e.g: [root@obiee bin] ./start.sh -i obis1</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">./stop.sh -i servicename1, servicename2</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">[root@obiee bin] ./stop.sh -i obis1</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">In Windows, instead of .sh use .cmd. for Example. start.cmd</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Cheers!</span></div>
<div style="background-color: white; color: #222222; font-size: small;">
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Bose</span></div>
</div>
Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com6tag:blogger.com,1999:blog-7620061238917187120.post-82590086783259708692018-11-09T11:42:00.005+05:302020-10-21T16:49:34.751+05:30Setting Java Home in Linux<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="font-family: georgia;">Edit the .bashrc or .bash_profile file and add the below line:</span></div>
<div style="text-align: left;">
<span style="font-family: georgia;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: georgia;">[$] vi .bashrc</span></div>
<div style="text-align: left;">
<span style="font-family: georgia;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: georgia;"><span>export JAVA_HOME="Enter_the_Java_Home_Directory"</span></span></div><div style="text-align: left;"><span style="font-family: georgia;">e.g: export JAVA_HOME=/app/JDK/jdk1.8<br />
<span><br /></span>
</span><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgprsp-vLqoCsVAJBLJcQ9bh07Aq2Dh_C-rbv7-YeXlYLoPH1kaa7sn_UkM68-nuSGflyfAp3PPoYq8eFnrW5Yd2V8jOcZ4VtzG8MGDa03EMUPzF6quiovMRN31BPldWvekFQ1Wvj9t7dE/s1600/bashrc.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: georgia;"><img border="0" data-original-height="173" data-original-width="680" height="161" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgprsp-vLqoCsVAJBLJcQ9bh07Aq2Dh_C-rbv7-YeXlYLoPH1kaa7sn_UkM68-nuSGflyfAp3PPoYq8eFnrW5Yd2V8jOcZ4VtzG8MGDa03EMUPzF6quiovMRN31BPldWvekFQ1Wvj9t7dE/s640/bashrc.png" width="640" /></span></a></div>
<span style="font-family: georgia;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: georgia;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: georgia;"><b>Here is the complete steps:</b></span></div>
<div style="text-align: left;">
<span style="font-family: georgia;"><a href="https://access.redhat.com/documentation/en-US/JBoss_Communications_Platform/5.0/html/Platform_Installation_Guide/sect-Configuring_Java.html">https://access.redhat.com/documentation/en-US/JBoss_Communications_Platform/5.0/html/Platform_Installation_Guide/sect-Configuring_Java.html</a></span></div>
<div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: georgia;"><br /></span></div><div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: georgia;"><br /></span></div><span style="font-family: georgia;">After updating it, just source the file so it would be effective immediately and you could verify with the below command</span></div><div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: georgia;"><br /></span></div><div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: georgia;">[$] source .bashrc</span></div><div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: georgia;"><br /></span></div><div dir="ltr" style="text-align: left;" trbidi="on"><span style="font-family: georgia;">[$] echo $JAVA_HOME<br />
<br />
<span>Cheers!</span><br />
<span>Bose</span></span></div>
Bose Pandianhttp://www.blogger.com/profile/12657863962603260666noreply@blogger.com0