Windows 10 Pro Update 1511 Problem – asks me to restart to install the update. It’s a large update, and it probably got corrupted when I cloned the system drive and swapped it out while the update 1511 was downloaded. So Win 10 Pro keeps prompting that I need to reboot to install the update …
note: be careful copying the code below from Windows to Unix as a Windows copy may corrupt the single quotes – just edit them and replace Want to turn off or change Oracle Scheduler windows # disable a maintenance window completely BEGIN dbms_scheduler.disable( name => ‘WEEKNIGHT_WINDOW’); END; / # change the duration of a window …
Want to turn off / disable Oracle's automatic tasks ( dbms_auto_task_admin.disable ): Read More »
Recently solved a mystery that puzzled me a couple of times when installing the newer version 4 of sqlDeveloper in a Windows 10 Pro environment. In the past with version 3 and lower the java path that sqldeveloper used was set by assigning a value to SetJavaHome in the <whatever your path to sqldeveloper>\bin directory …
While many Oracle features are turned on by default, that does not necessarily mean you are using them. If you want to check to see if a feature has been used and when it was last used, do something like this. This examples checks an instance for partitioning usage. Why the “USER” in the where …
Ok, this one is annoying. I’ll use the two terms “trackpad” and “touchpad” as synonyms. I’ve got a laptop with Windows 10 Pro. I use it without a mouse – trackpad only much of the time. It has a nice feature as many laptops do, which is, you can simply “tap” the trackpad instead of …
How to turn off auto click and still use tap to click in Windows 10 using a track pad Read More »
12c? Yes, but not for the features Oracle wants you to like. So far anyway, I’m not seeing much use of container DBs and I don’t know anyone using Oracle’s cloud. Don’t get me wrong, I’m know there are lots of customers using both features. And Oracle is blazing new paths with these type features. …
Here are a few tidbits (not comprehensive – I’ll leave that to Oracle) about “oraInventory”. Generally, it’s directory structure containing XML files that point at installed Oracle Products. Where is “oraInventory”? On Linux & most UNIX dialects here is a pointer to the directory structure: /etc/oraInst.loc or /var/opt/oracle/oraInst.loc $ cat /etc/oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=dba So lets …
This is not advanced troubleshooting and does not address mis-configurations. But, if your OEM agent is not communicating with OMS – try this. cd to the place where “emctl” lives. ./emctl stop agent ./emctl clearstate agent Note: everyonce in a while – I’ll see java “errors/messages” and java appears to be doing garbage collection – …
Here is an example of how to run Oracle new command line SQLCI tool – a super sqlplus based on SQLDeveloper. If you installed 4.1 or higher of SQLDeveloper (and included java in the download) in: C:\sqlDeveloper413 here is the command to run sqlcl with /nolog to get to SQL> prompt. All on one line: …
Here is an example of how to run Oracle's new command line SQLCI tool Read More »
jdbc:oracle:thin:[USER/PASSWORD]@[HOST][:PORT]:SID jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE