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

Oracle Êý¾Ý¿â¹ÜÀí½Å±¾ ÃüÃû¹æ·¶


    
      Oracle ÖеÄÊý¾Ý×ÖµäÊÇÊý¾Ý¿âÖеķdz£ÖØÒªµÄÒ»²¿·Ö£¬ÌṩÁËÏà¹ØÊý¾Ý¿âµÄÐÅÏ¢£¬ËüÊÇËùÓРOracle Óû§£¨´ÓÓ¦ÓõÄ×îÖÕÓû§¡¢Ó¦ÓõÄÉè¼Æ¿ª·¢Õßµ½Êý¾Ý¿â¹ÜÀíÔ±£©µÄ·Ç³£ÖØÒªµÄÐÅÏ¢À´Ô´¡£Êý¾Ý×ÖµäµÄ´´½¨£¬ÊÇÔÚ Oracle Êý¾Ý¿â´´½¨Íê±Ïºó£¬ÔËÐÐһЩÏà¹ØµÄÊý¾Ý¿â¹ÜÀí½Å±¾À´Íê³ÉµÄ¡£µ±²ÉÓàOracle Í³Ò»°²×°Æ÷£¨ Oracle Universal Installer £©´´½¨Êý¾Ý¿âʱ£¬ Oracle ·þÎñÆ÷ÓйصÄ×ÖµäÊÓͼºÍ½Å±¾×îºó»á±»×Ô¶¯°²×°¡£µ«µ±ÐèÒªÉý¼¶Ä¿Ç°µÄ Oracle Êý¾Ý¿â·þÎñÆ÷ʱ£¬Êý¾Ý¿â¹ÜÀíÔ±±ØÐëÒªÊÖ¹¤ÖØÐÂÔËÐд´½¨ÕâЩÊÓͼ»ò½Å±¾µÄ SQL ¡£
°²×°ÍêÊý¾Ý¿âºó£¬ Oracle Êý¾Ý¿â¹ÜÀí½Å±¾¾Í´æ·ÅÔÚ²Ù×÷ϵͳÖС£¶ÔÓÚ UNIX ºÍ NT ²Ù×÷ϵͳ£¬·Ö±ðλÓÚ²»Í¬µÄÎïÀíĿ¼Ï£¬¼û±í 1 Ëùʾ£º
²Ù×÷ϵͳ
½Å±¾Ä¿Â¼Î»ÖÃ
UNIX
$ORACLE_HOME/rdbms/admin
NT
%ORACLE_HOME%\rdbms\admin
¡¡±í 1 Êý¾Ý¿â¹ÜÀí½Å±¾ÔÚ²Ù×÷ϵͳÖеÄÎïÀíλÖÃ
Oracle Öм¸ºõËùÓеÄϵͳ¹ÜÀí½Å±¾¶¼±£´æÔÚ¸ÃÎļþĿ¼Ï£¬¸ÃĿ¼Ïº¬ÓÐÉÏ°Ù¸ö²»Í¬Îļþ¡£ÕâЩ²»Í¬µÄÎļþ¶¼ÓÐʲô×÷ÓÃÄØ£¿±¾ÎĽ«ÏêϸÌÖÂÛ×é³É Oracle Êý¾Ý¿â¹ÜÀí½Å±¾µÄÃüÃû¹æ·¶¡£ÕâÑùÓû§¿´µ½Ä³¸öÎļþ´ó¸Å¾Í¿ÉÒÔÖªµÀ¸ÃÎļþÖ÷ÒªÓÃ;ÊÇʲô¡£¸ÃĿ¼ÏµÄÎļþ°´ÕÕ¹¦Äܲ»Í¬¿É·ÖΪ 4 ´óÀ࣬ Oracle ÎªÁËÈÝÒ×Çø·ÖÕ⼸À಻ͬµÄÎļþ£¬¶ÔÓÚÎļþµÄÃüÃû×ñ´ÓÒ»¶¨µÄ¹æÔò¡£¼û±í 2 Ëùʾ¡£
ÃüÃû¹æÔò
¹¦ÄÜÃèÊö
cat*.sql
¹ØÓÚĿ¼ºÍÊý¾Ý×ÖµäÐÅÏ¢
dbms*.sql
Êý¾Ý¿âÖйØÓÚ°üµÄ˵Ã÷
prvt*.plb
¼ÓÃܹýµÄ°ü´úÂë
utl*.sql
Êý¾Ý¿âÆäËû¹¦ÄܵıíºÍÊÓͼ
±í 2 Êý¾Ý¿â¹ÜÀí½Å±¾ÃüÃû¹æ·¶
ÏÂÃæÀ´Ïêϸ½éÉÜÕâËÄÖÖ²»Í¬ÀàÐ͵Ľű¾¹¦ÄÜ£º
1 ¡¢ cat*.sql ½Å±¾
¸ÃÀà½Å±¾Ö÷ÒªÓÃÓÚ´´½¨Êý¾Ý×ÖµäÊÓͼ¡£ÆäÖУ¬½Å±¾ catalog.sql ºÍ catproc.sql ÊÇ´´½¨Êý¾Ý¿âºó±ØÐëÒªÔËÐеÄÁ½¸ö½Å±¾¡£ÕâÁ½¸ö½Å±¾µÄ¹¦ÄÜ˵Ã÷¼û±í 3 Ëùʾ¡£
½Å±¾
½Å±¾ËµÃ÷
catalog.sql
´´½¨ÏµÍ³³£ÓõÄÊý¾Ý×ÖµäÊÓͼºÍͬÒå´Ê
catproc.sql
ÔËÐзþÎñÆ÷¶ËËùÐèÒªµÄ PL/SQL ½Å±¾
±í 3 ´´½¨Êý¾Ý×ÖµäÊÓͼ½Å±¾ËµÃ÷
(1) catalog.sql
¸Ã½Å±¾´´½¨Ïà¶ÔÓÚϵͳ»ù±íµÄÊÓͼºÍϵͳ¶¯Ì¬ÐÔÄÜÊÓͼÒÔ¼°ËûÃǵÄͬÒå


