.batÆô¶¯Êý¾Ý¿â·þÎñ(MSSQL,Oracle)
@echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ
echo.
echo [1]Æô¶¯Sql Server2005 [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i [4]¹Ø±ÕOracle9i
echo.
echo ÆäËü¼üÍ˳ö±¾³ÌÐò
echo.
set /P CHS= ÇëÑ¡Ôñ·þÎñ: [1],[2],[3],[4]
if /I "%CHS%"=="1" (
goto aaaa
)
if /I "%CHS%"=="2" (
goto bbbb
)
if /I "%CHS%"=="3" (
goto cccc
)
if /I "%CHS%"=="4" (
goto dddd
)
goto close
:aaaa
REM Æô¶¯Sql Server2005
net start MSSQLSERVER
pause
cls
goto dosmenu
:bbbb
REM ¹Ø±ÕSql Server2005
net stop MSSQLSERVER
pause
cls
goto dosmenu
:cccc
REM Æô¶¯Oracle9I
net start "OracleServiceHOPE"
net start "OracleOraHome92TNSListener"
pause
cls
goto dosmenu
:dddd
REM Æô¶¯Oracle9I
net stop "OracleOraHome92TNSListener"
net stop "OracleServiceHOPE"
pause
cls
goto dosmenu
:close
REM Í˳ö
exit
-----------------------------------
¿½±´ÉÏÃæµÄÄÚÈÝ£¬ÃüÃûΪ.bat Îļþ£¬Ë«»÷ÔËÐм´¿ÉÆô¶¯£¬Í£Ö¹Êý¾Ý¿â·þÎñ
Ïà¹ØÎĵµ£º
http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅÌ°²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄÜ°²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10 ......
Ò»£®Âß¼StandbyµÄ×¼±¸¹¤×÷
1 È·ÈϲÙ×÷µÄ¶ÔÏóºÍÓï¾äÊÇ·ñÄܱ»Âß¼StandbyÖ§³Ö
ÓÉÓÚÂß¼StandbyÊÇͨ¹ýSQLÓ¦ÓÃÀ´±£³ÖÓëPrimaryÊý¾Ý¿âµÄͬ²½¡£SQLÓ¦ÓÃÓëREDOÓ¦ÓÃÊÇÓкܴóµÄÇø±ð£¬REDOÓ¦ÓÃʵ¼ÊÉÏÊÇÔÚÎïÀíStandby¶Ë½øÐÐRECOVER£»SQLÓ¦ÓÃÔòÊÇ·ÖÎöÖØ×öÈÕÖ¾ÎļþÖеÄREDOÐÅÏ¢£¬²¢½«Æäת»»ÎªSQLÓï¾ä£¬ÔÚÂß¼Standby¶ËÖ´ ......
ºÃ¾Ã¾ÍÏë¿´oracleÁË£¬ÓÉÓÚ×Ô¼ºÌ«ÀÁ£¬×î½ü²Å¿ªÊ¼¡£Ï£ÍûÒÔºóÄÜÑø³ÉºÃÏ°¹ß¡£
Ò»¡¢oracle 10g ·þÎñÆ÷
1.Ò»¸öoracle 10g·þÎñÆ÷°üº¬Ò»¸öoracleÊý¾Ý¿âºÍÒ»¸öoracle·þÎñÆ÷ʵÀý¡£
2.ÿµ±Êý¾Ý¿âÆô¶¯Ê±ºò£¬ÏµÍ³È«¾ÖÇø£¨SGA£©±»·ÖÅ䣬²¢Æô¶¯ÁËoracleºǫ́½ø³Ì¡£SGAÊÇÓÃÓÚÊý¾Ý¿âÓû§¹²ÏíÊý¾Ý¿âÐÅÏ¢µÄÄÚ´æÇøÓ ......
select table_name from user_tables; //µ±Ç°Óû§µÄ±í
select table_name from all_tables; //ËùÓÐÓû§µÄ±í
select table_name from dba_tables; &n ......
Oracle Êý¾Ý¼¯³É½â¾ö·½°¸
¡¡¡¡OracleÊý¾Ý¼¯³É½â¾ö·½°¸ÓÃÓÚÔÚSOA¡¢BIºÍÊý¾Ý²Ö¿â»·¾³Öй¹½¨¡¢²¿ÊðºÍ¹ÜÀíÒÔʵʱÊý¾ÝΪÖÐÐĵļܹ¹£¬°üº¬ÁËÊý¾Ý¼¯³ÉµÄËùÓÐÒªËØ——ʵʱÊý¾ÝÒƶ¯¡¢×ª»»¡¢Í¬²½¡¢Êý¾ÝÖÊÁ¿¡¢Êý¾Ý¹ÜÀíºÍÊý¾Ý·þÎñ——ÄÜÈ·±£¸÷¸ö¸´ÔÓϵͳµÄÐÅÏ¢¼°Ê±¡¢×¼È·¡¢Ò»Ö¡£
¡¡¡¡Í¨¹ýʹÓÃOracleÊý¾Ý¼¯³É£¬Æó ......