Site icon IT Tutorial

You (oracle) are not allowed to access to (crontab) because of pam configuration

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 )

Exit mobile version