Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

Tuesday, January 22, 2013

Oracle Apps R12 - JSP Compiling



Had a R12 vision instance of mine 'AJITHPATHIYIL', and I was trying to upgrade it to 12.1.3, But due to many reasons I was struck up with the upgrade process, and in the meantime, had to test AGILE PLM integration with PIP plugin for Agile on Oracle Apps R12.1.1, So restored my backup and got my old R12 base version in place. But after restore, My jsp's were not getting forwarded and served by the jsp engine, So had to recompile my jsp's and this is how I did that..

To compile the jsp as soon as you access jsp page :

-- Change s_jsp_main_mode in R12 context file (XML file)
  justrun
change it to
  recompile

--- Run Autoconfig (adautocfg.sh)
Autoconfig will update file
$INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml
        main_mode
         justrun

.

How to compile JSP manually
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
perl ojspCompile.pl –compile –flush  (Unix)
or
perl ojspCompile.pl –compile –flush -p 2 (Unix where -p means parallel execution)

perl -x ojspCompile.pl –compile –flush (Windows)
ojspCompile.pl is under $FND_TOP/patch/115/bin/

Note* JSP’s are compiled automatically after patching (whenever patch updates one or more jsp it calls ojspCompile.pl to compile JSP)

.
How I Forced JSP Compilation?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$ perl ojspCompile.pl --compile --flush -p 2
logfile set: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ausvmqtcdevap04/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
  loading deplist...8049
  enumerating jsps...8049
  updating dependency...0
initializing compilation:
  eliminating children...5980 (-2069)
translating and compiling:
  translating jsps...5980/5980 [failed: 3] in 20m59s
  compiling jsps...5977/5977 in 1h22m
Finished!

[applmgr@ajithpathiyil.lab.com:/u01/app/gebs/AJITHLAB/apps/apps_st/appl/fnd/12.0.0/patch/115/bin][AJITHLAB_FORMS]


JSP Compilation logs 
~~~~~~~~~~~~~~~~~~~~~~
In 11i, all jsp compilation errors are logged in $IAS_ORACLE_HOME/ Apache/ Jserv/ logs/ mod_jserv.log
In R12, all jsp compilation errors are logged in $LOG_HOME/ ora/ 10.1.3/ j2ee/ oacore/ oacore_default_group_1/ application.log

Below is the log of my JSP compilation
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

$ cd $AD_TOP
[applmgr@ajithpathiyil.lab.com:/u01/app/gebs/AJITHLAB/apps/apps_st/appl/ad/12.0.0][AJITHLAB_FORMS]
$ ./adchkcfg.sh    ( Remember I am Running adchkcfg.sh for checking the files that would be affected)
-bash: ./adchkcfg.sh: No such file or directory
[applmgr@ajithpathiyil.lab.com:/u01/app/gebs/AJITHLAB/apps/apps_st/appl/ad/12.0.0][AJITHLAB_FORMS]
$ cd bin
[applmgr@ajithpathiyil.lab.com:/u01/app/gebs/AJITHLAB/apps/apps_st/appl/ad/12.0.0/bin][AJITHLAB_FORMS]
$ ./adchkcfg.sh
Enter the full path to the Applications Context file:
/u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/appl/admin/AJITHLAB_ajithpathiyil01.xml
Enter the APPS password:

The log file for this session is located at: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/log/01211442/adconfig.log

AutoConfig is running in test mode and building diffs...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01
        Classpath                   : /u01/app/gebs/AJITHLAB/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/app/gebs/AJITHLAB/apps/apps_st/comn/java/classes

        Using Context file          : /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/AJITHLAB_ajithpathiyil01.xml

Context Value Management will now update the test Context file

        Updating test Context file...COMPLETED

        [ Test mode ]
        No uploading of Context File and its templates to database.

