Hi All,
I already have Oracle 11g Client installed in my computer. I wanted to Install Oracle 10g Express Edition in the same computer. So that I shall work with that even when I am not in the network. My Question is : Will installing both of 11g Client and 10g XE will cause conflict in my computer or is it ok to install both. Any suggestion/information is appreciated.
Regards,
RRR
You can run comand in cmd SET TNS_ADMIN=c:\path_to_your_tnsnames.ora_files
If you need to set this env. variable permanently then,
Try setting the TNS_ADMIN variable as a system environment variable. Go to my computer -> right click ->properties ->Advanced ->Click on Enviroment Variable -> Add
I already have a oracle 11g client installed in my machine. but i will be able to connect to this only when i am in the network. Say if i am not in network, i still wanted to connect to some database to connect my forms. So I tried installing Oracle 10g Express Edition so that i can connect to that when i am not in the network. After installing I tried connecting to the express edition saying user/password@xe. When i tried doing that i am getting the above error.
Your Express Edition needs to be installed to use the LOOPBACK Adapter. Other than that, it'll work.
Microsoft has a KB article describing how to install it. There are probably around 500 threads describing that in the category Database forums (one level up).
A mild amount of search in internet or in forums for 'loopback adapter and XE' will also provide detailed instructions as well. (I know - I've written dozens.)
