Sunday, 11 April 2010

Accessing windows 7 files from xp (sharing files from windows 7 to xp)

On windows 7 make sure computers are on the same group
Go to network and sharing centre
Click on Change advanced sharing settings (its on the left pane)

Under File and Printer Sharing
Turn on File and Printer Sharing
Under password protected sharing (for security)
Turn on Password protected sharing
if you select the other option, people can access without giving a user name and password, otherwise you have to provide user name and password)

Friday, 2 April 2010

Apex 3.2 Installation

Install http server (it’s can be found on 10g companion cd)

Dwnload and unzip

E:\oracle\apps\apex

Change your working directory to apex.

E:> cd \oracle\apps\apex

Create a table space called apex for oracle apex

Checking the shared_pool_size of the Target Database

SHOW PARAMETER PFILE;

SHOW PARAMETER SHARED_POOL_SIZE

ALTER SYSTEM SET SHARED_POOL_SIZE='100M' SCOPE=spfile;

SHUTDOWN

STARTUP

Oracle XML DB Requirement, Oracle Text Requirement

Oracle XML DB must be installed in the Oracle database that you want to use. If you

are using a preconfigured database created either during an installation or by

Database Configuration Assistant (DBCA), Oracle XML DB is already installed and

Configured.

Select comp_name “component” from dba_registry;

PL/SQL Web Toolkit

Oracle Application Express requires the PL/SQL Web Toolkit version 10.1.2.0.6 or

later.

Checking for PL/SQL Web Toolkit

Select owa_util.get_version from dual;

if current version is below this , install as follow

Installing the PL/SQL Web Toolkit 10.1.2.0.6

--------------------------------------------

1) Stop all applications using the database

2) Navigate to the directory apex/owa

3) Connect via SQL*Plus as the database user SYS

4) Run the PL/SQL Web Toolkit installation script by issuing: @owainst.sql

5) Review the output displayed from owainst.sql and ensure no errors were encountered.

6) Confirm the PL/SQL Web Toolkit version is 10.1.2.0.6 or greater by connecting to the database

select owa_util.get_version from dual;

7) Run the utlrp.sql script from the Oracle Database home to recompile all invalid PL/SQL

packages

To run utlrp.sql, issue: @?/rdbms/admin/utlrp.sql

Start SQL*Plus and connect to the database where Oracle Application Express is

installed as SYS specifying the SYSDBA role. For example:

Now we are going to run apex installation script

If you are not on apex location yet change directory to apex

E:> cd \oracle\apps\apex

Connect as sys and run the script as follows

@apexins apex apex TEMP /i/

tablespace_apex is the name of the tablespace for the Oracle

Application Express application user.

tablespace_files is the name of the tablespace for the Oracle

Application Express files user.

tablespace_temp is the name of the temporary tablespace.

images is the virtual directory for Oracle Application Express images. To

support future Oracle Application Express upgrades, define the virtual

image directory as /i/.

Change the Password for the ADMIN Account

1. Change your working directory to the apex directory where you unzipped the

installation software.

On Windows:

SYSTEM_DRIVE:\ sqlplus /nolog

SQL> CONNECT SYS as SYSDBA

Enter password: SYS_password

3. Run apxchpwd.sql. For example:

@apxchpwd

When prompted enter a password for the ADMIN account.

Configure Oracle HTTP Server Distributed with Oracle Database Oracle Application Server 10g

Unlocking the APEX_PUBLIC_USER Account

The APEX_PUBLIC_USER account is locked at the end of a new installation of Oracle

Application Express. You must unlock this account before configuring the database

access descriptor (DAD) in a new installation.

Connect as sysdba

ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password

Where new_password is the new password you are setting for APEX_PUBLIC_

USER. You will use this password when creating the DAD in the sections that

follow.

Copy the Images Directory

Copy E:\oracle\apps\apex\images e:\oracle\apps\http_server\apache\

Editing the dads.conf File If this is a new installation of Oracle Application Express, you

must edit the dads.conf file. The dads.conf file contains the information about the

DAD to access Oracle Application Express.

Go to the dads file location

http_home\apache\mod_plsql

open dads.conf with any text editor

replace ORACLE_HTTPSERVER_HOME, host, port,

service_name, and apex_public_user_password with values appropriate

for your environment.

Alias /i/ "ORACLE_HTTPSERVER_HOME/Apache/images/"

AddType text/xml xbl

AddType text/x-component htc

Order deny,allow

PlsqlDocumentPath docs

AllowOverride None

PlsqlDocumentProcedure wwv_flow_file_mgr.process_download

PlsqlDatabaseConnectString host:port:service_name ServiceNameFormat

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

PlsqlAuthenticationMode Basic

SetHandler pls_handler

PlsqlDocumentTablename wwv_flow_file_objects$

PlsqlDatabaseUsername APEX_PUBLIC_USER

PlsqlDefaultPage apex

PlsqlDatabasePassword apex_public_user_password

PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize

Allow from all

Locate the line containing PlsqlNLSLanguage set as follows

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

Ex:

## edited by yoonus on 7 Feb 2009

Alias /i/ "/orasoft/http_server/Apache/images/"

AddType text/xml xbl

AddType text/x-component htc

Order deny,allow

PlsqlDocumentPath docs

AllowOverride None

PlsqlDocumentProcedure wwv_flow_file_mgr.process_downloadd

PlsqlDatabaseConnectString localhost:1521:orcl ServiceNameFormat

PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8

PlsqlAuthenticationMode Basic

SetHandler pls_handler

PlsqlDocumentTablename wwv_flow_file_objects$

PlsqlDatabaseUsername APEX_PUBLIC_USER

PlsqlDefaultPage apex

PlsqlDatabasePassword jameela

PlsqlRequestValidationFunction wwv_flow_epg_include_modules.authorize

Allow from all

After setting up save this configuration, stop http server and restart

http://hostname:7777/pls/apex

defualt port for httpserver if you changed it give the port accordingly