如何确定Oracle软件中是否安装了RAC选项

1. 首先切换到 $ORACLE_HOME/rdbms/lib目录

2. 运行以下命令:
    nm -r libknlopt.a | grep -c kcsm.o

若以上命令返回0,则rac选项未安装,也就是有一部分2进制文件未链接。若返回值大于0,则安装了rac选项。

若希望在不重新安装的前提下启用rac选项,可以如下操作:

在登陆所有节点,并关闭所有实例,以NORMAL或IMMEDIATE方式均可。

停止其他一切资源(包括监听器,ASM实例等)

切换到$ORACLE_HOME/lib目录:

运行命令: make -f ins_rdbms.mk rac_on

附  ins_rdbms.mk 文件

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Comments

  1. How to Check and Enable/Disable Oracle Binary Options

    Applies to:

    Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 11.2.0.2 – Release: 10.2 to 11.2
    Other UNIX

    Goal

    The goal of this article is 2 parts:

    1. Verify if a given option is turned on or not
    2. Enable/Disable given options

    This applies to the following options:

    • RAC (Real Appliction Cluster)
    • RAT (Real Application Testing)
    • OLS (Oracle Label Security)
    • DV (Database Vault)

    Last, some unusual items to be aware of

    • ASM (Automated Storage Management)
    • OLAP (Oracle OLAP)
    • PART (Oracle Partitioning)
    • CTX (Context Management Text)

    Solution

    Before you can verify options and/or enable/disable them, you will need to:

    cd $ORACLE_HOME/rdbms/lib

    and run either or both of the following commands:

    ar -t libknlopt.a | grep -c {file}

    where {file} is  => OPTION – file

    • RAC – kcsm.o
    • RAT – kecwr.o
    • OLS – kzlibac.o
    • DV – kzvidv.o
    • ASM – kfon.o
    • OLAP – xsyeolap.o
    • PART – kkpoban.o
    • CTX – kciwcx.o

    An example

    ar -t libknlopt.a | grep -c kcsm.o

    would return 0 if RAC is disabled or a number >0 if enabled

     

    The ar command does not work on IBM AIX

     

    To enable or disable options, please look at the following commands:

    make -f ins_rdbms.mk {option}

    where {option} is => OPTION – {option on} / {option off }

    • RAC – rac_on / rac_off
    • RAT – rat_on / rat_off
    • OLS – lbac_on / lbac_off
    • DV – dv_on / dv_off
    • ASM – asm_on / asm_off
    • OLAP – olap_on / olap_off
    • PART – part_on / part_off
    • CTX – ctx_on / ctx_off

    An example

    make -f ins_rdbms.mk asm_on

     would enable ASM option

    Unusual Items to be Aware Of

    The V$OPTION is unchanged and you will need to refer to other documentation to change it in order to complete the changes to the options. This include but not limited to running sql scripts which changes the DB Catalog.

    Lastly, the Oracle binary will need to be recompiled

     

    $ make -f rdbms/lib/ins_rdbms.mk ioracle

     

    Additional information is the chopt utility

     

    This note can be made applicable for all platforms by adopting the chopt utility. 

    Besides working on Windows platforms, another useful feature is the fact that on UNIX/Linux platforms, it neatly displays the commands that need to be executed:

    [celcaix3]/grdbms/64bit/patchdb/app/oracle/product/p11201b/rdbms/lib> chopt disable rat
    Writing to /grdbms/64bit/patchdb/app/oracle/product/p11201b/install/disable_rat.log... %s_unixOSDMakePath% -f /grdbms/64bit/patchdb/app/oracle/product/p11201b/rdbms/lib/ins_rdbms.mk rat_off %s_unixOSDMakePath% -f /grdbms/64bit/patchdb/app/oracle/product/p11201b/rdbms/lib/ins_rdbms.mk ioracle Note that the relink commands above are not actually being run by chopt. The user has to manually run them.
    
    
    Note: The fact that chopt is showing an Installer variable is a bug.
    As per "Bug 8967636: $ORACLE_HOME/BIN/CHOPT.INI NOT INSTANTIATED CORRECTLY" chopt really *should* invoke make and relink the oracle executable.

    Workaround as per the bug is edit the chopt.ini file and
    replace all references to %s_unixOSDMakePath% with /usr/bin/make
    before running the chopt script.

    Warning concerning switching on ASM should only be done on Grid Infrastructure
    Homes in Oracle 11gR2. Doing it on standard RDBMS will result in errors on
    startup.

     

  2. admin says:

    Customize Enterprise Edition Options under 11.2.0.1 version

    Applies to:

    Oracle Universal Installer
    Information in this document applies to any platform.
    ORACLE SERVER ENTERPRISE EDITION VERSION 11.2

    Goal

    Explain how the 11.2 runInstaller works when we choose distinct oracle Enterprise Edition options.

    Solution

    Previous versions of the Oracle Universal Installer such as 10.2 and 11.1 allowed us the possibility to execute a custom installation of oracle database components. Under 11.2 we do not have this option and we can only choose one of the following possibilities:

    EE : Enterprise Edition
    SE : Standard Edition
    SEONE : Standard Edition One
    PE : Personal Edition (WINDOWS ONLY)

    The only customize possibilities that we have are related to the Enterprise Edition  options to choose.

    The list of EE options to enable are the following:

    oracle.rdbms.partitioning:11.2.0.0.2 – Oracle Partitioning
    oracle.rdbms.dm:11.2.0.0.2 – Oracle Data Mining
    oracle.rdbms.dv:11.2.0.0.2 – Oracle Database Vault
    oracle.rdbms.lbac:11.2.0.0.2 – Oracle Label Security
    oracle.rdbms.rat:11.2.0.0.2 – Oracle Real Application Testing
    oracle.oraolap:11.2.0.0.2 – Oracle OLAP

    Choosing one of this options or choosing all doesn’t means that the component  won’t be installed in the system. Choosing one of them means that the options will be enabled or disabled in the oracle executable across the libknlopt.a library.

    To know what options are enabled or disabled in the libknlopt.a we can use the following command:

    ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a

    We can cross the output with the next list.

    (OLS) Oracle Label Security ON= kzlilbac.o
    (OLS) Oracle Label Security OFF= kzlnlbac.o

    (DV) Oracle Database Vault ON= kzvidv.o
    (DV) Oracle Database Vault OFF= kzvndv.o

    Oracle OLAP ON= xsyeolap.o
    Oracle OLAP OFF=xsnoolap.o

    (PART) Oracle Partitioning ON= kkpoban.o
    (PART) Oracle Partitioning OFF= ksnkkpo.o

    (DM) Oracle Data Mining ON=dmwdm.o
    (DM) Oracle Data Mining OFF=dmndm.o

    (RAT) Oracle Real Application Testing ON=kecwr.o
    (RAT) Oracle Real Application Testing OFF=kecnr.o

    (RAC) Oracle Real Application Cluster ON=kcsm.o
    (RAC) Oracle Real Application Cluster OFF=ksnkcs.o

    (ASM) Storage Management ON=kfon.o
    (ASM) Storage Management OFF=kfoff.o

    As we  mentioned above, the component product will be installed and the size and number of  directories in the ORACLE_HOME will be the same. Only the option will be enabled or disabled under the oracle executable.

    We can verify this behavior using opatch tools. The output will be the same, independent of the Enterprise Edition options chosen.

    ——————————————————————————–

    To enable or disable options, please look at the following commands:

    make -f ins_rdbms.mk {option}

          
    where {option} is => OPTION – {option on} / {option off }

    • OLS – lbac_on / lbac_off
    • DV – dv_on / dv_off
    • OLAP – olap_on / olap_off
    • PART – part_on / part_off
    • DM   – dm_on / dm_off
    • RAT – rat_on / rat_off
    • RAC – rac_on / rac_off
    • ASM – asm_on / asm_off

    A couple of examples:

    make -f ins_rdbms.mk asm_on

          
    would enable ASM option

    make -f ins_rdbms.mk dm_off

          
    would disable Data Mining option

    Since you need to relink oracle itself after enabling or disabling any option, it is also necessary to follow any of these “enable/disable” commands with:

          
    make -f ins_rdbms.mk ioracle

    ——————————————————————————–
    Installed Top-level Products (1):

    Oracle Database 11g 11.2.0.0.2
    There are 1 products installed in this Oracle Home.
    ……..
    ……..
    ……..
    XML Parser for Oracle JVM 11.2.0.0.2
    There are 134 products installed in this Oracle Home.

    There are no Interim patches installed in this Oracle Home.

    Please note that we have a new tools “chopt” to enable or disable Enterprise Edition Options.

    We can observe the same behavior in silent install too. We cannot do a custom install using silent install as  the response file provided with the media is wrong.  Public bug 8933828  was opened to correct this problem.

     

  3. admin says:

    11gR2 Install (Non-RAC): Understanding New Changes With All New 11.2 Installer

    Applies to:

    Oracle Server – Enterprise Edition – Version: 11.2.0.0 to 11.2.0.0
    Information in this document applies to any platform.

    Purpose

    This article helps to understand the new changes incorporated with all new 11.2 installer (in Non-RAC environment installations).

    Scope and Application

    This article helps to understand the new changes incorporated with all new 11.2 installer (in Non-RAC environment installations).

    11gR2 Install (Non-RAC): Understanding New Changes With All New 11.2 Installer

    Following are the changes observed with all new 11.2 installer when compared to previous releases.

    1) Following are the installation options provided by 11.2 Installer from Oracle Database 11g Release 2 (11.2.0.1) installation kit.
       
    Create and configure a Database: Creates new database along with software installation
       
    Install Database Software only: Installs only OracleHome software
       
    Upgrade an Existing Database: Allows database upgrades along with software installation

    2) Input for “Oracle Home Name” is now removed from interview phase during installation. 11.2 OUI is now uses default name (controlled by DEFAULT_HOME_NAME parameter in oraparam.ini) for the Oracle Home installation. If user wants to specify different Oracle Home Name other than the default name, then user can specify the OracleHomeName via command prompt  

    ./runInstaller ORACLE_HOME_NAME=”Ora11gR2_prod”

    3) New screen “System Class” has been added to chose between “Desktop Class” OR “Server Class“.
    “Desktop Class” installs a minimal configuration SI (Single Instance) database installation with dbcontrol configured on local host. This option is to minimize the number of user inputs for installations on desktop class systems
    Server Class” selection provides advanced configuration options (for creating SI or RAC database)

    4) There is no need to use ‘-record‘ flag to record/save the response file.  At Summary page of installation, 11gR2 installer provides option to save the response file. We can perfom the silent installation using this saved response file  

    ./runInstaller -silent -responseFile <saved_response-file>

    5) There is no “Custom Install” option to select/deselect components/products during installation of Oracle Database Server. Available install options are
       
    Enterprise Edition
       
    Standard Edition
       
    Standard Edition One
    11gR2 installer installs the Oracle Home with ALL (without any customization) the components/products that are licensed under specific edition (EE, SE or SEOne). However, installer allows you to enable/disable specific component based on your selection. Components available for enable/disable (in OracleHome binaries) are
        
    Oracle Partitioning
        
    Oracle OLAP
        
    Oracle Label Security
        
    Oracle Data Mining RDBMS Files
        
    Oracle Database Vault option
        
    Oracle Real Application Testing

    6) It is not possible to perform additional components/products installation on top of existing 11gR2 OracleHome. As there is no ‘Custom install’ option, it is not possible to select/deselect components/products for installation/deinstallation to/from already installed/existing 11gR2 Oracle Home. Database edition chosen at the time of OracleHome installation, is the final installation selection. OracleHome software will be installed with ALL (or FULL) components/products that are licensed under specific edition (EE, SE or SEOne) installed.

    7) New deinstall script has been provided for deinstalling the 11gR2 Oracle Database Home.

     % cd $ORACLE_HOME/deinstall
     
    % ./deinstall

    8) 11.2 installer provides only two install methods : Interactive and Silent. Suppressed-Interactive Mode does not work with 11.2 OUI. If runInstaller command is invoked without “-silent” option but supplied the necessary information by using a response file or command line entries, then OUI still shows all the interactive screens but displays the values supplied through responsefile or command line entries as default values.

    9) During installation, list of configuration tools (ex: DBCA) can be seen in advance before they get executed. User can supply -noconfig flag with the runInstaller command to skip execution of all configuration tools during installation.

    10) 11.2 OUI is now provided with new argument/option called “-relink” to perform relinking activities.
    Manual relinking (i.e ‘relink all’) of the “11gR2 Oracle Database Home” is now executed using “runInstaller -relink”. Following is the command syntax used for ‘relink all’ (i.e “$ORACLE_HOME/bin/relink all”) in 11gR2 Oracle Database Home

    % ./runInstaller -relink -makeorder $ORACLE_HOME/inventory/make/makeorder.xml -waitforcompletion ORACLE_HOME=$ORACLE_HOME

    11) Separate 32-Bit Client installation kit for 64-Bit Platforms. Starting with Oracle Database 11g Release 2 (11.2), 64-bit client installation kit will not contain any 32-bit client binaries. If you require 32-bit client binaries on 64-bit platforms, then you can install the 32-bit binaries from the respective 32-bit client installation kit.

    12) On prerequisites execution screen, OUI generates a script that has fixes to some or all of the fixable prereqs that failed.
    – On entering the prereq dialog, prereqs are run.
    – If one or more fixable prereqs fail, then fixup dialog is shown and user is asked to run the script to automatically fix the failed (fixable) prereqs.
    There is no option to ignore a specific prereq failure. Only option available is “Ignore All”.

    13) Bubble help is available for each option in installation screens. It gives tip/information about the option when you move the mouse over that particular option.

    14) “Detail” button in installation progress window (screen name: “Install Product”) provides live installation progress messages in a separate window.

     

  4. admin says:

    How to install 11gR2 Database/Client Software in Silent mode without using response file [ID 885643.1]

    Applies to:

    Oracle Universal Installer – Version: 11.2.0.0 to 11.2.0.0
    Information in this document applies to any platform.

    Goal

    How to install Oracle Database Server/Client software in non-interactive or silent mode from command line without using a response file?

    Solution

    Silent installation can be done with the help of “Response File”. “Response File” contains all the inputs that are required for doing the silent installation.

    “Response File” can be created using one of the following methods: 

    – Responsefile template supplied with installation kit:
          
    Ex: <11gR2 Disk>/database/response/db_install.rsp 
      
    Copy “<11gR2 Disk>/database/response/db_install.rsp” to “<path>/db_install.rsp” 
      
    Edit “<path>/db_install.rsp” and modify the values that suits your environment 

    –  Record the responsefile using OUI in interactive mode:
    Starting with 11gR2, user can save (Record) all the installation steps into a response file during installation. This can be achieved by clicking on “Save Response File” button on the Summary page. Later, this saved response file can be used for a silent installation.

    Once the response file is created, user can execute the following command to do a silent installation:
     
    Windows : setup.exe -silent -responseFile “<path>\db_install.rsp”
     
    Unix : ./runInstaller -silent -responseFile “<path>/db_install.rsp”

    The same silent installation can be done directly from the command prompt without using a response file but it requires a minimum set of variables (from the response file) as arguments to the OUI (i.e “runInstaller or setup.exe”).

    For example, the following commands can be used to install in Silent mode without a response file:

    Database

    The following command can be used to install Database (Enterprise Edition Softwrae Only) in silent mode:  

    $ cd /11gR2/database
    $ ./runInstaller -silent -debug -force \
    FROM_LOCATION=/11gR2/database/stage/products.xml \
    oracle.install.option=INSTALL_DB_SWONLY \
    UNIX_GROUP_NAME=oinstall \
    INVENTORY_LOCATION=/u01/app/oracle/oraInventory \
    ORACLE_HOME=/u01/app/oracle/product/11201/db_1 \
    ORACLE_HOME_NAME=”OraDb11g_Home1″ \
    ORACLE_BASE=/u01/app/oracle \
    oracle.install.db.InstallEdition=EE \
    oracle.install.db.isCustomInstall=false \
    oracle.install.db.DBA_GROUP=dba \
    oracle.install.db.OPER_GROUP=dba \
    DECLINE_SECURITY_UPDATES=true

     

    Note :

    “DECLINE_SECURITY_UPDATES=true” causes the Install  of the OCM component but does not do the OCM configuration.

    If user wants to configure the OCM along with Database Silent Installation, then the following parameters need to be included to the above command:
      
    MYORACLESUPPORT_USERNAME=<MyOracleSupport Login>
      
    SECURITY_UPDATES_VIA_MYORACLESUPPORT=true
      
    MYORACLESUPPORT_PASSWORD=<MyOracleSupport Login Password>
    If direct connection is not possible, then following proxy connection details are required additionally
      
    PROXY_HOST=<proxy_host>
      
    PROXY_PORT=<proxy_port>
      
    PROXY_USER=<proxy_user>
      
    PROXY_PWD=<proxy_passwd>
      
    DECLINE_SECURITY_UPDATES=false

    Client
    The following command can be used to install Client (Install Type : Administrator) in silent mode:

    $ cd /11gR2/client
    $ ./runInstaller -silent -debug -force
    FROM_LOCATION=/11gR2/client/stage/products.xml \
    UNIX_GROUP_NAME=oinstall \
    ORACLE_HOME=/u01/app/oracle/product/11201/Client_1 \
    ORACLE_HOME_NAME=”OraClient11g_Home1″ \
    ORACLE_BASE=/u01/app/oracle \
    oracle.install.client.installType=”Administrator”
    Note:
    The following options are not mandatory but can be used when required:
      
    -force : Allows silent mode installation into a non-empty ORACLE_HOME directory.
     
    -debug : Displays debug information from OUI. This will be usefull if OUI is not starting.

    Note :

    11.2 installer provides only two install mehods : Interactive and Silent.
    Suppressed-Interactive mode (used to work in previous releases) does not work with 11.2 OUI.

    If runInstaller command is invoked without “-silent” option but supplied the necessary information by using a response file or command line entries, then OUI still shows all the interactive screens and displays the values supplied through responsefile or command line entries as default values.

     

  5. admin says:

    Oracle 11gR2 Relink New Feature [ID 883299.1]

    Applies to:

    Oracle Server – Enterprise Edition – Version: 11.2.0.0 to 11.2.0.0
    Generic UNIX

    Goal

    What is new in Oracle 11gR2 Relink?

    Solution

    I ) Oracle 11gR2 has two methods of relinking all product binaries in a home

    1) Traditional relink with ‘all’ option only

    The first method is the normal running the $ORACLE_HOME/bin/relink script, which now only accepts the‘all’ parameter (no other parameters are accepted)

    % $ORACLE_HOME/bin/relink all
    % $ORACE_HOME/bin/relink ( By default it takes the ‘all’ parameter )

    Note :  ‘Relink all’ is provided for backward compatibility.

    2) relink using runInstaller

    This runs the command:
     

      -relink : For performing relink actions on the oracle home
             
    Usage: -relink -maketargetsxml <location of maketargetsxml> [-makedepsxml <location of makedepsxml>] [name=value]
    Example :
    $ORACLE_HOME/oui/bin/runInstaller -relink -waitForCompletion -maketargetsxml  $ORACLE_HOME/inventory/make/makeorder.xml  -logLocation $ORACLE_HOME/install ORACLE_HOME=$ORACLE_HOME > $ORACLE_HOME/install/relink.log 2>&1

    II) Relink log location

    Case 1
     
    If  relink is performed using OUI then  “$ORACLE_HOME/install/relink.log” is not created by default.

    To send the relink  output to $ORACLE_HOME/install/relink.log we need to redirect the output explicitly.

    $ORACLE_HOME/oui/bin/runInstaller -relink -waitForCompletion -maketargetsxml $ORACLE_HOME/inventory/make/makeorder.xml -logDir $ORACLE_HOME/install ORACLE_HOME=$ORACLE_HOME > $ORACLE_HOME/install/relink.log 2>&1

    Case 2
    In case of  ” relink all ” command, it always creates a new log file with a name “relink.log” and it will not append log information to the existing relink log file . The previous log will be saved with a timestamp ( Ex: relinkActions2009-09-14_09-01-10-PM.log )

     

  6. admin says:

    How to install/deinstall Oracle Database Server software silently without response file

    Applies to:

    Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 10.2.0.1
    Oracle Server – Enterprise Edition – Version: 11.1.0.6 to 11.1.0.6
    Information in this document applies to any platform.
    Oracle Server Enterprise Edition – Version: 10.2.0.1.0 to 10.2.0.1.0
    Oracle Server Enterprise Edition – Version: 11.1.0.6.0 to 11.1.0.6.0

    Goal

    How to install/deinstall Oracle Database Server software in non-interactive or silent mode from command line without using response file?

    NOTE: Oracle support strongly recommends the use of response files.

    Solution

    Generally silent installation can be done with the help of “Response File”. “Response File” contains all the inputs that are required for doing the silent installation.

    “Response File” can be created using one of the following methods 
     
    – Using the responsefile template supplied with installation kit 
           
    Ex: <11g Disk>/database/response/enterprise.rsp 
       
    copy “<11g Disk>/database/response/enterprise.rsp” to “<path>/my_response.rsp” 
       
    edit “<path>/enterprise.rsp” and modify the values that suits your environment

     
    – Create responsefile using OUI’s option “-record”
        
    Invoke the interactive installation using following command
         
    Windows : setup.exe -record -destinationFile “<path>\my_response.rsp”
          
    Unix : ./runInstaller -record -destinationFile “<path>/my_response.rsp”
         Progress the installation till summary page and then exit the installer.
        
    All the inputs passed to the OUI during interactive installation will be
        
    recorded into “<path>/My_Response.rsp”

    Once the response file is created, we can execute following command to do a silent installation
       
    Windows : setup.exe -silent -responseFile “<path>\my_response.rsp”
       
    Unix : ./runInstaller -silent -responseFile “<path>/my_response.rsp”

    Same silent installation can be done directly from the command prompt without response file but it requires minimum set of variables (from response file) as arguments to the OUI (i.e “runInstaller or setup.exe”).

    For example, following command can be used to install Database Server software in silent mode

    11gR1 :

    Windows : 

    > cd Z:\database
    > setup.exe -silent -force -debug FROM_LOCATION=”Z:\database\stage\products.xml” ORACLE_HOME=”D:\app\oracle\product\11.1.0\db_1″ ORACLE_HOME_NAME=”Ora11gDb1″ ORACLE_BASE=”D:\app\oracle” TOPLEVEL_COMPONENT={“oracle.server”,”11.1.0.6.0″} INSTALL_TYPE=”EE” n_configurationOption=3

    Unix:

    $ cd /mount/dvd/database
    $ ./runInstaller -silent -force -debug \
    FROM_LOCATION=”/mount/dvd/database/stage/products.xml” \
    ORACLE_HOME=”/u01/app/oracle/product/11.1.0/db_1″ \
    ORACLE_HOME_NAME=”Ora11gDb1″ ORACLE_BASE=”/u01/app/oracle” \
    TOPLEVEL_COMPONENT='{“oracle.server”,”11.1.0.6.0″}’ \
    INSTALL_TYPE=”EE” n_configurationOption=3

    10gR2 :

    Windows :

    > cd Y:\database
    > setup.exe -silent -force -debug FROM_LOCATION=”Z:\database\stage\products.xml” ORACLE_HOME=”D:\app\oracle\product\10.2.0\db_1″ ORACLE_HOME_NAME=”Ora10gDb1″ TOPLEVEL_COMPONENT={“oracle.server”,”10.2.0.1.0″} INSTALL_TYPE=”EE” n_configurationOption=3

    Unix:

    $ cd /mount/dvd/database
    $ ./runInstaller -silent -force -debug \
    FROM_LOCATION=”/mount/dvd/database/stage/products.xml” \
    ORACLE_HOME=”/u01/app/oracle/product/10.2.0/db_1″ \
    ORACLE_HOME_NAME=”Ora10gDb1″ \
    TOPLEVEL_COMPONENT='{“oracle.server”,”10.2.0.1.0″}’ \
    INSTALL_TYPE=”EE” n_configurationOption=3

    Following command can be used to deinstall Database Server Software in silent mode. Example is given for 10gR2 (10.2.0.1).

    Windows:

    > setup.exe -silent -debug -deinstall DEINSTALL_LIST={“oracle.server”,”10.2.0.1.0″} REMOVE_HOMES={“D:\app\oracle\product\10.2.0\db_1”}

    Unix:

    $ ./runInstaller -silent -debug -deinstall \
    DEINSTALL_LIST='{“oracle.server”,”10.2.0.1.0″}’ \
    REMOVE_HOMES={“/u01/app/oracle/product/10.2.0/db_1”}
    Note:
    1. On windows, ensure that command is framed in single line and space is used between each option and variable
       
    Ex: setup.exe -option1 -option2 variable1=value variable2=value ….
    2. During install, variable “n_configurationOption=3” indicates that install “Software Only” option
    3. Following options are not mandatory but can be used when required
       
    -force : Allows silent mode installation into a non-empty ORACLE_HOME directory.
       
    -debug : Displays debug information from OUI. This will be usefull if OUI is not starting.

    Refer following article for installing database patchset software in silent mode
    Note 808275.1 How to install Oracle Database Patchset software in Silent mode without using response file

     

  7. admin says:

    How to install Oracle Database Patchset software in Silent mode without using response file

    Applies to:

    Oracle Server – Enterprise Edition – Version: 10.2.0.2 to 10.2.0.4
    Oracle Server – Enterprise Edition – Version: 11.1.0.7 to 11.1.0.7
    Information in this document applies to any platform.

    Goal

    This article helps to install Oracle Database Patchset software in silent/non-interactive mode from command line without using response file.

    Solution

    Generally patchset silent installation can be done with the help of the “Response File” (patchset.rsp) supplied with the patchset software.

    The process is documented in the README for each patchset.

    The same silent patchset installation can be done directly from the command prompt without response file, by using a minimum set of variables (from response file) as arguments to the OUI (i.e “runInstaller” or “setup.exe”).

    For example, following command can be used to install Oracle Database Patchset software in silent mode

    11.1.0.7

    Windows :

    > cd Z:\patches\11.1.0.7\Disk1
    > setup.exe -silent -force -debug FROM_LOCATION=”Z:\patches\11.1.0.7\Disk1\stage\products.xml” ORACLE_HOME=”D:\app\oracle\product\11.1.0\db_1″ ORACLE_HOME_NAME=”Ora11gDb1″ TOPLEVEL_COMPONENT={“oracle.patchset.db”,”11.1.0.7.0″} DECLINE_SECURITY_UPDATES=TRUE

     UNIX :

    $ cd /oracle/Patches/10.2.0.4/Disk1
    $ ./runInstaller -silent -force -debug \
    FROM_LOCATION=”//oracle/Patches/11.1.0.7/Disk1/stage/products.xml” \
    ORACLE_HOME=”/u01/app/oracle/product/11.1.0/db_1″ \
    ORACLE_HOME_NAME=”Ora11gDb1″ \
    TOPLEVEL_COMPONENT='{“oracle.patchset.db”,”11.1.0.7.0″}’ \
    DECLINE_SECURITY_UPDATES=TRUE

    OUI variable “DECLINE_SECURITY_UPDATES=TRUE
    Installs the OCM component (if not already installed) but does not do the OCM configuration.

    During 11.1.0.7 patchset software installation, if “DECLINE_SECURITY_UPDATES=TRUE” is not supplied during silent/non-interactive installation mode, then OUI may fail with following errors

    SEVERE:Values for the following variables could not be obtained from the command line or response file(s):
    METALINK_USERNAME(MetaLinkUsername)

    Silent install cannot continue.

     

    10.2.0.4

    Windows :

    > cd Z:\patches\10.2.0.4\Disk1
    > setup.exe -silent -force -debug FROM_LOCATION=”Z:\patches\10.2.0.4\Disk1\stage\products.xml” ORACLE_HOME=”D:\app\oracle\product\10.2.0\db_1″ ORACLE_HOME_NAME=”Ora10gDb1″ TOPLEVEL_COMPONENT={“oracle.patchset.db”,”10.2.0.4.0″}

    UNIX: 

    $ cd /oracle/Patches/10.2.0.4/Disk1
    $ ./runInstaller -silent -force -debug \
    FROM_LOCATION=”/oracle/Patches/10.2.0.4/Disk1/stage/products.xml” \
    ORACLE_HOME=”/u01/app/oracle/product/10.2.0/db_1″ \
    ORACLE_HOME_NAME=”Ora10gDb1″ \
    TOPLEVEL_COMPONENT='{“oracle.patchset.db”,”10.2.0.4.0″}’

     

    Note :

    1. On windows, ensure that command is framed in single line and space is used between each option and variable
       
    Ex: setup.exe -option1-option2 variable1=value variable2=value ….

    2. Examples are given for latest patchset versions at the time of article creation

    3. If you want to install other patchset versions, please ensure that you are passing correct values for following variables
      
    – TOPLEVEL_COMPONENT : should contain correct component name and version
      
    – FROM_LOCATION : should point to the products.xml in the patchset software install kit

    4. For confirmation, please verify variable values in response file template supplied with the patchset software.
       
    $ cd <Patchset>/Disk1
        
    $ grep TOPLEVEL_COMPONENT ./response/patchset.rsp
        
    $ grep FROM_LOCATION ./response/patchset.rsp

     

  8. admin says:

    Different ways to check if Oracle RDBMS software is RAC enabled.

    Applies to:

    Oracle Server – Enterprise Edition – Version: 9.2.0.1 to 10.2.0.4 – Release: 9.2 to 10.2
    Information in this document applies to any platform.
    Oracle Server Enterprise Edition – Version: 9.2.0.1 to 10.2.0.4

    Goal

    Many times installations are performed by wrongly selecting ‘single instance’ or it is unclear after installation if RAC option was selected.

    At times later DBCA while performing installation gives error :
       
    “ORA-00439: feature not enabled: Real Application Clusters”

    How can you determine if the RAC option has been enabled during RDBMS installation?

    Solution

    1) Check RDA :

      
    RDA will show two options :

      
    (a) This section will show if RAC software package is installed

    Overview => Oracle Home Inventory => Oracle <version> Real Application Clusters

                

      
    (b) This section shows if RAC option is enabled. (Also check Point 3 below)

       Cluster => Cluster Information => RAC on/off Linked

                  

    2) Run the command  :

      
    In Linux (ONLY) you can use the following statement in order to check if
      
    an Oracle RAC specific library is linked against the current executable.
      

    % ldd $ORACLE_HOME/bin/oracle | grep libwddapi.so

     
       IF <1 row> IS RETURNED
       
    THEN your oracle IS RAC-ENABLED
       
    ELSE your oracle IS NOT RAC-ENABLED

       

      
    Alternately you can run below :
      

    % nm -r /u01/app/oracle/product/10.1.0/db_1/rdbms/lib/libknlopt.a | grep -c “kcsm.o” 2>/dev/null

      
    IF <1 row> IS RETURNED
      
    THEN your oracle IS RAC-ENABLED
      
    ELSE your oracle IS NOT RAC-ENABLED
       

     

    3) When you login to a sqlplus connection it will show :

    [oracle@himalaya ~]$ sqlplus

    SQL*Plus: Release 11.1.0.6.0 – Production on Fri Dec 26 12:11:13 2008
    Copyright (c) 1982, 2007, Oracle. All rights reserved.

    Enter user-name: / as sysdba

    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
    With the Partitioning, Real Application Clusters, OLAP and Data Mining options

    Note:  this will only work if you are logging into an existing database.  If you launch sqlplus without connecting to a database, then it will not show any database options.

    4) Other ways to check are by checking  for few parameters in alert log :

      cluster_database         = TRUE
     
    cluster_database_instances= 2

    
    

    5) Querying the GV$<views> can also tell that RAC would be installed :

    SQL> SELECT INST_ID, INSTANCE_NUMBER, INSTANCE_NAME FROM GV$INSTANCE;

    INST_ID INSTANCE_NUMBER INSTANCE_NAME
    ---------- --------------- ----------------
    1 1 db11g1
    2 2 db11g2

     

  9. admin says:

    Relink or ‘make ioracle’ fails with libraries ha_gs_r ha_em_r not found

    Applies to:

    Oracle Server – Enterprise Edition – Version: 10.2.0.1.0 to 10.2.0.4.0
    AIX5L Based Systems (64-bit)

    Symptoms

    Attempting to relink or ‘make ioracle’ on a NON-RAC Oracle_Home fails with …

    Running make for target ioracle
    Make failed to invoke “/usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=</path/to/Oracle/Home>”….’ld: 0706-006 Cannot find or open library file: -l ha_gs_r
    ld:open(): No such file or directory
    ld: 0706-006 Cannot find or open library file: -l ha_em_r
    ld:open(): No such file or directory
    make: The error code from the last command is 255.

    Cause

    The ha_gs_r and ha_em_r libraries are provided by the AIX rsct.basic.rte fileset. rsct.basic.rte is a requirement for RAC but not for non-RAC database installations.

    The Oracle_Home may have once been in a RAC configuration, or the Oracle_Home may have been inappropriately copied or cloned from a RAC server. It may be necessary to re-install the Oracle_Home to avoid further linking errors, however, this error can be worked around.

    In this case, the ‘make’ for ‘ioracle’ is finding object ‘kcsm.o’ in library $ORACLE_HOME/rdbms/lib/libknlopt.a …

    $ ar -tv -X64 $ORACLE_HOME/rdbms/lib/libknlopt.a | grep kcsm.o

    The existence of OH/rdbms/lib/libknlopt.a(kcsm.o) triggers the ‘make’ process to link-in the HA libraries. In a non-RAC Oracle_Home, kcsm.o can be dropped from the library to avoid attempting to link-in the HA libraries.

    Solution

    To drop OH/rdbms/lib/libknlopt.a(kcsm.o) …

    $ cd $ORACLE_HOME/rdbms/lib
    $ ar -x -X64 libknlopt.a kcsm.o
    $ ar -d -X64 libknlopt.a kcsm.o

    The ‘ar -x’ extracts kcsm.o from the library into the current directory, in case it is needed later.

    The ‘ar -d’ deletes kcsm.o from the library.

    At this point, it should be possible to ‘make’ the OH/bin/oracle binary without invoking the HA libraries. With all processes running from the Oracle_Home SHUTDOWN …

    $ cd $ORACLE_HOME/rdbms/lib
    $ make -f ins_rdbms.mk ioracle

    If fatal errors continue to appear, re-installing the Oracle_Home should be considered.

     

  10. admin says:

    Relink of RAC Database Fails: Cannot find or open library file: -l ha_gs_r

    Applies to:

    Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 10.2.0.3
    AIX5L Based Systems (64-bit)

    Symptoms

    Relink of RAC database fails with:

    ld: 0706-006 Cannot find or open library file: -l ha_gs_r
    ld:open(): A file or directory in the path name does not exist.
    ld: 0706-006 Cannot find or open library file: -l ha_em_r
    ld:open(): A file or directory in the path name does not exist.
    make: 1254-004 The error code from the last command is 255

    Cause

    Fileset rsct.basic.rte (required for RAC) is not installed .

    Solution

    1. install fileset rsct.basic.rte 
    2. relink again

     

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569