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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡¡¡¡¡¡RETURN ......
ÔÎĵØÖ·£º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»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£7597(2008)0720043£01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......
28.6 Oracle³£¼ûÎÊÌâ´¦Àí
±¾½Ú½éÉÜÔÚRed Hat Enterprise Linux 5.2ÉÏ°²×°¼°ÅäÖÃOracleÊý¾Ý¿â·þÎñÆ÷ÖУ¬³£¼ûµÄÎÊÌâ¼°½â¾ö·½·¨£¬°üÀ¨ÈçºÎ»ñµÃÊý¾Ý¿â´´½¨¹ý³ÌÖеÄÏêϸÐÅÏ¢£¬·ÃÎÊOEM³öÏÖ“°²È«Á¬½Óʧ°Ü£¬Ê¹ÓÃÁËÎÞЧµÄ°²È«Ö¤Êé”´íÎóÒÔ¼°Íü¼ÇsysÓû§¿ÚÁîºóµÄ´¦Àí·½·¨µÈ¡£ ......