DBA Blogs

Declare a variable of type DATE using var

Tom Kyte - Thu, 2018-06-07 01:46
Tom, How do I declare a variable of type DATE in SQL*Plus? All I see is CHAR/NCHAR, VARCHAR2/NVARCHAR2, CLOB/NCLOB, REFCURSOR, NUMBER, BINARY_FLOAT and BINARY_DOUBLE. Thanks...
Categories: DBA Blogs

How to Remove Japanese SEO Spam from your Website ?

iMERGE Group - Wed, 2018-06-06 11:51
Discovering the Hack1. Identify infected pages using Google Search
You can uncover such pages by opening Google Search and searching for:
site:[your site root URL] japan
Navigate through some pages of the search results to see if you discover any suspicious looking URLs. These are the pages indexed by Google containing the word ‘japan’. If you notice pages with the Japanese characters in the title or description, it is likely that your website is infected.
Japanese SEO Spam in Google Search Results

2. Verify with Security Issues Tool in Google Search Console
In your Google Search Console (earlier called Google Webmaster Tools), navigate to the Security Issues Tool in the left sidebar.
Google Search Console Security Issues Tool
3. Fetch as Google to check for ‘Cloaking’
When you visit any of these hacked pages, you might see a 404 not found page suggesting that the web page doesn’t exist. Be careful, the hacker may be using a technique called cloaking. Check for clocking by using the “Fetch as Google” tool in your Google Search Console.
Fixing the Japanese SEO Spam Hack1. Remove any newly created user accounts in the Search Console
If you don’t recognize any users in the “Users and Property Owners” tab, immediately their revoke access. Websites hacked with the Japanese SEO Spam add spammy Gmail accounts as admins so that they can change your site’s settings like sitemaps and geotargeting.
2. Run a Malware Scan
Scan your web server for malware and malicious files using the ‘Virus Scanner’ tool in the cPanel provided by your web host.
3. Check your .htaccess file
Hackers often use the .htaccess file to redirect users and search engines to different malicious pages. Verify the contents of the .htaccess file from a last known clean version of the file from your backups. If you find any suspicious code, comment it out by putting the ‘#’ character in front of the rule.
4. Check Recently Modified Files
Login to your web server via SSH and execute the following command to find the most recently modified files:
find /path-of-www -type f -printf '%TY-%Tm-%Td %TT %p\n' | sort -r
If you are an Astra customer, you would have received an email telling you about malicious file changes.
5. Check your Sitemap
A hacker may modified, or added a new sitemap to get the Japanese SEO Spam pages indexed quickly. If you notice any suspicious links in the sitemap, ensure that you quickly update your CMS core files from a last known clean backup.
 6. Prevent future attacks with a Website Firewall
Another option to prevent the Japanese SEO Spam infections is to use a Website Firwall.


If you are still looking for an expert then feel free to reach out to us at support@ingressit.com and someone from our team will surely help you. 


Categories: DBA Blogs

interpret trace file

Tom Kyte - Wed, 2018-06-06 07:26
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.2 CPU : 12 - type 8664, 6 Physical Cores Process Af...
Categories: DBA Blogs

SQL statements inside AWR views

Tom Kyte - Wed, 2018-06-06 07:26
Hi Tom, I'm trying to find the history of executions for a given sql statement by using AWR views like DBA_HIST_ACTIVE_SESS_HISTORY, DBA_HIST_SQLSTAT, DBA_HIST_SQLTEXT, DBA_HIST_SQL_PLAN etc. I find the SQL_IDs for SQL by querying DBA_HIST_SQLT...
Categories: DBA Blogs

Display master child data as a set - from 2 different tables

Tom Kyte - Wed, 2018-06-06 07:26
Hi , I will be glad if you could help me in this. I have a Parent Table ( ORDER_HEADER ) and a Child table ( ORDER_LINE ). They are linked by order_id. ORDER_HEADER holds order details for customers and ORDER_LINE holds the child lines for ea...
Categories: DBA Blogs

Parsing a CLOB field with CSV data and put the contents into it proper fields

Tom Kyte - Wed, 2018-06-06 07:26
My Question is a variation of the one originally posted on 11/9/2015. parsing a CLOB field which contains CSV data. My delimited data that is loaded into a clob field contains output in the form attribute=data~ The clob field can contain up to 6...
Categories: DBA Blogs

process limit and sessions

Tom Kyte - Wed, 2018-06-06 07:26
Hi there, For the past few days,during the peak hours i am getting the following error in a frequent way " Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found " I googled it first,...
Categories: DBA Blogs

