Showing posts with label RAC. Show all posts
Showing posts with label RAC. Show all posts

Monday, 22 June 2015

RAC installation with GUI


./runInstaller
 Action: select the 1st option “install and configure grid infrastructure for a cluster “ and click next

Action: select the “Advanced installation” option and proceed to next step



 select language "English"
Action: add your cluster name here and add the SCAN name. unselect the “Configure DNS”. Keep the port as 1521


Action: click the add button and add your second node details. And click next.
You can check the SSH connectivity between the nodes with “SSH Connectivity” button shown above. Enter the “oracle” user password in the password field. 

Check your public and private subnet values and click next


Action: select the “ASM” option if your storage is ASM type.


Action: select the OCR_VOTE_DISKs for creating voting disk location


Action: select the password for ASM sys user and proceed to next


Action: do not select the IPMI option and proceed next
Action: click next

 Action: decide the Oracle Base and Grid home and enter here in the fields and proceed next

  Action: Enter the Inventory directory
Now the pre-checks will start


 Action: make sure everything is succeeded and click next

 Action: save the response file. It consists of all the params set ready for installation.

 Action: the above scripts need to be executed as root user in both nodes. Execute the scripts one after another on each node. Don’t execute simultaneously.
Click OK, once scripts are executed by root user
Note: make sure the scripts give success response. It should not fail. If it is failed analyze the issue and apply the patch 9974223 for 11.2.0.2.
 Note: everything here should be success




Action: click close to close the terminal
GRID Installation is completed….!!!!!!!!!

Friday, 25 July 2014

/u01/app/oracle/product/11.2.0/db_1/bin/clsecho: No such file or directory





Error: /u01/app/oracle/product/11.2.0/db_1/bin/clsecho: No such file or directory

Reason: 
This error occurs when we perform commands on ASM prompt. This is not a major issue to worry. This error causes because of improper set up of ASM environment variables.

    [oracle@node1-rac1 ~]$ asmcmd
    Connected to an idle instance.
    sh: /u01/app/oracle/product/11.2.0/db_1/bin/clsecho: No such file or directory
    ASMCMD> ls
    Can't exec "/u01/app/oracle/product/11.2.0/db_1/bin/clsecho": No such file or directory at /u01/app/oracle/product/11.2.0/db_1/lib/asmcmdshare.pm line 493, <STDIN> line 1.
    Use of uninitialized value $buf in string ne at /u01/app/oracle/product/11.2.0/db_1/lib/asmcmdshare.pm line 497, <STDIN> line 1.
    ASMCMD>

To set the proper environment variables follow the below steps:

    [oracle@rac1 ~]$ cat /etc/oratab | grep ASM
    # a database or ASM Configuration Assistant while creating ASM instance.
    +ASM1:/u01/app/11.2.0/grid:N          # line added by Agent

Action: 
set the env variables as below
    [oracle@rac1 ~]$ . oraenv
    ORACLE_SID = [RAC1]?  +ASM1   ----> enter as +ASM1 here if it is your node-1, +ASM2 if it is node-2 instance
    The Oracle base remains unchanged with value /u01/app/oracle
    [oracle@rac1 ~]$ asmcmd
    ASMCMD>
    ASMCMD>
    ASMCMD> ls
    DATA/
    ASMCMD>

                Now the issue is solved. We can list and check files using basic unix commands like ls,cat spfile.ora.

Note: Don’t forget to perform this on all nodes as well.

ORA-600 [kwqitnmphe:ltbagi], [1], [0] reported in the alert log file.

ORA-00600 [kwqitnmphe:ltbagi] Cause: This issue arises in 12.1.0.2. The error occurs because there are still Historical Messages without...