This content has been marked as final. Show 21 replies
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.
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.
How do you know he's running on Windows?
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.
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.
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
[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