RATE THIS ANSWER
+1
Click to Vote:
1
0
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.