ORA-00600

pts.
Tags:
Help Desk
Tech support
Using Oracle 8i. Failing to log into sql plus. ORA-01033, ORA-00604 and ORA-0100109. shutdown at command prompt is coming up with ORA-01109 and startup is coming up with ORA-00600. Please kindly assist. I am a new user of Oracle. Thank you

Answer Wiki

Thanks. We'll let you know when a new response is added.

ORA-01033 is ‘startup or shutdown in progress’ – so you’re trying to connect before the database is properly up.
ORA-01109 is ‘database not open’, so again, the database is not starting up properly.

Your other erros indicate some internal issues with the instance.

Have you checked your memory requirements for the SGA and other areas, and the memory settings on the server?

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Uktdtd
    ORA-01033 is 'startup or shutdown in progress' - so you're trying to connect before the database is properly up. ORA-01109 is 'database not open', so again, the database is not starting up properly. Your other erros indicate some internal issues with the instance. Have you checked your memory requirements for the SGA and other areas, and the memory settings on the server?
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following