Asking questions, following them up

November 8, 2016

Hello Guys

Not all situations, however for certain interesting cases, I spend loads of time out of my professional and personal life to nail down the concerns, situations you highlight through the comments and I feel neglected and insulted when YOU don’t respond to my queries on timely manner. No, it doesn’t mean I am not going to respond to your specific questions, however I may not follow up the progresses you have made unless I see a keen involvement.

Further, many instances I contact you through the emails provided with your comments and other than 1-2 instances, I have never received replies. I send you emails to insure that your private information are not being visible through the comments area. Hence, please make sure that you will be using regularly used email accounts while commenting or asking questions.

Please follow the below guidelines if you are keen about getting answered

  • Provide me an email address that you are frequently checking
  • Regularly check for the comment replies (You get a notification on email when I reply to your comment)

If I am not supported by YOU as the initiator, please be informed that, I do have better things to do :)

Sorry for the “Attitude”, however, that is going to save me some precious time!

regards,

 

 

Advertisements

Posting Code Blocks with your free WordPress Blog

February 27, 2015

Please visit https://en.support.wordpress.com/code/posting-source-code/ for detailed information about how to post source code blocks with your free wordpress.com blog.
A tip from me: Have a look at the source code of wordpress support page opened ;) you “MAY” get more ideas. Okay I didn’t say that!
Let us look at some samples:

1

Will produce the below, syntax highlighted code block for you

your code here

2

Refer the above image, the usage of additional tags within the code tag will syntax highlight a short VB script, avoiding the gutter (line numbers)

Public Class Form1
Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Dim xmlFile As XmlReader
        xmlFile = XmlReader.Create("MyVMS.xml", New XmlReaderSettings())
        Dim ds As New DataSet
        ds.ReadXml(xmlFile)
        DataGridView1.DataSource = ds.Tables(0)
        DataGridView1.Columns(0).HeaderText = "Id"
        DataGridView1.Columns(1).HeaderText = "VM Name"
        DataGridView1.Columns(2).HeaderText = "Shutoff Mode"
  
    End Sub
End Class

Avoid leaving spaces between tags inside “code” tag, as doing so could totally mess-up the code blocks. Just put everything tightly spaced like following

language=”VB” gutter=”false”, there are no spaces between language & = or = & the opening ”

The language (or lang) parameter controls how the code is syntax highlighted. The following languages are supported:

  • actionscript3
  • bash
  • clojure
  • coldfusion
  • cpp
  • csharp
  • css
  • delphi
  • erlang
  • fsharp
  • diff
  • groovy
  • html
  • javascript
  • java
  • javafx
  • matlab (keywords only)
  • objc
  • perl
  • php
  • text
  • powershell
  • python
  • r
  • ruby
  • scala
  • sql
  • vb
  • xml

If the language parameter is not set, it will default to “text” (no syntax highlighting).

Code in between the source code tags will automatically be encoded for display, you don’t need to worry about HTML entities or anything.

Configuration Parameters

The shortcodes also accept a variety of configuration parameters that you may use to customize the output. All are completely optional.

  • autolinks (true/false) — Makes all URLs in your posted code clickable. Defaults to true.
  • collapse (true/false) — If true, the code box will be collapsed when the page loads, requiring the visitor to click to expand it. Good for large code posts. Defaults to false.
  • firstline (number) — Use this to change what number the line numbering starts at. It defaults to 1.
  • gutter (true/false) — If false, the line numbering on the left side will be hidden. Defaults to true.
  • highlight (comma-seperated list of numbers) — You can list the line numbers you want to be highlighted. For example “4,7,19”.
  • htmlscript (true/false) — If true, any HTML/XML in your code will be highlighted. This is useful when you are mixing code into HTML, such as PHP inside of HTML. Defaults to false and will only work with certain code languages.
  • light (true/false) — If true, the gutter (line numbering) and toolbar (see below) will be hidden. This is helpful when posting only one or two lines of code. Defaults to false.
  • padlinenumbers (true/false/integer) — Allows you to control the line number padding. true will result in automatic padding, false will result in no padding, and entering a number will force a specific amount of padding.
  • title (string) — Set a label for your code block. Can be useful when combined with the collapse parameter.

regards,

rajesh


Windows7bugs | Script Copying Instructions

November 9, 2014

Hello guys

Once in a while we receive complaints about scripts copied from our blog causing issues. We regret those issues and apologizing to everyone who suffered due to. Our blog is totally free until date and unfortunately, different browsers behave differently while parsing the code tags.

We were using

 [ code ] [ /code ]

tag for long time, found that few scripts getting totally messed up with double quotes being showsn and &quote etc. This has forced us to start using

