1.AMAÇ VE KAPSAM
Bir user schemasının butun ozellikleriyle index yapisini cikartmaya yarar.
2.UYGULAMA
2.1 Sqlscriptimizi yaratiyoruz.
vi /home/oracle/Desktop/olanindexlerigoster.sql
[Read more…]
Archives for June 2010
Finding the location of database Alert log, ASM Alert log, Cluster log and OS logs
1.PURPOSE AND SCOPE
Finding the location of Alert log, ASM Alert log, Cluster log and OS logs
2.PRACTICE
2.1 Finding location of Alert log.
2.1.1 Need to connect sqlplus and check the parameter of background_dump_dest.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
# sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 21 09:53:17 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> show parameter background NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ background_dump_dest string /u01/app/oracle/diag/rdbms/stdby/stdby/trace |
2.1.2 And our alert log is in that location
|
1 2 |
#ls /u01/app/oracle/diag/rdbms/stdby/stdby/trace/a*.log -rw-r----- 1 oracle dba 5006 Aug 21 09:08 /u01/app/oracle/diag/rdbms/stdby/stdby/trace/alert_AA.log |
2.2 Finding the ASM Alert log location
2.2.1 To connect ASM instance we need to change our ORACLE_SID.If our enviroment is cluster we need to set it like +ASM1 or +ASM2 etc.. it depends on node number.
|
1 |
#export ORACLE_SID=+ASM |
2.2.2 Need to connect sqlplus and check the parameter of background_dump_dest .
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
# sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 21 09:53:17 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> show parameter background NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ background_dump_dest string /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/ |
2.2.3 And our alert log is in that location
|
1 2 |
#ls /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/a*.log -rw-r----- 1 oracle dba 5006 Aug 21 09:08 /u01/app/oracle/product/11.1.0/db_1/rdbms/asm/+asm/log/alert_ASM.log |
2.3 Location of Cluster logs
2.3.1 First we need to check is our Cluster home enviroment setted or not.
|
1 2 |
echo $ORA_CRS_HOME /u01/oracle/product/crs/ |
2.3.2 And we can reach Cluster logs with this command
|
1 |
ls $ORAC_CRS_HOME/log/aler* |
2.4 Os log locationSistem log lokasyonu
2.4.1 It would be much better to connect OS with root acc.
|
1 |
vi /var/log/dmesg |
or
|
1 |
dmesg | less |
Creating AWR report using command line
1.UYGULAMA
1.1 To create awr reports using command line.
• We need to connect OS to Oracle user.
• We need to enter spesific directory where some oracle basic scripts are avaliable “cd $ORACLE_HOME/rdbms/admin/” .
• Now time to connect sqlplus “sqlplus / as sysdba” .
• And now we need to execute awr script “@$ORACLE_HOME/rdbms/admin/awrrpt.sql” .
[Read more…]