Home » Fusion Middleware & Colab Suite » Business Intelligence » Unable to connect to database during OBIEE configuration (OBIEE, 12c, Windows 8.1 64 bit)
Unable to connect to database during OBIEE configuration [message #651283] Sat, 14 May 2016 09:35 Go to previous message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member
Hi gurus



I've Windows 8.1 64 bit on core-i7 laptop with 8 GB RAM.

I installed Ora DB 12c (12.1.0.2.0) installed on location E:\app\oradb12c\product\12.1.0\dbhome_1.

Java version is 1.8.0_65 on c:\Java\jdk18065.

Database Services are running quite well and I can connect to Db smoothly using SQL Plus as well as Toad.

Then I installed fmw12.2.1.0 smoothly without any error on E:\Oracle\Middleware.

After that I installed OBIEE-12.2.1.0.0 in the home of fmw-infrastructure which is E:\Oracle\Middleware.

Finally I do run OBI configuration from E:\Oracle\Middleware\bi\bin\config.bat.

I am giving following value in Simple Connect String: localhost:1521:orcl

But on Create New Schema page (Step 4 of 9) it is not connecting with database giving the following error:


Error in connecting to the Database: 'Oracle database at host localhost port 1521 service name orcl'. Error: 'The Network Adapter could not establish the connection' - Unable to connect to the Database with the given connect string and credentials.

Make sure the database is up and running and connect string, user name and password are correct.


While searching for a solution online for similar errors I found that I've no tnsnames.ora in my middleware home, so I have created folders and tnsnames.ora file as below (because I couldn't find these folders and tnsnames.ora file in middleware home at all):

E:\Oracle\Middleware\oracle_common\network\admin\tnsnames.ora

E:\Oracle\Middleware\network\admin\tnsnames.ora

E:\Oracle\Middleware\bi\network\admin\tnsnames.ora


Contents of tnsnames.ora are as below:


# tnsnames.ora Network Configuration File: E:\app\oradb12c\product\12.1.0\dbhome_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.


LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

(CONNECT_DATA =

(SID = CLRExtProc)

(PRESENTATION = RO)

)

)


ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

(CONNECT_DATA =(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)



But, even this workaround couldn't solve my problem and I am still unable to configure my OBIEE 12c installation.

So can you please help me to solve this problem?

Thanks in advance.
  • Attachment: ErrScr.jpg
    (Size: 281.81KB, Downloaded 4866 times)

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Python in Oracle Data Integrator For Data Science
Next Topic: BI Pub out of support
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 22:58:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.