[ sourcecode ] [ /sourcecode ] 

and realized if we have more than one block of scripts, the 2nd and consecutive scripts blocks being totally garbled.

With reference to above said, we request you to kindly make sure that the scripts those you copy from our posts are thoroughly checked for special characters prior applied. Especially registry related scripts as such attempts could completely wreck your Windows registry databases.

We hope you read us clearly and continue supporting us.

Regards,


Enable Database Enterprise Manager Console on Oracle EBS R12.1.1

June 16, 2018

I’m yet to check this one out. Reblogging to avoid losing the link among the ocean of bookmarks those I already have.

Joey Out Of The Box

First login as applmgr user, shutdown all application tier process using .
Login as oracle user to linux. Source the database environment.
Ensureis set in the init.ora for the
database using this command:

SQL> show parameter
REMOTE_LOGIN_PASSWORDFILE;

Create a password file using this command on linux:

Then execute this command:

(remember to change SID and port if needed).
You will be asked some question:

SYSMAN schema will be dropped and recreated.
While dropping the scema, database will be quisced.
Database sessions that blocking the quiescing process must be killed.
Use sqlplus to identify the sessions:

Make note on SID and SERIAL#.
Kill the session using this sql command:

(don’t forget to change SID and SERIAL#).
On create schema process you may need to increase the size of SYSAUX tablespace.
After the process completed you can access the enterprise manager on internet browser using this URL:

You may also have…

View original post 18 more words


Oracle Applications R12 | Java applet font scaling issues

June 10, 2018

We are using Oracle applications R12 12.0.6 with JDK 6.0 while most of the clients are using JRE 7/8 based on different business requirements (With full knowledge that there would be unexpected results due to the compiled versions). We’ve observed a peculiar issue with the JRE applet once after the upgrade to Windows 10 version 1803. The Java applet started showing too small fonts while launched from displays with high DPI resolutions.

Digging in brought me to the following discussion:

https://superuser.com/questions/988379/how-do-i-run-java-apps-upscaled-on-a-high-dpi-display

Although there are multiple recommendations, for EBS environment, Please follow the below instructions:

Launch the JAVA applet by opening a forms based module.

Open task manager and locate “Java(TM) Platform…”, right click and open properties. This will open the properties for “jp2launcher.exe”. Click on “Compatibility” and click on “Change high DPI settings”. Now check “Override high DPI scaling behavior. Scaling performed by:” to “Application”. Refer the image for more details.

Once the changes are made to the properties of the executable, restart the box. It could be specific case, the changes were not applied until a restart for me.

Although it fixes the font scaling issues, the toolbar area of the Oracle forms are remains scaled with pretty small icons. I am yet to find out a fix for this minor annoyance. May be quite soon.

 

regards,

 


Windows 10 1803 | .NET Framework 3.5 installation error: 0x800F081F

June 4, 2018

Hi guys

Windows 10 gets more interesting day after day. I feel like Microsoft is slowly helping my HUGE beasty desktop machines to start looking like a MOBILE PHONE, well enough said.

One of the latest issues with Windows 10 version 1803 (build: 17134.81) is, one cannot add the .NET Framework 3.5 feature using “Turn Windows features…”, the attempts start reporting you are not connected to internet, which is not true (Microsoft should grow up)

So if you are looking for a quick solution to the said, don’t worry, Microsoft has truly messed up documentations available here:

https://support.microsoft.com/en-us/help/2734782/net-framework-3-5-installation-error-0x800f0906-0x800f081f-0x800f0907

& you should read this one as well

https://docs.microsoft.com/en-us/previous-versions/windows/it-pro/windows-8.1-and-8/hh825020(v=win.10)

Or if you don’t want to get confused, follow the instructions below:

Using the Windows Media Creation Tool for Version 1803, create ISO and mount it

Browse to sources\sxs folder within the ISO that’s been already mounted. Example, my ISO file is mounted on J: drive, hence the path to sources files is “J:\sources\sxs”

Copy the path and with an administrator account, open “LOCAL” group policy editor

Click Computer Configuration, click Administrative Templates, click System, and then double-click the Specify settings for optional component installation and component repair setting.

and once the LOCAL policies are updated, you have to apply it. Apply the policy changes using “gpupdate /force”. Don’t worry about domain policies (if you are using a domain joined computer)

Now try to install “.NET Framework 3.5”, should complete without giving more errors.

Hope this helps few out there

 

 


Windows Server 2016 | Remote Desktop will not connect

May 31, 2018

Hi guys

I started this blog when I started using Windows 7 initial release and was struck with end number of issues, mostly related networking.

I am turning my attention towards Windows OS, minimum for a while as I am dealing with another Windows OS, that is crap like no other times…Windows Server 2016, which, looks and feels like Windows 10 with server OS capacities (to certain extends). A totally screwed up Server OS which has half of the settings over modern layout and rest on the legacy

This time I am going to discuss about a peculiar situation that arises once after removing “Remote Desktop Services from Windows Server 2016 & trying to initiate a normal RDP session with the server.

It just won’t connect. That’s all. You check for the usual stuffs everywhere and realize that everything is set fine, firewall, permissions. Yet, you won’t able to connect.

After trying to fix “few” things myself, I gave up and started searching for some answers. One of the most interesting things I learned about Windows Server 2016 is, there are hardly any forums discussing anything at all about this particular OS. 99% of the results I am provided were either for Windows Server 2008  or 2012 & for few situations not a single result for 2016!

Anyway I landed on this thread

https://social.technet.microsoft.com/Forums/en-US/bb34981e-9489-4a0c-80fc-6fdea2cd5cd3/remote-desktop-not-working-after-uninstalling-remote-desktop-session-host-server?forum=winserverTS

& by the bottom of the page found a link to Dell site where a solution was provided for Windows Server 2012 R2 to recreate the RDP-TCP registry values. As I was dealing with a VM, which is already backup, I decided to give it a try

http://www.dell.com/support/article/us/en/04/sln286475/how-to-recreate-or-add-an-additional-rdp-listener-in-windows-server-2012-and-2012-r2?lang=en

I’m copying the instructions here, for the reasons that the above link may not be available after a while.

1. Recreate the default RDP Listener
How to recreate the RDP listener.
1. Export the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp
2. Delete the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp
3. Copy and paste the below text into notepad, and save the file as RDP-Tcp.reg. Additionally, if the operating system is 2012 R2, another file will be required with the contents of the second box.


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp]
"fInheritMaxIdleTime"=dword:00000001
"fPromptForPassword"=dword:00000000
"fResetBroken"=dword:00000000
"PdClass"=dword:00000002
"LoadableProtocol_Object"="{5828227c-20cf-4408-b73f-73ab70b8849f}"
"UserAuthentication"=dword:00000001
"fDisableCam"=dword:00000000
"fInheritAutoLogon"=dword:00000001
"InteractiveDelay"=dword:00000032
"Domain"=""
"fInheritReconnectSame"=dword:00000001
"SelectTransport"=dword:00000000
"MinEncryptionLevel"=dword:00000002
"fInheritShadow"=dword:00000001
"WFProfilePath"=""
"fReconnectSame"=dword:00000000
"PdDLL"="tdtcp"
"PortNumber"=dword:00000d3d
"PdFlag1"=dword:00000000
"WdName"="Microsoft RDP 8.0"
"fInheritMaxSessionTime"=dword:00000001
"WdFlag"=dword:00000036
"SelectNetworkDetect"=dword:00000000
"fLogonDisabled"=dword:00000000
"MaxDisconnectionTime"=dword:00000000
"Callback"=dword:00000000
"PdDLL1"="tssecsrv"
"NWLogonServer"=""
"MaxIdleTime"=dword:00000000
"fDisableEncryption"=dword:00000001
"fInheritCallback"=dword:00000000
"fDisableCcm"=dword:00000000
"ColorDepth"=dword:00000003
"PdName"="tcp"
"fEnableWinStation"=dword:00000001
"OutBufLength"=dword:00000212
"PdFlag"=dword:0000004e
"CallbackNumber"=""
"CdClass"=dword:00000000
"Shadow"=dword:00000001
"fDisableCdm"=dword:00000000
"PdName1"="tssecsrv"
"fInheritSecurity"=dword:00000000
"CdDLL"=""
"LanAdapter"=dword:00000000
"fInheritResetBroken"=dword:00000001
"CfgDll"="RDPCFGEX.DLL"
"InitialProgram"=""
"fDisableClip"=dword:00000000
"InputBufferLength"=dword:00000800
"fAllowSecProtocolNegotiation"=dword:00000001
"fDisableAudioCapture"=dword:00000000
"Password"=""
"CdName"=""
"fDisableLPT"=dword:00000000
"CdFlag"=dword:00000000
"PdClass1"=dword:0000000b
"fAutoClientLpts"=dword:00000001
"fAutoClientDrives"=dword:00000001
"fInheritCallbackNumber"=dword:00000001
"OutBufCount"=dword:00000006
"fInheritMaxDisconnectionTime"=dword:00000001
"MaxInstanceCount"=dword:ffffffff
"KeyboardLayout"=dword:00000000
"fDisableExe"=dword:00000000
"AudioEnumeratorDll"="rdpendp.dll"
"Username"=""
"KeepAliveTimeout"=dword:00000000
"fUseDefaultGina"=dword:00000000
"fHomeDirectoryMapRoot"=dword:00000000
"fInheritColorDepth"=dword:00000000
"fForceClientLptDef"=dword:00000001
"WorkDirectory"=""
"SecurityLayer"=dword:00000001
"DrawGdiplusSupportLevel"=dword:00000001
"WdPrefix"="RDP"
"fInheritAutoClient"=dword:00000001
"fDisableCpm"=dword:00000000
"Comment"=""
"OutBufDelay"=dword:00000064
"fInheritInitialProgram"=dword:00000001
"MaxConnectionTime"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp\VideoRemotingWindowNames]
"AGFullScreenWinClass"="*"
"MacromediaFlashPlayerActiveX"="*"
"EVRVideoHandler"="*"
"MicrosoftSilverlight"="*"
"ShockwaveFlashFullScreen"="*"

