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

oracle¹éµµÄ£Ê½ÐÞ¸Ä

C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 13 15:26:31 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL>
SQL> archive log list;
Êý¾Ý¿âÈÕ־ģʽ             ·Ç´æµµÄ£Ê½
×Ô¶¯´æµµ             ½ûÓÃ
´æµµÖյ㠠          USE_DB_RECOVERY_FILE_DEST
×îÔçµÄÁª»úÈÕÖ¾ÐòÁР    112
µ±Ç°ÈÕÖ¾ÐòÁР          114
SQL> shutdown immediate;
Êý¾Ý¿âÒѾ­¹Ø±Õ¡£
ÒѾ­Ð¶ÔØÊý¾Ý¿â¡£
ORACLE Àý³ÌÒѾ­¹Ø±Õ¡£
SQL> startup mount;
ORACLE Àý³ÌÒѾ­Æô¶¯¡£
Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             230689668 bytes
Database Buffers          373293056 bytes
Redo Buffers                7135232 bytes
Êý¾Ý¿â×°ÔØÍê±Ï¡£
SQL> alter database archivelog;
Êý¾Ý¿âÒѸü¸Ä¡£
SQL> alter database open;
Êý¾Ý¿âÒѸü¸Ä¡£
TNS´íÎó£º
C:\Documents and Settings\Administrator>set oracle_sid=sgxxcyj


Ïà¹ØÎĵµ£º

Oracle±¸·ÝÓë»Ö¸´°¸Àý

Ò». Àí½âʲôÊÇÊý¾Ý¿â»Ö¸´
  µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨Ó²¼þ¹ÊÕÏ¡¢Èí¼þ¹ÊÕÏ¡¢ÍøÂç¹ÊÕÏ¡¢½ø³Ì¹ÊÕϺÍϵͳ¹ÊÕÏ£©Ó°ÏìÊý¾Ý¿âϵͳµÄ²Ù×÷£¬Ó°ÏìÊý¾Ý¿âÖÐÊý¾ÝµÄÕýÈ·ÐÔ£¬ÉõÖÁÆÆ»µÊý¾Ý¿â£¬Ê¹Êý¾Ý¿âÖÐÈ«²¿»ò²¿·ÖÊý¾Ý¶ªÊ§¡£Òò´Ëµ±·¢ÉúÉÏÊö¹ÊÕϺó£¬Ï£ÍûÄÜÖØ¹¹Õâ¸öÍêÕ ......

OracleÈÕÆÚº¯Êý²Ù×÷(ÊÕ¼¯ÕûÀí°æ)

¾­³£ÔÚÆ½Ê±µÄ¿ª·¢ÖÐÒªÓõ½oracleµÄÈÕÆÚº¯Êý£¬Ã¿´Î¶¼ÒªÉÏÍøÈ¥²é£¬ÏÖÔÚÓеãʱ¼ä£¬×Ô¼ºÊÕ¼¯ÕûÀíÁËһϡ£ÌùÔÚÕâÀ·½±ã×Ô¼º£¬Ò²·½±ã´ó¼Ò¡£
---------------------------------------------------------------------------------------------------------------------------------- 
³£ÓÃÈÕÆÚÐͺ¯Êý
1¡£Sysdate µ±Ç°È ......

´«ÖDz¥¿Í 2010 1 18Ê®Æß¡¢ORACLE(1)_°²×°Óë¹ÜÀí


Ò»¡¢Êý¾Ý¿âµÄÏà¹Ø¸ÅÄî
Êý¾Ý¿â£¨DB£©ÊÇÒ»¸ö°´Êý¾Ý½á¹¹À´´æ´¢ºÍ¹ÜÀíÊý¾ÝµÄ¼ÆËã»úÈí¼þϵͳ¡£
1¡¢Êý¾Ý¿â¹ÜÀíϵͳÓëÊý¾Ý¿âÓ¦ÓÃϵͳ
(1)Êý¾Ý¿â¹ÜÀíϵͳ£¨Database Management System£©
Êý¾Ý¿â¹ÜÀíϵͳ£¨DBMS£©ÊÇרÃÅÓÃÓÚ¹ÜÀíÊý¾Ý¿âµÄ¼ÆËã»úϵͳÈí¼þ¡£Êý¾Ý¿â¹ÜÀíϵͳÄܹ»ÎªÊý¾Ý¿âÌṩÊý¾ÝµÄ¶¨Òå¡¢½¨Á¢¡¢Î¬»¤¡¢²éѯºÍͳ¼ÆµÈ²Ù ......

Oracle´æ´¢¹ý³ÌÓ﷨ѧϰ

´æ´¢¹ý³Ì´´½¨Óï·¨£º
 
£¨1£©ÎÞ²Î
create or replace procedure ´æ´¢¹ý³ÌÃû
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
       ........................
Exception
       ........................
End;
 
£¨2£©´ø ......

linux ÏÂoracle µÄ°²×°(·þÎñ¶ËºÍinstant client)

linux ϰ²×°oracle ÊÇÒ»¼þºÜÁîÈËÍ·ÌÛµÄÊÂÇ飬ÎÒ°Ñ×Ô¼ºµÄ°²×°²½ÖèÄóöÀ´¸ø´ó¼Ò·ÖÏíһϡ£
Ò».linux·þÎñ¶ËµÄ°²×°.
1.ÏÂÔØoracle·þÎñ¶ËÈí¼þ,ÏÂÔØÍøÖ·ÈçÏÂ
http://www.oracle.com/technology/software/products/database/index.html
ÎÒÑ¡ÔñµÄ°æ±¾ÊÇ£ºOracle Database 10g Release 2 (10.2.0.1.0) for Linux x86-64
  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