2012년 7월 4일 수요일

oracle instant client


펌: http://www.leccionespracticas.com/uncategorized/how-to-install-oracle-instantclient-windows-xp-sp3-32bits/

1.  SET PATH=C:\Documents and Settings\miguel\Escritorio\instantclient10_1;%PATH%
       * This is obviously for finding the executables.
2. SET TNS_ADMIN=C:\Documents and Settings\miguel\Escritorio\instantclient10_1
       * This is only for finding the tnsnames.ora file. You do not have to have this in the Instant Client directory but if you were on a database box or one that already has the Oracle Client on it, where else would you put it?
3. SET LD_LIBRARY_PATH=C:\Documents and Settings\miguel\Escritorio\instantclient10_1
       * Obviously to find the shared libraries shipped with Instant Client.
4. SET SQLPATH=C:\Documents and Settings\miguel\Escritorio\instantclient10_1
       * If you use a glogin.sql file, you will need to set this to find it.