Configuring listener.ora

350795 pts.
Tags:
LISTENER.ora
Oracle 10g
Oracle 10g error messages
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 83294401843
    i am GEORGINA EUBA, aspiring to be in the IT world,and intrested to be a member of this house,THANK YOU.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following