13 March 2013

Step by step Oracle Enterprise Manger cloud OEM12C Installation on Linux OEL5.6

Step by step Oracle Enterprise Manger cloud 12C Installation on Linux OEL5.6

Install database 11..2.0.3 

[muthu@prithvi ~]$ export ORACLE_HOME=/u01/MUT/product/11.2.0/dbhome_1
[muthu@prithvi ~]$ export ORACLE_SID=MUT
[muthu@prithvi ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[muthu@prithvi ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 11 14:03:15 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> ALTER SYSTEM SET processes=300 SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;

System altered.

SQL> ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;

System altered.

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>startup pfile=/u01/MUT/product/11.2.0/dbhome_1/dbs/initMUT.ora
ORACLE instance started.

Total System Global Area 1155035136 bytes
Fixed Size                  1344484 bytes
Variable Size             671091740 bytes
Database Buffers          469762048 bytes
Redo Buffers               12836864 bytes
Database mounted.
Database opened.
SQL>create spfile from pfile;

File created.

SQL>

[muthu@prithvi bin]$ emca -deconfig dbcontrol db -repos drop -SYS_PWD oracle -SYSMAN_PWD oracle

STARTED EMCA at Mar 11, 2013 3:10:14 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: MUT
Listener port number: 1521

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 11, 2013 3:10:22 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/MUT/cfgtoollogs/emca/MUT/emca_2013_03_11_15_10_14.log.
Mar 11, 2013 3:10:23 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-01017: invalid username/password; logon denied

Mar 11, 2013 3:10:23 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Mar 11, 2013 3:10:23 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
 1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script
 2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Mar 11, 2013 3:10:23 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...



















Test the installation:

Access from the browser OEM CC URL https://muthu.com:7801/em


Enter username sysman and the password that you specified during OEM 12c installation with OUI.










Steps for Startup & shut down the OEM and agent:-

Shutdown OEM12C services :
[muthu@prithvi dbhome_1]$ export ORACLE_HOME=/u01/MUT/product/11.2.0/dbhome_1/
[muthu@prithvi dbhome_1]$ export OMS_HOME=/u01/MUT/Middleware/oms/
[muthu@prithvi dbhome_1]$ export AGENT_HOME=/u01/MUT/Middleware/agent/core/12.1.0.1.0
[muthu@prithvi dbhome_1]$ $OMS_HOME/bin/emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
AdminServer Successfully Stopped
Oracle Management Server is Down

Shutdown Agent services:-
[muthu@prithvi dbhome_1]$ $AGENT_HOME/bin/emctl stop agent
Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0 
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping agent ..... stopped.

Startup OEM12c services:-
[muthu@prithvi dbs]$ $OMS_HOME/bin/emctl start oms
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0 
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server Successfully Started
Oracle Management Server is Up

Startup Agent service:-

[muthu@prithvi dbs]$ $AGENT_HOME/bin/emctl start agent
Oracle Enterprise Manager 12c Cloud Control 12.1.0.1.0 
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Starting agent .......................... started.
[muthu@prithvi dbs]$

Step by step to install Oracle Database 11.2.0.3 on linux OEl 5.6

Step by step to install Oracle Database 11.2.0.3 on linux OEl 5.6



 Click Next


Choose your preference

 Click Next
Click Next










Click close.

11 March 2013

Step by Step to upgrade JRE Native Plug-in 1.7.0_17



Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 [ID 393931.1]

Step 1 - Apply Latest OUI Patch  - Patch6640838

Step 2 - MLR TRACKING BUG FOR FORMS 10.1.2.3.0 BUNDLE PATCH   (5.4M)   - Patch9593176

Step 3 - MERGE REQUEST ON TOP OF 10.1.2.3.1PSU FOR BUGS 14536350 14559906 14609039 - Patch14614795

Step 4 - R12.1.X: FORMS INTEROPERABILITY PATCH FOR 10.1.2.3 - patch14837539

Step 5 - Download the latest JRE (Java SE Runtime Environment 7u11 )  from http://oracle.com/technetwork/java/javase/downloads/index.html

Step 5  -  Rename the downloaded JRE file - Example file from jre-7u11-windows-i586.exe to j2se17011.exe

Step 6 - Move the j2se17011.exe file to the web application tier and place it in $COMMON_TOP/webapps/oacore/util/Jinitiator/

[applmgr@testap01 jinitiator]$ scp -pr kbtmariyappan@testap01:/usr/tmp/j2se17017.exe .

kbtmariyappan@testap01's password:

j2se17017.exe                                                                                                           100%   30MB  10.0MB/s   00:03

[applmgr@testap01 jinitiator]$ ll

total 144984

-rw-r--r-- 1 applmgr dba 15984024 Oct 14  2008 j2se16007.exe

-rwxr-xr-x 1 applmgr dba 16672544 Feb  3  2010 j2se16017.exe

-rwxr-xr-x 1 applmgr dba 16979960 Jan 27 03:39 j2se16037.exe

-rwxrwxrwx 1 applmgr dba 31521184 Mar 10 21:38 j2se17017.exe

Step 7 - Shut down your  Apache services  safer side we will stop all services.

Step 8 - Enable 'Maintenance Mode' using adadmin

[applmgr@testap01 jinitiator]$ sqlplus -s apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql ENABLE

PL/SQL procedure successfully completed.

Commit complete.

Step 9 - Run the $FND_TOP/bin/txkSetPlugin.sh jversion script   -  jversion  is  17017

[applmgr@testap01 jinitiator]$ pwd

/apps1/TEST/apps/apps_st/comn/webapps/oacore/util/jinitiator

[applmgr@testap01 jinitiator]$ $FND_TOP/bin/txkSetPlugin.sh 17017

/apps1/TEST/apps/apps_st/appl/fnd/12.0.0/bin

  Starting interoperability upgrade script...

Sending logfile output to:

        /apps1/TEST/inst/apps/TEST_testap01/logs/txkSetPlugin.log

Using the context file:

        /s001/TEST/inst/apps/TEST_testap01/appl/admin/TEST_testap01.xml

Using APPLSYS file:

        /apps1/TEST/apps/apps_st/appl/APPSTEST_testap01.env

Enter the password for the Oracle database APPS user [APPS] : *******

  Using /apps1/TEST/apps/tech_st/10.1.3/appsutil/jdk/jre/bin/java to execute java programs

  Getting J2SE parameter values...

  Copy oaj2se.exe to html dir...

Copying /apps1/TEST/apps/apps_st/comn/webapps/oacore/util/jinitiator/j2se17017.exe to /apps1/TEST/apps/apps_st/comn/webapps/oacore/html/oaj2se.exe ...

  Backing up the Application Context File...

/s001/TEST/inst/apps/TEST_testap01/appl/admin/TEST_testap01.xml to /s001/TEST/inst/apps/TEST_testap01/appl/admin/TEST_testap01.xml.prej2se17017

Using APPSWEB file /apps1/TEST/inst/apps/TEST_testap01/ora/10.1.2/forms/server/appsweb.cfg

  Backing up the appsweb file...

Backing up /apps1/TEST/inst/apps/TEST_testap01/ora/10.1.2/forms/server/appsweb.cfg to /apps1/TEST/inst/apps/TEST_testap01/ora/10.1.2/forms/server/appsweb.cfg.prej2se17017

  Updating XML context file with new J2SE parameters...

Updated J2SE plugin to jdk

Updated J2SE mimetype to 1.7.0_17

Updated J2SE Classid to CAFEEFAC-0017-0000-0017-ABCDEFFEDCBA

The log file for this session is located at: /apps1/TEST/inst/apps/TEST_testap01/admin/log/03102159/adconfig.log

AutoConfig is configuring the Applications environment...

AutoConfig will consider the custom templates if present.

        Using CONFIG_HOME location     : /apps1/TEST/inst/apps/TEST_testap01

        Classpath                   : /apps1/TEST/apps/apps_st/comn/java/lib/appsborg2.zip:/apps1/TEST/apps/apps_st/comn/java/classes

        Using Context file          : /s001/TEST/inst/apps/TEST_testap01/appl/admin/TEST_testap01.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.

Done

Step 10 - Check your J2SE Class id updated in context file or not.

 [applmgr@testap01 jinitiator]$ cat $CONTEXT_FILE |grep CAFEEFAC-0017-0000-0017-ABCDEFFEDCBA

         <sun_clsid oa_var="s_sun_clsid">CAFEEFAC-0017-0000-0017-ABCDEFFEDCBA</sun_clsid>

Step 11- [applmgr@testap01 jinitiator]$ sqlplus -s apps/apps @$AD_TOP/patch/115/sql/adsetmmd.sql DISABLE

PL/SQL procedure successfully completed.

Commit complete.

[applmgr@testap01 jinitiator]$

Step 12 - Start all application services services.


OPATCH_JAVA_ERROR=CheckConflict: OPatch cannot process overlay patches because of no OUI support. Please take latest OUI 10.1 patchset from "My Oracle Support" and try again.

[apdev01@muthu01 11710576]$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.64
Copyright (c) 2011 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home           : /s001/MUTHU/apps/tech_st/10.1.2
Oracle Home Inventory : /apps1/MUTHU/apps/tech_st/10.1.2/inventory
Central Inventory     : /apps1/MUTHU/oraInventory
   from               : /etc/oraInst.loc
OUI location          : /apps1/MUTHU/apps/tech_st/10.1.2/oui
OUI shared library    : /apps1/MUTHU/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so
Java location         : /apps1/MUTHU/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /s001/MUTHU/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Creating log file "/s001/MUTHU/apps/tech_st/10.1.2/.patch_storage/11710576/Apply_11710576_03-10-2013_21-02-24.log"

Invoking fuser to check for active processes.

OPATCH_JAVA_ERROR=CheckConflict: OPatch cannot process overlay patches because of no OUI support. Please take latest OUI 10.1 patchset from "My Oracle Support" and try again.
Cannot check bug/file conflict and component prerequisite checks.

ERROR: OPatch failed during prerequisite check.
[apdev01@m1tstap01 11710576]$


Solution :-

Apply below OUI patch

p6640838_10106_Linux-x86-64.zip    OUI CD PLACE HOLDER ON ARU FOR 10106

Reference :-

How to patch OUI for installing overlay patches on top of Forms Bundle Patch - 9593176 [ID 1301320.1]

Result:-

[apdev01@muthu01 11710576]$ opatch apply

Oracle Interim Patch Installer version 1.0.0.0.63
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..

Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)

Oracle Home           : /s001/MUTHU/apps/tech_st/10.1.2
Oracle Home Inventory : /apps1/MUTHU/apps/tech_st/10.1.2/inventory
Central Inventory     : /apps1/MUTHU/oraInventory
   from               : /etc/oraInst.loc
OUI location          : /apps1/MUTHU/apps/tech_st/10.1.2/oui
OUI shared library    : /apps1/MUTHU/apps/tech_st/10.1.2/oui/lib/linux/liboraInstaller.so
Java location         : /apps1/MUTHU/apps/tech_st/10.1.2/jre/1.4.2/bin/java
Log file location     : /s001/MUTHU/apps/tech_st/10.1.2/.patch_storage/<patch ID>/*.log

Creating log file "/s001/MUTHU/apps/tech_st/10.1.2/.patch_storage/11710576/Apply_11710576_03-10-2013_21-18-39.log"

Invoking fuser to check for active processes.


Patch "11710576" overlays " 9593176 ". Conflict check between them is skipped.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y
Oracle Configuration Manager has been installed but not configured. OCM enables
Oracle to provide superior, proactive support for our customers. Oracle
strongly recommends customers configure OCM. To complete the configuration of
OCM, refer to the OCM Installation and Administration Guide
(http://www.oracle.com/technology/documentation/ocm.html).
Backing up comps.xml ...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /s001/M1DEV01/apps/tech_st/10.1.2)
Is this system ready for updating?
Please respond Y|N >
y
Applying patch 11710576...

Patching copy files...



Inventory is good and does not have any dangling patches.


Updating inventory...

Verifying patch...
Backing up comps.xml ...


OPatch succeeded.
[apdev01@muthu01 11710576]$

10 March 2013

ORA-12719: operation requires database is in RESTRICTED mode

Step by Step to Drop Database:-

[ordev@muthu01 env_bkp_10Mar13]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 9 23:43:45 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount pfile=/home/ordev/env_bkp_10Mar13/initDEV011.ora
ORACLE instance started.

Total System Global Area 6263357440 bytes
Fixed Size                  2239976 bytes
Variable Size            4060086808 bytes
Database Buffers         2181038080 bytes
Redo Buffers               19992576 bytes
Database mounted.
SQL> drop database
  2  ;
drop database
*
ERROR at line 1:
ORA-12719: operation requires database is in RESTRICTED mode


SQL> shut immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup nomount pfile=/home/ordev/env_bkp_10Mar13/initDEV011.ora
ORACLE instance started.

Total System Global Area 6263357440 bytes
Fixed Size                  2239976 bytes
Variable Size            4060086808 bytes
Database Buffers         2181038080 bytes
Redo Buffers               19992576 bytes
SQL> alter database mount;

Database altered.

SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining and Real Application Testing options
SQL>

04 March 2013

End-of-central-directory signature not found

Error:-

[oracle@HQSRVDBA2 ~]$ unzip V34898-01.zip
Archive:  V34898-01.zip
  End-of-central-directory signature not found.  Either this file is not
  a zipfile, or it constitutes one disk of a multi-part archive.  In the
  latter case the central directory and zipfile comment will be found on
  the last disk(s) of this archive.
unzip:  cannot find zipfile directory in one of V34898-01.zip or
        V34898-01.zip.zip, and cannot find V34898-01.zip.ZIP, period.

Solution:-

[oracle@HQSRVDBA2 ~]$ cksum V35586-01.zip
1599202357 2342612234 V35586-01.zip
[oracle@HQSRVDBA2 ~]$ unzip V34898-01.zip
Archive:  V34898-01.zip
  inflating: ES_7.4_cluster_coordinator_linux.tgz
  inflating: ES_7.4_README.txt
  inflating: ES_7.4.sh
[oracle@HQSRVDBA2 ~]$