Topic: Database Administration >> Listener Problem
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| rsreddy28 |
Posted: Jan 16, 2008 11:54:30 AM |
Total Post: 35
Joined: Mar, 2007
|
Hello All,
I'm working on Linux AS4 , my database is fine . But when I start my listener.ora file , nothing happens . It stays as it is . Below is my listener.ora file
dbas =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521))
)
)
)
SID_LIST_dbas =
(SID_LIST=
(SID_DESC=
(SID_NAME=prod)
(ORACLE_HOME=/oraeng/app/oracle/product/10.2.0))
)
Dont know what and where is the problem lying .
How to configure the hostname in oracle . The above mentioned is my IP address.
Please let me know.
Regards,
Raj |
|
|
 MOH_DBA |
| Posted: Jan 16, 2008 02:17:52 PM |  |
|
Total Post: 133
Joined: Nov, 2007
|
I want from you to check the following things:
1) check in the listener. what is the current listener.
LSNRCTL> show current_listener
2)check the tnsnames of the external proceduer (i hope you know the relation between the listener and the tnsnames).
EXTPROC_CONNECTION_DATA = --this entry in tnsnames
(DESCRIPTION =
(ADDRESS_LIST =
---------------------------------------------------------
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
---------------------------------------------------------
)
(CONNECT_DATA =
-------------------------------------------------------
(SID = PLSExtProc)
------------------------------------------------------
(PRESENTATION = RO)
)
3)I want from you to check the /etc/hosts, if Your IP registered their with your host name.
4)check the listener trace and log file and see what they tell you.
Plz check all of that and tell me the Output.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 704 |
| Jayanta Sur | 479 |
| positive fanatic | 416 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 231 |
| Ramesh Jois | 226 |
| Bishal Khetan | 196 |
|
|
