Showing posts with label jpiwowar. Show all posts
Showing posts with label jpiwowar. Show all posts

Tuesday, September 13, 2011

Pythian Acquires "Dude Who Gets Stuff Done"

Pythian, the world's leading remote DBA service company, has announced the (non-hostile) acquisition of John Piwowar.

Wait, Pythian didn't announce it, officially anyway...



Source



Source

Maybe it was John?

...Starting today, I begin the "on-boarding" process at Pythian, as a member of one of their ERP teams.
In a way, it feels as much like starting school as it does a new job. This move represents my biggest career challenge to date, and I
look forward to learning a ton (and contributing a ton) in the company of a lot of smart, talented people. Since I'm going to be packing
my brain full of new things over the next 3 weeks, I expect that the only blog activity here will be from pre-scheduled posts, drafts that
I'd been putting off finishing until recently. Once I'm up to speed on the new system, you'll hopefully be hearing more from me on the
Pythian blog!

I think it's obvious from John's post how excited he is. I am excited for him too. John's an awesome dude, sherpa (for me), protector (of me, from myself), and DBA.

Find John in the following locations:

- Twitter
- Blog
- LinkedIn
- oraclenerd

OK, this didn't turn out as funny as I had intended, whatever.

Great move for both parties. Can't wait to see what John does with the vast resources available to him now.

Thursday, April 1, 2010

March Madness

No, it's not about basketball. I can't seem to get into this year, despite all the upsets (from what I hear).

This month, oraclenerd passed the 10,000 visitor mark...that's just amazing to me. Thank you.

Almost hit 16,000 page views as well. 10 shy if you're curious. Again, awesome.

Like last month, I'm posting the top 10 list based on views for March.

PageViews
Learning OBIEE763
EBS Install Guide - Part 1 by John Piwowar573
DBMS_CRYPTO: Example381
The Case for the Bit Bucket by Michael Cohen352
APEX: Install 3.2.1 on 11gR2331
EBS Install Guide - Part 2330
OBIEE: How to Migrate Your RPD238
ORA-08177 can't serialize access for this transaction236
OBIEE: Install on OEL 5.4 225
BULK COLLECT and FORALL222
EBS Install Guide - Part 3210

On a related note, John cracked the top 10, all time, in pages viewed on oraclenerd. His post has been up for just under 4 months and I've been at this for almost 31 months. Maybe if I had John post more often I could actually make (more) money here. As it stands, I owe him about $0.53 USD.

If you want to take a crack at John, I'm still accepting guest posts. Had 2 this month, both on the database as a bucket meme. Michael O'Neill had extended comments in Everything is a Bit Bucket and Michael Cohen took the other side...as usual.

Sunday, February 28, 2010

Random Things: Volume#16

EBS Challenge
John Piwowar wrote the first part of the EBS Installation Guide back in December, since then, it's become a runaway success. I hadn't realized how so until recently when I was looking at Google Analytics and it came it at number 19, for all time. Now it's up to 13 and with the addition of it to the front page, it should only go up faster.



I've never had a post that was this popular so I thought it fitting that John should get the recognition that he deserves. If you decide to take part and then write it up, let me know and I'll link you up to The EBS Challengepage. I think there are 4 people that have completed it so far. I'll even give you space here if you don't have your own blog.

Travel
Got the best color car ever this week.



OBI EE
For some reason my original, Learning Oracle Business Intelligence (OBIEE) post, has been near the top of the charts for multiple search phrases.
So I did what any sane person would do, I updated it with some new information. Not really sure if it's new, but it's got more. If people are finding it, I might as well update it as often as possible.

Monday, January 4, 2010

EBS Install Guide - Part 4

By John Piwowar [ blog | twitter ]

This is the fourth and final post in the "Installing E-Business Suite" series, where we'll take a quick look at the GUI. As with the command line interface, going into deep detail would take more time and space than is practical, but I'll try to present some of the high points. I'll close with a final list of useful references for EBS administrators, and then return you to you regularly scheduled oraclenerd programming. Thanks again, Chet!

Part 1 --> Part 2 --> Part 3 --> Part 4

The Navigator
After logging in to Oracle Applications (you remember that from the end of Part 2, right?), you'll be presented with the Navigator. Depending on the responsibilities granted to your user, the length of the list in the left column of the Navigator will vary. When connected as SYSADMIN, you'll most often be interested in the "System Administrator" and "System Administration" responsibilities. Clicking a responsibility will populate the center column of the Navigator with the functions assigned to that responsibility, and clicking one of those functions will take you to that function, either in the HTML interface or the Forms interface. As shown in the screenshot below, the small icons next to the links indicate whether a link will launch Oracle Forms or just take you to another HTML page. To the right of the two Navigator columns is the list of Favorites, which can be especially handy if you've been granted a lot of responsibilities and can't be bothered to remember which responsibility provides your most frequently-used functions.



The SYSADMIN user offers access to a wide variety of responsibilities and functions, particularly in the Vision instance. As you might expect, SYSADMIN also has "superpowers:" some responsibilities offer expanded functionality only to the SYSADMIN user. If you're interested in seeing what a more common, but still fairly powerful, user looks like, you can log in as one of the following users: MFG, OPERATIONS, SERVICES, MRC, or HRMS. These users are seeded in the Vision instance with the password 'welcome'.

