ORA-00604: error occurred at recursive SQL level 1#ORA-00018

[former_member346857]

Hi All,

I have just rebuilt an existing application server, the setup I have now is a database server with oracle and two application servers. The problem I am having is whenever I bring up the new application server I get short dumps and error messages in the log which is ORA-00604: error occurred at recursive SQL level 1#ORA-00018 does anyone have an idea of why I am getting this error when the new server is started?

Thanks

Jay

[Former Member · Accepted solution]

hello,

the oracle error ora-00018 means

ORA-00018: maximum number of sessions exceeded

This means that too many R/3 workprocesses (new application server - additional work

processes connecting to the oracle database) try to connect to the database at the

same time. You need to increase the value for the oracle sessions in the initSID.ora

file or/and spfile.

Kind regards,

Andreas

[Former Member]

you will have work at database level

/message/2522505#2522505 [original link is broken]

http://www.orafaq.com/forum/t/83442/0/

regards

nag