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)"
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)"