Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£©¸ÅÊö
¢Ù ¿ØÖÆÎļþÊÇOracleÊý¾Ý¿â×îÖØÒªµÄÎïÀíÎļþ¡£
¢Ú ÿ¸öOracleÊý¾Ý¿â¶¼±ØÐëÓÐÒ»¸ö¿ØÖÆÎļþ¡£
¢Û ÔÚ×°ÔØ£¨mount£©Êý¾Ý¿âʱ£¬Oracle»á¸ù¾Ý³õʼ»¯²ÎÊý¶¨Î»¿ØÖÆÎļþ¡£
¢Ü ÔÚÆô¶¯Àý³Ìʱ£¬Oracle»á¸ù¾Ý¿ØÖÆÎļþÔÚÀý³ÌºÍÊý¾Ý¿âÖ®¼ä½¨Á¢¹ØÁª¡£
¢Ý ´ò¿ªÊý¾Ý¿âʱ£¬Oracle»á¸ù¾Ý¿ØÖÆÎļþËù¼ÇÔ ......

64λwin7°²×°Ê¹ÓÃPL/SQL developerÁ¬½ÓOracle 10g±¸Íü

ÔÚÍøÉÏËÑË÷Á˰ëÌ죬Ö÷ÒªÔ­ÒòÊÇoci.dllÊÇ64λµÄ,¶øPL/SQL developerÖ»ÓÐ32λµÄ,ÔÚʹÓÃ64λoci.dllÎļþʱ³ö´í.
ÔÚÍøÉÏÕÒÁ˺ܶà×ÊÁÏ,×î·½±ãµÄ½â¾ö·½°¸ÈçÏÂ:
1.µ½oracle¹ÙÍøÏÂÔØOracle InstantClient,ÎÒϵÄÊÇinstantclient-basiclite-win32-10.2.0.4.zip,°ÑËü½âѹËõµ½
oracle°²×°Ä¿Â¼productÏÂ,ÆäÖл¹ÓÐÒ»¸öĿ¼Ϊ10.2.0. ......

¡¾Oracle¡¿SQLÓÅ»¯µÄÖØÒª¹¤¾ß AUTOTRACE

¡¾AUTOTRACE¡¿SQLÓÅ»¯µÄÖØÒª¹¤¾ß--AUTOTRACE
Ìáµ½SQLÓÅ»¯£¬²»Äܲ»ÌáAUTOTRACEµÄÇ¿´ó¹¦ÄÜ¡£Ê¹ÓÃÆðÀ´·Ç³£±ã½Ý£¬²»¹ýÔÚÊÇʹÓÃ֮ǰ£¬ÐèÒª×öһЩÅäÖõŤ×÷¡£¼òÒªµÄÃèÊöÒ»ÏÂÕâ¸ö¹ý³Ì£¬¹©Ã»ÓÐʹÓùýµÄÅóÓѲο¼¡£
1.ʹÓÃsysÓû§Ö´ÐÐplustrce½Å±¾
sys@ora10g> @?/sqlplus/admin/plustrce
sys@ora10g> drop role plustrace ......

oracleÖе¼Èëµ¼³ödmpÊý¾Ý¿âÎļþ

OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃü Áî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
¡¡¡¡Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