Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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£¬²»ÖªµÀʲôÒâ˼£¡Ôõô±ðÈ˶¼ËµÕâ¸öϵͳÈÏÖ¤·½·¨¿ÉÐУ¬ÎҾͲ»Ðа¡··

ÒýÓÃ
°´´


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

oracleÈëÃÅÅäÖÃ

oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
  (SID_LIST =
  ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......

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

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

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