Below Shell Script will append Date to all FileNames in Directory with extension .TXT. Also it will create a folder…
Tag Change
There are scenarios where you cannot login to SQL*PLUS even with SYSDBA credentials to restart a hanged database. There is…
Today on one of our 10g (10.2.0.1, don’t ask !) production databases running on AIX 5.3 we saw the following…
What to do when a production database goes hanging and there is no time left and your boss is standing…
Change OEM SYSMAN password Incase you have forgotten the sysman password 1. Login to Cloud Control 12c database SQL> alter…
NLS_DATE_FORMAT is a parameter heavily dependent on a session. A good practice is to write a logon trigger depending on the application…