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 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"

TNSPING and SQLPlus works but not Able to connect SQL Developer

Error description:

TNSPING and SQLPlus is working perfectly but when I try to connect through SQL developer it is giving error.

Solution description
You will have to set the tnsnames.ora location in the SQL developer configuration

Enable Auto Task Maintenance Jobs in Oracle Scheduler Window Manually

There are 3 auto task maintenance jobs in Oracle and they are listed below.
1.   auto optimizer stats collection
2.   auto space advisor
3.   sql tuning advisor

You can use below mentioned SQL to list the status of the jobs.
select client_name, status

Stop / Drop Scheduled / Running jobs in Oracle

You can use the DBMS_SCHEDULER package itself to stop or drop the job. There are two separate procedure(stop_job and drop_job) exists in the package.In some cases you will have to use the force option to stop the job.

SQL> SELECT job_name, state FROM DBA_SCHEDULER_JOBS where job_name like '%AT_OS_OPT%';


dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google