Additional 2012 R2 values:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Terminal Server\WinStations\RDP-Tcp]
"UserAuthenticationBackup"=dword:00000000
"MaxMonitors"=dword:00000004
"MaxXResolution"=dword:00000a00
"MaxYResolution"=dword:00000640

4. Double-click the RDP-Tcp.reg file and click Yes at the prompt.

Now, restart the box & you are back in the game once again.

Try it in case if you are “also” stuck & let me know about your experiences through comments.

regards,

rajesh

 

 

 


Windows Server 2016 | Too early for Production environments

May 30, 2018

Hi guys

Recently for a new hardware, we opted Windows Server 2016, which was suggested by the vendor and our logical thinking that we are already by the mid of 2018 and we should have a recent server OS.

Although we bought the OS, we didn’t use it until our recent Citrix deployment for a legacy application that is 20 years old, based on Oracle forms and reports (Developer 2000 6i)

Everything went as expected, but the printing. 1st of all we were expecting some misconfigurations from Citrix & came to conclusion that we will address the direct printing requirements from the legacy mini ERP by changing few stuffs here and there.

In order to make sure that no mistakes were been made during Citrix implementation causing such a hiccup, I decided to setup a lab environment (Actually the legacy application sources I have and the latest compiled are bearing different time stamps, hence I was skeptical about recompiling those forms after changing the printing routines…)

