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 next 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 129 times)
Re: Unable to connect to database during OBIEE configuration [message #651284 is a reply to message #651283] Sat, 14 May 2016 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
open Command Window & issue following OS commands

lsnrctl status
lsnrctl service

COPY the results directly from the Command Window then PASTE all back here
Re: Unable to connect to database during OBIEE configuration [message #651285 is a reply to message #651284] Sat, 14 May 2016 11:07 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Hi Swan

Thanks for your feedback.
Sorry that I forgot to run the Listener & Database Services.
They are up and running now but the error which I have been facing since many attempts in OBIEE configuration is below one:

Error connecting to 'Oracle database at host localhost port 1521 service name orcl' - Invalid user name/password.
Make sure the database is up and running and connect string, user name and password are correct. Enter a valid user name with DBA privileges


However the output of commands you told before running the Db services, was:


C:\Users\MuhammadKamran>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 15-MAY-2016 03:49
:40

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory

C:\Users\MuhammadKamran>lsnrctl service

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 15-MAY-2016 03:50
:23

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 2: No such file or directory



After running the commands, output is as below:

C:\Users\MuhammadKamran>lsnrctl status

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 15-MAY-2016 04:01
:02

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Produ
ction
Start Date 15-MAY-2016 03:51:12
Uptime 0 days 0 hr. 9 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\app\oradb12c\product\12.1.0\dbhome_1\network\admin\
listener.ora
Listener Log File E:\app\oradb12c\diag\tnslsnr\kamranpc\listener\alert\l
og.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=kamranpc)(PORT=5500))(Security=(my_
wallet_directory=E:\APP\ORADB12C\admin\orcl\xdb_wallet))(Presentation=HTTP)(Sess
ion=RAW))
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...
Service "pdborcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully


C:\Users\MuhammadKamran>lsnrctl service

LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 15-MAY-2016 04:05
:18

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: KAMRANPC, pid: 4572>
(ADDRESS=(PROTOCOL=tcp)(HOST=kamranpc)(PORT=62243))
Service "pdborcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Re: Unable to connect to database during OBIEE configuration [message #651286 is a reply to message #651285] Sat, 14 May 2016 11:20 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
>Invalid user name/password.
you need to use valid username/password pair
Re: Unable to connect to database during OBIEE configuration [message #651287 is a reply to message #651286] Sat, 14 May 2016 11:23 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Swan...I've tried user names of both Sys as well as System users. I am able to connect using these users through SQL Plus but not here. I don't know why it is?
Re: Unable to connect to database during OBIEE configuration [message #651288 is a reply to message #651287] Sat, 14 May 2016 12:41 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
mazam wrote on Sat, 14 May 2016 09:23
Swan...I've tried user names of both Sys as well as System users. I am able to connect using these users through SQL Plus but not here. I don't know why it is?


The one thing I am 100% confident of is that Oracle is too dumb to lie.
Problem Exists Between Keyboard And Chair.
I know that if/when you really provide correct username/password pair, you'll get logged in the database.

using COPY & PASTE show us how you tested using sqlplus.

Re: Unable to connect to database during OBIEE configuration [message #651296 is a reply to message #651288] Sat, 14 May 2016 22:31 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

/forum/fa/13117/0/Hi Swan...you are correct that Oracle doesn't lie. But, I feel that with every new release of Oracle Software, it introduces new glitches and we really have to juggle to install and configure that software.

Anyways, apart from this discussion, please look into attached, this will show you how am I running and connecting to Ora Db using sqlplus (in sqlplus.jpg file).
  • Attachment: sqlplus.jpg
    (Size: 113.77KB, Downloaded 149 times)
Re: Unable to connect to database during OBIEE configuration [message #651297 is a reply to message #651288] Sat, 14 May 2016 22:32 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Second file (rcu...Repository Creation Utility) shows the error I am receiving during OBIEE configuration.
  • Attachment: rcu.jpg
    (Size: 177.61KB, Downloaded 171 times)
Re: Unable to connect to database during OBIEE configuration [message #651309 is a reply to message #651296] Sun, 15 May 2016 11:37 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
mazam wrote on Sat, 14 May 2016 20:31
/forum/fa/13117/0/Hi Swan...you are correct that Oracle doesn't lie. But, I feel that with every new release of Oracle Software, it introduces new glitches and we really have to juggle to install and configure that software.

Anyways, apart from this discussion, please look into attached, this will show you how am I running and connecting to Ora Db using sqlplus (in sqlplus.jpg file).


You don't know what you don't know.
1) you provided NO password
2) sqlplus / as sysdba does NOT use SQL*Net & requires no listener but OBIEE can only login using SQL*net via listener

posted example proves nothing about ORA-01017 error

a valid test would be similar to below

sqlplus scott/tiger@orcl

& getting successfully logged into the database.

Re: Unable to connect to database during OBIEE configuration [message #651310 is a reply to message #651309] Sun, 15 May 2016 12:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65252
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... assuming that both use the same Oracle Home and/or tnsnames.ora and try to access to the same database...

Re: Unable to connect to database during OBIEE configuration [message #651323 is a reply to message #651309] Sun, 15 May 2016 21:52 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Hi Swan...Good day.

If any body knows what he doesn't know then may be he knows all Wink

I am able to connect with c##scott both the ways, with @orcl and without @orcl as appearing from attached screen shot.
  • Attachment: scott.jpg
    (Size: 425.37KB, Downloaded 130 times)
Re: Unable to connect to database during OBIEE configuration [message #651324 is a reply to message #651310] Sun, 15 May 2016 21:58 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Hi Michael...Pardon...I couldn't understand your bits...which both things should connect to same database? I've only one database instance installed on my Lappy which I mentioned in my first post. I've also mentioned complete directory structure as well there.
Re: Unable to connect to database during OBIEE configuration [message #651325 is a reply to message #651309] Sun, 15 May 2016 22:05 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Swan, my previous post with attached image "rcu.jpg" showing error message like "Error connecting to Oracle database at host localhost...". Though it's not assigned error num ora-01017 however it means same.
Did you have a look at that image?
Re: Unable to connect to database during OBIEE configuration [message #651326 is a reply to message #651323] Sun, 15 May 2016 22:05 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
every connection request that arrives at the listener is logged to the file shown below

Listener Log File E:\app\oradb12c\diag\tnslsnr\kamranpc\listener\alert\log.xml

Successful connection request will have a status code=0 for success & shows host & program that initiated the request.
Oracle treats ORA-01017 as an application error & does not record it in the alert_orcl.log file while listener treats the request as a success (STATUS=0)
Is OBIEE really connecting to the same database which allowed C##SCOTT to login.
BTW for V11 & V12 passwords are CaSeSenSiTiVe
Re: Unable to connect to database during OBIEE configuration [message #651336 is a reply to message #651326] Mon, 16 May 2016 00:21 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Hi...Here is some of the extract from log file, I thought it could help you some way to understand the issue:

<msg time='2016-05-16T17:11:55.100+12:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='KAMRANPC'
host_addr='fe80::5906:a22a:b182:ba8b%8'>
<txt>16-MAY-2016 17:11:55 * service_update * orcl * 0
</txt>
</msg>
<msg time='2016-05-16T17:13:22.093+12:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='KAMRANPC'
host_addr='fe80::5906:a22a:b182:ba8b%8'>
<txt>16-MAY-2016 17:13:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MuhammadKamran))(SERVICE_NAME=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MuhammadKamr an))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=53859)) * establish * orcl * 0
</txt>
</msg>
<msg time='2016-05-16T17:13:22.109+12:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='KAMRANPC'
host_addr='fe80::5906:a22a:b182:ba8b%8'>
<txt>16-MAY-2016 17:13:22 * service_update * orcl * 0
</txt>
</msg>


Can you please specify exactly that where should be the tnsnames.ora file in OBIEE home? I thought it might be on wrong location and OBIEE config setup not picking it up.

I've checked, there is no case sensitivity issue.


Regards
Re: Unable to connect to database during OBIEE configuration [message #651378 is a reply to message #651336] Mon, 16 May 2016 14:48 Go to previous messageGo to next message
BlackSwan
Messages: 25745
Registered: January 2009
Location: SoCal
Senior Member
><txt>16-MAY-2016 17:13:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MuhammadKamran))(SERVICE_NAME=orcl)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MuhammadKamr an))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=53859)) * establish * orcl * 0
</txt>

if above shows the OBIEE GUI connecting to the database, then it was using JDBC & therefore does not use tnsnames.ora or any other file
Re: Unable to connect to database during OBIEE configuration [message #651381 is a reply to message #651378] Tue, 17 May 2016 01:01 Go to previous messageGo to next message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Hi...Good day

Yes it was a connection attempt from OBIEE configuration, but it didn't give me any option to connect through JDBC.
However, I've noticed that if I write my computer name (kamranpc) instead of localhost it gives me 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.


Can u guess why is it?
Re: Unable to connect to database during OBIEE configuration [message #651461 is a reply to message #651381] Wed, 18 May 2016 05:39 Go to previous message
mazam
Messages: 47
Registered: October 2009
Location: Multan
Member

Hi Swan...After all I caught the bird Wink

Basically username/password were correct, but the hell it was showing was difference of Db Character set.

When I used a different RCU utility than the default utility with OBIEE 12c, then, while connecting, it gave me the error that Character Set of connecting Db should be AL32UTF8.

So, as it is Db 12c, so I reinstalled it with this character set.

Then again, during RCU setup, I got message of connecting to a PDB instead of CDB.

For this I changed my tnsnames.ora and listener.ora and finally able to complete this RCU wizard.

However...bundle of thanks for your kind attention and cooperation.


P.S...Would u suggest me, is it my lack of knowledge or it's really a sophisticated/complicated job to install just a small component of a full suite of software???
Previous Topic: XML Publisher with Oracle Apps
Next Topic: how to email user
Goto Forum:
  


Current Time: Wed Dec 13 21:46:16 CST 2017

Total time taken to generate the page: 0.03359 seconds