1. Change listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL =
IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL =
TCP)(HOST = 10.11.201.198)(PORT = 1523))
)
)
2. Connect to sys as sysdba
3. execute the following command:
ALTER SYSTEM SET
LOCAL_LISTENER =
"(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.201.198)(PORT=1523))";
4. execute the following command:
ALTER SYSTEM REGISTER;
No comments:
Post a Comment