bash: C:/Program: No such file or directory error solution in git bash with windows directory path having spaces

Hi friends,

Today, I have come across a situation where I have to execute the gitbash on windows with linux commands.

The escape character doesn't alone solve the problem

Problem

Setting up an alias for bash where the path includes space

$ alias DOCKER_HOME=C:/Program Files/Docker/Docker

Error

bash: C:/Program: No such file or directory

Solution

$ alias DOCKER_HOME=C:/"Program\ Files"/Docker/Docker

Hope my solution helps you in resolving the issue.

Please send your feedback and comments to psrdotcom@gmail.com

Oracle Drop/Delete User with All tables and files

Hi All,

Today I am going to explain the procedure to delete/drop a user in Oracle database along with tables and mapped files for that user tablespace.

Pre-requisites

Oracle database with the following

1. User
2. Tablespace of the user
3. Datafile of the tablespace

Procedure

Drop the user

Syntax: DROP USER CASCADE;
Example: DROP USER sampleuser CASCADE;

Make the tablespace offline

Syntax: ALTER TABLESPACE OFFLINE;
Example: ALTER TABLESPACE sampletablespace OFFLINE;

Drop the tablespace with mapped datafile[s]

Syntax: DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES
Example: DROP TABLESPACE sampletablespace INCLUDING CONTENTS AND DATAFILES

With the above 3 commands, you can make sure that, user and user related data has been completed removed from database.

Hope, it will help to resolve your issue.

Please send your feedback and comments to psrdotcom@gmail.com

Compress folders/files and create .tar.gz (Tar archive with GunZip Compression) and .zip (ZIP compression) file in Java

Hi friends,

Today I will explain how easily we can compress files and folders in java.

I have used a third part library which so simple to use.

Download the .jar from the following URL
https://rauschig.org/jarchivelib/download.html

Now, create a java class and create .tar.gz and .zip files.

Sample source code

package gunziptest;

import java.io.File;
import java.io.IOException;
import java.util.logging.Level;
import java.util.logging.Logger;
import org.rauschig.jarchivelib.ArchiveFormat;
import org.rauschig.jarchivelib.Archiver;
import org.rauschig.jarchivelib.ArchiverFactory;
import org.rauschig.jarchivelib.CompressionType;

/**
 *
 * @author psrdotcom
 */
public class GunZipTest {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // Archive file name
        String archiveName = "archive";
        // test is destination folder
        File destination = new File("test");
        // source folder has files and sub-folders
        File archive = null;
        
        // zip compression
        Archiver archiver = ArchiverFactory.createArchiver(ArchiveFormat.ZIP);
        try {
            archive = archiver.create(archiveName, destination, source);
            if(archive != null && archive.isFile()) {
                System.out.println("gunziptest.GunZipTest.main()" + "zip file created");
            }
        } catch (IOException ex) {
            Logger.getLogger(GunZipTest.class.getName()).log(Level.SEVERE, null, ex);
        }

