报错原因:在sqlplus中使用host命令然后exit返回,再此启动数据库会报此错;
SYS@PROD> host [oracle@PROD ~]$ exit exit SYS@PROD> ! [oracle@PROD ~]$ exit exit SYS@PROD> startup ORA-01031: insufficient privileges
解决办法原理:host后调用系统权限,exit回到sqlplus出现权限不足
SYS@PROD> exit Disconnected [oracle@PROD ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 6 21:43:47 2017 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss' * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0 SYS@PROD> startup ORACLE instance started. Total System Global Area 830930944 bytes Fixed Size 2217912 bytes Variable Size 503318600 bytes Database Buffers 322961408 bytes Redo Buffers 2433024 bytes Database mounted. Database opened. SYS@PROD>