Saturday, June 8, 2013

Exalogic vDC Management - Part 4


Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 


I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.
Contact: Franz

Exalogic vDC Management -  Part 4
Adding Users to an Account
Adding cloud users to the Account and granting the privileges to use the resources allocated to the Account; can be done while you create the account, or after you have created the Account.

To add Cloud users after creating an Account, you can follow these steps:
-> On the left navigation panel, click on “vDC Management”.  Under thevDCs, you can click on the default vDC in your Exalogic machine.  Then you can click on the “Accounts” option.  Or you could have just gone to the “Accounts” tab on the top navigation bar.  The “Accounts” page is displayed.

-> Select the Account that you want to work with, for example “Dept1”.

-> On the “Actions” pane, click on “Add Users”.  The “Add Users” wizard is displayed.  On this screen is a list of available Cloud Users on the left, and a list of already assigned Could users on the right hand side.

-> Select the Cloud Users that you would like to assign to the Account, and move them to the Assigned users on the right hand side, by clicking on the right arrow icon.

-> Click on the “Next” button to view the summary screen.

-> Review the Summary screen, and when you are ready, you can click on the “Finish” button to add the Cloud User to the Account

Assigning Networks to an Account
As the Cloud Admin user, you can assign networks like for example Ethernet over InfiniBand (EoIB) to an Account, by following the below steps:
-> In the navigation pane on the left, click on the “vDC Management”.  When you get the list of vDCs in your Exalogic machine, you can click on the name of the default vDC.  Then you select the Account listed under the list of Accounts in your default vDC.

-> Then you must right click on this Account, and choose the “Update Account” option.  The “Update Account” wizard is displayed.

-> On the “Specify Account Details” screen, click on the “Next” button to continue.  The “Specify Account Resource Limits” screen is dislayed.

-> Select the check box that corresponds to the required network type, from the list of Public Networks Resource Limits section.  For example you may have selected “External EoIB Network”.  
In the Limit field, you must specify the number of IP addresses to be allocated from the available addresses.   When you are satisfied, then you can click on the “Next” button.  The Summary screen is displayed.

-> You must review the information in the summary.  For example you must verify that it includes assigned networks under the section “Newly Assigned Public Networks”.

-> Click on the “Finish” button.

Examining the vDC
After performing Cloud Administration tasks, then you should examine the Virtual data Center (vDC) in your Exalogic machine:
-> IN the left navigation pane, you can click on “vDC Management”.  Under the vDCs, you click on the name of the default vDC, in your Exalogic machine.  The vDC Dashboard is displayed in the middle pane of the screen.

-> To examine the Accounts in the vDC, you click on the “Accounts” tab.  On this tab you can view the newly created Accounts.

-> You can examine the networks in the default vDC, by clicking on the “Networks’ tab.  You can continue by clicking on the “Network Configuration” tab, to view the network configuration.  The network configuration page will show you the network infrastructure, for example the public external networks, and the application internal networks in the vDC.   
You can click on the “Network Allocation” tab to view the network allocation details.  Here you will be able to look at the allocation of public IP addresses and the virtual networks (vNets), that have been defined in the vDC.  

Franz Devantier,
Need a database health check, or a security audit?
devantierf@gmail.com

Friday, June 7, 2013

Exalogic vDC Management - Part 3


Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 


I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.
Contact: Franz

Exalogic vDC Management -  Part 3
Establishing Cloud Accounts
Establishing Cloud Accounts in the vDC, involves creating Cloud Users and Cloud Accounts.

Creating Accounts for Cloud Users
For example to create a Cloud Account “Account1” for “User1”, and “Account2” for “User2”, you can follow these steps:
1.) Login to the Exalogic Control as the Cloud admin user.
2.) ON the left Navigation pane, click on “vDC Management”.  Under vDCs, click on the name of the default vDC in your Exalogic machine from the list of vDCs.  Now click on the “Accounts” tab on the top navigation bar, or just click on “Accounts”.  The “Accounts” page is displayed.  Click on the “+” icon to start the “Create Account Wizard”.
3.) In the “Specify Account Details” window, you fill in the fields, for example:
Name: Dept1
Description: Account for Dept1



4.) Click on the “Next” button.  The “Specify Account Resource Limits” screen is displayed.  The Account Resource Limits represent the sum total of all resources that are available to all of the users that will execute in the context of the Account, in this case “dept1”.



