ORACLE ORA 00132 ORA 00214
oracle¶ÏµçºóÖØÆô³öÏÖµÄÎÊÌâÒѾ½â¾ö·½·¨
Ò»¡¢ORA-00132
ÎÊÌâÃèÊö £ºsyntax error or unresolved network name ''
µÚ1²½£º¸´ÖÆÒ»·Ýpfile²ÎÊýÎļþ£¨×¢Ò⣺oracleÖеÄpfileÖ¸µÄ¾ÍÊÇinit<sid>.oraÎļþ£©
$sqlplus '/as sysdba';
SQL> create pfile from spfile='/u01/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora';
µÚ2²½£ºÐÞ¸Äpfile²ÎÊýÎļþ£¨ÐÞ¸Äinit<sid>.oraÎļþ£©
¾¹ýµÚÒ»²½ÒÔºó£¬Äã¾Í»áÔÚ$ORACLE_HOME/dbsĿ¼Ï·¢ÏÖÓÐÕâôһ¸öÎļþinit<sid>.ora£¬Õâ¾ÍÊÇÄãµÚÒ»²½´´½¨µÄÎļþ¡£
ÕÒµ½local_listenerÕâÒ»ÐУ¬È»ºó½«ÆäÖµÐÞ¸ÄΪ£º
(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))
ÆäÖеÄyour_hostnameΪÄãµÄÖ÷»úÃû£¬Æäʵµ¼ÖÂORA-00119ºÍORA-00132´íÎóµÄÔÒò¾ÍºÜ¿ÉÄÜÊÇÄãÐÞ¸ÄÁËÄãµÄhostname
µÚ3²½£ºÒÔpfile´´½¨spfile
ʹÓÃÒÔÏÂÃüÁî´´½¨spfile
SQL> create spfile from pfile='/u01/oracle/product/10.2.0/db_1/dbs/initorcl.ora';
µÚ4²½£ºÆô¶¯Êý¾Ý¿â
SQL> startup;
¶þ¡¢ORA-00214
ÎÊÌâÃèÊö £ºORA-00214: control file '' version ** inconsistent with file '' version **
ÿ¸öÃèÊö²»Ò»Ñù£¬ÕâÀïÊÇÎҵĽâ¾ö¹ý³Ì£º
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1220432 bytes
Variable Size 503316656 bytes
Database Buffers 1627389952 bytes
Redo Buffers 15556608 bytes
ORA-00214: control file '/usr/oracle/oradata/beyond/control02.ctl' version 3172
inconsistent with file '/usr/oracle/oradata/beyond/control01.ctl' version 3169
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> host cp /usr/oracle/oradata/beyond/control03.ctl /usr/oracle/oradata/beyond/control01.ctl
SQL> host cp /usr/oracle/oradata/beyond/control03.ctl /usr/oracle/oradata/beyond/control02.ctl
SQL> s
Ïà¹ØÎĵµ£º
ÔÎĵØÖ·oracle lock
1ÓÃPerl TKÄ£¿é ²éѯDBÖеÄLOCK
use DBI;
use Tkx;
use DBD::Oracle qw(:ora_session_modes);
$mw = Tkx::widget->new(”.”);
$mw->g_wm_title(”Oracle Lock”);
$content = $mw->new_ttk__frame(-padding => “5 5 12 0″);
$content->g_grid ......
µ±ÄãÔÚÊý¾Ý¿âÖд´½¨Êý¾Ý±íµÄʱºò£¬ÄãÐèÒª¶¨Òå±íÖÐËùÓÐ×ֶεÄÀàÐÍ¡£ORACLEÓÐÐí¶àÖÖÊý¾ÝÀàÐÍÒÔÂú×ãÄãµÄÐèÒª¡£Êý¾ÝÀàÐÍ´óÔ¼·ÖΪ£ºcharacter, number, date, LOB, ºÍRAWµÈÀàÐÍ¡£ËäÈ»ORACLE8iÒ²ÔÊÐíÄã×Ô¶¨ÒåÊý¾ÝÀàÐÍ£¬µ«ÊÇËüÃÇÊÇ×î»ù±¾µÄÊý¾ÝÀàÐÍ¡£ÔÚÏÂÃæµÄÎÄÕÂÖÐÄ㽫Á˽⵽ËûÃÇÔÚoracle ÖеÄÓ÷¨¡¢ÏÞÖÆÒÔ¼°ÔÊÐíÖµ¡£
¡¡¡¡
¡¡¡¡ ......
1£©ÊÂÎñÓëËø
µ±Ö´ÐÐÊÂÎñ²Ù×÷£¬±ÈÈç¶àÓû§Í¬Ê±½øÐвåÈë²Ù×÷ʱ£¬oracle»á¸øËùÓÐÕâЩ²åÈë²Ù×÷¼ÓÈë¶ÓÁУ¬ÏȽøÈë¶ÓÁеÄÏȽøÐвÙ×÷Ȩ£¬±ÈÈçÏÖÔÚAÓû§µÄ²Ù×÷ÊǵÚÒ»¸ö½øÈë¶ÓÁеģ¬ÄÇô´Ëʱ´Ë²Ù×÷¾Í»áÅжϲÙ×÷±íÉϵÄËøÊÇ·ñ´ò¿ª£¬Èç¹ûÊǹرյľÍ˵Ã÷ÓÐÆäËû²Ù×÷ÔÚÖ´ÐбØÐëµÈ´ýÆäÍê³É£¬Èç¹û´ò¿ªÁË£¬ÄǾͿÉÒÔÖ´Ðд˴ ......
itpubÂÛ̳ÖÐÔøÓÐÐÖµÜ˵¹ýmaterialized viewÊÇÒԿռ任ʱ¼ä£¬ÎÒÈÏΪ·Ç³£ÌùÇС£ÎﻯÊÓͼʵ¼Ê¾ÍÊÇ»ùÓÚ²éѯµÄÊý¾Ý¿½±´£¬ÆäÐÎʽ
¼òµ¥Àí½âµÄ»°¿ÉÒÔ¿´³ÉÊÇcreate table table_name as select * from table¡£
ºÇºÇ£¬ÈËÃÇ×ÜÊÇÏ£ÍûÊÂÇéÔ½¼òµ¥Ô½ºÃÂÓÚÊǵ±°³¿´µ½Õâ¸ö¶«Î÷Õâô¼òµ¥£¬Í·ÄÔÒ»·¢ÈÈÒ²ÆȲ»¼°´ý³åÁ˹ýÔÆ£¬ÏÂÃæÎҾ;ßÌåÃè ......