PL/SQL developer U3 support

[F. van Boven]

Hi,

recently I've bought a memorystick with U3 on it. This means that applications can be installed on a memorystick.

It would be great if PL/SQL Developer would have a U3 version available. In this way it is possible to help out a user on his own workstation using PL/SQL deloper.

Info can be found at http://www.u3.com/ and http://www.u3.com/developers/

New tools from U3 makes creating U3 applications even easier
September 7th, 2006 by john

If you

 

[CTzen]

You probably also need to have Oracle Instant Client running from memory stick?

 

[F. van Boven]

No, that's actually not needed... Since all our users are running the Instant Client. (It's needed to run our application)

 

[CTzen]

Well, it is still would be nice if PLD could run from memory stick, using Instant Client located on memory stick as well.

No need for tnsnames.ora, we can use new connect syntax

 

[F. van Boven]

Marco?

Any response on this?

 

[RobertK]

stupid U3 site : so very easy for people to find out just what the heck their product is

lame

 

[William Robertson]

Sounds interesting, but I'm still not quite seeing how this is different from installing an application on a normal USB flash drive.

 

[F. van Boven]

U3 supports a kind of registry for instance, makes it possible install a complate application, including all the registry settings and other system-specific setting on a USB drive.

 

[lofftjm]

I just started looking into this. I have the instant client working on a USB drive. I then copyied my PL/SQL Developer install from the hard drive to the USB drive. I set up a .bat file to set the PATH and TNS_ADMIN but no luck so far. There must be registry settings that are needed, which could probably be emulated with additional environment variables. Does the PL/SQL Developer put files anythere other than the install directory? For instance C:\Windows\System32?

 

[F. van Boven]

@lofftjm:

Keep us updated! Still hoping that some guys from Allround can give any feedback on this...

 

[walterheck]

I als recently purchased a U3 memorystick. I love it! My life would be even better if PL/SQL developer would be released for U3!
Any chance this will happen?

 

[Marco Kalter]

We'll look into it.

 

[lofftjm]

I got it working...

Download the following:
=======================
Oracle Instant Client Package - Basic Lite
Oracle Instant Client Package - SQL*Plus

These can be obtained from Oracle at http://www.oracle.com/technology/tech/oci/instantclient/index.html

Get a copy of msvcr71.dll
=========================
Get this from Microsoft or copy from existing Windows installation (C:\WINDOWS\system32\msvcr71.dll). This step is necessary because msvcr71.dll is part of Microsoft .NET and Oracle neglected to include it in the instant client. See Oracle Note:338900.1 for details.

Create directory structure on USB drive
=======================================
This example uses drive U: for the USB drive:

U:\
U:\Oracle\
U:\Oracle\instantclient_10_2
U:\Oracle\PLSQLDeveloper
U:\Oracle\tns_admin

Copy/extract files to appropriate locations
===========================================
Extract all the files from the Oracle Instant client "Basic Lite" and "SQL*Plus" zip files to U:\Oracle\instantclient_10_2
Copy msvcr71.dll to U:\Oracle\instantclient_10_2
Take an existing installation of PLSQL Developer and copy it to U:\Oracle\PLSQLDeveloper
Create the appropriate sqlnet.ora and tnsnames.ora file in U:\Oracle\tns_admin

Create a .bat file to setup the environment and launch PLSQL Developer
======================================================================
Create the file U:\oracle\start_plsql_developer.bat as follows:

set path=.\instantclient_10_2;.\PLSQLDeveloper;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem
set TNS_ADMIN=.\tns_admin
.\PLSQLDeveloper\plsqldev.exe

Save this file and double click it and PLSQL Developer should be run and be able to connect.