error 1303 insufficient privileges

Problem: Some colleagues reported that the newly installed database using conn sys/Oracle @ XXXX as sysdba login not up, prompt ORA-01031: insufficient privileges, and the user name and password are completely correct, log on normally without the @ xxx connector Conn/As sysdba. Process: first, identify that the current system uses operating system authentication, and then use system/manager @ xxxx to log o

Create view reports ORA-01031: insufficient privileges, insufficient Create view reported ORA-01031: insufficient privileges Create a script for the required experiment environment: create user lc0019999 identified by aaaaaa;create user lc0029999 identified by aaaaaa;grant d

Ora-01031: insufficient privileges, privilege Sqlplus "/as sysdba" cannot be connected or connect auxiliary sys/oracle @ sdyprod; Reporting ora-01031: insufficient privileges Solution Note that when multiple database instances are used, set ORACLE_SID = '', 1. Check whether sqlnet. ora (in the % ORACLE_HOME % NETWORKA

Author: skateTime: 2009/06/24 Sqlplus "/As sysdba" cannot connect, report ora-01031: insufficient privileges Solution Note that when multiple database instances are used, set oracle_sid = '', 1. Check whether sqlnet. ora (in the % ORACLE_HOME % networkadmin directory in Windows) contains this sentence: sqlnet. authentication_services = (ETS). If not, add 2. Check whether the user logg

Enter the User name: SYS/sys as sysdbaError:ORA-01031: insufficient privileges Enter the User name: System/system as sysoperError:ORA-01031: insufficient privileges Sys and system users cannot log on, and no permission is displayed: SQL> conn system/SystemConnected.SQL> grant sysdba to sys2;Grant sysdba to sys*

Operating Environment: Install the test on your own laptop (WIN10)Operating system version: 64-bit win8.1Oracle version: 64-bit Oracle 11gAfter installing Oracle successfully//log in as Administrator to OracleEnter the command in CMD sqlplus/as sysdbaThen error error:ora-01031 Insufficient privilegesWorkaround:In general, check whether the logged-on user of the operating system is included in the ORA_DBA gr

Under Linux, it is customary to log in with Sqlplus "/as sysdba". Today, on other machines, you have encountered an error as follows: [Oracle@db ~]$ sqlplus "/as sysdba" Sql*plus:release 11.2.0.3.0 Production on Mon June 24 01:59:24 2013 Copyright (c) 1982, Oracle. All rights reserved. ERROR:Ora-01031:insufficient Privileges Enter User-name: ^c[Oracle@db ~]$ Onl

The view's basic object has insufficient permissions and has been plagued for several days. This problem is solved by Ye Fei, I changed the dept table to view the execution plan. The process is as follows: SQL> conn Scott/Tiger Connected. SQL> set autotrace on; SQL> select * From tab; Tname tabtype clusterid ----------------------------------------------- Dept table EMP table Bonus table Salgrade table Mytable table Execution Plan -----------------

: Need to check system configurationLog in to Oracle[Java]View PlainCopy Sqlplus/as SYSDBA Inquire[SQL]View PlainCopy Sql> Show parameter password NAME TYPE VALUE ----------------------------------------------------------------------------- Remote_login_passwordfile string EXCLUSIVE Sql> 2: Check which users are[SQL]View PlainCopy Sql> SELECT * from v$pwfile_users; USERNAME Sysdb SYSOP --------------------------------------

Sqlplus "/As SYSDBA" not connected, ora-01031:insufficient privileges solution Note When multiple DB instances are set oracle_sid= ', 1, check Sqlnet.ora (under Windows in the%oracle_home%networkadmin directory) contains this sentence: sqlnet.authentication_services= (NTS), no words plus 2. Check whether the user logged in to Windows (Administrator or the user who installed Oracle) is included in the ORA_

Since I used Windows 7, I have never been better off, and the network has been disconnected by the standby mode. Some colleagues installed oracle11g, sqlplus/As sysdba, error: ora-01031: insufficient privileges Sqlnet. ora also sets system authentication, sqlnet. authentication_services = (ETS ). Later it was found that the System user is not in the ora_dba

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

1. Oracle is not in the DBA group. [Root @ localhost ~] # Gpasswd-D Oracle DBARemoving user oracle from group DBA[Root @ localhost ~] # Su-Oracle-Bash:/etc/profile: Line 61: syntax error: unexpected end of File[Oracle @ localhost ~] $ Sqlplus/As sysdba SQL * Plus: Release 10.2.0.1.0-production on ç ú?å 8 â 9 23:57:19 2013 Copyright (c) 1982,200 5, Oracle. All rights reserved. Error:ORA-01031: insufficient