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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄ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
......
Êý¾Ýµ¼³ö£º
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Êý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£7597(2008)0720043£01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......
¹Ø¼ü´Ê:
°ó¶¨±äÁ¿(binding variable),¹²Ïí³Ø(shared buffer pool), SGA(system global area);
ÔÚ¿ª·¢Ò»¸öÊý¾Ý¿âϵͳǰ,ÓÐ˶ÔOracle ϵͳÁ˽âºÜ¶à,ÓÈÆäÊÇËüµÄÌØÐÔ,ºÃÏóºÜÉÙ°É;¶Ô³õѧÕßÀ´½²,Õâ¸üÊDz»¿ÉÄܵÄÊÂÇé;½ö½ö¼òµ¥ÕÆÎÕÁËSQLµÄд·¨,¾Í¿ªÊ¼ÁËÊý¾Ý¿âµÄ¿ª·¢,Æä½á¹ûÖ»ÄÜÊÇ¿ª·¢Ò»¸öûÓÐЧÂÊ,ҲûÓпÉÀ©Õ¹µÄϵͳ;
Òò´Ë,ÎÒ ......