Posts

Showing posts with the label 12c

oracle 12c sqlldr error in windows oranfsodm12.dll missing

Image
We Installed oracle 12c client in windows 12 R2. sqlplus is wokring fine but sqlldr is failing with error  "oranfsodm12.dll is missing from your computer". Error screenshot: Solution: Make a copy of the oraodm12.dll in the bin directory and rename it to oranfsodm12.dll .

Patching using Datapatch from 12c

From 12c on wards we don’t need to run Patching post  installation scripts  postinstall.sql  &  @catbundle.sql psu apply   and validate log files manually .. All we need to do is just run   datapatch   after applying patch. ****************************** *********************** In 11G  After applying patch we need to run like following order .. postinstall.sql    =>  for OJVM in upgrade mode @catbundle.sql psu apply  =>  for PSU in normal startup mode ****************************** *********************** But from 12c datapatch will take care of post scripts work. ./datapatch –verbose Please see log for datapatch. [oracle@s24-oratl15  OPatch ]$  ./datapatch -verbose SQL Patching tool version 12.1.0.2.0 on Tue May  3 01:50:33 2016 Copyright (c) 2015, Oracle.  All rights reserved. Log file for this invocation: /u01/app/oracle/base/ cfgtoo...