OraFAQ Forum: Server Administration » Problem with Oracle 10g (Release 1 & 2)

Home » RDBMS Server » Server Administration » Problem with Oracle 10g (Release 1 & 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with Oracle 10g (Release 1 & 2) [message #258192]

Fri, 10 August 2007 09:43

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.

Report message to a moderator

Re: Problem with Oracle 10g (Release 1 & 2) [message #258231 is a reply to message #258192]

Fri, 10 August 2007 11:11

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

Report message to a moderator

Re: Problem with Oracle 10g (Release 1 & 2) [message #258245 is a reply to message #258231]

Fri, 10 August 2007 12:15

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.

Report message to a moderator

Re: Problem with Oracle 10g (Release 1 & 2) [message #258322 is a reply to message #258192]

Sat, 11 August 2007 00:35

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

Report message to a moderator

Re: Problem with Oracle 10g (Release 1 & 2) [message #258773 is a reply to message #258231]

Mon, 13 August 2007 10:02

abhitabh.jamankar
Messages: 4
Registered: August 2007
Location: India

Junior Member

Hi
Please can you explain in detail
Thanks

Report message to a moderator

Re: Problem with Oracle 10g (Release 1 & 2) [message #258829 is a reply to message #258773]

Mon, 13 August 2007 11:28

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Problem with Oracle 10g (Release 1 & 2) [message #258849 is a reply to message #258773]

Mon, 13 August 2007 11:53

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.

Report message to a moderator

Previous Topic:	Standby database
Next Topic:	dump

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 09:51:15 CST 2024