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

solarisÏÂoracle×ÔÆô¶¯

SolarisÉÏOracle×Ô¶¯Æô¶¯ÉèÖÃ
===========================================================
×÷Õß: tianying(http://tianying.itpub.net)
·¢±íÓÚ: 2005.04.03 21:51
·ÖÀà: ³õʼ·ÖÀà
³ö´¦: http://tianying.itpub.net/post/2852/24823
---------------------------------------------------------------
¸ÕÔÚһ̨solarisÉÏ×°ÁËoracle9i£¬¶ÔÓÚoracleÔÚsolarisÉϵÄ×Ô¶¯Æô¶¯ÉèÖúܸÐÐËȤ£¬Ñо¿ÁËһϡ£×ܽáÈçÏ£º
Ò»¡¢SolarisÉÏ¿ª»ú×Ô¶¯Æô¶¯
SolarisÔÚ¿ª¹Ø»úʱ£¬»á×Ô¶¯ÔËÐÐ/etc/rc.dĿ¼ÏµÄËùÓнű¾¡£ÆäÖÐNÔ½´ó£¬Ö´Ðеļ¶±ðÔ½¸ß¡£ÆäÖУ¬S¿ªÍ·µÄ½Å±¾ÔÚ¿ª»úʱ×Ô¶¯ÔËÐУ¬K¿ªÍ·µÄ½Å±¾Ôڹػúʱ×Ô¶¯ÔËÐС£
¶þ¡¢OracleÉÏµÄÆô¶¯½Å±¾
½Å±¾¿ÉÊÖд£¬»òʹÓÃOracle×Ô´øµÄÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿âµÄ½Å±¾¡£
Oracle×Ô´ø½Å±¾£º$ORA_HOME/bin/dbstart¡¢$ORA_HOME/bin/dbshut
×¢Ò⣺dbstartÖеIJÎÊýPFILE¿ÉÄÜ´æÔÚÎÊÌ⣨OracleĬÈϲ»Ê¹ÓÃpfileÆô¶¯£©£¬ÐèÊÖ¶¯Ð޸ġ£
Èý¡¢ÉèÖÃOracle×Ô¶¯Æô¶¯²½Ö裨ʹÓÃOracle×Ô´ø½Å±¾£©
1¡¢ÐÞ¸Ädbstart¡¢dbshut½Å±¾£¬±£Ö¤Ö±½ÓÔËÐÐʱ¿ÉÆô¶¯¹Ø±ÕÊý¾Ý¿â
2¡¢½«µ÷ÓÃdbstart¡¢dbshutµÄ½Å±¾dbora·ÅÖÃÔÚ/etc/init.dĿ¼Ï£¬dboraµÄÄÚÈÝÈçÏ£º
#!/bin/sh
ORA_HOME=/export/home/oracle/app/oracle/products/9.2.0
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup:cannot start"
exit
fi
case "$1" in
'start' )
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart &
/etc/init.d/dblsnrctl.sh
;;
'stop' )
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut &
;;
esac
3¡¢½«Æô¶¯lsnrctlµÄ½Å±¾dblsnrctl.sh£¨½Å±¾dbora½«µ÷Óô˽ű¾£©·ÅÖÃÔÚ/etc/init.dĿ¼Ï£¬dblsnrctl.shÄÚÈÝÈçÏ£º
su - oracle


Ïà¹ØÎĵµ£º

oracle uptimeµÄbug

Ö¢×´£ºoracle sqlplusû·´Ó¦
oracle10gµÄÓÐÊ®¼¸¸ö»úÆ÷¿Í»§¶Ë10.2.0.1.0£¬Ö´ÐÐsqlplusÕâ¸öÃüÁîû·´Ó³¡£´ËʱcpuʹÓÃΪ99.9%£¬¹Û²ìÁËÒ»»á£¬²»ÊÍ·Å¡£
oracleÆäËûÃüÁî¶¼ºÃʹ¡£
»·¾³±äÁ¿¡¢ping tnsnameµÈ¶¼Ã»ÎÊÌâ¡£¡£ÇÒÕâЩ»úÆ÷¶¼ÊÇÖÁÉÙÔËÐÐÁË200¶àÌì×óÓÒ£¬
µ«Ò»µ©ÖØÆôOS¾ÍºÃʹÁË¡£¡£
»òÕß²»ÖØÆôOS£¬»»³É9iµÄ¿Í»§¶Ë£¬sqlplus ......

