Discussions
Categories
- 381.9K All Categories
- 2.1K Data
- 207 Big Data Appliance
- 1.9K Data Science
- 447.4K Databases
- 220.8K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 23 Multilingual Engine
- 516 MySQL Community Space
- 464 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 471 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.9K SQL & PL/SQL
- 20.9K SQL Developer
- 292.7K Development
- 7 Developer Projects
- 124 Programming Languages
- 289.4K Development Tools
- 95 DevOps
- 3K QA/Testing
- 645.5K Java
- 23 Java Learning Subscription
- 36.9K Database Connectivity
- 150 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.8K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 16 Java Essentials
- 143 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 197 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 243 LiveLabs
- 35 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 166 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
ORA-01031: insufficient privileges While trying / as sysdba
534640
Member Posts: 236
Hi All,
We have oracle database 10.2.0.3 on Linux x86 32 bit Server.
We are trying to connect our database with sysdba and getting [ORA-01031: insufficient privileges ] error.
I have recreated the password file:
orapwd file=orapwdPRODT password=mypassword
But still we are unable to login
-------------------------------------------------------------------------
sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:22:27 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
[[email protected] PRODT_dev1]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:33:30 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
Please note that we are able to login if we supply exact password which is in password file. But / as sysdba command is giving above errors.
My sqlnet.ora file is having entries:
SQLNET.AUTHENTICATION_SERVICES=(NTS)
I have also tried by removing this line but same error exist.
MY initPRODT.ora file is having this entry:
remote_login_passwordfile='EXCLUSIVE'
I have searched through metalink and google and normally this kind of errors resolved by recreating the password file. I have tried these solutions but unable to resolve this issue.
I have also followed Note:435947.1 and tried to relink the config files but again same problem exist.
Can any one help me in this regard???
We have oracle database 10.2.0.3 on Linux x86 32 bit Server.
We are trying to connect our database with sysdba and getting [ORA-01031: insufficient privileges ] error.
I have recreated the password file:
orapwd file=orapwdPRODT password=mypassword
But still we are unable to login
-------------------------------------------------------------------------
sqlplus sys as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:22:27 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
[[email protected] PRODT_dev1]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Wed Apr 9 12:33:30 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
-----------------------------------------------------------------------
Please note that we are able to login if we supply exact password which is in password file. But / as sysdba command is giving above errors.
My sqlnet.ora file is having entries:
SQLNET.AUTHENTICATION_SERVICES=(NTS)
I have also tried by removing this line but same error exist.
MY initPRODT.ora file is having this entry:
remote_login_passwordfile='EXCLUSIVE'
I have searched through metalink and google and normally this kind of errors resolved by recreating the password file. I have tried these solutions but unable to resolve this issue.
I have also followed Note:435947.1 and tried to relink the config files but again same problem exist.
Can any one help me in this regard???
Tagged:
Comments
-
-
Well about OS details:
[[email protected]]$ id oracle
uid=500(oracle) gid=500(dba) groups=500(dba),501(oinstall)
[[email protected]]$ grep oracle /etc/passwd
oracle:x:500:500::/home/oracle:/bin/bash
[[email protected]]$ grep dba /etc/group
dba:x:500: -
Set the ORACLE_SID and ORACLE_HOME values first before using OS Authentication
Are you having multiplie DBs /Multiple Oracle Homes? -
We have two different homes. one for current Oracle database 10gR2 and other one is old 9i database from which we have upgraded the database. (9i to 10g).
We have properly set the environment for ORACLE_SID and ORACLE_HOME in bash_profile. even I have tried .oraenv before trying to connect.
Note: Sysdba logins were possible after the upgrade and we have applied the patch (5985992-upgraded version of autoconfig) day before and this problem started occuring.
Thats why we relink the oracle and its libraries according to metalink notes.
Right now env command is also showing the correct path of current database. -
echo $ORACLE_SID
echo $ORACLE_HOME -
Maran As I mentioned in previous thread I have confirmed these parameters:
[[email protected] or10g]$ echo $ORACLE_SID
PRODT
[[email protected] or10g]$ echo $ORACLE_HOME
/dev1_vis/or10g
You can see that SID and HOME both are properly set.
Even when we are trying sqlplus utility its showing version 10.2.0.3 which is confirmation that its using New oracle 10g Home. -
Last Option
Try TNSPING DBNAME
check which sqlnet.ora it uses... -
[[email protected] ~]$ tnsping PRODT
TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 09-APR-2008 14:44:19
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
/dev1_vis/or10g/network/admin/PRODT_dev1/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=DEV1.ubl.com.pk)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PRODT) (INSTANCE_NAME=PRODT)))
OK (10 msec) -
Hi Khalid,
I hope the problem is with the password file,
Please create the file in the following format.
orapwd file=orapwPRODT password=mypassword entries=5.
just check it out and let me know. Correct me if am wrong. -
One more thing where is the password file created?
/dbs or database it should be under /dbs
This discussion has been closed.