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 Ê ......
ÔÚWindowsËÞÖ÷»úÖÐÌí¼Ó¹²ÏíÎļþ¼Ð
1.Ñ¡Ôñ ÐéÄâ»ú ¡µÉèÖÃ
2.Ñ¡Ôñ Ñ¡Ïî
3.µãÑ¡ ¹²ÏíÎļþ¼Ð
4.µã»÷Add°´Å¥ ´ò¿ª¹²ÏíÎļþ¼ÐÏòµ¼ ²¢µãÏÂÒ»²½
5.ÊäÈë¹²ÏíÎļþ¼ÐÃû×ÖºÍλÖà ²¢µãÏÂÒ»²½
Name —— Õâ¸öÃû×Ö½«³öÏÖÔÚÐéÄâ»úÄÚ
Host folder —— ÔÚËÞÖ÷»úÖÐÄãÏë¹²ÏíµÄÎļþ¼Ð· ......
zipÊǸöʹÓù㷺µÄѹËõ³ÌÐò£¬Îļþ¾ËüѹËõºó»áÁíÍâ²úÉú¾ßÓД.zip”À©Õ¹ÃûµÄѹËõÎļþ¡£
linux zip ÃüÁîÏê½â
¹¦ÄÜ˵Ã÷£ºÑ¹ËõÎļþ¡£
Óï·¨£ºzip [-AcdDfFghjJKlLmoqrSTuvVwXyz$][-b <¹¤×÷Ŀ¼>][-ll][-n <×Öβ×Ö·û´®>][-t <ÈÕÆÚʱ¼ä>][-<ѹËõЧÂÊ>][ѹËõÉú³ÉÎļþ][Ô´Îļþ][-i <·¶±¾ ......
ÀûÓÃsocket±àдwindowsºÍlinuxͨѶ³ÌÐò
socket±à³Ì´ó¼Ò¶¼ºÜÊìϤ£¬ÎÒÔÚÕâÀï¾Í²»ÔÙÂÞàÂÁË¡£Ö±½ÓÇÐÈëÕýÌâ¡£¸Ã³ÌÐò·ÖÁ½²¿·Ö£¬server¶ËºÍclient¶Ë£¨Ë¶¼ÖªµÀ£©¡£ÆäÖÐserver¶Ë²ÉÓÃwindowsƽ̨£¬ÄÇlinuxƽ̨µ±È»ÊÇclient¶ËÁË¡£
ÕâÀïÊÇserver¶Ë³ÌÐò£º
/**********************************/
/* it work ......