Category Archives

Archive of posts published in the category: Oracle

Oracle Listeners

Let me first start by stating I am not a DBA and I am not an expert when it comes to Oracle.  I’ve messed around with Oracle for a few years now and I simply document these things to give you some guidance…

Oracle – Limit results within a group

I came across a situation where I need to run an Oracle query that would only show the first n number of records within a group.  Let me give you an example.  Consider a table that stores a list of transactions.  A customer…

Oracle SQL Loader – Tips and Tricks

Oracle SQL Loader is an excellent tool for loading a large amount of data into an Oracle Table based on a variety of different input formats.  This blog entry is simply a collective post from other entries on the web.  For my example,…

Install and Configure Oracle

This is a simple checklist that you may find useful for creating a database, connecting to the database via SQL Developer and adding a new schema user to load a set of tables to that user.  I’ve also include the SQL Plus command…

Oracle Export/Import

Please note for Oracle 11+, use the expdp and impdp utilities instead of exp and imp. Here are some very useful commands for performing an export and then an import of your Oracle database using the oracle exp and imp commands. This command…

Connecting to and Testing Oracle

Let me first start by saying, I am not an Oracle expert.  I learn what I need to in order to get things done.  I don’t go digging into learning Oracle proactively, frankly because I am not a huge fan of it, I…

ora-12638 credential retrieval failed

Check the sqlnet.ora file. Change the following entry and try, this will work. Original Entry – SQLNET.AUTHENTICATION_SERVICES= (NTS) Modified Entry – SQLNET.AUTHENTICATION_SERVICES= (NONE)

Categories