The forms interface
EBS has been evolving to use a more HTML- and Javascript-based UI, but a large proportion of the end-user functionality (and some crucial administrative functions) are presented via Oracle Forms. When you click on a link for a function that is handled by forms, Java will launch the Forms interface for you. It really, really helps in this case to be running on a supported Java+Browser+Operating System combination (Linux users take note: Oracle does not currently plan to certify Linux desktop OS versions to run EBS clients). In addition, make sure that you've either disabled your browser's popup blockers, or added your EBS server to your popup blocker's whitelist, otherwise Forms may fail to launch and you might mistakenly conclude that they're broken. Here's a quick demo of the start of the Forms interface, so you know what to expect. I chose the "System Profile Options" form for convenience, not because it's super-important...though it's certainly a normal amount of important:

Click appropriate link in the Navigator (or, as in this case, the Favorites list...yay, laziness!). A new browser window or tab will open, displaying a Forms servlet launcher. Depending on your browser's security settings, you may be asked a few questions about whether you want your EBS server to be allowed to communicate with your browser. I've found Safari to be particularly persnickety about this.



One of the browser windows (or tabs) that will open during the launch of Forms contains a "Do not close this window" warning. Hint: they're not kidding. Make sure it stays open for the duration of your Forms session.



After a bit of waiting and spawning those extra browser windows, you should get a view of the Forms interface. It'll probably try to take over all of your screen real estate (at least it does on my laptop), so it'll be impossible to miss:



A few things to note:
  • The Forms function you selected may be specific enough to require a series of sub-forms, in which case you'll see parent forms open underneath.
  • As with the web interface, there's a Navigator form, with all of the functions available to the current responsibility. If you select the Navigator form, the little "top hat" icon will become active, and you can switch to a new responsibility.
  • You can bask in the warm, comfortable nostalgia of desktop-app-like "File, Edit, Tools, etc" menu system.
  • If you use the Navigator to select a function that is HTML-based, you'll be popped back out into your browser. It might come as a surprise the first few times, but you'll get used to it. ;-)
  • If you close the Navigator window, you'll be asked to confirm that you want to exit Oracle Applications
Diagnostics
Oracle makes it easy to collect a lot of diagnostic information about the various EBS applications modules and tech stack components. A lot of the diagnostic test output can be packaged up and shipped to Oracle Support to support SR resolution. I've also been able to resolve issues on my own using Diagnostics that I might otherwise have had to open an SR to resolve, which makes the Diagnostics a clear timesaver. Access Diagnostics from either the "Application Diagnostics" responsibility or the "Diagnostics" link at the top of the Oracle Applications home page. Using the responsibility is a bit more straightforward.



I'll spare you a long, screenshot-laden walkthrough of Diagnostics, but you'll find that there are over 280 applications to choose from, each with its own set of tests. The applications AD (Applications DBA), FND (Application Object Library), and SYSTEM_TEST (HTML platform) are probably the most immediately interesting to you at this point. For fun, run the EBusinessSecurity test group under FND and see what holes are left open in a default system. :-)

OAM: Oracle Applications Manager (OAM)
I'm sure I'll lose a lot of "street cred," assuming I've ever had any, for extolling the virtues of a GUI-and-dashboard-based administration interface, but Oracle Applications Manager is pretty nifty. Come to think of it, maybe I'll lose cred just for using a word like "nifty." Oh well. OAM is available to users granted the System Administrator or System Administration responsibility. Access individual OAM functions from those responsibilities, or start at the Dashboard to begin exploring its functionality.



OAM can quickly display the overall health of your system, lets you change some Apps configuration options, provides facilities to report on applied EBS patches and analyze new ones, manage the various moving parts that comprise the Workflow system, and much more. Click around for a bit; they've packed a lot in there:



I should note that OAM and the Diagnostics utilities discussed above are part of the base Oracle Applications system, included as part of standard EBS licensing. OAM should not be confused with the Oracle Applications Management Pack for Grid Control, which is a separately-licensed product.

