OracleÓû§Ãû¸ü¸Ä²Ù×÷ËIJ½×ß
ÎÒÃǵÄOracle¹ÜÀí¹¤×÷Öо³£Éæ¼°µ½¸ü¸ÄOracleÓû§ÊôÐÔ¡¢ÃÜÂëÖ®ÀàµÄ³£ÓòÙ×÷£»µ«ÔÚijЩӦÓó¡¾°Ï£¬»áÓöµ½OracleÓû§Ãû¸ü¸ÄµÄÐèÇó£¬ÈçºÎ½â¾ö£¿ÏÂÃæÍ¨¹ýËĸö²½ÖèʵÏÖOracleÓû§ÃûµÄÐ޸ġ£
Ò»¡¢²éѯ¸ü¸ÄOracleÓû§Ãû
SQL> select user#,name,password from user$ where name ='TICKETS'; USER# NAME PASSWORD ---------- ------------------------------ ------------------------------ 78 TICKETS 21EDA78F89D6FACD
¶þ¡¢¸ü¸ÄÓû§Ãû
SQL> update user$ set name='TICKETS_BAK' where user#=78; 1 row updated. SQL> commit; Commit complete.
Èý¡¢´´½¨Í¬ÑùµÄOracleÓû§Ãû
SQL> create user tickets identified by "123456" 2 default tablespace yytickets 3 temporary tablespace temp; create user tickets identified by "123456" * ERROR at line 1: ORA-01920: user name 'TICKETS' conflicts with another user or role name
Õâʱϵͳ»áÌáʾ“Óû§Ãû³åÍ»”£¬ÔËÐÐÏÂÃæµÄSQLÓï¾ä
SQL> alter system checkpoint; ----Ç¿ÖÆÐ´ÈëÊý¾ÝÎļþ System altered. SQL> alter system flush shared_pool; ----Çå³þ»º´æÊý¾Ý×ÖµäÐÅÏ¢£¬
----Ç¿ÖÆoracle¶Áʵ¼ÊÊý¾Ý£¨¼´¸ü¸ÄºóµÄÊý¾Ý£© &nbs
Ïà¹ØÎĵµ£º
² Oracle9iµÄ°²×°£¬Çë²ÎÕÕ¹Ù·½µÄ°²×°ËµÃ÷¡£
² Oracle9i°²×°³É¹¦ÒÔºó£¬Ê¹ÓùÜÀíÔ±£¨Óû§Ãû£ºsys¡¢ÃÜÂ룺sys£©µÄÉí·ÝµÇ¼½øÈ¥£¬´´½¨Ò»¸öÓû§ddymis£¬ÃÜÂ룺ddymis,½ÇɫĬÈϸ³Óèdba¡£
² ......
ǰ¶Îʱ¼ä×öÁËÒ»¸öÐéÄâ×éÖ¯µÄ´´½¨¡£Õâ¸öÐéÄâ×éÖ¯µÄ´´½¨ÊÇ´ÓÏÖÓеÄ×éÖ¯ÖжÁÈ¡Êý¾ÝÈ»ºó½øÐзÖÎö±£´æµ½ÐéÄâ×éÖ¯±íÖС£±£´æÖ®ºóдÈÕÖ¾·½±ãͬ²½µ½ÆäËüϵͳÖС£¹«Ë¾Ê¹ÓõÄÖ÷Òª¼¼ÊõÊÇSSH¡£ÓÉÓÚÊÇÐÂÈËûÓÐʲô¾Ñ飬¼Ó֮ʱ¼ä±È½Ï½ôÆÈ£¬×îºóʹÓÃÒ»°ãµÄÂ߼˼Ïëͨ¹ýµÝ¹éÔÚhibernateÏÂ˳Àû´´½¨ÁË¡£¿ÉÊÇ´ÓÏÖÓеÄ×éÖ¯Ö ......
´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ.
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
......
OracleάÈÕ³£»¤µãµÎ
ËäÈ»Oracleά»¤²»ÊÇÎÒµÄÖ°Ô𣬵«Æ½Ê±»¹ÊÇÄÑÃâÒª¸úËü´ò½»µÀ£¬Òò´Ë¶ÔÓÚOracleµÄÈÕ³£Î¬»¤ÂÔÖªÒ»¶þ»¹ÊǺÜÓкô¦µÄ¡£
1. µÇ¼£º
£¨1£©²ÉÓÃϵͳ¹ÜÀíÔ±Óû§µÇ¼£º
#su - oracle
$ sqlplus / as sysdba
£¨2£©²ÉÓÃÒ»°ãÓû§µÇ¼£¬¼ÙÉèÓû§ÃûΪoracle£¬ÃÜÂëΪpasswor ......