windows Æô¶¯ oracle Åú´¦Àí½Å±¾
Oracle°²×°ºó£¬»á°Ñ4¸ö·þÎñÉèΪ×Ô¶¯Æô¶¯£¬·Ö±ðΪ£º
1. OracleOraHome90Agent
2. OracleOraHome90HTTPServer
3. OracleOraHome90TNSListener
4. OracleServiceORA
ÆäÖеڶþ¸ö²»ÊDZØÐëµÄ£¬¿ÉÒÔÔÚ·þÎñÀï°ÑËü½ûÓá£ÆäËûÈý¸öÔÚOracleÔËÐÐʱ¶¼ÒªÆô¶¯¡£
OracleµÄ½ø³Ì¶¼ÊdzÔÄÚ´æµÄÀÏ»¢£¬¿ÉϧÎÒÖ»ÓÐ512MµÄÄڴ涼Ҫ±ðËü³ÔÈ¥Ò»°ë£¬ÓÚÊDZã°ÑËùÓеÄOracle·þÎñ¶¼ÉèΪÊÖ¶¯£¬Ð´Ò»¸öÅú´¦ÀíÀ´Æô¶¯Oracle·þÎñºÍ¹Ø±ÕOracle·þÎñ£¬ÕâÑùÖ»ÓÐÒªÓõ½Oracleʱ²ÅÆô¶¯Ëü£¬ºÜ·½±ã¡£
Æô¶¯Oracle·þÎñµÄÅú´¦ÀíÈçÏ£º
@echo off
echo È·¶¨ÒªÆô¶¯OracleÂð£¿
pause
net start OracleOraHome90Agent
net start OracleOraHome90TNSListener
net start OracleServiceORA
Í£Ö¹Oracle·þÎñµÄÅú´¦ÀíÈçÏ£º
@echo off
echo È·¶¨ÒªÍ£Ö¹OracleÂð£¿
pause
net stop OracleOraHome90Agent
net stop OracleOraHome90TNSListener
net stop OracleServiceORA
ÆäÖÐ×îºóÒ»¸ö·þÎñµÄÃû³ÆºÍÄãµÄOracleÀý³ÌÃûÏà¹Ø£¬OraÊÇÎÒµÄOracleÀý³ÌÃû£¬Èç¹ûÀý³ÌÃû²»Ò»Ñù£¬ÄÇô°ÑOra»»³ÉÄãµÄÀý³ÌÃû¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
Ç°Á½Ì죬ÔÚ¿Í»§µÄÐéÄâ»úÉÏ°²×°oracleÈí¼þÓÃÓÚ²¿Êð×Ô¼ºµÄÓ¦ÓᣲÅ×°ºÃ²»¾Ã£¬ÓÉÓÚÐèÒªÅäÖÃÍøÂ簲ȫ£¬°ÑÕû¸öÐéÄâ»ú¶¼²ùµô£¬¿Ë¡Á˸öÅäÖúÃÍøÂ簲ȫµÄÐéÄâ»ú¸øÎÒÃÇʹÓã¬Ö»µÃÖØ×°oracle 10g¡£
µ±µÚ¶þ´ÎÔÚÐéÄâ»úÉÏ°²×°oracleʱ£¬Êý¾Ý¿âÃûºÍϵͳÕ˺ŵÄÃÜÂ붼×öÁ˸Ķ¯£¬½á¹ûÖ±½Óµ¼ÖÂÔÚ´´½¨oracleʵÀýʱµ¯³öora-12154´íÎó¡£Ñ¡Ôñ¡¾º ......
ORACLEÖеÄÊý¾Ý×ÖµäÊÇʲô£¿ÓÐʲôÌصãºÍ¹æÂÉ£¿
Êý¾Ý×Öµä¼Ç¼ÁËÊý¾Ý¿âµÄϵͳÐÅÏ¢£¬ËüÊÇÖ»¶Á±íºÍϵͳÊÓͼµÄ¼¯ºÏ¡£
Êý¾Ý×ÖµäµÄËùÓÐÕßÊÇSYSÓû§£¬Êý¾Ý×ֵ䶼±»´æ·ÅÔÚSYSTEM±í¿Õ¼ä£¬SYSÓû§µÄ·½°¸Ï¡£
Êý¾Ý×ÖµäÖ»ÔÊÐíSELECT²Ù×÷£¬Æäά»¤ºÍÐÞ¸ÄÈÎÎñÓÉÊý¾Ý¿â×Ô¶¯Íê³É¡£
µ±Óû§Ö´ÐÐCREATE¡¢ALTER¡¢DROP ......
»ùÓÚOCI ʵÏÖµÄ ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´Å ......
ÔÚ Windows ÉÏ°²×° Oracle Êý¾Ý¿â 11g
°²×°Oracle Èí¼þ£¬±ØÐëʹÓà Oracle Universal Installer¡£
1.ÔÚÕâÒ»°²×°ÖУ¬ÄúÐèҪʹÓà DVD »òÏÂÔØ DVD °æ±¾¡£ÔÚ±¾½Ì³ÌÖУ¬½«´ÓÒÑÏÂÔصİ汾½øÐа²×°¡£ÔÚ½âѹËõ DVD ÎļþµÄĿ¼ÖУ¬´ò¿ª Windows ×ÊÔ´ä¯ÀÀÆ÷²¢Ë«»÷ \db\Disk1 Ŀ¼µÄ setup.exe¡£
2.°²×°µÄ²úƷΪ Oracle Da ......
±¾ÎĵµÊÇOracle
Database 11.2.0.1 for RHEL5 Server(°üÀ¨x86ºÍx86_64ƽ̨)µÄ¾²Ä¬°²×°Ö¸ÄÏ. ËùÓвÙ×÷ÎÞÐèʹÓÃͼÐνçÃæ. ¾²Ä¬°²×°ÄܼõÉÙ°²×°³ö´íµÄ¿ÉÄÜÐÔ, Ò²ÄÜ´ó´ó¼Ó¿ì°²×°ËÙ¶È.
# ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂrootÓû§²Ù×÷; ºó¸úÃüÁî±íʾÒÔ²Ù×÷ϵͳÏÂoracleÓû§²Ù×÷;
1.1 ÉÏ´«Èí¼þ
¼ÙÈç·ÅÔÚ/wangnc/oracle/11g/Ä ......