Installing Oracle Applications E-Business 11i on Windows XP / Windowws 2003 Server

Hi! you will be able to install EBS 11i on Windows XP/ Windows 2003 Server, if you just follow these instructions else you should not get into it.

System Requirements Hardware used.

Windows XP (professional or Home) Service Pack 2 with 1 GB RAM ( you can do it on 512 MB also but not at all efficient) and make sure you have NTFS file system.
HD min 150 GB (c’mon your system and staging also need some space don’t agree with who says it work 100 GB with vision DB). You can use external hard drive too.
Don’t listen to those who advise you to install EBS 11i without vision database. I know
you are installing all this for learning etc.

Very Important.

Make sure there is no oracle product installed on your system. No entry of oracle should be in windows registry except system default by windows itself. So it is recommended to use fresh system for this purpose. If you tried a failed installation before on your PC then reinstall the OS (Win XP) again otherwise you will waste your time.

There should be !!!!NO!!! JDK installed on your machine. EBS 11i will install JDK version on your machine otherwise you will get errors I don’t want to discuss all this here. Just NOOOO JDK on your machine.

Pre-requisite software requirements.
1. Microsoft VC++ - http://msdn.microsoft.com/vstudio/express/visualc/download/

while installing VC++ make sure it is done in C:\V98. No spaces in any directory
structure of any software you install as pre-requisite for Oracle Apps. Opt for Register
Environment Variables while installing VC++.

If you installed MS Visual Studio C++ 6.0 then make sure you installed service pack 6.

http://msdn2.microsoft.com/en-us/vstudio/aa718364.aspx

Copy LINK.exe from C:\V98\bin to C:\WINDOWS\System32

2. Perl - http://www.activestate.com/Products/ActivePerl/

Version 5.8 or more and use MSI package type.

Perl is only needed if you are using Oracle Media Pack. If you are downloading from oracle site then you can skip this installation.

2. CYGWIN - http://cygwin.com/

- Download setup.exe to your machine.
Run setup.exe and click Next, which will bring up the Choose Installation Type screen.
Select -> Install from Internet and Click Next
Select -> Root Directory C:\cygwin and select radio button
Install for -> All Users and Default Text File Type -> DOS / text -> Next Local Package Directory can be any but C:\cygwin is recommended. -> Next Direct Connection.

Click on Next again to get to the Select Packages screen, and select the following packages (click on to toggle):
a. All Default
b. Archive Default, plus manually select the zip package
c. Base Default, plus manually select the following extra packages: ash, coreutils,
diffutils, findutils, gawk, grep, sed, tar and which
d. Devel Default, plus manually select binutils, gcc, gcc-core, gcc-g++, make and
mktemp
e. Doc Default, plus manually select cygwin-doc and man
f. Editors Default, plus manually select vim
g. Interpreters Default, plus manually select gawk
h. Shells Default, plus manually select ash and tcsh
i. Utils Default, plus manually select cygutils and file

Click on Next again to download the selected files. It will take some time depending upon mirror site you selected and after download cygwin setup will be automatically starts.

After installation completed

Open folder C:\cygwin\bin

And rename followings

gawk.exe to awk.exe
grep.exe to egrep.exe
make.exe to gnumake.exe
gcc.exe to cc.exe

You can override the name if system says that awk or egrep or cc already exits just remove or move to some other place.

Set the Path to include the C:\cygwin\bin

C:\> set PATH = %PATH%;c:\cygwin\bin

And then check your PATH to see that it include C:\cygwin\bin and C:\V98\bin

C:\>echo %PATH%

Oracle Media
You should be having Lasted available Oracle media pack (recommended) or Software download from oracle site and follow the unzipping instruction as per oracle documentation.

Domain Name Configuration

1. Open file c:\windows\system32\drivers\etc\hosts. Enter a domain next to localhost entry you will be using this domain while installing Oracle Applications. I used mydomain so you can replace what ever you want. 198.168.1.102 is IP Address of my PC you should enter your machine’s IP. If you don’t know it you can find it.

C:\>ipconfig

Example

127.0.0.1 localhost mydomain mydomain.com
198.168.1.102 mydomain mydomain.com

2. Go to Control Panel -> Systems -> Computer Name Tab -> Click on Change -> Click on More -> Enter Primary DNS Suffix as ‘mydomain’.