5.) You must now enter values for the following fields:
-> vCPU: This field should take an integer value, for example a value of 20 may be appropriate, because this is for the account resource limit.
-> Memory: You can enter a value in Giga-Bytes, which again could be reasonably high, for example: 100 GB.
-> Storage: Again you want to define the storage in Giga-Bytes, which can be reasonably high, because the Exalogic machine has very high total specs, for example: 2000 GB.
-> Number of private vNets: Again this is a number value that can range from 0 to 4096.  If you imagine that about 12 should be more than enough, you can enter a value of 12 here.

While you are entering this information, it is very important to look at the box in the middle of the screen with the heading “Resource Quota Information”.  Make sure that you don’t oversubscribe any of the resources.  The important thing here is to provide appropriate values, and to do proper planning to facilitate the smooth growth of your Exalogic investment.

-> Public Networks Resource Limits:  This table is at the bottom of the screen.  Under here you will find the public networks that are available in the vDC listed.  You need to select the Public Networks that you need to be accessible by the users of the account (Dept1).  On the right hand side of the table, in the “Limit” column, you can specify the number of IP addresses to be allocated from the “Available Addresses” column.

6.) When you are finished, then click on the “Next” button.   The “Assign Users” screen is displayed.


Select the users from the “Available Cloud Users” in the left hand pane, and click on the Arrow icon, to move them across to the “Assigned Cloud Users” in the right hand pane.  After the account creation, you can add additional Cloud users to the Account.

7.) Click on the “Next” button, the “Summary” screen is displayed.

8.) When you have finished reviewing the Summary, then you can click on the “Finish” button to create the Account, for example “Dept1”.

9.) You can continue to create additional accounts, which will be listed under the “Account” on the left navigation pane.  You can also click on the “Accounts” tab on the top navigation bar, to verify that the new Accounts are created and listed.

Franz Devantier,
Need a database health check, or a security audit?
devantierf@gmail.com

Wednesday, June 5, 2013

Exalogic vDC Management - Part 1


Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 


I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.
Contact: Franz

Exalogic vDC Management -  Part 1
Exalogic Virtual Data Center (vDC) Management: Basic Tasks
There are a number of basic tasks related to the Exalogic Virtual Data Center (vDC), the management of which is performed through the browser user interface (BUI) of Exalogic Control.

Logging In as Cloud Admin User
Log in to the Exalogic Control console as the Cloud Admin user.

Examining the Default vDC
Once you are logged in you can examine the default Virtual Data Center (vDC) in your Exalogic machine as follows:
1.) From the left navigation pane, click “vDC Management”.  Under the vDCs, click on the name of the default vDC in your Exalogic machine.  The vDC dashboard will be displayed.  The Exalogic machine has only one default vDC.

2.) Now you can view the vDC dashboard which is the middle pane on the screen.  (MyCloud – Virtual Datacenter)


3.) You can examine the networks in the default vDC, by clicking the Networks tab.  You will then see the network configuration and the network allocation if you click the displayed Network Configuration and Network Allocation tabs, respectively.

The Network Configuration page will show you the network infrastructure, public external networks, and application or internal private networks in the vDC.  The Network Allocation page will also show you the allocation of public IP addresses and virtual networks (vNets) in the vDC.

4.) To view the information about the storage infrastructure in the vDC, you can click “Storage”, which is on the top navigation bar.

5.) You can examine the Oracle VM Server pools in the vDC, by clicking on “Server Pools” in the top navigation bar.

5. Examine the Oracle VM Server pools in the vDC by clicking Server Pools on the
top navigation bar.  The server pools are configured in the Exalogic machine by Exalogic Control by default.

6.) On the top navigation bar you will see “vServer Types”, which you can click on in order to examine the vServer types.

You can create a new vServer type, by completing a few steps:
-> Form the left navigation pane, click on “vDC Management”.  Under vDCs, click on the name of your vDC.  The vDC dashboard will be displayed.
-> From the “Operate” menu on the right hand “Actions”pane, click on “Create vServer Type”.  You will see the vServer Type wizard displayed.
-> Fill in the blank fields, for example: Name, Description, and Tags for the new server type.
-> Click on the Next button.
    The Configure vServer Type screen is displayed.
