on 07-20-2010 8:04 AM
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
E:\Documents and Settings\Administrator>sqlplus/nolog
SQLPlus: Release 10.2.0.2.0 - Production on Sun Jul 20 12:30:17 2008*
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> connect as sysdba
Enter user-name: system
Enter password:
ERROR:
ORA-01031: insufficient privileges
SQL>
iam using ecc6.0
any one give me solution
Edited by: Mugala Balu on Jul 20, 2010 9:05 AM
My first question is why you are trying to connect your DB from Administrator user?
You don't have any DB admin (SIDADM or ORASID) in your landscape?
As told by above techies, just logoff from administrator and relogin with SIDADM then try....it should work.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mugala,
login with your <SID>adm user, then connect to your database as sqlplus /as sysd\ba.
hopefully it will resove your problem.
Regards,
Priya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
your logged on as "Admin"
Trying logging on as "sid<adm>" ora "ora<sid> and try again..
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use the below command also to connect to database
sqlplus "/as sysdba"
if you again face the error, please logoff and login with SIDADM and try the above command.
thanks,
Mahendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.