3. Open Network connections, Select your Connection on which your machine is connected (You will find Wireless or LAN) and right click and select properties. Select Internet Protocol( TCP/IP) and click on to properties. Click on Advanced button and go to DNS tab. Enter DNS suffix for this connection as ‘mydomain’.

4. Restart the PC.

.Staging the Oracle

If you have Oracle Media Pack then

Insert the Start Here DVD in DVD Rom and go to folder

Stage11i\startCD\Disk1\rapidwiz in DOS Prompt and type

D:\Stage11i\startCD\Disk1\rapidwiz\perl adautostg.pl
And follow the wizard.

Recommended Steps but not necessary.

There steps are only if your installation fails due to any reason so you can restore your registry and system to pre installation state.

When Staging is done successfully then export the registry and save it on a file.
Start -> Run -> regedit-> File -> Export and select the location where you want to store it .

Take a Computer Restore Point.
Start -> All Programs -> Accessories -> System Tools -> System Restore ->Create a Restore Point -> Enter name of restore point for example ‘PreOra’ and Press the Create.

Restart the PC.

Installing the the EBS 11i

So far you have done a great job. Now time to get the job done.

Go to folder C:\Stage11i\startCD\Disk1\rapidwiz or where you have done your staging on hard drive and just click RapidWiz

On welcome screen -> Next and Select

Install Oracle Applications E-Bussiness 11i Check on Use Express Configuration -> Next

In Express Configuration Information screen enter the following:

Database Type = Vision Demo Database
Database SID = VIS
MKS directory = C:\cygwin\bin or where “cygwin\bin” is
MSDEV directory = C:\V98 or where VC++ was installed
Domain = mydomain or what so ever is your domain.
Oracle Base directory =C:\oracle or where ever you want to install oracle
applications

Follow the wizard and you should pass all the Pre-Install Checks
If not then you did not follow instructions above and help yourself.

If you passed all the checks then just Click Next and follow the Wizard and installation will be done in 5 steps and take about 2-3 hrs depends upon the system.

After the installation is completed successfully (it should be) then Post-Installation Checks will be preformed. If you passed all the checks It is really a Wonderful and You Rocks

If your system don’t pass the Post-Installation Checks even then don’t worry just smile coz installation is successful you need to restart your PC and Open Command Prompt open to staging directory c:\Stage11i\startCD\Disk1\rapidwiz
And now just type rapidwiz –restart

Follow the Wizard and Enter all the info as you enter before Now This time it will take few minutes and you should pass Post-Installation Checks

If still a problem just repeat above step again you will get to it . Restart the PC and enter the URL in web browser

http://hostname.mydomain:8000/

E-Bussiness Login Username = sysadmin Password = sysadmin

These are the successful installation steps. I practically have done all that. Thanks to Mr. Naveed

Cheers …..

Installation / Re-Installation of Oracle Database 10g on Windows

1. Take back-up of data (Full Database).
2. Shutdown your database. (Shutdown Abort).
3. Take back-up of SP file.
(If you have set some parameters previously according to your environment)
4. Note the size and names of all table spaces.
5. Delete Database through wizard (If previously installed).
6. Run Installer and uninstall Oracle from your system.
7. Remove Oracle entries from registry.
8. Restart your system.
9. Remove Oracle Directory from System.
10. Check services from Administrative tools. Please verify that there should not any Oracle related service existing in the list. No TNS, no oracle home etc.
11. Reboot your system.
12. Run Oracle Installer and start installation. Follow wizard and select options according to your requirements.
13. When Database is created, verify your work by connecting to database.
14. Shutdown Database.
15. Restore SP file.
16. Start Database.
(Note if you find any error on startup, then you have to generate SP file from init.ora file)
17. Install patch from its installer and run the related scripts. (It will take around 45 minutes so no need to worry).
18. Reboot your machine.
19. Create table spaces by same name and size as we noted in step 4.
20. Load (Import) backup from dmp file. Create log file as well.
(View log file. If you find any error of “table space already exists”, then don’t worry. It is because we have created the table spaces our selves.)

Good Luck!!!

Oracle SOA Suite

