Remote Network And System Administration Job In IT And Networking
Unix administrator / DBA to write a shell script for automating oracle import
Find more Network And System Administration remote jobs posted recently Worldwide
Hi ,
I need to write a Unix shell which completes the below steps.
- Need to connect source ftp server , grep the latest file and copy the dumps from source to local target server (have keyless ssh entry already)
- Place the files under respective client_name folder location and it shouldnt replace last weeks old file .
- Once file is copied , this latest dump needs to imported automatically in Oracle database.
- Drop the existing user.
- Create a new user with default_tablespace (I have an existing script to do this already)
import the dump to newly created schema and while doing import I should be able to remap_schema and remap_tablespace.
- Once import is completed we need to execute a set of scripts and export the schema as a clean dump from the database.
Note : I have an existing script already for the scenario , we need to fine tune it for full automation.
Also, I have some 15 clients and I need a generic script to do this job using client name and schema name. Based on the client name it should automatically grep the name and import as relevant schema in database and need to export.
About the recuiterMember since Mar 14, 2020 Twinkle Mavani
from Ankara, Turkey
Candidate shortlisted and hiredHiring open till - Dec 13, 2022
Work from Anywhere
40 hrs / week Looking for help? Checkout our video tutorial
How to search and apply for jobs
How to apply? Do you have more questions about the Job?
See frequently asked questions
Similar Projects
python script to generate the github audit report lik
orgs,repo,teams,members,etc....
Small financial planning firm looking to creat and automate workflows. I find myself spending too much time transferring data from one place to another. I am not much of a tech person but understand enough to know what Im looking for as an end resul...read more
Robotic process automation (RPA) software
Need some advice and guidance on a few things
Hi,
I have GFF3 files (annotation) for my bacterial genomes. I want a script that can be used to convert this GFF3 and its fasta file into Genbank file.
Thanks.
The candidate will work with an engineering consulting team to deliver a BPM solution using Bizagi and connecting various SQL data sources.
The business process has been already designed in Bizagi Modeler by specialized engineering consulta...read more