Bhom Apps DBA || AWS || OCI

 If you face an error like the following while performing “impdp” operations: Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production ORA-39006: internal error ORA-39065: unexpected master process exception in DISPATCH ORA-01001: invalid cursor ORA-06512: at "SYS.DBMS_METADATA_UTIL", line 3343 ORA-06512: at "SYS.KUPM$MCP", line 2636 ORA-39097: Data Pump job encountered unexpected error -1001 Solution: execute the following command: SQL> exec dbms_metadata_util.load_stylesheets; If the above query executes sucessfully then try the “impdp” command again. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.3.0.0.0 SQL> exec dbms_metadata_util.load_stylesheets; PL/SQL procedure successfully completed. SQL>

Issue :- [oracle@testserv1~]$ crontab -l You (oracle) are not allowed to access to (crontab) because of pam configuration. [oracle@testserv1~]$ When you will check the log file /var/log/cron you will be able to see the error in logfile. May 22 12:28:57 testserv1 crontab[48079]: (oracle) PAM ERROR (Authentication token is no longer valid; new one required) May 22 12:29:37 testserv1 crontab[48205]: (oracle) PAM ERROR (Authentication token is no longer valid; new one required) Solution :- There could be two reason for this error: 1. Expired password for the user. 2. User not allowed to cron in /etc/security/access.conf file. Check for expired user password.  1. First of all, check the password expiry for the user using chage command. [root@testserv1 ~]# chage -l oracle Last password change                                    : Feb 19, 2021 Password expires        ...