Active instances

          

Interview questions

How can we keep track of active instances?


<<Previous   Next>>
Oracle - How can we keep track of active instances? posted by Babu Kunwar

How can we keep track of active instances?

Use enterprise manager, SQLPLUS, and SRVCTL to administer database instance.

Inorder to start any database instance execute the following command:
srvctl start instance -d db_name -i "inst_name_list" [-o start_options] [-c connect_str | -q]
Remember: This command will also start all enabled and non-running services that have the listed instances.

Stopping one ort more instance:
srvctl stop instance -d name -i "inst_name_list" [-o stop_options] [-c connect_str | -q]

To start or stop your entire cluster database, that is, all of the instances and its enabled services:
srvctl start database -d name [-o start_options] [-c connect_str | -q]
srvctl stop database -d name [-o stop_options] [-c connect_str | -q]



Write your comment - Share Knowledge and Experience


<<Previous   Next >> 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring