Feed aggregator

Mount NTFS disk in Linux 7

Darwin IT - Fri, 2016-08-26 06:03
Today I wanted to pass an old disk in a usb-case to my son. It was from an old Windows Laptop and even though I'm administrator, I wasn't able to read the documents in an other user's folder.

So I thought, let's do it from an Oracle Linux 7 VM, as root. But it turns out that Oracle linux did not support NTFS by default.

But with the trick in this link I managed to do it.

To sum up, especially for my self:

Add the EPEL-7 repository from Fedora:
# wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

# rpm -ivh epel-release-latest-7.noarch.rpm

This worked for me. Although I had to step over my issue that I add a Fedora repo to Oracle Linux.... An other option could have been (probably if under Redhat Linux or CentOS:
# yum install epel-release
# yum clean all
# yum update

Install the NTFS-3g package:
# yum install ntfs-3g -y

And enable NTFS support for FileManagers:
# yum install ntfsprogs -y

Then I got to the FileManager and I could browse the disk. It was mounted at '/run/media/oracle/803638DB3638D3BE'.

Links for 2016-08-25 [del.icio.us]

Categories: DBA Blogs

Readers don't block Readers

Tom Kyte - Thu, 2016-08-25 23:06
HI Connor Readers don't block Readers, is this true? As I understand waiting for a resource is also a kind of blocking. I am waiting because the access is blocked. Then please help understanding the below " ---- Another example of a prob...
Categories: DBA Blogs

Oracle forms to create a database user

Tom Kyte - Thu, 2016-08-25 23:06
Hello, Is there a way to create a form with username and password and create the user in the database? I have tried using a host command to log into sqlplus and execute the create user .... but it doesn't want to execute from the form host comm...
Categories: DBA Blogs

WHILE Loop Running forever

Tom Kyte - Thu, 2016-08-25 23:06
Hi , My aim is to print week days from a given date, for ex : IF I provide a date like '12-DEC-2012' ( Which is Thursday ) then my program should print as below FRIDAY SATURDAY But below code is running in a loop for ever, I am unable ...
Categories: DBA Blogs

Lock for "grant"

Tom Kyte - Thu, 2016-08-25 23:06
Hi Tom, When we *grant* a privilege on a table acquires a lock on the table. Just curious to know the following... -- Why does Oracle acquires a lock on the table (apart from grant being a DDL) when we issue a grant. Does it change the definiti...
Categories: DBA Blogs

Synchronous refresh cannot be used for the non-partitioned tables?

Tom Kyte - Thu, 2016-08-25 23:06
Hi, as I want to use the new technology in 12c called "Synchronous refresh" of the MView or group of MViews, I read the documentation ( https://docs.oracle.com/database/121/DWHSG/sync.htm#DWHSG029 ), but for me it's not 100% clear what are the res...
Categories: DBA Blogs

The last query gives the error "Invalid Identifier error".Please explain me whether I have refer the correct table?

Tom Kyte - Thu, 2016-08-25 23:06
---------------------types------------------- create type course_ty1 as object( cid number, titlte varchar(15), credits_req integer ) / create type unit_t as object( ui number(5), credit number(5) ) / create type offering_t as obj...
Categories: DBA Blogs

Oracle ASCIISTR Function with Examples

Complete IT Professional - Thu, 2016-08-25 16:17
In this article, I’ll explain what the Oracle ASCIISTR function does, and show you some examples. Purpose of the Oracle ASCIISTR Function The ASCIISTR function converts a string in any character set to a string in the database character set. If there are any characters that are not ASCII, they are converted to a format […]
Categories: Development

Partner Webcast – Oracle Big Data Preparation Cloud Service: Transform to Self Service Data Preparation for Business Users

When you work with data, the perception is that you spend most of your time on analytics. But in reality, you will devote much more time and effort on importing, profiling, cleansing, repairing,...

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

Accuracy Matters

Tim Hall - Thu, 2016-08-25 13:15

angry-1300616_640One of the annoying things about our industry is the volume of acronyms and very specific terminology used on a day-to-day basis. If you know the lingo you are fine. If not, life can be quite problematic.

In some cases, this is just a smoke screen to hide a lack of true understanding, say enough buzzwords you read in a Gartner report and people will eventually stop asking you to define them, but in other cases it is necessary to be able to communicate *accurately* about complex issues at a reasonable pace.

Some people are completely anal about everything, demanding an incredibly high degree of precision and exact terminology. Deviate from their prescribed ideal and you are in a world of hurt. Others, like myself, allow a lot more slack, knowing that every person is on a different part of the spectrum where this is concerned.

The problem with letting people get away with loose terminology and a lack of accuracy is it can sometimes come back to bite you on the ass. It’s all too easy to let them walk away with an unrealistic view of the situation, that becomes the new office myth, and travels with them through every company they ever work in…

  • Person: So Oracle does this right?
  • Me: Not really. It’s a lot more complicated than that. It’s more accurate to say it does …
  • Person: Yes, but it amounts to the same thing. It basically ends up doing this right?
  • Me: No. It really doesn’t. I can see how it appears that way in this case, but that’s too simplistic a view.
  • Person: Yeah, yeah. I know, but for the sake of argument, we will say it does this, which results in …
  • Me: Fine. That’s wrong, but lets leave that aside and move on…

… One week later …

I’m sure you’ve all been there at some point. It can be a really fine line between getting something across properly and being a total douche. Too far one side of the line and people are walking around believing rubbish. Too far the other way and you end up excluding people and sounding like an elitist prick.

It’s a journey babe!



Accuracy Matters was first posted on August 25, 2016 at 7:15 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

E-Business Suite in the Oracle Cloud

Pat Shuff - Thu, 2016-08-25 09:00
For the last three days we talked about deploying multiple servers and securing the different layers by hiding services in the cloud. Today we are going to go through the installation processes and procedure to install E-Business Suite 12.2.5 (EBS) into a multiple compute cloud instance. We could use this instance for development and test, quality assurance, or even production work if we wanted to. Note that there are many ways to install EBS. We could install everything into Oracle Compute Cloud Services (IaaS) and install WebLogic and the Oracle Database onto Linux servers. We could install the database component into Oracle Database Cloud Services (DBaaS) and the rest on IaaS. We could also install the database into DBaaS, the application into Oracle Java Cloud Services (JaaS), and the rest in IaaS. The current recommended deployment scenario is to deploy everything into IaaS and bring your own licenses for EBS, Database, WebLogic, and Identity Servers.

We are going to go through the tutorial for installing EBS on IaaS for this blog. We are going to go down the multi-node install which first requires installing the provisioning tools to boot all of the other images into standalone instances. We will need at least four compute instances with 500 GB of disk storage to deploy our test. The individual requirements are shown in the diagram below.

Before we can start deploying we must first go to the Oracle Cloud Marketplace and download five EBS bootable images. We start by going to the marketplace and searching for "e-business" images. A list of the images that we need are shown in the diagram below.

Step 1:Download EBS 12.2.5 Fresh Install DB Tier Image. This is done by selecting the image that is returned from the search. When we get to the image page we click on "Get App". This brings up a usage terms screen that we need to click on and click OK. Once we have accepted the terms we are presented with a list of cloud instances that we can deploy into. If you don't see a list of servers you need to go into your preferences for your instance and click the checkbox that allows you to provision the marketplace apps into your instance. You will also need Compute_Admin roles to provision these boot images. You don't need to go to the compute instance after you download the image. You are mainly trying to copy the DB Tier Image into your private images.

Step 2:Download EBS 12.2.5 Demo DB Tier Image. Unfortunately there is no go back feature so you need to go to the marketplace page, search again for e-business, and select the Demo DB Tier Image.

Step 3:Download EBS 12.2.5 Application Tier Image.

Step 4:Download EBS OS-Only Image

Step 5:Download EBS Provisioning Tools Image

Step 6:Verify that all of the images are ready. You should get an email confirmation that the image is ready. You should also be able to create a new instance and see the images in the private images area. You should have five images available and we could create a bootable instance for all of them.

Step 7:Create a compute instance using the Provisioning Tool image. We are going to go with an OC3 instance and accept the default. We will create a new security list and rule that allows http access. We do have to select the boot image from the private image list.

You get to review this before it is provisioned.

This will create an Orchestration that will create the bootable disk and boot the instance. It will take a few minutes to do this and once it is done we should have all of the provisioning tools ready to execute and deploy our multi-node EBS instance.

Step 8:Connect to the server via ssh using opc. Get the ip address from the previous screen. When I first tried to connect I had to add default to the Security List otherwise the connection timed out. Once I added the ssh rule, everything worked as expected.

Step 9:change user to oracle and execute

knife oc image list

You will need the compute endpoint of the compute service because you will be prompted for it. To find this you need to go to the Compute Dashboard and look at the Compute Detail. The RESTapi Endpoint is shown but for our instance we need to change it a little bit. We have two zones associated with this domain. We want to connect to the z16 instead of the z17 zone. Once we enter the endpoint, identity domain, account id, and account password, we get a list of images that we can boot from. At the bottom of the list we see the EBS images and should be good to go. It is important to repeat that using the z17 zone will not show the images so we had to change over to the z16 zone. This is due to a Marketplace configuration that always deploys images into the lowest numbered zone for your instance.

Step 10:Edit /u01/install/APPS/apps-unlimited-ebs/ProvisionEBS.xml and replace the id-domain and user name with the output of the knife command. It is important to note that your substitute command will be a little different from the screen shot below. I also had to change the OS-Image to include the date otherwise the perl script that we are about to execute will fail as well. The file name should be /Compute-obpm44952/pat.shuff@oracle.com/Oracle-E-Business-Suite-OS-Image-12032015 but your instance and user will be different.

Step 11:Run perl /u01/install/APPS/apps-unlimited-ebs/ProvisionEBS.pl to start the install. This will ingest the xml file from the previous section and present you a menu system to install the other instances. The system will again ask for the restAPI Endpoint for the compute server, your restAPI Endpoint for storage (go to Dashboard and click on Storage to get this), your identity domain, account, and password again. For our test installation we selected option 3 for a multi-node single application server installation. The perl script then installs chef, pulls cookbooks, and installs the database, app server, and forms server instances into compute instances. This step will take a while. I recommend playing around with all of the options and configurations until you get comfortable with what you are installing. We were going for the demo installation rather than a dev/test installation. We went for a single app node and a single database node. We could have gone for multiple app nodes and gone with demo or dev deployments. Some of the screen shots from this process are below. We called our installation prsEBS so if you see references to this it relates to our installation. The process deploys orchestrations to the cloud services then starts these services in the Oracle Cloud.

We can confirm that this is doing what is expected by looking at the Orchestration page under the compute console.

When it is complete we will see four instances are running in compute.

In summary, we are able to provision multiple instances that comprise a single application, E-Business Suite. This process is well documented and well scripted. Hopefully these screen shots and steps help you follow the online tutorial mentioned earlier. What is needed next is to apply the security principles that we talked about in the past few days to secure the database and hide it from the public.

Oracle DBTIMEZONE Function with Examples

Complete IT Professional - Thu, 2016-08-25 06:00
In this article, I’ll explain what the Oracle DBTIMEZONE function does, and show you some examples. Purpose of the Oracle DBTIMEZONE Function The DBTIMEZONE function returns the timezone offset of the database, in the format of [+|-]TZH:TZM, or a time zone region name. It’s helpful when working with dates to know what timezone the database […]
Categories: Development

Jet into the Oracle OpenWorld 2016 User Experience Exchange

Usable Apps - Thu, 2016-08-25 05:27

10, 9, 8, 7 ... Ignition Sequence Start ..

Oracle OpenWorld 2016 lifts off in September! And boy, have we been putting some passion and power into that user experience (UX) greatness to share with you. Oracle Applications User Experience (OAUX) Senior Director, Misha Vaughan (@mishavaughan), tells us:

"I am proud to say that the team has even more fantastic experiences lined up for attendees at Oracle OpenWorld this year. Near and dear to my heart is our Oracle OpenWorld User Experience Exchange. This will be our fourth annual event, and it just gets better every year for partners, customers, and analysts alike!"

Consider Yourself Invited

If you are an Oracle Fusion Middleware and PaaS Oracle PartnerNetwork member, Oracle SaaS customer, Oracle Technology Network Ace of any species, or a UX thought leader discovering the world of digital transformation, then you cannot afford not to spend an hour at our Exchange.

If you are a partner, you just might be interested in building a PaaS4SaaS simplified UI using the Oracle JavaScript Extension Toolkit (JET) and Oracle Alta UI, for example. Or perhaps, an Oracle Mobile Application Framework accelerator kit for SaaS UX takes your fancy?

Register here: http://tinyurl.com/OAUX2016 

Oracle Simplified UI for SaaS Rapid Development Kit

Design and Build a SaaS simplified UI UX in hours? No problem.

About the Exchange

This is an exclusive, hands-on, in-person event that demonstrates the Oracle Applications Cloud UX and our shared enablement on offer,  as well as some near-future Oracle UX and technology-based proof of concept ideas that'll inspire you to explore new business opportunities.

Your Exchange Experience

We will be showing the roadmap for the full Oracle SaaS portfolio, extensibility tools for business users to make the Oracle Applications Cloud their own, new mobile app and JavaScript front-end UI Rapid Development Kits for partners to design and build Oracle Cloud service solutions, some cool social innovation projects such as the award-winning Asteroid Data Explorer, innovative magic sauce from the OAUX emerging technologies team (including the incredible "step-in-and-try" Smart Office), and more!


Where is the Exchange located?

It's at the InterContinental Hotel at 888 Howard Street in San Francisco, Ca 94013.

What date and time is the Exchange on?

The open house part of the Exchange is from noon to 6 P.M. on Monday, September 19th, 2016.

There will be private events held after the open house. Contact Shannon.Whiteman(@)oracle.com for inquiries about these events.

Will the Famous Oracle Pokémon GO Cakes be at the Exchange?

There is only one way to find out! 

Register here: http://tinyurl.com/OAUX2016

Pokémon GO cakes at Oracle HQ

Play Pokémon GO at the Exchange? It would be rude not to.

See you at lift off in San Francisco!

Future of Oracle PL\SQL

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, I am working as PL\SQL developer, I wants to know the future job opportunities for PL\SQL,else whether I needs to update my skills in some other technology to survive in IT industry? Kindly do me suggestion. Thanks, Ganesh
Categories: DBA Blogs

Insert statement finished as per user_segment table but session is not releasing control

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, I need to dump data into a temporary table where I do not need to have any data foreigh key, primary key. I kept the table in NOLOGGING mode with parallel 4. I am inserting with /*+ APPEND */ direct path insert. The data is getting inserte...
Categories: DBA Blogs

Oracle SQL Developer

Tom Kyte - Thu, 2016-08-25 04:46
I have a query that returns 50,000 records, how can I quickly get to the last record? if I use the scroll arrow of slide, it takes a long time before it gets to the bottom of the 'Query Results" is there a quick way to go to the last record? I hop...
Categories: DBA Blogs

Identifying only new characters entered in a varchar2 field

Tom Kyte - Thu, 2016-08-25 04:46
I need to write a query that will extract only new characters appended in a text field. Almost like auditing but done by query. Example Select field1 from table1; the dog is running in the park user appends more data into field1 via applicati...
Categories: DBA Blogs

ORA-00201: control file version incompatible with ORACLE version

Tom Kyte - Thu, 2016-08-25 04:46
Hi Tom, We took a backup of prod database running on and refreshed it on test database running on We are unable to start to start our 10g database and receiving an error. We don't have a backup of our controlfiles as they ar...
Categories: DBA Blogs

File IO Stats - AWR

Tom Kyte - Thu, 2016-08-25 04:46
Hi team We have database showing "Av Rd(ms)" in File IO Stats section of the AWR as high as 500 msec. asvc_t ( SERVICE time) value of iostats data for the mount point is well within the acceptable 20 msec. 1) could you please share the sq...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator