A small spfile issue solved today

Source: Internet
Author: User

A server cannot be started. After checking, It is the initorcl at startup. the ora file cannot be found. Then, find the entire system directory and find an init. ora file,> startup pfile = init. ora. The database was successfully started and woho was lucky.

Put this file under database/and change it to initorcl. ora. Use pfile to specify startup. After startup,> Create spfile to pfile;

Check show parameter spfile. If no path is found, restart the database. This time, pfile is not input, check show parameter spfile, and the path has been entered, then confirm that the database has been started with spfile. The created spfile is called spfileorcl. ora (probably this name) in database)

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.