oracle ¼àÌýÅäÖÃ
ÎÒÏàÐÅÎÒÃǸÕѧoracle£¬¶ÔÊý¾Ý¿âµÄ²Ù×÷£¬¶¼ÊÇÔÚ±¾µØ½øÐеģ¬Ö»Òª±£Ö¤¼àÌý·þÎñÆô¶¯£¬ÄÇôÎÒÃǾͿÉÒÔÕý³£Ê¹ÓÃsqlplus¶ÔÊý¾Ý¿â½øÐвéѯ£¬µ«ÊǼÙÈçÎÒÃÇÏ£Íûͨ¹ýÔ¶³Ì¶ÔÊý¾Ý¿âÀ´·ÃÎÊÄØ£¬´ËʱÎÒÃǾÍÒª¶Ôoracle¼àÌý½øÐÐÅäÖá£
oracle¼àÌýÅäÖÃÓÐÈý¸öÎļþ£¬ÎªÁË·½±ãÃèÊö£¬ÎÒÓÃserverºÍclientÀ´Çø·Ö£¬¸üÈÝÒ×Çø·Ö¡£¼àÌýÅäÖÃÎļþ·ÅÔÚ oarcle\prdouct\10.2.0\db_1\network\admin Ŀ¼Ï£¬
listener.ora ÊÇoracleÊý¾Ý¿âËùÔÚ±¾»úµÄ¼àÌýÅäÖã¬Ï൱ÓÚSERVER
sqlnet.oraºÍtnsname.ora ÊÇÔ¶³Ì¿Í»§¶ËµÄ¼àÌýÅäÖã¬Ï൱ÓÚcilent
ÎÒÃÇÒªÏëÔ¶³ÌµÇ¼Êý¾Ý¿â£¬¿ÉÒÔÊÖ¶¯ÔÚserver¶ËºÍcilent¶ËÊÖ¹¤ÅäÖÃÕâÈý¸öÎļþ£¬µ±È»oracleºÜÈËÐÔ»¯£¬ËüҲΪÎÒÃÇÕâЩ³õѧÕß×¼±¸ÁËͼÏñ½çÃæÅäÖù¤¾ß£¬net configuration assistant ºÍnet manager
net configuration assitant ¾ßÓÐÏòµ¼µÄ¹¦ÄÜ£¬ÅäÖúú󣬲»ÓÃÖØÆð¼àÌý·þÎñ
net manager ÅäÖúúó£¬ÐèÒªÖØÆô¼àÌý·þÎñ
ÎÒÕâÀïÖ÷ÒªÃèÊönet mangerÅäÖã¬ÔÚ¿Í»§¶Ë£¬ÎÒÃÇÆô¶¯net manager ÐÞ¸ÄÁ½¸öµØ·½£¬¸ÅÒªÎļþ£¨sqlnet.ora£©ºÍ·þÎñÃüÃû£¨tnsname.ora£©£¬sqlnet.oraÒ»°ã²»ÓÃÐ޸ģ¬Ä¬Èϼ´¿É£¬tnsname.oraÐèÒªµã»÷×ó±ß“+“н¨Ò»¸ö¼àÌý£¬·þÎñÃû¾ÍÊÇÊý¾Ý¿âµÄÃû³Æ£¬
·þÎñÆ÷Ãû£¬¾ÍÊÇÊý¾Ý¿â±¾µØµÄ¼ÆËã»úÆ÷Ãû£¬¶Ë¿ÚΪ1521¼´¿É¡£
ÎÒÃÇÔÚÑé֤ʱ£¬¿ÉÒÔÀûÓÃtnsping + Êý¾Ý¿âÃû£¬²éÖ¤Á¬½Ó£¬ÓÃsqlplusµÇ¼ʱ£¬ÐèÒªÔÚÓû§ÃûºÍÃÜÂëºóÃæ¼ÓÉÏÊý¾Ý¿âÃû³Æ£¬Èç
sqlplus " system/manager@orcl"
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......