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, if you do not add the tool, add the tool as follows: Start-> Program-> oracle-> Configuration and Migration Tools (Configuration and Migration Tools) -> Administration Assistant for Windows oracle Managed Objects-> Computers-> computer name-> OS database administrator-right-click the computer to add/delete the current user and save it to ora_dba to log on to oracle using sys.! Then the ora-01031 is able to solve the problem of opening a package and executing the compilation prompt: ORA-01219: database not open: queries allowed on fixed tables/views only "ORA-01219: database not open: execute SQL --- select open_mode from v $ database; Execute SQL --- alter database open; prompt error: ORA-01157: cannot identify/lock data file 7-see DBWR trace fileORA-01110: data file 7: 'C: \ ORACLE \ ORADATA \ ISMART \ sysmgr_data.dbf' check whether the file shown in file7 exists: If not: 1. execute "alter database create datafile 7;" 2. run alter database datafile 7 offline drop 3. execute "alter database open". If so, perform steps 2 and 3 above.