iam trying to install obiee and oracle database on linux machine..i create two user 1 and 2 in same group.
i installed oracle db 10.2.0.4 on user 1.
i installed oracle obiee 10g on user 2.
using windows admintool i created .rpd moved to linx obiee server and started the obiee server and corresponding services...
i open the dashboard also... i i try to create the answer query iam getting error odbc
"Odbc driver returned an error (SQLExecDirectW).
Error Details Error Details
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down. (HY000)"
how can i configure odbc connection in linux ...
can anybody clear this....
Thanks and regards...
Please confirm below steps.
1. Have you modified connection pools in RPD?
2. Did you start the listner services in Linux box?
3. Check wether database is running or not?
Please cross check and update the status.
Hope this help's
ya , i did all the above the three steps....
modified the connection pool in rpd..
database is up.
but in connection pool what i have to select oci or odbc( i select odbc and given tns name for the database)
after i change the connection pool like odbc to OCI
error like "Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17003] Oracle gateway error: OCIEnvNlsCreate or OCIEnvInit failed to initialize environment. Please check your Oracle Client installation and make sure the correct version of OCI libraries are in the library path. (HY000)"
problem is in oracle clients or else..
finally problem will be resolved....thanks for kind reply...
before starting all obiee services,should change the ORACLE_HOME in user.sh file.. then start all obiee related services...then try to check...