Showing posts with label ORacle application custom top creation in 11i. Show all posts
Showing posts with label ORacle application custom top creation in 11i. Show all posts

Thursday, October 21, 2010

Custom Top - 1



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.