Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle ±¸·Ý,±í¿Õ¼ä¼ì²éshell½Å±¾´úÂë

#!/bin/ksh
#****************************************************************************
#
# (C) Copyright CPIC. 2008
#
# File name:    check_db_alert.sh
# Project:      Database Alerts Check
#
# Parameter : app_name -- name of db application(=oracle_sid)
#         ipaddress -- ip of the db server
#
# Creation Date:        Aug 19, 2008
# Origin Author:        Shangkun Peng
#
#
# Prerequisites:
# before using this shell script, directory $DAILY_CHECK must be created
# and this shell script should be put into it.
# for each application, environment file $DBENVFILE must be put into it.
# also, variables for auto ftp must be set
#
# Limitations:
# this shell script can be run at most once an hour
# additional job can be added but variable JOB_LIST must be modified
# and relative function must be coded too
#
#****************************************************************************
# record start date and time
echo "------------------------------------------------------------"
echo "database information collect started at:"; date
# check necessary parameter(s)
if [ $# -ne 2 ]
then
  echo "ERROR: parameter(s) not supplied correctly"
  echo "USAGE: check_db_alert.sh app_name ipaddress"
  echo "WHERE:"
  echo "app_name -- name of db application"
  echo "ipaddress -- ip of the db server"
  exit 1
fi
# -----------------------------------------------------------------------------------------------------------
# DEFINE VALUES FOR VARIABLES IN THIS SHELL
# general variables, can not be modified
APP_NAME=$1     # name of db application
IPADDRESS=$2     # ip of db server
DAILY_CHECK=/tmp/db_dailycheck   # directory for information collection of db application
DBENVFILE=$APP_NAME".dbenv"&


Ïà¹ØÎĵµ£º

OracleÖÐÓÃRowid²éÕÒºÍɾ³ýÖØ¸´¼Ç¼

OracleÖÐÓÃRowid²éÕÒºÍɾ³ýÖØ¸´¼Ç¼
¡¡¡¡Æ½Ê±¹¤×÷ÖпÉÄÜ»áÅöµ½µ±ÊÔͼ¶Ô¿â±íÖеÄijһÁлò¼¸Áд´½¨Î¨Ò»Ë÷Òýʱ£¬ÏµÍ³Ìáʾ ORA-01452 £º²»ÄÜ´´½¨Î¨Ò»Ë÷Òý£¬·¢ÏÖÖØ¸´¼Ç¼¡£
¡¡¡¡ÏÂÃæ×ܽáһϼ¸ÖÖ²éÕÒºÍɾ³ýÖØ¸´¼Ç¼µÄ·½·¨£¨ÒÔ±íCZΪÀý£©£º
¡¡¡¡±íCZµÄ½á¹¹ÈçÏ£º
¡¡¡¡SQL> desc cz
¡¡¡¡Name Null? Type
¡¡¡¡---------- ......

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî

oracleÖ´Ðмƻ®µÄһЩ¸ÅÄî(»ù´¡µÄ¼ÇÒä) 
¿ªÊ¼Ñ§Ï°ORACLEÓï¾äÓÅ»¯,´ÓÖ´Ðмƻ®¿ªÊ¼,ÏÈÊìϤÕâЩÃû´ÊÒÔ¼°»ù±¾º¬Òå,¼ÇÒäÔÚÎÒÄÔ×ÓÀï,2010-04-10
Rowid£ºÏµÍ³¸øoracleÊý¾ÝµÄÿÐи½¼ÓµÄÒ»¸öαÁУ¬°üº¬Êý¾Ý±íÃû³Æ£¬Êý¾Ý¿âid£¬´æ´¢Êý¾Ý¿âidÒÔ¼°Ò»¸öÁ÷Ë®ºÅµÈÐÅÏ¢£¬rowidÔÚÐеÄÉúÃüÖÜÆÚÄÚΨһ¡£
Recursive sql£ºÎªÁËÖ´ÐÐÓû§Óï¾ ......

oracleÖжÔÏó±í£¬ref¼°derefµÄÒ»¸öʵÀý¡£

ORACLEÔÚ¹ØÏµÊý¾Ý¿âÍ⣬ÈÚÈëÁËÃæÏò¶ÔÏóµÄÔªËØ£¬±ÈÈç¿ÉÒÔ´´½¨type£¬typeÖ®¼ä¿ÉÒԼ̳У¬type¿ÉÒÔ´ø¹¹Ô캯Êý¡¢ÅÅÐòº¯Êý¡¢¸÷ÖÖ¸÷ÑùµÄ³ÉÔ±º¯Êý¡¢´æ´¢¹ý³ÌµÈµÈ¡£
¶ÔÏó±íÊÇÖ¸¸Ã±íµÄÒ»ÐоÍÊÇÒ»¸ö¶ÔÏó£¬ÓÐÒ»¸öOID(object ID)£¬¶ÔÏó±íÖ®¼äûÓÐÖ÷Íâ¼ü¹ØÁªµÄ¸ÅÄΪÁËÌåÏÖÕâ²ã¹ØÏµ£¬oracleÖÐÓÃÁËref¶ÔÏóÀ´ÊµÏÖ¡£
ÏÂÃæÀý×Ó£¬´´½¨Ò»¸öµ ......

OracleÊý¾Ý¿âÖÐsysºÍsystemÁ½¸öÓû§µÄÇø±ð

     sysÊÇOracleÊý¾Ý¿âÖÐȨÏÞ×î¸ßµÄÕʺţ¬¾ßÓÐcreate databaseµÄȨÏÞ£¬¶øsystemûÓÐÕâ¸öȨÏÞ£¬sysµÄ½ÇÉ«ÊÇsysdba£¬systemµÄ½ÇÉ«ÊÇsysoper¡£
¡¡¡¡ÆäÓà¾ÍÊÇËûÃÇÁ½¸öÓû§¹²ÓеÄȨÏÞÁË£º
¡¡¡¡startup/shutdown/dbaÁ½¸öÓû§¶¼ÊÇ¿ÉÒÔ¹ÜÀíµÄ¡£
¡¡¡¡Æ½Ê±ÓÃsystemÀ´¹ÜÀíÊý¾Ý¿â¾Í¿ÉÒÔÁË¡£Õâ¸öÓû§µÄȨÏÞ¶Ô ......

Oracle Ìåϵ½á¹¹ ORA

Linux/UnixÉÏ£¬OracleÊǶà¸ö½ø³ÌʵÏֵģ¬Ã¿Ò»¸öÖ÷Òªº¯Êý¶¼ÊÇÒ»¸ö½ø³Ì£»ÔÚWindowsÉÏ£¬ÔòÊÇÒ»¸öµ¥Ò»½ø³Ì£¬½ø³ÌÖаüº¬¶à¸öÏ̡߳£
Oracle°ÑһϵÁÐÎïÀíÎļþ£¬ÈçÊý¾ÝÎļþ(Data file)¡¢¿ØÖÆÎļþ(Control file)¡¢Áª»úÈÕÖ¾(Redo log file)¡¢²ÎÊýÎļþ(spfile or pfile)µÈÎïÀí½á¹¹¼°ÓëÖ®¶ÔÓ¦µÄÂß¼­½á¹¹£¬Èç±í¿Õ¼ä(Tablespace)¡¢¶Î(Seg ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