Configuring listener.ora
10290 pts.
0
Q:
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
ASKED: Oct 29 2009  2:02 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
495 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Oct 30 2009  2:35 PM GMT by Jcmdba   495 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

83294401843   10 pts.  |   Nov 2 2009  10:12AM GMT

i am GEORGINA EUBA, aspiring to be in the IT world,and intrested to be a member of this house,THANK YOU.

 
0