ORAPWD Utility

[dba_giri]

Hi..,

1)
I 've created a user & provided the roles as follow:
Grant connect,resource,sysdba to U10 identified by U10;

2)
And the remote_login_passwordfile parameter value is EXCLUSIVE

3)
I 've executed the following command at
d:\oracle\product\10.2.0\db_1\database
as follows:
orapwd file=orapwpwdorcl.ora password=pass1234 force=y

4)
Select username From v$pwfile_users;
SYS
U10

On my client machine
************************************
I 've connected using U10 user with following :
u10/u10@orcl as sysdba
OR
sys/anypassword@orcl as sysdba

After this I 've executed as follows:
>Shut Immediate

The DB is shut downed

But what is the usage of "Password" "which is created using ORAPWD" utility..
Without that same password(which is generated using ORAPWD utility..) also am able to connecting the server if I 've specified "as sysdba"

Problem might be what can u please explain..?

Thanks In Advance

[abhaysk]

can you connect to oralce with

Connect U10/anypass@orcl as sysdba?

[dba_giri]

Yes, am able to connect using the same..

[OracleDisected]

Hi,

That is an Oracle's big security hole, but there is a way you may close that door. Insert this line within sqlnet.ora ($ORACLE_HOME/network/admin)

SQLNET.AUTHENTICATION_SERVICES= (NONE)

[bang_dba]

Hi,

That is an Oracle's big security hole, but there is a way you may close that door. Insert this line within sqlnet.ora ($ORACLE_HOME/network/admin)

SQLNET.AUTHENTICATION_SERVICES= (NONE)

This holds good only in Windows server ??

[abhaysk]

Hi,

That is an Oracle's big security hole, but there is a way you may close that door. Insert this line within sqlnet.ora ($ORACLE_HOME/network/admin)

SQLNET.AUTHENTICATION_SERVICES= (NONE)

That applies only when connection is made through bequeth protocol, not in this case where he is trying to connect using TCP.