Configuring listener.ora
This is regarding Oracle
10g networking. On the server side I had configured listener.ora. and on the
client side I had configured tnsnames.ora, but when I started listener.ora I
got an error: tns name is incorrect. Could u please explain to me how to
configure on Linux?
Software/Hardware used:
Oracle 10G
Software/Hardware used:
Oracle 10G
ASKED:
October 29, 2009 2:02 PM
UPDATED:
November 2, 2009 10:12 AM
Answer Wiki:
You don't actually start listener.ora, listener.ora is just a configuration file providing information about your listener. The command to start the listener is
"lsnrctl start <listener name>" . On any unix or linux o/s, I prefer to name the listeners, since there are times when I have more than one because of the versions of Oracle I have installed. The content of your listener.ora file will vary depending on your domain, the port you use, the databases it supports, etc. I suggest checking out Oracle technical documentation to get specifics, but here is an example of a listener.ora file for a working listener...
SID_LIST_MyListener =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /app/dba/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oradb1.mydomain.com)
(ORACLE_HOME = /app/dba/oracle/product/10.2.0)
(SID_NAME = oradb1)
)
)
MyListener =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)
(HOST = servername1.mydomain.com)(PORT = 1521))
)
SUBSCRIBE_FOR_NODE_DOWN_EVENT_MyListener = OFF
LOCAL_OS_AUTHENTICATION_MyListener = OFF
You will need to change <MyListener>, <oradb1>, <mydomain.com>, and <servername1> to fit your environment, as well as the Oracle Home location.
To see all answers submitted to the Answer Wiki: View Answer History.
i am GEORGINA EUBA, aspiring to be in the IT world,and intrested to be a member of this house,THANK YOU.