Oracle SQL Script to Get Daily Thread Wise Archive Log Generation Report

SET PAGESIZE 60
SET LINESIZE 300
SET VERIFY OFF

SELECT TRUNC(completion_time)  "Generation Date" , thread#,count(*)
FROM gv$archived_log
GROUP BY TRUNC(completion_time),thread#
ORDER BY TRUNC(completion_time)

Kerala PSC Thulasi: New Declaration is required. You are not eligible to apply for this post

Nowadays when we apply for a Kerala PSC post using Thulasi website, we are getting a message saying “You are not eligible to apply for the Post”. Reason for the rejection is “New declaration is required.”

How to Get SQLPLUS Query Output to a Shell Script Variable

Most of the time during the shell scripting we get requirement to get the database table query result values to a shell script variables. Here is one example to get a single column values to a variable. If you have multiple column outputs then we will have to concatenate into a single column and pass it to the shell script variable. You can use awk or scripting commands to make it separate.

Linux Screen Command: re Attach an Already Attached Session

Here are some useful tips to use screen command in Linux user logins. Linux screen command is very useful command to keep the session logged in without any failure even if any kind of network failure etc.

1. Invoke a Screen session

Login to your a/c

Fix for Chrome: These Settings Are Enforced By Your Administrator. A 100% working solution

Problem Description:

In Chrome browser unable to change the proxy settings and the browsing is not working with Chrome. IE and Firefox browser working perfectly but chrome is not working. Chrome throws error saying unable to connect to the proxy. When I tried to change the proxy settings it says “These settings are enforced by your administrator”.

Fix ORA-15505: cannot start workload capture because instance 1 encountered errors

Error Description

Workload_caputre.start_capture failed with Fix ORA-15505: cannot start workload capture because instance 1 encountered errors

SQL> create directory WLDIR as '/export/prod_db/workload/’;

Directory Created

SQL> begin

Unix Linux Script to Attach and Embed the HTML File in Mail Body

(

export ATTACH="/home/sthomas/xyz.html"

export MAILTO=xyx@abc.com ##

export MAILPART=`uuidgen` ## Generates Unique ID

export MAILPART_BODY=`uuidgen` ## Generates Unique ID

export SUBJECT=”Attach And Embed HTML”

echo "To: $MAILTO"

echo "Subject: $SUBJECT"

echo "MIME-Version: 1.0"