Re: local tnsnames.ora not referenced



I am doing my homework while waiting for answers.
Answer for Q1:
because TNS_ADMIN environment path wasn't set in tj2.pl.
Answer for Q2:
I found before I added tns entry on oracle I also added same entry
locally in /opt/oracle/dbd/network/admin/tnsnames.ora. tj2.pl still
work after tns entry was commented out on server may be because the
my_ffr tns entry already in local tnsnames.ora. looks like TNS_ADMN
environment setting somehow got inherited in my shell environemnt.

Answer for Q3:
afer more research, I am looking at Oracle InstantClient now. It is
smaller and supported by Oracle. Besides there are many threads about
InstallClient and DBD::Oracle in this list.


tj

.



Relevant Pages

  • ORACLE DBA -- Western Suburbs of Chicago
    ... OPERATIONAL ORACLE DBA ... DBA will work in the Oracle environment and help manage a complex ... with many constituencies to develop database solutions to business ... with a minimum of 3 years' of Oracle DBA experience. ...
    (comp.lang.python)
  • SUMMARY: Solaris 10 zone - user processes crashing randomly
    ... When talking to Oracle the ... I am in a Solaris 10 environment. ... or similar user processes crashed again. ... According to some core-files it ...
    (SunManagers)
  • Compiling Multiple versions of DBD::Oracle
    ... supporting a large Solaris Environment. ... I need to compile a set of DBI/DBD::Oracle modules such that they are able ... revision' oracle environment would be backward compatible, ... may not have a C compiler in my production environments, ...
    (perl.dbi.users)
  • Re: gc quiesce
    ... instance RAC environment hosted on Microsoft Windows 2003 Server (x64 ... Any idea what causes this random 'gc quiesce' event blocks? ... In RAC context, GC quiesce probably means to quiesce a resource DB. ... Oracle Corp. and work with them. ...
    (comp.databases.oracle.server)
  • Oracle Apps Dba, Financial, Dallas, Texas..Contract to hire.
    ... Procurement and stand alone Oracle RDBMS ... Oracle applications include G/L, A/P, ... upgrading the current applications environment and stand alone RDBMS to ... application client/server tiers, etc.). ...
    (comp.databases.oracle.marketplace)