Oracle Consulting and Training
For Better, Faster, Smarter
Oracle Training To Help Make Your Systems Better, Faster
For more valuable Oracle tips and tricks just subscribe to our ezine and every month we'll send you some
tips and tricks to help you make your Oracle systems better, faster and smarter.
Running multiple Oracle instances
Running an executable from a PL/SQL trigger
Is Oracle certification worthwhile?
See the resources page for recommended books for as
well as links to the Oracle documentation and useful
sites. See here for more Oracle tips and tricks.
From: Sandeep Singh I am new on Oracle . I want
to run two instance of one oracle database server
on single machine. I already install oracle. I create
one database named sandb and instance for that. I
want one more instance for the same database on
same machine. Please give the process for doing
It is possible to have more than 1 instance on a single
machine but unless you're using Real Application
Cluster, they won't share the same database. With the
Oracle software already installed, use the Database
Configuration Assistant to create another database and instance,
From: Sean Talbot: Hi, I need to run an executable from an Oracle Trigger, but can find no docs
on on how to do this - please help! Thanks in advance
We don't know of anyway to run a program directly from a trigger. However, you can call "external
procedures" from pl/sql and therefore from a trigger. An external procedure in this context is a shared
library (e.g. ".DLL" on MS Windows) as opposed to an executable.
There are a number of steps that have to be taken to be able to call an external procedure from your
Set up the listener for external procedures - this must be called
EXTERNAL_PROCEDURE_LISTENER and is separate from the other listeners so will need to be
added to the database start-up and shut-down scripts if you intend to use this feature on a regular
Build the shared library file (may contain more than one external procedure) for your o/s
Ensure Oracle knows where to find the library by issuing the CREATE LIBRARY command in
SQL*Plus and specifying the full path to the library file (e.g. CREATE LIBRARY ext_lib AS
'C:\WINDOWS\system32\extprocs.dll'). You need to do this once for each library you
intend to use, as opposed to once for each external procedure you wish to call.
Write your pl/sql wrapper to call the external procedure. This comprises the pl/sql function or
procedure header for the body with the rest of the body replaced by the external procedure interface
definition. For example: CREATE OR REPLACE PROCEDURE extproc1 (p1
PLS_INTEGER) IS EXTERNAL LIBRARY ext_lib NAME "an_ext_proc"
LANGUAGE C PARAMETERS (p1 int)
Call your pl/sql wrapper procedure from your trigger or other pl/sql routines in the same way you
would call any other pl/sql procedure or function (e.g. extproc1(400) ).
For more details see the resources page for links to relevant material on OTN.
From: K I Vijoy, I am a software professional working in java for developing web based
applications for a US Based company here in india. I would like to know whether taking a Oracle
DBA certification would brighten my career prospects or not. Kindly throw some light on this
matter so that i can pursue the certification course as soon as possible. Thanks, Vijoy
Oracle Certifications are one of the most sought after marques of credibility for expertise in the
Information Technology marketplace, according to Oracle and Tom’s IT Pro lists OCP as the best database
certification in 2014. However this is something you really have to be sure of due to the time and expense
involved in acquiring certification. See our Oracle Certification Demystified article for details of the
certification process and Oracle Certification Benefits for a discussion of the pros and cons.
Looking to sky-rocket productivity, save time and reduce costs?
Training is a highly cost-effective and proven method of boosting productivity. Smartsoft offers instructor-
led training in Oracle and related technologies on or off site in cities across the UK as well as self-study
online training. See our scheduled Oracle training courses, or let us know your requirements.
Oracle tips and tricks
Subscribe to our newsletter, jam-packed full of tips and tricks to help you slash costs, sky-rocket productivity and make
your systems better, faster and smarter.
© Smartsoft Computing Ltd, Bristol, England Tel: 0117 924 7646
Need help? Contact Us
This site uses woopra.com to gather statistical information about our visitors. This data is aggregated to show industry
trends (such as browser share). However, this data shall be the average of many thousands of visits and is in no way
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their