Showing posts with label describe. Show all posts
Showing posts with label describe. Show all posts

Location of Log files in Exadata

On the cell nodes
============

1. Cell alert.log file
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.logorif the CELLTRACE parameter is set just do cd $CELLTRACE

2. MS logfile
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/ms-odl.log.
orif the CELLTRACE parameter is set just do cd $CELLTRACE

3. OS watcher output data
/opt/oracle.oswatcher/osw/archive/

To get OS watcher data of specific date :

#cd /opt/oracle.oswatcher/osw/archive
#find . -name '*12.01.13*' -print -exec zip /tmp/osw_`hostname`.zip {} ;
where 12- year 01- Month 13-day

4. Os message logfile
/var/log/messages

5. VM Core files
/var/log/oracle/crashfiles
More details can be found in the following note:
Where / How to find OS crashcore file in Exadata Systems [Linux] (Doc ID 1389225.1)

6. SunDiag output files.
/tmp/sundiag_.tar.bz2

7. Cell patching issues related logfiles:
/var/log/cellos
The major logfile of patch application output you will find in the db node from where you are patching in the location /tmp/<cell version>/patchmgr.stdout and patchmgr.err

8. Disk controller firmware logs:
/opt/MegaRAID/MegaCli/Megacli64 -fwtermlog -dsply -a0

================

1. Database alert.log
$ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log
Ex: /u01/app/oracle/diag/rdbms/dbfs/DBFS2/trace/alert_DBFS2.log

2. ASM alert.log
$ORACLE_BASE/diag/asm/+asm/+ASM{instance number}/trace/ alert_+ASM {instance number}.log
Ex: /u01/app/oracle/diag/asm/+asm/+ASM2/trace/alert_+ASM2.log

3. Clusterware CRS alert.log
$GRID_HOME/log/{node name}/alert{node name}.log
Ex: /u01/app/11.2.0/grid/log/dmorldb02/alertdmorldb02.log

4. Diskmon logfiles
$GRID_HOME/log/{node name}/diskmon/diskmon.lo*
Ex: /u01/app/11.2.0/grid/log/dmorldb02/diskmon/diskmon.log

5. OS Watcher output files
/opt/oracle.oswatcher/osw/archive/

To get OS watcher data of specific date :

#cd /opt/oracle.oswatcher/osw/archive
#find . -name '*12.01.13*' -print -exec zip /tmp/osw_`hostname`.zip {} ;
where 12- year 01- Month 13-day

6. Os message logfile
/var/log/messages

7. VM Core files for Linux

/u01/crashfiles

More details can be found in the following note:Where / How to find OS crashcore file in Exadata Systems [Linux] (Doc ID 1389225.1)

8. Disk controller firmware logs:
/opt/MegaRAID/MegaCli/Megacli64 -fwtermlog -dsply -a0


What are the Exadata Installation Activities ?

How to find serial number of Exadata Server/Storage

Execute below command on operating system to find the serial number of DB node and Storage cell.

# ipmitool sunoem cli "show /SP system_identifier"



Example:


[root@db01 ~]#  ipmitool sunoem cli "show /SP system_identifier"

Connected. Use ^D to exit.
-> show /SP system_identifier

  /SP

    Properties:
        system_identifier = Exadata Database Machine X3-2 AK00097035


-> Session closed

Disconnected


You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification exam.

User Management in Exadata

User Management

#pam_tally2 -- Check the failed user login

#pam_tally2 -r -u username  ---Reset user user

######Check user pwd policy

#chage -l username

iDB Protocol

iDB protocol is an intelligent DataBase protocol which is the heart of the Exadata. It is used to do communication between Database node and cell storage. It transfers data between cell storage  and Database Node. Also it's provides interconnection bandwidth aggregation and failover.

DB pre-requisites to configure OEM12c

Database Pre-requisites to install the OEM 12c


### Deconfigure the dbconsole with below command ###


$emca -deconfig dbcontrol db -repos drop -HOST host01.example.com -PORT 1521 -SID emrep -SYS_PWD oraclepwd -SYSMAN_PWD oraclepwd -DBSNMP_PWD oraclepwd Y


### Set the parameter as per below on the OEM dataabse ###