So I picked up a Windows 2012 R2 physical server, setup Citrix following the documents provided by our implementation partner, which had minutely detailed explanations with screenshots how to install and configure Citrix XenApp 7.15.xx

After setting up the store front, I accessed the published application and the default printer was the one I have as default in my laptop! This caused me more confusion, so I decided to recreate the exact setup once again using Windows Server 2016

I built a VirtualBox VM using evaluation version of Windows Server 2016 standard edition and patched it with May 2015 cumulative update before setting up Citrix. I was able to reproduce the printing issues once again & I decided to find out what was the real cause behind two different behavior between Windows Server 2012 & 2016!

Kept on searching for any kind of information & came across couple of TechNet discussions

 https://social.technet.microsoft.com/Forums/office/en-US/d3bb9c96-d271-4eb4-b544-c2bcdc0f2e66/printer-redirection-server-2016?forum=winserverTS

 &

 https://social.technet.microsoft.com/Forums/en-US/785cbcc6-4f0b-4d88-b12f-2b1d89b85a44/remoteapp-default-printer-redirection-not-working-in-server-2016?forum=winserverTS

I dug deep into the registries of both OS after a normal RDP to confirm that Windows Server 2016 retains local printer for the key “HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows:Device” while Windows Server 2012 maps this key value with the default printer redirected from the client during a RDP session!

1

I couldn’t find a valid explanation or solution for Windows Server 2016, hence asked the implementer to redo the Citrix deployment using Windows Server 2012.

Now the topic cannot be justified just because we had some issues with an outdated legacy technology, should have more

Windows updates: I never experienced such kind of broken stuffs with Windows update that Windows Server 2016. It looks and breaks like Windows 10 & reminds me a BIG mobile phone than a real server OS

Windows Domain Administrator account has “Not enough privileges” to interact with desktop icons & more. This OS is almost 19 months old & Microsoft hasn’t fixed the above “bug” until date, so you could guess what kind of progress they might have had with this particular OS!

There could be more than what I have listed above with the OS that is still half baked. I am sure the printer related issue that I have narrated above MUST be another bug & future releases “may” address it.

So, unless you are true risk taker, I suggest to continue with Windows Server 2012 & only to use Windows Server 2012 in the test/development environments and to avoid straight away going with the OS for production deployments.

