WIP...............
WEBLOGIC INSTALLATION,CONFIGURATION , COLLECTING HEAPDUMP
WEBLOGIC INSTALLATION,CONFIGURATION , COLLECTING HEAPDUMP
Sunday 17 July 2016
ORACLE DATABASE
WIP.................
Yet to update:Database Architecture, Memory structure,Background process
DDL,DML,DCL command, SQL Basic commands,
Basic sql queries:-
1)To check the first date, last date,first year date,last year date
syn:- select trunc (sysdate, 'month') "first day of current month" from dual;
select trunc (last_day (sysdate)) "last day of current month" from dual;
select trunc (sysdate, 'year') "year first day" from dual;
select add_months (trunc (sysdate, 'year'), 12) -1 "year last day" from dual;
o/p
SQL> select trunc (sysdate, 'month') "first day of current month" from dual;
first day
---------
01-JUL-16
Yet to update:Database Architecture, Memory structure,Background process
DDL,DML,DCL command, SQL Basic commands,
Basic sql queries:-
1)To check the first date, last date,first year date,last year date
syn:- select trunc (sysdate, 'month') "first day of current month" from dual;
select trunc (last_day (sysdate)) "last day of current month" from dual;
select trunc (sysdate, 'year') "year first day" from dual;
select add_months (trunc (sysdate, 'year'), 12) -1 "year last day" from dual;
o/p
SQL> select trunc (sysdate, 'month') "first day of current month" from dual;
first day
---------
01-JUL-16
SQL> select trunc (last_day (sysdate)) "last day of current month" from dual;
last day
---------
31-JUL-16
SQL>
SQL> select trunc (sysdate, 'year') "year first day" from dual;
year firs
---------
01-JAN-16
SQL
SQL> select add_months (trunc (sysdate, 'year'), 12) -1 "year last day" from dual;
SQL> select add_months (trunc (sysdate, 'year'), 12) -1 "year last day" from dual;
year last
---------
31
SQL> select add_months (trunc (sysdate, 'year'), 12) -1 "year last day" from dual;
year last
---------
31-DEC-16
SQL>
You can use the below link for any ref" http://viralpatel.net/blogs/useful-oracle-queries/"
2) Create a table and do insert , update delete.
syn:
create table student (id int, name char, age int );
insert into student(id,name,age) values('121','r','20');
delete from student where name='r';
o/p
SQL> create table student (id int, name char, age int );
Table created.
SQL>
SQL> desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
NAME CHAR(1)
AGE NUMBER(38)
SQL> insert into student(id,name,age) values('121','r','20');
1 row created.
SQL> desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
NAME CHAR(1)
AGE NUMBER(38)
SQL> select * from student;
ID N AGE
---------- - ----------
121 r 20
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
123 e 23
SQL> delete from student where
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL> select * from student;
ID N AGE
---------- - ----------
121 r 20
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL> select * from student;
ID N AGE
---------- - ----------
121 r 20
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL>
2) Create a table and do insert , update delete.
syn:
create table student (id int, name char, age int );
insert into student(id,name,age) values('121','r','20');
delete from student where name='r';
o/p
SQL> create table student (id int, name char, age int );
Table created.
SQL>
SQL> desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
NAME CHAR(1)
AGE NUMBER(38)
SQL> insert into student(id,name,age) values('121','r','20');
1 row created.
SQL> desc student;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
NAME CHAR(1)
AGE NUMBER(38)
SQL> select * from student;
ID N AGE
---------- - ----------
121 r 20
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
123 e 23
SQL> delete from student where
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL> select * from student;
ID N AGE
---------- - ----------
121 r 20
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL> select * from student;
ID N AGE
---------- - ----------
121 r 20
123 e 23
SQL> delete from student where name='r';
1 row deleted.
SQL> select * from student;
ID N AGE
---------- - ----------
123 e 23
SQL>
SQL> select add_months (trunc (sysdate, 'year'), 12) -1 "year last day" from dual;
year last
---------
31
ORACLE EXADATA
This blog all about basics and brief of Exadata Features ,RACK overview, Storage Server
Architecture& Process ,Oracle ASM & RAC, Layers of Storage Disks, Flash Cache, Smart
Scan/Off loading, Storage Indexes ,HCC,ILOM
Note:-Please click all screenshot attached to view the text clearly.
The Oracle Exadata Database Machine X4-2 is the fifth generation database machine. It features the most advanced architecture, using industry-standard database servers, built-in management, intelligent storage servers, and a high speed InfiniBand network that interconnects servers and storage for faster data access and delivery.
There are a number of new innovations and enhancements in the latest release,delivering higher consolidation density, lower total cost of ownership and improved performance.
Exadata X4-2’s Compute Power: Exadata X4 Storage:
· 50% more database cores · 2X larger physical flash memory
· 2X larger database
server local storage · . Up to 4X larger logical flash memory
· 2X faster InfiniBand network 2X larger disks
Key database optimizations include:
For 1/8th and 1/4 th Configuration is same across the Rack
Database node, storage nodes,switches --Update pending
>>List of Command line interface utility for compute node and Cell node show below in diag
Architecture& Process ,Oracle ASM & RAC, Layers of Storage Disks, Flash Cache, Smart
Scan/Off loading, Storage Indexes ,HCC,ILOM
The Oracle Exadata Database Machine X4-2 is the fifth generation database machine. It features the most advanced architecture, using industry-standard database servers, built-in management, intelligent storage servers, and a high speed InfiniBand network that interconnects servers and storage for faster data access and delivery.
There are a number of new innovations and enhancements in the latest release,delivering higher consolidation density, lower total cost of ownership and improved performance.
Greater performance and capacity:-
Exadata X4-2’s Compute Power: Exadata X4 Storage:
· 50% more database cores · 2X larger physical flash memory
· 2X larger database
server local storage · . Up to 4X larger logical flash memory
· 2X faster InfiniBand network 2X larger disks
Key database optimizations include:
- More database query offload to storage can offload searches of LOBs
- Database optimized compression now includes Hybrid Columnar enhancements for transaction processing
- Database optimized PCI Flash enables ultra high speed flash compression (X4) at multi-million IOs/second, as well as caching for table scans and faster file initialization
- Database optimized QoS prioritizes CPU and IO use by multitenant pluggable database (12c)
- Database optimized availability allows for prioritized recovery of critical database files
- Database optimized messaging prioritization of critical database messages, including log writes and Oracle Real Application Clusters
Why Exadata ?
Exadata Database Machine is designed to address common issues:
>>Data Warehousing issues:
Supports large, complex queries
Managing Multi-Terabyte databases
>> OLTP issues:
Supporting large user populations and transaction volumes
Delivering quick and consistent response times
>> Consolidation issues:
Efficiently supporting mixed workloads(OLTP & OLAP)
Prioritizing workloads(IORM)
>> Configuration Issues:
Creating a balanced configuration without bottlenecks
Building and maintaining a robust system that works
>>Redundant and Fault Tolerant:
Failure of any component is tolerated.
Data is mirrored across storage servers
Basic Components of Exadata are Compute node(DB node, Cell nodes, Ibswitches,PDU's,Cisco
switches).
switches).
For 1/8th and 1/4 th Configuration is same across the Rack
Database node, storage nodes,switches --Update pending
>>List of Command line interface utility for compute node and Cell node show below in diag
 |
