linuxÏÂoracleÆô¶¯¹ý³Ì
ÔÚlinuxÏÂÆô¶¯oracle ºÍÔÚwindowsÊÇÓвî±ðµÄ£¬¶ÔÓÚÒ»°ãÔÚwindowsϲÙ×÷ϰ¹ßÈËÓкܶ಻ÊÊÓ¦£¬ËùÒÔÎÒÌØ±ðдÕâÑùÎÄÕ£¬ÒÔ·½±ãÐÂÊÖ½øÐвÙ×÷£¬ÏÂÃæ¾ÍÒ»²½Ò»²½½²½âÆô¶¯¹ý³Ì¡£
1.ͨ¹ýÖÕ¶ËÁ¬½Óµ½linux·þÎñÆ÷,µ±È»ÕâÑùµÄÈí¼þºÜ¶àÀýÈçputty,SecureCRT,²¢ÒÔoracleÓû§½øÐеǼ£¬·ñÔòÆô¶¯oracleʱ»á´íµÄ£¬Ã»ÓÐȨÏÞÆô¶¯.(Ò²¿ÉÓû§root µÇ¼£¬È»ºó½øÐÐ su - oracle )
2.Óû§sysÁ¬½ÓÊý¾Ý¿â,°´ÒÔÏÂÃüÁîÖ´ÐС£
a.sqlplus /nolog ;
b.conn sys/passwd as sysdba;
3.Æô¶¯Êý¾Ý¿â,ÒòΪÆô¶¯·½Ê½ÓкܶàÖÖ±ÈÈçÓÃpfile,spfile£¬ÕâÀïÎҾͲ»Ïêϸ½²½â¾ßÌåµÄÆô¶¯·½Ê½ÁË£¬ÒÔ×î¼òµ¥µÄΪÀý½øÐн²½â£¬startup½øÐÐÆô¶¯£¨Êµ¼ÊÊÇÒÔspfile ½øÐÐÆô¶¯),ÔÚÌáʾÏÂÔËÐÐ.
startup
(×¢Ã÷£¬Ò»°ãÆô¶¯»áÓÐÈý²½¶ÔÓ¦Êý¾Ý¿âÒª×öµÄÈý¼þÊÂ.
a.startup nomount ´ò¿ªÊµÀý
b.alter database mount ×°ÔØÊý¾ÝÎļþ
c.alter database open ´ò¿ªÊý¾ÝÎļþ
)
4.Æô¶¯ÍêÊý¾Ý¿âÒ»°ãÇé¿öÏ¿ͻ§¶Ë»¹²»ÄÜÁ¬½Óµ½·þÎñÆ÷£¬ÎÒÃÇÒªÆô¶¯¼àÌý³ÌÐò¡£½«µÚ3²½Í˳ösqlplus µ½ÃüÁîÌáʾ·û£¬½øÐÐÆô¶¯¼àÌý£¬Ö´ÐÐÃüÁîÈçÏÂ.
a.lsnrctl (´òÁÙÌý³ÌÐò)
b.status ( ²é¿´¼àÌý״̬)
c.start (Æô¶¯¼àÌý)
d.stop (¹Ø±Õ¼àÌý)
Èç¹ûÉÏÊöûÓÐÎÊÌ⣬ÎÒÃǾͿÉÒÔ¸ùÆô¶¯µÄÏÔʾÐÅÏ¢ÅäÖÃÎÒÃǵĿͻ§¶ËµÄtnsÎļþÁË¡£
5. tnsnames.¸ñʽÎļþÈçÏÂ(SERVICE_NAMEÒªÓë·þÎñÆ÷µÄ¼àÌýʵÀýÃû±£³ÖÒ»ÖÂ)
# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.98)(PORT = 1566))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
ORACLE11 =
(DESCRIPTION =
(ADDRESS_LIST =
Ïà¹ØÎĵµ£º
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
ÎÒµÄϵͳÊÇredhat as5 ½¨Òé´ó¼ÒÍêÈ«°²×°£¬ÒÔÃⰲװʱȱÉÙÏà¹ØµÄ±àÒëÆ÷µÈµÈ¡£
Ò»¡¢°²×°mysql£¨mysql-5.0.21.tar.gz£©
# tar zxf mysql-5.0.21.tar.gz
# cd mysql-5.0.21
#./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql/
˵Ã÷£º
#prefix=/usr/lo ......
×÷Õß: Óð·É | ·¢²¼Ê±¼ä: ÐÇÆÚÌì, 01/24/2010 - 16:23
ÔÚÍøÉÏÕÒÒ²ºÃ¶à¹ØÓÚÕâ·½ÃæµÄ×ÊÁÏ£¬µ«¶¼Ã»ÓÐÒ»¸ö¿ÉÒÔÓõģ¬
×Ô¼ºÑо¿ÁËһϣ¬ÍêÈ«¿ÉÒÔʵÏÖ£¬Ö»Òª°´ÕÕÒÔϲ½Öè×öÁË£¬°üÄãÄܰÑCentOSÇë»Ø¼Ò
ƽ̨Windows XP£» ËùÐèÈí¼þgrub4dos-0.4.3.zip£» CentOS¾µÏñÎļþDVD¡£
1.ÔÚWindows X ......
´ÓÓû§´ò¿ªµçÔ´µ½Óû§¿ÉÒԵǼµÄÕâ¶Ì¶ÌµÄÒ»¶Îʱ¼äÄÚ£¬Red Hat Enterprise Linuxµ½µ×¶¼×÷ÁËÄÄЩÊÂÇ飬ֻÓÐÖªµÀÁËÕâЩÊÂÇ飬Óû§ÔÚÒÔºóµÄʹÓùý³ÌÖУ¬Èç¹û³öÏÖÁËһЩÎÊÌ⣬ÎÒÃÇ¿ÉÒÔ½èÖúÕâЩ¹ý³ÌÀ´ÎªÎÒÃÇÅųýһЩ¹ÊÕÏ¡£
Red Hat Enterprise LinuxÔÚµçÄÔµÄÆô¶¯½×¶Î£¬Ò»¹²¾ÀúÒÔÏÂÁ½¸ö½×¶Î£¬Èçͼ1£º
BIOS×Ô¼ì
µ±µçÄÔ¿ª»úµÄʱº ......
×î½üÒ»Ö±ÔÚæÏîÄ¿£¬×öµÄ¹ý³ÌÖÐÓöµ½Ò»¸öºÜ¾À½áµÄÊÂÇé¡£ÐèÒªÓÃshell½Å±¾ÂÖѵÊý¾Ý¿â£¬Êý¾ÝÖ´ÐÐÍê±ÏÒÔºó²ÅÄܵ÷ÓÃÆäËûµÄshell½Å±¾¡£ÔÚÕâÀï×ܽáһϣ¬Óë´ó¼Ò¹²Ïí¡£
½Å±¾ÈçÏ£º
shell ½Å±¾ÈçÏ£º
#!/bin/sh
SQL_DIR=/home/tang/tek/sql/tek
SHELL_DIR=/home/tang/tek/sh/tek
LOG_DIR=/home/tang/tek/logs
. /home/tang/.bas ......