Select Page

Art of BI: Migrating files using SCP on Linux or Unix

Bill Anderson | | April 28, 2016

Oracle BI

Here’s a short blog post as a quick reference for some of the ways to move files using the terminal window for Linux/Unix using the SCP cmd. For this example we will be moving files and directories from a Dev environment onto a TST environment.

As an example, let’s walk through how to copy the file nohup.log from the ./start_stop directory in DEV to a directory into TST:

[code language="bash"]
scp /mp01/ancillary/start_stop/no_hup.log <user_name>@<server_name>:/mp01/ancillary/start_stop/
[/code]

– Be sure to add a forward slash for the target folder because if not it may interpret it as the name of a file that you are writing to.

– You will be asked to enter the password of the TST (Going to) userName from the system. This will not run if the password is incorrect.

To copy all files with the same file type .py from the start_stop directory from DEV to a directory in TST:

[code language="bash"]
scp <user_name>@<server_name>:"/mp01/ancillary/start_stop/*.py" /mp01/ancillary/start_stop/
[/code]

– You will be asked to enter the password of the DEV (Source) userName from the system. This will not run if the password is incorrect.

To copy the entire directory start_stop from Dev to a directory in TST:

[code language="bash"]
scp -r <user_name>@<server_name>:/mp01/ancillary/start_stop /mp01/ancillary/
[/code]

– You will be asked to enter the password of the DEV (Source) userName from the system. This will not run if the password is incorrect.

– The key here is to use the “-r” switch for copying an entire folder directory

In the end, one should always use the “man” command, for example “scp man”, from the terminal prompt to get all the information about the programs on which they have questions.

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Hyperion Myth #9: SOX Audit Requests Are Time-consuming

With serious financial penalties, SOX audits can be intimidating — but they don’t have to be. Find out how you can use Datavail’s software to automatically prove SOX compliance.

Jonathan Berry | March 13, 2018

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS