| ORAPWD Utility [message #273576] |
Thu, 11 October 2007 00:25  |
dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad
|
Junior Member |
|
|
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
|
|
|
|
|
|
| Re: ORAPWD Utility [message #274080 is a reply to message #273576] |
Sat, 13 October 2007 09:30  |
Albaraha
Messages: 1
Registered: September 2006
|
Junior Member |
|
|
| dba_giri wrote on Thu, 11 October 2007 08:25 |
On my client machine
************************************
I 've connected using U10 user with following :
u10/u10@orcl as sysdba
|
You're connecting using the password file authentication here.
| Quote: |
sys/anypassword@orcl as sysdba
|
As I assume you're running sqlplus command as the user who created the database.
You're connecting here using the OS authentication here, since the user you created the database with in Windows is added to the ORA_DBA group by default. So any username and password you type followed by "as sysdba" will be ignored and it won't be checked, and you'll be authenticated as the user sys.
You can make sure with this example:
SQL> conn sysys/asasa as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> select username From v$pwfile_users; -- You can see here that the user sysys doesn't even exist
USERNAME
-----------
SYS
Remember that the authentication precedence is as follows:
- Operating system authentication.
- Password file authentication.
- Data dictionary authentication.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
