Work From Home Is it good or bad ?

Pandemic Situation all over the world ( Yaa.. Origin country has recovered ..) has pushed all workers except essential service employees to work from home..

Due to technology work from home is exercised so fluently that many companies thinking of making it as a future working strategy to cut down expenses invested on infrastructure.

While many employees are on cloud 9 due to work from home facility , but their are few who are still thinking this is not a good option for future at all . And i am one of those few !!




Lets have a look what's the gain & the pain ..

Why Work from Home is too good ?

Migraine Disease and Social Conflict

More than 30% population of world has migraine chronic disease and many more yet to identify.

Migraine headache occurs due to its presence in genes or stressful lifestyle , individual has to understand their type of headache and recover or reduce from migraine pain.  

Everyone one who suffer from such illness differs from others mainly during migraine episodes and the learning from such incident leads to finding a solution to keep the pain away as much as possible , but this process causes Social conflict.

Why Migraine causes social conflict ?

ORA-28040: No matching authentication protocol

ORA- Error:


Connection could not be rolled back
java.sql.SQLException: ORA-28040: No matching authentication protocol
com.ing.sdm.exceptions.DMMConfigException: java.sql.SQLException: ORA-28040: No matching authentication protocol
at com.ing.sdm.sql.SQLHelper.createConnection(SQLHelper.java:110)
at com.ing.sdm.sql.SQLHelper.getConnection(SQLHelper.java:92)
at com.ing.sdm.dataimport.DataImporter.<init>(DataImporter.java:83)
at com.ing.sdm.ImportTool.main(ImportTool.java:87)

SP2-0027: Input is too long (> 4999 characters)

Error:


SP2-0027: Input is too long (> 4999 characters)




Cause:


The SQL builder tool used does not support characters over 4999 in a single line command.

ORA-39001: invalid argument value ORA-01775: looping chain of synonyms during export import expdp impdp

ORA- Error :



$expdp parfile=exp_mis_rpt_base.par
Export: Release 11.2.0.4.0 - Production on Tue Jul 14 09:30:48 2020
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORA-39001: invalid argument value
ORA-01775: looping chain of synonyms

How to avoid getting Dengue Fever and cure it fast : a personal experience

Each year, an estimated 390 million dengue infections occur around the world. Of these, around 5 million cases develop into severe dengue, which results in up to 25,000 deaths annually worldwide.

Dengue Fever is the most dangerous form of fever as it becomes life threatening if not detected in early stages or treatment is delayed. Dengue fever doesn't have medicine to cure it rapidly it has to go through stages of treatment and human immunity response to medicines for recovery matters most.   

To cure from dengue fever the most important step is to prevent it at first , knowing more about dengue helps to attain this step.

What is Dengue Fever ?

Dengue fever is a mosquito borne disease caused by the dengue virus. Dengue virus is primarily transmitted by Aedes mosquito bites.

ORA-01720: grant option does not exist for

ORA- Error:


SQL> GRANT SELECT on MP_DEPORT_ARTEX_PS_AGR to ORACLE_ASA_ROLE;
GRANT SELECT on MP_DEPORT_ARTEX_PS_AGR to ORACLE_ASA_ROLE
*
ERROR at line 1:

ORA-01720: grant option does not exist for 'NEW_ASU_USER.ASU_FINAL_PO_AGR'

SQL>SHOW USER

"NEW_ALT_USER"

Cause:

How to recover from Migraine headache : a personal experience

Over 39% population in world suffers Migraine headache and it has no cure yet in medical science , the only solution is lifestyle correction which can reduce the impact on life.

Various articles cover scientific reason behind Migraine Headache , however i am writing my personal experience how i struggle through the migraine pain and overcome to reduce its frequency from 2-3 times a week to 1-2 time in a month without medicines many times .

How to install Linux on virtual machine in 3 easy steps

Install ubuntu linux using virtual machine on laptop or PC in 3 east steps.  As given in below link or click here

After installing Linux ubuntu virtual host you can use the same for learning UNIX , installing database or application software to improve you hands-on skills.

ORA-13605: The specified task or object does not exist for the current user

ORA- Error:

SQL>Begin
dbms_sqltune.Execute_tuning_task (task_name => 'sql_sta_01151548_85fakm008r9z9');
end;
/

ERROR:
ORA-13605: The specified task or object sql_sta_01151548_85fakm008r9z9 does not exist for the current user.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.PRVT_ADVISOR", line 5900
ORA-06512: at "SYS.DBMS_SQLTUNE", line 926
ORA-06512: at line 1


Cause/Solution:

I.  The User which is logged into db to create the tuning task doesn't have advisor privilege ; Grant advisor,administer sql tuning set to solve the error

SQL>grant advisor to scott;

SQL>grant administer sql tuning set to scott;

II.  ORA-13605 caused due to ORA-13780 ; as sql statement itself not found in the workload history while creating a tuning task.

SQL> DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
sql_id =>'85fakm008r9z9',
scope => 'COMPREHENSIVE',
time_limit => 600,
task_name => 'sql_sta_01151548_85fakm008r9z9',
description => 'Task to tune a query autbywjufccpd');
END;
/ 

ERROR at line 1:
ORA-13780: SQL statement does not exist.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.PRVT_SQLADV_INFRA", line 125
ORA-06512: at "SYS.DBMS_SQLTUNE", line 655
ORA-06512: at line 4


ORA-13780 can be solved by specifying the AWR begin_snap  and end_snap id in create tuning task code to allow tuning task to search for the sql statement in specific range of workload where it exists. 

SQL> DECLARE
my_task_name VARCHAR2(30);
BEGIN
my_task_name := DBMS_SQLTUNE.CREATE_TUNING_TASK(
begin_snap => 291940,
end_snap => 292266,
sql_id =>'85fakm008r9z9',
scope => 'COMPREHENSIVE',
time_limit => 600,
task_name => 'sql_sta_01151548_85fakm008r9z9',
description => 'Task to tune a query autbywjufccpd');
END;
/ 

PL/SQL procedure successfully completed.



Once tuning task is created successfully, execute the tuning task to get desired result.


SQL>Begin
dbms_sqltune.Execute_tuning_task (task_name => 'sql_sta_01151548_85fakm008r9z9');
end;
/

PL/SQL procedure successfully completed.

Retrieve the Advisory Report ..

SQL>set long 900000
SQL>set linesize 9000
SQL>set pages 9000
SQL>col TUNING_ADVICE_85fakm008r9z9 for a9000
SQL>select dbms_sqltune.report_tuning_task('sql_sta_01151548_85fakm008r9z9') TUNING_ADVICE_85fakm008r9z9 from dual;

PL/SQL procedure successfully completed.

Solved !!!