• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 482
  • Last Modified:

stop/starting listener service on live database

hello Expert,

The dabgers of start/stop a listener service when a production database is running

oracle 7.3.4 on solaris 7 .

thanks
0
jomfra
Asked:
jomfra
2 Solutions
 
Steve WalesSenior Database AdministratorCommented:
If you stop the listener while the database is running, no new connections will be able to be made while the listener is down.

Existing connections I believe remain OK (but this is something you should test on your test/development environment).
0
 
slightwv (䄆 Netminder) Commented:
Unless you have set up USE_SHARED_SOCKET for a firewall, then sjwales is correct.  Existing connections will remain and only new connections will be denied.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now