Tuesday, November 23, 2010

Most basic things of apex

Page Rendering :- process of generating a page from database ( using show apge method / Procedure ). It assembeles all code into HTML format .


Page Processing :- evaluate & execute when page is Processed using ( accept apge Procedure ).
branching , computation , validation , processi ng .


when the page is requested then show page is executed.


when page is submitted then the accept page is executed,


Html Pages are mostly delivered on stateless protocol.

User Roles in APEx

Developer ---> create / edit application .

Workspace admin

1) manage workspace
2) carete suers
3) Viewing log file


END user :- end user to app

Instance Admin :- enitre hosted instance using admin services application .

Application Express Servers

The servers in apex are

!) APEX listeneer
2) http server

3) embedded plsql



Till 11.1 db there was the three tier architecture , hence the apex listener and http port had to be sperately installed.

Then in 11. or later or in XE , comes with embedded plsql

A two tier architecture .

hence no need to install the servers manually.

APEX and LDAP Authentication

1) Start Ldap Server.

2) Process=HTTP_server.

Go to the shared components of teh Apex Application .

Shared Components --->
authentication schema --->
Create--->
based on preconfig schems from the gallery ---->
LDAP Directory Credentials---->
select Login Page .



LDAP hosts .
LDAP Port .
DN name
( cn=%LDAP_USER%,l=owner , dc=orcale,dc=com)

Create scheme.
Aplly it on to a page.

APex installation in windows.

Orcale APEx installation is quite easy in windows.

Prerequisites one must have is

1) Oracel Database 10g (10.2.0.3) or higher version or Oracle XE.

all these databases comes with prerequisites which are required for Oracle APEX.


Steps :-
==========
1) Startup the database.

2) show parameter pfile

3) show Parameter shared_pool_size;


the u/p for teh above two commands are:-

SQL> show parameter pfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string E:\11G\PRODUCT\11.1.0\DB_1\DAT
ABASE\SPFILEORCL1.ORA
SQL> show parameter shared_pool_size;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size big integer 0


4)ALter system set shared_pool_size='100m' scope=spfile;

system altered .

5) if the system uses instilazation parameter set shared_pool_size='100mb'(atleast in initsid.ora).

6)shutdown

7)startup.


Browser Requirment :-

IE 7.0 / Firefox 3.5 / google chrome 4.0 / apple safar 4.0 .


Http server Requirements :-


when choosen the 10g and above all comes default.

1) Application Express Listener

2) Embedded PLSQL gateway .

3) Oracle Http Server & Modplsql.



Disk Space Requirement :-

1) 1 GB HD.

2) Oracle Apex tbspace 185 MB.

3) Sys table space 100 MB.

4) Each Additional Long uage takes (75 mb ) of space extra .



Orcale XML DB requirment

If using the preconfigures database then this is alreday installed and configured.


Oracle Text Requirment :-

- for online help option in Apex

---by default comes with dB.



Installation Steps :-


SQL > @connect sys as sysdba

sql>@apexins SYSAUX SYSAUX TEMP /i/

sql>@apxldimg.sql

connect to db

sql>@apxchpwd

To uninstall the apex

sql>@apxremov.sql


to configure teh apex

sql>apxconf.sql

to disable the port used by apex

sql>EXEC DBMS_XDB.SETHTTPPORT(0);

sql>EXEC DBMS_XDB.SETHTTPPORT(8082); enable the http port of apex xdb with the given port no .

Now go to the brwoser and type

http://127.0.0.1:8082/apex

login to apex using the admin password u set when exceuting the
@apxchpwd command

create the Workspace .
Assign the schema to it .

Create users and assign it to workspace.

Note the Workspace can be created and any schema can be assigned to it .

EX:- if u r trying to use the EBS then the schema of EBS can be assigned to it .



The Default Workspace with which the Admin connects in the admin login page is the internal workspace .

and the user is admin by default.



The users can be created as Workspace Admin , developer.


Regards,
Nandini Thakur.