{"id":155,"date":"2008-10-03T22:31:00","date_gmt":"2008-10-03T20:31:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2008\/10\/03\/oracle-listener\/"},"modified":"2010-08-24T22:44:36","modified_gmt":"2010-08-24T20:44:36","slug":"oracle-listener","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2008\/10\/03\/oracle-listener\/","title":{"rendered":"ORACLE LISTENER"},"content":{"rendered":"

pami\u0119ta\u0107 nale\u017cy \u017ce je\u017celi dodajemy drug\u0105 instancj\u0119 lub baz\u0119 musimy sprawdzi\u0107 czy w pliku init.ora jest:
LOCAL_LISTENER=[nazwa listenera]
i albo go wywali\u0107 albo wpisa\u0107 poprawnie poniewa\u017c potem przy komendzie
LSNRCTL.EXE opcja STATUS b\u0119dzie podawana konfiguracja nie z tego pliku listener.ora<\/p>\n

$oracle_home\/bin\/lsnrctl korzysta z pliku $oracle_home\/network\/admin\/listener.ora umieszczonego w tym samym $oracle_home<\/p>\n
<\/div>\n
sqlplus korzysta z pliku $oracle_home\/network\/admin\/tnsnames.ora w zale\u017cno\u015bci od ustawionej zmiennej systemowej ORACLE_HOME<\/div>\n
uruchamianie:<\/span>
lsnrctl start [listener_name]
w winshit wywo\u0142anie po raz pierwszy stworzy nowy service<\/p>\n

konfiguracja listener.ora<\/span>:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = [sid_pierwszej_bazy])
(ORACLE_HOME = D:\\oracle\\product\\10.2.0\\db_1)
)
)<\/p>\n

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = [IP])
(PORT = 1521)
)
)
)<\/p>\n

SID_LIST_LISTENER1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = [sid_drugiej_bazy])
(ORACLE_HOME = G:\\oracle\\product\\10.2.0\\db_1)
)
)<\/p>\n

LISTENER1 =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = [IP])
(PORT = 1522)
)
)<\/p>\n

\n

LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=[ip1])(PORT=[port]))
(ADDRESS=(PROTOCOL=tcp)(HOST=[ip2)(PORT=[port2]))
)<\/p>\n

)<\/p>\n

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=db1)
(ORACLE_HOME=d:\\oracle\\product\\10.2.0\\db_1)
)
(SID_DESC=
(SID_NAME=db2)
(ORACLE_HOME=d:\\oracle\\product\\10.2.0\\db_1)
)
) <\/b><\/p>\n

tnsnames.ora<\/b>:
alias=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=tcp)
(Host=host.domain)
(Port=1521)
)<\/p>\n

(CONNECT_DATA=
(SID=dbsid)
)
)<\/p>\n

<\/div>\n

<\/div>\n
ERRORS:
<\/span>ORA-01150 #check listener.ora<\/span>
<\/span><\/div>\n
ORA-12154 #check tnsnames.ora<\/div>\n

Linux Error: 110: Connection timed out dla lsnrctl status #compare \/etc\/hosts via listener.ora<\/p>\n

ORA-12560 – dla w$ sprawdzi\u0107 w services.msc czy serwis zosta\u0142 uruchomiony<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

pami\u0119ta\u0107 nale\u017cy \u017ce je\u017celi dodajemy drug\u0105 instancj\u0119 lub baz\u0119 musimy sprawdzi\u0107 czy w pliku init.ora jest:LOCAL_LISTENER=[nazwa listenera]i albo go wywali\u0107 albo wpisa\u0107 poprawnie poniewa\u017c potem przy komendzieLSNRCTL.EXE opcja STATUS b\u0119dzie podawana konfiguracja nie z tego pliku listener.ora $oracle_home\/bin\/lsnrctl korzysta z pliku $oracle_home\/network\/admin\/listener.ora umieszczonego w tym samym $oracle_home sqlplus korzysta z pliku $oracle_home\/network\/admin\/tnsnames.ora w zale\u017cno\u015bci od […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[73],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-listener"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"predecessor-version":[{"id":211,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/155\/revisions\/211"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}