SOA or Service Oriented Architecture allows organizations to reduce the complexity within there IT Architecture by adopting modular standards such as web services that are adaptable and flexible. The Service Oriented Architecture aims at achieving interoperability between various prosperity software that the organization might use. The SOA makes use of web service standards like Web Services Description Language (WSDL), extensible markup language (XML), and Simple Object Access Protocol (SOAP).

Oracle provides an SOA Suite provides the necessary infrastructure that enables you to create, deploy and managed these SOA complaint Web services.

The main components of the Oracle SOA Suite are

• Integrated Service Environment which includes Oracle JDeveloper,Oracle Application Framework and Oracle Toplink.
• Oracle BPEL Process Manager
• Oracle Enterprise Service Bus
• Oracle Business Rules
• Oracle Business Monitoring
• Oracle Web Services Manager
• Oracle Application Server 10g Rel 3

Installing SOA Suite

The Oracle SOA suite needs an 10g infrastructure to which it can be integrated and installed. This can either be the infrastructure that come with the 10g Application Server or the Oracle Collaboration Suite infrastructure.However to install SOA suite the database of the infrastructure must be at 10.1.5 or higher.

Pre Requisites

A 10g Application Server infrastructure installed

As mentioned earlier the SOA suite will be installed on a existing infrastructure, you must install a 10g infrastructure of you already do not have one.

Upgrade Infrastructure Database

The infrastructure database that comes with Oracle Application Server or Oracle Collaboration Suite might be required to be upgraded to 10.1.5 at least.

Create the required SOA schemas In The Database

The SOA suite requires the ORABPEL,ORAESB and ORAWSM schemas to be loaded into your infrastructure database. The irca.sh script will create these schemas for you. You can find this script at install/soa_schemas/irca in your SOA Suite CD.Even if these schemas exist you must overwrite them in order for the SOA Suite to function properly.

Login to your infrastructure tier and execute this script after setting the environment.

$ ./irca.sh
Integration Repository Creation Assistant (IRCA) 10.1.3.1.0
(c) Copyright 2006 Oracle Corporation. All rights reserved.
Enter database "host port serviceName" [localhost 1521 orcl]: samlx.appsdbablog.com 1521 samdb.appsdbablog.com
Enter sys password:
Running IRCA for all product(s):
connection="samlx.appsdbablog.com 1521 samdb.appsdbablog.com", , orabpelUser=ORABPEL, esbUser=ORAESB, orawsmUser=ORAWSM
Validating database ...
Validating database character set ...
Running prerequisite checks for ORABPEL ...
WARNING: This script will overwrite the existing ORABPEL schema.
Do you wish to continue? (y/n) y
Enter password for ORABPEL:
Loading ORAESB schema (this may take a few minutes) ...
Running prerequisite checks for ORAESB ...
Enter password for ORAESB:
Loading ORAESB schema (this may take a few minutes) ...
Running prerequisite checks for ORAWSM ...
Enter password for ORAWSM:
Loading ORAWSM schema (this may take a few minutes) ...
INFO: ORABPEL schema contains 210 valid objects.
INFO: ORAESB schema contains 175 valid objects.
INFO: ORAWSM schema contains 90 valid objects.
IRCA completed.
Please check for any ERROR message above and also check the log file
irca2006-11-30_07-52-09PM.log for any error or other information.

Create OS User

Create a OS user through will the installation of SOA suite will happen.

$useradd -g dba -d /u02/orasoa orasoa

Starting The Installation

Login to the orasoa user and start the installer using the ./runInstaller command.



The first screen lets us choose between a basic installation and a advanced installation, we choose the advance installation option for more felxiblity.



The next screen presents us with the components of SOA suite which we wish to install, here we choose J2EE Server, Web Server and the SOA Suite option.



A pre installation check of the operating system is now carried out.



You must now provide a user with sys DBA privileges on your infrastructure database and the hostname for your infrastructure.



Now you must give the password for the schemas you created using the irca script.



Specify weather you want manual or automatic port selection.



Enter an instance name and the password for the OC4JADMIN super user.



In case you want this instance to be a part of the existing Application Server cluster, you must specify the details here.



The installer will now display the components that it will install and configure for you.

The OUI now start the installation showing the progress.



Like most oracle installation, the SOA also requires you to run the root.sh script as the root user.



The configuration Assistant will now start the configuration of the products and also start the associated services.



