This blog is very helpful to everyone, in this blog we have demo of how to move database from RDBMS server to ASM STORAGE.Very first we will take the full RMAN backup of Source database using below script code. On TargetAnd also copy the parameter file from source database to Target machine with all backups. … Read more
This page will showing how to check out the last login details into oracle database there are several view like SYS.AUD$ , SYS.AUDIT_ACTIONS with the help of that you can easily find out the last login session information. And also you can use the dba_audit_session view to check out the logon and logoff time of … Read more
Its very helpful for everyone to understand the RAC ADMINISTRATION COMMANDS in Oracle database. RAC stands for Real Application Cluster which help to manage the high availability of database in case of any disaster. There are some useful command which are using in daily routine to stop and start the services of RAC. Oracle Real … Read more
This page will help to everyone to Get metadata DDL details about any schema objects which include the (tables,packages,db_link)etc. DBMS_METADATA The DBMS_METADATA package provides a way for you to retrieve metadata from the database dictionary as XML or creation DDL and to submit the XML to re-create the object. Object Types are: TABLE DB_LINK TABLESPACE … Read more
This blog will help you to find out the user password expiration and changed details in brief. You can check out the when the user password is going to expire or need to change before expiration. You can find details about users which are created in Oracle. By running a query from a command prompt, … Read more
To Check Failed login attempts count in oracle database for security purpose. It helps you to identify the username and what action has been performed by it. There are some other details which you can check from DBA_AUDIT_SESSION view. To find invalid logins by users who has return error code=1017 in oracle database you can fire the … Read more
In this blog I am going to showing to everyone how we can easily check the whole database size in oracle using simple SQL queries there are different ways to calculates the database size and showing to user what is the exact size of db’s. In the first ways you can check the database size … Read more