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.