Database Browser on Oracle Instant Client

More
12 years 10 months ago #1161 by newbie01.others
Hi,

Can you please advise if it is possible to get Database Browser to work using Oracle Instant Client as am not able to use ODBC or the "traditional" Oracle Client Install.

Am currently using Oracle SQL Developer and Tora but would want to compare it with Database Browser, that is if I can get it to run using Oracle Instant Client. Reason am wanting to do this is so that I can use it "portably" without re-doing ODBC connections for each PC that am going to use.

Any response will be very much appreciated. Thanks in advance.

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #1162 by admin
As far as I am aware all you need to do is to copy Oracle Instant Client dlls into PortableApps\DatabaseBrowserPortable\App\DatabaseBrowser directory

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #1164 by newbie01.others
Hi Peter,

I tried what you suggested and it doesn't work.

The drop down list does not list the tnsnames.ora entries and it is complaining about OracleHomeKey and OracleHomeDir which are not required to be set when using instantclient.

FYI, toRA and Oracle-SQLDeveloper are working but I want to give the Database Browser a go and see how it compares.

Are you able to test on your end? BTW, am using the PortableApps version of Database Browser as am not allowed to install this on the PC and hence running it off my portabl drive.

Any other suggestion will be very much appreciated. Thanks in advance.

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #1169 by admin
You sound like you have never used instant client.
It will not list your tns names you should enter connection string manually

Instant Client allows you to run applications without installing the standard Oracle client (SQL*Net or Net8) or having an ORACLE_HOME. It supports two basic connection string formats:

* //host:[port][/service name]
o e.g. //dbase-server-5:4321/ORDERS
* an Oracle Net keyword-value pair such as

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=dlsun242)
(PORT=5521)) (CONNECT_DATA=(SERVICE_NAME=bjava21)))

Naming methods that require a configuration file (such as tnsnames.ora or sqlnet.ora) for name translation can also be used if the environment variable TNS_ADMIN is set to point to the directory containing the file.

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.