regards,

rajesh

 


Weblogic 12c 12.2.1.3 Installation & configuring for forms & reports

May 22, 2018

This place holds space for subject line. Stay tuned.


Oracle E-Business Suite R12 | SGA vs PGA vs NOT being a DBA!

May 7, 2018

Hi guys

I know the subject title is not very professional this time. Yet, I want to make a claim that I figured out something, for which I spent more than couple of years time and have followed up few Oracle community threads (without much interesting results)

We had to retired a hardware that was recommended by the Oracle EBS implementation partner, within 2 years once after we went online with the R12 instance. We had 10g 10.2.0.3 with the instance, things were getting messy and slow & the new support partner recommended for a better hardware.

I always had eyes on this retired server. It had Linux, hence we couldn’t come up with a practical requirement to integrate the Linux server with our Windows domain environment and it was kept switched off until the virtualization project came online.

We needed “something” to hold a copy of the EBS instance while it was being virtualized.

So, I cloned this machine & before continuing let me describe what this is hardware is like:

Processor:


Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) per core: 1
Core(s) per socket: 4
Socket(s): 2
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 23
Model name: Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
Stepping: 6
CPU MHz: 1992.000
BogoMIPS: 4987.29
Virtualization: VT-x
L1d cache: 32K
L1i cache: 32K
L2 cache: 6144K
NUMA node0 CPU(s): 0-7

Storage space


[root@erp-bak ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdj2 59G 12G 44G 22% /
tmpfs 9.7G 3.9M 9.7G 1% /dev/shm
/dev/sdj1 2.0G 325M 1.5G 18% /boot
/dev/sdj5 738G 531G 170G 76% /u01
/dev/mapper/mpathbp1 591G 320G 242G 57% /u02
/dev/mapper/mpathcp1 197G 38G 150G 20% /u03
/dev/sdf1 591G 70M 561G 1% /u04
/dev/sdi1 269G 59M 256G 1% /u05

in addition to the local disks this server have partitions mounted from a IBM SAN.

Once the clone was done, I realized that the instance was extremely slow & our part time DBA started making excuses like “See that’s why we are changing the hardware” (He had 2G SGA and 1G PGA with 20 job_queue_processes against nearly 1TB database)

I opened few discussions with Oracle communities and was pointed towards a tone of documents suggesting me how to fine tune the hardware and database for better performances. Actually nothing were applicable as I didn’t have much hands on experiences with a database & I couldn’t find a person who could really HELP me.

Then I started taking interest about database technology, which I should have years back & came across SGA/PGA and JVM etc & as I had an idle instance, started trying out whatever I have “learned” against it.

While doing the 11g R2 the hard way I realized that I can use AMM and forget about tuning different parameters for memory optimization. Well, still the goddamn instance lagged like hell & I was almost done with it!.

Few of the persistent issues were:

After a cold boot

  • The login form would load at client end after waiting almost 3-4 minutes, which gets faster during consecutive attempts.
  • It takes ages for to open the concurrent programs window
  • Our custom forms & LOVs lag to extremes and so on..

Even shutting down the instance for anything was turning into a nightmare as the database always took more than 15-20 minutes and I had to kill multiple processes manually in order to bring it offline!

Then on a different note, while trying to learn SQL learning I landed against an ask Tom thread, where the asker says “I have setup both SGA and PGA 3GB”, still the SQL runs slow…

I did a fresh clone. Our database was upgraded to 11g almost year back. The default clone had 1G for both SGA and PGA. I altered them with 3G and 3G & bullseye

I went back and altered the SGA and PGA with 4G which was 40% of the total physical memory available for the hardware. I did three shutdowns and restarts of the physical server, did a dozen application and database startup to confirm that what I am experiencing is NOT a once in bluemoon phenomena. Each of my attempt to shutdown the database gracefully were completed within few seconds, not a single time I had to kill the Linux processes to bring it down!

I modified one of the main forms for a custom application and changed few VIEW calls with better logic & I can’t be happier!

Now, said that, don’t rush to me saying “I also did 4G for SGA and PGA and moron I still have a slow instance”. There are many factors affecting the performance of your database and application & most important few are:

Age of your hardware, especially the spinning disks. The aged they are, the worse the performance is going to be as there is hell loads of I/O happens when you are accessing/processing the data from a database.

Recently I was going through a MS SQL discussion about Multi-Tenant architecture and one of the contributors were discussing about a hosting firm that keeps on changing their hardware once in 6 months. I think he was just BLUFFING! ;)

I hope someone gets benefitted by the minor finding I have made YESTERDAY (6th May 2018)!

regards,

rajesh