ORA-01219 problem solution; ora-01031: insufficient privileges Problem Solution

Source: Internet
Author: User

Login sys user prompt: ora-01031: insufficient privileges;

Open the user account in the control panel and find that the current login account is not in the ora_dba domain;

Add method: Start-> Program-> Oracle-> Configuration
And migration tools (configuration and porting tools)-> Administration Assistant for Windows

Oracle
Managed Objects-> computers-> computer name-> OS database administrator-right-click the computer to add or delete the current user and save it to ora_dba.

Log on to Oracle using sys! So ora-01031 can solve

Prompt for opening a package to execute Compilation:

ORA-01219: Database not open: queries allowed on fixed tables/views only
Warning window for ORA-01219: Database not open: Allow queries only in fixed tables/Views

Execute SQL --- Select open_mode from V $ database;

Execute SQL --- alter database open;

Error prompt:
ORA-01157: cannot identify/lock data file 7-see dbwr trace file
ORA-01110: data file 7: 'C: \ oracle \ oradata \ ismart \ sysmgr_data.dbf'

Check whether the file shown in file7 exists:

If it does not exist:

1. Execute "alter
Database create datafile 7 ;"

2. Execute alter database datafile 7 offline drop

3. Execute "alter database open"

If yes, perform steps 2 and 3 above.



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.