{"id":417,"date":"2010-10-24T10:35:37","date_gmt":"2010-10-24T15:35:37","guid":{"rendered":"http:\/\/otac.isa-geek.net\/blog\/?p=417"},"modified":"2010-10-25T21:20:58","modified_gmt":"2010-10-26T02:20:58","slug":"journeying-into-oracleebs-12i-part-ii","status":"publish","type":"post","link":"https:\/\/otac.isa-geek.net\/blog\/?p=417","title":{"rendered":"Journeying into OracleEBS 12i \u00e2\u20ac\u201c Part II"},"content":{"rendered":"

Now that my 12i EBS virtual machine was initialized with Oracle Enterprise Linux, the next step was to stage the 12i installation media, and run the installation process from the 12i guest server.
\nI setup yum repositories to allow easy installation and update of software on the system. Debian-based environments (e.g., Ubuntu) would use apt-get for this.
\nFrom a terminal window, I did a sudo bash (to get a root shell):<\/p>\n

$ sudo bash
\n#
\n# cd \/etc\/yum.repos.d
\n# mv Oracle-Base.repo Oracle-Base.repo.disabled
\n# wget http:\/\/public-yum.oracle.com\/public-yum-el4.repo<\/strong><\/p>\n

I then installed the VirtualBox Linux additions, which would allow me to share files between the host and guest environments:
\n[root@jiraiya-oelinux VBOXADDITIONS_3.2.8_64453]# sh .\/VBoxLinuxAdditions-x86.run
\nVerifying archive integrity… All good.
\nUncompressing VirtualBox 3.2.8 Guest Additions for Linux……..
\nVirtualBox Guest Additions installer
\nBuilding the VirtualBox Guest Additions kernel modules
\nYour guest system does not seem to have sufficient OpenGL support to enable
\naccelerated 3D effects (this requires Linux 2.6.27 or later in the guest
\nsystem). This Guest Additions feature will be disabled.<\/strong><\/p>\n

Building the main Guest Additions module [ OK ]
\nBuilding the shared folder support module [ OK ]
\nDoing non-kernel setup of the Guest Additions [ OK ]
\nStarting the VirtualBox Guest Additions [ OK ]
\nInstalling the Window System drivers
\nInstalling X.Org 7.1 modules [ OK ]
\nSetting up the Window System to use the Guest Additions [ OK ]
\nYou may need to restart the hal service and the Window System (or just restart
\nthe guest system) to enable the Guest Additions.<\/strong><\/p>\n

Installing graphics libraries and desktop services componen[ OK ]<\/strong><\/p>\n

The next step was to share the location for the staging dir where the EBS 12i media was stored. I first created a permanent share in the VirtualBox folder list pointing to the source directory (\/media\/Terabank\/OAPPS_INSTALL):<\/p>\n

[oracle@jiraiya-oelinux ~]$ pwd
\n\/home\/oracle
\n[oracle@jiraiya-oelinux ~]$ mkdir mnt
\n[oracle@jiraiya-oelinux ~]$ cd mnt
\n[oracle@jiraiya-oelinux mnt]$ mkdir OAPPS_INSTALL
\n[oracle@jiraiya-oelinux mnt]$ pwd
\n\/home\/oracle\/mnt
\n[oracle@jiraiya-oelinux mnt]$ ls
\nOAPPS_INSTALL
\n[oracle@jiraiya-oelinux mnt]$ sudo mount -t vboxsf OAPPS_INSTALL \/home\/oracle\/mnt\/OAPPS_INSTALL
\n[oracle@jiraiya-oelinux mnt]$ ls
\n[oracle@jiraiya-oelinux mnt]$ ls OAPPS_INSTALL
\n11i 12i<\/strong><\/p>\n

I also added the entry to the \/etc\/fstab file to ensure the media’s availability on system startup:
\nOAPPS_INSTALL \/mnt\/OAPPS_INSTALL vboxsf defaults 0 0<\/strong>
\nI created the following short script to unzip and stage the 12i installation media from the eDelivery package zip files to the directory, it’s attached here: stage12i.zip<\/a>. Running this script, extracted the approximately 45 GB installation media into the target \/home\/oracle\/mnt\/OAPPS_INSTALL\/12i directory.
\nThe next step was to begin the install by running the rapidwiz command from the 12i staging directory:<\/p>\n

[oracle@jiraiya-oelinux 12i]$ pwd
\n\/home\/oracle\/mnt\/OAPPS_INSTALL\/12i
\n[oracle@jiraiya-oelinux 12i]$ cd stage12i
\n[oracle@jiraiya-oelinux stage12i]$ cd startCD\/Disk1\/rapidwiz\/
\n[oracle@jiraiya-oelinux rapidwiz]$ pwd
\n\/mnt\/OAPPS_INSTALL\/12i\/stage12i\/startCD\/Disk1\/rapidwiz
\n[oracle@jiraiya-oelinux rapidwiz]$ ls
\nadautostg.pl\u00c2\u00a0\u00c2\u00a0 driver\u00c2\u00a0 images\u00c2\u00a0 oui\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 RapidWiz.ini\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 template
\nbin\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 etc\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 jlib\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 rapidwiz\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 RapidWizVersion\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 unzip
\nClientWiz.cmd\u00c2\u00a0 File\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 jre\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 RapidWiz.cmd\u00c2\u00a0 RapidWizVersion.cmd
\n[oracle@jiraiya-oelinux rapidwiz]$ .\/rapidwiz<\/strong><\/p>\n

Rapid Install Wizard is validating your file system……
\n4 dvd labels found
\nRapid Install Wizard will now launch the Java Interface….<\/strong><\/p>\n\n\n\n\n\n
\n

\n

\n

\n

\n

\n

\n

\n

\"\"<\/a>

Oracle Applications Rapid Install Wizard<\/p><\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

After successful completion, the rapidwiz ran its Post-install checks. Errors were indicated for database startup, and HTTP connectivity.<\/p>\n\n\n\n
\n

\"\"<\/a>

Install Oracle Applications - Post-Install Checks<\/p><\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To resolve them, I had to start processes manually. Following, I detail the problem-resolution steps I went through, as well as the remaining actions to complete the Oracle EBS 12i installation.
\nThe First step was to start the database tier services. This was done by opening shell terminal,\u00c2\u00a0and changing to the database install directory: for my single-node install it was at \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0<\/strong>. I sourced the oracle env file in that directory (VIS_jiraiya-oelinux.env<\/strong>) to set all the necessary ORACLE environment vars:<\/p>\n

[oracle@jiraiya-oelinux mnt]$ . \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0<\/strong>\/VIS_jiraiya-oelinux.env<\/strong><\/strong><\/p>\n

then ran the addlnctl.sh script to start the database listener services:<\/p>\n

[oracle@jiraiya-oelinux mnt]$ \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/appsutil\/scripts\/VIS_jiraiya-oelinux\/<\/strong> <\/strong>addlnctl.sh<\/strong> start <\/strong>VIS<\/strong><\/p>\n

You are running addlnctl.sh version 120.1.12010000.2<\/strong><\/p>\n

Logfile: \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/appsutil\/log\/VIS_jiraiya-oelinux\/addlnctl.txt<\/strong><\/p>\n

Starting listener process VIS …<\/strong><\/p>\n

As seen above, this was successful. I then attempted to start the database instance, by running the addbctl.sh<\/strong> script in the appsutil\/scripts<\/strong> sub-directory under the $CONTEXT_NAME<\/strong> location ($CONTEXT_NAME is defined as <instance_name>_<hostname>):<\/p>\n

[oracle@jiraiya-oelinux mnt]$ \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/appsutil\/scripts\/VIS_jiraiya-oelinux\/addbctl.sh start
\n<\/strong><\/p>\n

which resulted in the error:<\/p>\n

sqlplus: error while loading shared libraries: \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/lib\/libsqlplus.so: cannot restore segment prot after reloc: Permission denied<\/strong><\/p>\n

and a\u00c2\u00a0 Troublesetbrowser popup in the OE Linux tray indicated a security infraction:<\/p>\n\n\n\n
\n

Summary:<\/strong> SELinux is preventing \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/bin\/sqlplus from loading \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/lib\/libsqlplus.so which requires text relocation.
\n Detailed Description:<\/strong> The \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/bin\/sqlplus application attempted to load \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/lib\/libsqlplus.so which requires text relocation.
\nThis is a potential security problem. Most libraries do not need this permission. Libraries are sometimes coded incorrectly and request this permission.
\nThe SELinux Memory Protection Tests web page explains how to remove this requirement. You can configure SELinux temporarily to allow \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/lib\/libsqlplus.so to use relocation as a workaround, until the library is fixed. Please file a bug reportagainst this package.
\nAllowing Access<\/strong>: If you trust \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/lib\/libsqlplus.so to run correctly, you can change the file context to textrel_shlib_t. The following command will allow this access: chcon -t textrel_shlib_t \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/lib\/libsqlplus.so<\/strong>.<\/td>\n		<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

After running the above command, I was able to successfully start the database processes:<\/p>\n

[oracle@jiraiya-oelinux mnt]$ <\/strong>sudo chcon -t textrel_shlib_t \/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/lib\/libsqlplus.so<\/strong><\/p>\n

and received the diagnostics below:
\n<\/strong><\/p>\n

You are running addbctl.sh version 120.1<\/strong><\/p>\n

Starting the database VIS …<\/strong><\/p>\n

SQL*Plus: Release 11.1.0.7.0 – Production on Fri Sep 24 21:45:41 2010<\/strong><\/p>\n

Copyright (c) 1982, 2008, Oracle.\u00c2\u00a0 All rights reserved.<\/strong><\/p>\n

Connected to an idle instance.
\nORACLE instance started.<\/strong><\/p>\n

Total System Global Area 1071333376 bytes
\nFixed Size\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 1318172 bytes
\nVariable Size\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 427819748 bytes
\nDatabase Buffers\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 629145600 bytes
\nRedo Buffers\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 13049856 bytes
\nDatabase mounted.<\/strong><\/p>\n

Database opened.
\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – Production
\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<\/strong><\/p>\n

addbctl.sh: exiting with status 0<\/strong><\/p>\n

Similar SELinux accesss errors were generated for other Oracle binaries, and were resolved by granting the permissions for the secure operation, using the command indicated in the troublesetbrowser. The alternative is to disable use of SELinux on installation of Oracle Enterprise Linux – obviously, this is not recommended for a production instance.<\/p>\n

Testing using tnsping now succeeded:<\/p>\n

[oracle@jiraiya-oelinux VIS_jiraiya-oelinux]$ tnsping VIS<\/strong><\/p>\n

TNS Ping Utility for Linux: Version 11.1.0.7.0 – Production on 24-SEP-2010 21:55:16<\/strong><\/p>\n

Copyright (c) 1997, 2008, Oracle.\u00c2\u00a0 All rights reserved.<\/strong><\/p>\n

Used parameter files:
\n\/d01\/oracle\/VIS\/db\/tech_st\/11.1.0\/network\/admin\/VIS_jiraiya-oelinux\/sqlnet_ifile.ora<\/strong><\/p>\n

Used TNSNAMES adapter to resolve the alias
\nAttempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=jiraiya-oelinux.otac.isa-geek.net)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=VIS) (INSTANCE_NAME=VIS)))
\nOK (580 msec)<\/strong><\/p>\n

