Skip to main content
Solved

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

Joffesti
Do Gooder (Customer)
Forum|alt.badge.img+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.

Best answer by Banu Liyanapathirana

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

View original
1 Attachments
    D
    1 person likes this
    • D
      Dilushkumar Vasudevan
    Did this topic help you find an answer to your question?

    10 replies

    Sampath Sitinamaluwa
    Hero (Employee)
    Forum|alt.badge.img+11
    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.
    durette
    1 person likes this
    • durette
      durette
    Joffesti
    Do Gooder (Customer)
    Forum|alt.badge.img+2
    • Joffesti
    • Author
    • Do Gooder (Customer)
    • 4 replies
    • October 8, 2019
    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.
    Yasas Kasthuriarachchi
    1 person likes this
    • Yasas Kasthuriarachchi
      Yasas Kasthuriarachchi
    chanaka-shanil
    Superhero (Employee)
    Forum|alt.badge.img+15
    • chanaka-shanil
    • Superhero (Employee)
    • 166 replies
    • October 9, 2019
    @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
    /Chanaka
    Sampath Sitinamaluwa
    Banu Liyanapathirana
    Yasas Kasthuriarachchi
    3 people like this
    • Sampath Sitinamaluwa
      Sampath Sitinamaluwa
    • Banu Liyanapathirana
      Banu Liyanapathirana
    • Yasas Kasthuriarachchi
      Yasas Kasthuriarachchi
    Joffesti
    Do Gooder (Customer)
    Forum|alt.badge.img+2
    • Joffesti
    • Author
    • Do Gooder (Customer)
    • 4 replies
    • October 9, 2019
    @chanaka-shanil , all our users are assigned the "default" profile in oracle and this profile is configured as below:

    1 Attachments
    Yasas Kasthuriarachchi
    1 person likes this
    • Yasas Kasthuriarachchi
      Yasas Kasthuriarachchi
    Banu Liyanapathirana
    Hero (Employee)
    Forum|alt.badge.img+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.
    --Banu Liyanapathirana--
    Sampath Sitinamaluwa
    Charith Epasinghe
    Kasun Balasooriya
    3 people like this
    • Sampath Sitinamaluwa
      Sampath Sitinamaluwa
    • Charith Epasinghe
      Charith Epasinghe
    • Kasun Balasooriya
      Kasun Balasooriya
    Banu Liyanapathirana
    Hero (Employee)
    Forum|alt.badge.img+13

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

    --Banu Liyanapathirana--
    Sampath Sitinamaluwa
    Kasun Balasooriya
    Yasas Kasthuriarachchi
    11 people like this
    • Sampath Sitinamaluwa
      Sampath Sitinamaluwa
    • Kasun Balasooriya
      Kasun Balasooriya
    • Yasas Kasthuriarachchi
      Yasas Kasthuriarachchi
    • Minoshini Fonseka
      Minoshini Fonseka
    • Rusiru Dharmadasa
      Rusiru Dharmadasa
    • durette
      durette
    • dsj
      dsj
    • SIMOBOIS
      SIMOBOIS
    • O
      Oshada Samarasinghe
    • Nadeesh Herath
      Nadeesh Herath
    • tobese
      tobese
    F
    Do Gooder (Partner)
    Forum|alt.badge.img+1
    • fahmyhaniffa
    • Do Gooder (Partner)
    • 2 replies
    • August 19, 2020

    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

    .

    F
    Do Gooder (Partner)
    Forum|alt.badge.img+1
    • fahmyhaniffa
    • Do Gooder (Partner)
    • 2 replies
    • August 19, 2020

    Thanks, able to find the threads.

    Binujaya Rajatheja
    Sidekick (Employee)
    Forum|alt.badge.img+6

    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 !

     

    Best Regards, Binu - https://www.linkedin.com/in/binujayarajatheja/
    durette
    D
    0guz
    3 people like this
    • durette
      durette
    • D
      Deshan Perera
    • 0guz
      0guz
    0guz
    Hero (Employee)
    Forum|alt.badge.img+10
    • 0guz
    • Hero (Employee)
    • 64 replies
    • November 21, 2024
    Binujaya Rajatheja wrote:

    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 !

     

    Thank you so much ​@Binujaya Rajatheja.

    https://www.linkedin.com/in/oguzhan-korkmaz-701596127/
    Binujaya Rajatheja
    1 person likes this
    • Binujaya Rajatheja
      Binujaya Rajatheja

    Reply


    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings