today:
597
yesterday:
1,098
Total:
1,132,865

General Apex setup procedure

admin 2016.04.28 14:06 Views : 245

Apex setup procedure

   1.  oracle developer  installation

       a. tablespaces create (gracework)
         create tablespace Gracework datafile 'C:oraclexeapporacleoradataXEGRACEWORK.DBF' SIZE 20M AUTOEXTEND ON;

       b. User table create (gracework)


   2.  EditPlus 3.40

   3.  apex express (XE) installation
       workspace create (gracework thru XE admin)

   4.  import dmp file
  
       copy image table to wwv_flow_files
       insert into wwv_flow_files   select * from  FLOW_FILES_IMAGE_T  

   5.  import gracework application

   6.  setup email (SMTP) procedures

       a) port change 2525 (Windows-> System32 --> Drivers --->etc -->Service

       b) port change APEX Admin  ---> Manage Instancde ->Instance Settings ->

       c) run smtp proc thru command line (email folder) 
      
       d) recompile procedure GRACE_KOEMAIL, PROCSEND_BATCH_EMAIL (after change port number and korean character)

       e) port change for network
  
   7.  Increase speed
    
       from sqlplus

       alter system set sessions=250 scope=spfile;
       alter system set processes=200 scope=spfile;
  
   8. Increase excess user

       run regeidt

    a)   HKEY_LOCAL_MACHINESOFTWAREMicrosoftInternet Explore
       MAINFeatureControlFEATURE_MAXCONNECTIONSPERSERVER

       and

       HKEY_LOCAL_MACHINESOFTWAREMicrosoftInternet Explore
       MAINFeatureControlFEATURE_MAXCONNECTIONSPER1_0SERVER 
    b)
       Now create DWORD Value called iexplore.exe for both sub keys
       to 10 or as desired
No. Subject Author Date Views
9 Name Show admin 2016.04.28 254
8 PHONE NUMBER admin 2016.04.28 207
7 UPDATE PROCESS admin 2016.04.28 227
» Apex setup procedure admin 2016.04.28 245
5 CREATE TABLESPACE admin 2016.04.28 219
4 Delete Message - Are you sure you want to delete this object? admin 2016.04.28 204
3 Captcha Test file admin 2016.04.18 251
2 How-To Document / Change a Logo in a Page Template admin 2016.04.16 284
1 Field Showing admin 2016.04.01 200