password file and more [message #57439] |
Mon, 16 June 2003 06:55 |
freewill
Messages: 16 Registered: October 2002
|
Junior Member |
|
|
hi all!
i am preparing for my ocp exam,now i have some questions .
the first is about password file .i created two db on my win2000 server with dbca,the dbca also created two password file for the two db respectively ,and the remote_login_passwordfile parameter is set to "exclusive" by default.now i want the two db shared a password file,i can create one with orapwd ,but after i modify the remote_login_passwordfile parameter ,how can i assign it to both of the databases?
furthermore,i can use " connect system/password@ora9i as sysdba",but when i excuted "select * from v$pwfile_users",i got only one user--sys.the "system" user have "sysdba" privilege,but it wasn't included in the password file ,why?after i connected as sys ,and excuted " grant sysdba to system ",it was then included in the password file.
the second question is ,why the name of my initial parameter file under the %oracle_home%/admin/sid/pfile directory is something like "init.ora.4132003132529",not initSID.ora?
by the way ,my oracle is oracle9i R2.
best regards!
|
|
|