var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ORA-01017 : invalid username/password; logon denied
I want to be able to start sqlplus by typing 'sqlplus /' at the command line.
Here's what I've done so far:
I'm on 9i (9.2 on HPUX) & have set the following values in my initSID.ora:
remote_login_passwordfile=NONE (have also tried EXCLUSIVE)
os_authent_prefix=""(have also tried OPS$)
& then have bounced the instance & verified that the values have taken effect by selecting from v$parameter.
I start sqlplus & 'create user extern identified externally;' & grant the user the dba role.
However, when I type 'sqlplus /' I get the following error: 'ORA-01017 : invalid username/password; login denied.
Has anybody got any ideas? What am I missing out on here?
Thanks for your help.
Have you tried
and then typing / as sysdba at the username prompt?
Unfortunately I must use 'sqlplus /'. Certainly being able to use
username: as sysdba
would be great, but the brief is to be able to connect as sqlplus /
Does anybody know if this is a known Oracle 9.2 bug? I've trawled Oracle's OTN & have found nothing on this problem. My users are starting to get frisky, so any suggestions would be greatly appreciated.
What user are you logged into the OS as?
Is there a database user with this same name?
If you have access to multiple databases, is the ORACLE_SID environment variable set properly?
remote_login_passwordfile should be EXCLUSIVE
Oracle changed the security setup since 9i and you must say "as sysdba" if you login w/o password.
When the CONNECT INTERNAL has been desupported in 9i, now users making DBA-privileged connections to the database must use one of the following syntaxes:
CONNECT / AS SYSDBA or CONNECT <username/password> AS SYSDBA
Hope that helps,
OCP - DBA