Blog - comments

Hi goog article can we install avdf firewall with flat network if it's possible please let me know ?

Thilina
First, thank you for your interrest in this blog.Yes, the byte code will be interpreted each time bu...
BIEHLER Stephane
Pretty sure this is wrong:> already said that JVMs interprets the generated byte code - that's true...
Gs
Michael, great article, however, I would disagree on DRS/Host Affinity. You are legally only requir...
David Bradshaw
Hi lauri, db_file_multiblock_read_count is still used in exadata smartscan because it defines the si...
Blog Yann Neuhaus Configuration des options en Oracle 11g EE avec 'chopt'

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.

Configuration des options en Oracle 11g EE avec 'chopt'

La configuration des options sous Entreprise Edition avant Oracle 11g pouvait être un véritable parcours du combattant. Donc, une attention particulière devait avoir lieu avant l'installation des binaires Oracle; à savoir quelles options devaient être installées! Depuis la version 11g, les choses ont bien changé, grâce à l'utilitaire "chopt" se trouvant sous $ORACLE_HOME/bin.

 

Voici la syntaxe d'utilisation de "chopt":

chopt [enable |disable] db_option

db_option:

  • dm = Oracle Data Mining
  • dv = Oracle Database Vault
  • lbac = Oracle Label Security
  • olap = Oracle OLAP
  • partitioning = Oracle Partitionin
  • rat = Oracle Real Application Testing
  • ode_net = Oracle Database Extensions for .NET 1.x
  • ode_net_2 = Oracle Database Extensions for .NET 2.0


Voici un exemple d'utilisation de "chopt":

  • Activation du data mining:

 

oracle@SORCQ01:/u00/app/oracle/product/11.2.0/db_1\bin\ [dbq1] chopt enable dmWriting to /u00/app/oracle/product/11.2.0/db_1/install/enable_dm.log...
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk dm_on ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
ld: 0711-224 WARNING: Duplicate symbol: fc_softc
ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libgeneric11.a[sdbgrfu.o], imported symbol timezone
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdowd.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdidx.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcr.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcnc.o], imported symbol mdrcnccmt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 208456    Maximum size: 65536
        Extra instructions are being generated for each reference to a TOC
        symbol if the symbol is in the TOC overflow area.

 

  • Vérification de la bannière:

 

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 10 14:00:01 2012Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With Data Mining options

 

  • Désactivation du data mining:

 

oracle@SORCQ01:/u00/app/oracle/product/11.2.0/db_1\bin\ [dbq1] chopt disable dmWriting to /u00/app/oracle/product/11.2.0/db_1/install/disable_dm.log...
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk dm_off ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
/usr/ccs/bin/make -f /u00/app/oracle/product/11.2.0/db_1/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1
ld: 0711-224 WARNING: Duplicate symbol: fc_softc
ld: 0711-224 WARNING: Duplicate symbol: __fe_def_env
ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libgeneric11.a[sdbgrfu.o], imported symbol timezone
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdowd.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdidx.o], imported symbol ksudbrmseccnt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcr.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrt.o], imported symbol kcbstdbz_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-773 WARNING: Object /u00/app/oracle/product/11.2.0/db_1/lib//libordsdo11.a[mdrcnc.o], imported symbol mdrcnccmt_
        Symbol was expected to be local. Extra instructions
        are being generated to reference the symbol.
ld: 0711-783 WARNING: TOC overflow. TOC size: 208456    Maximum size: 65536
        Extra instructions are being generated for each reference to a TOC
        symbol if the symbol is in the TOC overflow area.

 

  • Vérification de la bannière:

 

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 10 14:04:05 2012Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

 

Il est donc bien plus facile d'ajouter ou d'enlever des options avec la version Oracle 11g via "chopt". De plus, il n'est pas nécesssaire de lancer un arrêt de la base. C'est très pratique.

Rate this blog entry:
1

Yann Neuhaus is Chief Executive Officer (CEO) and Region Manager at dbi services. He has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies, cluster computing and high availability solutions (Oracle Real Application Clusters RAC, Oracle Data Guard, and Oracle Clusterware). His expertise also includes Oracle Grid Control as well as several open source solutions (MySQL, Unix/Linux, etc.). Yann Neuhaus is Oracle Certified Expert (OCE) Cluster 11g, Oracle RAC Certified Expert, MySQL 5.0 DBA certified, and Red Hat Certified Engineer. Prior to joining dbi services, Yann Neuhaus was Principal Consultant at Trivadis in Basel, where he was also responsible for the delivery and quality management of large infrastructure projects. He also worked as IT Database / Network Administrator for IFS France. Yann Neuhaus holds an Engineer's Degree in Computer Science from the University of Technology of Belfort-Montbéliard (F) as well as a Master in Business Engineering of the EM Strasbourg Business School (F). His branch-related experience covers Financial Services / Banking, Chemicals & Pharmaceuticals, Transport & Logistics, Retail, Food, etc.

Comments

  • Guest
    Claudio Wednesday, 27 March 2013

    Merci pour l'astuce. J'ai pu valider "chopt", c'est pratique.

Leave your comment

Guest Wednesday, 22 October 2014
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)

Contact

Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter