Welcome to www.freeoraclehelp.com Got questions? Post comments Like the facebook page to get instant updates. Thank you!!!
Total Pageviews
Search this blog
Loading...

SCAN Setup for Oracle 11g Release2(11gR2) RAC implementation

Single client access name (SCAN) is introduced in Oracle 11g R2 Cluster Ready Software(CRS) to simplify the database connection strings that an Oracle Client uses to connect to an Oracle Cluster Database. I have received a few emails about SCAN setup issues and I have promised that I would come up with an article addressing the following questions:

Oracle WebLogic Server 11g R1 10.3.5 Installation

Step by Step instructions to download, install Oracle WebLogic Server 11gR1 10.3.5, and create a sample domain are described in this article. Well, What is WebLogic? WebLogic Server is a powerful Application Server to run J2EE Applications. This is pretty much equivalent to Oracle 10gAS OC4J server, but WebLogic is known for its rich features and great functionality. Since Oracle has acquired BEA, there has been a strategic shift in the Application Server technologies from OC4J to Weblogic Server. Oracle has moved most of the OC4J Applications to Weblogic in Fusion Middleware releases. If you see the tag, Fusion, you can guess that it is Weblogic Application. Other than directory structures, installation procedure, here are few key differences between OC4J and WebLogic Server.

OC4J uses AJP protocol between OHS and OC4J. OHS in front of OC4J is a must (as OC4J itself does not have a HTTP listener, so it cannot answer HTTP requests). This is quite different in WebLogic, as WebLogic has got a HTTP listener, users can directly access WebLogic port from the browser. Of course, it is recommended to front end WebLogic by a web server but it is not mandatory. Web Server is mandatory for OC4J.

OC4J is completely managed by OPMN. A couple of interesting features by OPMN, such as increasing no# of JVMs (numprocs in opmn.xml) for the OC4J are available. WebLogic is not managed by OPMN. So, WebLogic always runs out of only one JVM.

Repository Creation Utility(RCU) 11g Installation for Fusion Middleware 11g

Step by Step instructions to download, install, and execute Repository Creation Utility (RCU) 11g for Fusion Middleware installations are described in this article. Before fusion middleware, databases are typically installed by the installer(OUI). For example, Oracle 10gAS installs Metadata Repository with the required tablespaces, schemas, and seeded data. Of course, it installs Oracle Database only. Starting with Fusion Middleware, Oracle has eased the database requirements little bit, by allowing/certifying other databases such as IBM DB2, Microsoft SQL Server..etc. That’s when the tool Repository Creation Utility (RCU) is born. Another good thing with RCU is that we can have multiple environment such as Test, Dev, Stage, and QA environments using the same physical database but each environment has got a unique set of schemas with a specific prefix each. For example, Development and Stage Discoverer environments can share the database and their schema names would be DEV_DISCOVERER and STAGE_DISCOVERER. The only exception to this is the Oracle Internet Directory (ODS) schema, which doesn’t have a prefix yet, meaning that there is only one OID possible in one physical database.

Right now, RCU is only available in Linux and Windows. Some of the RCU versions are only 32bit. To execute these 32bit RCUs in Linux 64bit OS, you need to start a separate shell for 32bit: $ linux32 bash

If you got to run the RCU for a database running on Solaris, you got to install RCU else where (probably on your windows laptop) and run RCU from there. It’s going to make a connection to the database and create the tablespaces and schemas. If you have got 11gR2 Oracle RAC servers with more than 32 CPUs, set parallel_max_servers=1 during the installation (only). I would be focusing on Oracle Database for RCU in this article.

Oracle Database Requirements:

  • Database version is equal to or higher than 10.2.0.4.0 in 10g or equal to or higher than 11.1.0.7.0 in 11g.
  • Database user has SYSDBA role.
  • Character set is AL32UTF8.
  • The DB_BLOCK_SIZE is greater than or equal to 8KB.

If you are preparing a database for Oracle Single Sign-On and Oracle Delegated Administration Services 10g, ensure that Ultrasearch is installed with the 371 WKSYS Objects in the database. For more information about installing Ultrasearch for 10g components, refer to note 337992.1 - How to Manually Install and Uninstall Ultrasearch 10gR2 Server Components. In addition, ensure that the following database parameters are set for Ultrasearch Installation:

  •     aq_tm_processes >= 1
  •     db_cache_size >= 150994944
  •     java_pool_size >= 125829120
  •     shared_pool_size >= 183500800

Oracle HTTP Server (OHS) 11g Installation on Linux

Step by Step instructions to install Oracle HTTP Server (OHS) 11g Installation on Linux is described in this article. Oracle HTTP Server is the Web server in Oracle Fusion Middleware. It provides a HTTP listener for Oracle WebLogic Server and the framework for hosting static pages, dynamic pages, and applications over the Web.  Oracle HTTP Server is based on the proven, open source technology of Apache. Oracle HTTP Server 11 g is based on Apache 2.2 web server, and includes all base Apache modules and modules developed specifically by Oracle. Here is the environment I have installed OHS in:

OS OEL 4 Update8 32bit
Server Name oam10.freeoraclehelp.com
User & Group oracle & oinstall
ORACLE_HOME /oracle/middleware/ohs
ORACLE_INSTANCE /oracle/middleware/instances/ohs
Ports Automatic Port Selection
htdocs $ORACLE_INSTANCE/config/OHS/<component_name>/htdocs

Oracle Applications(Apps) R12 (12.1.1) Installation on Linux

Step by Step instructions to install Oracle Applications R12(12.1.1) on Oracle Enterprise Linux 4 or RHEL 4 are described in this article. This is a single node installation, meaning that the database, all product directories and AD core directories, and all servers (concurrent processing, forms, and Web) are installed on a single node under one common APPL_TOP.

Rapid Install installs the Java Development Kit (JDK) 5.0 automatically. Oracle Applications Software from Oracle eDelivery is already staged. If you have got the CDs, Stage them using $ perl /mnt/cdrom/Disk1/rapidwiz/adautostg.pl

Oracle Applications R12 Installation on Linux 029

Here is the environment I have used in the installation process:

OS OEL 4 Update 8
Memory 12GB
Disk Space 100GB Disk (73GB required for fresh install ; 161GB for Vision)
Server Name erp.freeoraclehelp.com
Installation Type Single Node installation & Fresh database
Applmgr user oracle
DB Tier Base /oracle/erp/R12
Apps Tier Base /oracle/erp/R12
ORACLE_HOME /oracle/erp/R12/db/tech_st/11.1.0
ORADATA Location /oracle/erp/R12/db/apps_st/data
DATABASE SID ERPR12
Port pool 0