Get a Free iPhone 4 from Xpango - click here

Tuesday, January 4, 2011

Steps to install Apex 4 on linux

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. Oracle APEX is a fully supported, no cost option of the Oracle database.

Browser Requirement:
To view or develop Oracle Application Express applications, Web browsers must
support Java Script and the HTML 4.0 and CSS 1.0 standards. The following browsers meet this requirement:
1)Microsoft Internet Explorer 6.0 or later version
2)Firefox 1.0 or later

HTTP Server Requirements:
In order to run, Oracle Application Express must have access to one of the following:
1)Embedded PL/SQL gateway
2)Oracle HTTP Server and mod_plsql
Oracle XML DB HTTP Server with the embedded PL/SQL gateway installs with
Oracle Database 11g. It provides the database with a Web server and also the necessary infrastructure to create dynamic applications.

Oracle Application Express requires the shared_pool_size of the target database to be at least 100 MB.

Disk Space Requirement:
Oracle Application Express disk space requirements are as follows:
1)Free space for Oracle Application Express software files on the file system: 450 MB
2)Free space in Oracle Application Express tablespace: 100MB
3)Free space in SYSTEM tablespace: 85 MB
Free space in Oracle Application Express tablespace for each additional language
(other than English) installed: 30MB

Although you can install APEX into an existing tablespace, I recommend creating a new tablespace.
This will hold all the APEX objects and also any files uploaded to the database.
To create a new tablespace called APEX run the following:
CREATE TABLESPACE APEX DATAFILE "<filename and path>"
SIZE 200M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;

Installing the Oracle Application Express Software:
To install Oracle Application Express release 4.0.1:
1.Download the file apex_4.0.1.zip from the Oracle Application Express download
page. See:
http://www.oracle.com/technology/products/database/application_
express/download.html
2.Unzip apex_4.0.1.zip as follows, preserving directory names:
$ Unzip apex_4.0.1.zip
3. Change your working directory to apex.
$ cd apex
4. Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:

$ sqlplus sys/SYS_password as sysdba
Run apexins.sql passing the following five arguments in the order shown:

@apexins password tablespace_apex tablespace_files tablespace_temp images

eg: SQL>@apexins foo APEX APEX TEMP /i/

Configure Embedded PL/SQL Gateway:
To configure the embedded PL/SQL gateway:
1. Change your working directory to the directory where you
unzipped the Application Express software.
2. Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:
$ sqlplus sys/password as sysdba
$ @apex_epg_config
eg:After unzipped you have directiory structure like: /home/apex
@apex_epg_config /home
The next step is to upload the images.
Run apxldimg.sql passing the file system path to the base directory where the Oracle Application Express software was unzipped as shown in the following example:
SQL>@apxldimg.sql /home

You need to unlock few of the schema that is related to Apex application. Now unlock the schema as :
SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;
SQL > ALTER USER XDB ACCOUNT UNLOCK;
SQL > ALTER USER APEX_040000 ACCOUNT UNLOCK;
SQL > ALTER USER FLOWS_FILES ACCOUNT UNLOCK;
SQL > ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

Execute the apxconf.sql script and type the below command:

SQL>@apxconf.sql

And press enter...you will be asked to assign a password for admin : type your desired password  And press enter.
Then you will be asked to enter password for XDB HTTP port : type your desired port . here you can keep 8080 or can change like 7778.

You can verify the port no by using th following command:
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;

You can start XML DB as follows:
Start SQL*Plus and connect the database where Oracle Application Express is
installed as SYS. For example:
$ sqlplus sys/SYS_password as sysdba

Enter a statement similar to the following:
EXEC DBMS_XDB.SETHTTPPORT(port);

eg:SQL>EXEC DBMS_XDB.SETHTTPPORT(8080);

Open a browser and type the address
eg:http://localhost:8080




You will need to log in using the workspace "internal", username "admin" and the password you specified during installation.

In case you are not able to see images and logo follow this work around:
Execute reset_image_prefix script located in utilities directory.

Change your working directory to <base directory>/apex/utilities

$ sqlplus conn sys/password as sysdba

SQL>@reset_image_prefix.sql /i/

Friday, November 26, 2010

How to install Samba on linux with Screenshots

Samba allows linux computers to share files and printers across a network connection. By using its SMB protocol, your linux box can appear in Windows Network Neighborhood or My Network Places just like any other windows machine. You can share files this way, as well as printers. By using samba on my home network, for example, my Windows machines have access to a printer directly hooked up to my Linux box, and my Linux box has access to a printer directly hooked up to one of my Windows machines. In addition, everyone can access everyone else's shared files. You can see how samba can be very useful if you have a network of both Windows as well as Linux machines. 
Samba configurations are slightly different depending on the distribution you're using.This article explain steps on fedora.
  1. Install Samba
$sudo yum install samba samba-client system-config-samba
           enter your root password.

2. Adding Users.
You will need to ensure that people also have a login to the SAMBA server to do their work. Logins should be provided on an as needed basis. Obviously, in most cases the users accessing the SAMBA server will be a subset of the total users on the Windows business network.
Create user logins with the Gnome User Manager tool in Fedora. You can find this from the main menu by choosing System Settings, then Users & Groups. The command for this is: system-config-users.
                          Goto System->Administration->samba

                           Under the Preference menu item choose Samba Users

In this window you must Add at least one user who will have access to the SAMBA Server. Notice that only user accounts you created above should be added to this listing.

3. Configure Sharing
You can configure samba using /etc/samba.conf file.
We will use GUI tool installed by package “system-config-samba”.
                                   Goto System->administration->samba
                                   Goto preference->server setting


Enter Workgroup name exactly the same as in Windows OS.
In this case its ‘workgroup”. Your situation may be different.

Under this same window, click on the Security tab. It comes by default with the appropriate settings for a basic SAMBA Server. The Authentication mode should be User. You would need to change this only if you plan to allow logins based on the Microsoft ADS.



Under the SAMBA Server Configuration window, you must create at least one SAMBA share directory.
                                Press the " +" button and then the Browse button




Now choose a folder you wish to make available to SAMBA users. Be careful, some folders have permissions settings that do not allow sharing. Now be sure to select the Read/Write option to allow peoplefull access.Don't press OK yet!
In the same window, select the second tab labeled Access. From here choose the first option labeled Only allow access to specific users and select the users you wish to give access to this specific SAMBA shared folder. Press OK when finished.



4. Start Samba Server
SMB daemon and other core services are usually NOT started by default. You will need to change this so that your SMB daemon is now started.Using the GUI from the main menu, go to System Settings, then Server Settings, then choose Services. You can also get to this using the command: system-config-services.


Select SMB and press start.Save the configuration and exit.
Also make sure your firewall settings is configured to allow inbound request for Samba server.Goto to firewall settings and choose samba as trusted service.

Before moving towards windows note the IP address of your network .
Issue the following command :
$ ifconfig
It will show you the details of your networks from LAN,WLAN etc

5. Access Samba server from windows
In windows, start->run
Type the IP address of your linux system hosting the samba server.

eg: \\192.154.54.1

Will ask you for samba username and password.
You can now access shared folders in windows.