Month: July 2009

Make eclipse Galileo 3.5 work with NTMLv2 Proxy

I installed eclipse 3.5 at my work place (where we access internet through an authenticated NTML proxy).  I was unable to make eclipse pass through this proxy, which prevented me to install updates and additional software.

Anthony Dahanne’s describes the workaround on his blog (in french). The Apache httpclient implementation should be disabled because it doesn’t work well with NTMLv2 proxies.

For NTLMv2 Proxies, that require user name and password for access the workaround is to

  1. Disable the ECF httpclient provider.
  2. Provide the NTLMv2 proxy authentication info (proxyhost, domain, username, and password)

In practice, edit your eclipse.ini file to append the following properties.

-Dorg.eclipse.ecf.provider.filetransfer.excludeContributors=org.eclipse.ecf.provider.filetransfer.httpclient
-Dhttp.proxyPort=8080
-Dhttp.proxyHost=myproxy
-Dhttp.proxyUser=mydomain\myusername
-Dhttp.proxyPassword=mypassword
-Dhttp.nonProxyHosts=localhost|127.0.0.1

Original article : http://blog.dahanne.net/2009/07/01/eclipse-galileo-3-5-problemes_proxy/
Eclipse bug https://bugs.eclipse.org/bugs/show_bug.cgi?id=281472#c7
Eclipse wiki which provides the solution: http://wiki.eclipse.org/ECF_Filetransfer_Support_for_NTLMv2_Proxies

Export oracle data

This should work with oracle 8 and +

The consistent=yes parameter locks the Objects as read only to ensure data consistency.

Depending on the environment settings the @oracle_sid parameter in the user name may be optional.

exp User_name/user_pass@oracle_sid FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y

or

exp userid=User_name/user_pass@Oracle_sid FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y

to export schema from a user (owner_name)  while logged as an admin (dba_name)

exp userid=dba_name/dba_pass FULL=y FILE=my_export_file.dmp LOG=my_export_log CONSISTENT=y owner=owner_name