ScribeFire makes life easier for Bloggers

ScribeFire makes life easier for Bloggers . ScribeFire is Firefox addon through we can edit ,create and delete the blog contents . Its very handy and lighter to use . Thanks to Firefox .

This blog is one year old

I take this opportunity to thank everyone encouraged me to start this blog

Difference in registry key for Windows

This topic is common to all . I found its very interesting . It will be helpful to Windows oracle APPS customer.

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001
HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet

ControlSet001 = Set of boot information used to boot the system.

ControlSet002 = Set of boot information used for “Last Known
Good” configuration.

CurrentControlSet = Maps to either 001 or 002 above, depending
on how the system was booted. All edits should be done to this set,
as doing so will assure you’re modifying whichever control set is
currently in force.

How to start the mobile web application in R12.

Starting the Mobile Web Application (mwa)

Go to $INST_TOP/admin/scripts . Check mwactl its instantiated by Autoconfig.

Windows -mwactl.cmd start
UNIX -mwactl.sh start

In windows ,Once you fired the above command .It will open two or three command prompt with below message.

Message
———
“MWA Telnet server Release: 1.0.8.4 [December 12th 2002]“
E:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\bin\java.exe -Doracle.apps.mwa=E:
\oracle\VIS\inst\apps\VIS_ap703app -Doracle.apps.inst=E:\oracle\VIS\inst\apps\VI
S_ap703app -mx256m -ms128m -cp “E:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\
lib\dt.jar;E:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\lib\tools.jar;E:\oracl
e\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\rt.jar;E:\oracle\VIS\apps\
apps_st\comn\java\lib\appsborg2.zip;E:\oracle\VIS\apps\apps_st\comn\java
\classes”

oracl
e.apps.mwa.presentation.telnet.Listener 10202
Created server socket : listening on port 10202
Server startup is successful.

Two ways to check what are the ports are available for mobile application:

1. From the above message you can find what are the ports are open for the mobile application .. here 10202 in this port is listening .
2. Login to sysadmin/sysadmin.
   system administrator–>Oracle Applications Manager–>Hosts—->view configuration .

you can find the “MSCA Server Port Number 10200-10205″

To test whether MWA is started . Type
“telnet hostname.domainname 10200″

Compilation and Translation error when compiling JSP on R12

This error will occur on R12 environment and AS 10.1.3.0 (Windows instance not sure about unix instance)

Error:
——–
[5424] !!TRANSLATION ERROR(0) ahlapprCreateSpaceARMain.jsp:
java.io.IOException: The filename, directory name, or volume label syntax is
incorrect

Problem:
———
In windows environment,after new installation i tried to compile JSP and i used to below command to compile.
———————————————————————-
perl -x %fnd_top%\patch\115\bin\ojspCompile.pl –compile –flush –quiet
—————————————————————————————————
Note in windows env you need to mention perl -x in the prefix.After hard days breaking my head whats gone wrong with the installation.After i find out drive letter for jsp_dir in ojspCompile.conf is small.JSP class files is class sensitive .So its unable to determine the path.

Location of ojspCompile.conf : %INST_TOP%\appl\admin\

solution:
——–
1. Change the drive letter to Upper case in the ojspCompile.conf
For e.g.
jsp_dir = e:\VIS\apps\apps_st\comn\webapps\oacore\html
to
jsp_dir = E:\VIS\apps\apps_st\comn\webapps\oacore\html

2.Raise an SR ask for new ojspCompile.pl

3.Add a following piece of code in ojspCompile.pl (Use it at your own risk )
----------------------------------------------------
if($ISWINNT) {
my $jsp_dir_nt = ucfirst($jsp_dir);
$jsp_dir = $jsp_dir_nt;
}
----------------------------------------------------

Apps login error

Error :-
——-
Unable to login: &REASON has been detected in &ROUTINE

Problem:
———
log file -OACoreGroup.0.stderr f
[fnd.common.logging.DebugEventManager.handlerException]:

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

Solution:
——–
ORA-01000: maximum open cursors exceeded

- Increase the SGA_TARGET parameter to 1GB

- Increase the OPEN_CURSORS parameter in init.ora file present in database

To see if you’ve set OPEN_CURSORS high enough, monitor v$sesstat for the maximum opened cursors current. If your sessions are running close to the limit increase the value of OPEN_CURSORS parameter in init.ora file as per your requirement. You can run the following query which has a sample output

SQL> select max(a.value) as highest_open_cur, p.value as

 max_open_cur from v$sesstat a, v$statname b, v$parameter p

where a.statistic# = b.statistic#and b.name = 'opened cursors current'and

p.name= 'open_cursors'  group by p.value;

How to find forms version using command line?

Execute following command,first line will show the version.

$ORACLE_HOME/bin/frmcmp help=y

Installation of oracle application on windows

Installation of oracle apps R11 on windows:
——————————————-

Pre requistes :

1. MKSNT (mks80,mks90) tool kit needs to use. This is used for executing shell scripts on windows platform
2. VC ++ 6.0 . It is used for relinking the executables which was build on this version.

If you used VS2005 for 11i . It will throw an error during relinking and also cannot able to open the registry. If you are using mks90 then you needs to install P3 service patch in order to work properly

Installation of oracle apps R12 on windows:
——————————————-

Pre requistes:

1. MKSNT (mks80,mks90) tool kit needs to use. This is used for executing shell scripts on windows platform
2. VS2005

Autoconfig

Great starts make great finishes

Today i am going to discuss about Autoconfig
AC–Autoconfig

What is Autoconfig?
Autoconfig is a tool for configuring application instance.

What are the programs and program name involved in AC?
You can see perl,shell,cmd and java programs.

1.adconfig.pl- Its a main program which inturn call Java APIs for configuring appl instance.
args-appl context file location

2.adautocfg.sh/adautocfg.cmd-This program inturn calls adconfig.pl
args-apps password

3.adconfig.sh-This program again calls adconfig.pl

These three programs i used for running AC.

4. adchgatname.pl – This program will validating the APPL_TOP name in context file .If the APPL_Top name is changed, then this utility will take care of storing the old APPL_TOP name in APPL_TOP/admin/ATName.txt.Adconfig.pl calls this program .