sqlplus /nolog
 connect / as sysdba
 alter system set session_cached_cursors=200 scope=spfile;
 alter system set log_buffer=10485760 scope=spfile;
 alter system set processes=500 scope=spfile;
 alter database datafile '/u01/app/oracle/database/oradata/emrep/undotbs01.dbf' resize 250M;
 shutdown immediate
 startup
 exit

Exadata Operating System

Database Node:

Exadata DB node comes with 4 HDD (Hard Disk) with two OS. Two HDD Linux Configured and two HDD Solaris configured.

After Exadata comes to the floor, customer has to decide that which OS they will be required , accordingly Oracle ACS guy will configure single OS either Linux or Solaris on all four HDD with RAID 5 configuration.

Note: From X2-5, Solaris is no more available for Exadata machine.

Cell Storage:

Cell storage will be Linux configured. There is no second option for the storage cell.

Cellcli - Create

CellCLI> CREATE CELL [cellname] [realmname=realmvalue,] [interconnect1=ethvalue,] [interconnect2=ethvalue,][interconnect3=ethvalue,] [interconnect4=ethvalue,] 
( ([ipaddress1=ipvalue,] [ipaddress2=ipvalue,] [ipaddress3=ipvalue,] [ipaddress4=ipvalue,]) | ([ipblock=ipblkvalue, cellnumber=numvalue]) ) --- To configure the Oracle Exadata cell network and starts services. 

CellCLI> create celldisk all harddisk
CellCLI> create celldisk all 
CellCLI> create celldisk all harddisk interleaving='normal_redundancy' 
interleaving -- none(default), normal_redundancy or high_redundancy
CellCLI> create celldisk all flashdisk 
CellCLI> create griddisk RECO_CD_11_cell01 celldisk=CD_11_cell01 
CellCLI> create griddisk RECO_CD_11_cell01 celldisk=CD_11_cell01 size=100M 
CellCLI> create griddisk all prefix RECO 
CellCLI> create griddisk all flashdisk prefix FLASH 
CellCLI> create griddisk all harddisk prefix HARD 
CellCLI> create griddisk all harddisk prefix='data', size='270g'
CellCLI> create griddisk all prefix='data', size='300g'
CellCLI> create griddisk all prefix='redo', size='150g' 
CellCLI> create griddisk all harddisk prefix=systemdg 
CellCLI> create flashcache celldisk='FD_00_cell01' 
CellCLI> create flashcache celldisk='FD_13_cell01,FD_00_cell01,FD_10_cell01,FD_02_cell01,FD_06_cell01, FD_12_cell01,FD_05_cell01,FD_08_cell01,FD_15_cell01,FD_14_cell01,FD_07_cell01,FD_04_cell01,FD_03_cell01,FD_11_cell01,FD_09_cell01,FD_01_cell01' 

CellCLI> create flashcache all 
CellCLI> create flashcache all size=365.25G 
CellCLI> create key 
CellCLI> create quarantine 
CellCLI> create threshold cd_io_errs_min.prodb comparison=">", critical=10 
CellCLI> create threshold CD_IO_ERRS_MIN warning=1, comparison='>=', occurrences=1, observation=1 

Cellcli - Drop

CellCLI> drop cell --->> To reset the cell to its factory settings, removes the cell related properties of the server; it does not actually remove the physical server. 

CellCLI> drop cell force 
CellCLI> drop celldisk CD_01_cell05 
CellCLI> drop celldisk CD_00_cell09 force 
CellCLI> drop celldisk harddisk 
CellCLI> drop celldisk flashdisk 
CellCLI> drop celldisk all
CellCLI> drop celldisk all flashdisk force 
CellCLI> drop griddisk DBFS_DG_CD_02_cel14 
CellCLI> drop griddisk RECO_CD_11_cell01 force 
CellCLI> drop griddisk prefix=DBFS 
CellCLI> drop griddisk flashdisk 
CellCLI> drop griddisk harddisk 
CellCLI> drop griddisk all 
CellCLI> drop griddisk all prefix=temp_dg 
CellCLI> drop flashcache 
CellCLI> drop quarantine 
CellCLI> drop threshold DB_IO_RQ_SM_SEC.PRODB 
CellCLI> drop alerthistory

