Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

LISTENER: TNS-12545 ... No such file or directory

Przemek POct 6 2011 — edited Oct 10 2011
Hi. I have a 11.2.0 database. This database was migrated from 10.2.0.4 recently. We are now testing if this test migration is ok.

At the beginning noone had problem with connection but after a while I couldn't connect via sql developer, or make any remote connection. No new connections are allowed. How can i deal with it ?

Sql developer throws this error:

Got minus one from a read call
Vendor code 17002

Listener throws this erro (sorry for xml format)r:

<msg time='2011-10-06T14:04:43.440+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='fake_database'
host_addr='10.50.150.58'>
<txt>06-OCT-2011 14:04:43 * (CONNECT_DATA=(SID=SPBUFOR)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=wrpiprtr01))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.2.3.97)(PORT=56011)) * establish * SPBUFOR * 12518
</txt>
</msg>
<msg time='2011-10-06T14:04:43.441+02:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='fake_database'
host_addr='10.50.150.58'>
<txt>TNS-12518: TNS:listener could not hand off client connection
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist
Linux Error: 2: No such file or directory
This post has been answered by sb92075 on Oct 6 2011
Jump to Answer

Comments

user248025
Hi,

Yes, it's possible ..

Method: 1

if it's defaul for all users then set it each user wise by default dashboard page

Goto to My Account link and then change the preference


Method 2: user/group wise setting default home page dashboard

Ya, it can be done./.

Creat new init blok like below one

GPC_Home
select '/shared/AFS/_portal/GPC AFS Reporting' from dual

see my screen short:
http://imageshare.web.id/images/z5gz8tithwypn4vfgm14.jpg

here set u r home page url path like below one

'/shared/AFS/_portal/GPC AFS Reporting'

create anothe init blok

USER_LOGIN

select User_ID from User_Group_Map where User_ID=':USER'

for more :
http://total-bi.com/2011/01/obiee-11g-change-default-dashboard/

Thanks

Deva

Edited by: Devarasu on Nov 29, 2011 10:34 PM
user248025
Hi,

1. Created a session init block
2. Used data source as select '/shared/SH Test/_portal/Test1' from dual
3. Assigned this value to PORTALPATH session variable
4. In Presentation services > Administration > My account > Default dashboard should be set to 'default'. Then only the dashboard specified in init block will be displayed otherwise My account will override the init block.
5. Save the changes made to rpd.
5. Logout and relogin to see if it is working fine. it is working perfectly fine.


if you like to have user/group based home page.
1. They may need to have 2 separate tables.
i. Group_path_tab with 2 columns. Group_id, portal_path
Have group wise portal path for all the groups
ii. User-group map table
Group_id, Group_name, user_id

User should be part of some group.

2. Then in the init block write the sql should be something like this

select A.portal_path from Group_path_tab A, User_group_map B
where B.user_id = :USER
and B.Group_id = A.Group_id

So based on USER session variable, it will try to identify the group and then the portal_path.
Finally assign this value to PORTALPATH session variable.

for more :

http://varanasisaichand.blogspot.com/2011/03/system-session-variabels-obiee-11g.html

http://varanasisaichand.blogspot.com/2011/03/system-session-variabels-obiee-11g.html

SR 3-3432126511: ^how to Changing theOBIEE11g homepage for all users/group wise?

Thanks

Deva

Edited by: Devarasu on Nov 29, 2011 10:42 PM

Edited by: Devarasu on Nov 29, 2011 10:49 PM
Balaa
Stefan,

In 11g the following new expressions have been added in saw.sessioninfos.xml file. This file is under $ORACLE_HOME/bifoundation/web/msgdb/common/

Edit saw.sessioninfos.xml file, you will see following tags:

<gdexpression id="hdrLinkCatalog" expr="true" />
<gdexpression id="hdrLinkOpen" expr="true" />
<gdexpression id="hdrLinkAdvanced" expr="true" />
<gdexpression id="hdrLinkHelp" expr="true" />
<gdexpression id="hdrLinkHome" expr="true" />
<gdexpression id="hdrLinkGSearch" expr="true" />

Each of these control the display of a UI element in the global header.
By setting the value to *"false"* instead of *"true"*, the corresponding UI element in the global header can be hidden.

For changes to take effect, please re-start BI Services and clear Browser cache.

NOTE: Finally, this change is global, meaning will affect all users.

Thanks,
Balaa...
319739
Thanks for Help.
Each Subject Area receive now there own Dashboard :-)
319739
Sorry, but up to know I haven't found this file.
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 7 2011
Added on Oct 6 2011
8 comments
34,799 views