Welcome to the dbi services Blog! This blog focuses on IT infrastructure - featuring news, troubleshooting, and tips & tricks. It covers database, middleware, and OS technologies such as Oracle, Microsoft SQL Server, 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 the 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 has been used in the blog.
Bloggers
Bloggers Search for your favorite blogger from this site.

Posted by José Navarro on Thursday, 31 January 2013 in Database Administration & Monitoring

Hits: 576
1 Comment
Subscribe to this entry
Print
PDF

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.

Tagged in: Chopt Oracle 11g Oracle EE

Rate this blog entry:

Oracle Automatic Memory Management: real memory us...
Bug on Oracle 11.2 "ORION FAILS WITH ORA-27061": P...

How to handle mutex issues after migrating to Oracle 11.1 - Database Administration & Monitoring Dec 10
Getting rid of network acces issues after migrating to Oracle 11.2 - Database Administration & Monitoring Jan 27
How to avoid strange figures in the Oracle optimizer system statistics - Development & Performance Jan 03
Automatic Storage Management (ASM) : pourquoi pas ? - Storage, Virtualization & Cloud Dec 08
Génération de XML : le format des dates - Database Administration & Monitoring Jan 18

José Navarro

José-Maria Navarro is Principal Consultant 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, Data Warehouse features, Tuning aspects and high availability solutions (Oracle Data Guard). He is in charge of all core database topics at dbi services. José-Maria Navarro is Oracle Certified Professional 10g.

http://www.dbi-services.com