ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00119,ORA-00132 错误处理

ORA-00119,ORA-00132 错误处理

原创 Linux操作系统 作者:beatony 时间:2011-07-29 14:19:33 0 删除 编辑
 

ORA-00119,ORA-00132 错误处理

--******************************

-- ORA-00119ORA-00132 错误处

--****************************** 

 

  最近系统启动时,收到了ORA-00119以及ORA-00132错误该错误实际上跟LISTENER有,通常的法是spfile转储为pfile然后pfile启动

生成新的spfile过该操作方式代价太高,需要重新启动数。另一方式是直接修改tnsnames.ora中的服名,使之与监听器中的listener名字保持一致,具体考下面的细节 

 

.错误提示

 

  SQL> startup nomount;

  ORA-00119: invalid specification for system parameter LOCAL_LISTENER

  ORA-00132: syntax error or unresolved network name 'LISTENER_ODBP'

 

二、分析错误

 

  1.错误号对应的具体描述

    [oracle@odbp admin]$ oerr ora 00132

    00132, 00000, "syntax error or unresolved network name '%s'"

    // *Cause:  Listener address has syntax error or cannot be resolved.

    // *Action: If a network name is specified, check that it corresponds

    //          to an entry in TNSNAMES.ORA or other address repository

    //          as configured for your system. Make sure that the entry

    //          is syntactically correct.

 

    描述信息中出了listener.ora网络名是否tnsnames.ora相一致,需要检查

   

  2.

    [oracle@odbp admin]$ more listener.ora    

    # listener.ora Network Configuration File: /u01/app/oracle/10g/network/admin/listener.ora

    # Generated by Oracle configuration tools.

   

    SID_LIST_LISTENER_ODBP =

      (SID_LIST =

        (SID_DESC =

          (GLOBAL_DBNAME = odbp.oradb.com)

          (ORACLE_HOME = /u01/app/oracle/10g)

          (SID_NAME = odbp)

        )

      )

     

    LISTENER_ODBP =

      (DESCRIPTION =

        (ADDRESS = (PROTOCOL = TCP)(HOST = odbp.oradb.com)(PORT = 1521))

      )

 

  3.tnsnames.ora

    [oracle@odbp admin]$ more tnsnames.ora   

    # tnsnames.ora Network Configuration File: /u01/app/oracle/10g/network/admin/tnsnames.ora

    # Generated by Oracle configuration tools.

   

    ODBP =

      (DESCRIPTION =

        (ADDRESS_LIST =

          (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.192.11)(PORT = 1521))

        )

        (CONNECT_DATA =

          (SERVICE_NAME = odbp.oradb.com)

        )

      )

   

    EXTPROC_CONNECTION_DATA =

      (DESCRIPTION =

        (ADDRESS_LIST =

          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

        )

        (CONNECT_DATA =

          (SID = PLSExtProc)

          (PRESENTATION = RO)

        )

      )

 

    由上面的listener.oratnsnames.ora可知

    listener.ora中的听名tnsnames.ora中的服名不一致

 

三、解方法

  1.修改tnsnames.ora中的服LISTENER_ODBP,然后重新启动数即可

  2.可以spfile(pfile)转储为pfile文件,local_listener参数置空,然后使用pfile文件启动数后重新生成spfile

    可以采用下面的方法来转储,如下

      [oracle@odbp dbs]$ ls --pfile

      hc_odbp.dat  initdw.ora  init.ora  lkODBP  orapwodbp  spfileodbp.ora

     

      [oracle@odbp dbs]$ strings spfileodbp.ora > initodbp.ora

      [oracle@odbp dbs]$ cat initodbp.ora

      odbp.__db_cache_size=130023424

      odbp.__java_pool_size=33554432

      odbp.__large_pool_size=4194304

      odbp.__shared_pool_size=113246208

      odbp.__streams_pool_size=0

      *.audit_file_dest='/u01/app/oracle/admin/odbp/adump'

      *.background_dump_dest='/u01/app/oracle/admin/odbp/bdump'

      *.compatible='10.2.0.4.0'

      *.control_files='/u01/app/oracle/oradata/odbp/control01.ctl','/u01/app/oracle/oradata/odbp/control02.ctl'

      *.core_dump_dest='/u01/app/oracle/admin/odbp/cdump'

      *.db_block_size=8192

      *.db_domain='oradb.com'

      *.db_file_multiblock_read_count=16

      *.db_name='odbp'

      *.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

      *.db_recovery_file_dest_size=2147483648

      *.dispatchers='(PROTOCOL=TCP) (SERVICE=odbpXDB)'

      *.job_queue_processes=10

      *.local_listener='LISTENER_ODBP'   --改行注掉或置空

      *.open_cursors=300

      *.pga_aggregate_target=94371840

      *.processes=150

      *.remote_login_passwordfile='EXCLUSIVE'

      *.sga_target=285212672

      *.undo_management='AUTO'

      *.undo_tablespace='UNDOTBS1'

      *.user_dump_dest='/u01/app/oracle/admin/odbp/udump'

     

      SQL> startup nomount pfile='/u01/app/oracle/10g/dbs/initodbp.ora';

      ORACLE instance started.

     

      Total System Global Area  285212672 bytes

      Fixed Size                  1267068 bytes

      Variable Size             150997636 bytes

      Database Buffers          130023424 bytes

      Redo Buffers                2924544 bytes

     

      SQL> create spfile from pfile;

     

      File created.

     

      SQL> startup force;

      ORACLE instance started.

     

      Total System Global Area  285212672 bytes

      Fixed Size                  1267068 bytes

      Variable Size             150997636 bytes

      Database Buffers          130023424 bytes

      Redo Buffers                2924544 bytes

      Database mounted.

      Database opened.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22578826/viewspace-703520/,如需转载,请注明出处,否则将追究法律责任。

下一篇: CRS-0215 错误处理
请登录后发表评论 登录
全部评论

注册时间:2010-05-18

  • 博文量
    192
  • 访问量
    455702