At the end of the installation information is displayed on how to access the instance.



You can access the SOA Suite with the URL from the previous screen.

Install SOA Suite Companion CDs

After having installed the SOA Suite, lets install the Companion CDs. I am listing the steps that I undertook and the steps that I skipped in this process.
The URL for downloading Oracle SOA Suite Companion CDs is Link Here
You should install the SOA Suite prior to installing Companion CDs. Link for SOA Suite is click here
There are three files that you need to download. For this, I created following Directory Structure.
c:\bpel\soa_windows_x86_companion_101310_disk1 , disk2 and disk3

Extract the three zip files into respective 3 subdirectories.

Install Apache 2.0 http server
Navigate to c:\bpel\soa_windows_x86_companion_101310_disk1, and click on setup.exe
Selected the option to Install Apache Server as prompted, in default path C:\product\10.1.3.1\companionCDHome_2
Once installed, you will get a message
The following information is available in:
C:\product\10.1.3.1\companionCDHome_1\install\setupinfo.txt
-----------------------------------------
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://dell:7777

Install Oracle Containers for J2EE 10.1.3.1.0
Again from Companion CD1 itself, I Selected this option, and installed. Took few seconds.

Install TopLink 10g Runtime and Developer
Again from Companion CD1 itself, clicked on setup.exe and then I Selected this option, and installed. This tool approx 30 seconds.
The homepage for TopLink was created in location file:///C:/product/10.1.3.1/companionCDHome_3/toplink/doc/index.html.html

Companion CD2
Next, navigated to C:\bpel\soa_windows_x86_companion_101310_disk2\asg\Disk1\install
Clicked on Setup.exe, and noticed that Disk2 contained Application Server Guard, which I did not need. Hence I skipped this step.
Note: Companion CD2 delivers jDeveloper as file jdevstudio10131. This is where BPEL diagrams will be developed.
I had downloaded this separately anyway to install/extract on c:\jdev

Companion CD3
Next, navigated to C:\bpel\soa_windows_x86_companion_101310_disk3\failsafe\install
Clicked on Setup.exe, and noticed that Disk3, contained Oracle Fail Safe, that which I did not need. Hence I skipped this step too.

Validate your SOA Suite Install on PC

Before we can begin design and development in SOA, we must first ensure that SOA Suite was installed correctly on your Machine.

In this article, I will demonstrate the below:-
1. Start your SOA Console
2. Once you have installed SOA Suite and Companion CD, quickly validate that BPEL Server works as expected.


Step 1. In your Program Menu of [Windows in this case], Click on Start SOA Suite.


Step 2. Click on Menu SOA Launch Console [above the menu in Step 1]

Step 3. The Step 2 above would have displayed the SOA Suite in the browser.
Let's validate that your BPEL Server is up and running.
In the right hand side window, you would see BPEL Control and also Application Server Control


On the right hand side of the browser window, click on BPEL Control under Manage Your SOA Suite.
You will be prompted for User-Id and Password, which will be oc4jadmin/xx23xx23 as defined in article for SOA Installation

Keep patience when logging in for the very first time.
This completes the validation of your BPEL Server.

