Hi,
I got ” You (oracle) are not allowed to access to (crontab) because of pam configuration. ” error during crontab -l run.
You (oracle) are not allowed to access to (crontab) because of pam configuration
Details of error are as follows. When I try to drop database in mount mode, i got the following error.
[MSDB1]/home/oracle $ crontab -l You (oracle) are not allowed to access to (crontab) because of pam configuration See crontab(1) for more information [MSDB1]/home/oracle $
You (oracle) are not allowed to access to (crontab)
This error is related with the /etc/cron.allow file.
To solve this error you should add oracle or any other users that will use the Crontab into this file as follows.
[root@msdbadb01 home]# cat /etc/cron.allow root [root@msdbadb01 home]#
Add oracle user and save /etc/cron.allow
[root@msdbadb01 home]# vi /etc/cron.allow [root@msdbadb01 home]# cat /etc/cron.allow root oracle [root@msdbadb01 home]#
Now you can run the crontab -l command successfully as follows.
[MSDB1]/home/oracle $ crontab -l 00,15,30,45 * * * * sh /u01/app/oracle/admin/cron_jobs/clear_oracle_home.sh * * * * * /u01/app/oracle/admin/cron_jobs/alert_mail.sh > /u01/app/oracle/admin/cron_jobs/log/check_alertlog.txt
Or if above steps don’t solve your case, then check your user expire time. If your user is expired. If your case is like that, then do it like following. Set your user password again.
[root@msdbadm01 ~]# chage -l oracle Last password change : Aug 29, 2020 Password expires : Oct 28, 2020 Password inactive : never Account expires : never Minimum number of days between password change : 1 Maximum number of days between password change : 60 Number of days of warning before password expires : 7 [root@msdbadm01 ~]# [root@msdbadm01 ~]# [root@msdbadm01 ~]# [root@msdbadm01 ~]# passwd oracle Changing password for user oracle. New password: BAD PASSWORD: The password contains more than 4 characters of the same class consecutively Retype new password: passwd: all authentication tokens updated successfully. [root@msdbadm01 ~]# chage -l oracle Last password change : Nov 03, 2020 Password expires : Jan 02, 2021 Password inactive : never Account expires : never Minimum number of days between password change : 1 Maximum number of days between password change : 60 Number of days of warning before password expires : 7 [root@msdbadm01 ~]# su - oralce su: user oralce does not exist [root@msdbadm01 ~]# [root@msdbadm01 ~]# [root@msdbadm01 ~]# su - oracle Last login: Tue Nov 3 14:11:48 +03 2020 on pts/1 [oracle@msdbadm01 ~]$ [oracle@msdbadm01 ~]$ [oracle@msdbadm01 ~]$ crontab -l 00 23 * * * sh /home/oracle/RunDeleteArchive.sh >/home/oracle/Delete.log [oracle@msdbadm01 ~]$
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )