Custom Top - 1

Custom Top in Oracle Application - Creation & Registering

STEP 1

Created the directory structure for your custom application files under $APPL_TOP/abdul

$cd $APPL_TOP

$ mkdir abdul

$ mkdir abdul/11.5.0

$ mkdir abdul/11.5.0/admin

$ mkdir abdul/11.5.0/admin/sql

$ mkdir abdul/11.5.0/admin/odf

$ mkdir abdul/11.5.0/sql

$ mkdir abdul/11.5.0/bin

$ mkdir abdul/11.5.0/reports

$ mkdir abdul/11.5.0/reports/US

$ mkdir abdul/11.5.0/forms

$ mkdir abdul/11.5.0/forms/US

$ mkdir abdul/11.5.0/log

$ mkdir abdul/11.5.0/out

$ mkdir abdul/11.5.0/$APPLLIB

$ mkdir abdul/11.5.0/$APPLOUT

STEP 2

Added entry ABDUL_TOP=/ebiz/testappl/testappl/abdul in Enviornment file custom_TEST_vmware.env

ABDUL_TOP=/ebiz/testappl/testappl/abdul

export ABDUL_TOP

STEP 3

Then Run "custom_TEST_vmware.env",

./custom_TEST_vmware.env

STEP 4

Then Run "APPSORA.env"

./APPSORA.env

STEP 5

Finally Run the Oracle Manager's bash profile,

.bash_profile

STEP 6

Now Check for "ABDUL" top

$cd $ABDUL_TOP

$pwd

/ebiz/testappl/testappl/abdul

STEP 7

Create datafile (.dbf) from the new customized top in database

Connect to database manager

connect into sys user.

create tablespace and datafile for ABDUL_TOP

STEP 8

SQL> create tablespace abdul datafile '/ebiz/testora/testdata/abduldbf' size 10M;

Tablespace created.

STEP 9

Create Schema (USER) and Grant connect,resource to the USER.

SQL> create user abdul identified by abdul default tablespace abdul temporary tablespace temp quota unlimited on abdul;

User created.

STEP 10

SQL> grant connect,resource to abdul;

Grant succeeded.