SESSIONS_PER_USER error
Posted: Mon Jan 24, 2011 8:14 am
Hello,
I am getting the below error in Production. Can you help me understand where to look for this parameter? Has anyone come across this type of error?
The job is simply loading incremental data from source to staging using change data capture. This is a repeated error every week but is not limited to only one job. It happens very randomly in a sequence of 20 staging tables.
The admin says the user id has 35 sessions limit available. How to know how may sessions is DS establishing with a 2 node configuration?
TCLIENT_LOAD,0: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
TCLIENT_LOAD,0: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
TCLIENT_LOAD,0: APT_OraReadOperator: connect failed.
Thanks,
Sree
I am getting the below error in Production. Can you help me understand where to look for this parameter? Has anyone come across this type of error?
The job is simply loading incremental data from source to staging using change data capture. This is a repeated error every week but is not limited to only one job. It happens very randomly in a sequence of 20 staging tables.
The admin says the user id has 35 sessions limit available. How to know how may sessions is DS establishing with a 2 node configuration?
TCLIENT_LOAD,0: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
TCLIENT_LOAD,0: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
TCLIENT_LOAD,0: APT_OraReadOperator: connect failed.
Thanks,
Sree