OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Newbie question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Newbie question [message #111226]

Mon, 14 March 2005 18:20

spudgun
Messages: 1
Registered: March 2005

Junior Member

I'm a SAP administrator of a system running Oracle.
We have a dedicated Oracle DBA, but I'd like to learn a bit more about Oracle without constantly bugging him.

Recently we had a problem with the listener not running. Now I've Googled until I'm blue in the face, but I cannot find anything that tells me what a listener is in Oracle.

Can anyone assist with telling me what a lister is/does?
Also, any references for some basics on Oracle would be appreciated. I'm not looking for certification-level stuff - just the basics.

Cheers.

Report message to a moderator

Re: Newbie question [message #111242 is a reply to message #111226]

Mon, 14 March 2005 22:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Can anyone assist with telling me what a lister is/does?
listener "listens" or waits or handles the incoming oracle connections to the database.
Any Listener is assigned one particular port (1521 etc).
Any external call ( like when a client talks with a remote server),
the incoming call is detected by listener and handles it.
every listener can be associated with only ONE database
or
ONe listener can handle multiple databases.

so logically, for a client to talk to a remote server, you need the listener up and available in the remote server.
For a client that talks the local server ( cleint and server in the same machine) Does not essentially need a listener

sqlplus scott/tiger -- this entry does NOT need a listener.
sqlplus scott/tiger@remotedb --this needs a listener.
--remotedb is tnsentry created in tnsnames.ora

>>Also, any references for some basics on Oracle would be appreciated. I'm not looking for certification-level stuff - just the basics

great deal of information available in,
oracle documentation Oracle9i Net Services Administrator's Guide

Report message to a moderator

Previous Topic:	Terminology problem
Next Topic:	delete tables of many users at a time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 04 19:35:32 CDT 2025