How to Avoid / Remove Adsense Ads from Homepage / Archive Page in Blog


As per Google Adsense policy you are supposed to display 3 image and 3 links ads per page. But, if you set your blog home page with multiple items, normally the blogger will display ads for the first few posts and after the 3 ads it will show the empty slots in the homepage. This is applicable for the archive page with multiple items. The empty slots will give a bad look for your blog; moreover it is Adsense policy violation. You can get rid of this by implementing this sample code in your blog HTML.

Steps for RMAN Recovery from Old Incarnation without Catalog

Here is one example for RMAN recovery from old previous incarnation without catalog.

Step 1
Find out your control file backup file name from RC_BACKUP_FILES table with respect your DBID / Old incarnation.

Connect to RMAN catalog and run
RMAN> LIST INCARNATION OF DATABASE DEVDB01;

ORA-20021: database not set: Select From RC_BACKUP_FILES Table failed

Error Description
SQL> select distinct BS_TAG from rc_backup_files;
select distinct BS_TAG from rc_backup_files
*
ERROR at line 1:
ORA-20021: database not set
ORA-06512: at "RMAN.DBMS_RCVMAN", line 22314
ORA-06512: at "RMAN.RC_LBRECSETIMPL_T", line 58

How to Use ORADEBUG to Find out Trace file name

Facts on ORADEBUG
  1. You have to connect as sysdba to use/execute the ORADEBUG
  2. It can be executed from the SQLPlus prompt

How to Use ORADEBUG CURRENT_SQL to See Other Session SQL

Facts on ORADEBUG
  1. You have to connect as sysdba to use/execute the ORADEBUG
  2. It can be executed from the SQLPlus prompt
Example
Here I am giving you an example of ORADEBUG to check the SQL statement running on other session using a session with sysdba privilege.

FireFox: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser



Installation of the Yahoo Axis search bar on  FireFox browser is easy from the axis.yahoo.com. Yahoo Axis is not a normal browser like Google or Bing. This will install a permanent search bar on the browser like an ad-on. The search bar will be in the bottom left corner of the browser. This search bar stretch or pop-up when the cursor move on top it.

Internet Explorer: Uninstall / Disable / Remove Yahoo Axis Search Bar from IE Browser


Installation of the Yahoo Axis search bar on Internet Explorer (IE) browser is easy from the axis.yahoo.com. Yahoo Axis is not a normal browser like Google or Bing. This will install a permanent search bar on the browser like an ad-on.

Google Chrome: Uninstall / Disable / Remove Yahoo Axis Search Bar from Browser


Installation of the Yahoo Axis search bar on Google Chrome browser is easy from the axis.yahoo.com. Yahoo Axis is not a normal browser like Google or Bing. This will install a permanent search bar on the browser like an ad-on. The search bar will be in the bottom left corner of the browser. This search bar stretch or pop-up when the cursor move on top it.

Traffic after Registering Custom Domain for Blogger Blogspot - My Experience

It is always good to have a custom domain for your blogs. This will give better credibility to your blog. I wanted to share my experience on blog traffic after registering the custom domain.
1. Search engine indexing time.
Since the domain is new to the search engine, it will take time to crawl and index all the pages in your blog again. Sometimes it may take weeks time to index the entire blog content.

Work Around for ORA-00600: [kkpo_rcinfo_defstg:objnotfound], [75312]

This error occurs because of the oracle bug. Most of the time it happens with the database with deferred_segment_creation=true and the error will be specific to a database object. The object id for the particular object will be the second argument in the ORA-00600 error. Object name can be identified from the trace file mentioned in the first ora-00600 error in the alert.log file.

Find out Maximum, Current Limit of Oracle Resources (Session, Process, Lock) using v$resource_limit


V$resource_limit dynamic view provides the details of resources like sessions, processes, locks etc. It has the initialization values for the resources, maximum limit reached after the last database startup and current utilization of the resource.

Purpose of ORAENV_ASK=NO / YES variable in Oracle


It is mandatory to set ORACLE_SID, ORACLE_HOME environments to connect to the oracle database. Oracle provides a script called oraenv to set or change these variables. ORAENV_ASK environment variable is used to make the oraenv (/usr/local/bin/oraenv) script to interactive or non-interactive.

If you set the parameter value as YES (default) it will ask for the values ORACLE_SID, ORACLE_HOME. If you set the value as NO it will take blank or the values which is set already for the ORACLE_ parameters.

Data Pump EXPDP IMPDP content=METADATA_ONLY to Extract the Skeleton of the Oracle Database

Purpose of Content Option: Using this parameter you can choose the export / import utility for taking the metadata/metadata&data/data_only in to the dump file. The one of the benefit of this option is you can create the similar kind of database/ schema without data using the option content=METADATA. i.e. you can easily create a skeleton of the source. The dump size will not be a big one and you can easily import into the target schema or database.

You can take the data only dump also by setting the parameter value as DATA_ONLY.

How to Check / Find out the Privileges and Roles for My Own Session Oracle


Most of the time, as a SQL programmer user might not be having the privilege to select the data dictionary views to check the permissions of the user sessions. In Oracle any of the users can check their own privileges using following commands after connecting to the SQLPLUS using their credentials.

a.  SELECT * FROM SESSION_ROLES;
Above query will give you which and all roles assigned to your user.
b.  SELECT * FROM SESSION_PRIVS;
This one will give you which and all privileges assigned to your user.

ORA-00059: maximum number of DB_FILES exceeded - Fix / Resolve Oracle Add Datafile Error


Error Description: Create tablespace, add data file command failed with following error.

SQL> CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/testdb/TEST01.dbf' size 50m;
CREATE TABLESPACE TEST DATAFILE '/u01/app/oracle/oradata/testdb/TEST01.dbf' size 50m
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

ORA-28001: the password has expired - Permanent Fix for NOEXPIRY for Oracle User


Error Description: ORA-28001: the password has expired message is getting while connect to the user.

SQL> CONNECT TEST/TEST;
ERROR:
ORA-28001: the password has expired


 

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