无码视频在线观看,99人妻,国产午夜视频,久久久久国产一级毛片高清版新婚

  • 始創(chuàng)于2000年 股票代碼：831685
    咨詢熱線：0371-60135900 注冊有禮 登錄
    • 掛牌上市企業(yè)
    • 60秒人工響應
    • 99.99%連通率
    • 7*24h人工
    • 故障100倍補償
    全部產(chǎn)品
    您的位置： 網(wǎng)站首頁 > 幫助中心>文章內容

    Oracle ORA-00119，ORA-00132 錯誤處理
    發(fā)布時間:  2012/8/21 17:18:27

    最近系統(tǒng)啟動時，收到了ORA-00119以及ORA-00132的錯誤，該錯誤實際上跟LISTENER有關，通常的處理辦法是將spfile轉儲為pfile然后從pfile啟動

    并生成新的spfile，不過該操作方式代價太高，需要重新啟動數(shù)據(jù)庫。另一種方式則是直接修改tnsnames.ora中的服務名，使之與監(jiān)聽器中的listener名字保持一致，具體參考下面的細節(jié)。 

     

    一.錯誤提示 

      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中網(wǎng)絡名是否與tnsnames.ora相一致，需要檢查   

      2.查看監(jiān)聽

        [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.ora與tnsnames.ora可知

        listener.ora中的監(jiān)聽名與tnsnames.ora中的服務名不一致 

    三、解決方法

      1.修改tnsnames.ora中的服務名為LISTENER_ODBP，然后重新啟動數(shù)據(jù)庫即可

      2.可以將spfile(無pfile情況下)轉儲為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動數(shù)據(jù)庫后重新生成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/

          *.background_dump_dest='/u01/app/

          *.compatible='10.2.0.4.0'

          *.control_files='/u01/app/

          *.core_dump_dest='/u01/app/

          *.db_block_size=8192

          *.db_domain='oradb.com'

          *.db_file_multiblock_read_count=16

          *.db_name='odbp'

          *.db_recovery_file_dest='/u01/app/

          *.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/

         

          SQL> startup nomount pfile='/u01/app/

          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.


    本文出自：億恩科技【mszdt.com】

     

    一.錯誤提示 

      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中網(wǎng)絡名是否與tnsnames.ora相一致，需要檢查   

      2.查看監(jiān)聽

        [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.ora與tnsnames.ora可知

        listener.ora中的監(jiān)聽名與tnsnames.ora中的服務名不一致 

    三、解決方法

      1.修改tnsnames.ora中的服務名為LISTENER_ODBP，然后重新啟動數(shù)據(jù)庫即可

      2.可以將spfile(無pfile情況下)轉儲為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動數(shù)據(jù)庫后重新生成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/

          *.background_dump_dest='/u01/app/

          *.compatible='10.2.0.4.0'

          *.control_files='/u01/app/

          *.core_dump_dest='/u01/app/

          *.db_block_size=8192

          *.db_domain='oradb.com'

          *.db_file_multiblock_read_count=16

          *.db_name='odbp'

          *.db_recovery_file_dest='/u01/app/

          *.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/

         

          SQL> startup nomount pfile='/u01/app/

          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.


    本文出自：億恩科技【www.enidc.com】
    -->

    服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]
  • 您可能在找
  • 億恩北京公司：
  • 經(jīng)營性ICP/ISP證：京B2-20150015
    •
  • 億恩鄭州公司：
  • 經(jīng)營性ICP/ISP/IDC證：豫B1.B2-20060070
    •
  • 億恩南昌公司：
  • 經(jīng)營性ICP/ISP證：贛B2-20080012
    •
  • 服務器/云主機 24小時售后服務電話：0371-60135900
  • 虛擬主機/智能建站 24小時售后服務電話：0371-60135900
    •
    專注服務器托管17年
    掃掃關注-微信公眾號
    0371-60135900
    Copyright© 1999-2019 ENKJ All Rights Reserved 億恩科技 版權所有　 地址：鄭州市高新區(qū)翠竹街1號總部企業(yè)基地億恩大廈　 法律顧問：河南亞太人律師事務所郝建鋒、杜慧月律師   京公網(wǎng)安備41019702002023號
      1
     
     
     
     

    0371-60135900
    7*24小時客服服務熱線