Cellcli - List

CellCLI> help list 


Enter HELP LIST <object_type> for specific help syntax. 

<object_type>: {ACTIVEREQUEST | ALERTDEFINITION | ALERTHISTORY | CELL | CELLDISK | FLASHCACHE | FLASHCACHECONTENT | GRIDDISK | IBPORT | IORMPLAN | KEY | LUN | METRICCURRENT | METRICDEFINITION | METRICHISTORY | PHYSICALDISK | QUARANTINE | THRESHOLD } 


CellCLI> list cell - Will display Oracle Exadata Storage Servers/Cells information 


CellCLI> list cell detail 
CellCLI> list cell attributes all 
CellCLI> list cell attributes rsStatus 
CellCLI> list physicaldisk - Will display physical disks information 
CellCLI> list physicaldisk detail 
CellCLI> list physicaldisk 34:5 
CellCLI> list physicaldisk 34:11 detail 
CellCLI> list physicaldisk attributes all 
CellCLI> list physicaldisk attributes name, id, slotnumber 

CellCLI> list physicaldisk attributes name, disktype, makemodel, physicalrpm, physicalport, status 

CellCLI> list physicaldisk attributes name, disktype, errCmdTimeoutCount, errHardReadCount, errHardWriteCount 

CellCLI> list physicaldisk where diskType='Flashdisk' 

CellCLI> list physicaldisk attributes name, id, slotnumber where disktype="flashdisk" and status != "not present" 

CellCLI> list physicaldisk attributes name, physicalInterface, physicalInsertTime where disktype = 'Harddisk'

CellCLI> list physicaldisk where diskType=flashdisk and status='poor performance' detail 

CellCLI> list lun  
CellCLI> list lun detail 
CellCLI> list lun 0_8 detail 
CellCLI> list lun attributes all 
CellCLI> list lun attributes name, cellDisk, raidLevel, status 
CellCLI> list lun where disktype=flashdisk 
CellCLI> list celldisk - Will display cell disks information 
CellCLI> list celldisk detail 
CellCLI> list celldisk FD_01_cell07 
CellCLI> list celldisk FD_01_cell13 detail 
CellCLI> list celldisk attributes all 
CellCLI> list celldisk attributes name, devicePartition 
CellCLI> list celldisk attributes name, devicePartition where size>20G
CellCLI> list celldisk attributes name,interleaving where disktype=harddisk 
CellCLI> list griddisk - Will display grid disks information 
CellCLI> list griddisk detail
CellCLI> list griddisk DG_01_cell03 detail 
CellCLI> list griddisk attributes all 
CellCLI> list griddisk attributes name, size
CellCLI> list griddisk attributes name, cellDisk, diskType 
CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus 

CellCLI> list griddisk attributes name,cellDisk,status where size=476.546875G
CellCLI> list griddisk attributes name where asmdeactivationoutcome != 'Yes' 
CellCLI> list flashcache - Will display flash cache information 
CellCLI> list flashcache detail 
CellCLI> list flashcache attributes all 
CellCLI> list flashcache attributes degradedCelldisks 
CellCLI> help list FLASHCACHECONTENT 

Usage: LIST FLASHCACHECONTENT [<filters>] [<attribute_list>] [DETAIL] 
Purpose: Displays specified attributes for flash cache entries. 
Arguments: 
<filters>: An expression which determines the entries to be displayed. 
<attribute_list>: The attributes that are to be displayed. ATTRIBUTES {ALL | attr1 [, attr2]... } 
[DETAIL]: Formats the display as an attribute on each line, with an attribute descriptor preceding each value. 


CellCLI> list flashcachecontent - Will display flash cache content information

CellCLI> list flashcachecontent detail 
CellCLI> list flashcachecontent where objectnumber=161441 detail

CellCLI> list flashcachecontent where dbUniqueName like 'EX.?.?' and hitcount > 100 attributes dbUniqueName, objectNumber, cachedKeepSize, cachedSize

CellCLI> list flashcachecontent where dbUniqueName like 'EX.?.?' and objectNumber like '.*007'

CellCLI> list flashcachecontent where dbUniqueName like '.*X.?.?' and objectNumber like '.*456' detail 

