Uncategorized « Ora-lytics

Busy start to 2014 Speaking at Conferences **Updated

Posted on February 6, 2014

UPDATED list of conferences

We are just a few weeks into 2014 and it has been a busy time with Oracle User Group Conferences.

January : BIWA Summit

In January I gave 2 presentations at the BIWA Summit. This conference was held in the Oracle Convention Centre at Oracle Head Office.

March : OUG Ireland

I also have one presentation at the OUG Ireland conference in Dublin on the 11th March. As always this is a great day fill with sessions for well known speakers from around the world. This year we will have 6 tracks packed full. It is also a great opportunity to catch up with some friends I have known for 20+ years. Click on the following image for details of the agenda and how to register for the conference.

April : OUG Norway

I’ve also received notice that I will have 2 presentations at the Norway Oracle User Group. I’m delighted with this, as I was at this conference last year and really enjoyed it. This conference will be on the ship again this year between April 3-5, getting back into Oslo around 10am on the 5th April. Click on the following image for details of the agenda and how to register for the conference.

June : OUG Finland

In the past few days I’ve also received news that I will have 2 presentations at the Finland Oracle User Group conference. This will be my first time in Finland and I hope to get a few hours to do some exploring of Helsinki when I’m there. One of my presentations will be on using Oracle Data Miner and the second presentation will be on using R in the Oracle Database (or more correctly Oracle R Enterprise). Click on the following link for more details of the conference.

Hopefully I will see you at one of these conferences. Do make sure you say hello to me and let me know if you have any questions about the Oracle Advanced Analytics Option.

Second half of 2014

This second half of 2014 will probably be a bit quieter, but hopefully I’ll be at Oracle Open World in September (speaking or not) and also at the UKOUG Annual Conference (TECH14 or whatever it will be called) in December (speaking or not).

My travels (flights and hotel costs) to present at these conferences is made possible thanks to the Oracle ACE Director program. Also to DIT for allowing me to go.

This entry was posted in Uncategorized.

Oracle BigDataLite 2.4.1 is available to download

Posted on January 29, 2014

Oracle has made available the BigDataLite VM appliance to download. This VM is for evaluation purposes only and is a great way to try out the various products that Oracle has in the Big Data area.

Another major advanced of downloading and using the VM is that you don’t have the “fun” of trying to install everything yourself, getting everything configured and working together.

The BigDataLite 2.4.1 VM comes with the following:

Oracle Database 12.1c
Cloudera’s Distribution including Apache Hadoop (CDH4.5)
Cloudera Manager 4.8
Oracle Big Data Connectors 2.4
Oracle NoSQL Database 2.1.54
Oracle JDeveloper 11g (11.1.1.6.0 )
Oracle SQL Developer 4.0
Oracle Data Integrator 12c R1
Oracle R Distribution 3.0.1

There are a number of Hands-on-Labs that you can run on the VM and it comes with the MoviePlex demo data.

Get all the details and links for downloads at

http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html

WARNING: you will need a decent spec PC or laptop to host this VM. The recommendation is that you can dedicate 2 cores, at least 5GB RAM and >30G of disk for the VM. The install requires ~40G of space So this might not be for everyone.

This entry was posted in Uncategorized.

OUG Ireland 2014 Conference

Posted on January 15, 2014

The agenda has just gone live for the OUG Ireland Conference that will be on 11th March, 2014. The conference will again be in the Dublin Convention Centre (DCC). I’m on the conference committee again this year Smile . Part of the duties includes the presentation selection and agenda planning.

This year we have over 100 submission from well know experts from around the world and from a variety of customer case students. With a limited number of slots available there was some VERY VERY difficult decisions made. To included everyone that I wanted to present at the conference we would need to run the conference over 3 days. Sadly this was not possible.

An new feature of the conference this years is that we will have Tom Kyte giving a fully day of sessions the day after the conference. This will be a paid for event.

To view the agenda for the conference you can click on the image below.

To register for the conference and the extra 1 day workshops with Tom Kyte or 12c Workshop with Joel Goodman and Uwe Hesse, go to.

http://www.ireland14.oug.org/default.asp?p=10500

I have one presentation at the conference, so hopefully I’ll see you there.

This entry was posted in Uncategorized.

Some resources to get started with Hadoop

Posted on January 10, 2014

Cloudera and other sides have made available a number of resources for help all of us to get up to speed with using Hadoop etc.

So if you are starting out with Hadoop here is a short list of key resources that I have found very useful.

Cloudera Hapood Virtual Machine

The Hadoop FAQ for DBAs

Cloudera Newsletter for Developers

Cloudera New to Hadoop

Udacity course : Introduction to Hadoop and MapReduce

http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=1449311520&nou=1&ref=qf_sp_asin_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=1449311520&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr

http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=1935182196&nou=1&ref=qf_sp_asin_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=1935182196&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr

http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=1449327052&nou=1&ref=qf_sp_asin_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=1449327052&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr

This entry was posted in Uncategorized.

BIWA Summit 2014

Posted on December 21, 2013

The BIWA Summit 2014 is on from January 14th-16th, and is located in the Oracle Conference Center, at Oracle Head Office, in Redwood City (CA, USA). This conference is organised by a very dedicated and experienced group of people, including some very senior people in Oracle who are responsible for various analytics offerings from Oracle.

I presented that this conference last January (2013), and I’ve been tempted into presenting again in January (2014).

The conference has been expanded with more parallel tracks, a hands-on track, and a meet the experts/presenters session. So lots and lots more content and learning experiences.

I will be giving two presentations. The first one is on how Universities in the UK are using Oracle Data Miner and OBIEE to manage their Student Churn. I gave this presentation at Oracle Open World (Sept, 2013) along with Tony Heljula from Peak Indicators. This time (Tuesday 14th @10am) I’ll be giving the presentation on my own. My second presentation is a demonstration of how you can use Oracle Data Miner to do Sentiment Analysis using a sample data set from Kaggle (Wednesday 15th @11:15am). I’ve given this presentation a couple of times already and the feedback that I keep on hearing is ‘I didn’t know you could do that in Oracle’. So it is an alternative to using Endeca, R and any of the other tools that we keep on hearing about. Instead we can just use SQL.

If you come to one of my presentations make sure you ask me for one of my Oracle Data Scientist conference ribbons. I got these made up for Oracle Open World and there was lots of interest in them.

I’ve agreed to take part in the meet the experts/presenters. This is were attendees at the conference can sign up for a 15 minute 1-to-1 slot with one of the experts/presenters. I’ll be available for this from 3pm on Wednesday 15th. If you would like to sign up for one of these slots then there will be a sign up sheet at the conference. I will be hanging out at the conference for most of the 2.5 days, so do make sure you say hello at some stage.

The full agenda is live (subject to change of course) and can be found by clicking on the image below

Hopefully I’ll see you there.

This entry was posted in Uncategorized.

UKOUG TECH13

Posted on November 28, 2013

The UKOUG TECH13 conference is starting on Sunday and this year things a bit different. In previous years there was one big conference that covered (almost) everything and this conference had been in Birmingham.

This year Birmingham has been replaced by Manchester and the conference will focus on Database, Development with a few bits and pieces from other areas. The full agenda can be found here.

www.tech13.ukoug.org/agenda

Also this year the OakTable people are back but they will be in a different venue from the main conference. The OakTable World UK conference will be across the road in the Premier Inn and be on for two days on the Monday and Tuesday. Check out the agenda here

www.scaleabilities.co.uk/oaktable-world-uk-2013

When I’m not in the Manchester Central conference centre attending some excellent presentations, you will find me over at the Premier Inn. I expect there will be a lot of people running between the two venues over the Monday and Tuesday.

On the Wednesday morning I will be giving a presentation on how you can perform sentiment analysis using the Oracle Advanced Analytics Option (aka using Oracle Data Mining). I’ve tried to keep the number of slides to a minimum for this presentation, so most of the time will be taken up with a live demo of how to build a Sentiment Analysis Model using the Oracle Data Miner tool, then we jump into SQL*Plus and I will show how you can use the Sentiment model using SQL. The final part of the presentation I will show how you can then add the Sentiment model to OBIEE.

So lots of demos and code examples. Fingers cross it all works on the day Smile

I’ll also be making a little announcement about something that I have been working on recently and should be available in Spring 2014 Smile

This entry was posted in Uncategorized.

New Oracle Magazines for my Collection

Posted on November 26, 2013

You may or may not know that I have been collecting Oracle Magazines. It all began back when I had my very first job as a graduate consultant with Oracle in Ireland. A few days ago I received a package that contained the following Oracle Magazines. You will see that the list contains the very first edition and the second edition. Up to now I’ve just had an electronic copy of the first edition.

Here is the full list of the Oracle Magazines that were in the package.

– Volume 1, Number 1 : A New Dimension in Customer Support & Oracle version 5.1 Released
– Fall 1987, Volume 1, Number 2 : Enhancing Cellular Communications Oracle Helps Canada go Mobile
– Winter 1990, Volume IV, Number 1 : Focus on Financial Services & Systems Integration
– Spring 1990, Volume IV, Number 2 : Focus on Pharmaceuticals & National Language Support
– Summer 1990, Volume IV, Number 3 : Focus on Public Sector & Networking the Network
– Summer 1991, Volume V, Number 3 : Focus on Telecommunications & Open Systems Standards
– Winter 1992, Volume VI, Number 1 : Manufacturing Technologies & Massively Parallel Systems
– Spring 1992, Volume VI, Number 2 : Smart Cities Integrating Old and New, & Interview with Next Computer’s Steve Jobs
– Summer 1992, Volume VI, Number 3 : Mapping the Human Blueprint & Oracle version 7
– Fall 1994, Volume VIII, Number 4 : Systems Management & Oracle 7.1. Parallel Everything
– January/February 1995, Volume IX, Number 1 : Data Warehouse
– July/August 1995, Volume IX, Number 4 : Distributed Enterprise & Oracle release 7.2
– September/October 1995, Volume IX, Number 5 : Mission Critical Applications & Optimal Flexible Architecture
– November/December 1995, Volume IX, Number 6 : Managing Change & Client.Server Administrator Security
– January/February 1996, Volume X, Number 1 : Untangling the Web & Tuning Oracle 7 for Optimal Performance
– March/April 1997, Volume XI, Number 2 : Platform Diving & Performance Tuning with Oracle Expert.

My Oracle Magazine Collection can be found here. You will find links to my blog posts that summarize the contents of some of the previous editions. This is a work in progress project and at some point I will have summarized them all. On my Oracle Magazine Collection page I have a PDF for the very first Oracle Magazine from June 1987.

I’m now very close to having the full collection. If you have any of the magazines that I’m missing and you are willing to donate them, let me know Smile

This entry was posted in Uncategorized.

2014 Oracle User Group Conferences

Posted on November 15, 2013

Over the past few days I’ve put together a list of Oracle User Group Conferences from around the World that will be on in 2014.

This list is not complete and I’m sure I have left out some very well known conferences. If I have left a conference out let me know. If you are running a conference let me know and I will add these to the list.

The table below is my initial list. I’ve also posted this list to a new page called OUG Confs. This can be accessed from the menu at the top of my webpage. The plan is to keep this table updated (on the page/menu link) going forward into 2014, 2015 and beyond.

The only non Oracle User Group conference that I have included in the list is Oracle Open World.

2014

Date	Conference Name / Web Site	CFP Open	CFP Close
14-16 January	BIWA Summit http://www.biwasummit.com/ Redwood, CA, USA		Closed
5-7 February	RMOUG Training Days http://www.rmoug.org/training/training-days-2014-registration/ Denver, USA		Closed

11^th March	OUG Ireland http://www.ireland14.oug.org/ Dublin, Ireland	1^st November, 2013	15^th December, 2013

3-5 April	OUG Norway http://www.ougn.no/a/320 Oslo, Norway	September, 2013	1^st December, 2013
7-11 April	COLLABORATE 14 http://collaborate.oaug.org/ Las Vegas, USA		Closed
May	OUG Bulgaria http://www.bgoug.org/en , Bulgaria
2-3 June	E4 2014 – Enkitec Extreme Exadata Expo Dallas, Texas Registration opens : 2^nd January, 2014	Nov, 2013	31 Dec 2013
5-6 June	OUG Finland Finland	September, 2013	15^th January (Notification : 14^th Feb)
22-26 June	KSCOPE http://kscope14.com/ Seattle, USA		15^th October, 2013

27 Sept – 2 Oct	Oracle Open World http://www.oracle.com/openworld San Francisco, USA
Sept-Oct	Oak Table World San Francisco, USA
Oct	UKOUG APPS Conference www.ukoug.org , UK
Nov	OUG New Zealand http://www.nzoug.org
Nov	Australian OUG – INSYNC Conference http://www.ausoug.org.au , Australia
30 Nov – 3 Dec	UKOUG TECH Conference www.ukoug.org , UK	May	July
Dec	Oak Table World UK http://www.scaleabilities.co.uk/oaktable-world-uk-2013/ , UK #OTWUK14

This entry was posted in Uncategorized.

ODMr 4 EA3 : Repository Migration Failure

Posted on November 14, 2013

SQL Developer 4 Early Adaptor release 3 (EA3) was released just over a week ago. This EA3 release has over 500 bug or “feature” fixes since the EA2 release.

But there could be some new “features” introduced into the new EA3. This is the case with the Oracle Data Miner tool. One of the based features of using this tool is that a ODM repository is needed in the database. With each new release of the Oracle Data Miner tool there are typically some new features added to the repository. This will require an upgrade to be done to your repository.

For EA3 this repository upgrade steps does not seem to work. If you use automatically perform the upgrade it will not complete and will leave your repository in a locked state.

Fortunately Mark Kelly put up a notice about this on OTN along with how to fix it.

When EA2 came out just before OOW13, I performed the upgrade to EA2 on my laptop. During the EA2 upgrade the my ODM repository got recreated and I lost all my ODM work. As I was in the USA when this happened I did not have access to my backup and I had to wait until I got back home after OOW13 to recover my work.

So when EA3 was released I was not in a hurry to upgrade straight away. I waited just over a week. I was about to perform the upgrade and migrate my repository when I received the email notification of the post on the ODM OTN forum. I had a lucky escape Smile

The “fix” involves a minor change to one of the scripts that comes with Oracle Data Miner (part of SQL Developer EA3) and just involves a cut and past from the post on the OTN forum.

I’ve make the suggested changes and I’m delighted to report that everything has worked without any problems. There are a number of “feature” fixes in ODMr EA3 which I’ve been able to test out so far.

Check out the OTN form post here.

I’ve now upgraded my ODM repositories on my 11.2.0.3 and 12.1 databases and all seems to be good.

This entry was posted in Uncategorized.

Dropping all your ODM model

Posted on November 11, 2013

This post is main a note to myself of a script to drop all my Oracle Data Miner models.

1. Check to see what models you have in your schema

SELECT model_name,
       mining_function,
       algorithm,
       build_duration,
       model_size
FROM ALL_MINING_MODELS;

2. Drop all the ODM models

set serveroutput on
DECLARE
   cursor c_1 is SELECT model_name
                 FROM ALL_MINING_MODELS;
BEGIN
FOR r_1 in c_1 LOOP
     dbms_output.put_line(‘Dropping model ‘||r_1.model_name);
     DBMS_DATA_MINING.DROP_MODEL(model_name => r_1.model_name);
END LOOP;
commit;
END;
/

This entry was posted in Uncategorized.

Oracle 12c Book List for Santa

Posted on November 6, 2013

How many days are there to Christmas?

select
to_date(’25/12/2011′,’DD/MM/YYYY’) – trunc(sysdate) “How Many Sleep to Santa”
from dual;

There are a few Oracle 12c books available on Amazon (see below for amazon.co.uk). Here is my letter to Santa

Dear Santa

Could I have some of these books? I’ve been good this year.

Brendan

Certification
http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=0071819975&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=1492323896&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=0071820280&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=0071829237&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=111864395X&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr

Kindle
http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=B00DQSTPUE&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=B00DRC95Y0&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=B00C4BDR62&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=B00ACC6BLS&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-na.amazon-adsystem.com/e/cm?t=brendantierne-20&o=1&p=8&l=as1&asins=B00BDE689Y&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr

Certification
http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=1492323896&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=0071819975&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=0071829237&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=0071828680&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=0071820280&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr

Kindle
http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=B00DQSTPUE&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=B00ACC6BLS&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=B00C4BDR62&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=B00BUMZUD4&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr http://rcm-eu.amazon-adsystem.com/e/cm?t=academicwebsi-21&o=2&p=8&l=as1&asins=B00DRC95Y0&nou=1&ref=tf_til&fc1=000000&IS2=1&lt1=_blank&m=amazon&lc1=0000FF&bc1=000000&bg1=FFFFFF&f=ifr

This entry was posted in Uncategorized.

SQL Developer is dropping connections

Posted on November 4, 2013

I have SQL Dev 3.2.2 (32-bit) with the supplied JDK running on windows, in work and is rolled out to a large number of PCs. Sometimes we can have 10 users running SQL Developer against our 11.2 Database. But sometimes we can have 100 users using SQL Developer at the same time. They have all set up their connections to use the jdbc driver.

An error that has been occurring is that it SQL Developer is dropping connections to the database. The users get windows popping up that says

“Your Database Connection has been reset. Any pending transactions or session state has been lost.”

This typically happens when a user clicks to expand one of the objects under their schema in the Connections pane.

After searching and searching and a bit more searching it seem that this is being caused by and Out of Bands (OOB) error in the jdbc driver or on the network. Our DB is set to be dedicated (not shared) so that is not what is causing the issue. So after all my searching, if the following statement is added to the sqldeveloper.conf file then SQL Developer should ignore the OOB errors.

AddVMOption -Doracle.net.disableOob=true

What is really annoying about this error message is that this config file change seems to have worked for some users but for other users it has not. They are still getting their connections dropped when using SQL Developer, either while they are using their worksheets or when they click to expand/open a schema object.

Our next test is to roll out Oracle Client on the PCs and then get the users to connect to their schemas using the Oracle Client networking and a TNS entry.

Will this work? Will this make the error go away? Is there a problem with using the jdbc connection? Is it picking up another jdbc driver on the PC? Is it a bug in SQL Developer? Will using Oracle TNS work? Is it a problem on the Server? Is it a problem with the Database (no errors are being reported)?

Lots of questions that need answering.

If you can answer some of these then let me know.

If/When I find out I will update this blog post.

This entry was posted in Uncategorized.

Uncategorized

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this:

Share this: