Bugra Canbakal's Oracle Blog

  • Home
  • Contact
  • SITE MAP
You are here: Home / 2010 / Archives for June 2010

Archives for June 2010

User Schemasının index yapısını çıkartmak

12:40 PM By Bugra Canbakal Leave a Comment

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…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle Tagged With: schema index, table index, user schema

Finding the location of database Alert log, ASM Alert log, Cluster log and OS logs

05:41 AM By Bugra Canbakal Leave a Comment

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.

 

# 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

#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.

#export ORACLE_SID=+ASM

 

2.2.2 Need to connect sqlplus and check the parameter of background_dump_dest .

# 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

#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.

echo $ORA_CRS_HOME
/u01/oracle/product/crs/

 

2.3.2 And we can reach Cluster logs with this command

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.

vi /var/log/dmesg

 

or

dmesg | less

 

[Read more…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle Tagged With: alert log, asm alert log, cluster alert log, os alert log, os log, sistem alert log

Creating AWR report using command line

08:47 PM By Bugra Canbakal Leave a Comment

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…]

Share this:

  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on X (Opens in new window) X

Filed Under: Oracle Tagged With: awr, awr report

About Me



Language:

  • English
  • Turkish

Categories

  • Oracle
    • RAC – Real Application Cluster
    • RMAN
    • Single Node
    • Standby – Dataguard
  • OS
    • Linux

Blogroll

  • Emre Baransel
  • Gökhan Atıl
  • H. Tonguc Yılmaz
  • Kamil Türkyılmaz
  • Tanel Poder
  • Turkce Oracle
  • Turkish Oracle User Group
  • Uwe Hesse
  • Zekeriya Beşiroğlu

Archives

  • April 2014
  • March 2014
  • August 2013
  • June 2013
  • March 2013
  • January 2013
  • December 2012
  • November 2012
  • July 2012
  • June 2012
  • May 2012
  • January 2012
  • November 2011
  • October 2011
  • August 2011
  • July 2011
  • June 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • June 2010
OCP
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

[footer_backtotop]

Copyright © 2010-2014 Bugra Canbakal. All rights reserved.