Step 4. Next, go back to SOA Console [which in my case is http://dell:8888/]
Click on Application Server Control
Login and password once again is oc4jadmin and xx23xx23
Scroll down and click on link "Runtime Ports"
Under "OC4J Home", note down the Port Number for RMI

This completes the validation of Key Processes that have been installed on your PC.
In the next training article, we will learn how to configure Database Connection to OracleLite and Application Server using jDeveloper 10g.

SOA Suite Installation

To download the BPEL Process Manager [SOA Suite],
follow the link http://www.oracle.com/technology/software/tech/webservices/index.html
http://www.oracle.com/technology/software/products/ias/htdocs/101310.html
Alternately follow the above link[ I am not installing the Companion CDs as yet].

First install the SOA Suite as shown below.
I have listed the installation steps. The install was very straightforward, and does not really need a supporting article.

Salient feature of this install are:-
**This will install the BPEL Server, which is equivalent to the Workflow Engine[just in case you wish to make comparison].
**SOA Suite comes bundled with a Oracle Lite database, which should sufffice for your tutorials etc.
**SOA Suite will not have jDeveloper. jDeveloper can either be installed separately, or as a part of Companion CD.

What is the Difference between BPEL Server and jDeveloper?
Both are needed for you to practice BPEL design/development. jDeveloper will be used to make Service Orchestration diagrams.

Unzip the SOA Suite to c:\bpel and run the install.
For this I doubleclicked on C:\bpel\soa_windows_x86_101310_disk1\setup.exe


Password lets say xx123xx123

The installation of Oracle Application Server 10g 10.1.3.1.0 was successful.
These instructions are located in C:\product\10.1.3.1\OracleAS_1\install\readme.txt for your future reference.

You can view the status of the server with the following command:
C:\product\10.1.3.1\OracleAS_1\opmn\bin\opmnctl status


Access the Oracle SOA Suite 10g Application Server Welcome Page via the following URL:
http://dell:8888


Access the Oracle Enterprise Manager 10g Application Server Control via the following URL:
http://dell:8888/em



Installation Details:

Installation Directory: C:\product\10.1.3.1\OracleAS_1
Installation Type: J2EE Server and SOA Suite
Installed Components: SOA Suite, Oracle Containers for J2EE (OC4J) and Oracle Process Manager and Notification Server (OPMN)
Instance Name: anilpassi.dell
Administrator Username: oc4jadmin

The log file containing the details of Configuration Asistants is located in C:\product\10.1.3.1\OracleAS_1\cfgtoollogs



Documentation
Online documentation for Oracle Application Server is available at:
http://download.oracle.com/docs/cd/B31017-01/index.htm.

In order to keep your system up-to-date we encourage you to regularly check for the latest certification and software updates via Oracle Metalink.


Oracle Metalink (http://metalink.oracle.com) will help you get the most out of your Oracle products by providing access to technical information and assistance from Oracle Support Services, including information about: product availability, certification, product alerts, bug information, patches, technical solutions, logging service requests, and more.



If you need to find more information on Oracle Integration Products please visit (http://otn.oracle.com/products/integration)



You can access the list of ports used by the following command :
C:\product\10.1.3.1\OracleAS_1\opmn\bin\opmnctl status -l


Access the Oracle Web Services Manager through the following URL
http://dell:8888/ccore

Access the Oracle Business Rules Author through the following URL
http://dell:8888/ruleauthor

Access the Oracle Enterprise Service Bus through the following URL
http://dell:8888/esb


Access the Oracle BPEL Process Manager Control through the following URL
http://dell:8888/BPELConsole


Please refer to the following file for a summary of this installation.
This file also contains the URLs for the various OWSM components.

Filename: owsmsetupinfo.txt
Location: C:/product/10.1.3.1/OracleAS_1/install

Install Oracle 11i (11.5.10.2) on Linux

In today’s post I will cover things you need to install Oracle Apps 11i (11.5.10.2) on Linux.

Software
1. Software for Oracle 11i can be downloaded from edelivery.oracle.com(46 zip files) or you can order disks via metalink account.
2. Unzip these files and this should create five directory startCD, oraAppDB, oraApps, oraDB, oraiAS

O. S. Requirement
1. Linux Package : make sure you have ar, gcc, g++, ld, ksh, make, X Display Server
2. Disk Space : 26 GB for Application Tier & 65 GB for Vision Database (31 GB for fresh database). Hence total 57 GB for fresh DB & 91 GB for Vision Instance.
3. If you are installing apps 11.5.10.2 from Staging area you need another 24GB (No need if you are doing install from inserting CD’s on prompt)
4. O.S. User : Create two operating system user, avis11i (Application Tier) & ovis11i (Database Tier) both belonging to group DBA. You can use single user as well for both Application Tier & Database Tier
5. JDK : No need to install JDK 1.4.2 on solaris, Linux or windows as 11i Installer will install it. For other operating system you need to install JDK 1.4.2
6. For full list of RPM’s required on Red Hat Enterprise Linux Visit Metalink Note # 303859.1

Things you must do/know before installation
A) set environment variable LD_ASSUME_KERNEL=2.4.19 for root user
B) gcc -v (Should be of version 3.2.x) For any other version
mv /usr/bin/gcc /usr/bin/gcc.orig
mv /usr/bin/g++ /usr/bin/g++.orig
ln -s /usr/bin/i386-redhat-linux-gcc32 /usr/bin/gcc
ln -s /usr/bin/i386-redhat-linux-g++32 /usr/bin/g++

C) If your installation fail some time restart installation by option restart like
“rapidwiz -restart”
D) If you try to access apps from linux machine from browser other than Mozilla (like KDE)you will get error message that “You have insufficient privileges for current operation”
E) Installer should be started from root user