Testing templates from all of the product tops...
        Testing AD_TOP........
          Testing FND_TOP.......COMPLETED
        Testing ICX_TOP.......COMPLETED
        Testing MSC_TOP.......COMPLETED
        Testing IEO_TOP.......COMPLETED
        Testing BIS_TOP.......COMPLETED
        Testing AMS_TOP.......COMPLETED
        Testing CCT_TOP.......COMPLETED
        Testing WSH_TOP.......COMPLETED
        Testing CLN_TOP.......COMPLETED
        Testing OKE_TOP.......COMPLETED
        Testing OKL_TOP.......COMPLETED
        Testing OKS_TOP.......COMPLETED
        Testing CSF_TOP.......COMPLETED
        Testing IGS_TOP.......COMPLETED
        Testing IBY_TOP.......COMPLETED
        Testing JTF_TOP.......COMPLETED
        Testing MWA_TOP.......COMPLETED
        Testing CN_TOP........COMPLETED
        Testing CSI_TOP.......COMPLETED
        Testing WIP_TOP.......COMPLETED
        Testing CSE_TOP.......COMPLETED
        Testing EAM_TOP.......COMPLETED
        Testing FTE_TOP.......COMPLETED
        Testing ONT_TOP.......COMPLETED
        Testing AR_TOP........COMPLETED
        Testing AHL_TOP.......COMPLETED
        Testing OZF_TOP.......COMPLETED
        Testing IES_TOP.......COMPLETED
        Testing CSD_TOP.......COMPLETED
        Testing IGC_TOP.......COMPLETED

Differences text report is located at: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/cfgcheck.txt

        Generating Profile Option differences report...COMPLETED
Differences text report for the Database is located at: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/ProfileReport.txt
        Generating File System differences report......COMPLETED
Differences html report is located at: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/cfgcheck.html

Differences Zip report is located at: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/ADXcfgcheck.zip

AutoConfig completed successfully.
[applmgr@ajithpathiyil.lab.com:/u01/app/gebs/AJITHLAB/apps/apps_st/appl/ad/12.0.0/bin][AJITHLAB_FORMS]
$


The Difference Logs Shows The FIles That Would Change When Autoconfig is Actually Run
*******************/u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/cfgcheck.txt************************************
Driver: /u01/app/gebs/AJITHLAB/apps/apps_st/appl/ad/12.0.0/admin/driver/adtmpl.drv

  [CHANGED]
    Existing file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/ora/10.1.3/j2ee/oacore/application-deployments/oacore/html/orion-web.xml
    New file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/orion-web.xml
    Diff file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/x_orion-web.xml

    Existing file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/ora/10.1.3/j2ee/oafm/application-deployments/oafm/webservices/orion-web.xml
    New file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/orion-web0.xml
    Diff file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/x_orion-web0.xml


  [NEW]
    Destination file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/ora/10.1.3/j2ee/oacore/config/system-jazn-data-new.xml

    Destination file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/ora/10.1.3/j2ee/oafm/config/system-jazn-data-new.xml

    Destination file: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/ora/10.1.3/j2ee/forms/config/system-jazn-data-new.xml

*******************/u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/out/01211442/cfgcheck.txt************************************


ACTUAL AUTOCONFIG
=====================
$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/log/01211451/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01
        Classpath                   : /u01/app/gebs/AJITHLAB/apps/apps_st/comn/java/lib/appsborg2.zip:/u01/app/gebs/AJITHLAB/apps/apps_st/comn/java/classes

        Using Context file          : /u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/appl/admin/AJITHLAB_ajithpathiyil01.xml

Context Value Management will now update the Context file

        Updating Context file...COMPLETED

        Attempting upload of Context file and templates to database...COMPLETED

Configuring templates from all of the product tops...
        Configuring AD_TOP........COMPLETED
        Configuring FND_TOP.......COMPLETED
        Configuring ICX_TOP.......COMPLETED
        Configuring MSC_TOP.......COMPLETED
        Configuring IEO_TOP.......COMPLETED
        Configuring BIS_TOP.......COMPLETED
        Configuring AMS_TOP.......COMPLETED
        Configuring CCT_TOP.......COMPLETED
        Configuring WSH_TOP.......COMPLETED
        Configuring CLN_TOP.......COMPLETED
        Configuring OKE_TOP.......COMPLETED
        Configuring OKL_TOP.......COMPLETED
        Configuring OKS_TOP.......COMPLETED
        Configuring CSF_TOP.......COMPLETED
        Configuring IGS_TOP.......COMPLETED
        Configuring IBY_TOP.......COMPLETED
        Configuring JTF_TOP.......COMPLETED
        Configuring MWA_TOP.......COMPLETED
        Configuring CN_TOP........COMPLETED
        Configuring CSI_TOP.......COMPLETED
        Configuring WIP_TOP.......COMPLETED
        Configuring CSE_TOP.......COMPLETED
        Configuring EAM_TOP.......COMPLETED
        Configuring FTE_TOP.......COMPLETED
        Configuring ONT_TOP.......COMPLETED
        Configuring AR_TOP........COMPLETED
        Configuring AHL_TOP.......COMPLETED
        Configuring OZF_TOP.......COMPLETED
        Configuring IES_TOP.......COMPLETED
        Configuring CSD_TOP.......COMPLETED
        Configuring IGC_TOP.......COMPLETED

