hi

[Former Member]

Plz help me on what is ORA-1000 error

regards

padmanabha

[former_member563406 · Accepted solution]

Hi,

ORA-01000: maximum open cursors exceeded

refer to notes 725340, 398927 on service marketplace.

Regards,

Mohan

[Former Member]

Hai ,

ORA-01000: maximum open cursors exceeded

Other terms

Oracle, open cursors, exchange infrastructure

Reason and Prerequisites

The parameter "open_cursors" is set too low. Long transactions, such as imports, may use up all available cursors and fail.

Solution

• THIS NOTE APPLIES TO XI 3.0 SP2 ONLY **

Dear XI customer,

if you encounter an exception that reports "ORA-01000: maximum open cursors exceeded" please adjust the open_cursors parameter as follows:

If the BR*Tools exist on your system:

1] directory: /usr/sap/<SID>/SYS/exe/run

2] "brspace -c force -f dbparam -a change -p open_cursors -v 100000"

3] directory: $ORACLE_HOME/dbs (Unix) or %ORACLE_HOME%/database (Win)

4] change open_cursors parameter in init<SID>.ora to 100000

If the BR*Tools are not available (2] above - command not found)

1] change the open_cursors parameter as in 4] above

2] restart DB, for changes to take effect. _ NOTE: This problem has been fixed with XI 3.0 SP3 (see note 735078)

Plz asign points if helpfull.

prashanth