sqlplus / as sysdba;
SQL> create pfile from spfile='D:\app\user\product\11.2.0\dbhome_1\database\SPFILEORCL.ORA';
执行该语句后在database下会生成INITorcl.ORA文件
把INITorcl.ORA文件中的*.local_listener的值改成,如:
*.local_listener='(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) (HOST=serverIP)(PORT=1521)))'
再执行
SQL>
create spfile from pfile='D:\app\user\product\11.2.0\dbhome_1\database\INITorcl.ORA';
SQL>startup