¶ÔÓÚÆô¶¯Oracle 10gʱ ORA
ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,Oracle±¨¸æÏÂÁдíÎó£º
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
»ù±¾½âÊÍ
=======
Error: ORA-27101
Text: shared memory realm does not exist
-------------------------------------------
Cause: Unable to locate shared memory realm
Action: Verify that the realm is accessible
ÈçºÎ½â¾ö
=======
Õâ¸öÎÊÌâÆäʵÓÃÒ»¾ä»°¾Í¿ÉÒÔ˵Çå³þ£º
ORACLE_HOME»òÕßORACLE_SIDÉèÖò»ÕýÈ·¡£
ÔÚÒÔǰµÄ°æ±¾ÖУ¬Èç¹ûORACLE_SID²»ÕýÈ·£¬Ò»°ã¶¼Ö»ÌáʾORA-01034¡£Oracle¡¡8.1.7 ¸ø³öÒ»¸ö¶îÍâµÄÐÅÏ¢£ºORA-27101¡£
->Èç¹ûÊÇUnix£¬ÔÚShellÀï°ÑORACLE_SIDÉèÖÃÕýÈ·¼´¿É(×¢Òâ´óСдÃô¸ÐµÄÎÊÌâ)¡£
¡¡´ËÍ⣬¼ì²éORACLE_HOME»·¾³±äÁ¿¡£ÈçºÎ¼ì²é²Î¿¼ÈçϵÄÃüÁ
% echo $ORACLE_SID
% ps -ef |grep smon
->Èç¹ûÊÇWindows£¬Ò»°ã¶¼ÊÇÒòΪϵͳÖÐÓжà¸öʵÀýÔì³ÉµÄ¡£
¡¡¿ÉÒÔÔÚÃüÁîÐÐÏ¡¡C:>set ORACLE_SID=DEMO
¡¡°ÑÕâÀïµÄDEMO»»ÎªÄãÏàÓ¦µÄʵÀýÃû¡£
¡¡Èç¹û»¹²»Ðеϰ£¬¼ì²é×¢²á±íÖеÄORACLE_HOME¡£
¡¡´ËÍ⣬ÔÚWindows»·¾³ÏÂÓеÄʱºòÁ¬½Ó²»ÉÏÔ¶³ÌµÄÊý¾Ý¿â£¬»á±¨¸æÈç´ËµÄ´íÎó¡£
¡¡½â¾ö°ì·¨ÊǰÑsqlnet.oraÎļþÖеÄ
¡¡SQLNET.AUTHENTICATION_SERVICES = (NTS) NTS»»ÎªNONE.
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÏÈÀ´¼òµ¥µÄ˵һÏÂORACLEµÄ±¸·Ý·½Ê½£¬Ïêϸ¹¦ÄÜ¿ÉÒÔËÑË÷һϡ£
Ò»ÖÖÊÇÂß¼±¸·Ý£¬¼´ËùνµÄµ¼³ö(Export)ºÍµ¼Èë(Import)ÃüÁÕâÖÖ·½Ê½µÄÓŵãÊÇ£¬Äܹ»¶ÔÊý¾Ý¿âÖеÄÿ¸ö¶ÔÏó½øÐб¸·Ý£¬²¢ÇÒʵÏÖ²»Í¬Æ½Ì¨ÏµÄÊý¾ÝÇ¨ÒÆ£¬µ«±¸·ÝµÄʱºòÊý¾Ý¿â²»ÄÜÊǹرյ쬴ÓCMDÃüÁî½ ......
½â¾ö°ì·¨£º
1.ʹÓÃOracleÓû§µÇ¼ϵͳ£¬ÔÚCMDÖÐÆôÓÃSQLPLUS
2.sqlplus /nolog
3.SQL> connect /as sysdba
¡¡¡¡¡¡ Connected.
4.SQL> alter user system account unlock;
¡¡¡¡¡¡ User altered.
Ëø¶¨Õ˺ŷ½·¨£º
1.SQL> alter user system account lock;
¡¡¡¡¡¡ & ......
ÏòOracleÊý¾Ý¿â±íÖвåÈëÊ®¼¸ÍòÌõÊý¾Ý£¬¿ÉÊǵ±²åÈë3Íò¶àÌõºó£¬³ÌÐò¾ÍÅ×
Java´úÂë
ORA-01000 maximum open cursors exceeded
ORA-01000 maximum open cursors exceeded
Òì³£ÐÅÏ¢¡£GoogleÁËÒì³£ÐÅÏ¢£¬µÃÖªÕâÑùµÄ´íÎóºÜÈÝÒ׳öÏÖÔÚJava´úÂëÖеÄÖ÷ÒªÔÒòÊÇ£ºJava´úÂëÔÚÖ´ÐÐconn.crea ......
Oracle×îÐÂÈÏÖ¤Ìâ¿â×ÊÁÏÏÂÔØ
Actualtests Oracle 1Z0-200 V11.07.08
Actualtests Oracle 1Z0-211 V11.10.08
Actualtests Oracle 1Z0-212 V11.07.08
Actualtests Oracle 1Z0-213 V11.07.08
Actualtests Oracle 1Z0-101 V11.07.08
Actualtests Oracle 1Z0-132 V11.07.08
Actualtests Oracle 1Z0-140 V11.21.08
Actual ......