ASM files db wise
ASM files db wise to see all list of files in db column path format a70 column file_type format a15 select concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) path, system_created, alias_directory, file_type from (…
Read MoreManually create database 12c -NON CDB
We are going to see about manual database creation on oracle 12c nonCDB When we get the request to create a database on a Linux server. The basic prerequisite we…
Read MoreEXPDP Hangs at Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
We got a request to do a schema refresh, We prepared the parfile as below $cat DEV_SCHEMA.par directory=MY_DIR dumpfile=DEV_SCHEMA_%u.dmp logfile=DEV_SCHEMA.log SCHEMAS=DEV_SCHEMA1,DECSCHEMA01 estimate=statistics parallel=8 filesize=2G and ran in background as $ nohup…
Read MoreJSON_TABLE Query Fails with ORA-7445
Patch for JSON_TABLE Query Fails with ORA-7445 [__intel_ssse3_rep_memcpy] (Doc ID 2311377.1) Prerequisite : Install OCT Patch : Patch 28662603 – Database Oct 2018 Release Update 12.2.0.1.181016 Make sure Database and listener are…
Read Moreopatch prereq CheckConflictAgainstOHWithDetail Shows multiple HOME
When i got a request to apply a patch, i did a prereq check and faced the below error. RAM:oracle$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version…
Read More