ÈçºÎ½â¾ö¾ÖÓòÍøÖÐWindows·À»ðǽ²»ÄÜ·ÃÎÊOracleÎÊÌâ!


Èç¹ûÄãÊÇWINXP»òWIN2003µÄϵͳÖÐ×Ô´øµÄ·À»ðǽ,¿ÉÒÔÊÔÒ»ÏÂÒÔÏ·½·¨:
1.ÔÚ·À»ðǽµÄÀýÍâÖÐ,Ìí¼ÓORACLE.EXEÔËÐгÌÐò.(ÔÚoracle°²×°Ä¿Â¼ÕÒµ½binÎļþ¼ÐÖÐ)
2.ÔÙÔÚ·À»ðǽÀýÍâÖУ¬Ìí¼Ó¶Ë¿Ú1521¶Ë¿Ú¾ÍÑù¾ÖÓòÍøÄ򵀮äËû»úÆ÷¾Í¿ÉÒÔ·ÃÎÊÄãµÄORACLEÁË.
»òÕßÔڸ߼¶ÖÐ,Ñ¡Öе±Ç°Ê¹ÓõÄÍø¿¨,Ìí¼ÓIP,¶Ë¿ÚºÅ(1521),ÕâÑù,ÆäËû»úÆ÷Ò²¿ÉÒÔ·ÃÎ ......

oracleµ¼ÈëÎı¾Îļþ

1.ʹÓÃsqlldr
2.Ê×ÏȽ¨Á¢ÏàÓ¦µÄ±í
create table test(ip1 number, ip2 number, locate varchar2(512),country varchar2(60),province varchar2(60),city varchar2(60))
3.д¿ØÖÆÎļþ city.ctl
load data
infile 'c:\city.txt'
append into table test
--when country='Öйú'
fields terminated by ','
(
ip1,
ip ......

Oracle Decodeº¯ÊýµÄÓ÷¨

DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐʲôÓÃÍ¾ÄØ£¿ Ïȹ¹ÔìÒ»¸öÀý×Ó£¬¼ÙÉèÎÒÃÇÏë¸øÖÇÐÇÖ°Ô±¼Ó¹¤×Ê£¬Æä±ê×¼ÊÇ£º¹¤×ÊÔÚ8000ÔªÒÔϵĽ«¼Ó20£¥£»¹¤×ÊÔÚ8000ÔªÒÔÉϵļÓ15£¥£¬Í¨³£µÄ×ö·¨ÊÇ£¬ÏÈÑ¡³ö¼Ç¼ÖеŤ×Ê×Ö¶ÎÖµ? select s ......

Oracleº¯Êýmerge

°ÑÊý¾Ý´ÓÒ»¸ö±í¸´ÖƵ½ÁíÒ»¸ö±í£¬²åÈëÐÂÊý¾Ý»òÌæ»»µôÀÏÊý¾ÝÊÇÿһ¸öORACLE DBA¶¼»á¾­³£Åöµ½µÄÎÊÌâ¡£ÔÚORACLE9iÒÔǰµÄÄê´ú£¬ÎÒÃÇÒªÏȲéÕÒÊÇ·ñ´æÔÚÀÏÊý¾Ý£¬Èç¹ûÓÐÓÃUPDATEÌæ»»£¬·ñÔòÓÃINSERTÓï¾ä²åÈ룬Æä¼äÉÙ²»ÁË»¹ÓÐһЩ±ê¼Ç±äÁ¿µÈµÈ£¬·±ËöµÄºÜ¡£ÏÖÔÚORACLE9iרΪÕâÖÖÇé¿öÌṩÁËMERGEÓï¾ä£¬Ê¹ÕâÒ»¹¤×÷±äµÃÒì³£ÇáËÉ£¬
MERGEÓï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