Monthly Archives: February 2014

ORA-12518: TNS:listener could not hand off client connection

Today in a multiple instance server i configured a new instance on Windows platform and  i encounter next problem when i try connect from my laptop:

sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 – Production on Sun Aug 26 09:21:56 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-12518: TNS:listener could not hand off client connection.

Continue reading

70 things that you should know to become a Oracle DBA

This post contains 70 concepts that you should learn and become knowledgeable to be confident on performing your Job as a New DBA.

As a beginner, you know, in internet u will find lot of websites giving excellent information about different concepts, but like newbe u maybe  get litle confused by looking at the huge amount of information.

Continue reading

Insert an Image File into Oracle Database

Pictures are very easy to add to a Oracle Table. We have two ways to loading BLOBs and CLOBs into tables.

One using PL/SQL and DBMS_LOB package and the BFILE datatype to transfer external LOB files into the database
internal LOB structures.
Second uses OCI (Oracle Call Interface) to success same objetive. Here we will use DBMS_LOB package.

Continue reading

Basic to know about ORACLE

We suposse you have interest in Oracle and databases in general, but, how succeeding as a DBA? this are some suggestions.

There is no easy way to achive this, requires spend lot of time reading and practice, dba carrer is about read lots of documentation, understand documented concepts, and apply them to real-world tasks.

Continue reading