My Oracle Support Mobile

Oracle has released My Oracle Support Mobile – which offers users access to My Oracle Support through mobile.

My Oracle Support mobile is not an exact equivalent of the My Oracle Support.

In this release, we can access fewer but still useful features namely viewing and updating Service Requests (SRs).

How to access it from mobile?

1. Open web browser in your mobile.
2. Type in the https://support.oracle.mobi URL and enter. Guess what !!!!! you will get the login page.

Here you go.

Configure Enterprise Manager DB Console for Oracle Applications RAC database

When you use EMCA to configure Database Control for Oracle RAC, you configure the Database Control for each instance in the cluster. However, by default, the Database Control Console will only start on the local node. On every other node of the cluster, only the Enterprise Manager agent will start.

The Database Control Console is only started on the local node. On every other node, the commands emctl start dbconsole and emctl stop dbconsole only start and stop the agent. Each of the remote agents will upload their respective data to the console running on the local node, from where you can monitor and manage all the targets in the cluster. On each instance of the RAC database, the following subdirectories will be created:

$ORACLE_HOME/hostname1.domainname_SID1
$ORACLE_HOME/hostname2.domainname_SID2


Use the operating system command line to configure Database Control.

cd $ORACLE_HOME/bin
./emca -config dbcontrol db -repos create -cluster

Note: When you configure Database Control using EMCA, the database may become unavailable and users may not be able to connect to the database or perform operations on the database.


To configure Enterprise Manager for a newly added node of a cluster, enter the following command:

$ emca -addNode db


Unlock the SYSMAN and DBSNMP accounts.

Change the password of DBSNMP accounts.

To change the password of the user DBSNMP you must strictly follow the steps below, otherwise the 10g or 11g DB Control used to manage your database will not function properly.

Note: For DB Control Release 10.2.0.3 and higher installed on Windows 2008 / Vista, emctl commands may fail with the error "Permission Denied". Please consult the note below to fix this error:
Document 1164293.1 -  Executing Any EMCTL Command on Windows 2008 / Vista Returns "Permission denied" Error

Stop the standalone dbconsole
   
    $ export ORACLE_SID=
    $ emctl stop dbconsole

On Unix - DB Control Release 11.2.x and higher

    $ export ORACLE_SID=
    $ export ORACLE_UNQNAME=
    $ emctl stop dbconsole

   
    Check that the DB Control is stopped
    On Unix

    $ emctl status dbconsole

Connect to the database as a user with DBA privilege with SQL*Plus and execute

    SQL> alter user dbsnmp identified by ;

    Check the new password

    SQL> connect dbsnmp/[@database_alias]

    Go to $ORACLE_HOME/host_sid/sysman/emd
        Save the file targets.xml to targets.xml.orig
        Edit the file targets.xml with your favorite text editor
            Search for the line:
           
            Replace the encrypted value by the new password value
            Replace TRUE by FALSE
        Restart the standalone dbconsole
       
On Unix - DB Control Release up to 11.1.x

        $ export ORACLE_SID=
        $ emctl start dbconsole

On Unix - DB Control Release 11.2.x and higher

        $ export ORACLE_SID=
        $ export ORACLE_UNQNAME=
        $ emctl start dbconsole

Check that the password has been encrypted
        Edit the file targets.xml
        Search for the line:
        Check that the password VALUE is encrypted
        Check that the value of ENCRYPTED is TRUE


Note: In case of RAC DB, the dbsnmp password should be changed in targets.xml not only for instances(oracle_database), but also for rac_database target.
The file targets.xml needs to be updated on all the RAC Cluster nodes.





Check the status of agent in each nodes:
  $ emctl status agent




Now try to login to the Enterprise Manager console URL using DBSNMP user. For example:

http://hostname.domain:1150/em/console

Reference:
How to Change DBSNMP Password in Database 10g and 11g Monitored by DB Control [ID 259387.1]
How To Change the Password of the Database User Sysman (DB Control Repository Schema) [ID 259379.1]

Very Basic Practices - Oracle Apps DBA

Today I have taken a topic of very basic tips and practices to be followed by an Oracle Apps DBA in day to day support. It might look like a silly topic but it makes sense to put these points in the list of DBA practices.

First and foremost thing a DBA must take care is to change the default passwords of all accounts, after installation or cloning. When I say all accounts, it does mean ALL. In most cases, the  accounts like ap, ar, etc..accounts will be missing in their change password list. And especially sys will have the default password.
For more details refer metalink note ID: 419475.1.

