This discussion is archived
1 Reply Latest reply: Nov 21, 2012 1:59 AM by 975447 RSS

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

remc0 Journeyer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points