Enviroment for Oracle_home& Path

About oracle XE and client for oracle

In my environment, there is client for oracle exists, so after i install oracle XE, there may problem happen.
after test for some cases, there two enviroment variables is very important.
Oracle_home(where is the configure location)
Path (where is the bin location)
some time you may be use tns_admin, this can change folder which configure oracle_home define.

when we use tnsping
there may question may be occur,such as
Message 3513 not found; product=NETWORK; facility=TNS  (file tnsnames.ora   can't be found)
TNS-12557: TNS:protocol adapter not loadable( there is no binary code)

for example:

Oracle_home:
C:\oraclexe\app\oracle\product\10.2.0\server

path:
C:\oraclexe\app\oracle\product\10.2.0\server\BIN;
C:\ORABASE\ORA11g\Bin;

Tns_admin:
C:\ORABASE\ORA11g\network\admin

posted on 2012-06-28 17:02  子虚乌有  阅读(327)  评论(0)    收藏  举报