ACED – Technology Geek

Access Apex On the Cloud Using DBaas

Posted on April 4, 2017December 23, 2018 by Osama Mustafa in Cloud

Oracle Database Cloud Service include Oracle Application Express, which you manage using the Oracle Application Express administration console. You access this administration console by going to the Oracle Application Express.

To access the Apex Application on the cloud;-

From the Dbaas you want, press on the tool panel and choose Apex.

To use the Apex you need to enable https on your cloud, to do this you have to access to compute services –> network and choose https

After doing this you will be able to access to Apex Page enter the following information:-

In the Workspace box, enter INTERNAL.
In the Username box, enter ADMIN.
In the password box, enter your password.

Enjoy the cloud

Cheers

Osama mustafa

Enable master key Encryption Key for a PDB on the cloud

Posted on April 3, 2017December 23, 2018 by Osama Mustafa in Cloud

SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;Master Key Encryption allow you to encrypt sensitive data, such as credit card numbers, stored in table columns. Encrypted data is transparently decrypted for a database user who has access to the data. Transparent data encryption helps protect data stored on media in the event that the storage media or data file gets stolen for more information about it here.

After creating Database on the cloud ( Dbaas ) you can enable the master key by using the below steps :-

First of all you need to check the name of the container that you want to enable master key.

select con_id, dbid, name from v$pdbs;

as you see my container name is PDB1 set the session to this.

ALTER SESSION SET CONTAINER = PDB1;

Check the location for the wallet by running the below query :-

SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;

Back to Root Container run the below query to see the wallet parameter type there is two value autologin or password each one of them having it’s own usage, in my case the value set to password.

Now i should close the wallet depend on the wallet type in my case it’s set as password then i will use the below for more information about ADMINISTER KEY MANAGEMENT here

ADMINISTER KEY MANAGEMENT SET KEYSTORE close IDENTIFIED BY Mypassword;

When i tried to open the wallet using the same password i set it before.

ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY MyPassword CONTAINER=all

But my wallet is closed, i found oracle support document here Document number 1944507.1 which discuss this error and provide a solution for this error you can back to this document.

Once you apply the solution you will be able to open the wallet as below.

Welcome to TDE on the cloud.

Thank you

Osama Mustafa

Create Backup On Demand On the Cloud

Posted on March 19, 2017December 23, 2018 by Osama Mustafa in Cloud

In This Post i will show how to create backup for Dbaas :-

Open the Oracle Database Cloud Service console.
Click the database deployment for which you want to create a backup.
Click the Administration tile.
Click Backup Now and then confirm the action.

Or you can use the command line by connect to your compute node as root use and run the following command :-

To create a backup that follows the current retention policy

# /var/opt/oracle/bkup_api/bkup_api bkup_start

To create a long-term backup

# /var/opt/oracle/bkup_api/bkup_api bkup_start –keep

Check Status

# /var/opt/oracle/bkup_api/bkup_api bkup_status

Rentation in the cloud like the following :-

Both Cloud Storage and Local Storage: 30 days, with the 7 most recent days’ backups available on local storage
Cloud Storage Only: 30 days
Local Storage Only: 7 days

Enjoy the cloud

Osama

Oracle Cloud Services

Posted on March 12, 2017December 23, 2018 by Osama Mustafa in Cloud

During the last week i was working on Oracle Cloud Closely and i would like to summarize what Oracle Cloud Services Provide,and Short Description for each services :-

Oracle Compute Cloud Service

In this Services you control the cloud, use a variety of Oracle Compute Cloud Service resources and you can control form here the following :

disk images.
compute shapes
storage volumes.
IP reservations.
security lists.
security rules.
secure shell.

Oracle Storage Cloud Service containers

In this Following servvices, back up to cloud storage, vy using Oracle Storage Cloud Service containers as repositories for backups to the cloud But before you start working on this you should create container and active account.

Oracle Application container Services

Provides a lightweight infrastructure so that you can run applications in the Oracle Cloud.

Oracle Big Data Cloud Services

The power of Hadoop and Spark delivered as a secure, automated, high-performance service, which can be fully integrated with existing enterprise data but in the cloud.

Oracle Cloud Stack Services

to create and use templates that automate the provisioning of services like Oracle Compute Cloud Service in different format HTML, PDF, ePub and Mobi formats.

Oracle Event Hub Cloud Services

delivers the power of Kafka as a managed streaming data platform integrated with the rest of Oracle’s Cloud. with services you can loading and analyzing streaming data.

Oracle Golden Gate Cloud Services.

GoldenGate Cloud Service is a cloud based real-time data integration and replication service, which provides seamless data movement from various on-premises relational databases to databases in the cloud with sub-second latency while maintaining data consistency and offering fault tolerance and resiliency.

Oracle Java Cloud Services

provides an enterprise-grade platform to develop and deploy Java applications in the public cloud.

Oracle MYSQL Cloud Services

Delivers a secure, cost-effective and enterprise-grade MySQL database service. Built on MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise ready MySQL cloud service, enabling organizations to increase business agility and reduce costs.

Oracle SOA Cloud Services

Provides a PaaS computing platform for running Oracle SOA Suite, Oracle Service Bus and Integration Analytics in the cloud this cloud services supports multiple service types in case any of integration will happened.

I tried to make everything simple, each one of these services have a complete Oracle documentation how to work on it.

Thanks
Osama

Oracle Database 12cR2 Documentation is here

Posted on February 12, 2017December 23, 2018 by Osama Mustafa in News

Finally Oracle 12cR2 documentation is here

also All Books for Oracle® Database Online is here

Cheers

Osama

Oracle Open World 2015 review

Posted on November 1, 2015December 23, 2018 by Osama Mustafa in News

As all of you know Oracle open world 2015 finished before 2 days ago, and simply it’s was amazing, my trip started on OCT-21-2015 Wenseday and it’s was totally morning flight which mean i supposed to be in airport at 4:00 am because of to avoid miss my flight i didn’t sleep, the flight was from Jordan – Amman to Turkey – IST and then to SF, when i landed in IST i met my old friend Gurcan Orhan this man is awesome, he managed everything from our seats to waiting in the lounge but i have to say he spent 11 hours sleeping from IST- SF. meanwhile i was watching San Andres movie which i discovered later it was bad idea , in case you didn’t watch it’s movie talking about earthquake happened in San Francisco, actually i watched all the entertainment movie and i was thinking what i will go when i will be back home ? simply i watch San Andres again.

anyway we landed after 13 hours of flying and we met the great Tim Hall the great oracle guy i am sure this man is helping a lot of DBA with his amazing blog. so we took the shuttle “tim, Gurcan, Arup,cary , simon and me”.

Don’t forget this is was my first OOW15 as ACED :), so i attended ACED Breifing and meet my old friends there, during the two days i learnt alot of new things about Oracle that i can’t mention it here because the NDA, and i want to thanks Oracle ACE program to organizing all this and make it true so let’s skip this part.

OOW15 started on sunday with an amazing weather, attending session about RAC, Database just like arup said ” there is database and everything else” and sure the middleware sessions.

I had so much fun & learning, the funny thing that i met Deiby and nassyam for the first time and these guys are simply funny and crazy 🙂 i think we can be called the four musketeers “Me, Alex Zaballa, Deiby and Nassyam”

Let’s not forget the amazing friend all over the world such as : Bobby, Danny Bryant, Kellyn, Heli, Steve , Kevin ,Mahir, kamran, sai ram, Joel and a lot of amazing people and friends but i can’t feel my fingers 🙂

Also The ACE dinner on Sunday night was awesome,almost all the ACE’s in one place and we had so much there, in OOW I lost twice with F1 Simulation but i want one of these machine anyway.

and i noticed that i am not good at all when i am eating spicy food i spent my time like the following one hand drink water the other one wiping my tears. thanks for Sai , Nassyam and Hariharaputhran.

there is so much to say about OOW15 but this is as quick review for it and if you have any more question about it you can ask me 🙂

Thanks

Osama

Error : Cannot export Display Linux

Posted on September 10, 2015December 23, 2018 by Osama Mustafa in Operating system

There are different tools to do X11 forwarding on Windows one of them Xming it’s small software and very easy to use no need to do any special configuration only run the installation file.

But sometimes you are using this application and try to run the GUI on your desktop or laptop it’s working like you excepted, one simple solution to solve it.

I am using as ssh client Putty, before put the server ip from putty left panel

Connection > SSH > X11
Check X11 forwarding: [x] Enable X11 forwarding
Add to the “X display location” field: localhost:0.0

Cheers

Osama

System is in manitance mode. Please try again later OBIEE

Posted on August 25, 2015December 23, 2018 by Osama Mustafa in Fusion Middleware

When trying to update any reports in OBIEE the below errors appears :-

to solve this issue just follow the screen :-

1- Access to OBIEE Link http://ip-hostname:9704/analytics
2- Choose Administration from the upper right corner.

3- Turn Maintenance mode to off by press the link.

Good Luck.

Cheers
Osama