Starting from Notepad++ 7.5.x “Plugin Manager” is not bundled with this editor & you would find why and associated reasons here
So how do we have this “Plugin” configured for managing the plugins? Well the solution is pretty straight forward, download the latest version of the plugin manager from here
Please note, after downloading the plugin which is a zip archive, you need to extract it and there will be two folders, one for the Plugin Manager plugin & other one for the updater. Check the below image:
Note: The instructions given below are specific to 32-Bit version of Notepad++
Now, copy “PluginManager.dll” from plugins folder to “C:\Program Files (x86)\Notepad++\plugins” (default installation location, adjust to suite your environment)
Copy “gpup.exe” from “updater” folder to “C:\Program Files (x86)\Notepad++\updater” (Mandatory)
Now you are all set to start using Plugin Manager once again.
I confirm, I am not a DBA, yet my last 10 years with Oracle EBS experiments have given me opportunities to learn few facts those are not documented generally.
A general approach towards deploying a new setup/custom development for EBS is 1st developed and tested thoroughly for which a business needs testing environment. To provide such, a DBA “clones” or duplicates the existing environment and this process is called cloning.
A majority of the environments may note have the hardware with same configurations as it is available for the Production, this causes the cloned instances to perform poorly, thus making the entire testing pretty painful.
During the initial stages of learning, I had tough time digesting our part time DBA’s arguments and reasoning for the slowness, tied to the hardware limitations. Our TEST server has dual processors and 20GB memory with more than 3 TB storage that is hooked up to a 1GB network interface.
As my confidence kept on building, I started exploring the database setups and realized the DBA had only allocated 2GB for SGA & 1GB for the PGA. While questioned, he gave me all possible excuses like “Well, your instance doesn’t require more” and so on.
We got rid of him & had another DBA in the due course, who was far better and more experienced handling bigger environments. Yet we had this nagging issues related to the test instance being slow, lagging beyond our extended patience & I started asking oracle communities questions about how to speed up things.
“Not being a DBA” had it’s own limitations. Many instructions were beyond my understanding, many sounded impractical or illogical & finally one day I decided to setup the R12 (12.0.6, 11gR2 database) with 3GB for both SGA, PGA following an old discussion available with asktom.
That was the beginning. Our TEST instance performance improved to a level that, it become difficult to distinguish between the production and test instances when the Production instance is a beast (minimum for our environment)
Although, the manual SGA/PGA settings resolved one of the major performance related issues (login page load, opening large forms etc), I was still NOT convinced by the performance (Queries taking long time..). For some other reasons, I had to restart the TEST server (Which usually happens once in many months time) & was amazed to see that the performance gains were distinguishable from earlier times. As soon as I tried to access the instance, the login screen was loaded (not ignoring the cache mechanisms) faster, so did rest of the accesses. Forms based interfaces were loading faster and the queries were returned instantly etc.
I opted for another cloning. Dropped the entire R12 instances and repeated the cloning, adjusted the database parameters and “RESTARTED” the physical server, started the database and application tiers and insured that the performance gains I observed were not just a hit and miss, actually a permanent HIT that exists.
I continued my experiments further. My next attempt was to upgrade the SGA, PGA with more memory and this time I opted for 4GB for each sector. After the database & application restart I realized the poor performance. I was expecting the instance to be faster! Instead I was dealing with an instance that was as horrible as possible prior to my 3GB/restart patterns.
So I rolled back to 3GB SGA, PGA setups and was living with it until our finance consultant asked me for a fresh clone with most recent data. This time I decided to duplicate database using RMAN rather than a traditional cold back restore and cloning.
As RMAN duplicate database doesn’t require me to alter the database (as the spfile is already available), all I needed was to run the “adautoconfig” from the application tier and go online. I felt something awkward
Although the instance was “Okay”, there were few things which were NOT AT all okay. The database alert log was showing redo log files related issues. I checked the redo log files, things were looking Okay against the documents those I were referring to do the RMAN duplicate database…yet
I took the application tier offline and altered the database like following:
Increased the SGA max memory to 5GB and target to 4GB, restarted the database (40% of total available memory)
Left PGA at 3GB (Thus totaling the memory dedicated for the database to 8GB out of 20GB available)
From the database tier, executed “adautoconfig”
Execute “adautoconfig” from the application tier
Shutdown database and restarted the physical server
Restarted database and application tiers & boom, the instance was once again giving me the buttery smooth experience. I ain’t sure, whether it is technically correct, it was all about executing “adautoconfig” against both tiers after database parameter changes. I will ask Oracle community soon to confirm it.
Now, all the above experiments with an obsolete release of Oracle application R12 (12.0.6) over an OS (Linux 6) that’s not supported were performed over many months time. Lack of true technical training must be one of the reasons contributing towards painful experiences.
Well, whatever, today I feel like a winner. Just because I am able to host an instance of the application over a hardware that was labelled obsoleted just because someone didn’t know how to fine tune an instance of Oracle application, even though he is certified to do that!
If you are like me, not certified, a jack of everything, who loves to keep on experimenting, do give the above a try & post me your experiences!
Currently we are developing a small custom module better controlled sub-inventory transfers. This solution involves an approach as described below:
Our engineering division technicians will receive tools from main warehouse & each technician will have a store locator automatically created when the tools are issued against them for the 1st time.
So the requirement was to create stock locators under the main sub-inventory automatically while the issue happens.
We opted to use INV_LOC_WMS_PUB public API to create stock locators and came across an error, that keep on giving us the below error:
‘Could not create locator.’ and the return status was ‘U’. It looks like the API is not widely used, hence there were hardly many references available online & all we had was the Oracle support knowledge base. Unfortunately most of the documents were not referring obsolete versions like 12.0.x & we decided to go through each and every other document that was dealing with the API.
The we came across a document “Cannot Create Locators Using The INV_LOC_WMS_PUB API (Doc ID 283472.1)”, which had the correct solution for the issues we were facing with the API.
Please note, the below instructions ONLY deal with the situations when the return status from the API is “U”
Using one of the INV super user responsibilities, navigate to:
Setup -> Flexfields -> Key -> Segments
Query for “Stock Locators” Flexfield title
Check whether “Allow Dynamic Inserts” checkbox is selected. If not, select it and save. Now onwards you should able to run the API successfully.
Sample API Script (Adjust to your environment, tested against R12 12.0.6, Database:11gR2)
[code language=”sql” gutter=”false”]
SET DEFINE OFF;
SET SERVEROUTPUT ON SIZE UNLIMITED;
— Common Declarations
l_api_version NUMBER := 1.0;
x_msg_count NUMBER := 0;
— WHO columns
l_user_id NUMBER := -1;
l_resp_id NUMBER := -1;
l_application_id NUMBER := -1;
l_row_cnt NUMBER := 1;
l_user_name VARCHAR2(30) := ‘ABC’;
l_resp_name VARCHAR2(50) := ‘XYZ INV Super User’;
— API specific declarations
x_inventory_location_id NUMBER := NULL;
x_locator_exists VARCHAR2(1) := NULL;
— Get the user_id
WHERE user_name = l_user_name;
— Get the application_id and responsibility_id
SELECT application_id, responsibility_id
INTO l_application_id, l_resp_id
WHERE responsibility_name = l_resp_name;
IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
DBMS_OUTPUT.PUT_LINE(‘Msg Count:’||x_msg_count||’ Error Message :’||x_msg_data);
IF ( x_msg_count > 1 ) THEN
FOR i IN 1 .. x_msg_count LOOP
x_msg_data := fnd_msg_pub.get ( p_msg_index => i , p_encoded =>FND_API.G_FALSE ) ;
dbms_output.put_line ( ‘message :’ || x_msg_data);
My last build was 6+ years back. I did many upgrades, mostly with the memory & storage as I have a number of virtual machines through Oracle VirtualBox & from last three years I stopped taking office work to home, in order to have a better family life. So the PC is mostly used for YouTube & studies related activities by my kids. Once in a while (when I am allowed to use), I use it for work.
I’ve been thinking about an upgrade dearly, as the desktop started giving me a feeling that it was lagging, especially during the Windows startup.
I did a quick assessment and realized that the Intel OEM motherboard supports DDR3 32GB memory (Currently I have 16GB memory) and has SATA standard 3. I already have 5TB+ storage and one 850W PSU. A studio standard sound card from Creative and supported by an Intel i7 generation 2 processor which made the an “Awesome” unit when I built it initially.
From the investment point (both money and efforts), a new PC (Assembled) would cost me approximately 250-300 Kuwaiti Dinars (800-950$) & as the Desktop accessories market is slowly dying, the chances of finding all the items for assembling would be kind of time consuming and tiring activity.
Although a new motherboard and latest processor & memory means support and performance that existing PC could never offer after any number of upgrades, I decided to “upgrade” my current PC for one last time.
This upgrade included a single item and the total expense expected was 36.5KDs (36.5*3.2 = 116USD approximately), and the item was a Crucial MX500 500GB SSD!
I used EaseUS ToDo Backup free’s cloning utility to clone my existing 512GB mechanical drive (approximately 220GB data) which took around 1.5 hours & realized that I never felt my desktop PC such fast and responsive.
From my last 48+ hours assessment, following are few of the changes I have noticed.
My Windows 10 Pro 64Bit OS (Build 1809) starts and ready in 5-10 seconds time (Fast boot enabled), which was approximately 4-5 minutes prior the SSD inclusion.
My desktop machine shuts down within a time frame of 2-3 minutes, which was never less than 10 minutes (with almost no active database services other than an instance of MySQL and Google’s drive sync software. I found the later being one of the culprits)
The overall responsiveness has tremendously improved & the constantly nagging delays with starting software like Microsoft word & Excel are not anymore existing.
I know from my previous experiences with SSDs that, after a while, I would start feeling the PC turning slow, which is more psychological than technical.
So, if you WERE planning to replace your PC that’s is less than four years old, for it being “too slow”, “lagging” consider a SSD or NVMe M.2 (if supported). One of the major realities you should be considering when opting for a SSD is whether the OS & Processor support the SSDs. I’ve read somewhere that Windows 10 OS, starting from build 1703 has patched up with better support for SSDs and flash based storage.
One important note for Laptop users. Yes, you can also replace your mechanical drive with a SSD and enjoy the above said performance gains. Just make sure that your Laptop supports an SSD (read manuals, ask manufacturer forums or write to their support).
All the best with an upgrade & saving some real money folks!