1 Reply Latest reply: Nov 21, 2012 3:59 AM by 975447 RSS

    ORA-12520: TNS:listener could not find available handler for requested type

    remc0
      Hi all,

      I just installed biapps on my laptop. And now when I load data from an ebs vision image I am getting the following errors in SOME mappings:
      Severity: ERROR
      Timestamp: 11/20/2012 7:16:34 PM
      Node: node01_REMVAND-NL
      Thread: WRITER_1_*_1
      Process ID: 8496
      Message Code: WRT_8001
      Message: Error connecting to database...
      WRT_8001 [Session SDE_ORA_CodeDimension_Department Username BAW DB Error -1
      Database driver error...
      Function Name : Logon
      ORA-12520: TNS:listener could not find available handler for requested type of server

      Database driver error...
      Function Name : Connect
      Database Error: Failed to connect to database using user [BAW] and connection string [orcl].]


      -------------------------
      orcl is my datawarehouse..
      When I restart the dac then it will crash on other mappings and the mappings will complete which ran in an error before.

      I reduced the Max number of connection in the dac to the datawarehouse, however, this did not help.

      I also found somewhere an bug that happens in the XE database (however I have installed the enterprise edition, version 11.2.0.3.0)
      that I have to increase the concurrent processes with:

      SQL> alter system set processes=100 scope=spfile;
      SQL> shutdown immediate;
      SQL> startup;

      This doesn't resolve it as well...

      Can anyone help me out?

      Thanks,

      Remc0