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 =
Ïà¹ØÎĵµ£º
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 Ê ......
×÷Õß: Óð·É | ·¢²¼Ê±¼ä: ÐÇÆÚÌì, 01/24/2010 - 16:23
ÔÚÍøÉÏÕÒÒ²ºÃ¶à¹ØÓÚÕâ·½ÃæµÄ×ÊÁÏ£¬µ«¶¼Ã»ÓÐÒ»¸ö¿ÉÒÔÓõģ¬
×Ô¼ºÑо¿ÁËһϣ¬ÍêÈ«¿ÉÒÔʵÏÖ£¬Ö»Òª°´ÕÕÒÔϲ½Öè×öÁË£¬°üÄãÄܰÑCentOSÇë»Ø¼Ò
ƽ̨Windows XP£» ËùÐèÈí¼þgrub4dos-0.4.3.zip£» CentOS¾µÏñÎļþDVD¡£
1.ÔÚWindows X ......
×î½üÒ»Ö±ÔÚæÏîÄ¿£¬×öµÄ¹ý³ÌÖÐÓöµ½Ò»¸öºÜ¾À½áµÄÊÂÇé¡£ÐèÒªÓÃ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 ......
/*
* linux/kernel/floppy.c
*
* (C) 1991 Linus Torvalds
*/
/*
* 02.12.91 - Changed to static variables to indicate need for reset
* and recalibrate. This makes some things easier (output_byte reset
* checking etc), and means less i ......