Which is default if session is interrupted - COMMIT or ROLLBACK?

Tom Kyte - Wed, 2018-06-06 07:26
Hi Tom, I use Oracle SQL Developer. I do not use autocommit and in normal situation I always use after some block of SQL commands (INSERT, DELETE etc.) COMMIT, or ROLLBACK. But what does happen if I do not finish this block of SQL command in...
Categories: DBA Blogs

Composite Range-Hash interval partitioning with LOB

Tom Kyte - Tue, 2018-06-05 13:06
Hi, I would like to partition a table with a LOB column using Range-Hash interval partitioning scheme. But I not sure how the exact partition gets distributed in this scenario and also I noticed following differences based on how I specify my p...
Categories: DBA Blogs

Index Column Order – Impact On Index Branch Blocks Part I (Day-In Day-Out)

Richard Foote - Mon, 2018-06-04 07:16
I recently replied on Twitter to some comments regarding an excellent blog post by Franck Pachot – Covering indexes in Oracle, and branch size, where I disagreed somewhat with one of the conclusions stated in the post: “ensure that selective columns appear as early as possible (without compromising the index access efficiency of course) in order to […]
Categories: DBA Blogs

SID YES SERVICE_NAME NO in tnsnames.ora

Tom Kyte - Sun, 2018-06-03 06:06
Hello Tom, We use tnsnames.ora . 1) What is the difference between SID entry and SERVICE_NAME in the tnsnames.ora 2) When I put SID the connection is successful, when I put SERVICE_NAME it says tns could not resolve service name So This w...
Categories: DBA Blogs

Application Development Services Update

Application Container Cloud Service Secure Environment Variables Environment variables can now be secured by using the user interface or the deployment.json file. The value of the secure...

We share our skills to maximize your revenue!
Categories: DBA Blogs

storing password history

Tom Kyte - Fri, 2018-06-01 17:26
<code> I have a table create table user_password_history (user_cd varchar2(3), user_pass varchar2(30), created_date date); i want to keep last 5 records of each user in this table. kindly guide me how to achieve it. Thanks for your suppor...
Categories: DBA Blogs

The one case where we need an index rebuild - how to avoid it?

Tom Kyte - Fri, 2018-06-01 17:26
Having read Tom's books I know that in general there's no reason to rebuild indexes, and so we don't. However, we have one particular index which does benefit from rebuilding. Since it's a locally-partitioned index on a date-partitioned table we ...
Categories: DBA Blogs

CHAR Index (vs) NUMERIC Index

Tom Kyte - Fri, 2018-06-01 17:26
Hi Tom, In comparison to an Index on CHAR field and Index on NUMERIC field pls let me know which Index(whether CHAR or NUMERIC) would be faster. Thanx & Regards, Madhusudhana Rao.P
Categories: DBA Blogs

TNS-12541 : TNS: No Listener

Tom Kyte - Fri, 2018-06-01 17:26
Hi, In order to configure Standby database I have created one listener "Prod" & TNS Service "To_Stand" on Primary Side.Listener created successfully & its running.But the problem is TNS is not establishing connection with the database.Its saying "No...
Categories: DBA Blogs

locking explain plan table

Tom Kyte - Thu, 2018-05-31 04:46
Hi Tom, while creating explain plan for query, explain plan table is getting locked until commit or rollback. If we don't want to commit / rollback, is it a problem that explain plan table stays locked? also while it is locked we don't have any prob...
Categories: DBA Blogs

crsctl and background processes of rac

Tom Kyte - Thu, 2018-05-31 04:46
Hi Tom, Which background process or any process works to retrieve the result of command "crsctl stat res -t" Regards, S.Alam
Categories: DBA Blogs

How to generate some big test tables and rapidly export their SQL data

Tom Kyte - Wed, 2018-05-30 10:26
Hello teams, Our Developer manager asks me to export Oracle production database's three big tables with <i><b>CSV</b></i> or this format <i><b>"insert ... into ..."</b></i> for giving another App teams (their database is MySQL 5.7) once again, I r...
Categories: DBA Blogs

Database Link between Oracle 10g and Oracle 12c

Tom Kyte - Wed, 2018-05-30 10:26
Dears, am trying to create a dblink between Oracle 10g and Oracle 12c the dblink is created successfully my case is as below when select data from a table directly over dblink give the result without problems but call a package or stored procedur...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator - DBA Blogs