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.

[[email protected] home]# cat /etc/cron.allow
root
[[email protected] home]#

 

 

Add oracle user and save /etc/cron.allow

[[email protected] home]# vi /etc/cron.allow

[[email protected] home]# cat /etc/cron.allow
root
oracle
[[email protected] 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.

[[email protected] ~]# 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
[[email protected] ~]# 
[[email protected] ~]# 
[[email protected] ~]# 
[[email protected] ~]# 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.
[[email protected] ~]# 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
[[email protected] ~]# su - oralce
su: user oralce does not exist
[[email protected] ~]# 
[[email protected] ~]# 
[[email protected] ~]# su - oracle
Last login: Tue Nov 3 14:11:48 +03 2020 on pts/1
[[email protected] ~]$ 
[[email protected] ~]$ 
[[email protected] ~]$ crontab -l
00 23 * * * sh /home/oracle/RunDeleteArchive.sh >/home/oracle/Delete.log
[[email protected] ~]$

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 783 views last month,  3 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Do NOT follow this link or you will be banned from the site!