| Tony |
Posted: Apr 03, 2007 07:35:32 AM |
Total Post: 26
Joined: Dec, 2006
|
How do you determine the number of entries to enter in the parameter 'entries' of the database file? Is it the number od admins to have or both the admins and the non-admins?
tonygys@yahoo.co.uk |
|
|
 Jayanta |
| Posted: Apr 03, 2007 01:31:20 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
u can set it for maximum users enjoying sysdba privs.
if in future it falls short, u may recreate the password file without any problem.cheers!
|
|
|
|
|
| Tina |
| Posted: Apr 03, 2007 02:33:43 PM | |
|
Total Post: 9
Joined: Apr, 2007
|
Hi Tony,
If entries = 2
then max 5 sysdba and sysopen users you can create. It works like
entries =2 meaning (2 entries for sysdba+ 2 entries for sysopen + 1 sysdba default entries)
for eg. if entries = 3 then (3 entries for sysdba + 3 entries for sysopen + 1 default for sys user = 7)
here suppose, entries = 2
1. scott user > privilages sysdba + sysoper (it is treated as single entry)
2. tins user > privilages sysdba (it is also treated as one entry)
I guess you are cleared now.
Thanks,
Tina K.
|
|
|
|
|
| Tina |
| Posted: Apr 03, 2007 02:35:25 PM | |
|
Total Post: 9
Joined: Apr, 2007
|
Tony,
One more matter to say, if your entriesar reached at deadline (i.e. entries=2, hence max user is 5), so if you want to create 6th dba user then you need to recreate the password file.
Thanks,
Tina K.
|
|
|
|
|
| mit |
| Posted: Apr 21, 2007 04:47:02 AM | |
|
Total Post: 48
Joined: Sep, 2006
|
Hi,
Please tell me where to create the password file?
because in windows it is already created in database directory
How to set values in it?
Please send me reply on my id mitameet@gmail.com
Thanx
AMIT
|
|
|
|
|
| Jayanta |
| Posted: Apr 21, 2007 05:46:07 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
that's the default destination for paswordfile. so dont worry.
cheers!
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
