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.错误号对应的具体描述

    [[email protected] 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.

    [[email protected] 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

    [[email protected] 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

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

      [[email protected] dbs]$ ls --pfile

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

     

      [[email protected] dbs]$ strings spfileodbp.ora > initodbp.ora

      [[email protected] 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.

     

四、更多     

有关性能优化请参考

Oracle 硬解析与软解析

共享池的与优化(Shared pool Tuning)

Buffer cache 与优化(一)

Oracle 存(caching table)的使用

 

有关闪回特性请参考

Oracle 回特性(FLASHBACK DATABASE)

Oracle 回特性(FLASHBACK DROP & RECYCLEBIN)

Oracle 回特性(Flashback Query、Flashback Table)

Oracle 回特性(Flashback Version、Flashback Transaction)

 

有关基于用户管理的备份和备份恢复的概念请参考

Oracle 备份

Oracle 热备份

Oracle 备份复概

Oracle 例恢

Oracle 基于用管理恢(详细描述了介质恢复及其处理)

 

有关RMAN的恢复与管理请参考

RMAN 述及其体系结构

RMAN 配置、管理

RMAN 备份详

RMAN

 

有关Oracle体系结构请参考

Oracle 例和Oracle(Oracle体系结构)

Oracle 表空间与数据文件

Oracle 文件

Oracle 参数文件

Oracle 库实启动关闭过

Oracle 机重做日志文件(ONLINE LOG FILE)

Oracle 控制文件(CONTROLFILE)

Oracle 归档日志

 

;