ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00119

ORA-00119

原创 Linux操作系统 作者:fei890910 时间:2013-11-22 19:13:56 0 删除 编辑
修改hostname后
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=node3)(PORT=1521))'


SQ> create pfile='/home/oracle/init.ora' from spfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileprod.ora';
File created.
[oracle@node3 ~]$ vi init.ora 
*.local_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=1521)))'

SQL> startup pfile='/home/oracle/init.ora'
ORACLE instance started.

Total System Global Area  836976640 bytes
Fixed Size                  1339740 bytes
Variable Size             251661988 bytes
Database Buffers          578813952 bytes
Redo Buffers                5160960 bytes
Database mounted.
Database opened.
SQL> create spfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileprod.ora' from pfile='/home/oracle/init.ora';
File created.

-----------------------------------------------------------------------------------------------------------------------------------------------


[oracle@node3 ~]$ sqlpllus / as sysdba
-bash: sqlpllus: command not found
[oracle@node3 ~]$ su - 
Password: 
[root@node3 ~]# ln -s $ORACLE_HOME/bin/sqlplus /usr/bin
[root@node3 ~]# su - oracle
[oracle@node3 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 22 16:37:37 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to an idle instance.




























来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29108064/viewspace-777372/,如需转载,请注明出处,否则将追究法律责任。

下一篇: ogg启动步骤
请登录后发表评论 登录
全部评论

注册时间:2013-08-15

  • 博文量
    120
  • 访问量
    747647