CellCLI> list metriccurrent - Will display metrics information 
CellCLI> list metriccurrent gd_io_rq_w_sm 
CellCLI> list metriccurrent n_nic_rcv_sec detail 
CellCLI> list metriccurrent attributes name,metricObjectName,metricType, metricValue,objectType where alertState != 'normal' 

CellCLI> list metriccurrent attributes name,metricObjectName,metricType, metricValue,alertState where objectType = 'HOST_INTERCONNECT' 

CellCLI> list metriccurrent attributes all where objectType = 'CELL'
CellCLI> list metriccurrent attributes all where objectType = 'GRIDDISK' - 
> and metricObjectName = 'DATA_CD_09_cell01' and metricValue > 0 

CellCLI> list metricdefinition 
CellCLI> list metricdefinition cl_cput detail 
CellCLI> list metricdefinition attributes all where objecttype='CELL' 
CellCLI> list metrichistory - Will display metric's history
CellCLI> list metrichistory cl_cput 
CellCLI> list metrichistory where objectType = 'CELL' 
CellCLI> list metrichistory where objectType = 'CELL' and name = 'CL_TEMP'

CellCLI> list metrichistory cl_cput where collectiontime > '*2011-10-15T22:56:04-04:00*' 

CellCLI> list alertdefinition detail - Will display alert's definitions 
CellCLI> list alertdefinition attributes all where alertSource!='Metric'


CellCLI> list alerthistory - Will display alert's history

CellCLI> list alerthistory detail
CellCLI> list alerthistory where notificationState like '[023]' and severity like '[warning|critical]' and examinedBy = NULL;


CellCLI> list activerequest 

CellCLI> list ibport - Will display InfiniBand configuration details
CellCLI> list ibport detail 
CellCLI> list iormplan - Will display IORM plan details 
CellCLI> list key
CellCLI> list quarantine 
CellCLI> list threshold - Will display threshold details

Cellcli - Describe

It Will display all attributes

CellCLI> describe cell
CellCLI> describe physicaldisk
CellCLI> describe lun
CellCLI> describe celldisk
CellCLI> describe griddisk
CellCLI> describe flashcache
CellCLI> describe flashcachecontent
CellCLI> describe metriccurrent
CellCLI> describe metricdefinition
CellCLI> describe metrichistory 

Cellcli - Help

CellCLI> help
HELP [topic]
    Available Topics:
        ALTER
        ALTER ALERTHISTORY
        ALTER CELL
        ALTER CELLDISK
        ALTER GRIDDISK
        ALTER IBPORT
        ALTER IORMPLAN
        ALTER LUN
        ALTER PHYSICALDISK
        ALTER QUARANTINE
        ALTER THRESHOLD
        ASSIGN KEY
        CALIBRATE
        CREATE
        CREATE CELL
        CREATE CELLDISK
        CREATE FLASHCACHE
        CREATE GRIDDISK
        CREATE KEY
        CREATE QUARANTINE
        CREATE THRESHOLD
        DESCRIBE
        DROP
        DROP ALERTHISTORY
        DROP CELL
        DROP CELLDISK
        DROP FLASHCACHE
        DROP GRIDDISK
        DROP QUARANTINE
        DROP THRESHOLD
        EXPORT CELLDISK
        IMPORT CELLDISK
        LIST
        LIST ACTIVEREQUEST
        LIST ALERTDEFINITION
        LIST ALERTHISTORY
        LIST CELL
        LIST CELLDISK
        LIST FLASHCACHE
        LIST FLASHCACHECONTENT
        LIST GRIDDISK
        LIST IBPORT
        LIST IORMPLAN
        LIST KEY
        LIST LUN
        LIST METRICCURRENT
        LIST METRICDEFINITION
        LIST METRICHISTORY
        LIST PHYSICALDISK
        LIST QUARANTINE
        LIST THRESHOLD
        SET
        SPOOL
        START

What is cellcli ?

What is cellcli utility?

Full form – Cell Command Line Interface

Cellcli used to manage the cell through the cell command line utility.

To invoke the cellcli utility, login to the cell storage through root, celladmin or cellmonitor and type cellcli.