        // tar.gz compression
        archiver = ArchiverFactory.createArchiver(ArchiveFormat.TAR, CompressionType.GZIP);
        try {
            archive = archiver.create(archiveName, destination, source);
            if(archive != null && archive.isFile()) {
                System.out.println("gunziptest.GunZipTest.main()" + "zip file created");
            }
        } catch (IOException ex) {
            Logger.getLogger(GunZipTest.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
}

Hope, you will find this useful.

Please send your review and feedback to psrdotcom@gmail.com

Change EOL (End Of Line) Character from Windows to Unix/Linux for all the files in current working directory

Hi all,

For a single file, you can do the change of EOL using notepad++.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

But it would be difficult, if you want to do for multiple files in one go.

I have found a solution to update EOL for all files in the current directory.

Pre-requisite

Make sure that, working directory contains only the files which you want to change EOL.

Note: If not, copy the files to a new directory and change the EOL for all the files in that directory.

Procedure

1. Download dos2unix utility from sourceforge https://sourceforge.net/projects/dos2unix/
2. Extract the zip file
3. Tip: Make sure that the extracted path doesn't contain spaces.
4. Keep the bin directory available in your PATH environment variables
5. Download the customized batch file from GIST https://gist.github.com/psrdotcom/d73ff9590c3010253b5b2a886704b26b
6. Extract if needed, and place the "dos2unixfolder.bat" in the same directory where the "dos2unix" is placed.
7. Tip: If you place the batch file in the same folder of dos2unix.exe. You no need to add again the patch of batch file in environment PATH.
8. Navigate to your folder, where you want all the files EOL to be changed
9. Press "Right Click on Mouse" in empty area
10. 
11. Select "Open Command Prompt Here"
12. Type the batch file name "dos2unixfolder.bat"
13. You will able to see the conversion process
14. Once the conversion is completed, you can check the EOL coversion in notepad++.
15. If you need to help in checking, refer to http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from.html

Please send your comments and feedback to psrdotcom@gmail.com

Change EOL (End Of Line) Character from Windows to Unix/Linux using Notepad++

Hi all,

Today I will explain about updating/converting EOL for a single file from windows format to unix/linux format.

1. In Windows, the EOL (End-Of-Line) character is \r\n (CR LF) (Carriage Return, Line Feed)
2. In Unix/Linux, the EOL character is \n (LF) (Line Feed)

Check for EOL

If you open the file in notepad++, you will be able to see the EOL character by following below steps:

• Type the content and hit enter button on keyboard
• Choose menu "View -> Show Symbol"
• Check the "Show End of Line" option

• Now, you will be able to view "CR LF" special symbols in you file at every line end as show below

Update EOL

To convert the EOL from Windows (CR LF) to Unix (LF), do the following

• Click on "Edit" menu
• Choose "EOL Conversion"
• Select "Unix(LF)"

• Now, you can check the update EOL character in your file. Example conversion show below

This type of conversion useful, when you are updating file in windows and using the same file in U/Linux environment.

Batch File Update

For all files in one folder, you can follow my blog.
Reference: http://psrdotcom.blogspot.in/2017/01/change-eol-end-of-line-character-from_20.html

Send your comments and feedback to psrdotcom@gmail.com

UDPCast, udp sender and udp receiver Sharing files over LAN/Wi-Fi

Hi admins,

Have you ever thought of sending files/folders to all your systems which are connected over LAN?
Have you ever thought of copying the entire partitions including OS to all your systems with same configuration which are connected over LAN in your lab?

You might be using some proprietary tools.

Let me share my knowledge of open source tools in Ubuntu to perform the job.

It is UDP Case with following operations

1. udp-sender
2. udp-receiver

Simple usage can be seen in References 2

References

https://www.udpcast.linux.lu/cmd.html
https://www.udpcast.linux.lu/cmdlinedoc.html

Please send your comments and feedback to psrdotcom@gmail.com

Running job in regular intervals or daily in Linux to delete files or modifying files

Running scripts daily to perform some common tasks in Linux

Be in root mode, super user mode

1) Create a script with the name filename.sh or any other name whatever you like

2) Do any one of the following .. but please test it with some other file extension like .yourname or something .. create your own unique files and do the testing before executing on original files which may be important.

   

   find /folderpath -type f -iname "*.fileextension" | xargs -i '{}' rm -rf {}

   (or)
   find /folderpath -type -f -iname "*.fileextension"  -exec /bin/rm -rf {} \;

3) chmod +x filename.sh

4) crontab -e

    i) press i to go into insert mode

    ii) enter 30 20 * * 1-5 /bin/bash /fullpath        

                      //30 min 20 hour i.e 8:30pm on 1-5(mon-fri) on *(every month) on *(every year)

    iii) shift+ZZ to save the file

5) Try this and let me know if any modifications needed

For further details, contact me psrdotcom@gmail.com