This sql script provide you the logfile group, member, path and file size details for a Oracle database.
SQL Query
set pagesize 30 linesize 100 column member format a60 column status format a10 column size_MB format '999,999'
SQL Script to Check Oracle Logfile Size, Status and Location
Database Creation using dbca failed with Oracle Net Services configuration failed. The exit code is 1
Error Description:
Database creation using dbca utility failed with following error.
netca command failed with ProfileException: Could not create Profile: TNS-04414: File error
Error Description:
Oracle netca command failed with following error.
Oracle netca command failed with following error.
ProfileException: Could not create Profile: TNS-04414: File error
Oracle Net Services configuration failed. The exit code is 1
India Driving License Renewal New Process Through sarathi.parivahan.gov.in/ Portal
There is a change in the driving license renewal process in all the states in India. It is became the common portal for all the states. Earlier there were individual portal for different states.
Scripts to Check RMAN Backup Status and Progress
In this post I wanted to give 2 SQL scripts to check the Oracle RMAN backup status.
Datapump expdp impdp New Feature – Print Content of Parfile to Logfile
From Oracle 12.2 release onwards, when you use the parfile option to expdp or impdp it will write the content of the parfile to the logfile in below format.
Connect to Oracle Database Running in Linux
Step 1. Identify the database running in the server
[oracle@TESTBOX exp]$ ps -ef|grep pmon|grep -v grep oracle 25167 1 0 Jul18 ? 00:00:10 ora_pmon_cdb
Script to Check ASM Disk Usage Details
This script provides you ASM disk usage details for the ASM database.
SQL Query
Execute Oracle SQLs from Linux Command Prompt and Exit
Method 1
Execute single SQL command from the prompt
Command to List the Oracle Databases Running on Linux Server
Generally we use ps -ef|grep pmon command to list the databases running on the database server.
In this post I am going to mention
Commands to Delete Old Aged Oracle Trace Files(.trc, .trm) and Audit(.aud) Files
In this post I am going to explain the command to delete old trace, Audit files. You have to periodically clean up these trace, audit file locations to avoid the file system get filled with files.
Create Restore and Drop Oracle Restore Point - Types and Benefits
Restore Point
It is a name associated with the SCN in the database. Using this restore point we can revert to the SCN which is pointing to the restore point even if you make some changes to the database.
RMAN: Dropped Table Recovery
In this post I am going to demonstrate the table recovery using RMAN. There are chances to drop tables accidentally by developer. In this cases DBA asked to recovery the dropped table from the backup.
Script to Analyze All Schema Tables and Indexes in Oracle Database
This script to generate the script to analyze all the tables in the specified schema(s)
Method 1.
Using dbms_stats
SQL to Set Tablespace Quota for Oracle User
Create a tablespace - USER_DATA
create tablespace user_data datafile '/u02/oradata/CDB/user_data_01.dbf' size 500m;
