tag:blogger.com,1999:blog-9697592523552402002024-03-21T04:02:27.531+01:00Robert Crames' Oracle Database and Middleware BlogrobertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.comBlogger38125tag:blogger.com,1999:blog-969759252355240200.post-40693637205907469042021-04-19T17:16:00.001+02:002021-04-19T17:22:00.478+02:00Mac? X11? Oracle Cloud Infrastructure? - How To Get runInstaller To run ...<h2 style="text-align: left;">Summary</h2><p>Long story told short: Got two OCI machines and tried to install some Oracle stuff - Enterprise Manager, Database Software, Weblogic Server and such 'things'. Problem: How to install that without having a possibility to run a GUI? Well - I'm used to install oracle products using the 'silent' way. Nevertheless - How the heck can I get a GUI to run on a Mac? Here's the How To.</p><h2 style="text-align: left;">Environment</h2><p>MacBook Pro (Mid 2014 - yes it's old, but I'm still waiting for the all new MacBook M1X, latest generation, 32GB RAM at least. Possibly, tomorrow I know more :-))</p><p>OCI - two machines running Linux, 32GB RAM, nothing special</p><h2 style="text-align: left;">To Do's</h2><div style="text-align: left;"><ul style="text-align: left;"><li>Get XQUARTZ from the manufacturers <span style="font-family: times;">website</span> and install it on Your Mac</li></ul><ul style="text-align: left;"><li>connect to Your OCI machine(s) as user opc and login as root (sudo su -)</li></ul><ul style="text-align: left;"><li>check / change / edit '/etc/ssh/sshd_config:<br /><span style="font-family: courier; font-size: 12px;">X11Forwarding yes<br /></span><span style="font-family: courier; font-size: 12px;">X11UseLocalhost no</span></li></ul></div><p style="font-stretch: normal; line-height: normal; margin: 0px;"></p><ul style="text-align: left;"><li><span style="font-family: times;">restart sshd<br /></span><span style="color: #b42419; font-family: courier; font-size: 12px; font-variant-ligatures: no-common-ligatures;"><b>systemctl</b></span><span style="font-family: courier; font-size: 12px; font-variant-ligatures: no-common-ligatures;"> restart sshd</span></li></ul><p></p><p style="font-stretch: normal; line-height: normal; margin: 0px;"></p><ul style="text-align: left;"><li><span style="font-family: times;">install two more packages - xterm (nice to have to check x11) and xauth. Simply run the two statements. In case xterm and/or xauth are installed already, nothing happens.<br /></span><span style="font-family: Menlo; font-size: 12px;">yum -y install xterm<br /></span><span style="font-family: Menlo; font-size: 12px;">yum -y install xauth</span></li></ul><p></p><p style="font-family: Menlo; font-size: 12px; font-stretch: normal; line-height: normal; margin: 0px;"><span style="font-variant-ligatures: no-common-ligatures;"><br /></span></p><h2 style="text-align: left;">Let's try ...</h2><p></p><ul style="text-align: left;"><li><span style="font-family: times;">start XQUARTZ</span></li></ul><ul style="text-align: left;"><li><span style="font-family: times;">connect as opc to Your OCI machine (doesn't matter if You use mac's terminal.app or an XQUARTZ window:<br /></span><span style="font-family: Menlo; font-size: 12px;">ssh -CX opc@<OCI machine></span></li></ul><ul style="text-align: left;"><li><span style="font-family: times;">In case You're connecting using a ssh key:</span><br /><span style="font-family: Menlo; font-size: 12px; font-variant-ligatures: no-common-ligatures;">ssh -CX -i <Path to the public key> opc@</span><span style="font-family: Menlo; font-size: 12px;"><OCI machine></span></li></ul><ul style="text-align: left;"><li><span style="font-family: times;">run these two commands (You'll need the output right after the login as oracle):</span><br /><span style="font-family: Menlo; font-size: 12px;">echo "xauth add $(xauth list | grep `echo $DISPLAY | awk '{ print substr($0,index($0,":"),3) }'` | grep `hostname`)"<br /></span><span style="font-family: Menlo; font-size: 12px;">echo export DISPLAY=$DISPLAY</span></li></ul><ul style="text-align: left;"><li><span style="font-family: Menlo; font-size: 12px;">connect as user oracle<br /></span><span style="font-family: Menlo; font-size: 12px;">sudo su - oracle</span></li></ul><ul style="text-align: left;"><li><span style="font-family: times;">execute the result of the two commands (xauth and echo) - which is something like this:<br /></span><span style="font-family: Menlo; font-size: 12px;">xauth add <oci machine hostname, full qualified>:<Display #> </span><span style="font-family: Menlo; font-size: 12px;">MIT-MAGIC-COOKIE-1</span><span style="font-family: Menlo; font-size: 12px;"> <some kind of key><br /></span><span style="font-family: Menlo; font-size: 12px;">export DISPLAY=<IP>:<Display #></span></li></ul><ul style="text-align: left;"><li><span style="font-family: times;">run Your GUI stuff :-)</span></li></ul><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlpBqEr6b6h_XC7zmYPWyW5AYMJMMrLgYUOtYtXMMjETqsDtNGw-WZFXPFBnk50u7zMaujQuwHeuZs6mRw89PKXb4RcJ29RBPN0tHaJhCE5QqP0quuoI7Ypx9d6c8nqD35vYnggRDMpruo/s1596/ExampleGui.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="1200" data-original-width="1596" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlpBqEr6b6h_XC7zmYPWyW5AYMJMMrLgYUOtYtXMMjETqsDtNGw-WZFXPFBnk50u7zMaujQuwHeuZs6mRw89PKXb4RcJ29RBPN0tHaJhCE5QqP0quuoI7Ypx9d6c8nqD35vYnggRDMpruo/s320/ExampleGui.jpg" width="320" /></a></div><br /><div><br /></div><p style="font-family: Menlo; font-size: 12px; font-stretch: normal; line-height: normal; margin: 0px;"><span style="font-variant-ligatures: no-common-ligatures;"><br /></span></p><p><br /></p>robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-56212478385989875382021-04-11T19:58:00.005+02:002021-04-19T17:24:08.351+02:00Upgrading Enterprise Manager 13.4 to 13.5 - The Silent Way<p><br />Just a short description of what I did to upgrade an existing Enterprise Manager 13.4 (RU9) to the latest release 13.5 ...</p><h3 style="text-align: left;">Environment:</h3><div style="text-align: left;">OCI machine, Oracle Linux 7.9, Enterprise Manager 13.4 RU9<br />OCI machine, Oracle Linux 7.9, Repository Database Release 19.3</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><h3 style="text-align: left;">Software-Download</h3><div style="text-align: left;">EM 13.5 - downloaded from edelivery.oracle.com</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><h3 style="text-align: left;">Preparation</h3><h4 style="text-align: left;">Creating the new em13500 base directory, the MiddlewareHome and the Instance Home. </h4><p></p><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;">mkdir $ORACLE_BASE/product/em13500<br />mkdir $ORACLE_BASE/product/em13500/em13500<br />mkdir $ORACLE_BASE/product/em13500/gc_inst</span></div><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;"><br /></span></div><p style="text-align: left;">I prefer to have one separate EM Release Base Directory for each release, instead of creating everything in $ORACLE_BASE/product.</p><div style="text-align: left;"><br /></div><h4 style="text-align: left;">Extracting the response files from the installation media</h4><div style="text-align: left;"><span style="font-weight: normal;"><span style="font-family: courier; font-size: x-small;">./em13500_linux64.bin -getResponseFileTemplates -outputLoc /u01/software/em_install</span></span></div><div style="text-align: left;"><span style="font-weight: normal;"><span style="font-family: courier; font-size: x-small;"><br /></span></span></div><div style="text-align: left;"><span style="font-size: 12px; font-weight: normal;"><span style="font-family: courier;"><br /></span></span></div><h4 style="text-align: left;">Preparing some init parameters in the repository database (restart after)</h4><div style="text-align: left;"><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_optimizer_nlj_hj_adaptive_join" scope=both sid='*'; <br /></span></span><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_optimizer_strans_adaptive_pruning" scope=both sid='*';<br /></span></span><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_px_adaptive_dist_method" scope=both sid='*';<br /></span></span><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_sql_plan_directive_mgmt_control" scope=both sid='*';<br /></span></span><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*';<br /></span></span><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_optimizer_use_feedback" scope=both sid='*';<br /></span></span><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_optimizer_gather_feedback" scope=both sid='*';<br /></span></span><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">alter system reset "_optimizer_performance_feedback" scope=both sid='*';</span></span></div><div style="text-align: left;"><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;"><br /></span></span></div><p style="font-stretch: normal; line-height: normal; margin: 0px;"><span style="color: #b42419; font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;">
</span></span></p><p style="font-stretch: normal; line-height: normal; margin: 0px;"><span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: courier; font-size: x-small;"><br /></span></span></p><h4 style="text-align: left;">Adopting upgrade.rsp to the environment</h4><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;"><span style="font-variant-ligatures: no-common-ligatures;">RESPONSEFILE_VERSION=2.2.1.0.0<br /></span>UNIX_GROUP_NAME="dba"<br />INVENTORY_LOCATION=/u01/app/oraInventory<br />INSTALL_UPDATES_SELECTION=skip<br />ORACLE_MIDDLEWARE_HOME_LOCATION=/u01/app/oracle/product/em13500/em13500<br />ORACLE_INSTANCE_HOME_LOCATION=/u01/app/oracle/product/em13500/gc_inst<br />OLD_BASE_DIR=/u01/app/oracle/product/em13400/em13400<br />ORACLE_HOSTNAME=oem1.demo.ch<br />ONE_SYSTEM=true<br />WLS_ADMIN_SERVER_USERNAME=weblogic<br />WLS_ADMIN_SERVER_PASSWORD=manager<br />WLS_ADMIN_SERVER_CONFIRM_PASSWORD=manager<br />NODE_MANAGER_PASSWORD=manager<br />NODE_MANAGER_CONFIRM_PASSWORD=manager<br />WLS_ADMIN_SERVER_PASSWORD=manager<br />DATABASE_HOSTNAME=oem2.demo.ch<br />LISTENER_PORT=1521<br />SERVICENAME_OR_SID=poem1.demo.ch<br />SYS_PASSWORD=manager<br />SYSMAN_PASSWORD=manager<br />EMPREREQ_AUTO_CORRECTION=false<br />REPOSITORY_BACKUP_DONE=true<br />PLUGIN_SELECTION={}<br />b_upgrade=true<br />EM_INSTALL_TYPE=NOSEED</span></div><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;"><br /></span></div><p style="font-family: Menlo; font-size: 12px; font-stretch: normal; line-height: normal; margin: 0px; min-height: 14px;"><br /></p><h4 style="text-align: left;">Stopping the central agent</h4><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;">emctl stop agent</span></div><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;"><br /></span></div><h4 style="text-align: left;">Stopping Enterprise Manager - and only the Enterprise Manager. You'll need a running AdminServer (an an open repository database)</h4><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;">emctl stop oms</span></div><p><span style="font-family: courier; font-size: x-small;"><br /></span></p><h3 style="text-align: left;">Starting the installer</h3><p></p><p></p><ul style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; caret-color: rgb(0, 0, 0); color: black; font-family: -webkit-standard; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;"></ul><p></p><div style="text-align: left;"><span style="font-family: courier; font-size: x-small;"><span style="font-variant-ligatures: no-common-ligatures;">em13500</span><span style="font-variant-ligatures: no-common-ligatures;">_linux64.bin -silent -responseFile /u01/software/em_install/upgrade.rsp</span></span></div><p style="font-stretch: normal; line-height: normal; margin: 0px;"><br /></p><div style="text-align: left;">Waiting, waiting, waiting ... about 30 minutes in my environment. But this can take much longer in real life environments.</div><div style="text-align: left;"><br />To be honest: Because of the missing upgrade instructions, it took two tries to install. In both cases, the installer created a really helpful log file in html format, and left the original installation unchanged.</div><p style="text-align: left;"><br /></p><h3 style="text-align: left;">Finally<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDfesQxVMj8AkxdDXpg74-xBmaGhATNKhbDSEoWiYhO16Co2MmFnQ3ruxQQVsB6hOgNqKJCIFoLLlLkM2Jp6VOMj7POXLc9_Ccjqhzc7La80D00LeKeTtsxxR9am-S5Ib-oP0HPCNKOgs1/s471/EM13500.jpg" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="270" data-original-width="471" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDfesQxVMj8AkxdDXpg74-xBmaGhATNKhbDSEoWiYhO16Co2MmFnQ3ruxQQVsB6hOgNqKJCIFoLLlLkM2Jp6VOMj7POXLc9_Ccjqhzc7La80D00LeKeTtsxxR9am-S5Ib-oP0HPCNKOgs1/s320/EM13500.jpg" width="320" /></a></div></h3><br /><h2 style="text-align: left;">Important</h2><div>An Enterprise Manager Upgrade is - as always - an out-of-place upgrade. Keep in mind that any connection descriptions to LDAP as well as Your certificates are not (!) upgraded / moved to the new installation. So, if You're using LDAP for authentication or having Your own certificates in place: Save the information / the certificate and apply it after the upgrade to the new EM.</div>robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com4tag:blogger.com,1999:blog-969759252355240200.post-35593645508177991322019-09-03T08:39:00.002+02:002019-09-03T08:39:11.756+02:00Enterprise Manager 13.3 - After Upgrade to DB Plugin 13.3.2: Missing 'Top Activities' Page and Empty Graphs when using 'Performance Hub'<span style="font-family: inherit;">oops - long title ... sorry for that</span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">Starting with DB Plugin 13.3.2.0, oracle has kicked out the flash plugin and replaced that with JET (<span style="background-color: white; color: #212121; font-size: 16px;">JavaScript Extension Toolkit</span>). As a consequence, 'Top Activity' page is not available anymore and is replaced by 'Performance Hub' respectively 'Ash Analytics' and 'SQL Monitoring'. </span><br />
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">That's the good news ... the not that good news is: Both pages will show empty graphs in case the monitored database is of version 12.2 (it works correctly with 18c and 19c)</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQrVazaFSdtpMa42FjwEX3-HYu0Y_eiUbEJbOg3UR_OJ5uVJrdUWy-jkAs72itP0OZibGRL8JdBCIurtCcpg-OxE6qoACscx_1I-g5P6jmjl_iLbcFxpsqZ6T2fMTD6-gc6mdMORftceX7/s1600/EmptyASH.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: inherit;"><img border="0" data-original-height="657" data-original-width="1192" height="220" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQrVazaFSdtpMa42FjwEX3-HYu0Y_eiUbEJbOg3UR_OJ5uVJrdUWy-jkAs72itP0OZibGRL8JdBCIurtCcpg-OxE6qoACscx_1I-g5P6jmjl_iLbcFxpsqZ6T2fMTD6-gc6mdMORftceX7/s400/EmptyASH.JPG" width="400" /></span></a></div>
<span style="font-family: inherit;"><br /></span>
<span style="font-family: inherit;">Solution for that can be found in MOS Note <span style="font-size: 11pt;">"Usage Of ASH
Analytics In EM 13.3 PG Release (Doc ID 2580773.1)". Bad news two (,too ;-)): You have to execute the necessary steps in EVERY pluggable database.</span></span><br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com3tag:blogger.com,1999:blog-969759252355240200.post-19379560061413449222019-06-28T11:34:00.001+02:002019-06-28T12:35:21.508+02:00Solution: SQL Developer does not show its Startscreen after starting successfully<h3>
Problem: </h3>
After starting SQL Developer 18.4 on a Windows 10, the SQL Developer tile is shown in the taskbar, but the Startscreen is not shown on the desktop.<br />
<br />
<h3>
"Quick and Dirty" Solution</h3>
<br />
<ul>
<li>Stop SQL Developer. </li>
<li>Open Windows Explorer and type "%APPDATA%\SQL Developer" in the Directory/URL bar. You'll see a directory named according the SQL Developer release (for example, something like "system18.4.0.376.1900"). </li>
<li>Rename this directory.</li>
<li>Start SQL Developer - the directory is re-created, everything should work fine again. If SQL Developer comes up correctly, delete the renamed directory from "%APPDATA%\SQL Developer"</li>
<li>get back to work ... ;-)</li>
</ul>
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-12953083278623401172019-06-21T13:58:00.002+02:002019-06-24T10:19:51.999+02:00Enterprise Manager - Advanced Backup Strategies<br />
<div class="MsoNormal" style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;"><span style="font-family: inherit;">Oracle's </span>recommendation for an Enterprise Manager backup can be found in
"Enterprise Manager Cloud Control Advanced Installation and Configuration
Guide", chapter "Backing Up and Recovering Enterprise Manager". <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;">Basically, the recommendation consists of (only) three steps:<o:p></o:p></span></div>
<div class="MsoListParagraph" style="line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 14.2pt; margin-right: 0in; margin-top: 6.0pt; mso-list: l0 level1 lfo1; text-indent: -14.2pt;">
<!--[if !supportLists]--><span lang="EN-US" style="font-family: "symbol"; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";"> </span></span></span><!--[endif]--><span lang="EN-US" style="mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";">Software Library Backup<o:p></o:p></span></div>
<div class="MsoListParagraph" style="line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 14.2pt; margin-right: 0in; margin-top: 6.0pt; mso-list: l0 level1 lfo1; text-indent: -14.2pt;">
<!--[if !supportLists]--><span lang="EN-US" style="font-family: "symbol"; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";"> </span></span></span><!--[endif]--><span lang="EN-US" style="mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";">Management Repository Backup<o:p></o:p></span></div>
<div class="MsoListParagraph" style="line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 14.2pt; margin-right: 0in; margin-top: 6.0pt; mso-list: l0 level1 lfo1; text-indent: -14.2pt;">
<!--[if !supportLists]--><span lang="EN-US" style="font-family: "symbol"; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";"> </span></span></span><!--[endif]--><span lang="EN-US" style="mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";">Oracle Management Service Backup <o:p></o:p></span></div>
<div class="MsoListParagraph" style="line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 28.35pt; margin-right: 0in; margin-top: 6.0pt; mso-list: l1 level2 lfo2; text-indent: -14.15pt;">
<!--[if !supportLists]--><span lang="EN-US" style="font-family: "symbol"; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";"> </span></span></span><!--[endif]--><span lang="EN-US" style="mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";">Exportconfig<o:p></o:p></span></div>
<div class="MsoListParagraph" style="line-height: 115%; margin-bottom: .0001pt; margin-bottom: 0in; margin-left: 28.35pt; margin-right: 0in; margin-top: 6.0pt; mso-list: l1 level2 lfo2; text-indent: -14.15pt;">
<!--[if !supportLists]--><span lang="EN-US" style="font-family: "symbol"; mso-ansi-language: EN-US; mso-bidi-font-family: Symbol; mso-fareast-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt "Times New Roman";"> </span></span></span><!--[endif]--><span lang="EN-US" style="mso-ansi-language: EN-US; mso-fareast-font-family: "Times New Roman";">Software Homes<o:p></o:p></span></div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;">But we have a lot more important stuff within Enterprise Manager which
is worth to be backed up, haven't we? Monitoring Templates for example, Metric
Extensions or properties which were changed (either possibly or probably), …
But, where to get this information from and how to extract it from Enterprise
Manager's guts? Repository, emctl and emcli are the keywords – here's how to …:</span><br />
<span lang="EN-US" style="mso-ansi-language: EN-US;"><br /></span></div>
<h3 style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;">Software Library Backup</span></h3>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;">… of course worth a frequent backup. IMHO the best way to get the latest
information about the current path is to query the repository database:<o:p></o:p></span></div>
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;">select<br /> </span><span style="font-family: "courier new" , "courier" , monospace;"> base_path<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">from EM_SWLIB_OMS_LOCATIONS_E<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">where name ='default_loc';</span></blockquote>
<span lang="EN-US" style="mso-ansi-language: EN-US;">Put the result in a variable and issue something like this:</span><br />
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;">tar cvfz software_library.tar $<variableName>/*</span></blockquote>
<br />
<h3>
Management Repository Backup</h3>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;">… as a DBA You know how to backup an oracle database. I'm sure … <o:p></o:p></span></div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<br /></div>
<h3 style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;">Oracle Management Service Backup</span></h3>
… as oracle's manual states, use<br />
<div>
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;">emctl exportconfig oms</span></blockquote>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<br /></div>
<h3 style="margin-top: 6.0pt;">
<span lang="EN-US" style="mso-ansi-language: EN-US;">And the additional stuff, I was talking about?</span></h3>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<h4>
<span lang="EN-US" style="mso-ansi-language: EN-US;">OMS Properties</span></h4>
<span lang="EN-US" style="mso-ansi-language: EN-US;">Backup the </span><b>OMS properties</b><span lang="EN-US" style="mso-ansi-language: EN-US;"> – even if You've never changed them –
by issuing an </span><br />
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;">emctl list properties</span></blockquote>
Redirect the result to a file having a timestamp or a sequential number in its filename and You're save.</div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<br /></div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<h4>
<span lang="EN-US" style="mso-ansi-language: EN-US;">Monitoring Templates</span></h4>
<span lang="EN-US" style="mso-ansi-language: EN-US;">To backup<b> Monitoring Templates</b> use this SQL, spool the output to
a file and execute the file: <o:p></o:p></span></div>
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;">select<br /> </span><span style="font-family: "courier new" , "courier" , monospace;"> 'emcli export_template -name='''||template_name||''' -target_type='||target_type||' -output_file=$BACKUP_DIR/MT_'||template_name||'.xml'<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">from sysman.mgmt_templates<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">where is_public = 0<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">order by template_name ;</span></blockquote>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<h4>
Metric Extensions</h4>
Developing <b>Metric Extensions</b> is a time consuming task – so backup
the MEs frequently. It is that easy (spool and execute the spool file):</div>
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;">select<br /> </span><span style="font-family: "courier new" , "courier" , monospace;"> 'emcli export_metric_extension -file_name=''$BACKUP_DIR/'||name||'_V'||version||'.xml'' -target_type='||target_type||' -name='''||name||''' -version='||version<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">from SYSMAN.EM_MEXT_VERSIONS_E<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">order by name, version;</span></blockquote>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<h4>
Incident Rulesets</h4>
Your <b>Incident Rulesets</b> are candidate to be backed up, too (spool
and execute):</div>
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace;">select<br /> </span><span style="font-family: "courier new" , "courier" , monospace;"> 'emcli export_incident_rule_set -rule_set_name='||ruleset_name||' -rule_set_owner='||owner||' -export_file="$BACKUP_DIR"'<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">from EM_RULE_SETS<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">where owner not in ('SYSMAN', '<SYSTEM>')<br /> </span><span style="font-family: "courier new" , "courier" , monospace;">order by owner, ruleset_name;</span></blockquote>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<br /></div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<h4>
<span lang="EN-US" style="mso-ansi-language: EN-US;">Information Publisher Reports</span></h4>
<span lang="EN-US" style="mso-ansi-language: EN-US;">Did You write <b>Information Publisher Reports</b>? Backup them </span><span style="background-color: white; color: #404040; font-family: "Open Sans", sans-serif; font-size: 13px;">(redirect to a file and execute)</span>!:</div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<blockquote class="tr_bq">
<span lang="EN-US" style="font-family: "courier new"; mso-ansi-language: EN-US;">emcli get_reports | sed "s/, /
/g" | awk 'BEGIN{ FS=","}{x=$1; gsub(/ |-|=|:|\/|\(|\)/,
"",x); print "emcli export_report -title="$1"
-owner="$2" -output_file=${BACKUP_DIR}/REP_"x".xml" }'</span></blockquote>
</div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<br /></div>
<div class="MsoNormal" style="margin-top: 6.0pt;">
<h4>
Interested in more possibilities? </h4>
<span lang="EN-US" style="mso-ansi-language: EN-US;">emcli offers some more export commands
– "emcli help | grep -I export" extracts them from emcli's help text. Perhaps You'll find the one You're searching for.</span></div>
<br />
<h3>
Questions?</h3>
Get in contact ...<br />
<br />
<br />
<br />
<br /></div>
robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-9099555701639766802019-04-23T09:18:00.001+02:002019-04-23T09:18:42.497+02:00Follow up: Upgrading Enterprise Manager 13.2 to 13.3 - missing 'Update' Option in GUIFirst of all, thanks a lot to Martin Decker for his comment and the description how he could solve that problem. Tried that, but unfortunately, these changes alone did not help. I opened a SR and got a recommendation how to solve the problem, exactly designed for my environment. Beside the tasks Martin described, I had to edit some libraries in the directory tree <OMS_HOME>/inventory/featuresets/. <br />
<br />
I asked Oracle Support if I'm allowed to publish the solution, but they said:<br />
<br />
"<span style="font-family: Georgia, Times New Roman, serif;">We are still waiting for bug fix for a permanent solution and the workaround may or may not suitable for all situations where upgrade option not available. There are chances like inventory details missing also can cause the similar issue hence its better to log a new request if there are any concerns to verify the install logs/screens and provide solution/workaround</span>"<br />
<br />
So, in case You face the 'missing update option, too, please log a Service Request using the keywords "<a href="https://support.oracle.com/epmos/faces/BugDisplay?id=28350114&parent=SrDetailText&sourceId=3-19893818301" target="_blank" title="View bug in a new browser tab">Bug 28350114</a> : EM 13.3 Upgrade, Installation Types Screen Is Not Showing the Upgrade Option" and supply the install logs.<br />
<br />
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com2tag:blogger.com,1999:blog-969759252355240200.post-50403932994718654722019-04-17T08:25:00.001+02:002019-04-17T08:25:13.181+02:00Upgrading Enterprise Manager 13.2 to 13.3 - missing 'Update' Option in GUITried to upgrade an Enterprise Manager Cloud Control 13.2 to the next level of happiness - 13.3 - like I did that for several installations. Unfortunately, the 'Upgrading an existing Enterprise Manager System' option in the 'Installation Types' section of the installation GUI is not available. Usually, this behaviour points to an unavailable or corrupt Oracle Inventory. As additional possibility, it could be a bug as well:<br />
Check MOS Note "<span style="background-color: white; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 14.3px; font-weight: 700; text-align: right;">EM 13c: Checklist for Upgrading Enterprise Manager Cloud Control from Version 12.1.0.5/13.1/13.2 to 13.3 (Doc ID 2418352.1)</span>",<span style="font-family: inherit;"> the 'Known Issues' section: "<span style="background-color: white;">Bug 28350114 : EM 13.3 Upgrade, Installation Types Screen Is Not Showing the Upgrade Option"</span></span>robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com2tag:blogger.com,1999:blog-969759252355240200.post-76093393723189221092019-04-17T08:13:00.000+02:002019-04-17T08:35:50.344+02:00Copy MOS-Note URL'sPerhaps You've had that problem, too ... Something has changed with My Oracle Support URLs. Simply copying the url of an already opened MOS document and sending it to a collegue or pasting it into a doc will not give the expected result, i.e., forwarding to the expected document. But how to get the URL? Can be simply as that: Right click on the document's link, 'Copy link address' and You're done ... *wacko*robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com1tag:blogger.com,1999:blog-969759252355240200.post-38404183984253789972019-01-14T13:33:00.000+01:002019-01-14T14:22:37.843+01:00Enterprise Manager 13c - 'Tablespace Space Used %' metric sends false alarms<h3>
Situation is ...</h3>
Metric 'Tablespace Space Used %' is used to monitor the free space of the tablespaces. Sometimes You'll get an alarm that the Tablespace has reached it's critical value. But, the tablespace's data files are auto extensible and far away from the max size and the files are located on an ACFS which knows also auto-extensibility - or better said - an auto-resize feature. There is also plenty of space left on the underlying ASM. Nevertheless, FS free space is currently near to 100% and the <u>current</u> free space in the tablespace is lower than the critical value. Obviously a false alarm, isn't it?<br />
<h3>
Cause ...</h3>
for that behaviour is, that Oracle has changed the method to calculate a tablespace's free space for metric 'Tablespace Space Used %' with release 13c. New is that the metric takes the available disk space into account for its calculations. And this is correct , because no more space left on the disk means finally that a tablespace cannot auto-extend anymore. But with ACFS and the auto resize functionality, this shouldn't be a problem at all - ACFS will auto resize the FS if necessary.<br />
<br />
Unfortunately, Oracle Support has no fix for this false alarm at this very moment. MOS says that view DBA_TABLESPACE_USAGE_METRICS has a problem to calculate the metric's base information correctly. Well, that might be a possible reason, but IMHO, the values of my particular database / tablespaces / datafiles are fine.<br />
<h3>
Solution / Workaround</h3>
Simply set the value of the auto resize parameter for the ACFS filesystem in question to an appropriate value other than the default of 20G, to avoid the false alarm problem (until the ASM runs full and ACFS cannot auto resize):<br />
"<span style="font-family: "courier new" , "courier" , monospace;">acfsutil size -a <Size>G <FSName></span>"<br />
<br />
<b>Example:</b><br />
<pre style="font-family: "courier new"; margin: 0cm 0cm 0.0001pt;"><span class="line"><span lang="IT">acfsutil size -a 100G /u02/oradata/TESTDB</span></span></pre>
<pre style="font-family: "courier new"; margin: 0cm 0cm 0.0001pt;"><span class="line"><span lang="EN">acfsutil size: ACFS-03642: successfully updated auto-resize settings</span></span></pre>
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com1tag:blogger.com,1999:blog-969759252355240200.post-76396231789401912202018-12-21T14:35:00.000+01:002018-12-21T14:47:25.343+01:00ODA Server Patch 18.3 available - and installed ...Since today, Oracle Database Appliance software release 18.3.0.0.0 is available ... I took the chance to download and install the new release - this is the story:<br />
<br />
<h3>
Initial Situation:</h3>
I tested the update on an ODA X7-2M with system version 12.2.1.4.0, running five databases (12.1). There are three vlans configured on that system.<br />
<br />
<h3>
Documentation used:</h3>
Installation Instruction was taken from docs.oracle.com, Oracle Database Appliance, Release 18.3, X7-2 Deployment and User's Guide for Linux x86-64, Chapter 7 Patching Oracle Database Appliance, subchapter 'Patching Oracle Database Appliance Using the CLI'<br />
<br />
<h3>
Remarks:</h3>
- You have to download about 15GB - just for the system update, DB 18.x is around 4GB<br />
- do not copy the update software to a NFS share and do not run the update from this directory<br />
- if You are using NFS shares, be sure that a df -h comes back immediately. With my testsystem I had two NFS Filesystems which were not reachable at all, resulting in a 'never-come-back' df -h - this, in turn, resulted in a stuck Server Patching at step 'Configuring GI'. After I umounted those FS (by using the -f switch), the patching continued<br />
- qosmserver has to run and a crs resource ora.net1.network has to be configured<br />
- the patch documentation is missing the hint to first update dcsagent (odacli upgrade-dcsagent -v 18.3.0.0.0), but it's a prerequisite<br />
- remove any 'non-default' entries from oracle's .bash_profile prior to the update<br />
- Step 'Setting AUDIT SYSLOG LEVEL' had a status 'Failure' at the end of the update process - overall status of the update was - nevertheless - successful (will check the reason for that failure later)<br />
- Installation documentation says after step 'apply the server update' to check if the update was successful and then to issue an 'odacli update-storage'. ATTENTION! After a successful update, the server will reboot! Wait until the system is up again before You start the update-storage command!<br />
- Server reboot took about 10 Minutes with my X7-2M<br />
- Documentation example for 'Update the storage components' is not correct: use '--rolling' or '-r' instead of '-rolling'<br />
- update-storage using the '--rolling' option is not supported on ODAlite<br />
<br />
<h3>
That's it</h3>
The whole process took slightly more than one hour - and remember: the system reboots after an successful 'odacli update-server' (!)<br />
<br />
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-57118655211611864022018-12-07T09:35:00.004+01:002018-12-07T09:36:56.038+01:00ODA - Update to 12.2.1.4 - issue with ora.net1.networkYesterday, I had to update an ODA from Release 12.1.2.12 to 12.2.1.4 . All prerequisite checks including prepatchreport were successful ... but the update itself not!<br />
<br />
During the update, at stage 'GI Home Cloning', the update process failed and left the system in an 'unknown' state. A detailled analysis has shown the root cause: crs service qosmserver is missing. So, I tried to setup this missing link to a successful update:<br />
<br />
<span style="font-family: "courier new" , "courier" , monospace;">srvctl add qosmserver</span><br />
<span style="font-family: "courier new" , "courier" , monospace;">srvctl status qosmserver</span><br />
<span style="font-family: "courier new" , "courier" , monospace;">srvctl start qosmserver</span><br />
<br />
But, qosmserver could not be started - resource 'ora.net1.network' is missing. Well, that's absolutely true - we do not have such a resource defined for our ODAs. Finally changed the first of our vlan definitions to ora.net1.network and could start qosmserver.<br />
<br />
Unfortunately and because of the interrupted update, GI is now using its 12.2 home, but odacli describe-component shows, that the current home is the old 12.1 - that finally results in a situation where I cannot run update-server again (GI Home Cloning fails, because the new GI Home already exists)<br />
<br />
<h3>
Outcome: As additional prerequisite, check, wether or not the resource ora.net1.network exists on Your ODA and be sure qosmserver is up and running BEFORE starting an 'odacli update-server'.</h3>
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-12667435092695393552018-11-07T14:45:00.000+01:002018-11-07T14:45:19.668+01:00DBID Problem @ ODA - or Count von Count (Sesame Street) calculates DBIDsI did some more investigations to get an explanation for that problem with the extra long DBIDs and the resulting problems when creating new databases on an ODA ...<br />
<br />
<h3>
And here's the simple result:</h3>
Remember? In our environment, oracle's .bash_profile runs an additional script, which prints all - at this very moment existing - oracle databases, listeners, their status and the according ORACLE_HOMEs to STDOUT. Output looks like this:<br />
<br />
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">######################################################<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"># Following Databases/Aliases are on the ODA oda-o1234<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">######################################################<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">================================================================================<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">SID/PROCESS STATUS E_ORACLE_HOME<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">--------------------------------------------------------------------------------</span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">+ASM1 up /u01/app/12.2.0.1/oracle<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">TEST1 up /u01/app/oracle/product/12.1.0.2/dbhome_1<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">TEST2c up /u01/app/oracle/product/12.1.0.2/dbhome_1<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">TEST2D up /u01/app/oracle/product/12.1.0.2/dbhome_1<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">TEST2E up /u01/app/oracle/product/12.1.0.2/dbhome_1<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "Courier New"; font-size: 11pt;">LISTENER up /u01/app/12.2.0.1/oracle</span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "Courier New"; font-size: 11pt;"><br /></span></div>
Now, take all numbers from this output, put them in one line, add the 'real' DBID from the database - and You'll have the dbid which is displayed (and used) by odacli in the internal derby database. :-)<br />
<br />
<h3>
The easy test:</h3>
<h4>
Add two 'echo' lines to oracle's .bash_profile that it looks like this:</h4>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"># Get the aliases and functions<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">if [ -f ~/.bashrc ]; then<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> . ~/.bashrc<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">fi<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"># User specific environment and startup programs<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">PATH=$PATH:$HOME/bin<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">export PATH<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">umask 022<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "Courier New"; font-size: 11pt;"><b>echo "1111111111111111111111111111111111111111111111111"</b></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "Courier New"; font-size: 11pt;"><b>echo "2222222222222222222222222222222222222222222222222"</b></span></div>
<br />
<h4>
Create a database using the 'odacli create-database' command:</h4>
<span style="caret-color: rgb(0, 0, 0); font-family: "Courier New"; font-size: 14.6667px; text-size-adjust: auto;">odacli create-database -m -dh 665b9ce4-3a13-4a04-8ccd-548e66556def -n TEST2F -r ACFS</span><br />
<span style="caret-color: rgb(0, 0, 0); font-family: "Courier New"; font-size: 14.6667px; text-size-adjust: auto;"><br /></span>
<h4>
When the database is created, issue an 'odacli list-databases' and, subsequently, an 'odacli describe-database -i <id of that database>' - check the DBID (concatenated echo "1"s plus the echo "2"s plus the 'real' DBID):</h4>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">Database details<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">----------------------------------------------------------------<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> ID: 2a5426bc-8db9-4d07-ba87-b54f06dbbcc3<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Description: TEST2F<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> DB Name: TEST2F<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> DB Version: 12.1.0.2<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> </span><span lang="FR-CH" style="font-family: "Courier New";">DB Type: Si<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="FR-CH" style="font-family: "Courier New";"> DB Edition: EE<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="FR-CH" style="font-family: "Courier New";"> <span class="Apple-converted-space"> </span></span><span lang="EN-US" style="font-family: "Courier New";">DBID: <b>11111111111111111111111111111111111111111111111112222222222222222222222222222222222222222222222222</b><i><b><u>2498916505</u></b></i><o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">Instance Only Database: false<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> CDB: false<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> PDB Name:<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> PDB Admin User Name:<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Class: OLTP<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Shape: Odb1<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Storage: ACFS<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> CharacterSet: AL32UTF8<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> National CharacterSet: AL16UTF16<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Language: AMERICAN<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Territory: AMERICA<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Home ID: 665b9ce4-3a13-4a04-8ccd-548e66556def<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Console Enabled: false<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Level 0 Backup Day: Sunday<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> AutoBackup Disabled: false<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> Created: November 7, 2018 12:58:45 PM CET<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> DB Domain Name: world</span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"><br /></span></div>
<h4 style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif;">The database's DBID - which is the last portion in odacli's DBID:</span></span></h4>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";">SQL> select dbid from v$database;<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: "Courier New";"> <span class="Apple-converted-space"> </span></span><span style="font-family: "Courier New";">DBID<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "Courier New";">----------<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "Courier New";">2498916505</span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "Courier New";"><br /></span></div>
<h4 style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
Imho, the answer for question 'Bug or Feature?' is quite clear ;-) And, by the way, Oracle Support is still investigating the problem.</h4>
<div>
<br /></div>
<div>
<br /></div>
robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-33288264985466999492018-10-20T07:57:00.001+02:002018-11-14T23:12:30.209+01:00Update! - Unexpected Behaviour With V$DIAG_ALERT_EXT<h3>
Oops! Errormessages from a Test database in my Production-DB?!?</h3>
<br />
<h4>
Story behind:</h4>
I wanted to know which "ORA-" Errors have occured in my Production-DB and issued a<br />
<blockquote class="tr_bq">
<div style="margin-bottom: 0; margin-top: 0;">
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">select </span></span></div>
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">
</span></span>
<br />
<div style="margin-bottom: 0; margin-top: 0;">
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;"> to_char(originating_timestamp,'DD.MM.YYYYHH24:MI:SS')</span></span></div>
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">
</span></span>
<br />
<div style="margin-bottom: 0; margin-top: 0;">
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;"> ,message_text </span></span></div>
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">
</span></span>
<br />
<div style="margin-bottom: 0; margin-top: 0;">
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">from v$diag_alert_ext </span></span></div>
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">
</span></span>
<div style="margin-bottom: 0; margin-top: 0;">
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">where message_text like '%ORA-%' </span></span></div>
<span style="font-family: "courier new" , "courier" , monospace;"><span style="color: black; font-size: small;">
<div style="margin-bottom: 0; margin-top: 0;">
and originating_timestamp > sysdate-31 </div>
<div style="margin-bottom: 0; margin-top: 0;">
order by originating_timestamp;</div>
</span></span></blockquote>
to have an overview about the current - let me say - error situation. So far - so good ...<br />
<br />
Yesterday, I've found messages from a <b>TEST</b> database when querying the PRODUCTION db, which made me uncertain:<br />
"<span style="font-family: "courier new" , "courier" , monospace;">Errors in file /u01/app/oracle/diag/rdbms/<b>TEST</b>/<b>TEST</b>/trace/<b>TEST</b>_j000_45562.trc</span>"<br />
<br />
<h4>
Checked that - and discussed it with some collegues ... outcome is:</h4>
The View V$DIAG_ALERT_EXT does not only contain information from the current DB but from all databases on that system / from that diagnostic_dest:<br />
<blockquote class="tr_bq">
<span style="font-family: "courier new" , "courier" , monospace; font-size: xx-small;"><span style="-webkit-font-kerning: none;">select</span><span style="-webkit-font-kerning: none;"> distinct component_id,filename<br /> </span><span style="-webkit-font-kerning: none;">
from v$diag_alert_ext<br /> </span><span style="-webkit-font-kerning: none;">
order by 1,2;</span><br /><span style="-webkit-font-kerning: none;">COMPONENT_ID FILENAME</span><br /><span style="-webkit-font-kerning: none;">------------ -----------------------------------------------------------------------</span><br /><span style="-webkit-font-kerning: none;">apx /u01/app/oracle/diag/apx/+apx/+APX1/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">asm /u01/app/oracle/diag/asm/+asm/+ASM1/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">clients /u01/app/oracle/diag/clients/user_oracle/host_4163035053_107/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">clients /u01/app/oracle/diag/clients/user_oracle/host_4163035053_82/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">crs /u01/app/oracle/diag/crs/host/crs/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest1/DBTEST1/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest10/DBTEST10/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest11/DBTEST11/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest12/DBTEST12/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest13/DBTEST13/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest14/DBTEST14/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest2/DBTEST2/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest3/DBTEST3/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest4/DBTEST4/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest5/DBTEST5/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest6/DBTEST6/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest7/DBTEST7/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest8/DBTEST8/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/dbtest9/DBTEST9/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">rdbms /u01/app/oracle/diag/rdbms/rocrtest/rocrtest/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">tnslsnr /u01/app/oracle/diag/tnslsnr/host/asmnet1lsnr_asm/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">tnslsnr /u01/app/oracle/diag/tnslsnr/</span><span style="-webkit-font-kerning: none; background-color: white; direction: ltr; font-stretch: normal; line-height: normal; unicode-bidi: embed;">host</span><span style="-webkit-font-kerning: none; direction: ltr; unicode-bidi: embed;">/listener/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">tnslsnr /u01/app/oracle/diag/tnslsnr/</span><span style="-webkit-font-kerning: none; background-color: white; direction: ltr; font-stretch: normal; line-height: normal; unicode-bidi: embed;">host</span><span style="-webkit-font-kerning: none; direction: ltr; unicode-bidi: embed;">/listener_511/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">tnslsnr /u01/app/oracle/diag/tnslsnr/</span><span style="-webkit-font-kerning: none; background-color: white; direction: ltr; font-stretch: normal; line-height: normal; unicode-bidi: embed;">host</span><span style="-webkit-font-kerning: none; direction: ltr; unicode-bidi: embed;">/listener_576/alert/log.xml</span><br /><span style="-webkit-font-kerning: none;">tnslsnr /u01/app/oracle/diag/tnslsnr/</span><span style="-webkit-font-kerning: none; background-color: white; direction: ltr; font-stretch: normal; line-height: normal; unicode-bidi: embed;">host</span><span style="-webkit-font-kerning: none; direction: ltr; unicode-bidi: embed;">/listener_580/alert/log.xml</span></span></blockquote>
<h4>
Well - that was unexpected ... </h4>
Question is: Bug or feature? I'll open a SR and keep You up to date ...<br />
By the way: Made these tests on different oracle releases: 11.2, 12.1, 12.2.<br />
<br />
<h3>
Update (November 14th, 2018)</h3>
Opened a Service Request - and Oracle Support brought an explanation:<br />
<br />
"<span style="background-color: #fafafa; caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;">We have verified it. It is an expected scenario. As stated earlier V$DIAG_ALERT_EXT displays trace file and alert file data for the current container (It means all PDB) in a CDB (Even though you connect as ALTER SYSTEM SET CONTAINER - it will show all the database because all database resides on ORACLE HOME).</span><span style="background-color: #fafafa; caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;"> </span><br />
<br style="caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;" /><span style="background-color: #fafafa; caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;">Actually, V$DIAG_ALERT_EXT read the logs of all databases and listeners from the ADR Location (ORACLE HOME Directory) So, one connection to a database is enough to see all the database alert files and listener logs registered inside the ADR structure. </span><br style="caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;" /><br style="caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;" /><span style="background-color: #fafafa; caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;">So, this is an expected one. And not a BUG! </span><br style="caret-color: rgb(0, 61, 91); color: #003d5b; font-family: Tahoma, Verdana, Helvetica, sans-serif; font-size: 11px;" />"<br />
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com6tag:blogger.com,1999:blog-969759252355240200.post-14414380281893764192018-10-20T07:42:00.001+02:002018-10-20T07:42:46.202+02:00REASON FOUND: DBID Problem @ ODAHi There!<br />
<br />
in my blogpost "<a href="http://robertcrames.blogspot.com/2018/10/oda-bug-and-poor-support-from-oracle.html">http://robertcrames.blogspot.com/2018/10/oda-bug-and-poor-support-from-oracle.html</a>" I described a problem with the impossibility of creating databases as a result of an incredebly long DBID and the 'poor' oracle support in that specific case.<br />
<br />
Well - I contacted Oracle support and had a call with the Support Manager and then ... it worked smoothly 😏. Provided a few more information and Oracle support had an idea:<br />
<br />
'Remove any changes from the .bash_profile and try again' ... Unfortunately, we made no changes on root's .bash_profile (which is the 'initiator' of the create database process) :-( - but we made some changes on oracle's .bash_profile. One of these changes was, to set oracle's primary environment to Grid Infrastructure' instance +ASM1. Removed that entry, retried the 'odacli create-database' - and ... it works - DBID is correct and plausible, everything runs fine. :-)<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-3231376600503690622018-10-12T11:50:00.000+02:002018-10-19T15:25:58.503+02:00DBID Problem @ ODA ... Bug (?) <h3>
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: small;">long story told short: </span></h3>
<br />
<ul>
<li>Oracle Database Appliance X6-2M and X7-2M, </li>
<li>oak 12.1.2.11 up to 12.2.1.4</li>
</ul>
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;">We were not able to create databases anymore on one of our 15 ODAs. Detailled analysis has shown that the dbid - result from an 'odacli describe-database -i <DB identifier>' - grows and grows and, when it reaches a size of more than 255 characters, any subsequent try to create a database will fail and leave the database in status 'creating'. No more databases can be created, neither can You delete the database which is left in status 'creating'.</span><br />
<span style="font-family: "times" , "times new roman" , serif;"><br /></span>
<br />
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-size: 11pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">This is what a correct DBID (result from a describe-database) looks like: </span><span style="font-family: "courier new" , "courier" , monospace;">1653395885</span><span style="font-family: "times" , "times new roman" , serif;"> </span><span style="font-family: "arial" , "helvetica" , sans-serif;">- btw: this is exactly the real dbid found in the database</span><span style="font-family: "times" , "times new roman" , serif;"> (</span><span style="font-family: "courier new" , "courier" , monospace;">select dbid from v$database</span><span style="font-family: "times" , "times new roman" , serif;">).</span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: "times" , "times new roman" , serif;"><br /></span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-size: 11pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">An - imho - 'corrupted' DBID looks like this:</span><span style="font-family: "times" , "times new roman" , serif;"> </span><span style="font-family: "courier new" , "courier" , monospace;">2791133100113200112102253200112102127320011210212832001121021533200112102154320011210215632001121021573200112102159320011210217323200112102177232001121021793200112102181320011210218323200112102186320011210215800112102576011210251101121021196170968</span></span><span style="font-family: "times" , "times new roman" , serif; font-size: 11pt;"> - </span><span style="font-size: 11pt;"><span style="font-family: "arial" , "helvetica" , sans-serif;">the last 'n' numbers represent the real dbid </span></span><span style="font-family: "times" , "times new roman" , serif; font-size: 14.6667px;">(</span><span style="font-size: 14.6667px;"><span style="font-family: "courier new" , "courier" , monospace;">select dbid from v$database</span></span><span style="font-family: "times" , "times new roman" , serif; font-size: 14.6667px;">).</span></div>
<span style="font-family: "times" , "times new roman" , serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">Side effect, when the database creation has failed: </span><br />
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "courier new" , "courier" , monospace;">odacli list-databases<o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: "courier new" , "courier" , monospace;">DCS-10001:Internal error encountered: could not execute query.</span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: "times" , "times new roman" , serif;"><br /></span></span></div>
<h3 style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Would be great if You could do this:</span></h3>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
</div>
<ul>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">If You have more than five databases on an ODA, issue an 'odacli list-databases'</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">take the id from the last created database and issue an 'odacli describe-database -i <id>'</span></li>
<li><span style="font-family: "arial" , "helvetica" , sans-serif;">Post the result as a comment in this blog</span></li>
</ul>
<br />
<h3 style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: "arial" , "helvetica" , sans-serif;">Regarding oracle support:</span></span></h3>
<div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: "arial" , "helvetica" , sans-serif;">The Service Request is now open since weeks. Started as a Sev 2, relatively early changed sev to 1. The SR is updated from oracle support very rarely, usually no answer at all when I update the SR. In the meantime I escalated the SR, asked for a recall from a manager - no result and no recall. Today asked for another recall from another manager - will see how long that will take. </span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: "arial" , "helvetica" , sans-serif;">@OracleSupport: that is very poor ... leaving customers helpless and uninformed with such severe Problems. Very disappointing ...</span></span></div>
</div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
</div>
robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-81193330833893541672018-08-08T17:09:00.002+02:002018-08-08T17:09:57.053+02:00ODA X7 – no network connect after setup / re-image<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 11pt; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><b>Yesterday,</b><span style="font-size: 11pt;"> I’d prepared an all new X7-2M. During the setup process / network configuration (using VLAN), I ran into a problem: Despite the network configuration was setup absolutely correct, any try to connect to the system from a jumphost was unsuccessful.</span><span class="Apple-converted-space" style="font-size: 11pt;"> </span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 11pt; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><b>Long story short:</b><span style="font-size: 11pt;"> If You want to use the SFP28 (Fiberchannel) ports an ODA X7 offers, You have to do some config changes, to make it work. </span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 11pt; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US">First of all: do a firmware upgrade to version 20.08.01.14 or above. </span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 11pt; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US">Next, configure the nic / nics to force the speed to 10000 and turn off autonegotiation.<span class="Apple-converted-space"> </span><o:p></o:p></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 11pt; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span class="Apple-converted-space"><br /></span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 11pt; line-height: 13pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US">The firmware as well as a detailed description of all necessary steps can be found in MOS Note 2373070.1 ‘Using the onboard SFP28 ports on an ODA X7-2 server node’</span></div>
robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com1tag:blogger.com,1999:blog-969759252355240200.post-27515097980359237172018-08-08T16:48:00.002+02:002018-08-08T16:48:51.802+02:00How to copy Files to an ODA which is not available via network - by using the network Sounds a little weird, I know - but works ... *lol*<br />
<br />
<h3>
<span style="font-size: small;">Problem was: </span></h3>
The all new ODA has installed old firmware for the SPF28 interfaces. This makes it impossible to connect the system to the network. To upgrade the interfaces You need to have the firmware files on the ODA ... but how can I copy the firmware to the ODA without a network connect?<br />
<br />
<h3>
<span style="font-size: small;">Solution:</span></h3>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif;">First of all: create an ISO File from the Files You want to have in a virtual cd. With a mac, this is quite easy to do: start disk utility, then 'File / New Image / Image from Folder' and follow the instructions. Disk Utility will create a dmg file which hast to be reamed to iso. That's it, basically.<span style="font-size: 11pt;"><o:p></o:p></span></span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<h3 style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif; font-size: small;">Next steps:</span></span></h3>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif;">Open a browser window an connect to the ILOM (https://<ilom's hostname or ip></span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif;">Login by using ILOM's root account</span><span style="font-family: Arial, sans-serif; font-size: 11pt;"><o:p></o:p></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUzNnysAowSkb7h8lGZZnUkT41vCs7okqodf4jv8ViaT6rZADCvE0ryK63Hyt5uoj1AL-aVr24cSAE5yatmokfFsCqP8QN_-cceZDTw1fhPAHTbpRfPc3w0oyXrPn15ZJJ_AXf2a4w74yP/s1600/login-ilom.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="516" data-original-width="1029" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiUzNnysAowSkb7h8lGZZnUkT41vCs7okqodf4jv8ViaT6rZADCvE0ryK63Hyt5uoj1AL-aVr24cSAE5yatmokfFsCqP8QN_-cceZDTw1fhPAHTbpRfPc3w0oyXrPn15ZJJ_AXf2a4w74yP/s400/login-ilom.jpg" width="400" /></a></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif;">Launch console</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcl6zupv9-qv2awnLi6a7bhaY2VySSJK2esug-yXc4g9iGFjiBgDPc8kp2Tt0vWgCuXPk7SJejVwZRkvk8jm0tzW-bYZZLaFlSWVHXewEQGdFLt49htLqzfHMOJflFH8KM0DvPdmcmFizd/s1600/launch-console.jpg" imageanchor="1"></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcl6zupv9-qv2awnLi6a7bhaY2VySSJK2esug-yXc4g9iGFjiBgDPc8kp2Tt0vWgCuXPk7SJejVwZRkvk8jm0tzW-bYZZLaFlSWVHXewEQGdFLt49htLqzfHMOJflFH8KM0DvPdmcmFizd/s1600/launch-console.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="471" data-original-width="960" height="196" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgcl6zupv9-qv2awnLi6a7bhaY2VySSJK2esug-yXc4g9iGFjiBgDPc8kp2Tt0vWgCuXPk7SJejVwZRkvk8jm0tzW-bYZZLaFlSWVHXewEQGdFLt49htLqzfHMOJflFH8KM0DvPdmcmFizd/s400/launch-console.jpg" width="400" /></a></div>
<br />
<br />
<span style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><span style="font-family: Times, Times New Roman, serif;">Open KVMS/Storage </span></span><br />
<br />
<br />
<br />
<br />
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<span style="font-family: Times, Times New Roman, serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4UH04YTWJrZPBqMivvdPA0yb3wcHH-HqYYOTg-sHZF1lrK9kqJX1UQejjsiDKwrLVHlFPDVQlIRiYGgkZpbKZ7EIFWTlgviZzrZ3AErEPftclSdUUmzzq6so07cam7zpzOfOwLqbqjuwp/s1600/kvms-storage.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="358" data-original-width="493" height="232" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4UH04YTWJrZPBqMivvdPA0yb3wcHH-HqYYOTg-sHZF1lrK9kqJX1UQejjsiDKwrLVHlFPDVQlIRiYGgkZpbKZ7EIFWTlgviZzrZ3AErEPftclSdUUmzzq6so07cam7zpzOfOwLqbqjuwp/s320/kvms-storage.jpg" width="320" /></a></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: Times, Times New Roman, serif;">Add <span style="caret-color: rgb(0, 0, 0);">Storage - choose the iso you'd created and klick 'Connect'</span></span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikIhGIvg7oNd544j0jcF3zFFmOGKA34F7AIuPx0nOv4x79VjdrLDqYydC_zXqhh3NIKCtr8YddcxztIeeKd0hr6wGU6yQxj7iWYx_iukRJ42jJCgT54P52m-MmLsnRQfnTtD5nwN7wrzkF/s1600/connect-device.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" data-original-height="340" data-original-width="293" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEikIhGIvg7oNd544j0jcF3zFFmOGKA34F7AIuPx0nOv4x79VjdrLDqYydC_zXqhh3NIKCtr8YddcxztIeeKd0hr6wGU6yQxj7iWYx_iukRJ42jJCgT54P52m-MmLsnRQfnTtD5nwN7wrzkF/s320/connect-device.jpg" width="275" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFefzTGfOQF0eOfqB3Bgtelea9ZgRRRZNncZ-YlmMoRlbVlwHYVzgS2qxPIPLvM6BEIEgnHYt9MhzwWKHHxkTgfOeQcgmbEQiq6PiYl7qM66FMK6HHvyukDvDp2JTV409ubkJMk5kVumvp/s1600/add-device.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-right: 1em;"><img border="0" data-original-height="334" data-original-width="244" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFefzTGfOQF0eOfqB3Bgtelea9ZgRRRZNncZ-YlmMoRlbVlwHYVzgS2qxPIPLvM6BEIEgnHYt9MhzwWKHHxkTgfOeQcgmbEQiq6PiYl7qM66FMK6HHvyukDvDp2JTV409ubkJMk5kVumvp/s320/add-device.jpg" width="233" /></a><br />
<br />
<br />
<br />
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif;">Next, in a terminal session, start the console application (start /HOST/console), and mount the cdrom: </span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Courier New, Courier, monospace;">mkdir /media/cdrom</span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Courier New, Courier, monospace;">mount /dev/cdrom /media/cdrom</span><span style="font-family: Arial, sans-serif;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US" style="font-family: Arial, sans-serif;"><br /></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<span lang="EN-US"><span style="font-family: Times, Times New Roman, serif;">copy the files to whereever You want on the ODA's file system :-)</span><span style="font-family: Arial, sans-serif; font-size: 11pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
<div class="MsoNormal" style="caret-color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 11pt; margin: 0cm 0cm 0.0001pt; text-size-adjust: auto;">
<br /></div>
robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-82436502523839648642018-04-04T11:27:00.004+02:002018-04-04T11:27:59.849+02:00Enterprise Manager and the disadvantages of WLS' Dynamic Monitoring Service (lots of metricdump files)Had an interesting problem this morning with a customers Windows Server where Enterprise Manager 12c is running: Disk C: - where the EM Software is installed - was full. By the way: Imho, oracle software should never ever be installed in C: ...<br />
<br />
<h3>
The Problem:</h3>
Reason for the full disk was Weblogic's Dynamic Monitoring Service (or a weak housekeeping tool ;-)).<br />
Explained:<br />
Weblogic has a feature, called DMS, which is checking some domain metrics and saves them to a file in directory (DOMAIN_HOME/server/<ServerName>/logs/metrics) for each managed server. Each file is about 600 to 800k in size, which is not that much - except You have thousands of those files. Filename is, by the way, somewhat like metricdump*. The files are created per default in a 3 hour cycle.<br />
<br />
<h3>
The Solution:</h3>
For this customer's system, I decided to stop the Dynamic Monitoring Service for the AdminServer as well as for the EMGC_OMS1 managed server. To achieve this, search for the file dms_config.xml (DOMAIN_HOME/config/fmwconfig/servers/<ServerName>) and change the value of 'enabled' to "false"<br />
<br />
<div class="container">
<div class="line number1 index0 alt2">
<code class="xml plain"><</code><code class="xml keyword">dumpConfiguration</code><code class="xml plain">></code></div>
<div class="line number2 index1 alt1">
<code class="xml spaces"> </code><code class="xml plain"><</code><code class="xml keyword">dump</code> <code class="xml color1">intervalSeconds</code><code class="xml plain">=</code><code class="xml string">"10800"</code> <code class="xml color1">maxSizeMBytes</code><code class="xml plain">=</code><code class="xml string">"75"</code> <code class="xml color1">enabled</code><code class="xml plain">=</code><code class="xml string">"false"</code><code class="xml plain">/></code></div>
<div class="line number3 index2 alt2">
<code class="xml plain"></</code><code class="xml keyword">dumpConfiguration</code><code class="xml plain">></code></div>
<div class="line number3 index2 alt2">
<code class="xml plain"><br /></code></div>
<div class="line number3 index2 alt2">
<code class="xml plain"><span style="font-family: Times, Times New Roman, serif;">Restart EM to activate the change. </span></code></div>
<div class="line number3 index2 alt2">
<code class="xml plain"><span style="font-family: Times, Times New Roman, serif;">Another option could be, to change the value of intervalSeconds to a higher value - for example once a day (86'400 secs) or twice a day (43'200 secs). Or, in case you have a proper working housekeeping tool running each day, configure it that it deletes all files older than 'whatever-you-might-think'.</span></code></div>
</div>
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com1tag:blogger.com,1999:blog-969759252355240200.post-86381204421453359922018-03-16T16:52:00.000+01:002018-03-16T16:54:40.401+01:00ODA X6-2M – Expanding Storage can be unsuccessful when impatient<br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
In 'A Brief History of Time' (RIP Mr. Hawking), Chapter 2 is
named 'Space and Time' – and this title fits perfect with a current problem, I
was faced with, when expanding disk capacity in an ODA X6-2M.</div>
<div class="MsoNormal">
<br /></div>
<h4>
Long story, told short</h4>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
An ODA X6-2M, equipped with the standard disk configuration,
ran out of space and my customer decided to add two NVMe's. So, he ordered
two NVMe's – and, by the way - we were waiting for two weeks (!), until delivery. </div>
<div class="MsoNormal">
<br />
Next step - mounting the disks. According documentation, expanding disk storage is a quite easy job:<o:p></o:p></div>
<div class="MsoNormal">
</div>
<ul>
<li>Put the disks in</li>
<li>Set the disks in online state (odaadmcli power disk on pd_02
and odaadmcli power disk on pd_03)</li>
<li>Expand storage (odaadmcli expand storage)</li>
</ul>
<br />
<h4>
This results in my environment in a complete disaster: </h4>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
</div>
<ul>
<li>Disks are already online when trying a 'power disk on',</li>
<li>'expand storage' meant, the disks have already an ASM
signature and aborted,</li>
<li>'odaadmcli show disk' shows the disks, but als UNKNOWN and
with the /dev/nmv* names of the existing NMVes, whilst the old ones had, all of a sudden, new names … (!)</li>
<li>The command to power off said that the disks are not online,
but a subsequent remove of the disks resulted in a system crash …</li>
</ul>
<br />
<div class="MsoNormal">
In short: horror!! Opened a Service Request, tried this,
tried that – and finally, after three weeks fighting with Oracle Support, I started
a last try: Put the disks in, went to the coffee bar, returned about an hour
later. Started to set the disks in online state (result: the disks are already online),
and issued an 'odaadmcli expand storage' – expecting the same result as with every
try before … but, surprisingly, the command returned no error, ASM started
rebalancing and everything went fine <span style="font-family: "wingdings"; mso-ascii-font-family: "Times New Roman"; mso-char-type: symbol; mso-hansi-font-family: "Times New Roman"; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;">J</span></span></div>
<div class="MsoNormal">
<span style="font-family: "wingdings"; mso-ascii-font-family: "Times New Roman"; mso-char-type: symbol; mso-hansi-font-family: "Times New Roman"; mso-symbol-font-family: Wingdings;"><span style="mso-char-type: symbol; mso-symbol-font-family: Wingdings;"><br /></span></span></div>
<br />
<h4>
Solution / Chapter 2 ... 'Space and Time'</h4>
You'll get the disk <b>space</b>, when You take Your <b>time</b> ...<br />
<br />
Put the disks in, wait at least 15 minutes, power on the disks and issue the 'expand storage' command. Oracle Supports explaination of this behavior was (in my words): The oakd process needs some time to prepare the disks in a way that expand storage works properly …<br />
<div class="MsoNormal">
<span style="font-family: "times" , "times new roman" , serif;"><o:p></o:p></span></div>
<!--EndFragment--><br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-22659984742596002182018-03-16T08:49:00.004+01:002018-03-16T08:49:43.940+01:00ODA Xx – Space Waste When Using ACFS (instead of ASM) For Databases<br />
<div class="MsoNormal">
<br /></div>
<h4>
Disclaimer: I will not discuss the necessity of an ACFS FS
to store database files, nor compare ASM and ACFS or it's benefits. What to use
/ what fits best in Your environment is up to You, folks … ;-)</h4>
<h3>
Pretty sure that this is for lots of people a well-known
problem – but for all others:</h3>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal">
When creating a database using ACFS as storage option, a FS
of size 100GB is created. This 100GB is not a configurable value, by the way.
Result is: When having lots of small databases, making use of ACFS wastes a lot of disk space,
as every database's file system occupies 100GB. <br />Oracle Support's
answer to that is: "In the future releases you may see the customized
option to define the size of ACFS while creating the database".
Nevertheless: It is possible to reduce that 100GB FS to an appropriate size.
Here's how: <span style="mso-spacerun: yes;"> </span><o:p></o:p></div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Examples are based on OAK 12.2.1.2.0, used db release: 12.1.0.2</div>
<h4>
Create the database:</h4>
<div class="MsoNormal">
<o:p></o:p></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">oracle@eoda03 ~]$ odacli create-database -m -n
RCRACFS1 --no-cdb --dbstorage ACFS -dh
cce28d1b-01cc-4917-8237-38683d34f53e</span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";"><span style="font-size: x-small;"><br /></span></span></div>
<h4 style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
… results in (from a FS
perspective)</h4>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<o:p></o:p></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">Filesystem
Size Used Avail Use% Mounted on<o:p></o:p></span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">/dev/asm/datrcracfs1-262 100G
2.5G 98G 3% /u02/app/oracle/oradata/RCRACFS1</span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New"; font-size: 8.0pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><br /></span></div>
<h4 style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
Reduce the filesystem size to
10GB:</h4>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<o:p></o:p></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">[oracle@eoda03 ~]$ acfsutil size -90G
/u02/app/oracle/oradata/RCRACFS1<o:p></o:p></span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">acfsutil size: <b>new file system size: 10737418240
(10240MB)</b></span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New"; font-size: 8.0pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><br /></span></div>
<h4 style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
Check the filesystem size</h4>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<o:p></o:p></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">[oracle@oda03 ~]$ df -h /u02/app/oracle/oradata/RCRACFS1<o:p></o:p></span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">Filesystem<span style="mso-spacerun: yes;">
</span><span style="mso-spacerun: yes;"> </span>Size<span style="mso-spacerun: yes;"> </span>Used Avail Use% Mounted on<o:p></o:p></span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New";">/dev/asm/datrcracfs1-262 <b>20G</b>
2.5G 18G 13% /u02/app/oracle/oradata/RCRACFS1<span style="font-size: 8pt;"><o:p></o:p></span></span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black;"><span style="font-family: Times, Times New Roman, serif;"><b>20G?? 100 minus 90 is 20? Possibly yes (you never know ;-)) – on the other
hand and a better explanation: 20GB could be minimum FS for an ACFS file system.</b></span></span></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="color: black; font-family: "Courier New"; font-size: 8.0pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><br /></span></div>
<h3 style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
Conclusion:</h3>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<o:p></o:p></div>
<div class="MsoNormal" style="mso-layout-grid-align: none; tab-stops: 28.0pt 56.0pt 84.0pt 112.0pt 140.0pt 168.0pt 196.0pt 224.0pt 252.0pt 280.0pt 308.0pt 336.0pt; text-autospace: none;">
<span style="font-family: Times, Times New Roman, serif;"><span style="color: black;">Yes! It is that easy </span><span style="color: black;">J</span></span><span style="color: black; font-family: "Courier New"; font-size: 8.0pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><o:p></o:p></span></div>
<!--EndFragment--><br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-36134606873627127032018-03-05T16:50:00.002+01:002018-03-05T16:55:43.755+01:00EXPDP using an External Password Store - facing a new 'release' of a well known performance issue After a while without blogging, here a new blog post talking about a very well known performance issue:<br />
<h4>
export (exp as well as expdp) is usually slower when using an TCP based TNS-Alias instead of setting ORACLE_SID. Remember? ;-) </h4>
In a little more detail:<br />
<span style="font-family: "times" , "times new roman" , serif;">An "</span><span style="font-family: "courier new" , "courier" , monospace;">expdb system/manager@db directory= ..."</span> takes (usually) more time than an<br />
<span style="font-family: "courier new" , "courier" , monospace;">"export ORACLE_SID=DB; expdp system/manager directory= ..."</span><br />
<br />
But what if You have to use an external password store - a wallet - to avoid clearly readable passwords either in a file or at the command line? One part of the whole procedure is, to define the TNS alias in tnsnames.ora - and most of us define a TCP based alias. This is - imho - not the best way of connecting a local database - IPC or BEQ are way better for that.<br />
<br />
So, I solved an expdp performance issue by using an Bequeath based TNS alias:<br />
<br />
<span style="font-family: "times" , "times new roman" , serif;">Created a new wallet:</span><br />
<span style="background-color: white; font-family: "courier new" , "courier" , monospace;">mkstore -wrl /u01/app/oracle/wallet -create</span><br />
<div class="p1">
<span class="s1"><br /></span></div>
<div class="p1">
<span class="s1"><span style="font-family: "times" , "times new roman" , serif; font-size: small;">Created an alias to connect to the DB:</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;">mkstore -wrl /u01/app/oracle/wallet -createCredential db_system_beq.world system manager</span></div>
<br />
Added a BEQ connect description to my tnsnames.ora:<br />
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1">DB_SYSTEM_BEQ.</span><span class="s2">WORLD</span><span class="s1"> =</span></span></div>
<div class="p2">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s3"><span class="Apple-converted-space"> </span>(</span><span class="s1">DESCRIPTION</span><span class="s3"> =</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1"><span class="Apple-converted-space"> </span>(</span><span class="s4">ADDRESS</span><span class="s1"> =</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1"><span class="Apple-converted-space"> </span>(</span><span class="s5">PROTOCOL</span><span class="s1"> = </span><span class="s2">BEQ</span><span class="s1">)</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1"><span class="Apple-converted-space"> </span>(</span><span class="s5">PROGRAM</span><span class="s1"> = </span><span class="s2">oracle</span><span class="s1">)</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1"><span class="Apple-converted-space"> </span>(</span><span class="s5">ARGV0</span><span class="s1"> = oracleDB)</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1"><span class="Apple-converted-space"> </span>(</span><span class="s5">ARGS</span><span class="s1"> = '(</span><span class="s4">DESCRIPTION</span><span class="s1">=(LOCAL=</span><span class="s2">YES</span><span class="s1">)(</span><span class="s4">ADDRESS</span><span class="s1">=(</span><span class="s5">PROTOCOL</span><span class="s1">=</span><span class="s2">BEQ</span><span class="s1">)))')</span></span></div>
<div class="p1">
<span class="s1" style="font-family: "courier new" , "courier" , monospace;"><span class="Apple-converted-space"> </span>)</span></div>
<div class="p2">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s3"><span class="Apple-converted-space"> </span></span><span class="s6">(</span><span class="s1">CONNECT_DATA</span><span class="s3"> =</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1"><span class="Apple-converted-space"> </span>(</span><span class="s5">SERVICE_NAME</span><span class="s1"> = DB)</span></span></div>
<div class="p1">
<span style="font-family: "courier new" , "courier" , monospace;"><span class="s1"><span class="Apple-converted-space"> </span></span><span class="s7">)</span></span></div>
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #000000; background-color: #ffffff}
p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #34bc26; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures}
span.s2 {font-variant-ligatures: no-common-ligatures; color: #33bbc8}
span.s3 {font-variant-ligatures: no-common-ligatures; color: #000000}
span.s4 {font-variant-ligatures: no-common-ligatures; color: #34bc26}
span.s5 {font-variant-ligatures: no-common-ligatures; color: #cd7923}
span.s6 {font-variant-ligatures: no-common-ligatures; color: #000000; background-color: #00e6e6}
span.s7 {font-variant-ligatures: no-common-ligatures; background-color: #00e6e6}
</style>
<br />
<div class="p1">
<span class="s1" style="font-family: "courier new" , "courier" , monospace;"><span class="Apple-converted-space"> </span>)</span></div>
<br />
Set the environment for my db and issued an expdp:<br />
<span style="font-family: "courier new" , "courier" , monospace;">export ORACLE_SID=DB; </span><span style="font-family: "courier new" , "courier" , monospace;">expdb /@db_system_beq.world directory= ...</span><br />
<br />
Result:<br />
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #000000; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures}
</style>
<br />
<div class="p1">
<span class="s1" style="font-family: "courier new" , "courier" , monospace;">Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Mon Mar 5 15:04:15 2018 elapsed 0 <b>00:00:43</b><span class="Apple-converted-space"> </span></span></div>
<div class="p1">
<span class="s1"><span class="Apple-converted-space"><br /></span></span></div>
<div class="p1">
<span class="s1"><span class="Apple-converted-space"><span style="font-family: "times" , "times new roman" , serif; font-size: small;">Result when using a TCP based TNS alias:</span></span></span></div>
<div class="p1">
<span class="s1"><span class="Apple-converted-space">
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #000000; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures}
</style>
</span></span></div>
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #000000; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures}
</style>
<br />
<div class="p1">
<span class="s1"><span class="Apple-converted-space" style="font-family: "courier new" , "courier" , monospace;">Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Mon Mar 5 14:58:03 2018 elapsed 0 <b>00:01:31</b> </span></span></div>
<div class="p1">
<span class="s1"><span class="Apple-converted-space"><br /></span></span></div>
<h4>
<span class="s1"><span class="Apple-converted-space"><span style="font-family: "times" , "times new roman" , serif; font-size: small;">Try it - and post Your results as comment.</span></span></span></h4>
<br />
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #000000; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures}
</style><style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #000000; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures}
</style>robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-64059363001023657052017-09-26T16:12:00.002+02:002017-09-26T16:12:28.477+02:00News Regarding Post "bind csid (#) does not match session csid (#)"<h3>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Problem "bind csid (#) does not match session csid (#)"</span></h3>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">After further investigation and analysis, here some more news regarding the problem with "bind csid (#) does not match session csid (#)"</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">I wrote: <i>"Reason was - in my case - that an agent, which has connected to a freshly created clone of a production database a little to early, was stuck with an Character Set which was current at the time of the first connect."</i></span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><i><br /></i></span>
<h3>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Additional information: </span></h3>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Found out that the agent has used the 'sys' account of the database </span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">as monitoring user</span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">. That means, after the cloning process has finished and the database has been starting, the agent connected to the database using this account. Because sys (or any sysdba) is able to connect to a database which is not in an open state ... You know what I mean: The agent connected much too early, got US7ASCII as character set, and ran finally into the "bind csid does not match ..." error. </span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<h3>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Conclusion:</span></h3>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">There are more options to fix that problem than mentioned in the first post regarding this topic:</span><br />
<br />
<ul>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">restart the agent will solve the problem</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">if the database is a result of a recurring cloning process, do not use 'sys' as monitoring user, but 'dbsnmp'</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">generally: do not use 'sys' as a monitoring user, except for Dataguard </span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">After a system restart, start the databases first and subsequently the agent - if You have to use 'sys' as monitoring user for whatever reason</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">monitor the trace directory to avoid that tracefiles are filling up the filesystem</span></li>
</ul>
<br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: "helvetica neue", arial, helvetica, sans-serif;"><br /></span>
<span style="font-family: "helvetica neue", arial, helvetica, sans-serif;"><br /></span>robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com31tag:blogger.com,1999:blog-969759252355240200.post-11037600824423056812017-08-16T12:45:00.002+02:002017-08-16T12:45:41.823+02:00SQLcl - the SQL*Plus plus a plus ...<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">"euphoric: <span class="oneClick-link oneClick-available" style="background-color: white; box-sizing: border-box;">intensely</span><span style="background-color: white;"> </span><span class="oneClick-link oneClick-available" style="background-color: white; box-sizing: border-box;">happy</span><span style="background-color: white;"> </span><span class="oneClick-link" style="background-color: white; box-sizing: border-box;">or</span><span style="background-color: white;"> </span><span class="oneClick-link oneClick-available" style="background-color: white; box-sizing: border-box;">confident", @thatjeffsmith, </span>https://youtu.be/ecgijS76jvw ...</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Just watched the video from @thatjeffsmith about SQLcl - and it is, indeed, worth the time. After looking that video, I'm pretty sure that SQLcl will replace SQL*Plus within months (if some more people 'spread the word').</span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Just a few keywords to make you curious:</span><br />
<br />
<ul>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>SQLcl</b> is <b>available</b> as '<b>standalone</b>' download, <b>but</b> it is <b>also</b> already <b>part of</b> the latest <b>SQLDeveloper</b> <b>17.2.0</b></span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>SQLcl needs an JRE</b> to run </span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>To start</b> SQLcl <b>use</b> '<b>sql</b>' - not 'sqlcl'</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>SQLcl</b> has <b>almost all features</b> included, <b>SQL*Plus</b> has (simply run Your sql scripts in SQLcl instead of SQL*Plus)</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Once started, type help and You'll see all the new commands available. For example:</span></li>
<ul>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>alias</b> - define aliases for often used SQL-Commands</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>cd</b> - change directory when within SQLcl</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>ctas</b> - simply type 'ctas <table> <new-table>' and You'll get the complete syntax for a 'Create Table As Select'. The ctas is loaded into the SQLcl buffer, so You could simply issue a '/' and the code is executed. Ok - You have to edit the result, because of ORA-02264 errors (Constraint already exists - but thats easy done by typing ed to start the editor</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">SQLcl eases typing of statements. It can <b>autocomplete column and table names</b>. Example: Type 'select * from hr.empl<tab>' and it automatically autocompletes to hr.employees. If more than one possibility is available, it lists all ...</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>DDL</b> - a command to extract the ddl for a given object</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>info</b> - <b>a 'verbose' desc</b> which displays way more information about an object</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>info+</b> - yes, info+! An even more informational view on an object. Interestingly, neither info nor info+ are shown when issuing an help command. But 'help information' will show how to use it.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>history</b> - show the last 100 command You'd issued in SQLcl (customizable to any value). Even more: You can use history <index> (where index is the number of a sql statement in the history) to load a sql statement in buffer - execute it by typing / , edit it (ed) or change values using the good old 'c/<old value>/<new value></span></li>
</ul>
</ul>
<br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>And there is a lot more</b> - repeat for example, which repeats a statement n times, sleeping t seconds between each execution. <b>Watch the video and then try SQLcl!</b></span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">"euphoric: <span class="oneClick-link oneClick-available" style="background-color: white; box-sizing: border-box;">intensely</span><span style="background-color: white;"> </span><span class="oneClick-link oneClick-available" style="background-color: white; box-sizing: border-box;">happy</span><span style="background-color: white;"> </span><span class="oneClick-link" style="background-color: white; box-sizing: border-box;">or</span><span style="background-color: white;"> </span><span class="oneClick-link oneClick-available" style="background-color: white; box-sizing: border-box;">confident" - Yes, I am :-)</span></span><br />
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="font-size: 15px;"><br /></span></span>robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-2800381330354308322017-07-31T09:44:00.003+02:002017-07-31T09:44:24.103+02:00Back From HolidaysAfter some weeks, spent in Sweden, I'm back ... and will continue writing blogposts ... :-)<br />
<br />
Stay tuned<br />
<br />
<br />robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com0tag:blogger.com,1999:blog-969759252355240200.post-74956624036650931092017-07-06T16:34:00.000+02:002017-07-06T16:34:56.918+02:00ODA X6-2S - upgrade from 12.1.2.10.0 to 12.1.2.11.0 ... just a few remarks<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Did an update of our ODA X6-2S from 12.1.2.10.0 to 12.1.2.11.0 Patch Bundle and want to share some findings. </span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">The patching process is described quite good in the README - nevertheless, a few remarks:</span><br />
<span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;"><br /></span>
<br />
<ul>
<li><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">the whole process took about 2 hours - <u>without</u> downloading the necessary files and preparations (for example: <b>read the README</b> ;-))</span></li>
<li><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">The time, the update process takes, depends on the number of databases running on that system (in our case just four)</span></li>
<li><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">The README does not clearly mention that the system is rebooted two times. </span><br /><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">First time after step </span><span class="SpellE" style="background-color: white; text-size-adjust: auto;"><span style="font-family: "courier new" , "courier" , monospace;">odacli</span></span><span style="text-size-adjust: auto;"><span style="background-color: white; font-family: "courier new" , "courier" , monospace;"><span class="Apple-converted-space"> </span>update-server</span><span style="background-color: white; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">, </span></span><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">second after step </span><span style="font-family: "courier new" , "courier" , monospace;"><span class="SpellE" style="text-size-adjust: auto;">odacli</span><span style="background-color: white; text-size-adjust: auto;"><span class="Apple-converted-space"> </span>update-storage</span></span><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; text-size-adjust: auto;"><span style="background-color: white;">. </span></span><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">But not immediately after the update step - the system waits for 5 Minutes until it starts rebooting <b>(!)</b></span><br /><b style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">Do not start any following step before the reboot has taken place and the system is available again</b><span style="background-color: white; font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">. </span></li>
<li><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">README chapter 4 - Post Patching Steps - tells not the whole truth: oracle talks about issuing an update-image command. But, in the Image-Patch README is mentioned that You have to issue a </span><br /><br /><span style="font-family: "courier new" , "courier" , monospace;">odacli update-repository --fileName /tmp/oda-sm-12.1.2.11.0-170503-DB-12.1.0.2.zip</span><br /><br /><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif;">Long story told short:</span></li>
</ul>
<ol><ol>
<li>do the 'update-repository' step first </li>
<li>'--fileName' will throw an error - the command is: '--filename' (all lower case) or - alternatively '-f'</li>
<li>after updating the repository, issue the update-image</li>
</ol>
</ol>
<br />
<div class="p1">
<span style="font-variant-ligatures: no-common-ligatures;"><span style="font-family: "helvetica neue" , "arial" , "helvetica" , sans-serif; font-size: small;">That's it, basically. Happy upgrading!</span></span></div>
<div class="p1">
<br /></div>
<style type="text/css">
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Menlo; color: #000000; background-color: #ffffff}
span.s1 {font-variant-ligatures: no-common-ligatures}
</style>robertCrameshttp://www.blogger.com/profile/13705048105316689179noreply@blogger.com1