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.