Expert Blogs - Toad World

Expert Blogs

Blogs

Norm [TeamT]
Follow /25 Aug 2016 at 3:45pm / Oracle Blog

Which Extra Cost Oracle Options is my Windows Server Running?

It’s always nice to know which extra cost Oracle options are enabled, whether deliberately or silently as the result of some patching that has taken place. Copy and paste the code below into a Windows command file named – in my case –...
3 0 /
Roel Hartman
Follow /25 Aug 2016 at 12:56pm / Oracle Blog

Creating an APEX plugin for an Oracle JET component - Part 2

In my previous blogpost I showed how you can embed an Oracle JET component in your APEX application. Now it is time to make a plugin out of the wisdom we gained doing so. First of all a disclaimer. My intention is to make this plugin and the inner workings...
22 0 /
ember.crooks
Follow /25 Aug 2016 at 12:00pm / IBM DB2 Blog

A Physical DBA Reviewing DDL

My background comes largely from the physical DBA world, though I’ve gained logical DBA skills over the years. Any reasonably mature IT organization will have a DBA at some level or another review SQL and DDL before it is implemented in production...
17 0 /
Svetoslav Gyurov
Follow /25 Aug 2016 at 10:27am / Oracle Blog

Grid Infrastructure 12c installation fails because of 255 in the subnet ID

I was doing another GI 12.1.0.2 cluster installation last month when I got really weird error. While root.sh was running on the first node I got the following error: 2016/07/01 15:02:10 CLSRSC-343: Successfully started Oracle Clusterware stack 2016...
33 0 /
Pinal Dave
Follow /25 Aug 2016 at 2:30am / SQL Server Blog

SQL SERVER – Fix Error – Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

Here is a recent email which I received from Madhu. He is a beginner in the SQL Server and when he tried to take a backup from SSMS (SQL Server Management Studio), he got error related to backup file. As soon as he sent me an email I knew what was the...
48 0 /
Deiby Gomez
Follow /25 Aug 2016 at 1:51am / Oracle Blog

Thank you OTN Tour 2016

Oracle Technology Network Latin American Tour (OTN LA Tour) 2016 is done. I started my journey in Montevideo Uruguay, it was my first time there, and I had the opportunity to visit my good friends Nelson Calero and Edelweiss Kammermann . It was good to...
47 0 /
Clarisa Maman Orfali
Follow /24 Aug 2016 at 11:14pm / Oracle Blog

Oracle Developers Tour Latinoamerica 2016 - Call for Papers is Open!!

The Call for Papers for the Oracle Developers Tour Latino America 2016 is now open!! Speakers, we encourage you to submit yours presentations into the form that the ODT organization team has made for all the countries that participate of the Tour. Make...
53 0 /
Clarisa Maman Orfali
Follow /24 Aug 2016 at 11:09pm / Oracle Blog

The pool named: apex…. is not correctly configured… - Error 404 ORDS instalación en GlassFish

En esta oportunidad quiero compartir un error típico que aparece cuando estamos lo más bien trabajando con Apex en una instalación en Glassfish y cada cierto tiempo no podemos conectarnos y nos aparece el error 404. En un post...
54 0 /
John Sterrett
Follow /24 Aug 2016 at 9:25pm / SQL Server Blog

Calculating DTU in Azure SQL Database

A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure DTU? How could you pull the data shown in the Azure Portal graphs with T-SQL? No one answered, so this motivated me get off my butt and answer...
11 0 /
Denny Cherry
Follow /24 Aug 2016 at 5:00pm / SQL Server Blog

Releasing a Page Blog Lease in Azure

Sometimes when firing up VMs or moving VMs from the page or blob store you’ll get an error that there is still a lease on the file.  To solve this you need to release the lease. But waiting won’t do the trick, as the leases don’t have...
7 0 /
Steven Feuerstein
Follow /24 Aug 2016 at 4:47pm / Oracle Blog

PL/SQL at Oracle Open World 2016

If you work with PL/SQL, you will not want to miss any of these sessions : The Best Oracle Database 12 c New Features for Developers and DBAs [UGF2028] Alex Zaballa , Senior Oracle Database Administrator , Accenture Enkitec Group This presentation looks...
223 0 /
DaveBeulke
Follow /24 Aug 2016 at 4:37pm / IBM DB2 Blog

3 Consideration for Enjoying the Data Lake

With all the outside activities with friends and family, summer vacations are always wonderful. Being outside at the lake enjoying the warm weather and cooling off in the lake are a wonderfully relaxing great times. This is the safe, content image that...
41 0 /
James Serra
Follow /24 Aug 2016 at 4:00pm / SQL Server Blog

