 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.
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
