OraFAQ Forum: Business Intelligence » Unable to connect to database during OBIEE configuration

Home » Fusion Middleware & Colab Suite » Business Intelligence » Unable to connect to database during OBIEE configuration (OBIEE, 12c, Windows 8.1 64 bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to connect to database during OBIEE configuration [message #651283]

Sat, 14 May 2016 09:35

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 5784 times)

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651284 is a reply to message #651283]

Sat, 14 May 2016 09:48

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651285 is a reply to message #651284]

Sat, 14 May 2016 11:07

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

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651286 is a reply to message #651285]

Sat, 14 May 2016 11:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Invalid user name/password.
you need to use valid username/password pair

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651287 is a reply to message #651286]

Sat, 14 May 2016 11:23

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?

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651288 is a reply to message #651287]

Sat, 14 May 2016 12:41

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651296 is a reply to message #651288]

Sat, 14 May 2016 22:31

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 4924 times)

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651297 is a reply to message #651288]

Sat, 14 May 2016 22:32

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 5149 times)

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651309 is a reply to message #651296]

Sun, 15 May 2016 11:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

mazam wrote on Sat, 14 May 2016 20:31

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.

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651310 is a reply to message #651309]

Sun, 15 May 2016 12:19

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651323 is a reply to message #651309]

Sun, 15 May 2016 21:52

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

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 5009 times)

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651324 is a reply to message #651310]

Sun, 15 May 2016 21:58

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.

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651325 is a reply to message #651309]

Sun, 15 May 2016 22:05

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?

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651326 is a reply to message #651323]

Sun, 15 May 2016 22:05

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651336 is a reply to message #651326]

Mon, 16 May 2016 00:21

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

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651378 is a reply to message #651336]

Mon, 16 May 2016 14:48

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651381 is a reply to message #651378]

Tue, 17 May 2016 01:01

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?

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #651461 is a reply to message #651381]

Wed, 18 May 2016 05:39

mazam
Messages: 47
Registered: October 2009
Location: Multan

Member

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

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???

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #669162 is a reply to message #651461]

Thu, 05 April 2018 20:48

manish.nankar
Messages: 10
Registered: December 2008

Junior Member

Hi ,

I am facing exactly same issue which you faced? Can you please help me solve this error? Can you please share exact steps to resolve this error?

Will appreciate your help.

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #670479 is a reply to message #669162]

Sun, 08 July 2018 06:32

Darek2018
Messages: 2
Registered: July 2018

Junior Member

I have the same problem.

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #670482 is a reply to message #670479]

Sun, 08 July 2018 08:40

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Darek2018 wrote on Sun, 08 July 2018 04:32

I have the same problem.

same as what exactly?

use COPY & PASTE to show what you do & how Oracle responds

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #670483 is a reply to message #670482]

Sun, 08 July 2018 08:51

Darek2018
Messages: 2
Registered: July 2018

Junior Member

I have the same problem: " Invalid user name/password." Someone is written at: https://support.oracle.com/knowledge/Middleware/1209587_1.html, but I don't have access to https://support.oracle.com/

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #670486 is a reply to message #670483]

Sun, 08 July 2018 10:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

The ONLY solution for ORA-01017 error is to provide a valid username & password combination.
Oracle is too dumb to lie about this error.
If you claim that Oracle throws error incorrectly, then post reproducible test case that produces ORA-01017 when is should not be thrown.

Report message to a moderator

Re: Unable to connect to database during OBIEE configuration [message #685568 is a reply to message #651283]

Wed, 09 February 2022 22:58

hasnurfaq
Messages: 1
Registered: February 2022

Junior Member

Add this entries in sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION=8
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Report message to a moderator

Previous Topic:	Python in Oracle Data Integrator For Data Science
Next Topic:	BI Pub out of support

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 17 14:58:53 CST 2025