Ïà¹ØÎĵµ£º

WindowsÏÂÃüÁîÐÐÆô¶¯Oracle 10g/Database Control

 
1.Æô¶¯TNS¼àÌý
C:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-7ÔÂ -2008 12:0
3:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Æô¶¯tnslsnr: ÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Pr ......

ÈçºÎ½â³ýOracle ÕʺÅËø¶¨(the account is locked)

½â¾ö°ì·¨£º
1.ʹÓÃOracleÓû§µÇ¼ϵͳ£¬ÔÚCMDÖÐÆôÓÃSQLPLUS
2.sqlplus /nolog
3.SQL> connect /as sysdba
¡¡¡¡¡¡   Connected.
4.SQL> alter user system account unlock;
¡¡¡¡¡¡    User altered.
Ëø¶¨Õ˺ŷ½·¨£º
1.SQL> alter user system account lock;
¡¡¡¡¡¡  & ......

С²ËÄñÎÊ£ºoracleÖеÄÒ»¸ö´¥·¢Æ÷ÎÊÌâ

ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......

Oracle·ÖÒ³´æ´¢¹ý³Ì¼°javaµÄ¾ßÌåµ÷Ó÷½·¨

--°ü
create or replace package pkg_query as
  type cur_query is ref cursor;
end pkg_query;
--¹ý³Ì
CREATE OR REPLACE  PROCEDURE "PRC_QUERY" (p_tableName  
        in  varchar2,   --±íÃû
      & ......

¶ÔÓÚÆô¶¯Oracle 10gʱ ORA

 ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,Oracle±¨¸æÏÂÁдíÎó£º
ERROR:
ORA-27101 Shared memory realm does not exist 
ORA-01034 ORACLE not available
»ù±¾½âÊÍ
=======
Error: ORA-27101 
Text: shared memory realm does not exist 
-------------------------------------------
Ca ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