Oracle Training To Help Make Your

Systems Better, Faster and Smarter

For more valuable Oracle tips and tricks just subscribe to our ezine.

Contents

• Running multiple Oracle instances • Running an executable from a PL/SQL trigger • Is Oracle certification worthwhile? See the Oracle resources page for recommended books for as well as links to 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. How can I do this? It is possible to have more than 1 Oracle 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 PL/SQL: 1. 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 basis. 2. Build the shared library file (may contain more than one external procedure) for your o/s 3. 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. 4. 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) 5. 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) ). See the Oracle 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 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 linked to individuals. View woopra privacy policy. View Smartsoft privacy policy Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.