Skip to Main Content
  • Questions
  • Run bash scripts from application server for DBA tasks on DB server

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Rohan.

Asked: January 17, 2017 - 6:36 am UTC

Last updated: January 18, 2017 - 2:30 am UTC

Version: Oracle DB 12c

Viewed 1000+ times

You Asked

Hello Tom,

We do not want to DBA enterprise manager and instead want to create a bash scripts to perform DBA tasks.
The scripts will be residing on another server and we have a separate DB server.

Can we perform below DBA tasks from remote server on the DB which is hosted on another server ?
- RMAN utility
- Using opatch and dbua utility
- DB startup and shutdown

and Connor said...

RMAN
- yes, you can connect to remote database using standard connection string

opatch/dbua
- to my knowledge, you *must* be on the server containing the db software. For dbua, you can set DISPLAY to send the x-display back to another machine

db startup/shutdown
- yes, you can connect to remote database using standard connection string via sqlplus

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Rohan Mhatre, January 18, 2017 - 1:45 pm UTC


More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.