Oracle – Page 5 – Gokhan Atil's Blog

EM13c: Unique Database Service Names on DBaaS

When creating Database through Oracle Enterprise Manager Self Service Portal, we need to enter a “unique” value as database service name. After I set up DBaaS on EM13c, I made several tests until I fix the provision problems (based on my own faults). On each test, I cleaned up failed request, entered a unique service name and submitted a new request. I thought there’s no validation about the service name but then I got an error message complaning “non-unique service name”.

As we can see, I tried to enter “murtaza” and it says “murtaza” is not available. I knew that I have already cleaned up failed requests, and there is no service named “murtaza”. Anyway I wanted to be sure and decided to check the existing database services. I noticed that there’s no page showing the existing service names! So I had to enter each database service and check the service name. I had only 3 database services, so it didn’t take so much time.

The connection string (which we’ll share with the request owner), contains the service name. I couldn’t find any service named “murtaza”. It must be used for a failed request. As I said, I have already cleared and deleted all failed requests, but somehow the service name was stored in the repository. Good thing is, EMCLI verb “dbaas_artifacts” can show and remove these service names which belongs to failed requests:

# login to OMS as gokhan
./emcli login -username=gokhan

# check the names
./emcli dbaas_artifacts -list_reserved_artifacts 

List of reserved artifacts:

Reserved Name: MURTAZA, Type: SERVICE_NAME, Request Id: 21

# remove the name
./emcli dbaas_artifacts -remove_reserved_artifact -type="SERVICE_NAME" -value="MURTAZA"

Removing the artifact - MURTAZA (SERVICE_NAME) ...
Successfully removed the artifact - MURTAZA (SERVICE_NAME).

# login to OMS as gokhan

./emcli login -username=gokhan

# check the names

./emcli dbaas_artifacts -list_reserved_artifacts

List of reserved artifacts:

Reserved Name: MURTAZA, Type: SERVICE_NAME, Request Id: 21

# remove the name

./emcli dbaas_artifacts -remove_reserved_artifact -type="SERVICE_NAME" -value="MURTAZA"

Removing the artifact - MURTAZA (SERVICE_NAME) ...

Successfully removed the artifact - MURTAZA (SERVICE_NAME).

September 5, 2016Gokhan Atil1 CommentOracleDBaaS, em13c, emcli

Speaking at OOW 2016: Write powerful scripts with EMCLI

This will be my first time to attend Oracle Open World, and I’ll speak about Enterprise Manager Command-Line Interface (EMCLI) Scripting” on User Group Sunday. I already presented it on several conferences, heard people’s feedback and modified the content to improve my presentation. Now I will focus more on practical information, share sample scripts that can be used in real world scenarios. Hope to see you there!

Session ID: UGF3543
Session Title: Oracle Enterprise Manager Cloud Control: Write Powerful Scripts with EMCLI
Room: Moscone West – 3022
Date and Time: 09/18/16, 11:45:00 AM – 12:30:00 PM

Don’t forget to add my session to your schedule to reserve your seat! 🙂

September 1, 2016Gokhan AtilOracleem13c, emcli, oow

EM13c: Performance Tuning Access to Read Only Administrators

About six months ago, when I was in the OUGN Spring Conference, someone asked me how they can let developers access to performance tuning pages on Enterprise Manager Cloud Control 13c. He said that they granted full administrator privileges to the developers so they could access the performance page but it’s not acceptable. He also mentioned that they didn’t need to grant full administration privilege to the developers’ EM users while they were using EM12c.

Unfortunately I forgot to examine the situation until I saw a similar question on OTN (Oracle Community) forum on Friday. The forum reader has exactly the same problem. The database user was already granted required privileges but the EM administrator see the menu items related with “performance tools” are grayed out.

August 28, 2016Gokhan Atil8 CommentsOracleadministrator, em13c, performance

How to Import Data (to Oracle RDBMS) from XML

I wrote a blog post about how to import data from a XML file to Oracle about 7 years ago. I demonstrated how we can use DBMS_XMLSTORE package to parse XML data. Yesterday, I replied a question from a blog reader about that post. He had problem with running my sample script, I did troubleshoot and find out the problem with his script, and while testing the sample script, I noticed that I can write much better script.

This is my sample XML (employees.xml):

<EMPLOYEES>
<EMPLOYEE>
<NO>1</NO>
<NAME>Gokhan Atil</NAME>
</EMPLOYEE>
<EMPLOYEE>
<NO>2</NO>
<NAME>Ned Flanders</NAME>
</EMPLOYEE>
<EMPLOYEE>
<NO>3</NO>
<NAME>Agnes Skinner</NAME>
</EMPLOYEE>
<EMPLOYEE>
<NO>4</NO>
<NAME>Milhouse Van Houten</NAME>
</EMPLOYEE>
</EMPLOYEES>

<NAME>Gokhan Atil</NAME>

</EMPLOYEE>

<NAME>Ned Flanders</NAME>

</EMPLOYEE>

<NAME>Agnes Skinner</NAME>

</EMPLOYEE>

<NAME>Milhouse Van Houten</NAME>

</EMPLOYEE>

</EMPLOYEES>

I created a table to load the data and a directory link so we can access the file:

CREATE TABLE empfromxml ( no NUMBER, name VARCHAR2(50 ));
CREATE DIRECTORY xmltest AS '/oracle/xmltest';

1 2	CREATE TABLE empfromxml ( no NUMBER, name VARCHAR2(50 )); CREATE DIRECTORY xmltest AS '/oracle/xmltest';

August 26, 2016Gokhan Atil6 CommentsOraclexml

EM13c: Unique Database Service Names on DBaaS

Speaking at OOW 2016: Write powerful scripts with EMCLI

EM13c: Performance Tuning Access to Read Only Administrators

How to Import Data (to Oracle RDBMS) from XML

Book Review: Oracle Database Cloud Cookbook with Oracle Enterprise Manager Cloud Control 13c