文章內(nèi)容

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

發(fā)布時間: 2012/8/21 17:18:27

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

并生成新的spfile，不過該操作方式代價太高，需要重新啟動數(shù)據(jù)庫。另一種方式則是直接修改tnsnames.ora中的服務(wù)名，使之與監(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.查看錯誤號對應(yīng)的具體描述

[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)絡(luò)名是否與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中的服務(wù)名不一致

三、解決方法

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

2.可以將spfile(無pfile情況下)轉(zhuǎn)儲為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動數(shù)據(jù)庫后重新生成spfile

可以采用下面的方法來轉(zhuǎn)儲，如下

[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.ibaoshan.net】

一.錯誤提示

SQL> startup nomount;

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

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

二、分析錯誤

1.查看錯誤號對應(yīng)的具體描述

[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)絡(luò)名是否與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中的服務(wù)名不一致

三、解決方法

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

2.可以將spfile(無pfile情況下)轉(zhuǎn)儲為pfile文件，將local_listener參數(shù)置空，然后使用pfile文件啟動數(shù)據(jù)庫后重新生成spfile

可以采用下面的方法來轉(zhuǎn)儲，如下

[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】
-->

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]

上一篇 >> ARP靜態(tài)綁定批處理文件腳本詳細講解
下一篇 >> 配置和驗證網(wǎng)絡(luò)負載均衡

同類文章

·　Win7怎樣關(guān)閉UAC
·　防范入侵修改"遠程終端服
·　ASP網(wǎng)站漏洞解析及黑客入
·　ASP網(wǎng)站漏洞解析及黑客入
·　IP網(wǎng)絡(luò)攻擊手段和安全策略
·　網(wǎng)絡(luò)流量和網(wǎng)絡(luò)帶寬的區(qū)別
·　什么是網(wǎng)絡(luò)流量
·　服務(wù)器的使用誤區(qū)及正確使用
·　站長托管服務(wù)器之前必做的六
·　什么是虛擬主機？
·　服務(wù)器慢怎么辦？？
·　無盤啟動工作原理及其分類
·　什么是遠程訪問服務(wù)器
·　計算機網(wǎng)絡(luò)的帶寬的概念
·　WDS（無線分布式系統(tǒng)）加
·　VPN是什么
·　負載均衡是什么
·　Ping一下網(wǎng)絡(luò)故障早知
·　北京IDC專家北京最好的
·　seoer如何優(yōu)化行業(yè)網(wǎng)站

a毛片毛费观看-a毛片在线-a毛片在线观看-a毛片在线免费观看-国产成人综合洲欧美在线-国产成人综合高清在线观看

服務(wù)器租用

服務(wù)器托管

機柜批發(fā)

云服務(wù)器

建站俠

空間/域名

安全保姆

幫助類別

幫助中心

文章內(nèi)容

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

同類文章

億恩公告

在線客服

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

億恩公告

在線客服

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