Second tip is to avoid entering the apps password or any password on the bash shell prompt while running any commands or scripts. It can easily be traced from bash_history if any technical/admin have OS privileges. Oracle has implemented the hide password option for all scripts almost now.

Third even if someone forgets not to enter the password on the command prompt, one must remember not to send the screenshot of the session where you entered password to the functional/technical/client after completing the task :).

This list will continue....

Oracle E-Business Suite Release 12.2

Oracle E-Business Suite R12.2 RCDs for each product have been released in metalink.

A key change to Release 12.2 new technology stack is the adoption of WebLogic components. The old web tier, Apache and OC4J, will be replaced by WebLogic. This will be a major technology change and a challenge for Applications DBAs.

A further difference is that the application tier file system is now always shared.

As usual, many significant features have been added in R12.2.

One of the key features of Release 12.2 is the switch to online patching (OLP). This utilizes the Oracle Database 11g Release 11.2.0.2 feature of edition-based redefinition to reduce significantly the downtime traditionally needed for patching and related maintenance activities.

With online patching, patches are applied to a separate edition while users are working with the original edition. Subsequently, the system is cutover to make the patch edition the new production edition. After the upgrade to Release 12.2, all future patches and maintenance packs can be applied online, requiring only a short cutover period to make the new functionality active.

***** NOTE: This note is just for the information purpose and cannot be used  for any business decisions. This note is just a snapshot from metalink ID: 1302189.1***************

Users cannot launch Forms using MSIE 8 in Release 12.1.1

When attempting to launch any Oracle Form using MS Internet Explorer Browser Version 8, the following message can message will be observed:

'Internet Explorer has modified this page to prevent a possible cross-site scripting attack'

FRM-92101: There was a failure in the Forms during startup. This could happen due to an invalid configuration. Please look into the web server log file for details.

This is because MSIE 8 has implemented a new filter named "Cross Site Scripting [XSS] Filter"

As permanent solution, redeploy the Forms 10.1.2.3 formsapp.ear file

1. Make a backup copy of the original Forms system-jazn-data.xml file found in $INST_TOP/ora/10.1.3/j2ee/forms/config/system-jazn-data.xml

 2. Change oc4jadmin password if the password is unknown [ per Note 397174.1 ]

   3. Execute $FND_TOP/bin/txkrun.pl -script=CfgOC4JApp

         Enter Application name for re-deployment ? forms
         Enter Oc4j Instance password for re-deployment ? welcome (or current password)
         Run Autoconfig ? No

Temporary Workaround:

As a temporary workaround, disable the XSS filter is NOT recommended, but has been reported and may be of help until you implement the supported solution delineated in Note 389422.1.

1. In MSIE 8 > [Menu Bar ] >Tools > Internet Options >
    [Tab] Security > [Button] Custom Level >
    Scroll down to entry "Enable XSS Filter" > Select Disable XSS Filter >
    Click OK

Metalink - Master Notes

The Master Note ids are intended to provide an index and references to the most frequently used My Oracle Support Notes.These are extremely useful in finding out references related to each topics:

Note 1096952.1 Master Note for Real Application Clusters (RAC) Oracle Clusterware and Oracle Grid Infrastructure

Note 1187723.1 Master Note for Automatic Storage Management (ASM)

Note 1187674.1 Master Note for Oracle Database Machine and Exadata Storage Server

Note 1101938.1 Master Note for Data Guard

Note 402983.1 Master Note: How to diagnose Database Performance - FAQ

Note 1099271.1 Master Note for Enterprise Manager Configuration Assistant (EMCA) in Single Instance Database Environment

Note 1190323.1 Master Note for 10g Grid Console Browser / User-interface Issues

Note 1199803.1 Master Note For Oracle Backup And Recovery

Note 1116484.1 Master Note for Oracle Recovery Manager (RMAN)

Note 1088018.1 Master Note for Oracle Database Corruption

Note 1264715.1 Master Note for Data Pump Note 1152016.1 Master Note For Oracle Database Upgrades and Migrations Note 293369.1 Master Note For OPatch Note 1248939.1 Master Note for OBIEE Integration with EBS, Siebel, SSO, Portal Server, Peoplesoft Note 740964.1 Advisor Webcast Archived Recordings

    

Hope it is useful !!!