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
