oracle ¸´ÖÆ
[root@localhost bin]# pwd
/usr/local/bin
[root@localhost bin]# ls
coraenv dbhome oraenv
[root@localhost bin]#
[root@localhost etc]# ls -la ora*
-rw-r--r-- 1 root root 60 2008-09-19 oraInst.loc
-rw-rw-r-- 1 oracle oinstall 731 2008-09-19 oratab
[root@localhost etc]# pwd
/etc
#!/bin/sh
if [ -d "/etc" ]; then
chmod 755 /etc;
else
mkdir -p /etc;
fi
if [ -f "/u01/app/oraInventory/oraInst.loc" ]; then
cp /u01/app/oraInventory/oraInst.loc /etc/oraInst.loc;
chmod 644 /etc/oraInst.loc
else
INVPTR=/etc/oraInst.loc
INVLOC=/u01/app/oraInventory
GRP=oinstall
PTRDIR="`dirname $INVPTR`";
# Create the software inventory location pointer file
if [ ! -d "$PTRDIR" ]; then
mkdir -p $PTRDIR;
fi
echo "Creating the Oracle inventory pointer file ($INVPTR)";
echo inventory_loc=$INVLOC > $INVPTR
echo inst_group=$GRP >> $INVPTR
chmod 644 $INVPTR
# Create the inventory directory if it doesn't exist
if [ ! -d "$INVLOC" ];then
echo "Creating the Oracle inventory directory ($INVLOC)";
mkdir -p $INVLOC;
fi
fi
echo "Changing permissions of /u01/app/oraInventory to 770.";
chmod -R g+rw,o-rwx /u01/app/oraInventory;
if [ $? != 0 ]; then
echo "OUI-35086:WARNING: chmod of /u01/app/oraInventory to 770 failed!";
fi
echo "Changing groupname of /u01/app/oraInventory to oinstall.";
chgrp -R oinstall /u01/app/oraInventory;
if [ $? != 0 ]; then
echo "OUI-10057:WARNING: chgrp of /u01/app/oraInventory to oinstall failed!";
fi
echo "The execution of the script is complete"
-------------------------
#!/bin/sh
#!/bin/sh
#
# $Id: rootmacro.sbs 15-may-2007.20:34:21 dchriste Exp $
# Copyright (c) 2004, 2007, Oracle. All rights reserved.
#
# root.sh
#
# This script is intended to be run by root. The script contains
# all the product installation actions that require root privileges.
#
# IMPORTANT NOTES - READ BEFORE RUN
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¡¾AUTOTRACE¡¿SQLÓÅ»¯µÄÖØÒª¹¤¾ß--AUTOTRACE
Ìáµ½SQLÓÅ»¯£¬²»Äܲ»ÌáAUTOTRACEµÄÇ¿´ó¹¦ÄÜ¡£Ê¹ÓÃÆðÀ´·Ç³£±ã½Ý£¬²»¹ýÔÚÊÇʹÓÃ֮ǰ£¬ÐèÒª×öһЩÅäÖõŤ×÷¡£¼òÒªµÄÃèÊöÒ»ÏÂÕâ¸ö¹ý³Ì£¬¹©Ã»ÓÐʹÓùýµÄÅóÓѲο¼¡£
1.ʹÓÃsysÓû§Ö´ÐÐplustrce½Å±¾
sys@ora10g> @?/sqlplus/admin/plustrce
sys@ora10g> drop role plustrace ......
10053ʼþÊÇoracleÌṩµÄÓÃÓÚ¸ú×ÙsqlÓï¾ä³É±¾¼ÆËãµÄÄÚ²¿Ê¼þ£¬
ËüÄܼÇÔØCBOģʽÏÂoracleÓÅ»¯Æ÷ÈçºÎ¼ÆËã sql³É±¾£¬Éú³ÉÏàÓ¦µÄÖ´Ðмƻ®¡£
ÈçºÎÉèÖÃ10053ʼþ
ÉèÖñ¾sessionµÄ10053
¿ªÆô£º
Alter session set events’10053 trace name context forever[,level {1/2}]’;
¹Ø±Õ£º
Alter session set events& ......
--ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ£¿
2006/2/16 zhanghua first create
Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚora ......
Ò»¡¢Á¬½Ó¹æÔò£¬Ò»ÇвÙ×÷µÄǰÌá¡£ µÍ°æ±¾¿Í»§¶ËÄܹ»Á¬½Óµ½Í¬Ñù°æ±¾»òÕ߸ü¸ß°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimpºÍexp²Ù×÷¡£ ¸ß°æ±¾¿Í»§¶Ë²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimp»òÕßemp²Ù×÷¡£ ¶þ¡¢»ìºÏʹÓùæÔò£¬Ç°ÌáÊÇÒªÂú×ãÁ¬½Ó¹æÔò¡£ µÍ°æ±¾exp³öµÄdmpÎļþ£¬Óø߰汾Äܹ»imp½øÈ¥¡£ ¸ß°æ±¾exp³öµÄdmpÎļþ£¬µÍ°æ±¾µÄimp¹¤¾ß² ......