Hi experts,
I have installed obiee 11.1.1.7.0 in windows 64bit,but currently i am not able to create a repository,since the process gets stuck while selecting a data source and goes to not responding node.i have database oracle xe 11.2 installed.i am trying to import using a oci 10g/11g connection type,with data source name = xe
I have oracle home set to ORACLE_HOME=C:\obiee11g\Oracle_BI1
tns admin set to TNS_ADMIN=C:\obiee11g\Oracle_BI1\network\admin
My nqsadmintool.log looks like this,
[2014-08-31T15:34:52.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 11ac] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T15:46:16.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 1148] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T15:49:07.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1148] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
]]
[2014-08-31T15:51:32.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1148] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
]]
[2014-08-31T16:02:56.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 1290] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T16:44:57.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 14d4] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T16:53:20.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 1740] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T16:53:34.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1740] [nQSError: 13042] Repository password is wrong.
[2014-08-31T17:09:04.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 36c] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T17:13:04.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: dbc] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T17:19:54.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 17c0] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T17:49:38.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: ce4] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T17:59:23.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 1628] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T17:59:49.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1628] [nQSError: 16001] ODBC error state: 28000 code: 1017 message: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01017: invalid username/password; logon denied.
[2014-08-31T18:00:00.000+05:30] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1628] [16020] Metadata Database Type: Oracle 11g [[
Data Source Name: XE
Data Source Type: Oracle 11.01.0000 Oracle 11.1.0.0.0
]]
[2014-08-31T18:00:00.000+05:30] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 1628] Data Source Name: XE [[
Client Driver Version 06.00.0140 (B0109, U0053)
]]
[2014-08-31T18:00:03.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1628] [nQSError: 16001] ODBC error state: S1002 code: 0 message: [DataDirect][ODBC Oracle Wire Protocol driver]Number of bound columns exceeds the number of result columns..
[2014-08-31T18:18:14.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 17e8] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T18:34:02.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 1054] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T18:52:39.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 134c] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-08-31T18:53:39.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 134c] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12545, message: ORA-12545: Connect failed because target host or object does not exist
at OCI call OCIServerAttach.
]]
[2014-08-31T18:53:48.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 134c] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12545, message: ORA-12545: Connect failed because target host or object does not exist
at OCI call OCIServerAttach.
]]
[2014-08-31T19:09:24.000+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 134c] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12570, message: ORA-12570: TNS:packet reader failure
at OCI call OCIServerAttach.
]]
[2014-09-01T20:18:40.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: 2a0] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
[2014-09-01T20:25:56.000+05:30] [OracleBIServerComponent] [WARNING:1] [] [] [ecid: ] [tid: a14] Warning: Clustering and cache are enabled for this OBIS node, but cluster aware cache is disabled. This can lead to inconsistencies.
Please help me solve this issue,since i am stuck with this for 2 days
Thanking You,
Manju.