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;
I hope it's helpful for you. If you have any queries, don't hesitate to contact me.
Name : Muhammad Sahal Qasim
E-mail : s.m.sahal789@gmail.com
Thank you.
0 comments:
Post a Comment
If you have any doubts, please let me know. I will help you.