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
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇ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Êý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......