Starting Installation
1. Go to Staging directory /stage_location/startCD/Disk1/rapidwiz/
2. ./rapidwiz
3. Create base directory under which you wish to install database & apps tier with proper permission (owner) (Five main directory - [SID]appl,[SID]comn,[SID]ora owned by application user (avis11i) & [SID]db, [SID]data owned by database o.s. user (ovis11i) )

Post Install
1. Set environment variable in O.S. user profile
/install_base/[sid]appl/APPSORA.env (For Application Tier User, avis11i)
/install_base/[sid]db/SID_hostname.env (For Application Tier User, ovis11i)

2. For start/stop services of Oracle Apps 11i visit
11i Startup/Shutdown Scripts

Error/Issues during 11i Install
Issue : RW-50004: Error code received when running external process. Check log file for details. Running Database Install Drivers for VIS Database

Check Logsat : $install_base/[sid]db/9.2.0/appsutil/log/[SID]_[hostname]/MMDDHHMM.log
Error while running adlnkoh.sh, log for adlnkoh.sh at $install_base/[sid]db /9.2.0/install/make.log
In make.log file libgcc_s.so : undefined reference to `dl_iterate_phdr@GLIBC_2.2.4`

Fix : This issue is very well explained in Note : 363600.1 ‘dl_iterate_phdr@GLIBC_2.2.4′Error on Linux Running Rapidwiz

References:
303859.1 Requirements for Installing Oracle 9iR2 on RHEL 4
11i Install Guide from Oracle

Installing Oracle Applications 11i

So lets start learning from how to become Oracle Apps DBA . This apps dba training is completely free only thing I am looking is your feedback & what you want to hear more, If you are reading this post first time I will recommend you that you start from first post i.e. from Saturday, 29 July 2006.I hope you as Oracle Apps DBA Understand basic Architecture of Oracle E-Business Suite (If no read my first post ) .
Lets Start with Installation, You can start Installing Apps on Unix, Linux or Windows. I recommend Linux if not then Unix & finally Windows (I find it difficult working on windows as you need additional component to install E-Business Suite ) . For Installation Guide visit Oracle PDF at http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf This E-Business Suite Installation Guide consist of 166 pages & you need to Install all. Read Chapter 1-8 Single User Installation or Two User Installation. As by now you are aware that E-Business Applications Two Tier Database & Application , so first User Oxxxxx is for Database Tier & Second User Axxxxxx for Application Tier. If you are new & Installing it first time better Install everything on Single Machine, Database Under User Oxxxxx and Middle Tier under Axxxxxx.
Then you can Install Oracle Applications by Inserting CD's one after other or by dumping all disks to one location ( Universal Installer will not prompt to insert CD if you staged/dump your CD on Machine it in proper way, Pg 1-12 , page 24 of Guide), If you are Installing Oracle Apps first time, Select Single Node(Also called Single Machine) Installation. Go to Chapter 2, on page 29 of Guide , you will see screen by Screen navigation path for Installation ( Believe me its very simple and just 30 pages all screens so nothing much to read ). After installation forget Chapter 3,4,5 (these are for Advanced Installation Option - Look them once you are comfortable with Simple Instalation) go directly to chapter 6 , Page 141 (This describes how to Check/Access Oracle E-Business Suite 11i Installation) Just 10 pages. So here complete your Oracle 11i Application & that biggest challenge in becoming Oracle Apps DBA . If you face any Issues during Installation post your problem in some Forum or Metalink , else drop a comment on this Post.

How to do Multi Node Installation on Apps 11i ?
If you are comfortable & now want to know how to do multinode Installation for Oracle Applications 11i then follow Chapter 3 (p65- p106) of guide Oracle applications Installation Guide Using Rapid Install Release 11i at http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf


Tomorrow I'll discuss file system & directories which you/dba's/apps dba have Installed today , What oracle application component sits where ? That will be helpful to understand you Oracle Application . Plsssssss leave comments on this post, depending on that I'll get feedback if its useful or am I wasting your & my time .

Happy Learning Oracle Apps DBA.
Free Apps DBA training collaboration

10gR2 patchset 2 is out

For Windows and Linux x86, Oracle Database 10.2.0.3 is available

10.2.0.3 is huge

900M in size for a Linux patch is getting quite big. Expect 2G for HPUX/AIX5L, guess this 2G limit, if reached, is going to be a problem for many users !

10.2.0.3

I successfully installed 10gR2 patchset 2 on my notebook :

SQL> select ACTION,VERSION,COMMENTS from registry$history;

ACTION VERSION COMMENTS
------- ---------- ------------------------------
CPU 10.2.0.2.0 CPUOct2006
UPGRADE 10.2.0.3.0 Upgraded from 10.2.0.2.0

SQL> select COMP_NAME,VERSION,STATUS from dba_registry;
COMP_NAME VERSION STATUS
----------------------------------- ---------- -----------
Oracle Expression Filter 10.2.0.3.0 VALID
Oracle Database Catalog Views 10.2.0.3.0 VALID
Oracle Database Packages and Types 10.2.0.3.0 VALID
Oracle Database Java Packages 10.2.0.3.0 VALID
JServer JAVA Virtual Machine 10.2.0.3.0 VALID
Oracle XDK 10.2.0.3.0 VALID

-ignoreDiskWarning

I am in the process in installing Oracle 10gR2 patch 2 with response file. There is no plenty of disk available, but installing a patch does not require as much space as specified by the runInstaller.

when I start in silent mode, I get :

$ ./runInstaller -responseFile /home/oracle/10202.rsp -silent
Starting Oracle Universal Installer...
-----------------------------------------------------------------------------
You may not have enough space on your drive for a successful install. Do you still want to continue?

Where should I answer yes? There is a secret parameter called -ignoreDiskWarning which does the trick. The parameter is not listed in ./runInstaller -help.

So I installed my 10.2.0.1 + patch 10.2.0.2 and still have 500Mb free. It is ok for Oracle Home. Check your diskspace before using this to avoid filesystem full.

Solaris 10gR2 patchset 2 is out

10.2.0.3 patch is released for various plateforms, like Linux (x86,x86_64,Itanium), Windows (32bits/64bits), Solaris (64 bits) and Z/OS
Patch 5337014

8.1.7 desupport exceptions

In the Critical Patch Update 2007 January Pre-Release Announcement, you may wonder why there is a 8.1.7.4 CPU patch.

The reason is, Oracle 8.1.7.4 is still supported for some application supported by Oracle like Siebel, E-Business and Clinical.

Have a look at Metalink Note 148054.1

Critical Patch Update

The critical patch update for january is released. However, not for every version.

Already in CPU Oct 2006, many versions were delayed. The release date of 10gR1 Tru64 for example was Nov 15, but the note has not been updated for months. 9.2.0.8 Linux was released so late (29 Dec), that the CPU2006OCT-9208 is considered to be CPU2007JAN (patch 5490859). For 10.2.0.3, there is no CPU2007JAN

I applied both 9208-cpu2006oct and 10105-cpu2007jan to my notebook database.

Both complained about not existing XDB schema, but I ignore those (I have no XDB schema). Otherwise it went fine.

I apply the CPU as soon as released for testing purpose. However, applying the CPU as soon as possible in PROD does not apply to most of my customers.

xhost + is a huge security hole

Maybe you have a firewall in your company, only your PC can access the production server, only you have the root password in prod, and your company spend a lot of money in security, but you dare using xhost +.

This is a huge security hole, because it gives anyone access to your X resources, not only your display, but also your mouse and your keyboard, so anyone can read/modify/corrupt what you are typing/clicking. It is a bad habit to use xhost+. Even using xhost +localhost give access to your keyboard to anyone on localhost…

So what else could you use ?

The simplest is probably ssh tunnelling.

lsc@chltlxlsc:~> ssh -X oracle@localhost
Last login: Fri Max 2 10:24:09 2007 from localhost
oracle@chltlxlsc:~> xterm -e true && echo success
success

Another way to do this is to use X cookies.

