Starter of OBIEE needs help
784932Jul 14 2010 — edited Jul 14 2010Dear All,
i just installed the OBIEE and oracle db 10.2.0.3.0.(with sample sachems) but i am not able to using Administrator.
Following are the steps i did.
1) Install jdk
2) install oracle db 10.2.0.3.0
3) install OBIEE
4) Download SH folder containing sh.rpd and other files.
5) paste sh folder in "OracleBIDATA\web\catalog"
6)add CtatlogPath in instanceconfig.xml file "OracleBIDATA\web\catalog\sh"
7)copy sh.rpd and paste it in OracleBI\Server\Repository
8)add entry "Star = sh.rpd, DEFAULT;" and comment old one.
9)i installed it on Win 7 i was facing problem during ODB conenction so i applied patch "p5699495_10203_WINNT12.zip"
10) i created ODBC connection as
Data Source Name = sh
TNS Service Name = ORCL
User ID = sh
then i test connection and it was successful.
11)After this i restart the services.
12) Open Administrator and login using "Administrator" i can see "orcl SH" in PHYSICAL LAYER.
13)Connection Pool settings are
Call Interface = OCI 10g/11g
Data Source Name = sh (its was ORCL default)
user name = sh
password = i enter customized password
then i click on table like PRODUCTS and click on view data or update rows i got the number of errors.
[NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred.
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statment.
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied at OCI call OCILogon.
[nQSError: 17014] Could not connect to Oracle database
Any help????