Solved

DB_SWITCH_SESSION:Could not switch database proxy session to user [username]

  • 8 October 2019
  • 9 replies
  • 1764 views

Userlevel 2
Badge +2
Hi,

We are experiencing a DB_SWITCH issue similar to another posted earlier and marked resolved except that in our case, there is a minor a minor difference in the error message, instead of ORA-01017 we get ORA-00022. We've tried the solution proposed in the other topic without success, all our accounts are granted connect.

The issue is intermittent and after one or more attempts, our users are usually able to get in. Although i say it is intermittent, the error is experienced quite frequently and we have yet to identify the cause for this error.

Here is the full message message:



Any help would be greatly appreciated.
icon

Best answer by Banu Liyanapathirana 14 November 2019, 19:00

View original

9 replies

Userlevel 5
Badge +10
Hi, welcome to the IFS Community. This error could be due to multiple reasons, including due to an Oracle bug (Oracle Doc ID 1951983.1) if you have Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 (Release 11.2 to 12.1). I suggest that you dispatch a support case to IFS Support, as this may need further investigations.
Userlevel 2
Badge +2
Hi,

Thank you and thank you for your quick reply. Our current version of Oracle is 12.2.0.1.0 64 bit.
We do have a case open with IFS but so far, nothing fruitful.

Note that we've now been experiencing this issue for over 2 month and at this point, 'm hoping someone else has also experienced this issue and got it resolved or maybe has a lead.
Userlevel 6
Badge +15
@Joffesti Have you set any Oracle settings(IDLE_TIME, CONNECT_TIME) to disconnect idle DB sessions?. If so this could be what's causing the issue
Userlevel 2
Badge +2
@chanaka-shanil , all our users are assigned the "default" profile in oracle and this profile is configured as below:

Userlevel 6
Badge +13
Hi Joffesti ,

I'm investigating exactly the same issue from the case G2070009-A. At the moment, both RnD and Oracle support are involved.

Oracle ticket: 3-21048088101

Note: The same issue has already been reported by two APP10 customers. (G2089481 and G2092688 which is owned by @KasunBalasooriya )

It would be better if you can dispatch a support case for further investigation.
Userlevel 6
Badge +13

Finally, we resolved the issue by setting the “idle time” to "UNLIMITED" in all Oracle profiles. 

Badge +1

Hi Joffesti

We are experiencing the DB_SWITCH issue on IFSAPP account with ORA-01017; Could you please share the solution proposed for that? If it is available in the community forum, please share the link.

 

Error:

DB_SWITCH_SESSION:Could not switch database proxy session to user [IFSAPP] :

ORA-01017: invalid username / password; login denied

 

Thanks

.

Badge +1

Thanks, able to find the threads.

Userlevel 2
Badge +3

Hi All,

There is an unpublished Oracle bug (32919011) involving with JDBC proxy connections which will cause this issue when PDB name and the service name are same . Try to rename/create the service name which will distinct from PDB name and try.

This fails:

PDB_name = pdb
service_name = pdb.acme.com
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=<HOST>))(CONNECT_DATA=(SERVICE_NAME=pdb.acme.com)))


But this works:

PDB_name= pdb
service_name = pdb1.acme.com
JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=<HOST>))(CONNECT_DATA=(SERVICE_NAME=pdb1.acme.com)))

Thanks !

 

Reply