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