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

Íü¼Çoracle 9iÃÜÂë

Íü¼ÇÁËoracle 9iµÄËùÓÐÃÜÂ룬ËùÓеÄÓû§sys  system  sysman  scottµÈµÈ£¬ÒÔ¼°ÍøÉÏ˵µÄºÜ¶à·½·¨£¬Èç3.sqlplus / as sysdba;
4.alter user sys identified by 123; 5.alter user system identified by 123; µÈµÈ¶¼Ã»ÓÐÓã¡ÎÒÍü¼ÇÁËËùÓеÄÓû§ÃÜÂ룬½øSQL*PLUS¶¼²»Äܽø
£¬ÐҺû¹¿ÉÒÔͨ¹ýÃüÁîÐнøÈ¥£¬µ«ÊǽøÈ¥ÁËҲûÓ㬲»ÖªµÀÓÃÄĸöÓû§Á¬½Ó£¿£¿Ë­ÄܸæËßÎÒ¸ÃÔõô°ì°¡¡£¡£¡£¡£
¿ÉÒÔÖØÐ´´½¨ÃÜÂëÎļþ
ÔÚʹÓÃOracle Instance Manager´´½¨Ò»Êý¾Ý¿âʵÀýµÄʱºî£¬ÔÚORACLE_HOME£ÜDATABASEĿ¼Ï»¹×Ô¶¯´´½¨ÁËÒ»¸öÓëÖ®¶ÔÓ¦µÄÃÜÂëÎļþ£¬ÎļþÃûΪ PWDSID.ORA£¬ÆäÖÐSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£´ËÃÜÂëÎļþÊǽøÐгõʼÊý¾Ý¿â¹ÜÀí¹¤×÷µÄ»ù´£ÔÚ´ËÖ®ºó£¬¹ÜÀíÔ±Ò²¿ÉÒÔ¸ù¾ÝÐèÒª£¬Ê¹Óù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨ÃÜÂëÎļþ£¬ÃüÁî¸ñʽÈçÏ£º

C:£Ü >ORAPWDFILE=£¼ FILENAME £¾PASSWORD =£¼ PASSWORD £¾ ENTRIES= < MAX_USERS >

¸÷ÃüÁî²ÎÊýµÄº¬ÒåΪ£º

FILENAME£ºÃÜÂëÎļþÃû£»

PASSWORD£ºÉèÖÃINTERNAL£¯SYSÕʺŵĿÚÁ

MAX_USERS£ºÃÜÂëÎļþÖпÉÒÔ´æ·ÅµÄ×î´óÓû§Êý£¬¶ÔÓ¦ÓÚÔÊÐíÒÔSYSDBA£¯SYSOPERȨÏ޵ǼÊý¾Ý¿âµÄ×î´óÓû§Êý¡£ÓÉÓÚÔÚÒÔºóµÄά»¤ÖУ¬ÈôÓû§Êý³¬³öÁË´ËÏÞÖÆ£¬ÔòÐèÒªÖØ½¨ÃÜÂëÎļþ£¬ËùÒԴ˲ÎÊý¿ÉÒÔ¸ù¾ÝÐèÒªÉèÖõôóһЩ¡£

ͬÒâÂ¥ÉÏ£¡

°´´Ë·½·¨¼üÈë¡£ÃüÁîÐÐÎÞ·µ»ØÐÅÏ¢£¬Ìø»Ø³õʼµÄ״̬¡£²¹³äÏ£¬ÎÒÔÚCÅÌûÕÒµ½PWDSID.ORAÕâ¸öÎļþ£¬ÊDz»ÊÇÓÐÎÊÌâÄØ£¿  ÎÒÓÃÍøÉÏ˵µÄ×î¶àµÄ·½·¨alter user sys identified by 123£¬°´»Ø³µºó£¬·µ»Ø2£¬²»ÖªµÀʲôÒâ˼£¡Ôõô±ðÈ˶¼ËµÕâ¸öϵͳÈÏÖ¤·½·¨¿ÉÐУ¬ÎҾͲ»Ðа¡··

ÒýÓÃ
°´´


Ïà¹ØÎÊ´ð£º

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