VirtualBox VMs for Developers and DBAs

Good news for those who work on Virtual Box.

Oracle has pre-build VM to support quicker access to its product.

see VirtualBox VMs for Developers

The power of Amazon EC2

Why 'Anonymous' failed to take down Amazon over WikiLeaks - Dec. 9, 2010

Cloud Computing at its best. EC2 expanded and scaled as the traffic increased. Read the above article to know about why it is powerful.

Hosting Oracle Products would be more fun there.

BPELConsole and BPELAdmin Page does not load

All,

When trying to access the BPEL Console or the BPEL Admin page or the EM console after a fresh installation of Oracle Application Server Release 3 and BPEL I was not able to get the initial screen.The browser status always showed as "Loading .....".

After a long time of investigation and going through all the log files.
Found one log file under
$ORACLE_HOME/j2ee/oc4j_bpel/log/oc4j_bpel_default_group_1/oc4j/log.xml which was growing rapidly...on just tailing the log file came across the following error


<MSG_TEXT>IOException in NIOServerSocketDriver:select</MSG_TEXT>


Cause :-

Starting up oc4j on Solaris 10 spawns nioserversocketdriver exceptions,which is a bug.

Fix:-

1. Backup the $ORACLE_HOME/opmn/conf/opmn.xml file.

2. Edit the opmn.xml file to include -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.PollSelectorProvider in the
java-options tag for the start-parameters for "home" and "oc4j_bpel" as mentioned below

<data id="java-options" value="-server -Djava.security.policy=$ORACLE_HOME/j2ee/home/config/java2.policy -Djava.nio.channels.spi.SelectorProvider=sun.nio.ch.PollSelectorProvider -Djava.awt.headless=true"/>

3. Restart the Oracle Application Server

$ORACLE_HOME/opmn/bin/opmnctl stopall
$ORACLE_HOME/opmn/bin/opmnctl startall
$ORACLE_HOME/opmn/bin/opmnctl status (to verify)

Now I was able to sucessfully load the BPEL Console ,BPEL Admin and EM page without any issues.

The system classes in the classpath are not compatible with this version of Java when trying to start application using adstrtal.sh

Hello All,

Today when trying to start one of the mid-tier services using adstrtal.sh apps/apps, the script failed with the below message :-

Note :- This was a 11i EBS system.

apphost1:/d51/oracle/viscomn/admin/scripts/vis_apphost1> adstrtal.sh apps/apps

You are running adstrtal.sh version 115.11

The system classes in the classpath are not compatible with this
version of Java.  Please check that the classpath is correct.
CLASSPATH = /opt/jdk1.3.1_20/j2se/jre/lib/rt.jar:/opt/jdk1.3.1_20/j2se/jre/lib/i18n.jar:/d51/oracle/viscomn/java/appsborg.zip:/d51/oracle/viscomn/java/apps.zip:/d51/oracle/visora/8.0.6/forms60/java:/d51/oracle/viscomn/java:/d51/oracle/visappl/ad/11.5.0/java/adconfig.zip:/opt/jdk1.3.1_20/j2se/bin/../classes:/opt/jdk1.3.1_20/j2se/bin/../lib/classes.zip:/d51/oracle/viscomn/java/loadjava.zip:/d51/oracle/visappl/ad/11.5.0/java/adconfig.zip:/d51/oracle/visappl/fnd/11.5.0/java/3rdparty/stdalone/xmlparserv2.zip:/d51/oracle/viscomn/util/jre/1.1.8/bin/../classes:/d51/oracle/viscomn/util/jre/1.1.8/bin/../lib/classes.zip
Check logfile /d51/oracle/viscomn/admin/log/vis_apphost1/11040716.log for details.


After analysing for minutes found that the tools java home was incorrectly set and pointing to a wrong directory.

1. Took a backup of the Context file and replaced the s_tools_java to point to the correct java location.

<JAVA_HOME oa_var="s_tools_java">/opt/jdk1.3.1_20/j2se</JAVA_HOME>

2. Then ran autoconfig .

3. Now tried to start the application services and it started successfully.

New System Privilege 'SYSASM' to manage ASM instance in 11g

Hello All,

Today when I was trying to shutdown a 11g ASM instance connected as sysdba it was not allowing me to shutdown and gave 'ORA-01031: insufficient privileges'.

After a bit of research found that in 11g there is a new privilege called 'SYSASM' which is separate for ASM storage administration privilege and for maintaining ASM instance.The basic idea was to separate the storage administrator and the database administrator responsbilities.

Below is what I was trying to do.


[oracle@oelbox1 ~]$ echo $ORACLE_SID
+ASM

[oracle@oelbox1 ~]$ ps -ef | grep -i pmon
oracle 11810 1 0 18:58 ? 00:00:00 asm_pmon_+ASM
oracle 22821 22724 0 22:19 pts/5 00:00:00 grep -i pmon

[oracle@oelbox1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 14 22:19:07 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Automatic Storage Management option

SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
+ASM

SQL> shutdown immediate
ORA-01031: insufficient privileges
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Pr oduction
With the Automatic Storage Management option

[oracle@oelbox1 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.2.0 Production on Thu Oct 14 22:19:46 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connect sys as sysasm
Enter password:
Connected.
SQL>
SQL> shut immediate
ASM diskgroups volume disabled
ASM diskgroups dismounted
ASM instance shutdown
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Pr oduction With the Automatic Storage Management option

ORA-20001:FND_CANT_INSERT_USER_ROLE when attaching responsibility to User

Yesterday we had a issue with one user saying after he logs into applications no responsibility displayed.When we did a search for that user on the forms ,surprisingly
there was no responsibilities attached to that user.

We tried to attach responsibility and save it ,but it will not save and came back with the below message

"ORA-20001:FND_CANT_INSERT_USER_ROLE has been detected in FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT"

Later we ran concurrent program "Workflow Directory Services User/Role Validation" .Request completed normal and this time the responsibility was visible on the forms when we queried that user.But when the user tried to login no responsibilities still.

We fixed this issue by end-dating the responsibility assigned to the user and saved.Then removed the end date for the responsibility and saved.

Now requested the user to test and he can see the responsibility now and work without any issues.

RMAN-05001: auxiliary filename /u01/oracle/oradata/wipd06.dbf conflicts with a file used by the target database

When performing duplication using RMAN I recieved the following message and duplication came out with errors.
On researching found that the values for parameters 'db_file_name_convert' and 'log_file_name_convert' was not set correctly.

The reasons being last time when duplication was performed the DBA used a different Database as source and the values for 'db_file_name_convert' and 'log_file_name_convert' were still pointing to the previous source database mount points.

So this time without checking or modifying the values the DBA started the duplication and received the above error message.

To fix it

Stop the database,change the values for 'db_file_name_convert' and 'log_file_name_convert' to the correct source Database values and then restart the duplication.