Oracle Apex Installation in Windows

A quick Oracle Apex Installation guide is here.

I did not feel the need of using images here as most of the work done using Command Prompt.

1:-  Download Oracle Apex and Extract it on your root drive.
      Like on Windows C:\apex and on unix/linux  /tmp/apex

      There should be no blank space in the directory name. 

2:- Go to command prompt and follow these steps.

C:\> cd apex

C:\apex> sqlplus \nolog

Connect with sysdba password.

3:- Write

SQL> @apex_epg_config.sql C:\TEMP 

4:- When installation completes. Set password for oracle apex admin.

( this step can be done after step 5, If file ain’t run here then call this file from sqlplus after step 5. )

SQL> @apxchpwd.sql

When prompted write password, it must contain one capital letter and don’t forget it , as its apex admin password to connect.

5:- Run these commands

(Go to sqlplus ( not from command line) and connect   sys as sysdba )

SQL>  alter user APEX_PUBLIC_USER account unlock;

SQL>  alter user FLOWS_030000 account unlock;

SQL>  alter user APEX_040200 account unlock;

SQL>  alter user APEX_PUBLIC_USER identified by password;

SQL>  alter user ANONYMOUS account unlock;

6:-   Run this in same command where you run apex configuration file and password change file.  

SQL> @apxldimg.sql C:\

 

7:- In same window run these

SQL>  SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

If it returns Zero, run this

SQL>  EXEC DBMS_XDB.SETHTTPPORT(8080);

8:- Execute/run this procedure in same window

SQL> 

DECLARE

  ACL_PATH  VARCHAR2(4000);

BEGIN

  — Look for the ACL currently assigned to ‘localhost’ and give APEX_040200

  — the “connect” privilege if APEX_040200 does not have the privilege yet.

  SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS

   WHERE HOST = ‘localhost’ AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;  

  IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, ‘APEX_040200’,

     ‘connect’) IS NULL THEN

      DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,

     ‘APEX_040200’, TRUE, ‘connect’);

  END IF;

EXCEPTION

  — When no ACL has been assigned to ‘localhost’.

  WHEN NO_DATA_FOUND THEN

  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(‘local-access-users.xml’,

    ‘ACL that lets users to connect to localhost’,

    ‘APEX_040200’, TRUE, ‘connect’);

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(‘local-access-users.xml’,’localhost’);

END;

SQL>  /
SQL>  commit;

9:-

SQL> SELECT VALUE FROM v$parameter WHERE NAME = ‘job_queue_processes’;

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES = 2000; 

10:- Run these commands in end:

SQL>  select par_value From ctxsys.ctx_parameters where par_name = ‘FILE_ACCESS_ROLE’;

SQL>  create role apex_url_datastore_role;

SQL>  grant apex_url_datastore_role to apex_040200;

SQL> exec ctxsys.ctx_adm.set_parameter(‘file_access_role’,’APEX_URL_DATASTORE_ROLE’);

SQL>  select value from v$parameter where name = ‘job_queue_processes’;

SQL> SELECT * FROM dba_users;

 

(in sql developer , if apex_030200 user exists then run the other commands)

SQL>  drop user apex_030200 cascade;

SQL>  exec dbms_network_acl_admin.delete_privilege(‘power_users.xml’,’apex_030200′);

SQL>  exec dbms_network_acl_admin.delete_privilege(‘power_users.xml’,’apex_030200′);

 

if this command return this error then its normal as dbms_network_acl_admin doesnt exists at all just move next , go to apex login page .

 

ORA-31001: Invalid resource handle or path name “/sys/acls/myacl.xml”

11:- If you have shared servers you can run this, this is optional.

SQL>  ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;

 

Add/Install Microsoft LoopBack Adapter

Hi,

Microsoft Loop Back Adapter is  a must and prerequisite  for many software like , Oracle DB, VM Ware, SAP etc.

Today i will explain you how to install and configure it.

Step 1: Go to Windows Device Manager.

LoopBack Adapter

Step 2:  Right Click on Computer name and select Add Legacy Hardware.

 

Step 3:  In the Wizard select Next.

 

Step 4:  Select ” Install hardware manually from a list “.

 

Step 5:  From hardware types , select ” Network Adapters”.

 

Step 6: From Manufacturer select Microsoft, and from Network Adapters select ” Microsoft KM-TEST Loopback Adapter” .

 

Step 7: Click  Next button to install.

 

Step 8: Click Finish.

 

Step 9: Open Network Sharing Center.

 

Step 10: You will see an unknow Network here it, which Windows try to connect, is you Loopback Adapter.

Step 11: Go to Properties of that network and go to Internet Protocl Version 4 Configurations to add a static IP.

Step 12: You must add these settings else Loopback Adapter will not work ( here is case for ORACLE database )

IP Address: 10.10.10.10

Subnet Mask: 255.255.255.0

Preferred DNS Server: 10.26.10.80

 

Step 13:  Click Ok and your loopback adapter is up and working. Enjoy 🙂

Remember to Install and configure it before Installing Oracle Database.

Oracle Installation on Windows

Today I am posting about how to install oracle 11g 64 bit on windows server 2012.

In this post I will also discuss error INS-13001.

Windows Server 2012 configurations:

Windows Edition:  

  • Windows Server 2012 R2 Standard

System:

Intel 2.60 GHz 2 Processors

RAM: 16 GB

64-bit Operating System

Prerequisite:

Java, JDK6 or Higher 64-bit.

Loopback adapter ( for installation see this post )

Softwares ( to download ) :

  • Java (jdk-6u29-windows-x64 OR higher)

 I install Java 7 SDK and JRE , it’s really difficult to find Java 6 setup on internet now , luckily I found it on my backup hard drive.

affiliate_link

  • Oracle Database (11g R2) 11.2.0.1.0 64-bit

You can get setup from this link

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

  • Download .

index

  • Extract the 2 zip files of Database (11g R2) 11.2.0.1.0 64-bit to a common folder win64_11gR2_database.

extract

  • Note:Extract it to the same folder.Else while installing the database it will error out because some files will be missing. It comes around 2.12GB after unzipping.
  • Stop all services of oracle if there is any version running already on System, and uninstall oracle through utility.
  • Delete all the homes created previously to avoid confusion.

home

 

  • If you get this error when you start setup , Install database by clicking on the setup.

“ Oracle Installer:[INS-13001] Environment does not meet minimum requirements “

Then do use below method to start Installation Utility.

  • Run Setup.exe with this command
  • In command prompt go to location of setup.exe folder and type this

Setup.exe -ignoreSysprereqs –ignorePrereq

o1-1

Thinking of creating website click here to get one.