This content has been marked as final. Show 21 replies
1 person found this helpful
piku wrote:do EXACTLY as below
I have one instance name is skydb and once upon a time i used it when i created it.i did set one password for the sys user and created password file.but right now i have forgot the password of sys.again creating the password file using below command.
but can not able to log in into sys as sysdba using this 'oracle' password .
orapwd file=orapwdskydb password=oracle entries=10
for your information now the database is down.we also need to up it.
thanks a lot in advance.
/ as sysdba
An operating system would be nice to know.1 person found this helpful
Also confirmation that your ORACLE_SID is set to "skydb"
And that you created the password file in the correct location (which depends on the answer to the first point)
Additionally, you should be able to do a password-less SYS connection directly on the server itself. (i.e, connect / as sysdba) if your OS user is a member of the DBA group.
AS sb suggested.....1 person found this helpful
first check oracle service for database skydb is running in windows from services.msc
cmd>sqlplus / as sysdba
sql>alter user sys identified by password;
you can change sys user password using alter user command as stated above....
How do you know he's running on Windows?1 person found this helpful
Both you and sb are wrong, too, in just saying '/ as sysdba' will fix it. If our user was a member of the ORA_DBA or DBA group, then sqlplus "sadjhdjkf/djfhskjfhksdj as sysdba" would work regardless of what password has been set in the password file. Conversely, if he's NOT a member of the ORA_DBA or DBA group, then trying to "connect / as sysdba" isn't going to work.
So we can deduce he's using an OS account that isn't privileged. Perhaps because he's connecting remotely. But either way, that will require the use of a proper SYS password at connection time.
Meaning we can't just fob him off with "try typing "sqlplus / as sysdba exactly", because that's not going to work.
he don't know how to login into oracle database so I Assume he will not be on NIX system.....lets wait for op reply if he get any error we will give NIX way also...... :-)
Bad assumption to make on flimsy grounds, I think.
But that still doesn't make telling him "use / as sysdba" any better, because that obviously cannot work in his situation, whatever OS he turns out to be on. If he's getting an error using "oracle" as the password, then he's not a member of an OS privileged group. Therefore, he **can't** use "/ as sysdba".
Which is why I was careful to say that he could try "/ as sysdba" if he was directly connected to the database server AND that he was a member of the OS privileged group. Without those caveats, your advice (and sb's) was simply wrong.
I'm sorry catfive....I will ask OS before giving advice.....thanks for reminding .....
I am using / as sysdba always at home....as op said he has install it so he will automatically became member of ORA_DBA group....
first of all thaks a lot for your promt reply.now for your information my os info is
my account user is in DBA group and its confirm.
Linux oracleDB11g 2.6.32-71.el6.i686 #1 SMP Fri Nov 12 04:17:17 GMT 2010 i686 i686 i386 GNU/Linux
now am giving the output of the
[oracle@oracleDB11g admin]$ sqlplus / as sysdba SQL*Plus: Release 22.214.171.124.0 Production on Wed Jan 23 11:04:25 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges
also want to tell you I have created that password file on location is
[oracle@oracleDB11g admin]$ sqlplus /nolog SQL*Plus: Release 126.96.36.199.0 Production on Wed Jan 23 11:05:59 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. SQL> connect / as sysdba ERROR: ORA-01031: insufficient privileges
thanks once again
Hi,1 person found this helpful
Please check proper ORACLE_SID is set and password file contains valid SID name.
X A H E E R
paste output for
ps -ef|grep pmon
Could you show us output of "env" command?
Check ORACLE_SID parameter.
And also check follows.
[oracle@oracleDB11g dbs]$ export ORACLE_SID=skydb [oracle@oracleDB11g dbs]$ echo $ORACLE_SID skydb [oracle@oracleDB11g dbs]$ sqlplus / as sysdba SQL*Plus: Release 188.8.131.52.0 Production on Wed Jan 23 11:25:32 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges [oracle@oracleDB11g dbs]$ ps -ef|grep pmon oracle 3082 2915 0 11:25 pts/1 00:00:00 grep pmon
Can you please post output of "id" command? and group permission given to Oracle user?
your database is not running.....
as you can see from pmon command....
check permissions for insufficient privileges....