Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 SQL ÓÅ»¯

http://kang275284.javaeye.com/blog/154331
Ò»¡¢ ÏȽéÉÜÒ»ÏÂoracle
µÄSGA£ºÊý¾Ý¿âµÄϵͳȫ¾ÖÇø£¬SGAÖ÷ÒªÓÉÈý²¿·Ö¹¹
³É£º¹²Ïí³Ø¡¢Êý¾Ý»º³åÇø¡¢ÈÕÖ¾»º³åÇø¡£
1¡¢ ¹²Ïí³ØÓÖÓÉÁ½²¿·Ö¹¹³É£º¹²ÏíSQL
Çø
ºÍÊý¾Ý×ֵ仺³åÇø¡£¹²ÏíSQL
Çø×¨ÃÅ´æ·ÅÓû§SQL
Ãü
Áoracle
ʹÓÃ×î½ü×îÉÙʹÓõÈÓÅÏȼ¶Ëã·¨À´¸üи²¸Ç£ ......

oracle dg µÄ»ù±¾ÃüÁî

1£¬²é¿´µ±Ç°µÄ±£»¤Ä£Ê½
 select DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL from v$database;
2£¬²é¿´ÈÕÖ¾µÄ´«ËÍ·½Ê½£»
 select dest_name,archiver from v$archive_dest;
3£¬Í£Ö¹standbyµÄ×Ô¶¯»Ö¸´×´Ì¬
 alter database recover manager standby database finish;
4£¬Ìí¼Óstandby logfile
&nb ......

»ùÓÚ OCI ʵÏÖµÄ oracle ×î¸ßЧdump³ÌÐò

»ùÓÚOCI ʵÏֵĠ×î¸ßЧdump³ÌÐò£¬ ±ÈOTL ÒÔ¼°ÆäËûµÄ½Ó¿Ú¶¼¿ìºÜ¶à
ÄÜÖ´ÐÐÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃûºÍ×Ö¶ÎÀàÐÍ£¬½øÐÐÊä³öÊä³ö
/*
* oracle_dump.cpp
*
* Created on: 2010-2-1
* Author: clm971910@gmail.com
*
* ѹËõ
* 4216351 dump done
* ÍêÕû 106 Ãë
* д·Ö¸ô·û 8Ãë
* ѹËõд´Å ......

Oracle¹éµµÃüÁî£¨×ªÔØ£©

Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
select name,log_mode from v$database;
Ò²¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä
archive log list£»(¸Ã·½·¨ÐèÒªas sysdba)
¶ÔÓڷǹ鵵ģʽµÄÊý¾Ý¿â¸ÃΪ¹éµµÄ£Ê½£¨Ö÷ÒªÒÔOracle 10gΪ²Î¿¼£©Ê¹ÓÃÒÔϲ½Ö裺
1. SQL> alter system set log_archive_dest_1='location=/oracle/oracle10g/log/archive ......

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ

Oracleµ÷ÕûÓëSQL Óï¾äµÄµ÷ÓŵĹØÏµ
ÔÚOracleµ÷ÕûÖÐÎÒÃÇ»¹»áÉæ¼°µ½SQL Óï¾äµÄµ÷ÓÅ£¬ÎÒÃǽÓÏÂÀ´¾ÍÀ´¿´ÒÔÏ嵀 SQL Óï¾äµÄµ÷ÓÅ¡£ÎÒÃǶ¼ÖªµÀ Oracle ÖÐµÄ SQL µ÷ÓÅÊÇÒ»¸öÏ൱¸´ÔÓµÄÖ÷Ì⣬ÉõÖÁÊÇÐèÒªÕû±¾ÊéÀ´½éÉÜ Oracle SQL µ÷ÓŵÄϸ΢²î±ð¡£
²»¹ýÓÐһЩ»ù±¾µÄ¹æÔòÊÇÿ¸ö Oracle DBA ¶¼ÐèÒª¸ú´ÓµÄ£¬ÕâЩ¹æÔò¿ÉÒÔ¸ÄÉÆËûÃÇϵͳµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