-> Here you can specify, the Memory Size in GB, and the Number of vCPUs.  When you have everything the way you want it, you can click on the “Next” button.
   The Summary screen will be displayed.
-> Verify that you are happy with the settings on the summary page and click on the “Finish” button.
-> You can verify the newly created vServer type.  Click on the “vServer Types” tab on the top navigation pane.  The newly created vServer Type will be listed with the other vServer Types.

7.) You can examine all the incidents in the vDC by clicking on the “Incidents” tab in the top navigation bar.  In this tab, you will be able to view all the incidents and alerts for the entire vDC.

8.) You can examine all the current and/or historical jobs by clicking on the “Jobs” tab on the top navigation bar.

 Franz Devantier,
Need a database health check, or a security audit?
devantierf@gmail.com

Tuesday, June 4, 2013

Exalogic Managing Machine - Part 7

Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 

I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.

Exalogic Managing Machine  -  Part 7
Viewing the Exalogic System Report
You can also view existing reports or create new reports.  The Exalogic report contains a few sections:
-> Report Parameters
-> Summary Table
-> System Control Software Table
-> Compute Nodes Table
-> Switches Table
-> Storage Appliances Table
-> Power Distribution Units Table
-> Validation Table

Report Parameters
The Report Parameters section will display the name and the model of the Exalogic system.  It will also display the number of assets in the rack, by their types, as for example Compute nodes, switches, storage Nodes in the System.



Summary Table
The Summary Table is a list of all the detailed tables in the full report.  It will also display the number of records for each detail table.


System Control Software Table
The System Control Software table has a list of points that it lists:
-> Exalogic Control software components
-> Versions of Exalogic control software components
-> Descriptions
-> Names of VMs running Exalogic Control
-> Names of Oracle VM Servers hosting Exalogic Control VMs

Compute Nodes Table
The rack setup is displayed in the Compute nodes tables, which has the following entries:
-> Type of Asset
-> Name of asset or compute node
-> Firmware version, such as the BIOS, and the service processor, and the HCA adapter
-> Version and location of the asset in the rack

Switches Table
The switches tables displays the information that is relevant to the switch, such as:
-> The name of the switch node
-> Type of switch
-> Firmware version
-> Location of the switch in the rack
-> Slot number where it is placed

Storage Appliances Table
The Storage Appliances table, displays information relevant to the appliances such as:
-> Name of the compute Node
-> Version of the service processor firmware
-> Location of the appliance with the slot number
-> Where it is placed in the rack

Power Distribution Units Table
The table displays the Power Distribution Units (PDUs) and their firmware version.

Validation Table
This table will display the validation result of the rack.  A baseline check is performed against the known schema for the rack.  The “Expected Component” displays the expected component, only if the placed component in the slot does not match the schema, when the baseline check is performed.



Franz Devantier,
Need a database health check, or a security audit?
devantierf@gmail.com

Monday, June 3, 2013

Exalogic Managing Machine - Part 6

Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 

I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.


Exalogic Managing Machine  -  Part 6
Creating and Viewing Exalogic Reports
Not only can you look at the photorealistic view of the server, but you can also look at reports to view the Exalogic rack setup.  Such reports will include information about your assets, such as the job history, firmware versions, OS updates, and problems.  You can choose to have your reports in PDF format or in CSV format.  You can export your reports, or use the report to launch jobs on targeted assets.

Creating an Exalogic System Report
To create an Exalogic report from the Exalogic Control center, you will need to complete a few steps:
1.) Firstly, on the Navigation pane, click on “Reports”, then click on “Exalogic System Report”.



2.) On the Actions  pane, click on “Create Exalogic System Report”.  This will bring up and display the “Create Exalogic System Report” wizard.

In the “Define Report Parameters” window, you will fill in a few fields.
-> Report Name:  Enter a name for the report
-> Description: Enter a short description of the report
-> Schedule: There is a check box for you to click if you want to run the report later on, or on a recurring basis or schedule.
-> Output Format: check the CSV box, or the PDF box or both.

3.) Click on the “Next” button to proceed.  Because you checked the schedule box, the schedule screen will be displayed.


On the Schedule window, you will need to select one of the following options.
-> Now:  Create the report job and run immediately
-> At a later date/time: Create and run the report job at a specific time
-> On a Recurring Schedule: Create and run the report job at a set time, and at a set interval.
. Select the Start time
. Select the end time
. Select the number of hours between reports, to create the intervals

