Oracle Developer for HP-UX PA-RISC R6i Patch13 リリース・ノート

Size: px

Start display at page:

Download "Oracle Developer for HP-UX PA-RISC R6i Patch13 リリース・ノート"

たつやひろき
5 years ago
Views:

1 Oracle Developer for HP-UX PA-RISC R6i Patch : J Copyright 2003, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation Oracle Forms Developer Oracle9iAS Forms Services Oracle Reports Developer Oracle9iAS Reports Services Oracle9i Application Server Oracle Corporation

2 1 Oracle Developer for HP-UX R6i Patch HP-UX OS... 4 CD Oracle Forms Developer and Oracle9iAS Forms Services R6i Forms6i Patch POST RUN_PRODUCT Forms6i Patch Forms Listener Servlet... 7 Forms6i Patch basehtml envfile... 8 formsweb.cfg... 8 Servlet PATH LD_LIBRARYP_PATH... 8 FormsServlet... 8 Servlet... 8 Forms6i Patch /... 8 SSO... 9 Forms6i Patch Listener Servlet HTTPS JInitiator Forms Patch Forms Listner Servlet Forms Listener Servlet Forms Listener Servlet jserv.properties jserv.properties Oracle9i Database NCHAR SJIS CLOB EUC forms60.csh CLOB Form FRM

3 JInitiator Oracle Reports Developer and Oracle9iAS Reports Services R6i Patch Oracle Reports Oracle9iAS Portal LAG LEAD Oracle9iAS Reports Services X Windows Oracle9i Database NCHAR SJIS RDF Report Builder CLOB reports60.csh(reports60.sh) reports60.csh Web og.pll Windows 2000 JInitiator

4 1 Oracle Developer for HP-UX R6i Patch13 Oracle Developer for HP-UX R6i Oracle Developer Server for HP-UX R6i Oracle9i Application Server Enterprise Edition R1.0.2 patch_install.sh $ORACLE_HOME patch_install.sh patch_deinstall.sh.pre_p13 Forms Forms Reports one-off Patch13 Zip Zip Unzip Info-ZIP Web ( ) Unzip HP-UX OS CD HP-UX OS PHSS_21959 PHSS_22946 Forms Reports ASSERTION FAILED STATUS = CLIPBOARDSUCCESS FILE UICL.C LINE 985 HP-UX Motif OS Patchset PHSS_23823 PHSS_23823 OS Oracle Developer OS $ /usr/sbin/swlist -l fileset CD README_dev6ip13.html developer6i_p13.zip README_dev6ip13.html README developer6i_p13.zip README_VERSION.html Oracle9i Application Server ORACLE_HOME <ias_home>/6iserver <ias_home>/6iserver/lib SHLIB_PATH <ias_home>/6iserver/bin PATH RDBMS RDBMS ORACLE_HOME DISPLAY 1 Oracle Developer for HP-UX R6i Patch13 4

5 patch_install.sh RDBMS () You have answered 'No' to installing patchset for RDBMS, returning to the Asset Manager Screen. Yes RDBMS : Oracle E-Business Suite 11i Oracle E-Business Suite 11i 1. ORACLE_HOME 2. developer6i_p13.zip $ORACLE_HOME 3. Unzip 4. developer6i_patch13/bin/genshlib chmod ug+x developer6i_patch13/bin/genshlib /patch_install.sh genshlib: error: archive library not found: $ORACLE_HOME/lib/libix.a 7. SHLIB_PATH $ORACLE_HOME/network/jre11/lib/PA_RISC/native_threads 8. Relink cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install Forms Relink (make -if ins_forms60w.mk install) /usr/ccs/bin/ld: Found 39 duplicate symbol(s) make: [f60webm] Error 1 (ignored) 1. ORACLE_HOME 2../patch_deinstall.sh 3. Relink cd $ORACLE_HOME/procbuilder60/lib; make -f ins_procbuilder.mk install cd $ORACLE_HOME/forms60/lib; make -f ins_forms60w.mk install 1 Oracle Developer for HP-UX R6i Patch13 5

6 cd $ORACLE_HOME/reports60/lib; make -f ins_reports60w.mk install cd $ORACLE_HOME/graphics60/lib; make -f ins_graphics60w.mk install README 1 Oracle Developer for HP-UX R6i Patch13 6

7 2 Oracle Forms Developer and Oracle9iAS Forms Services R6i Forms6i Patch10 (Oracle Developer R6i Patch13) Oracle Server 7.3.4, 8.0.4, 8.0.5, 8.0.6, 8.1.5, 8.1.6, 8.1.7, Forms6i Patch10 OTN-Japan OTN-Japan Web ( Forms6i DATETIME Forms6i Patch9 Forms6i(Java ) OK_TO_PASTE Boolean EDITABLE(Boolean ) SELECTION (Point ) POST RUN_PRODUCT 1 POST RUN_PRODUCT 1 Web Connection from a new browser window not supported POST GET run_product open_form PL/SQL 1 Forms Forms6i Patch9 OTN-Japan OTN-Japan Web ( Forms URL Forms Forms Listener Servlet runtime 15 servlet 15 Forms 2 Oracle Forms Developer and Oracle9iAS Forms Services R6i 7

8 Forms6i Patch8 Forms6i Patch7 Forms6i Patch8 OTN-Japan OTN-Japan Web ( formsweb.cfg envfile workingdirectory formsweb.cfg (FormsServlet ) runtime basehtml envfile basehtml envfile ( :envfile=default.env) Forms basehtml envfile Forms Servlet (formsweb.cfg) formsweb.cfg Forms Servlet formsweb.cfg basehtml=base.htm basehtmljinitiator=basejini.htm basehtmlie=baseie.htm envfile=default.env workingdirectory= Servlet PATH LD_LIBRARYP_PATH Servlet PATH LD_LIBRARY_PATH FormsServlet Forms Servlet basehtml basehtmlie basehtmljinitiator Forms Servlet (formsweb.cfg) default Servlet Servlet Forms6i Patch7 OTN-Japan OTN-Japan Web ( / ID formsweb.cfgforms Servlet CGI HTML ID Forms6i Patch7 ID formsweb.cfg Forms CGIID HTML ID ID Forms Patch7 ID Forms Servlet Listener Servlet Forms Servlet HTML FormsCGI HTML Forms Listener 2 Oracle Forms Developer and Oracle9iAS Forms Services R6i 8

9 SSO Oracle Login Server Forms Service & Patch 7 Forms ID formsweb.cfg : 1. username=value&password=value&database=value formsweb.cfg userid=%user%/%password%@%database% : [myapp_sso] Forms6i Patch6 userid=%user%/%password%@%database% 注意 : % URL 2. Logon Server Oracle Portal Forms - URL formsweb.cfg Source formsweb.cfg userid=%name%/%password%@%source% - POST POST URL Forms Servlet Forms6i Patch6 OTN-Japan OTN-Japan Web ( Oracle Forms 6i Patch5 Oracle Forms FRM-92100: Patch6 Bug# Listener Servlet Oracle Forms <networkretries> 2 Oracle Forms Developer and Oracle9iAS Forms Services R6i 9

10 "2/30" "2" 2 "30" <networkretries> <networkretries> Oracle Forms FRM-92102: Forms < > 1 Forms Oracle Forms FRM-92101: base HTML "networkretries" formsweb.cfg networkretries=30 0 formsweb.cfg Patch4 Listener Servlet HTTPS JInitiator Forms JInitiator HTTPS HTTP keep-alive keep-alive JInitiator URL SSL Forms 6i Patch4 Forms 6i Patch 4:Forms Listener Servlet Forms HP-UX Patch4 Patch4a Forms Listner Servlet Forms Forms Listener Forms Listener Forms HTTP HTTPS Forms Listener Forms 6i Patch4 Forms Listener Forms Listener Servlet Forms Forms Listener Servlet HTTP HTTPS Forms Listener Servlet Forms Listener HTTP HTTPS Oracle9iAS R Oracle Forms Developer and Oracle9iAS Forms Services R6i 10

11 Forms Listener Servlet Forms Listener Servlet Oracle9i Application Server Web Java Forms Listener Servlet Forms Server Runtime Forms Server Runtime Forms Listener Servlet Forms Listener Servlet Forms Forms Listener Forms Listener Servlet Web (HTTP/1.1 HTTP/1.0) HTTP/1.1 HTTP/1.0 Forms Listener Forms Listener SSL SSL(Secure Sockets Layer) Web HTTPS Forms Server Apache Jserv Internet Explorer 5.0 JVM Oracle JInitiator HTTP HTTPS Internet Explorer 5.0 Microsoft JVM Forms Listener Servlet Forms 6i Patch 4:Forms Listener Servlet Forms Oracle Technology Network Web jserv.properties HP-UX Forms Listener Servlet Oracle9iAS Servlet <9iAS_HOME>/Apache/Jserv/etc/jserv.properties 2 Oracle Forms Developer and Oracle9iAS Forms Services R6i 11

12 wrapper.classpath = <9iAS_HOME>/6iserver/forms60/java wrapper.classpath = <9iAS_HOME>/6iserver/forms60/java/f60srv.jar jserv.properties Forms Listener Servlet Oracle9iAS Servlet <9iAS_HOME>/Apache/Jserv/etc/jserv.properties wrapper.env=nls_lang=japanese_japan.ja16euc FRM-13009: JavaBean IView : Forms JavaBean JavaBean Oracle Forms IView : Oracle Forms oracle.forms.ui.iview FRM-18010: JavaBean : Forms JavaBean JavaBean Forms : JavaBean Form Builder JavaBean Oracle9i Database NCHAR Oracle9i NCHAR(NVARCHAR2) Oracle9i NCHAR(NVARCHAR2) Unicode Net8 Oracle9i NCHAR SJIS CLOB EUC : JA16SJIS CLOB Form JA16EUC Form : JA16EUC forms60.csh Forms forms60.csh SHLIB_PATH SHLIB_PATH setenv SHLIB_PATH $ORACLE_HOME/lib:/usr/lib 2 Oracle Forms Developer and Oracle9iAS Forms Services R6i 12

13 setenv SHLIB_PATH $ORACLE_HOME/lib:/usr/lib:${SHLIB_PATH} CLOB Form FRM : CLOB Form Forms Runtime FRM : SQL : : : JA16EUC : JA16SJIS : JA16EUC REP-0911: : $ORACLE_HOME/doc60/admin/quicktuor/JA/d2q60.html 2 DE_VARIABLESHARE NULL DE_VARIABLESHARE=YES 2 2 When-Validate-Item Alert 2 JInitiator JInitiator Forms Netscape HTML WebForms 2 Oracle Forms Developer and Oracle9iAS Forms Services R6i 13

14 3 Oracle Reports Developer and Oracle9iAS Reports Services R6i Patch2 (Oracle Developer R6i Patch13) Oracle Server 7.3.4, 8.0.4, 8.0.5, 8.0.6, 8.1.5, 8.1.6, 8.1.7, Oracle Reports Oracle9iAS Portal Oracle9iAS Reports Services R6i Oracle9iAS Portal R3.0 Oracle9iAS Reports Services R6i Oracle9iAS Reports Services ORDER BY HAVING SELECT GROUP BY Oracle8i SELECT dname, sum(sal) FROM dept, emp WHERE dept.deptno =emp.deptno GROUP BY dname Oracle8i CUBE ROLLUP ROLLUP CUBE ROLLUP 1 CUBE crosstabulation 1 GROUPING CUBE ROLLUP GROUPING 0 1 Oracle8i R8.1.6 SQL SQL SQL ANSI 4 LAG LEAD 3 Oracle Reports Developer and Oracle9iAS Reports Services R6i 14

15 % RANK DENSE_RANK PERCENT_RANK CUME_DIST NTILE 13 AVG SUM MIN MAX COUNT VARIANCE STDDEV SQL 1 AVG SUM MAX COUNT VARIANCE STDDEV SQL LAG LEAD SQL LAG LEAD Oracle8i 2 SQL PL/SQL SELECT GROUPING(dname) dept_grouping_code, DECODE(GROUPING(dname), 1, 'All Departments',initcap(dname)) AS dname, GROUPING(job) job_grouping_code, DECODE(GROUPING(job), 1, 'll Jobs', job) AS job, COUNT(*) "Total Empl", AVG(sal+nvl)(comm,0)) "Average Comp" FROM emp, dept WHERE dept.deptno = emp.deptno GROUP BY CUBE (dname, job) 2 SQL SELECT emp.deptno, dept.dname, avg(sal+nvl(comm,9)) over (partition by dept.deptno) avg_dept_sal, ename, job, sal, 3 Oracle Reports Developer and Oracle9iAS Reports Services R6i 15

16 nvl(comm,0), (sal+nvl(comm,0)) Compensation, hiredate RANK () OVER (PARTITION BY emp.deptno ORDER BY (sal+nvl(comm,0)) DESC) as rk, RANK () OVER (ORDER BY (sal+nvl(comm,0)) DESC) "Rank in Company", RANK () OVER (ORDER BY hiredate) "rank in employ", ((LEAD(hiredate, 1) OVER (ORDER BY hiredate))-hiredate) "Days over emp", (LEAD(ename,1) OVER (ORDER BY hiredate)) next_emp FROM emp, dept WHERE dept.deptno = emp.deptno ORDER BY rk SQL*Plus Oracle9iAS Reports Services SQL Oracle9iAS Reports Services SQL Oracle9iAS Reports Services Oracle9iAS Reports Services R6i Patch2 SQL Oracle9iAS Reports Services SQL Oracle9iAS Reports Services R6i Patch2 2 Oracle9iAS Reports Services PostScript HTML RTF 2 Oracle9iAS Reports Services Oracle9iAS Reports Services X Windows Oracle9iAS Reports Services Windows Windows X Windows Oracle9iAS Reports Services DISPLAY REP-3000 REP-1800 Oracle9i Database NCHAR Oracle9i NCHAR(NVARCHAR2) Oracle9i NCHAR(NVARCHAR2) Unicode Net8 Oracle9i NCHAR SJIS RDF : SJIS.rdf REP-0495: 3 Oracle Reports Developer and Oracle9iAS Reports Services R6i 16

17 SJIS EUC : EUC Report Builder CLOB CLOB Report Builder Report Builder reports60.csh(reports60.sh) : Reports reports60.csh(b reports60.sh) : REPORTS60_PATH $ORACLE_HOME/reports60/admin/templates ) reports60.csh setenv REPORTS60_PATH $ORACLE_HOME/reports60/admin/templates:$ORACLE_HOME/tools/devdem60/demo/r eports reports60.sh REPORTS60_PATH=$ORACLE_HOME/reports60/admin/templates:$ORACLE_HOME/tools/ devdem60/demo/reports export REPORTS60_PATH : : NLS_LANG ) sh unset NLS_LANG csh unsetenv NLS_LANG reports60.csh $ORACLE_HOME/reports60.csh NLS_LANG IF if [ "$NLS_LANG" = "" ] then if (! $?NLS_LANG ) then 3 Oracle Reports Developer and Oracle9iAS Reports Services R6i 17

18 : JA16EUC : JA16SJIS : JA16EUC REP-0911: : $ORACLE_HOME/doc60/admin/quicktuor/JA/rwq60.html J Oracle Reports Developer 6i Oracle Reports Developer SQL Oracle Technology Network Japan Web CD $ORACLE_HOME/doc60/admin/manuals/JA/od_pubrep60 CD J Oracle9i Application Server Oracle Reports Services Web Oracle Reports Developer and Oracle9iAS Reports Services R6i 18

19 4 og.pll Oracle Forms Developer Oracle Reports Developer og.pll Forms Graphics Oracle Developer R6i CD- ROM <CD-ROM>/extras/forms/graphics/og.pll Windows 2000 JInitiator Windows 2000 Administrators Power Users Users JInitiator Administrators Power Users 4 19

Oracle Developer for Microsoft Windows R6i Patch13 リリース・ノート

Oracle Developer for Microsoft Windows R6i Patch13 2003 4 : J07595-01 Copyright 2003, Oracle Corporation All Right Reserved Oracle Oracle Oracle Corporation Oracle Forms Developer Oracle9iAS Forms Services