Here we will see how to Install Standalone Oracle Application Express on top of R12.
Hardware requirement : one node for R12 and another for HTMLDB
Software Requirement :
1. EBSO Dump to Setup R12 Instance
2. Database Companion CD which hold the HTMLDB
Installation Steps:
1. Set R12 Instance and make sure all the components are working fine.
2. Create a Tablespace for HTMLDB on the R12 Database.
SQL> create tablespace htmldb datafile '/home1/orr12/ebsor12/db/apps_st/data/htmldb_01.dbf'
2 size 100m
3 autoextend on
4 next 50m
5 maxsize 2048m
6 extent management local;
Tablespace created.
SQL>
3. Create a User on the same host as apexpress and login in as apexpress
4. Start the Installer from the Companian CD
5. Specify the Inventory Directory and Credentials and click Next
6. Select the Product to Install as Oracle HTMLDB and click Next
7. Select the Installation Type as "Oracle HTMLDB and HTTP Sever" , click Next
8. Specify the Oracle Home
9. Specify HTMLDB Database Details
Hostname : r12lab01.r12.com
Port : 1521
Database Service Name : EBSOR12
Tablespace Name : HTMLDB
SYS Password : sys_password
HTMLDB Password : htmldb_password
Confirm HTMLDB Password : htmldb_password
10. Rest RunInstaller will take care
11. Run orainstRoot.sh and root.sh
12. Verify the Log File for the HTMLDB Installation and make sure you have the following;
Log File : $ORACLE_HOME/cfgtoollogs/htmldbca/install_xxxxxxxxxxxxx.log
Thank you for installing Oracle HTML DB.
Oracle HTML DB is installed in the FLOWS_010600 schema.
The structure of the link to the HTML DB service adminstration is as follows:
http://r12htmldb.r12.com:7777/pls/htmldb/htmldb_admin
The structure of the link to the HTML DB development interface is as follows:
http://r12htmldb.r12.com:7777/pls/htmldb
timing for: Upgrade
Elapsed: 00:00:00.09
timing for: Complete Installation
Elapsed: 00:14:04.13
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining option
Oracle Application Express on Top of R12 Database is done.
The voice in my head may not be real , but they have some good ideas !!!
Fail Fast, Fail Forward, Fail Often, Fail Better , Standup Every Time
Every problem has at least one solution. Only some solutions are harder to find.
Thursday, June 7, 2007
Popular Posts
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_...
-
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
-
As a green field expert in data science, you would be responsible for designing and implementing data science projects from scratch. This i...
-
PRVG-2031 : Owner of file "/u01/app/oracle/diag/crs/rac01/crs/lck" did not match the expected value on node "HOST1". [Ex...
-
Suddenly all production reports in BI Publisher failed with message " ORA-01017: invalid username/password; logon denied" The da...
-
If you are an EBS administrator the first thing some asks you to do a health check of an environment , you return to him with a Request ID o...
-
EBS 12.2 ADOP Cycle Errors During Validation Cannot open XML file for load ADOP cycle will have validation errors in some cases. *****...
-
ADOP patching on a downtime mode with [ERROR] Patch service is not exist or running Please note , if you get ADOP issues on PROD ple...
-
Let me start telling a story , "Once upon a time there lived a great ♚EBS 12.2 instance , it was very kind to the DBAs and one fine day...