Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Creating a shared library in AIX for Oracle to use

Posted on 2004-09-08
5
721 Views
Last Modified: 2008-02-01
A while back I wrote some code in C for Windows NT. I compiled this code in NT and created a dll. Then I was able to invoke this dll through PL/SQL after creating a user library in Oracle. This code consists of 2 cpp files and 2 header files. I have to link this code to an external library.

Now I need to take this code and compile it in AIX. I looked at the Oracle makefiles that they suggest we use for compiling . I guess in AIX the equivalent of a Windows NT dll is a shared library. How can I modify the Oracle provided makefiles to create my shared library? Where in the makefiles do I include my external library that I need to link my code to? In addition I need to add a path where my include files reside. Where do I do this?

Thanks
Silvia
0
Comment
Question by:SilviaMacke
5 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 250 total points
ID: 12006482
AIX handles shared libraries a bit differently than many other UNIX platforms. If the "shr.o" object exists in a library, then that library will be dynamically linked at run time.  
 
To check if a library includes the "shr.o" object do the following:  
 
1. Change locations to the "lib" directory  
 
     % cd $ORACLE_HOME/lib  
 
2. Verify that the "shr.o" object exists  
 
     % /usr/ccs/bin/nm <library_name>|grep shr.o  
 
     For example:  
 
          % /usr/ccs/bin/nm libclntsh.a|grep shr.o  
          libclntsh.a[shr.o]:  
 
3. Check to see if an executable has been linked with a shared library  
 
     % /usr/sbin/dump -Hv <executable>  
 
     For example, here is the output from the svrmgrl executable in 8.0.4:  
 
     % cd $ORACLE_HOME/bin  
     % /usr/sbin/dump -Hv svrmgrl  
 
     svrmgrl:  
 
             ***Loader Section***  
                 =           Loader Header Information  
     VERSION#         #SYMtableENT     #RELOCent        LENidSTR  
     0x00000001       0x000000d2       0x00002709       0x000000b3  
 
     #IMPfilID        OFFidSTR         LENstrTBL        OFFstrTBL  
     0x00000006       0x0001e83c       0x000003c0       0x0001e8ef  
 
 
                        ***Import File Strings***  
     INDEX  PATH  BASE                MEMBER  
     0  
/u01/app/oracle/product/8.0.4/lib/:/u01/app/oracle/product/8.0.4/rdbms/li  
     b:/usr/lib:/lib  
     1                      libc_r.a         shr.o  
     2                      libpthreads.a       shr.o  
     3       libc_r.a            aio.o  
     4                      libodm.a            shr.o  
     5                      libclntsh.a         shr.o  
 
   
     NOTE:  "libclntsh.a" (BASE) contains "shr.o" (MEMBER), and  
            therefore is a dynamically linked library.  At run time,  
            the path specified in INDEX 0 will be searched for the  
            "libclntsh.a" library, and if not found, it will then  
            check the environment variable LIBPATH for its location.  
 
   
AIX dynamically linked libraries may contain an ".so" or ".a" extension.  The  
existence of the shared object (shr.o) in the library determines whether it is  
dynamically or statically linked.

0
 

Author Comment

by:SilviaMacke
ID: 12006536
That sounds good, however it does not answer my question.

I have two source files: test1.cpp
                                   test2.cpp
Two header files: test1.h
                          test2.h

The file test1.cpp contains definition a class and its functions
The file test2.cpp instantiates the class from test1.cpp and it creates the functions that I want to export.

When compiling the source code, I need to link this code to another library and inlcude a path.
How do I do this ? Can I use the Oracle make files?

I need to compile this as a Unix Shared Library
0
 
LVL 22

Assisted Solution

by:earth man2
earth man2 earned 250 total points
ID: 12006928
can you use $ORACLE_HOME/rdbms/demo/demo_rdbms.mk extproc_no_context | extproc_with_context
or extproc_nocallback and extproc_callback
#    A single external procedure demo whose 3GL routines do not use the
#    "with context" argument:
#
#    make -f demo_rdbms.mk extproc_no_context SHARED_LIBNAME=libname
#                                             OBJS="demo.o ..."
mo1.o epdemo2.o"
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle RAC 12c 8 87
sort a spool into file output in oracle 1 44
how to trim oracle sql sentence in unix 17 58
Oracle Query - Return results based on minimum value 8 35
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question