Ora-01031:insufficient Privileges Solution

Source: Internet
Author: User
Tags session id true true

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.