-
1. Re: I cannot login as SYSDBA
Hi,
you dont have permission to access the database,
Do this:
C:/>Sqlplus/nolog
SQL>Conn/as sysdba
SQL> Startup
Then Create a user and grant t he connect/resource privilage
Regards
S.Senthil Kumar -
2. Re: I cannot login as SYSDBA
This type of errors comes only when u have forgotten uar password for sys.
So create a new password file ora%SID% and give some new password to this file and then connect as sysdba using that password only .
It will works...
Vipin -
3. Re: I cannot login as SYSDBA
I have permissions to connect to database, but I haven't permissions to connect as SYSDBA.
C:\>sqlplus /nolog
SQL*Plus: Release 8.0.5.0.0 - Production on Mon Mar 26 8:46:56 2007
(c) Copyright 1998 Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Invalid option.
Usage: CONNECT <username> [AS SYSDBA|SYSOPER]
SQL> connect system/manager
Connected.
SQL> connect system/manager as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL>
-
4. Re: I cannot login as SYSDBA
hi ,
are you trying to connect from any remote machine in your LAN??
SKP -
5. Re: I cannot login as SYSDBA
system user dont have the privileges to access to the Db as sysdba
login as a user who has sysdba privileges.
System dont have SYSDBA privileges -
6. Re: I cannot login as SYSDBA
i'm also in agree with maran.. system user dont have sysdba privileges .. try to connect as sys user might help..
connect sys/pwd@hoststring as sysdba; -
7. Re: I cannot login as SYSDBA
Sorry I cannot format to the output...
SQL> connect USER/PASSWORD
Connected.
SQL> select * from user_role_privs;
USERNAME GRANTED_ROLE ADM DEF OS_
-------- ------------ --- --- ---
USER CONNECT NO YES NO
USER DBA NO YES NO
USER RESOURCE NO YES NO
SQL> connect USER/PASSWORD as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> connect sys/change_on_install as sysdba;
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.
SQL> connect sys/change_on_install
Connected.
SQL> select * from v$pwfile_users;
ERROR:
ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [],[]
no rows selected
SQL>
I found that password file doesn't exist so I created it.
C:\>orapwd file=PWDORCL.ORA password=password
I cannot restart server until one hour to update change. -
8. Re: I cannot login as SYSDBA
Again as a user who has password cannot login as sysdba
create a user,grant him sysdba privilge,create a password file,
then try to login as the USER and see -
9. Re: I cannot login as SYSDBA
Check the following parameter in your init.ora
remote_login_passwordfile string EXCLUSIVE
Should be set to EXCLUSIVE. Then make sure that the password file exists in $ORACLE_HOME/dbs in this format - orapw$ORACLE_SID -
10. Re: I cannot login as SYSDBA
The parameter is for login from remote machine as sysdba not for local login am i right?
Message was edited by:
Maran Viswarayar -
11. Re: I cannot login as SYSDBA
Yes, that's true. Also true if you try to login thru two-task from the local machine. However, irrespective of that you do need the orapw<$ORACLE_SID> file in $ORACLE_HOME/dbs.
And when you execute this query, you should get the following row(s):
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
SYS TRUE TRUE -
12. Re: I cannot login as SYSDBA
What is the purpose of internal account in Oracle please ? Because now I'm connected to internal. -
13. Re: I cannot login as SYSDBA
thanx
working..
from command prompt
sqlplus "/as sysdba" also works:-) -
14. Re: I cannot login as SYSDBA
user13574172 wrote:
Did you notice you were thanking someone from a thread that is over 4 years old, dealing with a version of oracle that hasn't been supported in this millennium?
thanx
working..
from command prompt
sqlplus "/as sysdba" also works:-)