<var id="fe6gj"></var>

<rp id="fe6gj"><nav id="fe6gj"></nav></rp>

<noframes id="fe6gj"><cite id="fe6gj"></cite>

<ins id="fe6gj"><button id="fe6gj"><p id="fe6gj"></p></button></ins>

<tt id="fe6gj"><i id="fe6gj"><sub id="fe6gj"></sub></i></tt>

始創于2000年股票代碼：831685

咨詢熱線：0371-60135900 注冊有禮登錄

掛牌上市企業
60秒人工響應
99.99%連通率
7*24h人工
故障100倍補償

全部產品

您的位置：網站首頁 > 幫助中心>文章內容

文章內容

Oracle ORA-00119，ORA-00132 錯誤處理

發布時間: 2012/8/21 17:18:27

最近系統啟動時，收到了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.ora與tnsnames.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/

*.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.endtimedelusion.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中網絡名是否與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.ora與tnsnames.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/

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

上一篇 >> ARP靜態綁定批處理文件腳本詳細講解
下一篇 >> 配置和驗證網絡負載均衡

同類文章

您可能在找

服務器托管/租用

億恩云建站

億恩北京公司：

經營性ICP/ISP證：京B2-20150015

億恩鄭州公司：

經營性ICP/ISP/IDC證：豫B1.B2-20060070

億恩南昌公司：

經營性ICP/ISP證：贛B2-20080012

服務器/云主機 24小時售后服務電話：0371-60135900

虛擬主機/智能建站 24小時售后服務電話：0371-60135900

專注服務器托管17年

掃掃關注-微信公眾號

0371-60135900

Copyright© 1999-2019 ENKJ All Rights Reserved 億恩科技版權所有　地址：鄭州市高新區翠竹街1號總部企業基地億恩大廈　法律顧問：河南亞太人律師事務所郝建鋒、杜慧月律師

京公網安備41019702002023號

億恩公告

在線客服

服務器托管
服務器租用
云服務器
域名/空間
云建站

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

av不卡不卡在线观看_最近2018年中文字幕_亚洲欧美一区二区三区_一级A爱做片免费观看国产_日韩在线中文天天更新_伊人中文无码在线