Feed aggregator

ORA 1017 error while connecting to the database as SYS using SQL developer

Tom Kyte - Sat, 2017-09-23 02:26
I changed the SYS user password in database I recreated the password file using Oracle Doc ID 1029539.6 Now when I try to login to the database using SQL developer it gives the ORA 1017 error Am I missing any step here ? please advise ... ...
Categories: DBA Blogs

How to see SGA usage for all active and inactive sessions i.e SGA used by each process / session

Tom Kyte - Sat, 2017-09-23 02:26
Recently , I ran into a System Global Area (SGA) related alert as below : SGA USAGE INST_ID TOTAL_MB USED_MB FREE_MB FREE_PCNT 1 168836.35 105033.66 43802.71 29 And these alert kept on showing frequently for pas...
Categories: DBA Blogs

Protect access to certain data from the DBA

Tom Kyte - Sat, 2017-09-23 02:26
This question has probably been asked many times, but I cannot find a solid solution. We are required to restrict access (select/insert/update/delete) to certain database tables even from the DBA. As far as I know, only Database Vault can do this rel...
Categories: DBA Blogs

Does Foreign Key constraint (No Validate) impact on performance?

Tom Kyte - Sat, 2017-09-23 02:26
We have imported data from PROD to UAT environment. While import foreign key constraints enabled as No Validate. Both the tables parent table and child tables have huge number of rows. How can we tune the queries referencing to these two tables, s...
Categories: DBA Blogs

Tom Kyte Blog

Tom Kyte - Sat, 2017-09-23 02:26
Hi, What has happened to Tom Kyte's blog http://tkyte.blogspot.com/. Can you add me to white list of that blog ? Will be very great-full. Thanks Fahd
Categories: DBA Blogs

Combination of selected columns from one table to be made primary key column value in other table

Tom Kyte - Sat, 2017-09-23 02:26
Hi, I have a cust_bug_test table with 2 columns(ROOT_CAUSE, BUG_NUMBER) like as follows: <code>create table cust_bug_test(ROOT_CAUSE VARCHAR(250), BUG_NUMBER NUMBER NOT NULL PRIMARY KEY); insert into cust_bug_test(ROOT_CAUSE, BUG_NUMBER ) valu...
Categories: DBA Blogs


Tom Kyte - Sat, 2017-09-23 02:26
Hi Tom, When we use the FOR-UPDATE clause in cursors, we lock the rows which we intend to work on. Also, we use BULK COLLECT to process huge amount for rows to save time. Let's considering a scenario that a cursor is fetching rows for bulk pro...
Categories: DBA Blogs

Duplicate blog to laptop VM

Bobby Durrett's DBA Blog - Fri, 2017-09-22 18:48

I started to write this blog post and then realized that in the process of making a copy of my blog on my laptop I whacked my connection to WordPress. But, it was easy to resolve it by disconnecting Jetpack from WordPress, clearing my browser cache, and then reconnecting. Whew! I worried that messing with this stuff would cause some problem but the blog still seems to work.

My idea was to bring up a copy of this blog site on a VirtualBox VM on my laptop. I have thought about doing this in the past but did not have any good reason to do so. I have mainly acted like an end user for this blog software and to iPage, the company that hosts it. I have not tried to delve into the underlying PHP code or mess with the MySQL database. But, my database team has recently started supporting MySQL and I am trying to train myself up a bit so it made sense to play with duplicating this small MySQL app.

I duplicated the blog in three main steps:

  1. Setup a VirtualBox VM
  2. Setup a MySQL database
  3. Setup the web site


I am still using the VirtualBox NAT networking that I described in an earlier post. I created a VM called Blog with this ip and port forwarding details:

Blog ip

Blog port forwarding

61014 to 22
61015 to 80

I duplicated an existing Oracle Enterprise Linux 7 VM and modified the ip and setup the port forwarding. Then I did a yum update to catch up all the existing packages. I also disabled the firewall so that it would not get in the way.

yum -y update
systemctl disable firewalld
systemctl stop firewalld


I downloaded mysql57-community-release-el7-11.noarch.rpm from http://dev.mysql.com/downloads/repo/yum/ and ran the following commands to install MySQL:

yum localinstall mysql57-community-release-el7-11.noarch.rpm
yum install mysql-community-server
service mysqld start
service mysqld status

Then I ran a series of SQL commands logged into MySQL to setup the user and database for the blog:

grep 'temporary password' /var/log/mysqld.log

mysql -uroot -p
use temporary root password

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Bl0gC0py!';


GRANT ALL PRIVILEGES ON blogdb.* TO "blogdbuser"@"localhost"



Next I took a backup of my blog database that I got from iPage and made the following string replacements in the SQL commands:

Replace all instances of






replace with










I was trying to make sure that I didn’t whack anything in my real blog and that it worked with my localhost:61015 web site host name and port. I had to add two lines to the beginning of the sql script to make it work:

use blogdb
SET sql_mode = '';

I ran the script like this:

mysql -v --force -ublogdbuser -pBl0gC0py! < database.sql > database.out 2> database.err

I checked database.err and it only had a warning about using the password on the command line.


Now that the database was setup and loaded with data I worked on the web site.

First, I installed the Linux packages for php which pulled in the web server as a dependency:

yum install php php-common php-mysql php-gd php-xml php-mbstring php-mcrypt 

Edited httpd.conf to setup web server:

vi /etc/httpd/conf/httpd.conf

Replace all instances of AllowOverride None or none
with AllowOverride all

Added VirtualHost lines at the end:

Added host to /etc/hosts

vi /etc/hosts

add this line  blog

I forgot to mention in step 1 that when I created the VM I renamed it to blog using hostnamectl.

Next I created the web site directory and populated it with files from my ftp backup of my website.

mkdir /var/www/html/wordpress

copy my blog files to /var/www/html/wordpress

Next I edited the WordPress configuration file to work with the database:

cd /var/www/html/wordpress

vi wp-config.php

/** The name of the database for WordPress */
define('DB_NAME', 'blogdb');

/** MySQL database username */
define('DB_USER', 'blogdbuser');

/** MySQL database password */
define('DB_PASSWORD', 'Bl0gC0py!');

/** MySQL hostname */
define('DB_HOST', 'localhost');

Finally I restarted the web server and set the web server to automatically start on reboot:

systemctl restart httpd.service 

systemctl enable httpd.service

Finally, I tested the web site at http://localhost:61015 and it looked a lot like this blog site.


Categories: DBA Blogs

Security Alert CVE-2017-9805 Released

Oracle Security Team - Fri, 2017-09-22 15:10

Last week, Equifax identified an Apache Struts 2 vulnerability, CVE-2017-5638, as having been exploited in a significant security incident. Oracle distributed the Apache Foundation’s fixes for CVE-2017-5638 several months ago in the April 2017 Critical Patch Update, which should have already been applied to customer systems well before this breach came to light.

Recently, the Apache Foundation released fixes for a number of additional Apache Struts 2 vulnerabilities, including CVE-2017-9805, CVE-2017-7672, CVE-2017-9787, CVE-2017-9791, CVE-2017-9793, CVE-2017-9804, and CVE-2017-12611. Oracle just published Security Alert CVE-2017-9805 in order to distribute these fixes to our customers. Please refer to the Security Alert advisory for the technical details of these bugs as well as the CVSS Base Score information.

Oracle strongly recommends that customers apply the fixes contained in this Security Alert as soon as possible. Furthermore, Oracle reminds customers that they should keep up with security releases and should have applied the July 2017 Critical Patch Update (the most recent Critical Patch Update release).

The next Critical Patch Update release is on October 17, 2017.

For More Information:

The Security Alerts and Critical Patch Updates page is located at https://www.oracle.com/technetwork/topics/security/alerts-086861.html

A blog entry titled "Take Advantage of Oracle Software Security Assurance" is located at https://blogs.oracle.com/oraclesecurity/take-advantage-of-oracle-software-security-assurance. This blog entry provides a description of the Critical Patch Update and Security Alert programs and general recommendations around security patching.

Integrigy at Oracle Open World 2017

Integrigy will be presenting again this year on database security at Oracle Open World 2017 (San Francisco, October 1-5).  If you will be attending Open World, please join us for this informative session on database security.

The Thrifty DBA Does Database Security

Sunday, Oct 01, 10:45 a.m. - 11:30 a.m. | Moscone South - Room 159

Stephen Kost, Founder and CTO, Integrigy Corporation

Properly securing an Oracle Database requires significant effort and often expensive security add-on products. The Thrifty DBA likes having secure databases, but doesn’t like to spend money on expensive security products when equivalent zero or low-cost solutions are available. In this session discover thrifty yet effective security solutions to solve auditing, encryption, virtual private database, and authentication challenges.

Integrated Cloud Platform:  Database, Identity and Security

Code:  SUN5690

Please let us know if you would like to meet while at Open World to discuss Oracle Database or Oracle E-Business Suite security.

Oracle Database, Conference
Categories: APPS Blogs, Security Blogs

This week's &nbsp;<a href="http:/

David Kurtz - Fri, 2017-09-22 09:22
This week's  PeopleSoft Administrator Podcast includes a few minutes of me talking to Dan and Kyle about Oracle Resource Manager.
(22 September 2017) #99 - Oracle Resource Manager You can listen to the podcast on psadmin.io, or subscribe with your favourite podcast player, or in iTunes.

Insert Large set of data from View to Table faster

