ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre
来源:互联网 发布:java爬虫代码视频教程 编辑:程序博客网 时间:2024/05/18 03:37
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 23 10:27:15 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_SUNDAY'
[oracle@dbra ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 23 10:37:18 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create pfile from spfile;
File created.
[oracle@dbra dbs]$ ls -l
total 32
-rw-rw---- 1 oracle oinstall 1544 Jan 21 14:04 hc_drb.dat
-rw-rw---- 1 oracle oinstall 1544 Jan 23 10:34 hc_sunday.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 1002 Jan 23 10:38 initsunday.ora
-rw-r--r-- 1 oracle oinstall 1004 Jan 12 15:30 initsunday.ora.bak
-rw-r----- 1 oracle oinstall 24 Jan 21 13:46 lkSUNDAY
-rw-r----- 1 oracle oinstall 1536 Jan 21 14:24 orapwsunday
-rw-r----- 1 oracle oinstall 3584 Jan 22 08:59 spfilesunday.ora
[oracle@dbra dbs]$ vi initsunday.ora
sunday.__db_cache_size=125829120
sunday.__java_pool_size=41943040
sunday.__large_pool_size=8388608
sunday.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
sunday.__pga_aggregate_target=176160768
sunday.__sga_target=331350016
sunday.__shared_io_pool_size=0
sunday.__shared_pool_size=146800640
sunday.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/sunday/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/sunday/control01.ctl','/u01/app/oracle/fast_recovery_area/sunday/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='sunday'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4385144832
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=sundayXDB)'
*.local_listener='LISTENER_SUNDAY'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_target=507510784
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
~
~
找到*.local_listener='LISTENER_SUNDAY'
然后将其值修改为:
(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))
[oracle@dbra ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Jan 23 10:43:09 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
[oracle@dbra dbs]$ ls -l
total 36
-rw-rw---- 1 oracle oinstall 1544 Jan 21 14:04 hc_drb.dat
-rw-rw---- 1 oracle oinstall 1544 Jan 23 10:34 hc_sunday.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 1049 Jan 23 10:42 initsunday.ora
-rw-r--r-- 1 oracle oinstall 1004 Jan 12 15:30 initsunday.ora.bak
-rw-r----- 1 oracle oinstall 24 Jan 21 13:46 lkSUNDAY
-rw-r----- 1 oracle oinstall 1536 Jan 21 14:24 orapwsunday
-rw-r----- 1 oracle oinstall 3584 Jan 23 10:44 spfilesunday.ora
-rw-r----- 1 oracle oinstall 3584 Jan 23 10:43 spfilesunday.ora.bak
SQL> startup
ORACLE instance started.
Total System Global Area 505233408 bytes
Fixed Size 2254664 bytes
Variable Size 348129464 bytes
Database Buffers 150994944 bytes
Redo Buffers 3854336 bytes
Database mounted.
Database opened.
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre
- ORA-00119,ORA-00132 invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- 解决oracle11g ORA-00119 ORA-00132方法 invalid specification for system parameter LOCAL_LISTENER
- 改主机名后:ORA-00119: invalid specification for system parameter LOCAL_LISTENER
- oracle 11g 报 ORA-00119: invalid specification for system parameter LOCAL_LISTENER错误
- invalid specification for system parameter LOCAL_LISTENER
- ORA-00119: invalid specification for system parameter 错误解决办法
- ORA-00119: invalid specification for system parameter REMOTE_LISTENER
- ORA-00119: invalid specification for system parameter 解决
- 无缘无故的ORA-00119: invalid specification for system parameter REMOTE_LISTENER错误
- 字符串
- Nightmare hdu1072
- 安装和启动MySQL时遇到的问题总结
- 数字签名是什么?
- 大数据时代挑战就是商机
- ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unre
- C++ static关键字
- 变形空间和候选消除算法(Candidate-Elimination)C++实现
- C语言变参使用
- mysql的utf8mb4设置
- Shell脚本中参数传递方法常用有8种
- linux redis安装
- boost库学习及应用
- 树莓派使用360wifi2实现无线上网