Share an example of Oracle problem solving today

Source: Internet
Author: User
Tags sessions

Share an example of Oracle problem solving today

Prompt for "ora-00600:internal error code, arguments" error when starting Oracle?

Sql> Startup

Ora-00600:internal error code, arguments: [Ksunfy:too few sessions], [9504], [75040], [], [], [], [], [], [], [], [], [ ]”

Workaround: The error here shows that Oracle's processes and sessions values are too large.

(1) Modifying the values of processes and sessions

*.processes=10000

*.sessions=10000

Save

(2) sql> create SPFile from pfile= '/home/oracle/pfile20151225.ora ';

File created.

Sql> Startup

ORACLE instance started.

Total System Global area 8.5516E+10 bytes

Fixed Size 2237776 bytes

Variable Size 8858372784 bytes

Database buffers 7.6504E+10 bytes

Redo buffers 151142400 bytes

Database mounted.

Database opened.

Problem solving

is not very simple for Linux systems that are duly completed.

If you are new to the Linux system, you may want to download a German Linux software center to try it out first.
Free: Http://www.nfs-cloud.cn:81/appCenter/open/softcenter

It contains a good thousands of kinds of deb package, can meet the needs of users of all aspects of software, at the same time, our software center is recently stepping up the improvement, will be a new version, please look forward to.


Share an example of Oracle problem solving today

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.