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
Ïà¹ØÎĵµ£º
ÒÔǰÓиöÏîÄ¿½«Óû§±í½¨Á¢ÔÚÁËsystemÓû§ËùÊôÏ£¬ºóÀ´·¢¾õΣº¦Ï൱´ó£¬×¼±¸½«±í¶ÔÏó×ªÒÆµ½Ð½¨Á¢µÄLANDÓû§Ï£¬Ã»ÕÒµ½Ö±½ÓµÄ°ì·¨£¬ÓÃÒÔϰ취µÃÒÔʵÏÖ£º
1¡¢½¨Á¢ÐµÄLANDÓû§£¬ÔÚ·þÎñÆ÷µÄOracle Enterprise ManagerÀï·ÖÅä ¶ÔÏóȨÏÞ £¬Ìí¼Ó¶ÔsystemÖÐÊý¾Ý±í¶ÔÏóµÄ select ȨÏÞ¡£
2¡¢ÒÔ LAND Óû§µÇ¼£¬Ê¹ÓÃÃüÁ ......
µ±ÎÒÃÇ»ñÈ¡Êý¾Ýʱ,¿ÉÄÜ»áÓÐÕâÑùµÄÐèÇó,¼´Ã¿´Î´Ó±íÖлñÈ¡Êý¾Ýʱ,ÊÇËæ»ú»ñȡһ¶¨µÄ¼Ç¼,¶ø²»ÊÇÿ´Î¶¼»ñȡһÑùµÄÊý¾Ý,ÕâʱÎÒÃÇ¿ÉÒÔ²ÉÈ¡OracleÄÚ²¿Ò»Ð©º¯Êý,À´´ïµ½ÕâÑùµÄÄ¿µÄ.
1) select * from (select * from tablename order  ......
Ê×ÏÈ£¬ÄãÒªÓÐÒ»ÕÅ±í£¡
CREATE TABLE example(
ID Number(4) NOT NULL PRIMARY KEY,
NAME VARCHAR(25 ......
DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐʲôÓÃÍ¾ÄØ£¿ Ïȹ¹ÔìÒ»¸öÀý×Ó£¬¼ÙÉèÎÒÃÇÏë¸øÖÇÐÇÖ°Ô±¼Ó¹¤×Ê£¬Æä±ê×¼ÊÇ£º¹¤×ÊÔÚ8000ÔªÒÔϵĽ«¼Ó20£¥£»¹¤×ÊÔÚ8000ÔªÒÔÉϵļÓ15£¥£¬Í¨³£µÄ×ö·¨ÊÇ£¬ÏÈÑ¡³ö¼Ç¼ÖеŤ×Ê×Ö¶ÎÖµ? select s ......