Thursday, December 2, 2010

Setup Shell limits for Oracle user in Linux

Add lines to /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Above values depend on your environment.

Add following script to /etc/profile.local
if [ $USER = “oracle” ]; then
if [ $SHELL = “/bin/ksh” ] ; then
ulimit –p 16384
ulimit –n 65536
else
ulimit –u 16384 –n 65536
fi
fi

Have a nice day!

Transfer files between Unix/Linux with SCP

The scp command can be used in three ways: 1. to copy from your computer to a remote server 2. to copy from a remote server to your computer, and 3. to copy from a remote server to another remote server.

copy from your computer to a remote server:

# scp examplefile user_id@your_server:/home/user_id/

copy from a remote server to your computer

# scp user_id@your_server:/home/user_id/examplefile .

copy from a remote server to another remote server

# scp user_id1@server1:/home/user_id1/examplefile user_id2@server2:/home/user_id2/

Putting'' an entire directory


# scp -r dir1 user1@server1:/MyRsrch/dir2/

``Getting'' an entire directory


ucsu> scp -r user1@server1:dir1/09  /dir2/r9/



Have a nice day.