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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
¡öÀÖÖª
“ËÊÇ˵ÄË”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......
ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......