AutoConfig completed successfully.
[applmgr@ajithpathiyil.lab.com:/u01/app/gebs/AJITHLAB.local/apps/AJITHLAB_ajithpathiyil01/admin/scripts][AJITHLAB_FORMS]
$


HAPPY LEARNING!

Oracle 11g Baseline - Try This To Be Crystal On Baselining



If a query is "hard" parsed, oracle produces several execution plan and compares it with the accepted plan in a baseline. 
If a match is found, oracle picks that plan.

Two Parameter for baseline 

optimizer_capture_sql_plan_baseline if set to true, let oracle automatically capture sql plan baselines. The default value is false
optimizer_use_sql_plan_baseline, if set to true, force oracle to use the sql plan baseline (if present). The default is true.

SQL> create table sqlplantest as select * from dba_objects ;

Table created.

SQL> select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH';

no rows selected

SQL> select sql_id,sql_text from v$sqlarea where sql_text like '%withoutindex%' ;

SQL_ID SQL_TEXT
------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
b5dgh4v84xjdq select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'
3yq0rqy2zrx3v select sql_id,sql_text from v$sqlarea where sql_text like '%withoutindex%'


SQL> SELECT * FROM TABLE(dbms_xplan.display_cursor('b5dgh4v84xjdq'));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID b5dgh4v84xjdq, child number 0
-------------------------------------
select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'

Plan hash value: 1357081020

-----------------------------------------------------------------------------------
| Id | Operation        | Name | Rows  | Bytes     | Cost (%CPU)| Time   |
-----------------------------------------------------------------------------------
| 0  | SELECT STATEMENT |       |       |           | 282 (100)  |        |
|* 1 | TABLE ACCESS FULL| sqlplantest | 11    | 2277      | 282 (1)    |00:00:04|
-----------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

1 - filter("GENERATED"='AJITH')

Note
-----
- dynamic sampling used for this statement (level=2)


22 rows selected.

SQL> select sql_text, sql_handle, plan_name, enabled, accepted from dba_sql_plan_baselines;

no rows selected

SQL> var v_num number;
SQL> exec :v_num:=dbms_spm.load_plans_from_cursor_cache (sql_id => 'b5dgh4v84xjdq',plan_hash_value => 1357081020 );

PL/SQL procedure successfully completed.

SQL> select sql_text, sql_handle, plan_name, enabled, accepted from dba_sql_plan_baselines;

SQL_TEXT SQL_HANDLE PLAN_NAME ENA ACC
-------------------------------------------------------------------------------- ------------------------------ ------------------------------  --- ---
select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH' SYS_SQL_c7f6b95762b4c6a9 SQL_PLAN_cgxptaxjb9jp997bbe3d0  YES YES

SQL> create index sqlplantest_idx on sqlplantest(GENERATED) parallel 8;

Index created.

SQL> select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH';

no rows selected

SQL> select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH';

no rows selected

SQL> select sql_id,sql_text from v$sqlarea where sql_text like '%withoutindex%' ;

SQL_ID SQL_TEXT
------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
b5dgh4v84xjdq select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'
3yq0rqy2zrx3v select sql_id,sql_text from v$sqlarea where sql_text like '%withoutindex%'


SQL> select sql_id,sql_text from v$sqlarea where sql_text like '%GENERATED=%'; 

SQL_ID SQL_TEXT
------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
b5dgh4v84xjdq select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'
2s1gzn4d03qts select sql_id,sql_text from v$sqlarea where sql_text like '%GENERATED=%'


SQL> select * from table(dbms_xplan.display_cursor('b5dgh4v84xjdq', 1, 'basic note'));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
EXPLAINED SQL STATEMENT:
------------------------
select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'

Plan hash value: 1357081020

----------------------------------
| Id | Operation | Name |
----------------------------------
| 0 | SELECT STATEMENT | |
| 1 | TABLE ACCESS FULL | sqlplantest |
----------------------------------

Note
-----
- SQL plan baseline SQL_PLAN_cgxptaxjb9jp997bbe3d0 used for this statement


17 rows selected.



SQL> select /*+index(sqlplantest_idx sqlplantest) */ * from sqlplantest where GENERATED='AJITH';

no rows selected

