Sending email with file attachment.

Posted on By Admin No Comments on Sending email with file attachment.

Single File Attachemnt: ======================= cat test.dat|uuencode test.dat|mailx -s “subject” mailid Multiple file Attachment: ========================= (uuencode INPUTFILE $FILE_STRING.out ;uuencode INPUTFILE $FILE_STRING.err )|mailx -s “SUBJECT” $EMAIL_ID (uuencode INPUTFILE check_dr_notok.log ;uuencode INPUTFILE check_dr_ok.log )|mailx -s “Test multuple attachment” pmehta@1800flowers.com (uuencode check_dr_notok.log check_dr_notok.log ;uuencode check_dr_ok.log check_dr_notok.log)|mailx -s “Test multuple attachment” pmehta@1800flowers.com

Linux/Unix, shell

Kernel Parameters for Solaris

Posted on By Admin No Comments on Kernel Parameters for Solaris

* pre Solaris 10 * ——————- To view the current values of these parameters, enter the following commands: # grep noexec_user_stack /etc/system # /usr/sbin/sysdef | grep SEM # /usr/sbin/sysdef | grep SHM * Post Solaris 10 * =================== In Solaris 10, you are not required to make changes to the /etc/system file to implement the…

Read More “Kernel Parameters for Solaris” »

Linux/Unix, shell

Physical Standby switchover with session active

Posted on By Admin No Comments on Physical Standby switchover with session active

In order to perform a switchover all sessions to the database need to be disconnected. In version 901 this was a manual process. In version 9.2.0 this process has been automated with the “with session shutdown” clause that has been added to the alter database commit to switchover command. If SWITCHOVER_STATUS returns SESSIONS ACTIVE then…

Read More “Physical Standby switchover with session active” »

Oracle, rman-dataguard

Find_table_size.sql

Posted on By Admin No Comments on Find_table_size.sql

set lines 120 pages 500 col owner format a30 col segment_name format a30 col tab_sum format 999999999999999 col indx_sum format 999999999999999 col MB format 999999999 accept pvm_owner prompt ‘Enter Owner Name -> ‘ accept pvm_table prompt ‘Enter Table Name -> ‘ select tab.owner, tab.segment_name, tab.tablespace_name, (tab_sum+indx_sum)/(1024*1024) MB from (select p.owner, p.segment_name, p.tablespace_name, sum(p.bytes) tab_sum from…

Read More “Find_table_size.sql” »

Oracle, SQL scripts

Database link password in user_db_links

Posted on By Admin No Comments on Database link password in user_db_links

Problem Description: ~~~~~~~~~~~~~~~~~~~~ Database link passwords are stored as plaintext. A database link is a mechanism used to provide a method of transparently accessing one server from another. When creating a database link, a user name and password of the account on the remote server can be specified. Creating the database link without credentials works…

Read More “Database link password in user_db_links” »

Oracle, SQL scripts

More info about /proc folder and its relation with processes.

Posted on By Admin No Comments on More info about /proc folder and its relation with processes.

One of the most interesting directories on any Linux system is /proc, a virtual filesystem that provides a plethora of information on the hardware of the running system, and of the various processes running. In fact, many programs such as ps and top obtain their information by mining /proc. Some well-known virtual files in /proc…

Read More “More info about /proc folder and its relation with processes.” »

Linux/Unix, shell