5 Replies Latest reply: Oct 17, 2013 12:04 PM by JDinPA RSS

    Oracle 12c can't loging with EM Express error: Security token does not match. You must login again...

    user537222

      I configured EM express and proceed to login. I was able to access the login page but when attempting to login using the user 'system' I get the following error: Security token does not match. You must login again...

       

      -I installed by 12c database manually using  a CREATE DATABASE statement and ran the recommended sql scripts catproc.sql, catalog.sql and using system pupbld.sql

      - I configured the dispatcher parameter at init.ora and confirmed configuration:

      SQL> show parameter dispatchers

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      dispatchers                          string      (PROTOCOL=TCP) (SERVICE=VOLBXDB

      - from lsnrctl status output:

      .......

      DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=<editedhereforpostingatforums>)(PORT=5500))(Security=(my_wallet_directory=/app/oracle/product/12.1.0/dbhome_1/admin/VOLB/xdb_wallet))(Presentation=HTTP)(Session=RAW))

      ......

      Service "VOLBXDB" has 1 instance(s).

      ......

      -I'm not using a named listener.

      -XDB https port is configured (I'm  able to connect to the login page)

      Any idea of what I'm missing?

       

      Here's more information...........

       

      In Firefox I get a window back with more details, and it seems it's failing on: saveToken(): saving the token

      9934     : DBUrlLoader.reportLoadComplete(): done loading

      9935     : doLogin(): save token

      9937     : saveToken(): saving the token

       

      Here's the entire error message:

       

      TypeError: Error #1034

       

      Memory Log:

      0     : AppContext(): params=null, bootStrap: true

      8     : AppContext(): params=[object Object], bootStrap: false

      8     : AppContext(): _locale=en-US

      19     : AppContext(): no active report(Object)#0

        caching = "1369729771"

        em_express = "true"

        locale = "en-US"

      19     : AppContext(): _em_express=true _emx_caching_number=1369729771 resourceDir=/em/resources

      19     : AppContext(): localeChain is null, resourceDir=/em/resources

      19     : NLSResources.setRootUrl(): rootUrl=/em/resources

      20     : AppContext:createAppContext(): AppContext.execModeem

      35     : NLSResources.initResource()

      60     : EMAppicationScript - showPage() page.pageFeature=null, currentPage=null

      265     : DBUrlNavigator:navigateToApp(): login/login

      265     : pages length: 1

      265     : page feature: login/login

      266     : EMPageScript initiateRefresh() urlvariables:

      272     : EMBaseController.refreshModel(): enter

      272     : EMBaseController:refreshModel(): prevRefreshUrlVariables=

      272     : doProcessLanguage(): enter

      273     : NLSResources.getSelectedLocale(): locale=en_US

      273     : NLSResources.loadResource(): locale=en_US currentLocale=en_US

      275     : EMAppicationScript - showPage() page.pageFeature=login/login, currentPage=emxLogin0.EMApplication6.viewStack.EMLandingPage11

      275     : EMAppicationScript - showPage() currentPage.pageFeature=null

      9763     : DBUrlLoader:loadInternal(): loading comp=Login rep=doLogin

      9932     : DBUrlLoader.onComplete(): success (str=<login token="EYSakD/xk4LKDGMM8yeLAA==">ok</login>...)

      9934     : DBUrlLoader.reportLoadComplete(): done loading

      9935     : doLogin(): save token

      9937     : saveToken(): saving the token

      9968     : DBUrlLoader.reportLoadComplete(): notify failure in processFct

      TypeError: Error #1034

       

      ***********************************************************************************************************************************************************

      So I set a trace event on init.ora:

      event="31098 trace name context forever, level 2"

      **********************************************************************************************************************************************************

      And found the error at: <SID>_s000_6534.trc, following are the relevant lines and at the bottom the error I got back in the browser

       

      POST                

      /em/orarep/config/server_info

      HTTP/1.1              
      Host: <editedhereforpostingatforums>:5500
      Connection: keep-alive
      Content-Length: 9     

      Origin: https://<editedhereforpostingatforums>:5500

      Accept-Language: en_US   

      User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.62 Safari/537.36

      Content-Type: application/x-www-form-urlencoded                                                                  
      Accept: */*                                                                                                      
      Referer: https://<editedhereforpostingatforums>:5500/em/shell                                                                        
      Accept-Encoding: gzip,deflate,sdch                                                                               
      Cookie: EMXSESSIONID_5500=MFOi8ezEbyMs+6l0rQ4DPg==                                                               
      post=true                                                                                                        
      HTTP/1.1 200 OK                                                                                                  
      MS-Author-Via: DAV                                                                                               
      DAV: 1,2,<http://www.oracle.com/xdb/webdav/props>                                                                 
      Server: Oracle XML DB/Oracle Database                                                                            
      Content-Type: text/xml                                                                                           
      Transfer-Encoding: chunked                                                                                       
      0029                                                                                                             

      <mesg type="emxerr">TOKEN_MISMATCH</mesg>   <--------------------------------------- I can see at the trace the same error but this is a binary file so that's all I can read

       

      Message was edited by: user537222