Wednesday 8 February 2012

ORA-12701: CREATE DATABASE character set is not known

ORA-12701: CREATE DATABASE character set is not known
While Starting the database, I had faced the error - ORA-1092 signalled during: ALTER DATABASE OPEN...
then check in the Alert.log it shows the messages like below:
ORA-12701: CREATE DATABASE character set is not known
Thu Jul 9 19:10:14 2009
Error 12701 happened during db open, shutting down database
USER: terminating instance due to error 12701
Instance terminated by USER, pid = 28018
ORA-1092 signalled during: ALTER DATABASE OPEN...

Solution:
I had checked $ORA_NLS10 path. Instead of “$ORACLE_HOME/nls/data/9idata”,
it points to the Wrong one like below:

echo $ORA_NLS10
ORA_NLS10=/aplvol01/CRP/oracle/CRP/db/tech_st/10.2.0/ocommon/nls/admin/data

Change the env file to the correct path and start the database.

Wednesday 1 February 2012

Oracle Apps R12 Forms Not Opening on Linux

Oracle Apps R12 Forms Not Opening on Linux

The forms for Oracle Apps EBS R12 may not open for many reasons.

If you are using Firefox browser then one reason is that the Firefox version may be higher than the recommended(3.0.18) Firefox version.So please make sure that you have installed the recommended Firefox.


Follow below steps to find out:-


1.Steps to Install JRE 5.0 Linux(32-bit)

http://www.oracle.com/technetwork/java/javase/install-linux-138610.html

Manual Installation/registration of Java Plugin in Linux

2.Uninstall any previous installations of Java Plug-in.

[root@linux1 /]# cd /usr/lib/mozilla/plugins

[root@linux1 plugins]# rm -rf libjavaplugin_oji.so



3.For the Mozilla browser create a symbolic link to the Plug-in in the Mozilla plugins directory.

[root@linux1 plugins]# ln -s /usr/java/jre1.5.0_10/plugin/i386/ns7/libjavaplugin_oji.so .


4.Now Restart your Firefox Browser and login in to Oracle EBS R12.

Issue must be resolved!


All the Best!