1

Trying to start oracle service, shows me the follow error:

enter image description here

I have the follow SPFILEXE.ORA:

enter image description here

Im using ORACLE XE, but really I don't know which parameter change and what should be the value.

Please help !!! Thanks in advance

2 Answers 2

1

Try doubling shared pool size to 1G, or 1000M.

Java pool should be larger if you're using EJB.

Large pool should be much larger if you're using RMAN.

Remove sessions.

Reduce processes by a LOT, like start with 200. Are you ever going to use close to 10,000??? XE is not meant for that many processes.

Make job_queue about 20.

0

I home you aren't trying to edit that spfile with a text editor!! It is a binary file (in spite of so much clear text) and will be corrupted if you deliberately or inadvertently modify it directly. I'd cut back on open_cursors, processes, and sessions. I've only got open_cursors=300 on my big production databases; processes=150.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.