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

Oracle ѧϰ±Ê¼Ç: SYSDBAµÇ½ȨÏÞÎÊÌâ

±¾ÎÄ»·¾³ÅäÖãºOracle10gR2£¬Windows XP
OracleµÄÓû§ÐÅÏ¢Ò»°ãÀ´ËµÊDZ£´æÔÚÊý¾Ý×ÖµäÀïµÄ£¬ËùÒÔ³£¹æÓû§ÔÚOracleÊý¾Ý¿âûÓÐÆô¶¯µÄʱºòÊÇÎÞ·¨µÇ½µÄ¡£µ«ÓÐÁ½ÀàÓû§ÀýÍ⣬Õâ¾ÍÊǾßÓÐsysdba»òÕßsysoperȨÏÞµÄÓû§¡£Oracle sysdba»òÕßsysoperÓû§µÄµÇ½ÓÐÁ½ÖÖ·½Ê½£ºÒ»ÊÇͨ¹ýOSÈÏÖ¤£¬¶þÊÇͨ¹ýÃÜÂëÎļþÑéÖ¤¡£
¾¿¾¹Ê¹ÓÃÄÄÒ»ÖÖÑéÖ¤·½Ê½ÒÔ¼°ÄÜ·ñ³É¹¦µÇ½ȡ¾öÓÚÈý¸ö·½ÃæµÄÒòËØ£º
1. sqlnet.oraÖÐSQLNET.AUTHENTICATION_SERVICESµÄÉèÖÃ
2. ²ÎÊýÎļþÖÐREMOTE_LOGIN_PASSWORDFILEµÄÉèÖÃ
3. ÃÜÂëÎļþ PWD%sid%.ora
Oracle½øÐÐȨÏÞÑéÖ¤µÄ´óÖÂ˳ÐòÈçÏ£º
1. ¸ù¾ÝSQLNET.AUTHENTICATION_SERVICESµÄÖµ¾ö¶¨ÊǽøÐÐosÑéÖ¤»¹ÊÇÃÜÂëÎļþÑéÖ¤¡£
2. Èç¹ûÊÇosÑéÖ¤£¬¸ù¾Ýµ±Ç°Óû§µÄÓû§×éÅжÏÊÇ·ñ¾ßÓÐsysdbaȨÏÞ¡£Èç¹ûosÑé֤ʧ°Ü£¬Ôò½øÐÐÃÜÂëÎļþÑéÖ¤¡£
2. Èç¹ûÊÇÃÜÂëÎļþÑéÖ¤£¬REMOTE_LOGIN_PASSWORDFILEµÄÖµÒÔ¼°ÃÜÂëÎļþÊÇ·ñ´æÔÚ¾ö¶¨ÁËÑéÖ¤ÊÇ·ñ³É¹¦¡£
1. OS Ñé Ö¤
ÒªÆôÓÃosÑéÖ¤£¬¾Í±ØÐëÔÚqlnet.oraÖÐÉèÖÃSQLNET.AUTHENTICATION_SERVICES=(NTS)£¬È»ºóÔÚWindowsÖн¨Á¢ora_dbaÓû§×飬°ÑÏà¹ØÓû§¼ÓÈëµ½Õâ¸ö×éÖУ¨e.g., administrator£©£¬ÕâÑùadministrator¾Í¿ÉÒÔÔÚ²»ÓÃÌṩÓû§ÃûºÍÃÜÂ루»òÕßÌṩÈÎÒâµÄÓû§ÃûºÍÃÜÂ룩µÄÇé¿öÏÂÒÔsysdbaÉí·Ý±¾µØµÇ½¡£ÒòΪ²Ù×÷ϵͳÒѾ­´úÌæOracle½øÐÐÁËÑéÖ¤¡£
²âÊÔÒ»£ºora_dbaÓû§±¾µØµÇ½
Sql´úÂë
C:\>sqlplus / as sysdba   
Connected to:   
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production   
With the OLAP and Data Mining options   
SQL>   
  
C:\>sqlplus wrong_user/wrong_password as sysdba   
Connected to:   
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production   
With the OLAP and Data Mining options   
SQL>  
C:\>sqlplus / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the OLAP and Data Mining options
SQL>
C:\>sqlplus wrong_user/wrong_p


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracleË÷ÒýÏê½â

Ô­ÎĵØÖ·£ºhttp://fandayrockworld.javaeye.com/blog/540509 
»Ø¹Ë£º
Ò»¡¢ ROWIDµÄ¸ÅÄî
¡¡¡¡´æ´¢ÁËrowÔÚÊý¾ÝÎļþÖеľßÌåλÖãº64λ±àÂëµÄÊý¾Ý£¬A-Z, a-z, 0-9, +, ºÍ /£¬
¡¡¡¡rowÔÚÊý¾Ý¿éÖеĴ洢·½Ê½
¡¡¡¡SELECT ROWID, last_name from hr.employees WHERE department_id = 20;
¡¡¡¡±ÈÈ磺OOOOOOFFFBBBBBBRRR ......

oracle exp imp ³õ̽

Êý¾Ýµ¼³ö£º
 1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:\daochu.dmpÖÐ
   exp system/manager@TEST file=d:\daochu.dmp full=y
 2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
   exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
 3 ½«Êý¾Ý¿âÖеıíin ......

OracleÊý¾Ý¿âµÄÓÅ»¯Éè¼Æ

[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£­7597(2008)0720043£­01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......

Oracle Êý¾Ý¿âµÄ°ó¶¨±äÁ¿ÌØÐÔ¼°Ó¦ÓÃ

¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐË­¶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQLµÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
Òò´Ë,ÎÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