The next step was to start the middle tier services using the CONTEXT_NAME of VIS_jiraiya-oelinux:<\/p>\n

The middle tier for my single-node 12i installation was at \/d01\/oracle\/VIS\/inst\/apps<\/strong>; the scripts to control the services were found under the $CONTEXT_NAME\/admin\/scripts directory. For my installation, I changed to the directory:<\/p>\n

[oracle@jiraiya-oelinux VIS_jiraiya-oelinux]$ <\/strong>cd \/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/admin\/scripts<\/strong><\/p>\n

and ran the command<\/p>\n

[oracle@jiraiya-oelinux VIS_jiraiya-oelinux]$ <\/strong>adstrtal.sh apps\/apps<\/strong><\/p>\n

to start up the middle-tier services.<\/p>\n

An error starting HTTP services was seen:<\/p>\n

Executing service control script:
\n\/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/admin\/scripts\/adapcctl.sh start
\nTimeout specified in context file: 100 second(s)<\/strong><\/p>\n

script returned:
\n****************************************************<\/strong><\/p>\n

You are running adapcctl.sh version 120.7.12010000.2<\/strong><\/p>\n

Starting OPMN managed Oracle HTTP Server (OHS) instance …<\/strong><\/p>\n

adapcctl.sh: exiting with status 204<\/strong><\/p>\n