Tom Kyte - Fri, 2017-09-22 08:06
<b></b>Hi Tom, Good morning. We have a dynamic view which is growing day by day due to the combinations are increasing. SO we have decided to create a table from the view , for which we have created a procedure which runs fine but it takes lo...
Categories: DBA Blogs

java stored procedure retrieving file from FTP

Tom Kyte - Fri, 2017-09-22 08:06
Hi Tom, I've made java stored procedure that retrives file from FTP. The java program works well on local system but on database it hangs and not working and I should stop the OracleService to stop it. The below is what I did for making the jav...
Categories: DBA Blogs

TNS error about 'TNS-12535 and TNS-00505' in alert log file of my Oracle ?

Tom Kyte - Fri, 2017-09-22 08:06
Hi,teams I found that there has a plenty of TNS error about 'TNS-12535 and TNS-00505' in alert log file of my Oracle part content as follows, <code> ...... *********************************************************************** Fata...
Categories: DBA Blogs

selecting rows from a table

Tom Kyte - Fri, 2017-09-22 08:06
Hi, I have a cust_bug_test table with 2 columns(ROOT_CAUSE, BUG_NUMBER) like as follows: create table cust_bug_test(ROOT_CAUSE VARCHAR(250), BUG_NUMBER NUMBER NOT NULL PRIMARY KEY) insert into cust_bug_test(ROOT_CAUSE, BUG_NUMBER ) values('Thi...
Categories: DBA Blogs

Test to be performed after Critical Patch Application

Tom Kyte - Fri, 2017-09-22 08:06
Hello Oracle Masters, Thanks for taking the time and answer our questions! Is there any kind of test or validation to run after applying the critical patch update? I have applied the Critical Patch Update - July 2017 and would like to know i...
Categories: DBA Blogs

how to traverse the tree in reverse direction?

Tom Kyte - Fri, 2017-09-22 08:06
dear Tom, In a hierarchical query how do I traverse the tree from the branch level to the top? Say in the emp->manager case, given the empno, I want to find his manager, manager's manager etc. thanks,
Categories: DBA Blogs

Sysdate with TimeZone

Tom Kyte - Fri, 2017-09-22 08:06
Hi, I am trying to get the date with time zone in the below format (ISO 8601 I GUESS) YYYY-MM-DDThh:mm:ss.sTZD (eg 1997-07-16T19:20:30.45+01:00) where: YYYY = four-digit year MM = two-digit month (01=January, etc.) DD ...
Categories: DBA Blogs

Unify Update - v1.0.1

Rittman Mead Consulting - Fri, 2017-09-22 07:54
Unify Update - v1.0.1

Unify Update - v1.0.1

We have updated Unify following feedback from our customers and have released version 1.0.1. The following bugs have been fixed and features added:

  • Change the default port to 3724 as 8080 is the default port of Oracle XE.
  • Allow port configuration in the desktop app.
  • Fixed problem with date filters not working with >, >=, <, <= operators.
  • Fixed some problems using presentation variables used in filters.
  • Made the preview table scale to the resolution of the screen instead of being fixed size.
  • Enabled parsing for dashboard pages, so an OBIEE page can be opened and each report from it will be loaded into Unify.
  • Made viewing column or filter panes optional in the UI.
  • Improved tray icons for Mac distribution of the Desktop app.
  • Distinguish measures and attributes with icons in the presentation layer.
  • Allow queries from multiple subject areas.
  • Switched to Tableau WDC 2.0.9 to facilitate compatbility with Tableau 10.0.

You download Unify from our website: https://unify.ritt.md

Categories: BI & Warehousing

EBS 12.2 Upgrade Guides Updated and Streamlined

Steven Chan - Fri, 2017-09-22 02:15

A significant number of customers have successfully upgraded to Oracle E-Business Suite Release 12.2.  Along the way, they have given us a great deal of feedback on how we could improve our certified upgrade processes and documentation.

I'm pleased to announce that we have incorporated their feedback into the latest published upgrade guides available in the Oracle E-Business Suite Web Library and on the Oracle E-Business Suite Release 12.2.7 media.

What's New?

The following enhancements have been made to the Oracle E-Business Suite Release 12.0/12.1-to-12.2 and 11i-to-12.2 Upgrade Guides:

  • Reorganized and simplified chapters and steps
  • Provided clarity around the overall upgrade process and major steps using diagrams
  • Reduced the number of self references and external references and confirmed all remaining references
  • Created new documentation tags for actionable references and steps

If you are already working on your upgrade to Oracle E-Business Suite 12.2, there's no need to switch to the recently updated upgrade guide. If you are getting ready to start your upgrade, be sure to use the latest updated upgrade guide.


Related Articles

Categories: APPS Blogs


Subscribe to Oracle FAQ aggregator