4.) Click the “Next” button.  The summary screen is displayed
5.) Review the Summary, and then click on “Run and Close”

You could also have clicked on “Save Template and Close”, instead of “Run and Close”.  In this way you will save the report template.  You can use the report template later to run similar reports.

Franz Devantier,
Need a database health check, or a security audit?
devantierf@gmail.com

Sunday, June 2, 2013

Exalogic Managing Machine - Part 5

Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 

I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.


Exalogic Managing Machine  -  Part 5
Viewing the Photorealistic Representation of Exalogic Machine
The photorealistic view is a representation of the Exalogic physical rack.  The front and the rear views of the rack are displayed in this view.  You can see the rack layout with all of its components.  All the slots and the respective assets are accurately displayed.  Each asset in the rack is represented by an image.

The health status of the assets, such as “OK”, “Warning”, or “Critical”, are displayed in the form of coloured lights, that match the physical rack, almost like a photograph.  This means that you don’t have to physically be in front of the machine, in order to see how it is running.  You could be some distance away from the physical machine, and still see a photorealistic representation of the health status of the assets.  The OK status is shown in green, whilst the warning and critical statuses are shown in yellow.  You can hover the mouse over the slots in the rack to view information about the health etc of the specific assets.

The type of information that you can view by hovering the mouse over the slot, is the:
-> Slot number
-> Asset name
-> Description
-> Type of asset
-> Model number of the asset
-> The health status of the asset

A question mark in any of the slots indicates a discrepancy from the baseline chack.

To see the photorealistic view of the rack, there are a few steps to perform:
1.) ON the Navigation plane, under Assets, select Exalogic Systems
2.) Select a rack that you want to view
3.) In the center pane, click on the Details Tab

Now a photorealistic view of the rack will be displayed for you.

Franz Devantier,
Need a database health check, or a security audit?
devantierf@gmail.com

Saturday, June 1, 2013

Exalogic Managing Machine - Part 4

Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 

I will make a deal with you:  If you refer me to a company that needs database support, from a few hours per week to full time, and I am able to sign a contract with them.
Then I will give you 10% of the monthly contract or deal price every month.  When the contract ends, and we re-sign the contract, I will again give you 10% of the monthly contract price.  This will go on until the company no longer employs or contracts me or my agents to look after their databases.
I can do this, because that 10% is my marketing budget.  When we re-sign the contract, in the future, it may depend on you giving the thumbs up again, and that is worth 10% of the monthly contract price, to be given to you as commission.


Exalogic Managing Machine  -  Part 4
Infrastructure Networks
If you click on the Networks tab, then you will get the information for the infrastructure networks that are used in the Exalogic machine for communication between the different Exalogic Control Components, and vServers in the Exalogic vDC.

For each infrastructure network you will find the following information:
-> Network Name: This displays the name of the managed network
-> Network CIDR: This displays the type of asset.
-> Partition Key:  This displays the partition of the port.
-> IP Range: This specifies the minimum and maximum boundaries of the IP addresses assigned to the network.
-> Roles: This displays the role.
-> Network Connectivity Table: The network connectivity section displays the infrastructure networks with IPs assigned to the individual hardware components of the Exalogic system.
-> Network Name:
-> Asset Type:

Viewing Unassigned Incidents and Alerts
You can click on the final Tab on the center pane, the Incidents Tab.  On this page you can view all the unassigned incidents and alerts in your Exalogic system.
  



You can view all the incidents from this screen.  You can also take actions to resolve them from this screen.

Viewing the Exalogic Machine Rack
You can view the Exalogic System Rack, the visualization of the rack or the physical layout, aggregated rack components.  You can look at energy data, and other rack details.  As the Exalogic system admin, you can drill down to any asset contained in the rack, such as a compute node, a storage node, a switch, a PDU, and then you can drill down further from that component.

To get to the view of the Exalogic System rack, you need to complete a few steps.
-> On the Navigation pane, under Assets, select Exalogic Systems.
-> Then you must select one of the racks that you want to view.  You will see displayed the:
. rack ID
. Description of the rack
. Schematic view of the assets with the rack.

-> Then you can select one of the displayed components of the asset in the rack and view the asset details. 

Franz Devantier,
Need a database health check, or a security audit?
devantierf@gmail.com