YouarepartoftheDBAteamworkingforaGRANTSYSDBATOjohn;However,youreceivethefollowingerror:ORA-01996:GRANTfailed:passwordfile’c:\oracle\ora9i\dbs\testdb.pwd’isfullWhichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers?()
YouarepartoftheDBAteamworkingforamultinationalbank.Theteamisresponsibleforperformingadministrativetasksonthedatabaseserverlocatedatthehomeoffice.ThedatabaseserveratthehomeofficehasaproductiondatabaseandatestdatabasenamedTESTDB.Thetestdatabaseisprimarilyusedfortestingdatabasecommandsandconfigurationsettingsbeforimplementingthesesettingsontheproductiondatabase.Thetestdatabaseisalsousedforthedevelopmentofdatabaseapplications.YouhavebeenaskedbytheseniorDBAtogranttheSYSDBAprivilegetoanewteammember,John,sothathecanperformsomeadministrativetasks,suchasshutdownandstartupoperations,onTESTDB.YouusethepasswordfiletoconfigureremoteauthenticationontheTESTDBdatabase.Youexecutethefollowingstatementtograntthe SYSDBAprivilegetoJohn:
SQL>GRANTSYSDBATOjohn;
However,youreceivethefollowingerror:
ORA-01996:GRANTfailed:passwordfile
’c:\oracle\ora9i\dbs\testdb.pwd’isfull
Whichactionshouldyoutaketoaddtheuserjohntothepasswordfilewithoutremovinganyoftheexistingusers?()