在设置开机自动启动监听服务时:chkconfig --add oracle10g

在设置开机自动启动监听服务时:chkconfig --add oracle10g

报ora-000119和ora-00132

引用下面文章,转载

http://space.itpub.net/22578826/viewspace-703520

ORA-00119,ORA-00132 错误处理

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

-- ORA-00119,ORA-00132错误处

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

 

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

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

 

一.错误提示

 

 SQL> startup nomount;

 ORA-00119: invalidspecificationforsystemparameter LOCAL_LISTENER

 ORA-00132: syntaxerrororunresolvednetworkname'LISTENER_ODBP'

 

二、分析错误

 

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

   [oracle@odbpadmin]$ oerrora00132

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

   // *Cause: Listener address has syntaxerrororcannot be resolved.

   // *Action:Ifanetworknameisspecified,checkthat it corresponds

   //         toanentryinTNSNAMES.ORAorother address repository

   //         asconfiguredforyour system.Makesure thattheentry

   //         issyntactically correct.

 

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

   

 2.

   [oracle@odbpadmin]$morelistener.ora    

   # listener.oraNetworkConfigurationFile: /u01/app/oracle/10g/network/admin/listener.ora

   #GeneratedbyOracle 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@odbpadmin]$moretnsnames.ora   

   # tnsnames.oraNetworkConfigurationFile: /u01/app/oracle/10g/network/admin/tnsnames.ora

   #GeneratedbyOracle 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 nomountpfile='/u01/app/oracle/10g/dbs/initodbp.ora';

     ORACLEinstancestarted.

     

     TotalSystemGlobalArea 285212672bytes

     FixedSize                 1267068bytes

     VariableSize            150997636bytes

     DatabaseBuffers         130023424bytes

     Redo Buffers               2924544bytes

     

     SQL>createspfilefrompfile;

     

     Filecreated.

     

     SQL> startupforce;

     ORACLEinstancestarted.

     

     TotalSystemGlobalArea 285212672bytes

     FixedSize                 1267068bytes

     VariableSize            150997636bytes

     DatabaseBuffers         130023424bytes

     Redo Buffers               2924544bytes

     Databasemounted.

     Databaseopened.


 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值