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

ORACLE 9I·þÎñÆ÷Æô¶¯ºÍ¹Ø±Õ

·þÎñÆ÷Æô¶¯µÄ¹ý³Ì
       OracleÊý¾Ý·þÎñÆ÷µÄ³£¹æÆô¶¯¹ý³Ì:
        1¡¢Æô¶¯TNS¼àÌý             C:\Documents and Settings\Administrator>lsnrctl start
        2¡¢Æô¶¯Oracle Services    C:\Documents and Settings\Administrator>net start OracleServiceOrcl
        ·þÎñÆ÷Æô¶¯µÄ8ÖÖ
        1¡¢startup nomount ·Ç°²×°Æô¶¯£¬ÕâÖÖ·½Ê½Æô¶¯Ï¿ÉÖ´ÐУºÖؽ¨¿ØÖÆÎļþ¡¢Öؽ¨Êý¾Ý¿â ¶ÁÈ¡init.oraÎļþ£¬Æô¶¯instance£¬¼´Æô¶¯SGAºÍºǫ́½ø³Ì£¬ÕâÖÖÆô¶¯Ö»ÐèÒªinit.oraÎļþ¡£
          2¡¢startup mount dbname °²×°Æô¶¯£¬ÕâÖÖ·½Ê½Æô¶¯Ï¿ÉÖ´ÐУº Êý¾Ý¿âÈÕÖ¾¹éµµ¡¢Êý¾Ý¿â½éÖʻָ´¡¢Ê¹Êý¾ÝÎļþÁª»ú»òÍÑ»ú£¬ ÖØж¨Î»Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡£Ö´ÐГnomount”£¬È»ºó´ò¿ª¿ØÖÆÎļþ£¬È·ÈÏÊý¾ÝÎļþºÍÁª»úÈÕÖ¾ÎļþµÄλÖ㬵«´Ëʱ²»¶ÔÊý¾ÝÎļþºÍÈÕÖ¾Îļþ½øÐÐУÑé¼ì²é¡£
           3¡¢startup open dbname ÏÈÖ´ÐГnomount”£¬È»ºóÖ´ÐГmount”£¬ÔÙ´ò¿ª°üÀ¨Redo logÎļþÔÚÄÚµÄËùÓÐÊý¾Ý¿âÎļþ£¬ ÕâÖÖ·½Ê½Ï¿ɷÃÎÊÊý¾Ý¿âÖеÄÊý¾Ý¡£
           4¡¢startup£¬µÈÓÚÒÔÏÂÈý¸öÃüÁî startup nomount, alter database mount ,alter database open
           5¡¢startup restrict Ô¼Êø·½Ê½Æô¶¯ÕâÖÖ·½Ê½Äܹ»Æô¶¯Êý¾Ý¿â£¬µ«Ö»ÔÊÐí¾ßÓÐÒ»¶¨ÌØȨµÄÓû§·ÃÎÊ·ÇÌØȨÓû§·ÃÎÊʱ£¬»á³öÏÖÒÔÏÂÌáʾ£º ERROR£º ORA-01035: Oracle Ö»ÔÊÐí¾ßÓÐ RESTRICTED SESSION ȨÏÞµÄÓû§Ê¹ÓÃ
           6¡¢startup force Ç¿ÖÆÆô¶¯·½Ê½ µ±²»ÄܹرÕÊý¾Ý¿âʱ£¬¿ÉÓÃstartup forceÀ´Íê³ÉÊý¾Ý¿âµÄ¹Ø±Õ ÏȹرÕÊý¾Ý¿â£¬ÔÙÖ´ÐÐÕý³£Æô¶¯Êý¾Ý¿âÃüÁî
           7¡¢startup pfile=²ÎÊýÎļþÃû ´ø³õʼ»¯²ÎÊýÎļþµÄÆô¶¯·½Ê½ ÏȶÁÈ¡²ÎÊýÎļþ£¬ÔÙ°´²ÎÊýÎļþÖ


