Start Free TrialLog in
Avatar of taditya
taditya

asked on 

Managing multiple oracle instances on the same server

We have multiple Oracle 10g databases and corresponding instances on the same physical server. The server runs HP tru-unix B.11.23. We want to do a physical restart of the server, so it is needed to determine what all users are logged in into each instance and which interactive / non-interactive sessions are in progress.

Please suggest how can a consolidated report be generated automatically for all instances?


Regards,
T Aditya
Oracle Database
Avatar of undefined
Last Comment
Mark Geerlings
SOLUTION
Avatar of Indrajit Mahajan
Indrajit Mahajan
Flag of India image
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)
You will need a script/program to connect to each instance individually and run whatever SQL you have to determine "interactive / non-interactive sessions".

You might also look at setting up Grid Control to mananage multiple instances.
Avatar of taditya
taditya

ASKER

@slightwv, Can I get such level of details in this Grid control, like the session owner, machine used to start the session, session start time, session state (ACTIVE/INACTIVE), and SQL statement / procedure being executed in the session? If yes, please let me know how to establish such a grid control?


Thanks in advance
Avatar of taditya
taditya

ASKER

@indrajitmahajan, the links that you have shared, provide a good amount of information on the best practices used to manage multiple instances, but they do not help my cause.

Still, thanks for the information.
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image
Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Oracle Database
Oracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

81K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts

  • "Invaluable tool for our organization"

    Josh Regalski

  • "Your help has saved me hundreds of hours of internet surfing."

    @fblack61

  • "Just a dang good service!"

    @golferski

  • "Worth every penny."

    Steve Hougom

  • "It’s been a life saver."

    Maria Halt

  • "Best support site I’ve seen!"

    Bob Schneider

  • "I would be lost without them."

    @fblack61

  • "Saved my job multiple times."

    Walt Forbes

  • "I love this site."

    Maria Duwe

  • "Friendly respectful help."

    Andrew Kowtalo

  • "Such top-notch experts."

    @magento

  • "The best money I have ever spent."

    @rwheeler23

  • "Beyond any comprehensible value"

    George Morris

  • "Invaluable tool for our organization"

    Josh Regalski

Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo
© 1996-2023 Experts Exchange, LLC. All rights reserved. Covered by US Patent