tag:blogger.com,1999:blog-73475967138491108912024-03-13T23:09:39.360-07:00Solution Mentors Technology Blog.NET Core, Java, NodeJS, React + Redux, Typescript, Oracle, Microsoft SQL Server, PostgreSQL, Microsoft Azure, Amazon AWS, and more.skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.comBlogger66125tag:blogger.com,1999:blog-7347596713849110891.post-75127647394917879412020-01-15T12:44:00.001-08:002020-01-16T13:38:49.044-08:00Analyzing why Oracle archive log takes a lot of space<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 class="post-title entry-title" itemprop="name" style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 22px; font-stretch: normal; font-variant-east-asian: normal; font-variant-numeric: normal; font-weight: normal; line-height: normal; margin: 0.75em 0px 0px; position: relative;">
<b style="font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;">Problem</b></h3>
<div>
<b style="font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;"><br /></b></div>
<div>
<span style="color: #666666; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;">Oracle archivelog grows extensively. Need to figure out what objects are being changed most frequently.</span></span></div>
<div>
<span style="color: #666666; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span></div>
<div>
<b style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;">Solution</b></div>
<div>
<b style="color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;"><br /></b></div>
<div>
<span style="color: #666666; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;">Run following statement to get statistics by snapshot date, object name and max number of changes.</span></span></div>
<div>
<span style="color: #666666; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span></div>
<div>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif;"><span style="font-size: 13.2px;">SELECT to_char(begin_interval_time,'YYYY-MM-DD HH24:MI') snap_time,
dhsso.object_name,
sum(db_block_changes_delta) as maxchages
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND begin_interval_time BETWEEN to_date('2020-05-22 17','YYYY-MM-DD HH24')
AND to_date('2020-05-22 21','YYYY-MM-DD HH24')
GROUP BY to_char(begin_interval_time,'YYYY-MM-DD HH24:MI'),
dhsso.object_name order by maxchages asc;</span></span><span style="color: #222222; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif; font-size: 13.2px;">
</span></pre>
<div>
<span style="color: #222222; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif; font-size: 13.2px;"><br /></span></div>
<div>
<span style="color: #222222; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif; font-size: 13.2px;">In order to find out SQL statements that cause these changes, please use following query:</span></div>
<div>
<br /></div>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif;"><span style="font-size: 13.2px;">SELECT to_char(begin_interval_time,'YYYY-MM-DD HH24:MI'),
dbms_lob.substr(sql_text,4000,1),
dhss.instance_number,
dhss.sql_id,executions_delta,rows_processed_delta
FROM dba_hist_sqlstat dhss,
dba_hist_snapshot dhs,
dba_hist_sqltext dhst
WHERE upper(dhst.sql_text) LIKE '%<your object name>%'
AND dhss.snap_id=dhs.snap_id
AND dhss.instance_Number=dhs.instance_number
AND begin_interval_time BETWEEN to_date('2020-01-10 01','YYYY-MM-DD HH24') AND to_date('2020-01-20 21','YYYY_MM_DD HH24')
AND dhss.sql_id = dhst.sql_id;</span></span></pre>
</div>
<div>
<br /></div>
<div>
<div>
<span style="color: #222222; font-family: "trebuchet ms" , "trebuchet" , "verdana" , sans-serif;"><span style="font-size: 13.2px;">Complete explanation can be found at great article: </span></span><a href="http://cheatsheet4oracledba.blogspot.com/2013/05/huge-archive-log-generation-what-to-do.html">http://cheatsheet4oracledba.blogspot.com/2013/05/huge-archive-log-generation-what-to-do.html</a></div>
<div>
<br /></div>
</div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-26808001596227393072019-10-24T12:10:00.000-07:002019-10-24T12:10:16.907-07:00Convert tab delimited file into comma delimited on Mac<div dir="ltr" style="text-align: left;" trbidi="on">
<b style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;">Problem</b><br />
<b style="background-color: white; color: #666666; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;"><br /></b>
<span style="color: #666666; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;">Need to convert tab delimited file to comma delimited on Mac.</span></span><br />
<span style="color: #666666; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span>
<span style="color: #666666; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;"><b>Solution</b></span></span><br />
<span style="color: #666666; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span>
<span style="color: #666666; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;">Use sed utility, note that standard version doesn't understand \t, so you can either generate tab symbol by pressing Ctrl+V and Tab or install posix sed.</span></span><br />
<span style="color: #666666; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px;">sed 's/ /,/g' <source file> > <target file></span></pre>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-75996028439864841702019-10-22T23:10:00.001-07:002019-10-22T23:10:27.958-07:00Simple build script that works in Windows and Linux<div dir="ltr" style="text-align: left;" trbidi="on">
<b style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Problem</b><br />
<b style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;"><br /></b>
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Have two development environments:</span><br />
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;"><br /></span>
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Laptop</span><br />
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">MacOS, Visual Studio Professional for Mac, .NET Core 3.0</span><br />
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;"><br /></span>
<span style="color: #666666; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;">Desktop</span></span><br />
<span style="color: #666666; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;">Windows 10, Visual Studio Professional for Windows, .NET Core 3.0</span></span><br />
<span style="color: #666666; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span>
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Need to write a script that will be working on </span><span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Windows (.bat file) and MacOS (bash). </span><br />
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;"><br /></span>
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">For example sake, scripting languages or msbuild conditions should not be used.</span><br />
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;"><br /></span>
<b style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Solution</b><br />
<br />
<span style="color: #666666; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;">Never thought that it's possible, definitely not an option for complex scenarios, but for basic commands go following (assuming that script build_webpack.cmd).</span></span><br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="font-size: 13.2px;">echo off
goto(){
#!/bin/bash
NODE=`which node`
cd "$(dirname "$0")/.."
$NODE ./node_modules/webpack/bin/webpack.js --config webpack.config.vendor.js $@
}
goto $@
exit
:(){
SET mypath=%~dp0
CD "%mypath:~0,-1%\\.."
node node_modules\\webpack\\bin\\webpack.js --config webpack.config.vendor.js %*
</span></span></pre>
<div>
<span style="color: #666666; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px;"><br /></span></span></div>
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">Now, if we need to invoke this script during project build, add the following line:</span><br />
<span style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;"><br /></span>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="font-size: 13.2px;"> <Exec Command="ClientApp/scripts/build_webpack.cmd --env.dev" />
</span></span></pre>
<div>
<span style="color: #222222; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="font-size: 13.2px;"><br /></span></span></div>
<div>
<span style="color: #222222; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="font-size: 13.2px;">Detailed explanation can be found at: </span></span><a href="https://nastytester.com/posts/script-that-works-in-windows-and-linux.html">https://nastytester.com/posts/script-that-works-in-windows-and-linux.html</a></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-83985607797912065022019-06-05T10:04:00.000-07:002019-06-05T10:11:53.355-07:00How to find out what processes were killed by OOM on Linux<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Services with high memory utilization are dying sporadically.<br />
<br />
<b>Solution</b><br />
<br />
Run the following command to get a list of processes killed by oom.<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">dmesg | egrep -i 'killed process'</pre>
<br />
<br />
Useful articles:<br />
<br />
1. How to troubleshoot OOM<br />
<a href="https://access.redhat.com/solutions/2612861">https://access.redhat.com/solutions/2612861</a><br />
<br />
2. How to add swap file to Linux Azure VM<br />
<a href="https://support.microsoft.com/en-us/help/4010058/how-to-add-a-swap-file-in-linux-azure-virtual-machines">https://support.microsoft.com/en-us/help/4010058/how-to-add-a-swap-file-in-linux-azure-virtual-machines</a><br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-family: "trebuchet ms", trebuchet, verdana, sans-serif; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">vi /etc/waagent.conf</pre>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="font-size: 13.2px;">ResourceDisk.Format=y
ResourceDisk.EnableSwap=y
ResourceDisk.SwapSizeMB=xx</span></span></pre>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: trebuchet ms, trebuchet, verdana, sans-serif;"><span style="font-size: 13.2px;">service walinuxagent restart</span></span></pre>
<div>
<br /></div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-3864957070867701422019-06-05T09:55:00.001-07:002019-06-05T09:55:38.542-07:00How to find out how long the process has been running on Linux<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to find out how long process is running<br />
<br />
<b>Solution</b><br />
<br />
In order to get time how long process is running, execute following command;<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">ps -o etime= -p <your pid></pre>
<br />
<br /></div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-28453584795862529812019-05-30T14:53:00.003-07:002019-05-30T17:24:23.181-07:00Azure VM is not accessible /proc/net/route contains no routes<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<b>Problem</b></div>
<div style="text-align: left;">
<br /></div>
Oversudden Azure VMs running Ubuntu 18LTS became unreachable (WestUS region)<br />
/proc/net/route contains no routes<br />
<br />
<br />
<b>Solution</b><br />
<br />
Connected to Azure VM via Console and got following running lines of error messages<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">2019/05/30 18:24:20.747552 ERROR ExtHandler /proc/net/route contains no routes</pre>
<br />
Restart waagent service produced the following:<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222;"><span style="font-size: 13.2px;">INFO Daemon Azure Linux Agent Version:2.2.32.2
2019/05/30 18:24:18.242022 INFO Daemon OS: ubuntu 18.04
2019/05/30 18:24:18.246632 INFO Daemon Python: 3.6.7
2019/05/30 18:24:18.251476 INFO Daemon Add daemon process pid 2330 to walinuxagent systemd cgroup
2019/05/30 18:24:18.258645 INFO Daemon CGroups: ok
2019/05/30 18:24:18.263173 INFO Daemon Run daemon
2019/05/30 18:24:18.268142 INFO Daemon Clean protocol
2019/05/30 18:24:18.272685 INFO Daemon Provisioning already completed, skipping.
2019/05/30 18:24:18.277567 INFO Daemon RDMA capabilities are not enabled, skipping
2019/05/30 18:24:18.285862 INFO Daemon Determined Agent WALinuxAgent-2.2.40 to be the latest agent
2019/05/30 18:24:18.613217 INFO ExtHandler Agent WALinuxAgent-2.2.40 is running as the goal state agent
2019/05/30 18:24:18.635339 INFO ExtHandler Detect protocol endpoints
2019/05/30 18:24:18.642625 INFO ExtHandler Clean protocol
2019/05/30 18:24:18.651472 INFO ExtHandler WireServer endpoint is not found. Rerun dhcp handler
</span><b style="font-size: 13.2px;">2019/05/30 18:24:18.658883 INFO ExtHandler Test for route to </b><span style="font-size: 13.2px;"><b>168.63.129.16</b></span><b style="font-size: 13.2px;">
2019/05/30 18:24:18.665334 WARNING ExtHandler No route exists to </b></span><span style="color: #222222;"><span style="font-size: 13.2px;"><b>168.63.129.16</b></span></span><span style="color: #222222;"><span style="font-size: 13.2px;"><b>
</b>2019/05/30 18:24:18.670932 INFO ExtHandler Checking for dhcp lease cache
2019/05/30 18:24:18.675843 INFO ExtHandler looking for leases in path [/var/lib/dhcp/dhclient.*.leases]
2019/05/30 18:24:18.684096 INFO ExtHandler cached endpoint not found
2019/05/30 18:24:18.690504 INFO ExtHandler Cache exists [False]
2019/05/30 18:24:18.695994 INFO ExtHandler Send dhcp request
2019/05/30 18:24:18.700569 INFO ExtHandler Examine /proc/net/route for primary interface
<b>2019/05/30 18:24:18.705882 ERROR ExtHandler /proc/net/route contains no routes
</b>2019/05/30 18:24:18.710763 WARNING ExtHandler Could not determine primary interface, please ensure /proc/net/route is correct
2019/05/30 18:24:18.717827 WARNING ExtHandler Contents of /proc/net/route:
Iface Destination Gateway Flags RefCnt Use Metric Mask MTU Window IRTT
2019/05/30 18:24:18.732775 WARNING ExtHandler Primary interface examination will retry silently
2019/05/30 18:24:20.747552 ERROR ExtHandler /proc/net/route contains no routes
2019/05/30 18:24:22.755975 ERROR ExtHandler /proc/net/route contains no routes</span></span></pre>
<br />
VM reboot didn't help, but VM instance stop/start helped.<br />
<br />
<b>References</b><br />
<a href="https://bugs.launchpad.net/ubuntu/+source/linux-azure/+bug/1822133">https://bugs.launchpad.net/ubuntu/+source/linux-azure/+bug/1822133</a><br />
<a href="https://github.com/Azure/WALinuxAgent/issues/980">https://github.com/Azure/WALinuxAgent/issues/980</a><br />
<a href="https://github.com/Azure/WALinuxAgent/issues/1439">https://github.com/Azure/WALinuxAgent/issues/1439</a><br />
<br /></div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-46560096922650750552019-05-14T10:27:00.000-07:002019-05-14T10:27:01.074-07:00Tibco Jaspersoft throws error java.lang.NoClassDefFoundError: Could not initialize class java.awt.Color<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Tibco Jaspersoft Report server throws java.lang.NoClassDefFoundError: Could not initialize class java.awt.Color when attempting to render report containing graphical elements.<br />
<br />
<b>Solution</b><br />
<br />
Check missing dependencies using following command:<br />
<br />
<div style="background-color: white;">
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">ldd /opt/jasperreports-server-7.1.1/java/lib/amd64/libawt_xawt.so</pre>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<br /></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<br /></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="color: black; font-family: "Times New Roman"; font-size: small;">Results:</span></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<div>
<span style="color: black; font-family: "Times New Roman"; font-size: small;"><br /></span></div>
<div>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><pre style="border-radius: 3px; box-sizing: border-box; color: black; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"> linux-vdso.so.1 (0x00007ffff17f4000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f346bc2f000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f346b891000)
libawt.so => /opt/jasperreports-server-7.1.1/java/lib/amd64/libawt.so (0x00007f346b5bf000)
libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6 (0x00007f346b3ad000)
libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6 (0x00007f346b075000)
<b><span style="color: red;"> libXrender.so.1 => not found</span></b>
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f346ae71000)
<b><span style="color: red;"> libXtst.so.6 => not found
libXi.so.6 => not found</span></b>
libjava.so => /opt/jasperreports-server-7.1.1/java/lib/amd64/libjava.so (0x00007f346ac45000)
libjvm.so => not found
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f346a854000)
/lib64/ld-linux-x86-64.so.2 (0x00007f346c0a7000)
libjvm.so => not found
libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1 (0x00007f346a62c000)
libjvm.so => not found
libverify.so => /opt/jasperreports-server-7.1.1/java/lib/amd64/libverify.so (0x00007f346a41d000)
libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6 (0x00007f346a219000)
libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 (0x00007f346a013000)
libjvm.so => not found
libbsd.so.0 => /lib/x86_64-linux-gnu/libbsd.so.0 (0x00007f3469dfe000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f3469bf6000)</pre>
</pre>
</div>
<div>
<br /></div>
</div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="color: black; font-family: "Times New Roman"; font-size: small;">Install missing packages using following command, libjvm.so can be ignored.</span></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="color: black; font-family: "Times New Roman"; font-size: small;"><br /></span></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">sudo apt-get install libfontconfig1 libxrender1 libxi6 libxtst6</pre>
<div style="font-size: 13.2px;">
<br /></div>
</div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="color: black; font-family: "Times New Roman"; font-size: small;">Restart Jasper Report server using commands</span></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="color: black; font-family: "Times New Roman"; font-size: small;"><br /></span></div>
<div>
<div>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #222222; font-family: Trebuchet MS, Trebuchet, Verdana, sans-serif;"><span style="font-size: 13.2px;">sudo /opt/jasperreports-server-7.1.1/ctlscript.sh stop
sudo /opt/jasperreports-server-7.1.1/ctlscript.sh start</span></span></pre>
</div>
</div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="color: black; font-family: "Times New Roman"; font-size: small;"><br /></span></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<span style="color: black; font-family: "Times New Roman"; font-size: small;"><br /></span></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<br /></div>
<div style="color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<br /></div>
</div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-36786760995784658372019-05-01T22:09:00.001-07:002019-05-01T22:09:24.430-07:00Create GitLab backup without repositories<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to create GitLab backup skipping git repositories themselves. GitLab installed using <a href="https://docs.gitlab.com/omnibus/">Omnibus package</a>.<br />
<br />
<b>Solution</b><br />
<br />
According <a href="https://docs.gitlab.com/omnibus/settings/backups.html">GitLab Omnibus Documentation</a> and <a href="https://docs.gitlab.com/ee/raketasks/backup_restore.html">Backing up and restoring GitLab</a>, required backup can be created using command below:<br />
<br />
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">gitlab-rake gitlab:backup:create BACKUP=gitlab_20190420 GZIP_RSYNCABLE=yes SKIP=repositories</pre>
</div>
<br />
<div>
Please note, that following files are not included to backup and <b>must be backed up separately.</b></div>
<div>
<b><br /></b></div>
<div>
<div style="background-color: white; color: #666666; font-family: "Trebuchet MS", Trebuchet, Verdana, sans-serif; font-size: 13.2px;">
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">/etc/gitlab/gitlab.rb
/etc/gitlab/gitlab-secrets.json</pre>
</div>
<br /></div>
<div>
<b>Reference</b></div>
<div>
<br /></div>
<div>
<a href="https://docs.gitlab.com/omnibus/settings/backups.html">https://docs.gitlab.com/omnibus/settings/backups.html</a></div>
<div>
<a href="https://docs.gitlab.com/ee/raketasks/backup_restore.html">https://docs.gitlab.com/ee/raketasks/backup_restore.html</a></div>
<div>
<a href="https://docs.gitlab.com/omnibus/">https://docs.gitlab.com/omnibus/</a></div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-36309854424783647022019-05-01T21:32:00.003-07:002019-05-01T21:32:57.788-07:00Add user to sudoers<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to add existing user to sudoers.<br />
<br />
<b>Solution</b><br />
<br />
Ubuntu<br />
<br />
<div>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">usermod -aG sudo <username></pre>
</div>
<div>
<br /></div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-10272401441552798382019-05-01T21:29:00.001-07:002019-05-01T21:29:42.782-07:00Install and configure Domain Controller in Microsoft Azure<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to install and configure domain controller in MS Azure.<br />
<br />
<b>Solution</b><br />
<b><br /></b>
There is excellent article how to setup DC in Azure.<br />
<a href="https://www.assistanz.com/steps-to-create-new-active-directory-forest-in-azure-portal/">https://www.assistanz.com/steps-to-create-new-active-directory-forest-in-azure-portal/</a><br />
<div>
<br /></div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-54407663341581595872019-05-01T21:20:00.001-07:002019-05-01T21:20:51.524-07:00Configure Azure Firewall ports required to join Domain Controller<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
There are two virtual networks, Network 1 (contains Domain Controller, Windows Server 2016) and Network 2 (contains workload VMs, Windows Server 2016). Traffic between them goes through Azure Firewall and User Defined Routes.<br />
<br />
<b>Solution</b><br />
<br />
After some experiments came up with following categories of rules:<br />
<br />
<table>
<tbody>
<tr>
<th>Name</th>
<th>Proto</th>
<th>Src</th>
<th>Dest</th>
<th>Ports</th>
</tr>
<tr>
<td>tcp-to-dc</td>
<td>tcp</td>
<td>*</td>
<td><dc server></td>
<td>53,88,135,139,389,445,464,3268,3269,49152-64000</td>
</tr>
<tr>
<td>udp-to-dc</td>
<td>udp</td>
<td>*</td>
<td><dc server></td>
<td>53,88,123,135,137,138,464,389,49152-64000</td>
</tr>
</tbody></table>
<br />
<br />
<b>References</b><br />
<a href="https://support.microsoft.com/en-us/help/179442/how-to-configure-a-firewall-for-domains-and-trusts">https://support.microsoft.com/en-us/help/179442/how-to-configure-a-firewall-for-domains-and-trusts</a><br />
<a href="http://powershell365.com/2016/01/19/firewall-ports-required-to-join-ad-domain/">http://powershell365.com/2016/01/19/firewall-ports-required-to-join-ad-domain/</a><br />
<div>
<br /></div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-15324602991938380752019-05-01T18:21:00.006-07:002019-05-01T19:11:01.923-07:00Sync files using rsync with sudo privileges<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to copy files from one Linux VM to another (Ubuntu 18). Root account is not available, have accounts with sudo privileges.<br />
<br />
<b>Solution</b><br />
<b><br /></b>
Sample command listed below:<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #222222; font-size: 13.2px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">sudo rsync -e "ssh" --rsync-path="sudo rsync" -Pav remoteuser@<remote server>:/mnt/disk01/folder_to_sync/ /mnt/disk01/folder_to_sync/</pre>
<br />
<br />
<div>
When executing, the system will ask you for password to existing user and then password for remoteuser. </div>
<div>
<br /></div>
<div>
Note, that remoteuser should be able to execute sudo command without prompting to type password.</div>
<div>
<br /></div>
Refer to <a href="https://sk.solutionmentors.com/2019/05/run-commands-with-sudo-without-having.html">https://sk.solutionmentors.com/2019/05/run-commands-with-sudo-without-having.html</a> for instructions.<br />
<br /></div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-37485567260659240462019-05-01T18:20:00.003-07:002019-05-01T19:08:49.098-07:00Run commands with sudo without having to enter a password<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to temporarily allow access to user to run commands with sudo without typing password (for batch jobs)<br />
<br />
<b>Solution</b><br />
<br />
Add following entry to /etc/sudoers to allow remoteuser to execute commands with sudo without entering password.<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">remoteuser ALL=(ALL) NOPASSWD:ALL</pre>
<b><br /></b>
<b>References</b><br />
<a href="https://askubuntu.com/questions/334318/sudoers-file-enable-nopasswd-for-user-all-commands/340669">https://askubuntu.com/questions/334318/sudoers-file-enable-nopasswd-for-user-all-commands/340669</a></div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-3489482838417971002019-04-30T15:33:00.000-07:002019-04-30T15:33:44.441-07:00Azure icon sets<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need get PNG, SVG icons for Microsoft Azure services, components, etc. Who struggled with presentations, will understand..<br />
<br />
<b>Solution</b><br />
<br />
Excellent article from Microsoft MVP Chris Pietschmann - <a href="https://buildazure.com/2017/08/22/microsoft-azure-icon-set-download/">Microsoft Azure Icon Set Download – Visio stencil, PowerPoint, PNG, SVG</a><br />
<br />
Icon set can be found at: <a href="https://www.microsoft.com/en-us/download/details.aspx?id=41937">https://www.microsoft.com/en-us/download/details.aspx?id=41937</a><br />
<br /></div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-60417883683632829952019-04-30T15:31:00.004-07:002019-04-30T15:31:55.223-07:00ORA-01102: cannot mount database in EXCLUSIVE mode<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
ORA-01102: cannot mount database in EXCLUSIVE mode during database instance startup<br />
<br />
sqlplus / as sysdba<br />
QL*Plus: Release 12.2.0.1.0 Production on Tue Apr 30 21:26:57 2019<br />
<br />
Copyright (c) 1982, 2016, Oracle. All rights reserved.<br />
<br />
Connected to an idle instance.<br />
<br />
SQL> startup;<br />
ORACLE instance started.<br />
<br />
Total System Global Area 6174015488 bytes<br />
Fixed Size 8634320 bytes<br />
Variable Size 1241514032 bytes<br />
Database Buffers 4915724288 bytes<br />
Redo Buffers 8142848 bytes<br />
ORA-01102: cannot mount database in EXCLUSIVE mode<br />
<div>
<br /></div>
<b>Solution</b><br />
<br />
Same as <a href="https://sk.solutionmentors.com/2019/04/ora-01012-not-logged-on-startup-failed.html">https://sk.solutionmentors.com/2019/04/ora-01012-not-logged-on-startup-failed.html</a>, seems this problem appeared because database was not stopped properly.<br />
<br />
Follow great article <a href="http://www.dba-oracle.com/t_ora_01102_cannot_mount_database_in_exclusive_mode.htm">http://www.dba-oracle.com/t_ora_01102_cannot_mount_database_in_exclusive_mode.htm</a><br />
<br />
+++++++++++<br />
<br />
POSSIBLE SOLUTION:<br />
Verify that the database was shutdown cleanly by doing the following:<br />
<br />
1. Verify that there is not a "sgadef<sid>.dbf" file in the directory<br />
"ORACLE_HOME/dbs".<br />
<br />
% ls $ORACLE_HOME/dbs/sgadef<sid>.dbf<br />
<br />
If this file does exist, remove it.<br />
<br />
% rm $ORACLE_HOME/dbs/sgadef<sid>.dbf<br />
<br />
2. Verify that there are no background processes owned by "oracle"<br />
<br />
% ps -ef | grep ora_ | grep $ORACLE_SID<br />
<br />
If background processes exist, remove them by using the Unix<br />
command "kill". For example:<br />
<br />
% kill -9 <Process_ID_Number><br />
<br />
3. Verify that no shared memory segments and semaphores that are owned<br />
by "oracle" still exist<br />
<br />
% ipcs -b<br />
<br />
If there are shared memory segments and semaphores owned by "oracle",<br />
remove the shared memory segments<br />
<br />
% ipcrm -m <Shared_Memory_ID_Number><br />
<br />
and remove the semaphores<br />
<br />
% ipcrm -s <Semaphore_ID_Number><br />
<br />
NOTE: The example shown above assumes that you only have one<br />
database on this machine. If you have more than one<br />
database, you will need to shutdown all other databases<br />
before proceeding with Step 4.<br />
<br />
<b>4. Verify that the "$ORACLE_HOME/dbs/lk<sid>" file does not exist. This is what caused issue in our case. Simple removal of this file did the trick.</b><br />
<br />
5. Startup the instance<br />
<br />
<b>Related issues</b><br />
<a href="https://sk.solutionmentors.com/2019/04/ora-01012-not-logged-on-startup-failed.html">https://sk.solutionmentors.com/2019/04/ora-01012-not-logged-on-startup-failed.html</a><br />
<a href="https://sk.solutionmentors.com/2019/04/ora-27125-unable-to-create-shared.html">https://sk.solutionmentors.com/2019/04/ora-27125-unable-to-create-shared.html</a><br />
<br />
<b>Reference</b><br />
<a href="http://www.dba-oracle.com/t_ora_01102_cannot_mount_database_in_exclusive_mode.htm">http://www.dba-oracle.com/t_ora_01102_cannot_mount_database_in_exclusive_mode.htm</a><br />
<br /></div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-59624602408309775442019-04-30T15:24:00.000-07:002019-04-30T15:24:32.169-07:00ORA-01012: not logged on startup failed <div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Getting ORA-01012: no logged on startup failed during database startup<br />
<br />
<b>Solution</b><br />
<br />
This behavior in our case caused by "disgraceful" database shutdown.. Seems like zombie Oracle processes existed that prevented database instance from starting up.<br />
<br />
sysresv utility allows to diagnose orphaned shared memory segments.<br />
<br />
> sysresv<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #24292e;"><span style="font-size: 13.6px;">IPC Resources for ORACLE_SID "<your SID>" :
Maximum shared memory segment size (shmmax): 8589934592 bytes
Total system shared memory (shmall): 6871949312 bytes
Total system shared memory count (shmmni): 4096
*********************** Dumping ipcs output ********************
------ Message Queues --------
key msqid owner perms used-bytes messages
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 0 oracle 600 8634368 891
0x00000000 32769 oracle 600 6157238272 446
0x00000000 65538 oracle 600 8142848 446
0x9ab568e0 98307 oracle 600 28672 446
------ Semaphore Arrays --------
key semid owner perms nsems
0x1d625978 98304 oracle 600 227
0x1d625979 131073 oracle 600 227
0x1d62597a 163842 oracle 600 227
*********************** End of ipcs commanddump **************
***************** Dumping Resource Limits(s/h) *****************
core file size 0 KB/UNLIMITED
data seg size UNLIMITED/UNLIMITED
scheduling priority 0 KB/0 KB
file size UNLIMITED/UNLIMITED
pending signals 63 KB/63 KB
max locked memory 14 GB/14 GB
max memory size UNLIMITED/UNLIMITED
open files 64 KB/64 KB
POSIX message queues 800 KB/800 KB
real-time priority 0 KB/0 KB
stack size 32 MB/32 MB
cpu time UNLIMITED/UNLIMITED
max user processes 16 KB/16 KB
virtual memory UNLIMITED/UNLIMITED
file locks UNLIMITED/UNLIMITED
***************** End of Resource Limits Dup ******************
Maximum map count configured per process: 65530
Total /dev/shm size: 8403361792 bytes, used: 0 bytes
<b>Shared Memory:
ID KEY
32769 0x00000000
65538 0x00000000
0 0x00000000
98307 0x9ab568e0
Semaphores:
ID KEY
98304 0x1d625978
131073 0x1d625979</b></span></span></pre>
<br />Kill memory segments<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #24292e;"><span style="font-size: 13.6px;">ipcrm -m <Shared Memory ID>
</span></span></pre>
<div>
<span style="color: #24292e;"><span style="font-size: 13.6px;"><br /></span></span></div>
Kill semaphores<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #24292e;"><span style="font-size: 13.6px;">ipcrm -s <Semaphore>
</span></span></pre>
<div>
<span style="color: #24292e;"><span style="font-size: 13.6px;"><br /></span></span></div>
Try to startup database instance again.</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-87743165887638428162019-04-30T15:10:00.000-07:002019-04-30T15:10:33.429-07:00ORA-27125: unable to create shared memory segment during startup<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<b><br /></b>
After reboot, unable to startup Oracle 12c database instance (Red Hat Enterprise Server 7.6)<br />
<br />
ORA-27125: unable to create shared memory segment<br />
Linux-x86_64 Error: 28: No space left on device<br />
Additional information: 3822<br />
Additional information: 6157238272<br />
<div>
<br /></div>
<div>
<b>Solution</b></div>
<div>
<b><br /></b></div>
<div>
Verify OS kernel.shmall memory setting.</div>
<div>
<br /></div>
<div>
1. Get current value </div>
<div>
cat /proc/sys/kernel/shmall</div>
<div>
1677722</div>
<div>
<br /></div>
<div>
This seems to be too high..</div>
<div>
<br /></div>
<div>
2. Determine page size</div>
<div>
getconf PAGE_SIZE</div>
<div>
4096</div>
<div>
<br /></div>
<div>
3. Calculate recommended value for shmall</div>
<div>
<br /></div>
<div>
shmall = <total size of SGA>/<page size></div>
<div>
<br /></div>
<div>
In our case, we have 16GB RAM, so, shmall = 16 * 1024 * 1024 * 1024 / 4096 = 4194304</div>
<div>
<br /></div>
<div>
4. Update /etc/sysctl.conf</div>
<div>
vi /etc/sysctl.conf</div>
<div>
kernel.shmall=4194304</div>
<div>
sudo sysctl -p</div>
<div>
<br /></div>
<div>
5. Verify kernel.shmall again</div>
<div>
cat /proc/sys/kernel/shmall</div>
<div>
4194304</div>
<div>
<br /></div>
<div>
6. Start Oracle instance</div>
<div>
sudo su - oracle</div>
<div>
sqlplus / as sysdba</div>
<div>
startup;</div>
<div>
<br /></div>
<div>
This of course leads to another error..</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b>References</b></div>
<div>
<a href="https://support.oracle.com/knowledge/Oracle%20Database%20Products/301830_1.html">https://support.oracle.com/knowledge/Oracle%20Database%20Products/301830_1.html</a></div>
<div>
<a href="http://www.nazmulhuda.info/ora-27102-out-of-memory-linux-x86_64-error-28-no-space-left-on-device">http://www.nazmulhuda.info/ora-27102-out-of-memory-linux-x86_64-error-28-no-space-left-on-device</a></div>
<div>
<a href="https://it.toolbox.com/blogs/surachartopun/shared-memory-startup-database-ora-27102-out-of-memory-linux-x86-64-error-28-no-space-left-on-device-102409">https://it.toolbox.com/blogs/surachartopun/shared-memory-startup-database-ora-27102-out-of-memory-linux-x86-64-error-28-no-space-left-on-device-102409</a></div>
<div>
<a href="https://jameshuangsj.wordpress.com/2018/06/07/ora-27125-unable-to-create-shared-memory-segment-linux-x86_64-error-28-no-space-left-on-device/">https://jameshuangsj.wordpress.com/2018/06/07/ora-27125-unable-to-create-shared-memory-segment-linux-x86_64-error-28-no-space-left-on-device/</a></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-89154560150494190112019-04-30T14:39:00.002-07:002019-04-30T14:39:38.685-07:00Formula to set proper values for max processes, sessions and transactions in Oracle<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to adjust max number of sessions in Oracle DB.<br />
<br />
<b>Solution</b><br />
<br />
Standard formula looks like:<br />
<br />
PROCESSES = Operating System Dependant<br />
SESSIONS = (1.1 * PROCESSES) + 5<br />
TRANSACTIONS = 1.1 * SESSIONS<br />
<div>
<br /></div>
<div>
<div>
alter system set sessions=1000 scope=spfile;</div>
<div>
alter system set processes=905 scope=spfile;</div>
<div>
alter system set transactions=1100 scope=spfile;</div>
<div>
<br /></div>
<div>
shutdown immediate;</div>
<div>
startup;</div>
</div>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-64449829444096227982019-04-24T23:59:00.004-07:002019-04-25T00:02:08.173-07:00How to get external IP for Linux VMs on Azure<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
How to get external IP for Linux VMs on Azure<br />
<br />
<b>Solution</b><br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #24292e; font-size: 13.6px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #24292e; font-family: , "consolas" , "liberation mono" , "menlo" , "courier" , monospace;"><span style="font-size: 13.6px;">dig +short myip.opendns.com @resolver1.opendns.com</span></span> </pre>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-12198002837724321492019-04-24T23:32:00.003-07:002019-04-25T00:01:24.227-07:00Change mount point for /mnt folder in Ubuntu Linux on Azure<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="tr_bq">
<b>Problem</b></div>
<br />
When provisioning Linux VMs on Azure, /mnt folder is automatically created and pointed to Resource Disk. In some case, we need to have more fine-grained control over /mnt folder (for instance for backward compatibility) and map Resource Disk to its sub-folder, e.g. /mnt/tmp<br />
<br />
<b>Solution</b><br />
<br />
Azure provides fantastic support for Linux VMs called <a href="https://docs.microsoft.com/en-us/azure/virtual-machines/extensions/agent-linux">Microsoft Azure Linux Agent</a>.<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 13.6px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;">sudo service waagent restart</pre>
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"><span style="color: #24292e; font-family: , "consolas" , "liberation mono" , "menlo" , "courier" , monospace;"><span style="font-size: 13.6px;">vi /etc/waagent.conf
# Mount point for the resource disk
ResourceDisk.MountPoint=/mnt/resources</span></span> </pre>
<br />
Restart waagent service<br />
<br />
<pre style="background-color: #f6f8fa; border-radius: 3px; box-sizing: border-box; color: #24292e; font-family: SFMono-Regular, Consolas, "Liberation Mono", Menlo, Courier, monospace; font-size: 13.6px; line-height: 1.45; overflow-wrap: normal; overflow: auto; padding: 16px; word-break: normal;"> sudo service waagent restart</pre>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-80320729391714763582019-04-24T23:08:00.001-07:002019-04-24T23:08:00.857-07:00Install telnet client from command line on Windows Server<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Problem</b><br />
<br />
Need to install telnet client on Windows Server 2012, 2016<br />
<br />
<b>Solution</b><br />
<br />
pkgmgr /iu:”TelnetClient”</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-21783876312942691842013-02-26T19:26:00.002-08:002013-02-26T19:26:12.620-08:00Rhino.Mocks WhenCalled() throws exception "Method requires a return value or an exception to throw"<div dir="ltr" style="text-align: left;" trbidi="on">
When using of WhenCalled, you should also specify Return statement at the end. More details <a href="http://blog.spinthemoose.com/2011/07/28/using-rhino-mocks-whencalled-remember-to-return/">here</a>.<br />
<br />
<br />
<br />
<blockquote class="tr_bq">
<br /></blockquote>
</div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-54043302869365476872012-09-16T21:08:00.001-07:002012-09-16T21:08:28.829-07:00Copy maven dependencies to WEB-INF/lib<div dir="ltr" style="text-align: left;" trbidi="on">
<b>Use Case</b><br />
<br />
Configure Dynamic Web Project in Eclipse to copy maven dependencies (jars) to WEB-INF/lib.<br />
<br />
<b>Solution</b><br />
<br />
1. Update eclipse.ini, specify -vm option<br />
<br />
-vm<br />
C:\Program Files\Java\jdk1.6.0_25\bin\<br />
<div>
<br /></div>
<div>
2. Convert project to MAVEN backed, set packaging to WAR.</div>
<div>
<br /></div>
<div>
3. Configure JRE</div>
<div>
Go to Project > Properties > Java Build Path > Libraries. Choose JRE System Library and click 'Edit'. Choose Execution Environment from list of available environments, use the same vm as eclipse.ini has.</div>
<div>
<br /></div>
<div>
4. Configure Deployment Assembly</div>
<div>
Go to Project > Properties > Deployment Assembly. Click Add button, then choose Java Build Path Entries. Choose Maven Dependencies from the list and click OK. </div>
<br />
<br /></div>
skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-14744075634681136572011-10-31T01:38:00.000-07:002011-10-31T01:38:13.275-07:00ActiveMQ 5.3 / System.IO.EndOfStreamException / "Unable to read beyond the end of the stream.<div dir="ltr" style="text-align: left;" trbidi="on">
Issue<br />
<br />
I've got a problem with long-running message listeners in ActiveMQ. After approximately 60s, long-running operation breaks with exception - Thread was aborted.<br />
<br />
Solution<br />
<br />
Solution and reason are described there: <a href="https://issues.apache.org/jira/browse/AMQNET-196">https://issues.apache.org/jira/browse/AMQNET-196</a><br />
<br />
After adding: ?transport.keepAliveResponseRequired=true to connection string everything became working like a charm.</div>skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0tag:blogger.com,1999:blog-7347596713849110891.post-89573486319078823602011-07-11T21:37:00.000-07:002011-07-11T21:37:01.219-07:00HTTP Error 404.15 – Not Found: The request filtering module is configured to deny a request where the query string is too longUse Case<br />
<br />
Query string exceeds reasonable size for HTTP GET.<br />
<br />
Solution<br />
<br />
Quick and dirty solution is to increase the maximum querystring size by setting the maxQueryString attribute on the requestLimitselement in the system.webServer/security/requestFiltering configuration section in your application’s web.config:<br />
<br />
<system.webServer><br />
<security><br />
<requestFiltering><br />
<requestLimits maxQueryString="NEW_VALUE_IN_BYTES" /><br />
</requestFiltering><br />
</security><br />
</system.webServer><br />
<br />
<a href="http://mvolo.com/blogs/serverside/archive/2007/12/08/IIS-7.0-Breaking-Changes-ASP.NET-2.0-applications-Integrated-mode.aspx" style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px;">http://mvolo.com/blogs/serverside/archive/2007/12/08/IIS-7.0-Breaking-Changes-ASP.NET-2.0-applications-Integrated-mode.aspx</a><br />
<br />
<em><span class="Apple-style-span" style="color: #555555; font-family: Geneva, Verdana, Arial, Helvetica, sans-serif;"><span class="Apple-style-span" style="font-size: 12px; line-height: 17px;">Or use HTTP POST, if you can.</span></span></em>skhttp://www.blogger.com/profile/09139878898434533671noreply@blogger.com0