Search This Blog

Wednesday, May 29, 2019

Install Oracle Apex 19.1 on Oracle 11g

SELECT NAME FROM V$DATAFILE ; KEEP THE PATH FROM OTHER TABLESPACE. Step-1 CREATE TABLESPACE APEX DATAFILE 'D:\APP\JEWEL\ORADATA\ORCL\MFIMIS\APEX.DBF' SIZE 10M AUTOEXTEND ON NEXT 20M; Step-2 @APEXINS.SQL APEX1 APEX1 TEMP /i/ Step-3 @APXCHPWD.SQL Step-4 @APXLDIMG E:\apex_19.1 Step-5 @apex_epg_config.sql E:\apex_19.1 Step-6 EXEC DBMS_XDB.SETHTTPPORT(8888) ; Step-7 ALTER USER ANONYMOUS ACCOUNT UNLOCK ; ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK; ALTER USER APEX_PUBLIC_USER IDENTIFIED BY vinish;<title> SELECT NAME FROM V$DATAFILE ;<br /> <br /> KEEP THE PATH FROM OTHER TABLESPACE.<br /> <b><br /></b> <b>Step-1</b><br /> CREATE TABLESPACE APEX DATAFILE 'D:\APP\JEWEL\ORADATA\ORCL\MFIMIS\APEX.DBF' SIZE 10M  AUTOEXTEND ON NEXT 20M;<br /> <br /> <b>Step-2</b><br /> @APEXINS.SQL APEX1 APEX1 TEMP /i/<br /> <br /> <b>Step-3</b><br /> @APXCHPWD.SQL<br /> <br /> <b>Step-4</b><br /> @APXLDIMG E:\apex_19.1<br /> <br /> <b>Step-5</b><br /> @apex_epg_config.sql E:\apex_19.1<br /> <br /> <b>Step-6</b><br /> EXEC DBMS_XDB.SETHTTPPORT(8888) ;  <br /> <br /> <b>Step-7</b><br /> ALTER USER ANONYMOUS ACCOUNT UNLOCK ;<br /> <br /> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;<br /> <br /> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY vinish; SELECT NAME FROM V$DATAFILE ;

 KEEP THE PATH FROM OTHER TABLESPACE.

 Step-1 CREATE TABLESPACE APEX DATAFILE 'D:\APP\JEWEL\ORADATA\ORCL\MFIMIS\APEX.DBF' SIZE 10M AUTOEXTEND ON NEXT 20M;

 Step-2 @APEXINS.SQL APEX1 APEX1 TEMP /i/

 Step-3 @APXCHPWD.SQL

 Step-4 @APXLDIMG E:\apex_19.1 (This path is apex folder's immediate previous directory )

 Step-5 @apex_epg_config.sql E:\apex_19.1 (This path is apex folder's immediate previous directory )

 Step-6 EXEC DBMS_XDB.SETHTTPPORT(8888) ;

 Step-7  ALTER USER ANONYMOUS ACCOUNT UNLOCK ;
 ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
 ALTER USER APEX_PUBLIC_USER IDENTIFIED BY vinish; SELECT NAME FROM V$DATAFILE ;<br /> <br /> KEEP THE PATH FROM OTHER TABLESPACE.<br /> <b><br /></b> <b>Step-1</b><br /> CREATE TABLESPACE APEX DATAFILE 'D:\APP\JEWEL\ORADATA\ORCL\MFIMIS\APEX.DBF' SIZE 10M  AUTOEXTEND ON NEXT 20M;<br /> <br /> <b>Step-2</b><br /> @APEXINS.SQL APEX1 APEX1 TEMP /i/<br /> <br /> <b>Step-3</b><br /> @APXCHPWD.SQL<br /> <br /> <b>Step-4</b><br /> @APXLDIMG E:\apex_19.1<br /> <br /> <b>Step-5</b><br /> @apex_epg_config.sql E:\apex_19.1<br /> <br /> <b>Step-6</b><br /> EXEC DBMS_XDB.SETHTTPPORT(8888) ;  <br /> <br /> <b>Step-7</b><br /> ALTER USER ANONYMOUS ACCOUNT UNLOCK ;<br /> <br /> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;<br /> <br /> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY vinish;

No comments:

Post a Comment

Split A String By Coma (,)

Step 1.  create or replace type split_tbl as table of varchar2(32767); Step 2. create or replace function split (     p_list varchar2,...