This discussion is archived
1 Reply Latest reply: Jan 14, 2013 9:27 PM by Kishore Rout RSS

OBIEE installation failed while connecting to database.

975282 Newbie
Currently Being Moderated
Hello All,
I am trying to install the OBIEE 11g (11.1.1.5.0) on my windows 7 laptop.. First time when I tried I created the repository using the RCU and it failed while creating the domain.. It was saying in-progress but the progress bar didn't move from 0%.. after goggling I found that I need to install the loop back adapter to 10.10.10.10 and subnet mask to 255.255.255.0

After doing this I also added a entry in C:\Windows\System32\drivers\etc like
10.10.10.10 localhost mypcname

Ping localhost
Pinging Sadhana-PC [10.10.10.10] with 32 bytes of data:
Reply from 10.10.10.10: bytes=32 time<1ms TTL=128
Reply from 10.10.10.10: bytes=32 time<1ms TTL=128
Reply from 10.10.10.10: bytes=32 time<1ms TTL=128
Reply from 10.10.10.10: bytes=32 time<1ms TTL=128

While trying to install the OBIEE I cannot pass the database stage where it validates the DEV_BIPLATFORM

Connect string as localhost:1521:orcl it is giving me an error INST-08029 (unable to connect to the database with the given credentials.)

I can able to connect to the database through sqlplus.. I can also connect as DEV_BIPLATFORM..

=================================================================================
C:\Users\Sadhana>tnsping orcl

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 14-JAN-2
013 20:34:03

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
C:\app\Sadhana\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (20 msec)
=================================================================================

STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 14-JAN-2013 18:52:03
Uptime 0 days 1 hr. 57 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\Sadhana\product\11.2.0\dbhome_1\network\admin\l
istener.ora
Listener Log File c:\app\sadhana\diag\tnslsnr\Sadhana-PC\listener\alert\
log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=*127.0.0.1*)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successful
==================================================================

how do i change the host port to 10.10.10.10 from HOST=*127.0.0.1*


Please help me in fixing in this... hoping after fixing this loop back my installation will not fail while creating the domain..

thanks in advance..
  • 1. Re: OBIEE installation failed while connecting to database.
    Kishore Rout Journeyer
    Currently Being Moderated
    From the above error it seems Time-Zone on the server where Database/OBIEE are installed is not supported by Oracle Database. Please find below steps for resolution of this issue.

    Steps:
    1) Identify your Server Time-Zone. For example "Asia/Colombo".
    2) Check if it is a listed DB supported Time-Zones list, execute SQL Statement:
    SELECT unique tzname FROM V$TIMEZONE_NAMES where tzname = 'Asia/Colombo';
    3) Update your Server with another Time-Zone close/synonym to the original Time-Zone.
    In this example we would change to "Asia/Calcutta" instead "Asia/Colombo".
    SQL Statement: SELECT unique tzname FROM V$TIMEZONE_NAMES; will list you all supported Time-Zones.

    4) Continue your OBIEE 11gR1 installation.

    If this helps please mark:)
    Regards,
    Kishore

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points