Showing posts from 2017

Error: Server refused our key or No supported authentication methods available

If you use PuTTY to connect to your instance and get either of the following errors, Error: Server refused our key or Error: No supported authentication methods available, verify that you are connecting with the appropriate user name for your AMI. Enter the user name in the User name box in the PuTTY Configuration window.

The appropriate user names are as follows:

For an Amazon Linux AMI, the user name is ec2-user.For a RHEL AMI, the user name is ec2-user or root.For an Ubuntu AMI, the user name is ubuntu or root.For a Centos AMI, the user name is centos.For a Fedora AMI, the user name is ec2-user.For SUSE, the user name is ec2-user or root.Otherwise, if ec2-user and root don't work, check with the AMI provider.


Out Of memory , Not Enough Space Solaris 11

SQL> startup mount ;
ORA-27102: out of memory
SVR4 Error: 12: Not enough space
Additional information: 1671
Additional information: 16106127360
Additional information: 64424509440
The Above error appeared When trying to start Oracle 12c on Solaris 11.3, this is published bug 
Solaris using something called OSM , Optimized Shared memory You can know more about it here 
To avoid this error as workaround just set the parameter

Thanks Osama

Configure AWS Command Line Interface

In this lesson i will show you how to configure AWS command line, and how to start working with your AWS account thru command line with very simple and basic steps :-

First of i will assume that you don't have any user or group in your AWS consolefrom the AWS Console :-

From IAM ( Identity access management ) Choose Group Create Group with permission Administrator access and then hit create.
create user and add that user to the group in my case the group name shown above, save the secret key and access ID as CSV. Now from this link here, Download AWS Command Line Interface depend on your operating system and open cmd , terminal ... etc.Now from Dos enter AWS configure and fill the information like the below:-
Open the command line and test if it's connected to AWS now.
You can learn more about the command line from AWS documentation , if you recive the following error 
"Could not connect to the endpoint URL: ""
Then make sure you are …

failed to associate the token : AWS

Once you create AWS you should activate "Activate MFA on your root account" 

and do that you should use your phone (Iphone, Android) download google authenticator app from the app store/Google Play once the installation is done Scan the QR and Enter the code, the code will be change automatically, if the first try not working and you receive this error " failed to associate the token" uninstall the app and try again.

Thank you

Helping implementer and tester dealing with famous Siebel - based system messages and errors

Upon my colleague Mohammad Altraimat i am publishing this article

 let me gives you a brief  about him , he is currently working with as Siebel Freelance , ensure the functionality of systems, support and train clients to use the systems and collect the requirements from the client and ensure it reflected during his career he developed this document to help people to understand more about Siebel.

You Can Share it But please mention the source of the article or you ask me to share the article with you.

You can find the article here.

Thank you

Weblogic 101 for DBA Webinar

if you want to learn more about web-logic, Register now "Weblogic 101 for DBA"

i will cover different topic during the webinar to give you a better idea about the weblogic concept

Register now here

Thank you

Migrating From AWS to Oracle Using SQL Developer

The Data Uploaded to the Cloud Vendor Amazon web services ( AWS ) But the client decided to move their data on-premises for the first sight you will think this is hard and needs  a lot of work but thank you SQL Developer and Jeff Smith and he is the product manage for SQL Developer amazing man by the way and crossfitter  at the same time :P

However Lets start :-

Open SQL developerChoose Database copy option from tools menu.

Select source database should be AWSProvide hostname only for the AWSListener PortDB NameUsername/Password Test your connection.Select destination database should be Oracle 
Provide hostname only for the AWS.Provide hostname/IP for the server.Listener PortDB NameUsername/Password Test your connection.

Press Next Button, if the migration done before on the same schema press replace and next.

Press Next after choose what you want to move, Data, Functions , Or trigger ... etc
Check Proceed to summary and Press the finish button the migration will start after this,  it will…

Getting Started with Pentesting

Today i received an email for the official publish for Penetration testing tutorial videos , this is another achievement will be added to my security list.

If you want to have alook on the video here

Thank you PackIT for this opportunity

Thank you

Moving from VMware/KVM to the Oracle Cloud

Are you running Vmware or KVM solution in your infrastructure and you are afraid to move your infrastructure to the cloud, Oracle provide and gives one simple solution without losing anything Now you can now easily move your virtual machines to the Oracle cloud using Ravello

and you don't have to change anything from network, storage or anything you did on your local infrastructure to know more about this product.

You can request a free trial account to experience the Ravello’s unique features and
capabilities. For any questions please contact your local Oracle Cloud Infrastructure and
Platform Sales Executive. The following is the URL for requesting the Free Trail

Thank you

Plug and unplug PDB on the Cloud

You can use DBaaS Monitor to plug/Unplug in a pluggable database.

Open Dbaas Monitor like usual 

Once you did this the, you will redirected to new page, in my case i have 2 PDB let's choose one of them and try to unplug it then Plug it again.
From the Right Panel press on the Unplug new screen will be open, As you see from the below picture you should the XML path in your mind in case you need to Plug the database again , put the password same as you use it when you create PDB.

The output should be "PDB unplugged successfully"..

Let's Plug again.
Press on Plug PDB on the right new screen will be opened.

Enter the following ;-
Name of the new PDB You want.The XML file should be saved under directory you choose it

Output should be successfully done.
Osama Mustafa

Administrating Pluggable Database on the cloud - Other Operation you can do on the cloud

In my previous post i discussed how to clone Pluggable database on the cloud using Dbaas monitor, but what else i can do on the cloud

Closing a Pluggable Database

Open Dbaas Monitor

Click on modify State, once you press on it new screen will be open contain which PDB you want to close ( if you have more than once ) and the state ( Open or Close ) with two option immediate and normal.

Press on Show SQL to check the command 

Press OK

Drop Pluggable Database 

Same screen you can drop the database by press on the panel then drop like the following, new screen will be opened you can choose keep the datafiles or delete them it's refer to you

Create Pluggable Database 

The same screen there is option called create PDB press on it.
New Screen will be opened contains different parameters such as the name of the PDB, Password and file name conversion once you enter everything press ok

Cheers Osama Mustafa

Administrating Pluggable Database on the cloud - Clone

You can use DBaaS Monitor to create and drop a pluggable database, open and close a pluggable database, plug in and unplug a pluggable database, and clone a pluggable database.

Let's Start with Clone Database :-

On the DBaaS Monitor home page.
Enter the username and the password of the Dbaas Monitor , username : Dbaas_monitor.
From the upper tab press on database --> Manage 
you will be redirected to new page , this page contains what pluggable database you have , once you choose which one you want to clone, press on the panel and Press on clone
Once you press on clone , new page will be open contains the following 
New PDB Name --> New name for the clone Database.Source PDB --> From where you want to clone.File Name Conversion --> You are using this option in case  you want to change anything in the location of database file/ Storage.
Press on Show SQL 

Once you are done Press on Ok it will take 30 Sec to clone depend on data you have

Cheers Enjoy the Cloud
Osama Mustafa

Access Dbaas monitor

To access Oracle DBaaS Monitor when the HTTPS port is unblocked ( i blogged about this before and how to enable it )

Open the Oracle Database Cloud Service console, from the console 
From the right panel of the services choose Database services monitor and then press on it.New Screen will be openedUsername --> dbaas_monitorPassword -->  the same password you put it for the Dbaas creation.

Thank you  Osama Mustafa

Access Apex On the Cloud Using DBaas

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

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 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 …