If you install a 32bit application in your 64bit Windows OS, following default prompts, the installed product will be under “<drive letter:>”\Program Files (x86)” & Oracle doesn’t really like those braces :)
You should uninstall the software and install it again in a folder that doesn’t have braces or spaces in between in it’s name
eg: C:\Program Files (x86)\some software to >> C:\somesoftware
Toad and few other little utilities available for Oracle will stop complaining about “ORA-06413: Connection not open” once after that.
There could be thousands (exaggerated) reasons why a Oracle cloning process could go all bad. I’m not an application DBA, however, have enough experience with the architecture, technology as I interact with it everyday as a part of my job.
Few months back, I started doing something what a DBA should do, cloning. My prior attempts were mostly at home, using virtual machines and test instances and they were NOT as mission critical as what we do at work.
So, after the storage device was revamped with new partition structures I was asked to do a cloning for the production instance. Let me explain how the application was deployed prior the storage restructuring
We had the database tier on mount point /u05
Application on /u06 mount point
So, I recreated the same mount points and started the cloning process for dbTier and the process got terminated at 2% and the log files shown me an error that I was not familiar with.
“ouicli.pl INSTE8_APPLY 1”
Google searches fetched me hundreds of results for “ouicli.pl INSTE8_APPLY”, however the error codes were mostly for 255 or “-1” and apparently I didn’t have any clue what was going wrong.
So I unzipped the tar ball for database tier once again, and the cloning process got aborted at 2%, and I was getting nervous as I was expected to make the instance online by early morning 7AM
Most of the reference materials were explaining about non-existent Oracle inventory locations, and I confirmed that it was not the case from my part (Obviously, I was overlooking at this constrain itself!)
After half a dozen times tasting failure, finally I tried to see what was written inside the oraInst.loc file
and the cloning process went ahead without giving another errors.
We had an instance that was running from last 6 years, which was only once cloned from a cold backup during the storage device change, and somehow the inventory location remain unchanged with the repositories.
I hope this finding could help few newbies like me out there
Already upgraded to Windows 10? Being a hardcore desktop user from last 18+ years, I do feel Microsoft totally lost it while distinguishing between power users and home users. This hybrid OS is built for touch enabled devices, then for desktops. Many of the applications point you towards window phone site for fixes, confirming that much of such applications were ported for desktop from mobile applications, when this should be opposite!
Being a hybrid and released to masses while it was in the high beta status, Windows 10 has many bleeding edges. Start menu related issues are one of the worse and most difficult to address. There are hundreds of frustrated users flooding the technical support forums asking for fixes and to be very precise there are no immediate solutions for this dreaded issue as on date.
I have three computers running Windows 10 OS. Two computers with RTM build 10240 and one box running the insider preview. One of my 10240 build box started having issues with start button and task bar related issues almost 10 days back, forced me to do a factory reset and the issues came back after 4 days once after the reset. Someone pointed out that the issues were brought back with the cumulative updates release during October, whatever causes it, is annoying.
There are posts stating a particular batch file named “10Services_Default.bat” fixing this dreaded issue, however I haven’t tried it yet. I may, if my box stops behaving once again.
So do we have a fix for it? I was damn lucky (dunno for how long) to revive my PC that was constantly getting this issue by doing following few:
Removed the additional wireless dongle. Hard power off*
Created a new user account with administrator privileges: Hard power off*
Logged in as new user: It took around 20 minutes to logon
Hard power off*
Logged back to the old user & bingo
* Keep pressing the power on button for more than 20 seconds to manually switch off the computer
After almost 48 hours, my box is still responding to the start button and rest of the so called “modern apps”
Whether my own fixes going to help you? I’m not at all sure about it. However, there is no wrong in giving it a try.
There is a problem with accessing the Oracle enterprise manager for 11g R2. After a default installation, the EM console will not even load in Internet explorer, while recent versions of firefox will show an error like following:
An error occurred during a connection to FQDN 1158. The server certificate included a public key that was too weak. (Error code: ssl_error_weak_server_cert_key)
This is due to the SSL certificate that used for securing the enterprise management console, if you are not using the database at a production environment, you can disable the secure mode and get the enterprise manager online with minimum efforts.
Please follow the instructions as given below
From an elevated command prompt
Issue the following command
emctl unsecure dbconsole
(Check the below image for more clarity)
The above exercise restarts the dbconsole service and you should able to access the enterprise manager without any issues.
Side note: Should you allow DBConsole (Enterprise Manager) & other Oracle services start automatically?
Allowing dbconsole & Oracle services starting with each restart of your laptop or desktop boxes having standard hardware configurations would be very displeasing experience. Oracle services require resources(true) and they definitely take much more time to start up and be online against most of other Windows services.
If you have a box that has barely 4GB memory and processor from an old generation, I suggest you to change the startup method to “Manual” from automatic immediately after the installation. Well, your call :)
Below find the Oracle services for which you can safely change the startup mode as “Manual”
OracleDBConsole<database name> (Aka Enterprise manager, allows you to change system wide configurations, setup backups etc)
Once the database configurations are made, you are hardly going to use enterprise manager regularly. That means you don’t even have to start the DBConsole service every time while you restart the database service.
I hope the above guidelines help you to save much of the limited resources and let you use your box more effectively while the Oracle services are running.
Update (19th October 2015): I’m yet to find proper solutions for screen capturing in Windows 10. My favorite OBS doesn’t render the dropdown menus while screen recorded (thread here). Once it’s done, I will make the video as promised with my last update.
Update (12th October 2015) : I’m not promising, however, if possible, I will soon post a video with my Youtube channel explaining how you can configure both forms and reports server for hosting applications. Stay tuned :)
There are excellent articles explaining installing WebLogic 10.3.6 64Bit on Windows. Most of the installation methods are applicable to Windows 7, 8.x & on Windows 10 also. I opted to do a factory reset (the new reset option available with Windows 10) and was forced to re-install & configure WebLogic. I thought of sharing my experiences with you, as usual :)
(There were not a single hiccup experienced throughout the installation, to say it short)
Environment: Windows 10 Professional 64Bit, i5 Processor, 8GB memory, 1TB HDD, Dell laptop
Update 12th October 2015
Weblogic server 10.3.6 has identified issues with IPV6, hence I will suggest you to disable it in case if you are expecting a better experience with your Weblogic servers (forms & reports). ISA, the firewall client also could be a problem.
Once the IPV6 disabled, if you are in a home network or domain network, ping your machine and make sure that your ping replies are coming from your IPV4 address, instead of IPV6. If your computer is a domain member, ask your administrator to delete the IPV6 DNS entries for your box, disable IPV6 in your computer and restart. Ping again to confirm the replies are from IPV4. The issues are random, I had my Windows 8.1 machine with both the protocols enabled and my Weblogic servers just ran smoothly, however my Windows 10 box was adamant and until I disabled IPV6, couldn’t get the report server functional properly.
Install JDK 7 to a folder without spaces in between, preferably C:\ (eg: C:\jdk or D:\jdk). Avoid installing JRE that comes with the JDK package.
Copy your WebLogic installation .jar file to a folder (eg: D:\downloads)
Now kick start the installation, as seen with the below image. It may take a while to deflate the .jar file and the installation to start
Try to install the weblogic server in a folder that doesn’t have spaces in it’s name. I always installed it in D:\weblogic
You don’t have a support for the product most of the times, so uncheck the “I wish…”
Choose the “Typical” for install type
As you started the installation from the JDK installation folder, the local JDK will be already chosen
Select the defaults for components installations(unless you know how to handle it thoroughly)
Install WebLogic for all users
Uncheck “Run Quickstart” and exit the installation by clicking the Close button
Step 4 – Install Developer Suite 11gR2
Installation media for Developer Suite 11gR2 comes as 3 disks. Download (if still available) and start the “Setup.exe” from Disk 1
Select “Skip Software Updates” which requires a paid support from Oracle. If you have one, please set it up prior going ahead with the installation
Select “Install Software – Do Not Configure”. We’ll configure it as part of our Classic Instance setup.
You can ignore the error, details mentions about unsupported operating system, well that’s all our intentions
Unless you have specific requirements, accept the defaults
You don’t have a paid support from Oracle, you don’t get updates. Uncheck “I wish to …”
The installation will start now and it takes quite a while, in my case around 30 minutes. Sit back and relax
Exit the installation clicking “Finish” button.
Step 5 – Configure a Classic Instance
Even though you have installed Developer Suite 11gR2, you cannot yet use the development tools unless a classic domain is set up. Below please see how a classic domain is configured with Developer forms and reports.
A default installation of Oracle Developer Suite should create a folder “Oracle Classic 11g -Home1” under programs. You can activate the classic home setup by invoking menu item “Configure Classic Instance”
(I’m using ClassicShell start menu, I can’t really work with the latest “Start Menu”, so don’t get confused with the below image. You can use the search to find “Configure Classic Instance”)
Select “Configure for Deployment”
Skip the below by unchecking the “I wish to …”
Unless mandatory, accept the defaults
Provide a alphanumeric password for “weblogic” account for the domain. Please note it down, incase if you fear of forgetting it (I do many times)
Important: By default “Oracle Forms and Reports 11g R2” is unchecked, You must check this option to install the developer tools. After checking, proceed with the configuration
Select “Auto Port Configuration”
Select “Do not use proxy settings”. Proxy settings could make weblogic experiences cumbersome. I suggest you use a computer that doesn’t require proxy settings
We are not going to use the Identity store for a local development machine, if you do, please provide the details.
Initiate the configurations by clicking “Configure” button
Configuration should complete in around 30 minutes, so sit back and relax
The above concludes the installation of WebLogic Server 10.3.6 & Developer Suite 11gR2 64Bit on Windows 10.
Let us checkout few essentials those will make sure that you have a seamless experience with the fresh installation.
Unlike the 32Bit, 64Bit installation of WebLogic server doesn’t install node manager Windows service. So you must install the windows service using the scripts provided by the installation process. If you didn’t change any of the default paths while installing the WebLogic server, the node manager windows service installation script file will be available …\wlserver_10.3\server\bin path
Shutdown all running servers using the WebLogic console and restart the computer, this will avoid any sort of complication that could arise while the below exercise are executed.
From an elevated command prompt, running “installNodeMgrSvc.cmd” script will create this node manager windows service for you, which is mandatory for the WebLogic console to maintain your forms & reports servers (start, shutdown)
Once you created the node manager service, you should create a service for WebLogic admin server as well. This will help you from running the batch files manually & having a cluttered desktop later. More than, once created these services can restart themselves whenever you restart the box!
[code language=”text” gutter=”false”]
set MEM_ARGS=-Xms512m -Xmx512m
Copy the above script to a text file and save with a name like “InstallAdminServer.cmd” or with a name that ends with .cmd extension. I will always prefer saving the file in the same folder where we had the node manager service installation script.
Now, from an elevated command prompt, run the script, which should create Admin Server Windows Service for you.
If you followed the instructions, you should see all the services as listed above. You can start the ones which are not running, Please wait a while before trying to access the WebLogic admin console after starting the service. It takes few minutes for the admin server to come online.
I do hope this post will help you to install and configure WebLogic Server and Developer Suite 11gR12 on Windows 10 successfully. Have questions or problems? please update me with the comment section.
I’m posting a sample script for creating suppliers, sites and contacts. I’ve referred multiple sample scripts and believe the below code block is a fine tuned one, however standing refinement at all levels. Please note, I haven’t added the API block for creating banks for suppliers. Will, and update the scripts as I make advancements.
[code language=”sql” gutter=”false”]
/* Formatted on 10/5/2015 11:12:16 AM (QP5 v5.163.1008.3004) */
SET DEFINE OFF;
SET SERVEROUTPUT ON;
— Supplier MUST have a global level payment method
— So that individual companies can defer the default payment method while sites are created
— I have tried the following @ site levels, didn’t work until at supplier level assigned. You may post corrections with
— Comments section
— if the Payable System setup is set automatic numbering for the suppliers (table ->AP_PRODUCT_SETUP Column -> SUPPLIER_NUMBERING_METHOD = ‘AUTOMATIC’)
— You can get the next number from column NEXT_AUTO_SUPPLIER_NUM
— if you are following manual numbering (Alpha Numeric )
— p_vendor_rec.segment1 :=’865′; –(insert non duplicate number, in case if the supplier numbers are not fetched from a sequence, check your setups)
— We do have an automatic numbering for suppliers, hence the below block is used
— If your setups are not as explained above
— Comment from BEING until p_vendor_rec.segment1 := p_vendor_number;
Select NEXT_AUTO_SUPPLIER_NUM into p_vendor_number from AP_PRODUCT_SETUP
where SUPPLIER_NUMBERING_METHOD= ‘AUTOMATIC’;
WHEN NO_DATA_FOUND then
local_failed_at := ‘NUMBER’;
IF local_failed_at = ‘SUPPLIER’
DBMS_OUTPUT.put_line (‘API failed at Supplier Creation’);
ELSIF local_failed_at = ‘SITE’
DBMS_OUTPUT.put_line (‘API failed at Site Creation’);
ELSIF local_failed_at = ‘CONTACT’
DBMS_OUTPUT.put_line (‘API failed at Contact Creation’);
ELSIF local_failed_at = ‘NUMBER’
DBMS_OUTPUT.put_line (‘API failed at getting Supplier Number’);