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"

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.


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

RMAN-08591: WARNING: invalid archived log deletion policy

Warning Description:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

old RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

new RMAN configuration parameters:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

new RMAN configuration parameters are successfully stored

starting full resync of recovery catalog

full resync complete

Insert to Oracle View failed with ORA-01779: cannot modify a column which maps to a non key-preserved table

Error description:

ORA-01779 error is coming while inserting into view

Solution Description:

Views are two types in terms of update to the view-Updateable and non-updateable. When you try to insert to the non-updateable views you will get the error ORA-01779: cannot modify a column which maps to a non key-preserved table

Where/How to Check Alert Log File in Oracle 12c?

Prior versions as a DBA we used 

to check the alert logs in background_dump_dest directory. But in 11g onwards the alert log file location is changed to different location mentioned below. The second option is adrci which is the easiest way to access the alert log files for the databases which are running on the box.