adapcctl.sh: check the logfile \/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/log
\ns\/appl\/admin\/log\/adapcctl.txt for more information …<\/strong><\/p>\n

.end std out.<\/strong><\/p>\n

.end err out.<\/strong><\/p>\n

****************************************************<\/strong><\/p>\n

Viewing HTTP script log indicated an error with the Apache process:<\/p>\n

[oracle@jiraiya-oelinux VIS_jiraiya-oelinux]$<\/strong> more \/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/logs\/ora\/10.1.3\/opmn\/HTTP_Server~1.log<\/strong><\/p>\n

10\/10\/03 22:24:10 Start process
\n——–
\n\/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/ora\/10.1.3\/Apache\/Apache\/bin\/apachectl startssl: execing httpd
\n\/d01\/oracle\/VIS\/apps\/tech_st\/10.1.3\/Apache\/Apache\/bin\/httpd: error while loading
\nshared libraries: libdb.so.2: cannot open shared object file: No such file or directory<\/strong><\/p>\n

This indicated a missing library was causing Apache not to start.<\/p>\n

Some research indicated that Red Hat no longer supplies libdb1<\/code> as part of their libc<\/code>, so it was\u00c2\u00a0 neccessary to install it. I resolved this by creating a symbolic link to the latest version of the library, which was named differently:<\/p>\n