SQL> select sql_id,sql_text from v$sqlarea where sql_text like '%GENERATED=%';

SQL_ID SQL_TEXT
------------- --------------------------------------------------------------------------------------------------------------------------------------------------
b5dgh4v84xjdq select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'
2s1gzn4d03qts   select sql_id,sql_text from v$sqlarea where sql_text like '%GENERATED=%'
8wgw4b0agmvv8 select /*+index(sqlplantest_idx sqlplantest) */ * from sqlplantest where GENERATED='AJITH'


SQL> select * from table(dbms_xplan.display_cursor('b5dgh4v84xjdq', 0, 'basic note'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID: b5dgh4v84xjdq, child number: 0 cannot be found


SQL> select * from table(dbms_xplan.display_cursor('8wgw4b0agmvv8',0, 'basic note'));

PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------
EXPLAINED SQL STATEMENT:
------------------------
select /*+index(sqlplantest_idx sqlplantest) */ * from sqlplantest where GENERATED='AJITH'

Plan hash value: 1389866015

---------------------------------------------------------
| Id | Operation | Name     |
---------------------------------------------------------
| 0 | SELECT STATEMENT |   |
| 1 | TABLE ACCESS BY INDEX ROWID | sqlplantest    |
| 2 | INDEX RANGE SCAN | sqlplantest_IDX   |
---------------------------------------------------------

Note
-----
- dynamic sampling used for this statement (level=2)


18 rows selected.

SQL> exec :v_num:=dbms_spm.load_plans_from_cursor_cache(sql_id => '8wgw4b0agmvv8',plan_hash_value => '1389866015' );

PL/SQL procedure successfully completed.

SQL> select sql_text, sql_handle, plan_name, enabled, accepted from dba_sql_plan_baselines;

SQL_TEXT  SQL_HANDLE PLAN_NAME ENA ACC
-------------------------------------------------------------------------------------------   ------------------------------ ------------------------------ --- ---
select /*+index(sqlplantest_idx sqlplantest) */ * from sqlplantest where GENERATED='AJITH'    SYS_SQL_22655d99f2ac5a60 SQL_PLAN_24taxm7tasqm0a5063692 YES YES
select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'      SYS_SQL_c7f6b95762b4c6a9 SQL_PLAN_cgxptaxjb9jp997bbe3d0  YES YES
select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'  SYS_SQL_c7f6b95762b4c6a9 SQL_PLAN_cgxptaxjb9jp9a5063692  YES NO

SQL> exec :v_num:=dbms_spm.load_plans_from_cursor_cache(sql_id => '8wgw4b0agmvv8',plan_hash_value => 1389866015 ,sql_handle => 'SYS_SQL_c7f6b95762b4c6a9');

PL/SQL procedure successfully completed.

SQL> select sql_text, sql_handle, plan_name, enabled, accepted from dba_sql_plan_baselines;

SQL_TEXT SQL_HANDLE   PLAN_NAME ENA ACC
------------------------------------------------------------------------------------------  ------------------------------ ------------------------------ --- ---
select /*+index(sqlplantest_idx sqlplantest) */ * from sqlplantest where GENERATED='AJITH' SYS_SQL_22655d99f2ac5a60 SQL_PLAN_24taxm7tasqm0a5063692  YES YES
select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'    SYS_SQL_c7f6b95762b4c6a9 SQL_PLAN_cgxptaxjb9jp997bbe3d0  YES YES
select /*+withoutindex */ * from sqlplantest where GENERATED='AJITH'    SYS_SQL_c7f6b95762b4c6a9 SQL_PLAN_cgxptaxjb9jp9a5063692  YES YES

SQL> 


#1

Step1)

Disable affecting plan and moniter for 2 hours.In case if the error has not been stopped or baseline plan is not available then go to step2.

DECLARE
v_number pls_integer;
BEGIN
v_number:=dbms_spm.alter_sql_plan_baseline(
sql_handle=>'SYS_SQL_357e8c14c551f65b',
plan_name=>'SYS_SQL_PLAN_a55df45c695bc033',
attribute_name=>'ACCECPTED',
attribute_value=>'NO');
END;
/


Step2)

If the baseline plan is not available for the affected SQL then just load it using the below SQL.


DECLARE
my_plans pls_integer;
BEGIN
my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id => 'b5dgh4v84xjdq');
END;
/

#2

Step 1) Drop the affecting plan and moniter for 2 hours.In case if the error has not been stopped or baseline plan is not available then go to step2.


