找到listener.ora文件:
/opt/oracle/app/product/11.2.0/dbhome_1/network/admin/listener.ora
修改端口为21521:LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = what21-05)(PORT = 21521))
)
)
ADR_BASE_LISTENER = /opt/oracle/app
Oracle执行:alter system set local_listener='(ADDRESS = (PROTOCOL = TCP)(HOST = what21-05)(PORT = 21521))';
启动Oracle11g数据库:
SQLPlus启动数据库->
su - oracle
sqlplus /nolog
conn /as sysdba
startup
Oracle用户Console启动监听->
lsnrctl start