ORACLE µÇ½´íÎóÎÊÌâ
µÇ½ORACLEʱ³öÏÖ£ºORA-12637 °ü½ÓÊÜʧ°Ü ´íÎó
½â¾ö·½·¨£ºÔÚ\oracle\product\10.2.0\client_1\NETWORK\ADMIN ÖÐÕÒµ½sqlnet.oraÎļþ£¬
°ÑÐÞ¸Ä SQLNET.AUTHENTICATION_SERVICES= (NONE)¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎĵµ£º
Oracle JOB Ó÷¨Ð¡½á
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡ ......
×î½üÔÚÂÛ̳ÉÏÒ»Ö±¿´µ½ÓÐÅóÓѶÔÊý¾Ý×ÖµäÀïµÄÄÚÈݸ㲻̫Çå³þ£¬±ÈÈç˵V$¡¢V_$¡¢GV$µÈµÈ£¬µ½µ×ÄĸöÊÇͬÒå´Ê£¬ÄĸöÊÇÊÓͼ£¬Äĸö»ùÓÚÄĸö´´½¨¡£½ñÌìÕýºÃ¿´µ½¸Ç¹úÇ¿µÄ¡¶ÉîÈëdz³öORACLE¡·µÚÈýÕ½²µ½Õâ·½ÃæÄÚÈÝ£¬×ܽáһϣ¬Ò²·½±ã´ó¼Òѧϰ¡£
Êý¾Ý×ÖµäÓÉËIJ¿·Ö×é³É£º
1¡¢ÄÚ²¿RDBMS(X$)±í
X$ÊÇOracleÊý¾Ý¿âµÄºËÐIJ¿·Ö£¬ÕâЩ ......
ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,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
-------------------------------------------
Ca ......
1 ¾Û¼¯(cluster)
1.1 ¸ÅÄ
ÓÃÓÚ½«²»Í¬±íÖеÄÊý¾Ý´æ´¢µ½ÏàͬµÄÎïÀíÊý¾Ý¿éÖУ¬ÓÃÓÚ¶à±íÊý¾ÝÐèҪƵ·±½øÐÐÁªºÏ²éѯµÄÇé¿öÏ¡£¶à±íÊý¾Ý´æ´¢ÔÚÏàͬÊý¾Ý¿éºó£¬ÔÚ¶Ô¶Ô±í½øÐÐÁªºÏ²éѯʱ£¬ËùÐè¶ÁÈ¡µÄÎïÀí¿éÊý¼õÉÙ£¬´Ó¶øÌá¸ß²éѯÐÔÄÜ¡£
ÐèҪעÒâµÄÊǶԾۼ¯Öе¥±íµÄ²éѯºÍ¶Ô¾Û¼¯ÖбíÊý¾Ý½øÐÐÐ޸Ļò²åÈëµÈÊÂÎñ²Ù×÷ʱ£¬ÐÔÄܽ«Ê ......
Oracle±í¿Õ¼äµÄ¹ÜÀí
1.´´½¨±í¿Õ¼ä
//´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace test_temp
tempfile 'E:\oracle\product\10.2.0\oradata\testserver\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
&nbs ......