Hi Friends,
Welcome you back on exiting topic, Today’s session is on
Default locations:
$ORACLE_HOME/dbs/orapw$ORACLE_SID ---------------- Unix
%ORACLE_HOME%\database\PWD%ORACLE_SID%.ora ------- Windows
REMOTE_LOGIN_PASSWORDFILE= NONE/EXCLUSIVE/SHARED
orapwd:
$ orapwd file=password_file_name [password=the_password] [entries=n] [force=Y|N] [ignorecase=Y|N] [nosysdba=Y|N]
Examples
$ orapwd file=orapwSID password=sys_password force=y nosysdba=y
$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=secret
Conclusion:
1. Password file will be used for remote database login as admin user for administrator
2. enties what you mention while creating the password file is the maximum number of admins are allowed to login remotely as the same time.
3. You can grant the sysdba previlage to N-number of users irrespective of maximum entries mentioned in password file.
Please do follow me and support me on,
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/
Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter:https://twitter.com/mallik034
instagram:https://www.instagram.com/mallik034/