I was always installing Oracle DB under oracle user and OBIEE under obi user.
In this way under oracle $ORACLE_HOME was point to the database and under obi it was pointing to $MW_HOME\Oracle_BI1
The idea for separation was first suggested to me by Gerard Nico's blog .
So the variables that need to set are:
ORACLE_HOME=$MW_HOME/Oracle_BI1
TNS_ADMIN=$ORACLE_HOME/network/admin
# Create tnsnames.ora under MW_HOME/Oracle_BI1/network/admin
If setting the PATH variable make sure $MW_HOME/Oracle_BI1/bin is before database $ORACLE_HOME/bin.
If OBIEE is going to the DB tnsnames.ora, this type of error might show up:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
In this way under oracle $ORACLE_HOME was point to the database and under obi it was pointing to $MW_HOME\Oracle_BI1
The idea for separation was first suggested to me by Gerard Nico's blog .
So the variables that need to set are:
ORACLE_HOME=$MW_HOME/Oracle_BI1
TNS_ADMIN=$ORACLE_HOME/network/admin
# Create tnsnames.ora under MW_HOME/Oracle_BI1/network/admin
If setting the PATH variable make sure $MW_HOME/Oracle_BI1/bin is before database $ORACLE_HOME/bin.
If OBIEE is going to the DB tnsnames.ora, this type of error might show up:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
No comments:
Post a Comment