For those of you who end up using the Oracle Developers Day VM for more that just demo's but playing with other things too, will find that at some point, you'll need more space. (Like I did) Today's post is about just that. We're going to add a new VMDK drive to our virtual machine and configure it so its available to you in the machine.
First thing we want to do is to have a list of the devices in your linux box. This will save you searching for it once you add it later.
[oracle@localhost ~]$ cd (more...)
[This post was originally published on 2012/02/29 and was hidden shortly thereafter. I'm un-hiding it as of 2012/05/30 with some minor edits.]
Many Oracle Database users like tools with GUI interfaces because they add features and functionality that are not easily available from the command line interfaces like SQL*Plus. One of the more popular tools from my experiences is Oracle SQL Developer in part because it’s a free tool from Oracle. Given SQL Developer’s current design (as of version 3.1.07.42), some issues frequently show up when using it with Oracle Databases with Parallel Execution. SQL Developer (more...)
I'm speaking next week at the UK Oracle User Group at the ICC in Birmingham. The topic will be one I've posted several times about which is Tuning, Refactoring and Instrumentation. Have a look at the agenda, and if you are in town, come along. You can click on the image to go to the conference site and check out the agenda.
Working through security issues uncovers some interesting things. Anyone who has developed scripts for building out schemas for an application will have had the issues of passing variables to subscripts or managing password visibility when creating users, building objects or granting permissions
SQLDeveloper and SQL*Plus have substitution variables to solve this problem. Basically, there are two types of substitution variables, & and &&. &foo is used to refer to the variable foo. &&foo is also used to refer to the variable foo. The main difference between the two variables is that first time SQL*Plus comes across a variable defined with (more...)
@thatjeffsmith asked me today about running SQL*Plus from SQLDeveloper for his current sql file. This has been shown before, but there is a simple way to add it and to get it to run your file under SQL*Plus.
The only caveate on this example, is that we are using the bequeath adapter to connect to a local XE database. You can amend this to add a service after the username
The main steps are to point the program executable to your SQLPlus, which will populate the executable and the Run directory. Next you need to populate the arguments, which for (more...)
I encountered this error “I/O Error: SSO Failed: Native SSPI library not loaded” when using Oracle SQL Developer connecting to a MS SQL database using Windows Authentication. Fortunately, couple web sites (here and here) already mentioned about this.
Basically, from the jTDS distribution downloaded files, I have to copy a DLL file named ntlmauth.dll (which is for NT authentication) under the jtds-x.x.x-dist\x86\SSO\ or jtds-x.x.x-dist\x64\SSO\, to any directories in the PATH environment. I copied it to the bin directory of the JDK (which I already have it in the (more...)
After Oracle decided that SQL Developer Data Modeler should be a paid-for product, adoption naturally dropped to so close to zero you couldn’t measure it. I’ve asked around at several conferences and never managed to find a single person who paid for this product…
Just before Oracle OpenWorld, Oracle realized (more...)
Did you know that ODTUG is podcasting? I hear a couple of podcasts on the way to work the other day, and they’re good. I encourage you to sign up at odtug.podhead.net.
The latest episode was an interview with Sue Harper about the upcoming SQL Developer 2.0, (more...)