Yesterday has been doing Oracle's startup parameter settings, forgot to set it back. In the morning a landing on the error ora-01031:insufficient privileges
Just reset it back.
As follows:
Sql> Conn Scott/tiger;
Error:ora-01033:oracle initialization or shutdown in progress process id:0 session id:154 serial number: 7 warning: You are no longer connected to ORACLE.
Sql> Startup ora-01031:insufficient Privileges sql> conn System/manager; Error:ora-01033:oracle initialization or shutdown in progress process id:0 session id:154 serial number: 7 sql> show Parameter Passwo
Rd sp2-0640: sql> conn/as sysdba not connected;
is connected. Sql> Show parameter password NAME TYPE VALUE---------------------------------- -----------------------------------------remote_login_passwordfile string EXCLUSIVE sql> Select * FR
Om v$pwfile_users; USERNAME sysdb SYSOP Sysas---------------------------------------------SYS
True true FALSE sql> shutdown abort;
The ORACLE routine has been closed.
sql> startup pfile= ' D:/APP/ADMINISTRATOR/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.O RA ' ORACLE routine has started. Total System Global area 535662592 bytes Fixed Size 1334380 bytes Variable Size 226493332 bytes Database buffers 301989888 bytes Redo Buffer
s 5844992 bytes Database loading complete.
The database is already open.
sql> sql> Conn Scott/tiger;
is connected.
sql> sql> col empno for 999999 sql> run; 1* SELECT * from emp where rownum =1 EMPNO ename JOB MGR hiredate SAL COMM DEPTNO--- ---------------------------------------------------------------------7369 SMITH Clerk 7902 17-12
Month-80 800 20
OK, just find the initial value pfile and then specify that the startup is OK.