Standing on the shoulders of giants
Okay, that's a wrap! Thanks for sticking through to the end; I'll leave you with one last list of reference material. If you want to dig further into learning about EBS, here are some useful resources and blogs. I'm bound to miss a lot here, but you won't go very wrong starting with this list:
  • First and foremost, if you aren't following Steven Chan's blog, you are doing yourself a huge disservice. Steven and his blogging team are are all heavily involved in the Applications Technology and Applications Technology Integration groups at Oracle. They will keep you up to date on the evolution of the Oracle Applications tech stack "as it happens," with certification announcements, discussions of advanced features and configurations, and pointers to interesting EBS whitepapers. If you've ever tried to navigate the labyrinth of Oracle's certification matrix, you'll recognize that Steven's list of certifications for the EBS tech stack components alone is worth a visit to his blog. Steven also maintains a list of Apps-related blogs, both within Oracle and in the broader community.
  • The OTN EBS forums are an invaluable resource for getting answers to your EBS questions. Most of the time, it seems like Oracle Ace Hussein Sawwan is holding the entire show together with his encyclopedic knowledge and crazy My Oracle Support skills. There are a lot of very helpful regulars there to pick up the slack when Hussein steps out for dinner, too (I'm not convinced that he sleeps). The EBS on Linux, EBS R12 Install/Upgrade, and EBS Technology General Discussion forums are a good place to start.
  • Atul Kumar's Online Apps DBA blog covers a wide variety of topics related to the technical side of Oracle Applications, including the integration of a wide variety of Oracle products with EBS, and more "real-world" deployment scenarios than this installation guide provides. It seems like there isn't an Oracle product this dude hasn't installed; it's pretty impressive.
  • Eddie Awad's famous OraNA service has an "Applications and Apps Technology" subcategory, and you'll see some interesting tidbits come through there.
  • Ben Prusinski, Oracle Ace and RAC expert, has recently ventured into the realm of Apps DBA work, and many of his recent blog posts have covered R12-related topics.

Sunday, January 3, 2010

2009 - In Review

Crazy year...but that seems to be the norm. Is crazy my normal? I wouldn't be suprised.

Numbers
  • 289 - Number of posts this year.
    • 37 - September had the highest number of posts.
    • 18 - February - lowest
    • 24 - Average posts per month
    • 76 - Number of days not covered by a post. In reality though, there were numerous occasions where I posted 2 or more times.
  • 439 - Number of posts it took to get to the magical $100 mark with Google AdSense. I don't even want to do the math on that. BTW, I reached the $100 mark on December 28, 2009. Here's to perseverance.
  • 94,998 - Pageviews according to Google Analytics
  • 66,313 - Visits according to Google Analytics
  • 465,963 - Page Requests according to my web server (GoDaddy)
  • 1,015,934 - Server Requests according to my web server
I'm not sure what the disparity is between the web server stats and Google Analytics. I tend to put more faith into Google Analytics though. (Of course seeing that 1 million is cool, even if it is only server requests).

Pretty Pictures
Here's a screenshot from my Google Analytics page...in July, I hit 5,000 Visits for the first time

july analytics

I'm still not real clear what happened here

wtf?

That was a 2,000 visit jump. I originally thought it had to do with my shameless pining to go to OOW 09...but that was late August, early September.

And to give you an idea of the progression since I started

wow!

The 2,000 hit jump is much more dramatic in that picture.

Guest Authors

Back in July (well, technically in May), I opened up the blog to guest authors. Mainly I wanted to give people of all experiences an opportunity to try out their writing skills...to see if they would like it. I didn't exclude established bloggers though. Of the 5 who participated, 4 already had blogs and 1 had been considering it.
I know Ted's got one (almost) ready for posting and I'm trying to talk Jeff Haynes and Brad Tumy into doing guest spots as well.

Thanks to all of you who participated...I can't say that enough.

So I hope you enjoyed 2009 as much as I did. I'm not sure how long I can keep this up...it's a lot of work. I think it's worth it though.

Sunday, December 20, 2009

EBS Install Guide - Part 3

By John Piwowar [ blog | twitter ]
This is the third post in my "Installing E-Business Suite" series. Now that your Vision installation is (hopefully) complete, it's time to start exploring the system a bit. Thanks again to Chet for the opportunity to share here, and for his patience as I took longer than was strictly necessary to finish this installment.

Part 1 --> Part 2 --> Part 3 --> Part 4

It's impossible to provide a comprehensive overview of the various command-line utilities used to manage the E-Business Suite in the space of one (or even a few blog posts, but in this post I'll show you how to start and stop the services, and point you to a few references where you can learn more, if you're into that sort of thing. I don't ever claim perfect memory, but you can probably assume that anything you later discover to be missing was omitted to save space, not because I forgot about it.

Stopping EBS services
It's a good idea to shut down the EBS database ASAP after installation to take a full backup. Before you can shut down the database, you need to shut down the applications tier, or your system will probably become cranky. The "shut down everything" script for the apps tier is called adstpall.sh, and it calls scripts to stop individual components and bring down the system in a (usually) graceful manner. Run adstpall.sh as the applvis user:

[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME/adstpall.sh

You are running adstpall.sh version 120.10

Enter the APPS username: apps
Enter the APPS password:
The logfile for this session is located at
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adstpall.log
Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/jtffmctl.sh stop
script returned:
****************************************************
You are running jtffmctl.sh version 120.3
Shutting down Fulfillment Server for R12VIS on port 9355 ...
jtffmctl.sh: exiting with status 0

.end std out.
.end err out.
****************************************************

Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adcmctl.sh stop
script returned:
****************************************************
You are running adcmctl.sh version 120.17.12010000.3
Shutting down concurrent managers for R12VIS ...
ORACLE Password:
Submitted request 5798328 for CONCURRENT FND SHUTDOWN

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adcmctl.txt
for more information ...

.end std out.
.end err out.
****************************************************

Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adoafmctl.sh stop
script returned:
****************************************************
ERROR : Timed out( 100000 ): Interrupted Exception
You are running adoafmctl.sh version 120.8
Stopping OPMN managed OAFM OC4J instance ...
****************************************************

Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adformsctl.sh stop
script returned:
****************************************************
ERROR : Timed out( 100000 ): Interrupted Exception
You are running adformsctl.sh version 120.16
Stopping OPMN managed FORMS OC4J instance ...
****************************************************

Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adoacorectl.sh stop
script returned:
****************************************************
ERROR : Timed out( 100000 ): Interrupted Exception
You are running adoacorectl.sh version 120.13
Stopping OPMN managed OACORE OC4J instance ...
****************************************************

Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adapcctl.sh stop
script returned:
****************************************************
You are running adapcctl.sh version 120.7.12010000.2
Stopping OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: stopping opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adapcctl.txt
for more information ...

.end std out.
.end err out.
****************************************************

Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adalnctl.sh stop
script returned:
****************************************************
adalnctl.sh version 120.3
Shutting down listener process APPS_R12VIS.
adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adalnctl.txt
for more information ...

.end std out.
.end err out.
****************************************************

Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adopmnctl.sh stop
script returned:
****************************************************
You are running adopmnctl.sh version 120.6
Stopping Oracle Process Manager (OPMN) and the managed processes ...
opmnctl: stopping opmn and all managed processes...
adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adopmnctl.txt
for more information ...

.end std out.
.end err out.****************************************************
adstpall.sh:Exiting with status 3
adstpall.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adstpall.log
for more information ...
You may not see the timeout errors listed above for the 10gAS components, but you might, if your server is slow or particularly busy when you're trying to shut down services. Shutting down the apps tier can take a while, particularly while waiting for the concurrent managers to exit. Eventually, though, there shouldn't be any apps-related processes left running:
[applvis@londo ~]$ ps -ef  | grep applvis
applvis 16667 16665 0 19:55 pts/2 00:00:00 -bash
applvis 18927 16667 0 20:34 pts/2 00:00:00 ps -ef
applvis 18928 16667 0 20:34 pts/2 00:00:00 grep applvis
Once the apps are down, switch over to the database software owner (oravis) and shut down the database services. It's possible to do this using the normal lsnrctl and sqlplus commands you already know, but for purposes of completeness (i.e. egregious pedantry), we'll use the EBS-supplied wrapper scripts. First, use addlnctl.sh to stop the listener:
[oravis@londo ~]$ $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addlnctl.sh stop R12VIS
You are running addlnctl.sh version 120.1.12010000.2
Logfile: /u01/ebs/R12VIS/db/tech_st/11.1.0/appsutil/log/R12VIS_londo/addlnctl.txt
Shutting down listener process R12VIS ...
addlnctl.sh: exiting with status 0
Finally, use addbctl.sh to shutdown the database:
[oravis@londo ~]$ $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/addbctl.sh stop immediate
You are running addbctl.sh version 120.1

Shutting down database R12VIS ...

SQL*Plus: Release 11.1.0.7.0 - Production on Sat Dec 12 20:44:35 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0
Backing up the database is left as exercise for the reader, but I suggest using RMAN.

Starting EBS components
Okay, time to start everything back up, in reverse order of shutdown. First, the database listener:
[oravis@londo ~]$ export PATH=$PATH:$ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
[oravis@londo ~]$ addlnctl.sh start R12VIS
You are running addlnctl.sh version 120.1.12010000.2
Logfile: /u01/ebs/R12VIS/db/tech_st/11.1.0/appsutil/log/R12VIS_londo/addlnctl.txt
Starting listener process R12VIS ...

addlnctl.sh: exiting with status 0
Then, the database...
[oravis@londo ~]$ addbctl.sh start
You are running addbctl.sh version 120.1

Starting the database R12VIS ...

SQL*Plus: Release 11.1.0.7.0 - Production on Sat Dec 12 22:29:22 2009
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
ORACLE instance started.
Total System Global Area 521936896 bytes
Fixed Size 2161272 bytes
Variable Size 218105224 bytes
Database Buffers 289406976 bytes
Redo Buffers 12263424 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsaddbctl.sh: exiting with status 0
You'll note that I also used the database downtime to downsize the memory footprint of the database a bit. I'll confess that I didn't do any careful testig to arrive at these values; I just whacked a bunch of parameters by 50%. Your mileage may vary. :-)

Finally, back to the applvis user to start up the apps. I'll demonstrate an alternate means of running adstrtal.sh that doesn't involve prompting for a password. This is also a legitimate way to call adstpall.sh, but in both cases, be mindful that the password for the all-powerful APPS database user will be in your command history. Seems convenient on the surface, until you consider the security implications. Yes, it's just a test server, but safety begins in the sandbox. ;-)
[applvis@londo ~]$ adstrtal.sh apps/apps
You are running adstrtal.sh version 120.15
The logfile for this session is located at
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/admin/scripts/adopmnctl.sh start
[[I'll spare your eyeballs the full, verbose startup of all the components. It's unsurprisingly similar to the output from running adstpall.sh, and admit it, you didn't really read through that output in great detail either, did you? ]]
adstrtal.sh: check the logfile 
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adstrtal.log for more information ...
Again, on a slower system you may get some timeout errors from the 10gAS components. For your peace of mind, you can check the status of those components with adopmnctl.sh until the status of all the components reads, "Alive."

[applvis@londo ~]$ adopmnctl.sh status
You are running adopmnctl.sh version 120.6
Checking status of OPMN managed processes...
Processes in Instance: R12VIS_londo.londo.local
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 22974 | Alive
OC4JGroup:default_group | OC4J:forms | 22836 | Alive
OC4JGroup:default_group | OC4J:oacore | 22678 | Alive
HTTP_Server | HTTP_Server | 22619 | Alive
adopmnctl.sh: exiting with status 0
Yay. Carry on, then.

Other important stuff
Now you know how to stop and start Oracle Applications. If you're just going to be exploring the apps as a hobbyist, that should be enough to get you going. There's a lot more to learn, however, if you're interested in understanding common EBS maintenance tasks, including:
  • adadmin: This utility is used to maintain objects in the Apps database and applications tier filesystem. Common tasks include recompiling invalid database objects, regenerating forms and reports files, and enabling and disabling maintenance mode (a required task during patching). adadmin is invoked by the applications owner (applvis in our case). To get an better idea of what adadmin does, type adadmin help=y from the command line, or just type adadmin to invoke its text-based menu system and explore from there.
  • Autoconfig: In the Dark Ages of Oracle Applications, making configuration changes in EBS was fraught with peril. Changing the value of a directory or port for an application server component could involve touching multiple config files, and missing one file could lead to confusing (at best) or disastrous (what's worse than disastrous?) results. Nowadays, Autoconfig takes care of configuration file management for you. The trade-off is that any manual changes made to Autoconfig-managed configuration files will be overwritten when Autoconfig is run. There are two versions of Autoconfig: one for the applications tier ($ADMIN_SCRIPTS_HOME/adautocfg.sh), and one for the database tier ($ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/adautocfg.sh). In general, you'll be using the apps tier version of Autoconfig much more frequently. It's worth noting that Autoconfig does not manage the database pfile or spfile; changes to database initialization parameters can be made without concerns about Autoconfig clobbering them.
  • adpatch: This may not be relevant to your current sandbox, but in the real world you are unlikely to run an unpatched EBS system. adpatch is the utility that drives the patching process for the applications tier file system and Apps database objects. It does not handle patching the database and application server ORACLE_HOMEs, however, you still get to use the trusty Opatch utility for that.
Almost done!
The 4th and final part of this little "scratching the surface of E-Business Suite" adventure will take a look at a few parts of the UI. You know what that means, right? Yup, more screenshots! I bet you can't wait!

References:
  • Michael Taylor (mdtaylor), Oracle Ace and "installing EBS on unsupported versions of SUSE" guru (among other things), posted some recommendations on OTN for extreme downsizing of the memory consumed by the EBS database and concurrent managers.
  • My Oracle Support Doc 396009.1 breaks down the database initialization parameters for R12. Configure for the low end, unless you're really building out a Vision instance for use by lots of people, in which case you need to stop reading this guide before you get yourself into trouble. ;-)
  • If you're interested in setting up your applvis OS user's environment so that the Apps environment is sourced automatically and the various Apps administration utilities are added to your path at login, I know a guy who wrote not one, but two blog posts about that.
  • Chapter 4 of the Oracle Applications Maintenance Utilities guide covers the adadmin utility
  • The Oracle Applications Patching Procedures guide covers the use of adpatch, and the patching process in general
  • And, finally, Chapter 5 of the Oracle Applications Concepts guide discusses Autoconfig, and provides a context for use of the tool (that's a pretty bad pun, but only if you've read the guide).

Tuesday, December 8, 2009

EBS Install Guide - Part 2

By John Piwowar [ blog | twitter ]
This is the second post in my "Installing E-Business Suite" series, where we actually install the software. Hopefully by now you've read part 1, downloaded the software, and configured your Linux server. Thanks again to Chet for the opportunity to share on his blog; I'm enjoying this guest spot on ORACLENERD Inc's New Media Empire (2.0!). And now, welcome to screenshot village; we hope you enjoy your stay.

Part 1 --> Part 2 --> Part 3 --> Part 4

The Oracle Applications Rapid Install Wizard, more commonly called RapidWiz, drives the EBS installation process. If you're accustomed to using the Oracle Universal Installer, you'll find that RapidWiz "feels" a bit different, but it still has that comforting grey, "Hi, I'm a Java-based Oracle software installer!" look to it.

Step 1: Launching RapidWiz
Log in to your Linux server's desktop as root, not oracle. Open a terminal window and change to the startCD/Disk1/rapidwiz subdirectory of the software staging area

Run the rapidwiz utility in that directory:
[root@londo R12stage]# cd startCD/Disk1/rapidwiz/
[root@londo rapidwiz]# ./rapidwiz
You should see a few launch messages in your terminal window, and the welcome screen of the installer will appear. Click Next:



Step 2: Select installation type
In the Wizard Operations window, make sure that "Install Oracle Applications" is selected, but do not check the Express Install box. Click Next:



Step 3: OCM configuration
In the Oracle Configuration Manager window, leave all the fields and options blank, and click Next. OCM is not a complication we need right now. :-)



Step 4: Configuration Choice
Since this is a new install, select the first option ("Create a new configuration") in the Configuration Options window and click Next.



Step 5: Port pool assignment
Select a number between 0 and 99 from the port pool list in the Global System Settings window, then click Next. Doesn't matter which number; choose your favorite. In past releases I've had issues where selecting 0, 1, or 99 has caused strange problems later, but those were pretty obscure and not consistently repeatable, so don't let that stop you from living on the edge. ;-)



Step 6: Database node configuration
Now we're finally getting to the fun bits! In the Database Node Configuration window, verify that the following fields have correct values:
  • Database type is "Vision Demo Database"
  • Hostname and domain name match the host and domain names on your Linux server. If you've configured this correctly in /etc/hosts and /etc/sysconfig/network, RapidWiz should pull the correct values.
  • The Operating System value should match your server's platform (Linux x86 or Linux x86-64)
Change the following fields as necessary:
  • Database SID: You can leave this at the default (VIS), or change it if you prefer.   
  • Database OS user: The OS user you created in part 1 as the owner of the Oracle software (e.g. oravis)
  • Database OS group: Change to oinstall
  • Base Directory: This should be set to a directory in the Very Large Mount Point(tm) that you created in part 1. RapidWiz doesn't exactly conform to the OFA standard, but if you're picky about such things, you can click the "Edit Paths" button for finer control over where things go. I'm usually picky, but for the sake of saving you a few more screenshots, I'm letting RapidWiz decide where to file everything this time. :-)


Note: If your specified base directory doesn't exist, you'll need to create it. Um, whoops. Actually, I intentionally skipped that step just so you could get an example of what error conditions you might encounter during configuration. That's me, taking one for the team. It's just the sort of guy I am.



Make sure to change the ownership, and to grant write permissions to the oinstall group:
[root@londo rapidwiz]# cd /u01
[root@londo u01]# mkdir -m 775 -p ebs/R12VIS
[root@londo u01]# chown -R oravis:oinstall ebs
[root@londo u01]# ls -lR ebs
Click OK once you've created the base directory, make sure the installer has retained your other configuration settings, and click Next.

Step 7: Applications node configuration
The next window, "Primary Applications Node Configuration," takes most of its values from the database node configuration. You'll need to change the values of Apps OS user and Apps OS group to match the ones created in part 1 of this series. Everything else should be fine; you'll just need to verify. Again, if you want to tinker with specific locations in the installation, you can click the Edit Paths button, but that's beyond the scope of these instructions. Oh yeah, and click Next when you're done.



Step 8: Node information review
The Node Information window presents a review of the servers you've configured so far, and offers the option to add an additional server. Adding a server would be useful in the case of multi-node installations, but for now, just click (what else?) Next:



Step 9: Pre-install system checks
RapidWiz will pop up a window showing the system checks it is performing prior to installation. Basically, it's making sure that the necessary ports are open for the applications and database to run, that there's enough disk space to install, that it can write to all its directories, etc. After the checks are done, a Pre-Install Checks results window will appear. Hopefully you'll see all green checkmarks, as below. If you see red X's next to any of the test categories, click on the X to see a log from the test run, find and fix the errors, and click the Retry button to re-run the tests. Once all tests have been run successfully, click Next.





Step 10: The actual installation part
Click Next at the Install Review window, then Yes in the inevitable "are you sure you want to install?" box, and you're off to the races! Or maybe off to run some errands while blue bars crawl across the installer windows for a few hours, whichever. You'll notice that the terminal window from which you launched RapidWiz will display some information about where it's writing out log files. Hopefully we won't need those, because the installation will just go swimmingly, right?





Step 11: Post-install checks
After a while (probably a few hours, depending on how speedy your server is) the installation will complete, and post-install checks will begin. If some of the post-install checks are listed as failed initially, don't be too worried. The initial startup of E-Business Suite can pretty resource-intensive, and it's not unusual for some of the post-install checks to time out waiting for responses from web pages, or for application server components themselves to time out when starting up. Keep in mind that you're installing software intended to run on server-class hardware, and your server might be under spec somewhere (disk speed, CPU, memory).



Here's what my post-install checks looked like the first time around. Ouch.  As with the pre-install checks, you can click on the icons to see more about the failed checks. I'll spare you all 5 screenshots, but in this case, all the messages have the same theme: HTTP server taking too long to respond.



Step 12: A troubleshooting interlude
My poor 2-CPU "server" had a load average above 10 when the post-install checks first ran, and a ridiculous level of I/O wait (thanks, 5400RPM hard drive!), so the first thing I did was to wait until the system has settled down a bit, and then click the Retry button. Unfortunately, the outcome of the post-install checks didn't change, so I had to look into fixing the web server. What follows may not be applicable to your install situation, but it does provide a small taste of basic Oracle Applications troubleshooting, so please bear with me. If you get bored, or if your post-install checks were all successful, you can always skip ahead to step 14. ;-)

The first thing I did was to log in as the owner of the Oracle Applications software, applvis in this case. Then, I set up the OS environment to be able to better navigate the various sections of the Apps filesystem. You'll often hear this called "sourcing the Apps environment."
[root@londo ~]# su - applvis
[applvis@londo ~]$ . /u01/ebs/R12VIS/apps/apps_st/appl/R12VIS_londo.env
If you don't feel like digging through the documentation to find out where the Apps environment file should be for your system, you can find the value from the result of the "Environment File" post-install check. The output from that check lists a number of environment files; the one that's relevant here is the "APPL_TOP environment file." Using the newly-defined environment variables, I checked the status of the 10g Application Server components and tried to restart the web server:
[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME/adopmnctl.sh status
You are running adopmnctl.sh version 120.6
Checking status of OPMN managed processes...
Processes in Instance: R12VIS_londo.londo.local
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 10677 | Alive
OC4JGroup:default_group | OC4J:forms | 12390 | Alive
OC4JGroup:default_group | OC4J:oacore | 10505 | Alive
HTTP_Server | HTTP_Server | N/A | Down

adopmnctl.sh: exiting with status 0
adopmnctl.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adopmnctl.txt for more information ...
This confirms that the web server is the only component that's currently failing, and the other app server components of the system are starting as expected.
[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME adapcctl.sh start
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
================================================================================
opmn id=londo.local:6255
0 of 1 processes started.
ias-instance id=R12VIS_londo.londo.local
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--------------------------------------------------------------------------------
ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server/
Error
--> Process (index=1,uid=1625958549,pid=26727)
failed to start a managed process after the maximum retry limit
Log:/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/ora/10.1.3/opmn/HTTP_Server~1.log

adapcctl.sh: exiting with status 0adapcctl.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adapcctl.txt for more information ...
That doesn't look so great, but at least I have a log file to review:
[applvis@londo ~]$ tail /u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/ora/10.1.3/opmn/HTTP_Server~1.log
--------
09/12/05 19:28:55 Start process
--------
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/u01/ebs/R12VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd:
error while loading shared libraries:
libdb.so.2: cannot open shared object file: No such file or directory
That missing shared object library file is the most likely culprit. This often, but not always, means that there's a required OS package missing. In this case, a review of the installed packages on my server didn't show anything missing, so I turned to Google and My Oracle Support. I quickly found a handful of references in OTN forums and Oracle's non-EBS documentation to a quirk of installing R12.1 on 64-bit Oracle Enterprise Linux 5. One symlink later, and I was on my way:
[root@londo ~]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2
[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME/adapcctl.sh start
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...
adapcctl.sh: exiting with status 0
adapcctl.sh: check the logfile
/u01/ebs/R12VIS/inst/apps/R12VIS_londo/logs/appl/admin/log/adapcctl.txt for more information ...
[applvis@londo ~]$ $ADMIN_SCRIPTS_HOME/adopmnctl.sh status
You are running adopmnctl.sh version 120.6
Checking status of OPMN managed processes...Processes in Instance: R12VIS_londo.londo.local
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 10677 | Alive
OC4JGroup:default_group | OC4J:forms | 12390 | Alive
OC4JGroup:default_group | OC4J:oacore | 10505 | Alive
HTTP_Server | HTTP_Server | 29299 | Alive
After that, the post-install checks all came back green. Which is good, because I hadn't clicked Next in a while:



Step 14: Grand Finale
(what, you thought I'd risk the whole exercise by ending on step 13?)
And now, after hours of downloads and nigh-endless unzipping, the EBS install is done! That tempting "Connect to Oracle Applications Release 12.1.1" button may work, but if it doesn't, don't despair. Click Finish, open a web browser, and go the URL http://server.domain:80nn. The value for nn is the "port pool" value you selected in the early stages of the installation. Hopefully you know what "server" and "domain" are. :-) For example, when I browse to http://londo.local:8055, I am redirected to the main login page for EBS:





If you want to start looking around a little bit, the "superuser" for Oracle Applications is SYSADMIN, and the default password for the account is the same as the username. If you attempt to launch any of the Oracle Forms-based parts of the Apps interface from a browser on your Linux server, you may run into trouble. The EBS Forms interface is famously finicky on Linux-based browsers; I usually access EBS from browser on a Windows or OS X desktop, rather than from Linux, but the OTN forums are full of tips on how to get EBS Forms working on Linux. I'll try to dig up some links for the next post, or you can chime in with comments if you've already been down that road.

Thanks for following along! I hope that your installation experience is even more painless than this one. In part 3, I'll cover a few basic topics following the theme, "great, it's installed, now what do I do?"

References

Monday, December 7, 2009

EBS Install Guide - Part 1

By John Piwowar [ blog | twitter ]
Chet, the oraclenerd, recently suggested that I write about installing Oracle E-Business Suite, aka Oracle Applications. He's also been encouraging me, in his low-key sort of way, to guest post on his blog. Here's the result. Thanks for the opportunity, Chet! Hope I don't drive too many of your readers away. ;-) Each post in this series will have a companion piece on my blog, Only Four Left, with additional details, discussion, and errata, in case you just can't get enough on this topic. Hey, it could happen.

Editor's Note
You can now get the entire series, including John's supplementary posts, in one convenient PDF file!   
Part I --> Part 2 --> Part 3 --> Part 4

Cheesy radio-commercial style intro
So you're a fan of tinkering with Oracle technology. You might even label yourself an oraclenerd. You have a few spare hours this weekend, and you're thinking about installing Oracle E-Business Suite to see what the fuss is all about, since people seem to talk about it a lot. But the installation and configuration guide is ridiculously, nap-inducingly long, and you can't even find the software on OTN. Where to start? Wonder no more! Start here!

This series of posts will cover a "Vision" install of Oracle Applications 12.1.1 on Linux. In this installment, I'll discuss requirements and acquiring the software. Subsequent posts will cover the installation of the software and actually using your shiny new E-Business Suite system.

Requirements
  1. A Linux machine (physical or virtual).
  2. At least 2GB of memory. 3GB would be better. 4GB would make me jealous. ;-) If your machine is on the low end of this list, don't expect to use it for anything else while EBS is running.
  3. Lots of disk space. At least 300GB. If you want reasonable breathing room, set aside 350GB.
  4. Access to My Oracle Support (formerly Metalink). I wish there was a way around this, but I'll be making references to a handful of My Oracle Support documents, and quoting extensively from those documents is a huge no-no. I'll do my best to make these instructions usable for those without access, but there may be bits that you'll miss.
Recommendations
  1. Install on a version of Linux that is supported/certified for use with EBS. I'm going to be using Oracle Enterprise Linux 5, Update 4 (64-bit) for this install, but there are other options, listed in My Oracle Support Doc ID 761566.1: Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (32-bit Linux users can check out My Oracle Support Note 761564.1) It may be possible to install EBS on your favorite flavor of Linux, but that's not what this particular adventure is all about.
  2. Consider installing EBS in a virtual machine, using VMware or Virtualbox. There are serious advantages to doing this, in my opinion, particularly if, like me, you'll be installing on your primary workstation.
  3. Get familiar with some of the documentation while you're downloading the massive software distribution and building and/or patching your Linux environment to get up to spec. You'll find a reference list at the end of this post.
Preparing the OS
When laying out the disk space for your Linux server, allocate your preferred amount of space for swap and the operating system (I usually set aside about 10GB), 260-275GB for the /u01 partition (where we'll be installing the EBS software and database), and 50GB for the stage directory for the installer (I usually mount this to /mnt/R12stage). Needless to say, a production system's layout would be more refined/detailed, but if you're reading this guide as a roadmap to a production deployment, you need to stop immediately and have your head examined. ;-)

Install packages and set kernel parameters according to the appropriate section in the Release Notes referenced above. If you don't have access to My Oracle Support, you're in a bit of a tough spot, but here are some thoughts:
  • Version R12.1 of EBS comprises Oracle RDBMS 11.1.0.7, Oracle Developer 10g, and two versions of Oracle Application Server 10g (ahem, excuse me, Fusion Middleware): 10.1.2.3 and 10.1.3.4. Presumably, combining the installation requirements for those products will get you most of the way to a full set of required packages and kernel parameters.
  • Similarly, installing all the packages that come with your OS distribution should get you almost all of the installation requirements.
  • The oracle-validated RPM seems to cover many, but not all, of the software and kernel parameter requirements for Oracle Enterprise Linux.
  • One point that bears mentioning (and has been discussed pretty openly in the OTN forums, so it's not like I'm giving away any deep My Oracle Support secrets) is that an old version of openmotif libraries is required for this install. The name of the package varies by OS distribution, but the version number is what's important: it has to be version 2.1. If you go with the install-everything route, be sure to remove any competing openmotif packages.
Create two OS users, one to own the Oracle RDBMS software, and one to own the Apps software. Oracle recommends oraSID and applSID, respectively, where SID is all or part of the database SID that you designate during installation. For example, since we'll be doing a Vision install, it would be appropriate to create users oravis and applvis. It's a good idea to make sure that both users share the same primary group, usually the oinstall group. Also, create a dba group and assign it to the Oracle RDBMS software owner as an additional (not primary) group.

Acquiring and staging the software
E-Business Suite software can't be found on Oracle Technet (OTN). You can either purchase the media from the Oracle Store, or download it from Oracle's E-Delivery site. I'll assume you'll be downloading from E-Delivery. Two things worth noting here:
  1. E-Delivery is decoupled from other Oracle web properties like My Oracle Support and OTN. You'll need to register with new credentials to download software here.
  2. Software downloaded from E-Delivery is not covered under the OTN "Free to download, free to learn, unlimited evaluation" license. Instead, it's a thirty-day trial, after which you'll need to uninstall or purchase a license.
After logging in to E-Delivery, select "E-Business Suite" in the Product Pack dropdown, and select your desired installation platform (Linux x86 or Linux x86-64). Click Go to search, and click the "Oracle E-Business Suite Release 12.1.1 Media Pack" link to get to the downloads page. Don't pick the "Upgrade Media" link, unless you really intend to upgrade, in which case you really shouldn't be reading this. ;-)

EBS_DL_search.png

You don't need to download all of the files listed on the page, but you're still going to be grabbing about 45GB. You might want to fix yourself a snack while you wait. The media is separated as if to be burned to DVD. For this exercise, however, we won't be burning DVDs. Be sure to grab all of the parts labelled:
  • "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Start Here"
  • "Rapid Install RDBMS - Disk 1" "Rapid Install Databases - Disk 1" through "Rapid Install Databases - Disk 9," inclusive
  • "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install Tools - Disk 1"
  • "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install APPL_TOP - Disk 1"
  • "Oracle E-Business Suite Release 12.1.1 for Linux x86-64 Rapid Install APPL_TOP - Disk 2"
When I sent these instructions to Chet, he did the smart thing and created a spreadsheet to track his downloads. He's been kind enough to share it on Google Docs. Note that your part numbers may be different if you decide to go with 64-bit Linux instead of 32-bit.

Once you have all of the media, unzip the files into the stage directory on your Linux server. When the unzip utility asks if you want to replace dvd.label or component.label files, answer yes. If you get any other errors from unzip, you may have a corrupt download, and should re-download that zip file. Don't assume you can work around it. Once you've unpacked all of the files, your stage directory should look like this:

[root@londo R12stage]# ls
oraAppDB oraApps oraAS oraDB startCD
At this point, you'll be ready to start the installation (finally!). Hopefully, by the time you're done building your Linux server and downloading and staging the EBS software, the next installment in this series will be up. ;-)

Additional References

Caveats, disclaimers, and assumptions
  • This guide is intended as a roadmap for people who are self-directed enough to tinker if things go wrong. I'm presenting a series of steps that have worked for me, written up as I performed them, so it's all worked at least once. No, really. Honest.
  • If you use this guide to deploy a system intended for production use, then your project timeline and maybe even your job are at risk. In other words: "No guarantees, warranties, express or implied, proceed at your own risk, blahblah fake legalese etc"
  • There are individuals and organizations out there that provide thorough, professional-grade training on installing and maintaining Oracle Applications. Please do not make the mistake of equating their excellent, polished work with a handful of blog posts by some random dude on the Internet. :-)
  • Similarly, part or all of the material presented here may have been covered on other blogs. Please share links to your favorite resources in the comments.
  • This guide assumes some level of familiarity with Linux, or at least the ability to use Google to find instructions on installing, configuring, and working with Linux. Extensive Linux tutorials are beyond the scope of this guide; heaven knows I'm verbose enough as it is.