| How to use Password file [message #72525] |
Fri, 11 July 2003 00:24  |
Haneef
Messages: 7
Registered: June 2003
|
Junior Member |
|
|
HI
I am facing some problem in Password file....in Oracle9i
suppose i want to create a database name is testdb.Before creating a database i have to create a service throught oradim. At the time of creating service i can provide a password.and this password belong to sys user.
suppose oradim -new -sid testdb -intpwd testdb -startmode a
now sys is having a password testdb
and if i write on dos prompt
c:sqlplus/nolog
now i can
sql>connect sys/testdb as sysdba
it will connect.This is fine..
Now if i try to implement password file.. here i m facing a problem..
c:orapwd file=C:oracleora90databaseorapwdtestdb.pwd password=oracle entries=3
suppose this is a statement..now question is this password belongs to which user?
I read some notes they are saying this is user SYS password. but if i want to connect through this password then system doesn't allow me to connect the database..then what is the use of this password file?
i have read some notes.. and they are saying if u set a parameter remote_login_password=Exclusive
after that if i u give a sysdba role to one user suppose user1 then this user's information i:e userid and password will automatically goes into this password file. and if u'r database is not open then authentication will be done from this password file.
Now question is where should i make this passwordfile.. is there any specific path?
Once if i give a sysdba role to any one system will allow me to connect as a sysdba without making password file..... then what is the use of this password file?
And i have try it but was not be able to implement it. i don't know where i am wrong?
I think i have explain it better manner..
Haneef
|
|
|
|
| Re: How to use Password file [message #72528 is a reply to message #72525] |
Fri, 11 July 2003 03:00  |
sachin kumar gupta
Messages: 157
Registered: March 2003
|
Senior Member |
|
|
Hi haneef,
First u should be clear that:
1) If u r using shared server mode, then set remote_login_password=Exclusive & other than sys users, multiusers can connect to the db on a single instance.
2) If u r using dedicated server mode, then set remote_login _password=shared & only sys user can be connected to MULTIPLE instance.
When using shared server mode, grant the users:
GRANT SYSDBA TO USER.
One more thing, password file is used only when no O.S. authentication is required.
Hope this helps u.
Regards,
Sachin
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