Ïà¹ØÎĵµ£º

oracle°²×°

°²×°…………
ÒýÓõÄhttp://mamaoyuan625.javaeye.com/blog/617502
°²×°oracle 10gºó£¬µÇ¼ ³öÏÖ
the account is locked
Õâ¸ö´íÎ󼸺õËùÓеijõѧÕ߶¼»áÓöµ½.
Æäʵ½â¾ö°ì·¨·Ç³£¼òµ¥.
ÇëÊäÈëÓû§Ãû:  SYSTEM
ÊäÈë¿ÚÁî:admin(×¢Òâ,Õâ¸öÃÜÂëÊÇÄãÔÚ°²×°oracleʱµÚÒ»²½ÉèÖõÄ)
È»ºóϵͳ»áÏÔ ......

OracleÓû§¡¢È¨ÏÞ¡¢½ÇÉ«¹ÜÀí

OracleÓû§¡¢È¨ÏÞ¡¢½ÇÉ«¹ÜÀí
Oracle ȨÏÞÉèÖÃ
Ò»¡¢È¨ÏÞ·ÖÀࣺ
ϵͳȨÏÞ£ºÏµÍ³¹æ¶¨Óû§Ê¹ÓÃÊý¾Ý¿âµÄȨÏÞ¡££¨ÏµÍ³È¨ÏÞÊǶÔÓû§¶øÑÔ)¡£
ʵÌåȨÏÞ£ºÄ³ÖÖȨÏÞÓû§¶ÔÆäËüÓû§µÄ±í»òÊÓͼµÄ´æȡȨÏÞ¡££¨ÊÇÕë¶Ô±í»òÊÓͼ¶øÑԵģ©¡£
¶þ¡¢ÏµÍ³È¨ÏÞ¹ÜÀí£º
1¡¢ÏµÍ³È¨ÏÞ·ÖÀࣺ
DBA: ÓµÓÐÈ«²¿ÌØȨ£¬ÊÇϵͳ×î¸ßȨÏÞ£¬Ö»ÓÐDBA²Å¿ÉÒÔ´´ ......

oracleÔ¶³ÌÁ¬½Óµ¼Èëµ¼³öÊý¾Ý¿â

·½Ê½Ò».
Ö´ÐÐÒÔÏÂsqlÓï¾ä´´½¨database link
create database link test_link  --Á´½ÓÃû
  connect to   Óû§Ãû   identified by ÃÜÂë
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Êý¾Ý¿â·þÎ ......

Oracle RACÐÔÄÜ Oracle sequence ÐÔÄܲâÊÔ

ÔÚOracle RAC»·¾³ÖУ¬ÏµÍ³ÐÔÄÜ»áÊܵ½Ó°Ï죬Ö÷Òª¼¯ÖÐÔÚBlockÔÚinstanceÖ®¼äµÄ´«Ê䣬¾¡¹Üoracle 10g ÖвÉÓÃÁËCache FusionÀ´¸ÄÉÆÒÔÇ°ÖØdiskÖжÁÈ¡Êý¾Ý¡£ÆäÖеÄÒ»¸ö²¿·Ö¾ÍÊǹØÓÚoracle sequenceµÄÐÔÄÜÎÊÌâ
ÏÂÃæÊǹØÓÚsequence µÄcacheºÍorder¶Ôrac ÐÔÄܵÄÓ°Ï죬´Ó²âÊÔÖп´µ½Ôö´ócacheºÍ²ÉÓÃnon-orderedµÄsequenceÐÔÄÜÊܵ½µÄÓ° ......

Oracle 1z0 047 Exam


Exam Number/Code : 1z0-047
Exam Name : Oracle Database SQL Expert
Questions and Answers : 278 Q&As
Update Time: 2010-04-15
1. Which two statements are true regarding the execution of the correlated subqueries? (Choose two.)
A. The nested query executes after the outer query returns th ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