start oracle with the linux opening
1.ÐÞ¸Ä/etc/oratab £¬Ìí¼Ó$ORACLE_SID:$ORACLE_HOME:Y --
Y´ú±íOSÆô¶¯ÔòDBÆô¶¯±ØÐëÉèÖÃΪY£¬·ñÔòdbstartºÍdbstop²»¿ÉÓã¬NΪ²»Æô¶¯£¬$ORACLE_SIDÊÇDB
SID£¬$ORACLE_HOMEÊÇDB ¾ø¶Ô·¾¶
2.ÐÞ¸Ä/etc/rc.d/rc.loacl,¼ÓÈëÒÔÏ£º
#listener command
COMM_LISTENER=/opt/oracle/product/10.2.0/db_1/bin/lsnrctl
LISTENER_NAME=orctest
su - oracle -c "$COMM_LISTENER start $LISTENER_NAME"
COMM_START=/opt/oracle/product/10.2.0/db_1/bin/dbstart
su - oracle -c "$COMM_START"
echo $COMM_START
ÖØÆô¼´¿É¿´µ½Êý¾Ý¿âºÍ¼àÌýÒѾÆô¶¯¡£
##################################################
1. ´´½¨Îļþ/etc/oratab
#Ìí¼ÓÈçÏÂÄÚÈݵ½/etc/oratabÎļþÖÐ,
#$ORACLE_SIDÊÇÄãµÄOracleÊý¾Ý¿âµÄsid
#$ORACLE_HOMEÊÇÄãµÄOracleÊý¾Ý¿âµÄOracle_home
#Y±íʾҪÇóÔÚϵͳÆô¶¯µÄʱºòÆô¶¯OracleÊý¾Ý¿â.N±íʾ²»ÒªÔÚϵͳÆô¶¯µÄʱºòÆô¶¯Oracle
¸ÄÒÔÏÂΪ
# *:/data/opt/app/oracle/app:N# db1:/data/opt/app/oracle/app:N
*:/data/opt/app/oracle/app:Ydb1:/data/opt/app/oracle/app:Y
2. ÐÞ¸ÄÎļþ/etc/rc.localÌí¼ÓÒ»ÏÂÁ½ÐÐ
su - oracle -c 'dbstart'
su - oracle -c 'lsnrctl start '
3.ÐÞ¸ÄdbstartÕâ¸öÆô¶¯ÎļþµÄoratabµÄĿ¼Ϊ/etc/oratab,ĬÈϵÄÎļþĿ¼ÊDz»¶ÔµÄ¡£Ò»¶¨Òª¸Ä¡£
#ORATAB=/var/opt/oracle/oratab
ORATAB=/etc/oratab
Ö»ÐèÐÞ¸ÄÒÔÉϾͿÉÒԳɹ¦ÁË¡£ºÜEASY!
#######################################################
=== 5. ÉèÖÃÊý¾Ý¿â×Ô¶¯Æô¶¯ ===
-- 5.1 --
±à¼Îļþ /etc/oratab£¬½«“N”ÐÞ¸ÄΪ“Y”
oradb1:/oracle/product/10.2.0:Y
-- 5.2 --
È·ÈÏoracleÓû§ÄÜ·ñÓÃϵͳ×Ô´øµÄShell³ÌÐòdbstart, dbshutÕý³£Æô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¬ÒÔoracle
Éí·ÝÖ´ÐÐ dbstart dbshut
-- 5.3 ½¨Á¢Æô¶¯Shell --
ÒÔrootÉí·Ý£¬ÔÚ /etc/rc.d/init.d Ŀ¼Ï½¨Á¢Îļþ oracle£¬ÄÚÈÝΪ£º
#!/bin/sh
OPT_=$1
case "$OPT_" in
start)
/bin/echo "$0 : (start)"
#
# Your service startup command goes here.
#
su - oracle -c "/oracle/product/10.2.0/bin/lsnrctl start"
su - oracle -c "/oracle/product/10.2.0/bin/dbstart"
# NOTE: Must exit with zero unless error is severe.
chmod 177
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌṩÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
Óï·¨:
select *
from [TABLE] as of timestamp
to_timestamp('ʱ¼ä', ’ʱ¼ä¸ñʽ')
×÷Óãº
²éѯij¸öʱ¼äµãµÄÊý¾Ý£¬ÔÚÕâ¸öʱ¼äµãÖ®ºó£¬Êý¾Ý¸ü¸ÄÒѾÌá½»ÁË¡£
¿ÉÒÔÓÃÀ´¸üÕýÓû§¶ÔÊý¾ÝµÄÎó²Ù×÷
¿ÉÒÔÓÃÀ´»ñÈ¡Êý¾ÝµÄ¸ü¸ÄÇé¿ö£¬±ÈÈçƵÂʵÈ
ÔÀí£º
µ±Êý¾Ýupdate»òdeleteʱ£¬ÔÀ´µÄÊý¾Ý ......
2007Äê12ÔÂ05ÈÕ ÐÇÆÚÈý 05:36
Linux×ö´úÀíÉÏÍø·þÎñÆ÷
Linux×ö´úÀíÉÏÍø·þÎñÆ÷--Ë͸øÄÇЩÏëÓÃLinux×öÍø°É´úÀíÉÏÍø·þÎñÆ÷µÄÅóÓÑ
Ê×ÏÈÉùÃ÷£¬»áÕâ¸öµÄÀÏÄñ²»Óÿ´£¬ÎÒÕâÖ»ÊǸøÐÂÊÖ¿´µÄ
Ê×ÏÈ°²×°ºÃLinux£¬×¼±¸Ò»Ì¨ÓÐÁ½¿éÍø¿¨µÄ·þÎñÆ÷£¬Ò»Íø¿¨½ÓÄÚÍø£¬ÁíÒ»Íø¿¨½ÓÍâÍø£¬±ÈÈçÍø°ÉÍâÍøIPΪ61.178.89.234 ÄÚÍøIP¶ÎΪ192.16 ......
ZZTµÄ£¬×ö¸ö±Ê¼Ç¡£ÒÔ±¸²é¿´¡£
linuxÏÂConfigureÃüÁî
http://hi.baidu.com/wanyinglong/blog/item/3d4eb9fd08d5a91e08244d34.html
2009-04-19 22:18
‘configure’½Å±¾ÓдóÁ¿µÄÃüÁîÐÐÑ¡Ïî.¶Ô²»Í¬µÄÈí¼þ°üÀ´Ëµ,ÕâЩѡÏî¿ÉÄÜ»áÓб仯,µ«ÊÇÐí¶à»ù±¾µÄÑ¡ÏîÊDz»»á¸Ä±äµÄ.´øÉÏ’–help’ Ñ¡ ......