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

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.