Categories
- All Categories
- 87 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 49 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Unable to Connect db through RPD OBIEE 12 C
Hi All,
I have created one connection and trying to connect DB through RPD in Online mode but i am getting below error.
Also i have added TNS entry in tsnnames.ora
The connection has failed
[nQSEerror: 17014] could not connect to oracle database.
[nQSEerror: 17001] Oracle error code : 12170 , Message ORA-12170 TNS: Connect timeout occurred at OCI call OCIServerAttach
But if i was open RPD in Offline mode we are able to connect DB.
And Report level i am getting below error
ORA-01012: not logged on Process ID
please help
Thannks,
P G
Answers
-
Do you have a tnsnames.ora file in the right location for the Admin tool?
0 -
HI Joel,
The tnsnames.ora file is in right location.
One more things, i have create jdbc connection and i am able connect db successfully.
0 -
Is it now working or not?
On which location did you store tnsnames.ora?
Which version of Oracle-Bi are you running on which OS?
0 -
Hi Michael,
Its not working through RPD.
tnsnames.ora stored in below location
OBIEE\Middleware\user_projects\domains\bi\config\fmwconfig\bienv\core
OBIEE Version: Oracle Business Intelligence 12.2.1.3.0
OS: Windows 10
0 -
Just a simple check: can you change the datasource name to a direct connection and try again?
Direct connection is: server:PORT/SID
0 -
Hi Micael,
As per your suggestion, i have tried to connect db by direct connection.
But same error occurred.
Thanks,
PG
0 -
Do you have an Oracle Client on your OBIEE server? If you do,can you connect via SQL Plus to your DB? Can you try pinging the DB server from your OBIEE server as well?
0 -
HI Joel,
By using SQL Developer, we are able to connect DB and also able to pinging the DB server from OBIEE server.
Thanks
P G
0 -
Place complete connection string into RPD and try.
0