Home » RDBMS Server » Server Administration » Problem with Oracle 10g (Release 1 & 2)
Problem with Oracle 10g (Release 1 & 2) [message #258192] Fri, 10 August 2007 09:43 Go to next message
abhitabh.jamankar
Messages: 4
Registered: August 2007
Location: India
Junior Member
Hi,
problem with Oracle 10g(release 1 & 2)

I change the password of sys user using
>conn sys/oldpassword as sysdba;
>alter user sys idetified by newpassword;
now the problem is that i can log in using both the passwords.
Mad How it possible? The old one should not be considered.
I restart the database but have the same problem.
Try it and reply.

icon14.gif  Re: Problem with Oracle 10g (Release 1 & 2) [message #258231 is a reply to message #258192] Fri, 10 August 2007 11:11 Go to previous messageGo to next message
sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata
Senior Member

This happens because only SYS defaultly used the password file. In the password file if the maximum entries option is given more than one then it happen.

For more information please see the link
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521.pdf

Cheers
Sanka
Re: Problem with Oracle 10g (Release 1 & 2) [message #258245 is a reply to message #258231] Fri, 10 August 2007 12:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
you would also be able to connect as
sqlplus '/ as sysdba'
i guess .Your OS authentication is enabled.
Re: Problem with Oracle 10g (Release 1 & 2) [message #258322 is a reply to message #258192] Sat, 11 August 2007 00:35 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

It is happen becuase during login password is not check.
SQL> conn sys/oracle@orcl as sysdba
Connected.
SQL> conn sys/wrongpassword@orcl as sysdba
Connected.
SQL> conn sys/none@orcl as sysdba
Connected.


Reason
1. OS user is member of ORA_DBA group
2. sqlnet.ora "sqlnet.authentication_services=(NTS)

Regards
Taj
Re: Problem with Oracle 10g (Release 1 & 2) [message #258773 is a reply to message #258231] Mon, 13 August 2007 10:02 Go to previous messageGo to next message
abhitabh.jamankar
Messages: 4
Registered: August 2007
Location: India
Junior Member
Hi
Please can you explain in detail
Thanks
Re: Problem with Oracle 10g (Release 1 & 2) [message #258829 is a reply to message #258773] Mon, 13 August 2007 11:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Administrator's Guide
Chapter 1 Overview of Administering an Oracle Database
Section Database Administrator Authentication

In addition, in Windows, OS authentication is activated only if sqlnet.authentication_services include NTS (Windows Authentication Service).

Regards
Michel
Re: Problem with Oracle 10g (Release 1 & 2) [message #258849 is a reply to message #258773] Mon, 13 August 2007 11:53 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
abhitabh.jamankar wrote on Mon, 13 August 2007 09:02
Hi
Please can you explain in detail
Thanks



Yes iFF you gonna pay me Wink
But michel gave you free link.
Previous Topic: Standby database
Next Topic: dump
Goto Forum:
  


Current Time: Sun Dec 04 16:38:11 CST 2016

Total time taken to generate the page: 0.05957 seconds