Steps for copying files between remote windows systems from command prompt using xcopy

1. We can copy the files between two windows systems using xcopy

2. Share a folder on target machine where we want to copy the files

Right click on the folder

Select share with and then click on Specific people

Add Everyone and set permission level to Read/Write

Click on Share

Click on Done

3. Source system folder

4. On the source system open the command prompt as an administrator and run the below command to copy files between source and target

xcopy source_folder_path  \\target_hostname\target_folder_path  /E

Here we got "Invalid drive specification" error

Note: To work with xcopy we need to map the network shared path at least ones or we need the access the shared folder ones from the source system

click windows + r button

In the resulting window typed the network shared path and click ok

Enter the username and password and click ok

Click ok

Close it and again try to copy the files using xcopy

Now open the target folder on remote system and check for the files

How to get EBS (Oracle E-Business Suite) version, patch set and modules

1. SQL query to get the EBS version

Login to EBS database and run the below query to get EBS version

SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;

2. SQL query to get the EBS patch set number

SELECT PATCH_LEVEL FROM FND_PRODUCT_INSTALLATIONS WHERE PATCH_LEVEL LIKE '%AD%' ;

3. SQL query to get the EBS modules

SELECT APPLICATION_ID, APPLICATION_SHORT_NAME, APPLICATION_NAME FROM FND_APPLICATION_V1;

Copying files between widows to linux from command prompt using ftp

Open the command prompt as an administrator on windows machine
Try to connect to linux machine using ftp and try to copy a file

Here we are getting the message as "Not connected"

To resolve this we need to modify "vsftpd.conf" on linux machine as below:

uncomment the following line below and save the file

local_enable=YES

write_enable=YES

anon_upload_enable=YES

Now restart the ftp server as below:






Now again try to connect from windows machine

Here we tried to connect as root user but it got failed.
By default ftp server was not open to linux as root user so try with normal user.

Copy a file from windows to linux using "put" command in ftp prompt

Now check for the file in linux machine

Basic ftp commands:

1. ls
List the contents of remote directory

2. cd
Change the remote working directory

3. dir
List contents of remote directory

4. get
To receive file from the linux machine to windows machine

Check for the file on windows machine

5. lcd
Change the local working directory on windows machine

6. mget
Getting multiple files from linux machine

Checking files on windows machine

7. mput
Sending multiple files to linux machine

Checking files on linux machine

8. rename
Renaming a file name




Checking for the renamed file

9. bye
Terminating the ftp session

10. close
Terminating the ftp connection

11. help
Displays the local help information

Basic hadoop commands

1. Creating a directory in hdfs

$ hdfs dfs -mkdir <paths>

2. List the directories in hdfs

$ hdfs dfs  -ls  <args>

3. Permissions

4. Putting a file in to hdfs file system

$ hdfs dfs -put <local-src> ... <HDFS_dest_path>

5. Space utilization in hdfs directory

$ hdfs dfs -du URI

6. Downloading files from hdfs to local file system

$ hdfs dfs -get <hdfs_src> <localdst>

7. Merging two files

We can merge two files in hdfs file system into a single file to the local file system as below

$ hdfs dfs -getmerge <src1> <src2> <localdst> [addnl]

8. Copying files or directories recursively

$ hdfs dfs -cp <src-url> <dest-url>

9. Help command

Use help command to access hadoop command manual

10. Seeing the contents of a file

$ hdfs dfs -cat <path[filename]>

11. Copying a file from source to destination in hdfs file system

$ hdfs dfs -cp <source> <dest>

12. Copy a file using copyFromLocal and copyToLocal

copyFromLocal

$ hdfs dfs -copyFromLocal <localsrc> URI

CopyToLocal

$ hdfs dfs -copyToLocal [-ignorecrc] [-crc] URI <localdst>

13. Move file from source to destination in hdfs file system

$ hdfs dfs -mv <src> <dest>

14. Remove a file or directory from hdfs file system

$ hdfs dfs -rm <arg>

15. Remove files recursively

16. To display last few lines of a file

$ hdfs dfs -tail <path[filename]>

17. Hadoop version

18. To check amount of space used by hdfs file system

19. To count the number of files and directories in hdfs