Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Ashish.

Asked: March 16, 2017 - 9:21 pm UTC

Last updated: March 22, 2017 - 1:44 am UTC

Version: oracle 12c

Viewed 1000+ times

You Asked

Hi Tom,

we have an instance of oracle running on one of our client server .
But I found a strange thing, that I can login into the oracle server
using 2 different password and it let us do that .
Is it possible that Sys object have two passwords ? and if yes ? how we can delete one of the password
so we can only login by only one password.
Also please describe what is the usage of multiple password for a Sys object.

example : sys/oldpassword@evo as sysdba
sys/newpassword@evo as sysdba

I can login by both .

cheers
ashish

and Connor said...

It could be a mismatch between password file and dictionary

See this link

https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:670117794561

It's a little dated but might still be relevant for you

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Muhammad Riaz, March 19, 2017 - 11:18 am UTC

If you are on server and even using a TNS Name to connect 'as sysdba', you are actually using OS authentication

P:\>sqlplus sys/asdasdasd@ora11gpr as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 19 15:14:24 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

P:\>sqlplus sys/asfdsdfsdfsdf@ora11gpr as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sun Mar 19 15:14:31 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

SQL>

Connor McDonald
March 22, 2017 - 1:44 am UTC

nice input
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.