[oracle@jiraiya-oelinux VIS_jiraiya-oelinux]$ <\/strong>ln -s \/usr\/lib\/libgdbm.so.2.0.0 \/usr\/lib\/libdb.so.2<\/strong><\/p>\n

Then retried starting the HTTP service:<\/p>\n

[oracle@jiraiya-oelinux VIS_jiraiya-oelinux]$ <\/strong>\/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/admin\/scripts\/adapcctl.sh start<\/strong><\/p>\n

This successfully resolved the issue and allowed the Apache services to start correctly.<\/p>\n

I was then able to get the login page for the 12i instance, and login as sysadmin with the default password (sysadmin):<\/p>\n\n\n\n
\n

\n

\"\"<\/a>

Oracle Applications Home Page - 12i<\/p><\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

On trying to launch the forms, I received the following error:<\/p>\n

\"\"<\/a>

Forms Error - Forms Runtime - Web<\/p><\/div>\n

On viewing the application log in the \/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/logs\/ora\/10.1.3\/j2ee\/forms\/forms_default_group_1\/application.log file, the following error was seen on Forms startup:<\/p>\n

10\/10\/19 19:52:15.109 formsweb: FormsServlet init():
\nconfigFileName:\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 \/d01\/oracle\/VIS\/inst\/apps\/VIS_jiraiya-oelinux\/ora\/10.1.2\/forms\/server\/appsweb.cfg
\ntestMode:\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0\u00c2\u00a0 false
\n10\/10\/19 19:52:15.145 formsweb: 10.1.3.4.0 Started
\n10\/10\/19 20:57:25.101 formsweb: ListenerServlet init()
\n10\/10\/19 20:57:30.212 formsweb: Forms session <1> aborted: runtime process failed during startup with errors \/d01\/oracle\/VIS\/apps\/tech_st\/10.1.2\/bin\/frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory<\/strong>
\n <\/span><\/p>\n

This indicated that the libXm.so.2 library was not found in the library path. Some investigation indicated that this library is provided in the openmotif library which has a dependency on the libXp library. I downloaded\u00c2\u00a0 rpms for both from here<\/a> (openmotif) and here<\/a> (libXP), and installed libXp first, followed by openmotif using the graphical software installer (rpm would work as well). After signing out of the 12i instance, and attempting to access forms once again, the issue was resolved:<\/p>\n\n\n\n
\n

\n

\"\"<\/a>

Oracle Applications<\/p><\/div><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Note the Java runtime security prompt which must be accepted to allow the forms runtime to install in the browser (in this case, Firefox 3.6 on OE Linux).<\/p>\n

This concluded the base installation of Oracle 12i on Enterprise Linux, however, in a real-world scenario, there would be a number of security and functionality patches to be applied, as well as configuration for workflow, concurrent manager and printer services. I will detail some of my further activities evaluating this product in future postings.<\/p>\n","protected":false},"excerpt":{"rendered":"

Now that my 12i EBS virtual machine was initialized with Oracle Enterprise Linux, the next step was to stage the 12i installation media, and run the installation process from the 12i guest server. I setup yum repositories to allow easy installation and update of software on the system. Debian-based environments (e.g., Ubuntu) would use apt-get […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,37,60,57],"tags":[],"class_list":["post-417","post","type-post","status-publish","format-standard","hentry","category-erp","category-ebs","category-oracle-enterprise-linux","category-oracle-virtualbox"],"_links":{"self":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=417"}],"version-history":[{"count":0,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/417\/revisions"}],"wp:attachment":[{"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/otac.isa-geek.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}