Does HFM 126.96.36.199 use 64 bit database client or 32 bit? or both. which doesn't make sense.
I have installed external database client (not using the one that comes with HFM), which one should i install? 64 bit or 32 bit?
Plus about the TNS_ADMIN environment variable What it should be?
Kindly correct me if i am wrong.
1 - If i have used the default database client it's value would be... E:\Oracle\HFM\Middleware\user_projects\config\dbclient
2 - If i use external client it would be like this... E:\Oracle\DB_Client\product\12.2.0\client_1\network\admin
3 - Couldn't i just enter the required entries in my database tnsname.ora file and use this TNS_ADMIN entry... E:\Oracle\DB\product\12.2.0\dbhome_1\network\admin
or i can't because database doesn't get installed with database client. We have to install it separately.
Everything is installed on same machine.