SQL Server 2016 real-time operational analytics

SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both analytics (OLAP) and OLTP workloads on the same database tables at the same time.  This allows you to eliminate the need for ETL...
8 0 /
Dan Hotka
Follow /24 Aug 2016 at 3:37pm / Oracle Blog

SQL Tuning Webinar Series

Hi! Here is an interesting event that all of you should make sure to attend. I’m doing a 4-part SQL tuning webinar series for Dell. Click here to see exact details and to register. This material is not just for Toad users…I think anyone...
55 0 /
Thomas LaRock
Follow /24 Aug 2016 at 3:32pm / SQL Server Blog

More General and Less SQL

Many DBAs liken their roles to being a mechanic, and with everything under the hood of SQL Server these days I think an F1 mechanic is an apt comparison. The post More General and Less SQL appeared first on Thomas LaRock . If you liked this post then...
71 0 /
Brendan Tierney
Follow /24 Aug 2016 at 3:02pm / Oracle Blog

How to get ORE to work with APEX

This blog post will bring you through the steps of how to get Oracle R Enterprise (ORE) to work with APEX. The reason for this blog posts is that since ORE 1.4+ the security model has changed for how you access and run in-database user defined R scripts...
63 0 /
sqlsanctum
Follow /24 Aug 2016 at 3:00pm / SQL Server Blog

Remotely Enable Always On

Always On Availability Groups is the new feature for High Availability in SQL Server 2012. It’s been out for awhile now, but unless you have Enterprise Edition SQL, you might not have been able to use it much. Of course you need a cluster to utilize...
7 0 /
Steven Feuerstein
Follow /24 Aug 2016 at 2:37pm / Oracle Blog

PL/SQL Optimization Levels and Native Code Generation

Charles Wetherell, Consulting Member of the PL/SQL development team, was kind enough to offer these insights regarding PL/SQL optimization and native code generation. A PL/SQL programmer asked why PL/SQL native code generation was turned off when the...
47 0 /
Kenneth Fisher
Follow /24 Aug 2016 at 2:00pm / SQL Server Blog

Copying an on-premis Database to an Azure SQL Database

Continuing my exploration of Azure the next logical step seemed to be copying an on-premis database up to the cloud. This is also the next in the ideas I got while watching Jes Borland’s ( b / t ) excellent session on Azure and SQL Server on the...
7 0 /
Jason Brimhall
Follow /24 Aug 2016 at 1:30pm / SQL Server Blog

Finding the Right Path

I have a fairly large backlog of articles that are in progress or that are planned for my series about Extended Events. Despite the backlog and planned articles, every now and then something else comes up that bumps things around. This article is an example...
8 0 /
o.mustafaoracle
Follow /24 Aug 2016 at 12:30pm / Oracle Blog

oracle.security.jps.wls.listeners.JpsApplicationLifecycleListener' Class not Found

Aug 24, 2016 2:23:57 PM weblogic.nodemanager.server.AbstractServerManager log INFO: Server output log file is '/u01/Oracle/Middleware/domains/mserver/STAGEDQ/servers/EDQ_INS1_SIPEDQ1/logs/EDQ_INS1_SIPEDQ1.out' java.io.IOException: Server failed...
43 0 /
o.mustafaoracle
Follow /24 Aug 2016 at 8:57am / Oracle Blog

Apply Weblogic Patch Offline mode

Shutdown all the services for weblogic. unzip the patch under $MW_HOME/utils/bsu/cache_dir run the following command :- ./bsu.sh -prod_dir=$weblogic_home -patch_download_dir=Patch_location -patchlist=patch_id -verbose -install The final Result Or you...
38 0 /
Hemantgiri S. Goswami
Follow /24 Aug 2016 at 7:58am / SQL Server Blog

Resolve Microsoft SQL Server Error Code 824

Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the data consistency at every step. Sometimes, the user may face SQL Server Error 824 while making any SQL query or data modification...
56 0 /
Guy Harrison
Follow /24 Aug 2016 at 6:22am / Oracle Blog

Graph Lookup in MongoDB 3.3

Specialized graph databases such as Neo4J specialize in traversing graphs of relationships – such as those you might find in a social network. Many non-graph databases have been incorporating Graph Compute Engines to perform similar tasks. In the...
33 0 /
Pinal Dave
Follow /24 Aug 2016 at 2:30am / SQL Server Blog

SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step ‘upgrade_ucp_cmdw.sql’

Recently once by my client contacted via Skype to know my thoughts about a cluster failover failure issue. They were having two nodes SQL Clustered instance and it was running fine of Node1. As soon as they failover to Node2, it was not able to start...
69 0 /