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

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 10g ÒªµãÕûÀí Ö® ¹ÜÀí±í

¹ÜÀí±í
±íÊÇÕæÕý´æ´¢ÐÅÏ¢µÄ¶ÔÏó¡£
1 Êý¾ÝÀàÐÍ
£¨1£©ÊýÖµÀàÐÍ£ºÓÃÓÚ´æ´¢ÕûÊý¡¢¸¡µãÊý¡¢ÊµÊý¡£
     number£¨¾«¶È£¬·¶Î§£©¾«¶ÈÊÇÖ¸Êý×Ö¸öÊý×ܺͣ¬·¶Î§ÊÇָСÊýµãÓұߵÄλÊý¡£
 
£¨2£©×Ö·ûÀàÐÍ£ºÉùÃ÷°üº¬ÁË×Öĸ¡¢Êý×ÖÊý¾ÝµÄÁС£
      char£º´æ´¢¹Ì¶¨³¤¶È×Ö·û´®
&n ......

Oracle 10g ÒªµãÕûÀí Ö® ÉÁ»Ø£¨½öÏÞÓÚSQL*Plus£©

ÉÁ»Ø
1 ÌØÕ÷
ÉÁ»ØÊý¾Ý¿âÖ»ÊÇÂß¼­Êý¾ÝÔâµ½ÆÆ»µÊ±µÄÊֶΡ£
ÉÁ»ØÊý¾Ý¿âÈÕÖ¾±ØÐëÔÚÊý¾Ý¿â»Ö¸´ÇøÖд´½¨¡£
ÉÁ»ØÈÕÖ¾²»ÐèÒª¹éµµ£¬²»ÄÜÓÃÓÚÎïÀí»Ö¸´¡£
Ö´ÐÐÉÁ»ØÊý¾Ý¿â²Ù×÷ʱ£¬±³¾°½ø³ÌRVWR¾ÍÆô¶¯ÁË¡£
 
2 ʹÓÃÉÁ»ØÊý¾Ý¿â
3ÖÖ¹¤¾ß£¬SQL*Plus£¬RMAN£¬OEM¡£
£¨1£©ÒªÇó
ΪÁËʹÓÃÉÁ»ØÊý¾Ý¿â£¬Êý¾Ý¿â±ØÐë´¦Óڹ鵵ÈÕ־ģʽ¡ ......

Oracle 10g ÒªµãÕûÀí Ö® ¹ý³Ì¡¢º¯Êý¡¢³ÌÐò°ü¡¢´¥·¢Æ÷

¹ý³Ì¡¢º¯Êý¡¢³ÌÐò°ü¡¢´¥·¢Æ÷
 
1 ¹ý³Ì
£¨1£©¶¨ÒåÓï·¨
create [or replace ] procedure ¹ý³ÌÃû
[(²ÎÊý1 [in | out | in out] ²ÎÊýÀàÐÍ£¬
²ÎÊý2 [in | out | in out] ²ÎÊýÀàÐÍ£¬
……)]
is | as
begin
Ö´Ðв¿·Ö
exception
Òì³£´¦Àí²¿·Ö
end [¹ý³ÌÃû];
 
¹ý³ÌÖÐûÓÐdeclare²¿·Ö£¬ÉùÃ÷²¿ ......

oracle µ¼Èëµ¼³ö¹æÔò

Ò»¡¢Á¬½Ó¹æÔò£¬Ò»ÇвÙ×÷µÄǰÌá¡£ µÍ°æ±¾¿Í»§¶ËÄܹ»Á¬½Óµ½Í¬Ñù°æ±¾»òÕ߸ü¸ß°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimpºÍexp²Ù×÷¡£ ¸ß°æ±¾¿Í»§¶Ë²»ÄÜÁ¬½Óµ½µÍ°æ±¾µÄ·þÎñÆ÷ÉϽøÐÐimp»òÕßemp²Ù×÷¡£ ¶þ¡¢»ìºÏʹÓùæÔò£¬Ç°ÌáÊÇÒªÂú×ãÁ¬½Ó¹æÔò¡£ µÍ°æ±¾exp³öµÄdmpÎļþ£¬Óø߰汾Äܹ»imp½øÈ¥¡£ ¸ß°æ±¾exp³öµÄdmpÎļþ£¬µÍ°æ±¾µÄimp¹¤¾ß² ......

²é¿´Oracle±í¿Õ¼äʹÓÃÇé¿öSQLÓï¾ä

 select f.tablespace_name,a.total,u.used,f.free,round((u.used/a.total)*100) "% used", round((f.free/a.total)*100) "% Free"
from
(select tablespace_name, sum(bytes/(1024*1024)) total
from dba_data_files group by tablespace_name) a,
(select tabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