oracle11g ora00119,ORA-00119跟ORA-00132的解决方案(Oracle11g-准确版本11.2)

当前位置:我的异常网» 数据库 » ORA-00119跟ORA-00132的解决方案(Oracle11g-准确版

ORA-00119跟ORA-00132的解决方案(Oracle11g-准确版本11.2)

www.myexceptions.net  网友分享于：2013-08-18  浏览：246次

ORA-00119和ORA-00132的解决方案(Oracle11g--准确版本11.2)

SQL> startup;

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name ’LISTENER_ORCL’

网上我找了一些资料, 加上我个人的处理, 解决了此问题:

修改安装目录下的SPFILEORCL.ORA文件, 我本机的具体位置:D:\app\Administrator\product\11.2.0\dbhome_2\database目录下, 而不是...\dbhome_2\dbs目录下;

用ultraedit或记事本打开该文件, 源文件内容如下:

C"           ?                                                                              ?  續?

C  C"

E/  orcl.__db_cache_size=343932928

orcl.__java_pool_size=4194304

orcl.__large_pool_size=4194304

orcl.__oracle_base='D:\app\Administrator'#ORACLE_BASE set from environment

orcl.__pga_aggregate_target=419430400

orcl.__sga_target=637534208

orcl.__shared_io_pool_size=0

orcl.__shared_pool_size=276824064

orcl.__streams_pool_size=0

*.audit_file_dest='D:\app\Administrator\admin\orcl\adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='D:\app\Administrator\oradata\orcl\control01.cC  C"           g  tl','D:\app\Administrator\flash_recovery_area\orcl\control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='orcl'

*.db_recovery_file_dest='D:\app\Administrator\flash_recovery_area'

*.db_recovery_file_dest_size=4039114752

*.diagnostic_dest='D:\app\Administrator'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.local_listener='LISTENER_ORCL'

*.memory_target=1056964608

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

C  C"           Ge

C  C"           Fe

C

文件的首尾有不规则的代码(类似于乱码, 不用管它)

修改*.local_listener='LISTENER_ORCL'这一行, 修改后如下(基于我本机):

*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=WIN-COSDJDSFC4C)(Port=1521)))'

其中WIN-COSDJDSFC4C是机器名,通过桌面我的电脑, 右键属性, 即可查到;

其他属性,如端口, 协议视具体情况修改.

保存即可, 修改后的内容为:

C"           ?                                                                              ?  續?

C  C"

E/  orcl.__db_cache_size=343932928

orcl.__java_pool_size=4194304

orcl.__large_pool_size=4194304

orcl.__oracle_base='D:\app\Administrator'#ORACLE_BASE set from environment

orcl.__pga_aggregate_target=419430400

orcl.__sga_target=637534208

orcl.__shared_io_pool_size=0

orcl.__shared_pool_size=276824064

orcl.__streams_pool_size=0

*.audit_file_dest='D:\app\Administrator\admin\orcl\adump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='D:\app\Administrator\oradata\orcl\control01.cC  C"           g  tl','D:\app\Administrator\flash_recovery_area\orcl\control02.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='orcl'

*.db_recovery_file_dest='D:\app\Administrator\flash_recovery_area'

*.db_recovery_file_dest_size=4039114752

*.diagnostic_dest='D:\app\Administrator'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=WIN-COSDJDSFC4C)(Port=1521)))'

*.memory_target=1056964608

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.undo_tablespace='UNDOTBS1'

C  C"           Ge

C  C"           Fe

C

启动成功

Oracle10.2的数据库可参考:http://hi.baidu.com/gmail07/item/bc19a889a8900ec099255f26

文章评论