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

Tuesday, January 22, 2013

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

Sunday, January 20, 2013

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.

Wednesday, January 9, 2013

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.