by wilson2011 - Oracle - 2011-12-19 13:56:42 ÔĶÁ£¨598£© »Ø¸´£¨0£©
²é¿´oracleµ±Ç°Óû§ÏµÄÐÅÏ¢£¨Óû§£¬±íÊÓͼ£¬Ë÷Òý£¬±í¿Õ¼ä£¬Í¬Òå´Ê£¬´æ´¢¹ý³Ìº¯Êý£¬Ô¼ÊøÌõ¼þ£©
0¡¢±í¿Õ¼ä
¡¡¡¡SQL>select username,default_tablespace from user_users;
Solaris ÉÏoracle 10gR2 ÕýÔÚÔËÐÐ, ÁíÍâÒ»¸öÓû§(Ò²ÊôÓÚdba, oinstall group)ÓÃps -ef|grep oraÈ´¿´²»µ½oracle ½ø³Ì, oracleÓû§ÊÇ¿ÉÒÔ¿´µ½µÄ. ÇëÎÊÊÇʲôÎÊÌâ? лл
SQL>; connect internal/oracle as sysdba ERROR: ORA-01031: insufficient privileges SQL>; connect sys/changed_on_install /as sysdba ERROR: ORA-01031: insufficient privileges SQL>; conn sys/sys as sysdba ERROR: ORA-01031: insufficient privileges
ÎÒʹÓõÄƽ̨ÊÇRed Hat Enterprise Linux AS release 4 (Nahant Update 3) Êý¾Ý¿â°æ±¾ÊÇ9.2.0,Êý¾Ý¿âºÍ³ÌÐòÔËÐÐÔÚͬһ̨»úÆ÷ÉÏ ÎÒ±àÒëÁËÒ»¸öotl×Ô´øµÄ²âÊÔ³ÌÐò,ÒÔoracleÓû§Ö´ÐиóÌÐòok,ÒÔÆäËûÓû§(°üÀ¨root)Ôò²»ÄÜÖ´ÐÐ ±¨´íora-12545(Ä¿±ê»òÕ߶ÔÏó²»´æÔÚ) ÎÒºÜÊÇÓôÃÆ,Çл»µ½oracleÓû§ÏÂ,ʹÓÃtnspingÃüÁî,½á¹ûok ÒÔÏÂÊÇÎÒµÄtnsname.ora xb18 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST...
oracleÖмÙÈçÆäÖÐÒ»¸ö±í¿Õ¼äÂúÁË£¬ËùÒÔÒª°ÑÆäÖеÄÒ»ÕÅ´ó±í°áµ½ÆäËû±í¿Õ¼ä,¾ßÌåµÄsqlÔõôд£¿²ËÄñÇó½Ì...
À´Ô´£ºÈüµÏÍø ×÷ÕߣºLouis suid/guidµÄÎÊÌ⣺ ÒªÇó·ÇoracleÓû§Ò²ÄÜÔËÐÐsqlplusµÈoracleÃüÁî¡£ ½â¾ö·½·¨£º ¼ÙÈçÏ£ÍûÉèÖÃs u i d£¬ÄÇô¾Í½«ÏàÓ¦µÄȨÏÞλ֮ǰµÄÄÇһλÉèÖÃΪ4£»Èç¹ûÏ£ÍûÉèÖÃg u i d£¬ÄÇô¾Í½«ÏàÓ¦µÄȨÏÞλ֮ǰµÄÄÇһλÉèÖÃΪ2£»Èç¹ûÏ£ÍûÁ½Õ߶¼ÖÃ룬ÄÇô½«ÏàÓ¦µÄȨÏÞλ֮ǰµÄÄÇһλÉèÖÃΪ4+2¡£ Ò»µ©ÉèÖÃÁËÕâһ룬һ¸ös½«³öÏÖÔÚxµÄλÖÃÉÏ¡£×¢Ò⣺ÔÚÉèÖÃs u i d»òg u i dµÄͬʱ£¬ÏàÓ¦µÄÖ´ÐÐȨÏÞλ±ØÐëÒª±»ÉèÖÃ...
ÔÚLH3000ÉÏ×°ÁËSCO UNIX 506£¬oracle 7.3.4£¬ÓÃoracleÓû§Æô¶¯¡¢·ÃÎʶ¼Ã»ÓÐÎÊÌ⣬µ«ÊÇͬ×éµÄÆäËüÓû§¶¼ÎÞ·¨·ÃÎÊ,Ìáʾ£º SVR>;connect system/manager ORA-01034: oracle not available ORA-07320: smsget: shmat error when trying to attach sga. SCO System V/386 Error: 13: Permission denied ÏÂÃæÊǸÃÓû§µÄºÍoracleÓйصĻ·¾³±äÁ¿£¬¸ÃÓû§ºÍoracleÓû§ÊÇͬһ¸ö×éµÄ oracle_BASE=/oracle oracle_PATH=/oracle/product/7.3.4/...
ÔÀ´ÎÊÌâÌû×Óhttp://bbs.chinaunix.net/forum/19/20040810/384112.html ÊÇÓÉÓÚoracleÓû§°²×°Ê¹ÓÃbsh, ÆäËûÓû§Ê¹ÓÃcsh, »á³öÏÖÎÊÌ⣬¸Ä³ÉbshÒÔºó£¬ÎÊÌâ½â¾ö£¡ µ«ÊÇ£¬»¹ÓÐÒÉÎÊ£¬ÔÚÓÚ£¬Èç¹û²»È¥ÐÞ¸Äshell £¬Ôõô½â¾ö£¡
Unix Ï oracle Account ÎÞ·¨login,µ«ÓÃÆäËûÓû§su - oracle¿ÉÓᣠÇëÎÊÒªÊDz»ÊÇÉÙÅäÖÃÁËЩ¶«Î÷£¿ ÎÒµÄϵͳ£º HP-UX c01tXX B.11.11 U 9000/785 2366069355 unlimited-user license [ ±¾Ìû×îºóÓÉ shallyhe ÓÚ 2009-12-21 11:24 ±à¼ ]