Åú´¦Àí£¨batÎļþ£©×Ô¶¯Æô¶¯/¹Ø±Õoracle·þÎñ
Åú´¦Àí£¨batÎļþ£© ×Ô¶¯Æô¶¯/¹Ø±Õoracle·þÎñ
ÅжÏoracle ·þÎñ״̬
Èç¹û·þÎñ´¦ÓÚÆô¶¯×´Ì¬£¬¾Í¹Ø±Õ·þÎñ£»
Èç¹û·þÎñ´¦ÓڹرÕ״̬£¬¾ÍÆô¶¯·þÎñ¡£
@ECHO OFF
for /f "skip=3 tokens=4" %%i in ('sc query OracleServiceORCL') do set "zt=%%i" &goto :next
:next
if /i "%zt%"=="RUNNING" (
ECHO Stoping OracleService, please wait ...
net stop OracleServiceORCL
net stop OracleDBConsoleorcl
net stop OracleOraDb10g_home1TNSListener
net stop OracleOraDb10g_home1iSQL*Plus
)else (
ECHO Starting OracleService, please wait ...
net start OracleServiceORCL
net start OracleDBConsoleorcl
net start OracleOraDb10g_home1TNSListener
net start OracleOraDb10g_home1iSQL*Plus
)
pause
exit
×¢Ò⣺
OracleServiceORCLºÍOracleDBConsoleorcl·þÎñÃû×Ö¸ù¾ÝÄã´´½¨oracleµÄʵÀý²»Í¬¶ø±ä»¯£¬ÐèÒª²é¿´±¾µØ·þÎñ½ø³Ì£¬ÏàÓ¦¸Ã¶¯¡£
²Î¿¼ÎÄÕ£º
1.http://hi.baidu.com/smilevt/blog/item/ceca43f6f4aa892e730eec8b.html
2.http://zdz8207.javaeye.com/blog/487532
Ïà¹ØÎĵµ£º
ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name Type Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y &nb ......
[oracle@dba01 dbs]$ orapwd file=/oracle/app/oracle/product/10.2.0/db_1/dbs/orapworcl password=oracle entries=20 force=y
[oracle@dba01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sat May 29 13:07:10 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Con ......
oracleÖÐpro*cµÄѧϰ
¡¡Ò» Pro*C ³ÌÐò¸ÅÊö£º
1£®Ê²Ã´ÊÇPro*C³ÌÐò
ÔÚORACLEÊý¾Ý¿â¹ÜÀíºÍϵͳÖУ¬ ÓÐÈýÖÖ·ÃÎÊÊý¾Ý¿âµÄ·½·¨£»
£¨1£© ÓÃSQL*Plus£¬ ËüÓÐSQLÃüÁîÒÔ½»»¥µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£»
£¨2£© ÓõÚËÄ´úÓïÑÔÓ¦Óÿª·¢¹¤¾ß¿ª·¢µÄÓ¦ÓóÌÐò·ÃÎÊÊý¾Ý¿â£¬ÕâЩ¹¤¾ßÓÐSQL*froms£¬QL*Reportwriter,SQL*MenuµÈ£»
£¨3£© ÀûÓÃÔÚ ......
¡îÊý¾ÝÀàÐÍ
¶¨ÒåÁË£º±êÁ¿(SCALAR)¡¢¸´ºÏ(COMPOSITE)¡¢ÒýÓÃ(REFERENCE)ºÍLOB
ËÄÖÖÊý¾ÝÀàÐÍ
¡î±êÁ¿(SCALAR)
ºÏ·¨µÄ±êÁ¿ÀàÐÍÓëÊý¾Ý¿âµÄÁÐËùʹÓõÄÀàÐÍÏàͬ£¬´ËÍâËü»¹ÓÐһЩÀ©Õ¹¡£ËüÓÖ·ÖΪÆ߸ö×飺Êý×Ö¡¢×Ö·û¡¢ÐС¢ÈÕÆÚ¡¢Ðбêʶ¡¢²¼¶ûºÍ¿ÉÐÅ¡£
......
µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ ......