$ sqlplus / as sysdba
SQL>create pfile fromspfile
修改$ORACLE_HOME/dbs下的文件initDEV.ora中的*.local_listener值
范例如下:
*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp)(Host=serverIP)(Port=1521)))'
SQL>create spfile frompfile;
SQL>startup;
2022-10-24 20:48:17
$ sqlplus / as sysdba
SQL>create pfile fromspfile
修改$ORACLE_HOME/dbs下的文件initDEV.ora中的*.local_listener值
范例如下:
*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp)(Host=serverIP)(Port=1521)))'
SQL>create spfile frompfile;
SQL>startup;