DECLARE
v_plans_dropped pls_integer;
BEGIN
v_plans_dropped:=dbms_spm.drop_sql_plan_baseline(
sql_handle=>'SYS_SQL_22655d99f2ac5a60',
plan_name=>'SQL_PLAN_24taxm7tasqm0a5063692');
END;
/




Step 2) If the baseline plan is not available for the affected SQL then just load it using the below SQL.

DECLARE
my_plans pls_integer;
BEGIN
my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE( sql_id => '99twu5t2dn5xd');
END;
/



SQL_ID is available in top section of the trace file or you can find it using the v$sql view.
sql_handle and plan_name can be found using the below SQL.

select sql_handle, plan_name, enabled, accepted, fixed from dba_sql_plan_baselines WHERE SQL_TEXT LIKE '%&SQL_TEXT%'; 


HAPPY LEARNING!

Sunday, January 20, 2013

Wanna Be A Networking Expert? Deep Dive Into Sqlnet.ora Trace Files


Net Logging and Trace

I am trying for put some light on SQLNET.ORA Logging and Tracing parameters. 

On Unix, Oracle checks for sqlnet.ora in $ORACLE_HOME/network/admin unless this location, Exception when  $TNS_ADMIN environment variable is used. You can enable logging, trace or both on both the client and server using sqlnet.ora, Let me explain you how.


Logging




Trace

The following parameters can be set to configure Oracle Net logging in sqlnet.ora:





For both the client and server trace files, the default directory is $ORACLE_HOME/network/trace.
For the client, the default trace file name is sqlnet.trc
For the server the default trace file name is svr_pid.trc





Level 16 (SUPPORT) is the most detailed trace level. Take care when enabling this level of detail as it will consume disk space very rapidly. Consider using the TRACE_FILELEN_SERVER andTRACE_FILENO_SERVER parameters to reduce the impact on the server

If TRACE_UNIQUE_CLIENT is set to ON then a separate trace file will be created for each client. The pid is appended to the file name e.g. client_123.trc. Note that this appears to be the default behaviour in recent versions.

Now, You have learened how to enable sqlnet.ora tracing, But, as usual, I am sure, most of the people will not be able to understand the raw trace file, Now below is the reference to the MOS note that will make you a networking expert with furthur reading.


MOS Note:- Examining Oracle Net, Net8, SQL*Net Trace Files [ID 156485.1]

Note:- You will have a PDF document attached to the above note which will make you a networking expert :)   Notepart:156485.1:1 Examining Oracle Net Trace Files(339 KB)

Happy Learning !




Wednesday, January 9, 2013

Oracle Database Appliance, EXADATA Jr?

The Oracle Database Appliance saves time and money by simplifying deployment, maintenance, and support of high-availability database solutions. Built with the latest generation of the world’s most popular database—Oracle Database 11g—it offers customers a fully integrated system of software, servers, storage, and networking in a single box that delivers high-availability database services.

Fully Redundant Integrated System
============================================
The Oracle Database Appliance hardware is a single 4U rackmountable chassis containing two
Oracle Linux server nodes, each with two 6-core Intel Xeon processors X5675 and 96 GB of memory. The two server nodes are connected via an internal redundant gigabit Ethernet (GbE) interconnect for cluster communication, and each provides both 1 GbE and 10 GbE external networking connectivity. The appliance contains 12 TB of raw storage that’s triple-mirrored, offering 4 TB of resilient usable database storage. There are also four 73 GB solid-state disks for database redo logs to boost performance. To expand storage outside of the appliance, external NFS storage is supported for online backups, data staging, or additional database files. The appliance is designed with mission-critical requirements in mind, with hotswappable and redundant components.  The Oracle Database Appliance runs Oracle Database 11g, Enterprise Edition, and customers have the choice of running Oracle Real Application Clusters (Oracle RAC) or Oracle RAC
One Node for “active-active” or “active-passive” database server failover.

Ease of Deployment, Management, and Support
============================================
To help customers easily deploy and manage their databases, the Oracle Database Appliancefeatures Appliance Manager software for one-button automation to provision, patch, and diagnose database servers.

Pay-As-You-Grow Licensing 
==========================
The Oracle Database Appliance offers customers a unique pay-as-you-grow software licensing model to quickly scale from 2 to 24 processor cores without any hardware upgrades. Customers can deploy the Oracle Database Appliance with as few as 2 processors cores to run their database servers, and incrementally scale up to the maximum of 24 processor cores.