Tags » Database

Applying Oracle Critical Patch Update of April 2017 on Oracle

1) Finding Current Opatch Version.

$ /ora00/app/grid/product/12.1.0/OPatch/opatch version
OPatch Version:

OPatch succeeded.

2) Download Updated Opatch patch from Oracle Metalink.

TESTING:oracle $ cd patchopatch/
TESTING:oracle $ ls
p21142429_121010_Linux-x86-64.zip… 491 more words

Working with DACPACs

First, lets outline what a DACPAC is.  According to Microsoft:

“A data-tier application (DAC) is a logical database management entity that defines all of the SQL Server objects – like tables, views, and instance objects, including logins – associated with a user’s database. 302 more words


mssqlsystemresource - The database you may have never seen.

When I blog, it tends to be due to me having done something at work and thinking it may be useful, primarily for me to make a note of what I did somewhere but also because this might help someone else.  184 more words


Multiple Inline Constraints

SQL New Blogger:

Time to investigate: 10 mins 
Time to test: 10 mins
Time to write: 10 mins

While creating a script for some new tables I came across a few columns that were designated to have both… 228 more words


ORA-39212 ORA-39213 Metadata processing is not available

While running import datapump following errors are seen,

$ impdp parfile=imp.par

Import: Release - Production on Tue Jun 27 13:02:53 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  140 more words

Importing Data into PowerPivot Part 1

Jumpstart your PowerPivot knowledge with this post. This Excel add-on can do some serious heavy lifting when it comes to crunching data. Here is an easy way to practice using PowerPivot with a free large dataset. 782 more words

NLS_LANG, character sets & more - How to do it right


Globalization is confusing. Everyone and everything is using different characters in different charcter sets. Oracle is prepared for that and offers several parameters and variables to control the behaviour. 845 more words