| Diag 1:Command categories |
- CellCLI - the Exadata Storage Server. To manage this, Oracle provides a command line tool: CellCLI (Cell Command Line Interpreter). All the cell-related commands are entered through the CellCLI.
- DCLI - The scope of the CellCLI command is the cell where it is run, not in other cells. Sometimes you may want to execute a command across multiple cells from one command prompt, e.g. shutting down multiple nodes. There is another command line tool for that: DCLI.
- SQL – Once the cell disks are made available to the database nodes, the rest of the work is similar to what happens in a typical Oracle RAC database, in the language you use every day: SQL. SQL*Plus is an interface many DBAs use. You can also use other interfaces such as Oracle SQL Developer. If you have Grid Control, there are lots of commands you don’t even need to remember; they will be GUI based.
- ASMCMD – ASMCMD this is the command line interface for managing ASM resources like diskgroups, backups, etc.
- SRVCTL – SRVTCL is a command-line interface to manage Oracle Database 11.2 RAC Clusters. At the database level, most of the commands related to cluster, e.g. starting/stopping cluster resources, checking for status, etc. can be done through this interface.
- CRSCTL – CRSCTL Cis another tool to manage clusters. As of 11.2, the need to use this tool has dwindled to near zero. But there is at least one command in this category.
- These are the basic categories of the commands. Of these only CellCLI and DCLI are Exadata specific. The rest, especially SQL, should be very familiar to DBAs.
ORACLE EXALOGIC
ORACLE EXALOGIC
----------------------------
This blog contains Components of Exalogic, Architecture, Details of all components,
OTD ,Patching,Issues. (will be updating others )
Note:Please click all screenshots attached in blog to view the text clearly
Basic Components of Exalogic:-
--------------------------------------
Compute node
ZFS storage appliance
Infiniband switches
Infiniband spine switches
PDU's
Cisco Admin switches
Exalogic released with full rack, half rack,quarter rack, 1/4 rack as well as machine named x4-2,x5-2,x3-2 .
Oracle released Both Physical and Virtual Environment.
Physical will have all above components
Virtual Environment includes all the above components with additional Virtual server.\\\
COMPONENTS OF EXALOGIC ELASTIC CLOUD SYSTEM:
An Exalogic configuration consists of the following major components:
Exabus
x86 Compute Nodes
ZFS Storage Appliance
Oracle VM (hypervisor)
Exalogic Control
Oracle Traffic Director
Exalogic System Utilities
Oracle Virtual Assembly Builder (OVAB)
YET TO UPDATE ABOUT THE NETWORKS OF EXALOGIC.........
How to install OTD version 11.1.1.9.0
-----------------------------------------------------
OTD INSTALLATION&CONFIGURATION ,version-- 11.1.1.9.0
Steps to follow:-
------------------
1)Download the file from OTN "ofm_otd_linux_11.1.1.9.0_64_disk1_1of1.zip"
2)Unzip the file
3)You will be getting a directory called "Disk1"
4)Run the installer from /Disk1 directory screen shot attached below
4)You can change the Oracle home location which you preferred as per the requirement setup
5) Once the above steps done, click next
6)Click next and finish
7)OTD installation end here.
..
Steps to create a Admin server
----------------------------------------
In command line interface
(I)CREATE ADMIN SERVER
<oraclehome>/bin/tadm configure-server --user=otd_admin --server-user=root --instance-home=/home/remyar/otd_remya/
The default port number for OTD is 8989, you can use any port which you preferred.
(2)START THE OTD
----------------------------
This blog contains Components of Exalogic, Architecture, Details of all components,
OTD ,Patching,Issues. (will be updating others )
Note:Please click all screenshots attached in blog to view the text clearly
- Oracle Exalogic is an integrated hardware and software system designed to provide a complete platform for a wide range of application types and widely varied workloads. Exalogic is used for large-scale,performance-sensitive, mission-critical application deployments. It target towards combining Oracle Fusion Middleware software and industry-standard Sun hardware to enable a high degree of isolation between concurrently deployed applications to leverage security, reliability, and performance requirements.Exalogic facilitates customers to develop a single environment that support end-to-end consolidation of their entire applications portfolio.
- Minimum latency
- Maximum through put.
Cloud services by facilitating IaaS and SaaS.
DIAGRAM SHOWS THE OVERVIEW AND THE COMPONENTS OF EXALOGIC
Basic Components of Exalogic:-
--------------------------------------
Compute node
ZFS storage appliance
Infiniband switches
Infiniband spine switches
PDU's
Cisco Admin switches
Exalogic released with full rack, half rack,quarter rack, 1/4 rack as well as machine named x4-2,x5-2,x3-2 .
Hardware component 1/8th 1/4th 1/2 full
Compute node 4 8 16 30
ZFS storage appliance 2 2 2 2
Infiniband switches 2 2 2 2
Infiniband spine switches 0 0 1 1
PDU's 2 2 2 2
Cisco Admin switches 1 1 1 1
Oracle released Both Physical and Virtual Environment.
Physical will have all above components
Virtual Environment includes all the above components with additional Virtual server.\\\
COMPONENTS OF EXALOGIC ELASTIC CLOUD SYSTEM:
An Exalogic configuration consists of the following major components:
Exabus
x86 Compute Nodes
ZFS Storage Appliance
Oracle VM (hypervisor)
Exalogic Control
Oracle Traffic Director
Exalogic System Utilities
Oracle Virtual Assembly Builder (OVAB)
YET TO UPDATE ABOUT THE NETWORKS OF EXALOGIC.........
How to install OTD version 11.1.1.9.0
-----------------------------------------------------
OTD INSTALLATION&CONFIGURATION ,version-- 11.1.1.9.0
Steps to follow:-
------------------
1)Download the file from OTN "ofm_otd_linux_11.1.1.9.0_64_disk1_1of1.zip"
2)Unzip the file
3)You will be getting a directory called "Disk1"
4)Run the installer from /Disk1 directory screen shot attached below
4)You can change the Oracle home location which you preferred as per the requirement setup
5) Once the above steps done, click next
6)Click next and finish
7)OTD installation end here.
..
Steps to create a Admin server
----------------------------------------
In command line interface
(I)CREATE ADMIN SERVER
<oraclehome>/bin/tadm configure-server --user=otd_admin --server-user=root --instance-home=/home/remyar/otd_remya/
The default port number for OTD is 8989, you can use any port which you preferred.
(2)START THE OTD
start the OTD via startserv in CLI
>>/home/remyar/otd_remya/admin-server/bin/startserv
o/p as per below screen shots.
Access the OTD console via http:<hostname:8989>
To create a origin server pool, adding instances... updating ...WIP
Oracle Traffic Director Optimizations
Enabling SDP use to the wls origin servers
You can also optimize the communication between the OTD nodes and WLS
managed servers in the Origin Server Pool. The optimization is to enable OTD to
communicate with the origin server pool managed servers using the SDP protocol.
By doing so, the communication channel between the OTD frontend and the WLS
application tier is optimized to the fullest extent to take advantage of the Exabus
performance capabilities. Configuration change is required on both the OTD and the
WLS ends.
OTD
1. Log in to the OTD administration console for your environment using the
browser.
2. Select Server Pools and then origin-server-pool-1 that you created.
3. Search for the Address Family and using the drop down list change it to inetsdp.
4.Click Save.
5. Select each of the origin servers in the origin-server-pool.
6. Change the port from 7101 to 7102
7. Click Save.
8. Deploy both these changes
>>/home/remyar/otd_remya/admin-server/bin/startserv
o/p as per below screen shots.
To create a origin server pool, adding instances... updating ...WIP
Oracle Traffic Director Optimizations
Enabling SDP use to the wls origin servers
You can also optimize the communication between the OTD nodes and WLS
managed servers in the Origin Server Pool. The optimization is to enable OTD to
communicate with the origin server pool managed servers using the SDP protocol.
By doing so, the communication channel between the OTD frontend and the WLS
application tier is optimized to the fullest extent to take advantage of the Exabus
performance capabilities. Configuration change is required on both the OTD and the
WLS ends.
OTD
1. Log in to the OTD administration console for your environment using the
browser.
2. Select Server Pools and then origin-server-pool-1 that you created.
3. Search for the Address Family and using the drop down list change it to inetsdp.
4.Click Save.
5. Select each of the origin servers in the origin-server-pool.
6. Change the port from 7101 to 7102
7. Click Save.
8. Deploy both these changes
Tuesday 12 July 2016
REMYA-ORACLE ENGINEERED SYSTEM BLOG EXADATA/EXALOGIC
REMYA- ORACLE ENGINEERED SYSTEM BLOG
This blog is all about below TECHNOLOGIES...
ORACLE EXADATA/EXALOGIC
MIDDLEWARE---ORACLE WEBLOGIC/JBOSS/APACHE/
OS-ORACLE LINUX
ORACLE DATABASE
Introduction for Oracle Engineered systems
-------------------------------------------------------
Engineered systems are pre-designed, pre-engineered, pre-configured and pre-tested to cut short IT complexity, reduce costly maintenance, integration and testing tasks and power real-time decision making with extreme performance.
This blog is all about below TECHNOLOGIES...
ORACLE EXADATA/EXALOGIC
MIDDLEWARE---ORACLE WEBLOGIC/JBOSS/APACHE/
OS-ORACLE LINUX
ORACLE DATABASE
Introduction for Oracle Engineered systems
-------------------------------------------------------
Engineered systems are pre-designed, pre-engineered, pre-configured and pre-tested to cut short IT complexity, reduce costly maintenance, integration and testing tasks and power real-time decision making with extreme performance.
Traditionally, IT departments have been required to install and configure software that is hosted on hardware that was itself installed and configured separately. Oracle Engineered Systems relieve this burden from the IT department by providing a pre-defined combination of hardware and software.Oracle Engineered Systems is a complete set of integrated hardware and software that is designed to reach a predetermined level of capability, capacity, and scale. This relatively new concept of an integrated hardware and software solution, dedicated to provide a specific service, changes the way one must think about architecture in IT environments.
Some engineered systems are listed below:-
Oracle Exadata Database Machine->>To host Critical Database application
Oracle Exalogic Elastic Cloud>>Middleware
Oracle Exalytics In-Memory Machine>>
Oracle SPARC Super Cluster
Oracle Private Cloud Appliance
Oracle Database Appliance
Oracle Big Data Appliance
Zero Data Loss Recovery Appliance
Oracle FS1 Flash Storage System
Oracle ZFS Storage Appliance
Some engineered systems are listed below:-
Oracle Exadata Database Machine->>To host Critical Database application
Oracle Exalogic Elastic Cloud>>Middleware
Oracle Exalytics In-Memory Machine>>
Oracle SPARC Super Cluster
Oracle Private Cloud Appliance
Oracle Database Appliance
Oracle Big Data Appliance
Zero Data Loss Recovery Appliance
Oracle FS1 Flash Storage System
Oracle ZFS Storage Appliance
Subscribe to:
Posts (Atom)