Useful tips to find the Sysdate Commands from Oracle Database by issuing SQL Queries Find the First Day of the Month SQL> SELECT TRUNC (SYSDATE, ‘MONTH’) FROM DUAL; TRUNC(SYS ——— 01-JAN-23 Find the Last Day of the Month SQL> SELECT TRUNC (LAST_DAY (SYSDATE)) FROM DUAL; TRUNC(LAS ——— 31-JAN-23 Find… Read more..

How to create the trigger for failed & success login attempt in Oracle Database Note: The below given trigger is created to attempt the success and failed login attempt of the all the user in Oracle database., Data will be recorded in the table as well as at the OS Level (directory loc). Verify the Read More

How to check the Failed Login Attempts in Oracle Database. Assume you or someone else has logged to the database with failed username & password. SQL> connect systest/alksflkagf ERROR: ORA-01017: invalid username/password; logon denied Lets try to find out the failed login attempt with time based Query to find the time based… Read more..

How to configure the memory target in Oracle Database Consider you are running the database with sga & pga configuration., if you need to change it to memroy target, fallow the below process. Check the status of database SQL> select instance_name, version, open_mode from V$database, v$instance; INSTANCE_NAME VERSION OPEN_MODE ———————————————- oemsw… Read more..

How to Exclude Specific Tablespace from the RMAN Backup in Oracle 11gR2 Check the database details SQL> select instance_name,version,open_mode from v$instance, v$database; INSTANCE_NAME VERSION OPEN_MODE —————- —————– ———– testdb1 11.2.0.4.0 READ WRITE Check the RMAN Configuration [oracle@testdb… Read more..

Move the datafile in standby database from one disk to another in Oracle 11gR2(11.2.0.4) Check the database status SQL> select version,instance_name,open_mode from V$database,v$instance; VERSION           INSTANCE_NAME    OPEN_MODE ——- —————- ——————– 11.2.0.4.0        teststd         MOUNTED Fallow… Read more..