Go to File Menu -> Tools -> Manage Add-ons;
There make sure that only one Java Plug in is enabled!
This should solve the problem!
Also verify Control Panel-> Java-> Java(Tab) runtime options; make sure all point to the same javaw.exe file and that the version of Java is same!
Also recommended to clear Java cache.
This is also listed as a bug that is with Java 6 Update 10 http://bugs.sun.com/view_bug.do?bug_id=6516270
Sunday, May 30, 2010
applsys password and adadmin adpatch
During adpatch and adadmin session, the ad tools ask ORACLE password of Application Object Library which is owned by APPLSYS. If the password for applsys is wrong or the account is locked/expired, the prompt for password appears again.
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AD Administration is verifying your username/password....Unable to connect.
Error: The given ORACLE password is not the correct password.
Please re-enter the ORACLE username and password.
Enter the ORACLE password of Application Object Library [APPS] :
Check the password for apps and applsys and unlock them if necessary. Apps and applsys should have the same password.
REF:
Adpatch And Adadmin Utilities Will Not Accept Apps Password [ID 555251.1]
The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :
AD Administration is verifying your username/password....Unable to connect.
Error: The given ORACLE password is not the correct password.
Please re-enter the ORACLE username and password.
Enter the ORACLE password of Application Object Library [APPS] :
Check the password for apps and applsys and unlock them if necessary. Apps and applsys should have the same password.
REF:
Adpatch And Adadmin Utilities Will Not Accept Apps Password [ID 555251.1]
applying a new patch after the failed patch application
175485.1 How to apply an 11i patch when adpatch is already running
If you are applying a big patch which need hours and get into a problem which needs to apply another patch to fix the problem, you need above metalink internal note to apply this patch. As it is an internal note, you cannot download it from mysupport. Following is from beginapps.blogspot.com. check oracle-magic.blogspot.com for similar note.
However, if the patch is small, you can apply another patch by not continuing the previous adpatch run. After the patch fix, apply the previous patch again.
1. Using the adctrl utility, shutdown the workers.
a. adctrl
b. Select option 3 "Tell worker to shutdown/quit"
2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema
a. sqlplus applsys/
b. create table fnd_Install_processes_back
as select * from fnd_Install_processes;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes_back;
select count(*) from fnd_Install_processes;
3. Backup the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS_back
as select * from AD_DEFERRED_JOBS;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory.
At this point, the adpatch session should have ended and the cursor should
be back at the Unix prompt.
a. cd $APPL_TOP/admin/
b. mv restart restart_back
c. mkdir restart
5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. drop table FND_INSTALL_PROCESSES;
c. drop table AD_DEFERRED_JOBS;
6. Apply the new patch.
7. Restore the .rf9 files located in $APPL_TOP/admin//restart_back
directory.
a. cd $APPL_TOP/admin/
b. mv restart restart_
c. mv restart_back restart
8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS
schema.
a. sqlplus applsys/
b. create table fnd_Install_processes
as select * from fnd_Install_processes_back;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes;
select count(*) from fnd_Install_processes_back;
9. Restore the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS
as select * from AD_DEFERRED_JOBS_back;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
10. Re-create synonyms
a. sqlplus apps/apps
b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;
c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;
11. Start adpatch, it will resume where it stopped previously.
If you are applying a big patch which need hours and get into a problem which needs to apply another patch to fix the problem, you need above metalink internal note to apply this patch. As it is an internal note, you cannot download it from mysupport. Following is from beginapps.blogspot.com. check oracle-magic.blogspot.com for similar note.
However, if the patch is small, you can apply another patch by not continuing the previous adpatch run. After the patch fix, apply the previous patch again.
1. Using the adctrl utility, shutdown the workers.
a. adctrl
b. Select option 3 "Tell worker to shutdown/quit"
2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema
a. sqlplus applsys/
b. create table fnd_Install_processes_back
as select * from fnd_Install_processes;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes_back;
select count(*) from fnd_Install_processes;
3. Backup the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS_back
as select * from AD_DEFERRED_JOBS;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory.
At this point, the adpatch session should have ended and the cursor should
be back at the Unix prompt.
a. cd $APPL_TOP/admin/
b. mv restart restart_back
c. mkdir restart
5. Drop the FND_INSTALL_PROCESSES table and the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. drop table FND_INSTALL_PROCESSES;
c. drop table AD_DEFERRED_JOBS;
6. Apply the new patch.
7. Restore the .rf9 files located in $APPL_TOP/admin//restart_back
directory.
a. cd $APPL_TOP/admin/
b. mv restart restart_
c. mv restart_back restart
8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS
schema.
a. sqlplus applsys/
b. create table fnd_Install_processes
as select * from fnd_Install_processes_back;
c. The 2 tables should have the same number of records.
select count(*) from fnd_Install_processes;
select count(*) from fnd_Install_processes_back;
9. Restore the AD_DEFERRED_JOBS table.
a. sqlplus applsys/
b. create table AD_DEFERRED_JOBS
as select * from AD_DEFERRED_JOBS_back;
c. The 2 tables should have the same number of records.
select count(*) from AD_DEFERRED_JOBS_back;
select count(*) from AD_DEFERRED_JOBS;
10. Re-create synonyms
a. sqlplus apps/apps
b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;
c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;
11. Start adpatch, it will resume where it stopped previously.
how to run hrglobal.drv
Hrglobal.drv and legislative data update
0. apply necessary legislative data update patch (either standalone data patch or combined with rollup patch. Apply required pre and post patches).
1. run data install
java oracle.apps.per.DataInstall apps appspw thin pind21:1571:PTCH1
choice 1: select legislative data to install/upgrade
Choice 1I (Global Human Resources Install)
Choice 5I (Canada Human Resources Install)
Choice 6I (Canada Payroll Install)
Choice 55I (United Kindom Human Resources Install)
Choice 56I (United Kindowm Payroll Install)
Choice 57I (United States Human Resources Install)
Choice 58I (United States Payroll Install)
(need to choose all with Installed under leg. data? Column)
Type enter key to return to main menu.
Choice 4 to exit to confirmation menu. Then type Y to exit and save.
2. Run hrglobal.drv
Login as applmgr
Cd $PER_TOP/patch/115/driver
Adpatch options=hotpatch driver=hrglobal.drv logfile=adpatch_hrglobal.log
Answer normal adpatch interview questions.
REF:
How to Install Legislative Data Using Data Installer and hrglobal.drv [ID 140511.1]
HRGLOBAL Basics [ID 300097.1]
Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal) [ID 145837.1]
0. apply necessary legislative data update patch (either standalone data patch or combined with rollup patch. Apply required pre and post patches).
1. run data install
java oracle.apps.per.DataInstall apps appspw thin pind21:1571:PTCH1
choice 1: select legislative data to install/upgrade
Choice 1I (Global Human Resources Install)
Choice 5I (Canada Human Resources Install)
Choice 6I (Canada Payroll Install)
Choice 55I (United Kindom Human Resources Install)
Choice 56I (United Kindowm Payroll Install)
Choice 57I (United States Human Resources Install)
Choice 58I (United States Payroll Install)
(need to choose all with Installed under leg. data? Column)
Type enter key to return to main menu.
Choice 4 to exit to confirmation menu. Then type Y to exit and save.
2. Run hrglobal.drv
Login as applmgr
Cd $PER_TOP/patch/115/driver
Adpatch options=hotpatch driver=hrglobal.drv logfile=adpatch_hrglobal.log
Answer normal adpatch interview questions.
REF:
How to Install Legislative Data Using Data Installer and hrglobal.drv [ID 140511.1]
HRGLOBAL Basics [ID 300097.1]
Latest Oracle HRMS Legislative Data Patch Available (HR Global / hrglobal) [ID 145837.1]
How to bypass the regenerating seeded forms
CSFDCSTA.fmb has not used from release 11.5.8. However, running adadmin to regenerate all forms will have compilation error for package boby STAT. (Note 438795.1). You could just ignore the error message or you can disable the regeneration of this forms (Note 112327.1).
1. save a copy of csffile.drv in $CSF_TOP/admin/driver
cd $CSF_TOP/admin/driver
cp csffile.drv csffile.drv.orig
2. delete line with CSFDCSTA.fmb and CSFDCSTA.fmx in csffile.drv
3. run adadmin again and regenerate all forms in csf.
Ref:
Field Service Form CSFDCSTA.fmb Does not compile: Component ‘GET_SELECTED_TERR’ must be declared [ID 438795.1]
How Does ADADMIN know which forms fies to regenerate? [ID112327.1]
1. save a copy of csffile.drv in $CSF_TOP/admin/driver
cd $CSF_TOP/admin/driver
cp csffile.drv csffile.drv.orig
2. delete line with CSFDCSTA.fmb and CSFDCSTA.fmx in csffile.drv
3. run adadmin again and regenerate all forms in csf.
Ref:
Field Service Form CSFDCSTA.fmb Does not compile: Component ‘GET_SELECTED_TERR’ must be declared [ID 438795.1]
How Does ADADMIN know which forms fies to regenerate? [ID112327.1]
The troubling features of My Oracle Support as of March 8 2010
The classic metalink was retired during the weekend of November 6-8, 2009. My Oracle Support was in trial before then and I tried and did not like it. So I continued to use metalink until the cutoff date. After November 6-8, I did not have the choice although I hate My Oracle Support. I have compiled following features in My Oracle Support which I believe are troubling ones.
1. The first login page does not show me username/password fields but a sign-in button. I need to click the sign-in button and navigate to another page for username/password fields.
2. after login, I have to wait for a long time as the system is loading the dashboard.
3. The dashboard is confusing as there is too much info in it.
4. cannot use backspace button in SR upload message and SR: contact fields.
5. Service Request: radio button for technical SR and Non-Technical SR: should use check box. I want to display all of my service requests.
6. patch search: filter platform or language, not both.
7. session timeout: My Oracle Support Services Error: A server connection error occurred: IO Error #2032 Please try again later: should direct me to login page
8. logoff is slow than close the browser and start-over again.
9. Family pack and min-pack: does not include a link or pointer to more patches needed on top of these packs.
10. Talked to some Oracle reps in Sales, Education, Support etc. A lot of people know the problems with My Oracle Support, but no fix yet.
11. can not use the browser’s backpage button
12. service request updated (three choices during SR creation: update to SR, email, and phone): when choosing email option, analyst updated the service request and then My Oracle Support generated following email to me:
Please note that your Service Request Number 3-1220691331 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.
Why not send me the actual updates?
13. service request escalation: there is no easy way to call analyst’s manager (no phone number or manager’s email address) or request for escalation. It is worse than metalink. In metalink, we know who is the manager for the support analyst.
In summary, the GUI design is total unacceptable. It is slow. The navigation is confusing and common keyboard features got disabled.
The GUI design follows same pattern as Oracle EBS. Comparing to Google’s web design, Oracle really needs to hire some product managers from Google.
1. The first login page does not show me username/password fields but a sign-in button. I need to click the sign-in button and navigate to another page for username/password fields.
2. after login, I have to wait for a long time as the system is loading the dashboard.
3. The dashboard is confusing as there is too much info in it.
4. cannot use backspace button in SR upload message and SR: contact fields.
5. Service Request: radio button for technical SR and Non-Technical SR: should use check box. I want to display all of my service requests.
6. patch search: filter platform or language, not both.
7. session timeout: My Oracle Support Services Error: A server connection error occurred: IO Error #2032 Please try again later: should direct me to login page
8. logoff is slow than close the browser and start-over again.
9. Family pack and min-pack: does not include a link or pointer to more patches needed on top of these packs.
10. Talked to some Oracle reps in Sales, Education, Support etc. A lot of people know the problems with My Oracle Support, but no fix yet.
11. can not use the browser’s backpage button
12. service request updated (three choices during SR creation: update to SR, email, and phone): when choosing email option, analyst updated the service request and then My Oracle Support generated following email to me:
Please note that your Service Request Number 3-1220691331 has been updated. To view the update, please access My Oracle Support at https://support.oracle.com/ and choose the Service Requests tab.
Why not send me the actual updates?
13. service request escalation: there is no easy way to call analyst’s manager (no phone number or manager’s email address) or request for escalation. It is worse than metalink. In metalink, we know who is the manager for the support analyst.
In summary, the GUI design is total unacceptable. It is slow. The navigation is confusing and common keyboard features got disabled.
The GUI design follows same pattern as Oracle EBS. Comparing to Google’s web design, Oracle really needs to hire some product managers from Google.
how to run non-interactive ftp
##logfile="ftp.log"
##exec > $logfile 2>&1
echo 'THIS IS A TEST'
files=`find ftp* -mtime 0`
echo $files
for file in $files
do
ftp -vn peterpan <
binary
pwd
mput $file
quit
EOF
done
echo 'FINISH'
peterpan here is the remote hostname with an account of oracle and password oracle.
##exec > $logfile 2>&1
echo 'THIS IS A TEST'
files=`find ftp* -mtime 0`
echo $files
for file in $files
do
ftp -vn peterpan <
binary
pwd
mput $file
quit
EOF
done
echo 'FINISH'
peterpan here is the remote hostname with an account of oracle and password oracle.
non-interactively download data from websites
Here is an example on how to download current exchange data from a website:
wget "http://www.oanda.com/cgi-bin/fxcsv/fxcsv?client_id=oandatest&exch=USD&expr=EUR_BAM_INR" -O exchange.csv
Download data are stored in comma separate value in exchange.csv.
You could create a shell script to download other security data or even download books.
wget "http://www.oanda.com/cgi-bin/fxcsv/fxcsv?client_id=oandatest&exch=USD&expr=EUR_BAM_INR" -O exchange.csv
Download data are stored in comma separate value in exchange.csv.
You could create a shell script to download other security data or even download books.
Subscribe to:
Posts (Atom)