lsc@chltlxlsc1:~> xauth extract ~/my-x-cookie $DISPLAY<
lsc@chltlxlsc1:~> setfacl -m u:oracle:r ~/my-x-cookie
lsc@chltlxlsc1:~> su - oracle -c "DISPLAY=$DISPLAY bash"
Password:
oracle@chltlxlsc1:~> xterm -e true && echo success
Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified

xterm Xt error: Can't open display: :0.0
oracle@chltlxlsc1:~> xauth merge ~lsc/my-x-cookie
xauth: creating new authority file ~oracle/.Xauthority
oracle@chltlxlsc1:~> xterm -e true && echo success
success

No need to type all. Here is my alias

alias oracle='
xauth extract $HOME/my-x-cookie $DISPLAY;
setfacl -m u:oracle:r $HOME/my-x-cookie;
su - oracle -c "export DISPLAY=$DISPLAY;
xauth merge $HOME/my-x-cookie;
bash"'

CPU2007Apr

I just downloaded and installed the Critical Patch Update April 2007

$ lsnrctl stop
...
The command completed successfully
$ sqlplus / as sysdba
SQL> shutdown immediate
...
ORACLE instance shut down.
SQL> quit
$ cd /tmp/5901891
$ ORACLE_HOME/OPatch/opatch apply
... Finish at Wed Apr 18 10:28:17 CEST 2007
$ lsnrctl start
...
The command completed successfully
$ sqlplus / as sysdba
SQL> startup
...
Database opened.
SQL> @?/cpu/CPUApr2007/catcpu
SQL> @?/rdbms/admin/utlrp

The logfile of opatch is $ORACLE_HOME/cfgtoollogs/opatch/opatchdate.log and the logfile of the catcpu is APPLY_sid_date.log. ORA-02303 can be safely ignored.

SQL> select * from dba_registry_history

ACTION_TIME
------------------------------
ACTION
------------------------------
NAMESPACE
------------------------------
VERSION
------------------------------
ID
----------
COMMENTS
------------------------------
18-APR-07 10.38.09.565465 AM
CPU
SERVER
10.2.0.3.0
5901891
CPUApr2007

SQL> select count(*) from dba_objects where status='INVALID';

COUNT(*)
----------
0

Successfully applied

10.1.0.5 is the terminal patchset

I just read on the General Notes For Oracle Database - Enterprise Edition in Metalink that 10.1.0.5 is the terminal patchset for 10gR1

Create your database with dbca

With dbca you can fasten the procedure of creating databases in your company. You can also run this in silent mode and create exactly the database you want, with your redo/undo size, with your parameters settings. You create the template once, and use it many times. Fast and easy :-D

I have one database which I created with SQL*PLUS called LSC01.

1) Create template lsc-template
dbca
–> Manage Templates
–> Create a database template
–> from an existing database (structure as well as data)
–> LSC01
–> lsc-template
–> convert the file locations to use OFA structure
This takes some place on disk and will speed up database creation. Technically speaking, it is doing a compressed backup with RMAN that will be restore, and restore is way faster than create database

2) Create database LSC99 in silent mode or progressOnly mode.
dbca -silent -createDatabase -templateName lsc-template.dbc -gdbName LSC99.lcsys.ch

It took me only two minutes to create my database on my notebook !

Try it ! Of course I expect comments on this post

installing OID 10.1.4.2 Preview 1

Download oracle-oid-10.1.4.2.0-1.0.i386.rpm
Download oracle-xe-univ-10.2.0.1-1.0.i386.rpm

Install the rpm

# rpm -i oracle-*.i386.rpm

In SLES 10, there is no /bin/cut, let’s create a link as root to avoid a mistake when running config-oid.sh

# ln -s /usr/bin/cut /bin/cut

Run the configure script as root

# /etc/init.d/oracle-oid configure

That’s all folks! It created an Oracle XE 10gR2 database, and configured a running database. Excellent!

LDAP Server is running and configured.

$ ldapsearch cn=orcladmin dn
cn=orcladmin, cn=Users, dc=com

There is a nice video to run on linux : oracleauthenticationservices_demo.vvl
Save the file, set the display, then

$ chmod +x oracleauthenticationservices_demo.vvl
$ ./oracleauthenticationservices_demo.vvl

It shows also how to use Oracle LDAP Server OID to identify your Linux users with the preview of Oracle Authentication Service