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