This discussion is archived
9 Replies Latest reply: Apr 4, 2013 7:48 AM by Paul Horth RSS

Enable partition feature in oracle 11g

user520824 Newbie
Currently Being Moderated
we have 11g and the DB has not installed the partitiong, how do we install this feature in 11g?
SQL> select * from v$option;

PARAMETER                                                        VALUE
---------------------------------------------------------------- -------------------------------
Partitioning                                                     FALSE
  • 1. Re: Enable partition feature in oracle 11g
    Solomon Yakobson Guru
    Currently Being Moderated
    Did you purchase it? Partitioning comes with EE (enterprise edition) as an option on top of enterprise edition, not with SE (standard edition) or XE (express edition).

    SY.

    Edited by: Solomon Yakobson on Jul 13, 2010 9:21 AM
  • 2. Re: Enable partition feature in oracle 11g
    user520824 Newbie
    Currently Being Moderated
    Yes, we have the license and using enterprise..
  • 3. Re: Enable partition feature in oracle 11g
    Solomon Yakobson Guru
    Currently Being Moderated
    user520824 wrote:
    Yes, we have the license and using enterprise..
    So what prevents you from installing it?

    SY.
  • 4. Re: Enable partition feature in oracle 11g
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl see these MOS Docs

    1069015.1 - How to determine enabled/disabled components in an 11.2 software-only installation
    942406.1 - Customize Enterprise Edition Options under 11.2.0.1 version

    HTH
    Srini
  • 5. Re: Enable partition feature in oracle 11g
    rrp Newbie
    Currently Being Moderated
    This is a bit late for the original poster, but maybe by adding it here it will of use to someone else in the future.

    There are many database options that are linked in with the oracle kernel when it is installed.

    This happens by default when you pick the Enterprise Edition.

    If you choose not to install them you cannot just add them with dbca, you must re-link the kernel.

    These were the instructions I got for adding in the partitioning option.
    shutdown
    $ cd $ORACLE_HOME/rdbms/lib
    $ make -f ins_rdbms.mk part_on
    $ make -f ins_rdbms.mk ioracle
    restart

    /rrp
  • 6. Re: Enable partition feature in oracle 11g
    655665 Newbie
    Currently Being Moderated
    10 out of 10 for this rrp.

    I was installing Oracle 11g Grid Control, and got the (apparently not uncommon) prompt that partitioning was not installed. I ran your 'make' commands, and looks fine now, resulting in me not having to uninstall / re-install.

    Good man!
  • 7. Re: Enable partition feature in oracle 11g
    873098 Newbie
    Currently Being Moderated
    Hi Guys,

    I have the same issue (partioning feature not enabled) and as per rrp's suggestion,

    I executed the make commands by logging with oracle user in unix and here are my output

    [oracle@oretail lib]$ make -f ins_rdbms.mk part_on
    /usr/bin/ar cr /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/libknlopt.a /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/kkpoban.o
    [oracle@oretail lib]$ make -f ins_rdbms.mk ioracle
    chmod 755 /apps/oracle/app/oracle/product/11.1.0/db_2/bin

    - Linking Oracle
    rm -f /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/oracle
    gcc -o /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/oracle -L/apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/ -L/apps/oracle/app/oracle/product/11.1.0/db_2/lib/ -L/apps/oracle/app/oracle/product/11.1.0/db_2/lib/stubs/ -Wl,-E /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/opimai.o /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/ssoraed.o /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/ttcsoi.o -Wl,--whole-archive -lperfsrv11 -Wl,--no-whole-archive /apps/oracle/app/oracle/product/11.1.0/db_2/lib/nautab.o /apps/oracle/app/oracle/product/11.1.0/db_2/lib/naeet.o /apps/oracle/app/oracle/product/11.1.0/db_2/lib/naect.o /apps/oracle/app/oracle/product/11.1.0/db_2/lib/naedhs.o /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/config.o -lserver11 -lodm11 -lsage11 -lnnet11 -lskgxp11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 -lknlopt `if /usr/bin/ar tv /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/libknlopt.a | grep xsyeolap.o > /dev/null 2>&1 ; then echo "-loraolap11" ; fi` -lslax11 -lpls11 -lrt -lplp11 -lserver11 -lclient11 -lvsn11 -lcommon11 -lgeneric11 `if [ -f /apps/oracle/app/oracle/product/11.1.0/db_2/lib/libavserver11.a ] ; then echo "-lavserver11" ; else echo "-lavstub11"; fi` `if [ -f /apps/oracle/app/oracle/product/11.1.0/db_2/lib/libavclient11.a ] ; then echo "-lavclient11" ; fi` -lknlopt -lslax11 -lpls11 -lrt -lplp11 -ljavavm11 -lserver11 -lwwg `cat /apps/oracle/app/oracle/product/11.1.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /apps/oracle/app/oracle/product/11.1.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lztkg11 `cat /apps/oracle/app/oracle/product/11.1.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /apps/oracle/app/oracle/product/11.1.0/db_2/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `if /usr/bin/ar tv /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/libknlopt.a | grep "kxmnsd.o" > /dev/null 2>&1 ; then echo " " ; else echo "-lordsdo11"; fi` -L/apps/oracle/app/oracle/product/11.1.0/db_2/ctx/lib/ -lctxc11 -lctx11 -lzx11 -lgx11 -lctx11 -lzx11 -lgx11 -lordimt11 -lclsra11 -ldbcfg11 -lhasgen11 -lcore11 -lskgxn2 -locr11 -locrb11 -locrutl11 -lhasgen11 -lcore11 -lskgxn2 -loraz -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lsnls11 -lunls11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -laio `cat /apps/oracle/app/oracle/product/11.1.0/db_2/lib/sysliblist` -Wl,-rpath,/apps/oracle/app/oracle/product/11.1.0/db_2/lib -lm `cat /apps/oracle/app/oracle/product/11.1.0/db_2/lib/sysliblist` -ldl -lm -L/apps/oracle/app/oracle/product/11.1.0/db_2/lib
    test ! -f /apps/oracle/app/oracle/product/11.1.0/db_2/bin/oracle ||\
    mv -f /apps/oracle/app/oracle/product/11.1.0/db_2/bin/oracle /apps/oracle/app/oracle/product/11.1.0/db_2/bin/oracleO
    mv /apps/oracle/app/oracle/product/11.1.0/db_2/rdbms/lib/oracle /apps/oracle/app/oracle/product/11.1.0/db_2/bin/oracle
    chmod 6751 /apps/oracle/app/oracle/product/11.1.0/db_2/bin/oracle
    [oracle@oretail lib]$

    and I restarted the DB but it doesnt solve the problem.. pls advice.
  • 8. Re: Enable partition feature in oracle 11g
    LANCERIQUE Newbie
    Currently Being Moderated
    Thanks a lot..


    Your post saved my day..

    Regards,
    Nikhil Mehta.
  • 9. Re: Enable partition feature in oracle 11g
    Paul Horth Expert
    Currently Being Moderated
    LANCERIQUE wrote:
    Thanks a lot..


    Your post saved my day..

    Regards,
    Nikhil Mehta.
    Don't reply to 2 year old posts.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points