Oracle BI EE Installation - Business Intelligence Applications

does anybody have Solaris 9 sparc 64 BI EE installation experience?
1. Should it be installed under oracle software owner account or a separate one? In installation manual they say - "make it writable to a group".
2. Installation manual says - install only under bash. Should we change default oracle shell to bash (i don't like the idea) or SHELL= suffice?
3. How about oracle client - install doc says it should be installed before BI EE. Should we set ORACLE_HOME or setting to OAS 10.1.3 is ok? How about path classpath, ld_library_path? What do we need in LANG, NLS_LANG, ORA_NLS10?
4. How about java_home, jdk_home, jre_home?
5. Are ar, ld, make paths hardcoded?
Thnx
Michael 

Handle this install like a normal Linux/UNIX install
1. BI EE should be installed like the Oracle DB into a single "oracle" owner and gorup.
2. Install under bash
3. Set the Oracle client up as normal. Make sure that when you are logged in as the Oracle user that you can use SQL*Plus to connect
4. BI EE needs JDK 1.5.x. The installer will take this as a prompted variable and hardcode it where needed.
5. No sure about that one

Related

ORACLE8i & OAS on Sun Solaris

I have a problem with Oracle Installation on Sun Solaris.
First I Install Oracle 8.1.6 on user Oracle.
My database is running. Then I Install OAS 3.0.8.2 on different home but on the same user Oracle. After this installation my oas is runnning by my database can't start. From the message i know that the problem is on Oracle_Home variable. Because now my database is connecting to OAS home not Oracle8i home.
When i open .profile of oracle user i see that there is an addition command to call owsenv_bsh.sh and in this script there is a line that point to OAS oracle Home. I thinks this line have overwrite my existing Oracle_Home for Database.
Can anybody help me to solve this problem, because i've been try to solve this problem for a week.
My question should I Install OAS and Database on different Sun Users. And How can i make multiple home in Sun Solaris Like On Windows NT.
Thanks So Much For Helping me.
Best Regards
Yanto 
Hi Yanto,
I suspect everything is OK with both OAS AND the 8.1.6 install. It's just a question of setting the correct environment variables dependent on what you want to do (i.e use the DB or use OAS)
Firstly - you should only use the oracle user for installing oracle software, and starting/stopping stuff. i.e. the DB, listeners, OAS etc... Create other users to do you development type stuff...
With that in mind, I would do the following:
1. comment out the 'owsenv_bsh.sh' line in oracle users .profile
2. I assume all you 8.1.6 env variables like ORACLE_BASE, ORACLE_HOME etc are also in .profile - so whenever you start a shell you will be in 'Oracle 8.1.6' env.
3. if you need to start/stop OAS run the owsenv_bsh.sh script by hand then you'll be in the 'OAS env'. Put the script it in your PATH to make starting it easier.
4. if you need to go back to 'Oracle 8.1.6' env then run .profile again (i.e. '. .profile') or start another shell session.
Life's a bitch with two oracle homes :) I think the latest version of OAS - (4.0.8.2) allows you to install into the same oracle home... maybe you should try that. Or maybe your better off going to oracle's replacement for OAS -> iAS internet Application Server.
Mike 
Hi Mike,
Thanks alot for your help,
now my database is running again.
I am new in Sun Solaris OS, Now I make an Internet Based Application Using Oracle8i, OAS 4.0.8.2 and Forms6i running om Sun Enterprise 3500 with 2 GB memory. But according to my friends experience, I will have problem with the performance.
For any body in this forum, what do you thinks about Using IE5 Native or IE5/Netscape+Jinitiator will be faster for access my application architecture from browser.
Byee
Yanto :)
null

De-install oracle 10g

Hi All,
Though its a very poor Question, but is there any way i can deinstall (remove) oracle10g database using GUI.
I don't wanna remove it directly by removing the home directory, oratab & oraInst.loc file.
Any ideas........
Thanks & Regards,
MB 
Adding more.....Am running it on Unix server.
Regards,
MB 
Use the same GUI you used at installation time, the Oracle Universal Installer.
Werner 
Hi Werner,
Am using the same GUI, but once i select the Installed Products ---> Select the installed components ---->My REMOVE remains hidden ....
Please advice,
Thanks !!!
MB 
Look for the deinstall products button and make sure you mark with the checkbox the products you want to deinstall.
Deleting directly from OS is not advisable, as it will leave invalid entries at the OUI inventory. However, it could be done if this is the only OracleHome installed on your computer. A procedure can be stated, it involves deleting the Oracle Home and the OUI Inventory, and if you are working in a windows environment, the registry entries too. Otherwise it is not recommended, nor supported.
Regards. 
I dont find deinstall button ,instead i found Install products and i check the box for installed oracle , but even stilll the remove button remains hidden.
But anyways i did it manually now by removing the directories.
Thanks & Regards,
MB 
Hi,
I have the same problem but also a little more complicate.
My system is based under Solaris 8 and no X-Window can be run.
How can I unistall Oracle database from my system? 
Remove the oracle directories manually. As i did them manually too :), though its not been recommended to do it in this way.
Cheers !!!
MB 
Now, let me ask you something. How were you successful in installing if you didn't have an Xterminal environment ready? The only possiblitiy is that you either had an Xterm which is no longer available or you performed a silent install. Either way you can setup a XServer at your pc using open software, and you can perform software maintenance from there.
Having an Xterminal graphical environment for Installing or maintaining software is a must. You could do a silent install, but you must have the response file first. You could deinstall by recursevly deleting folders and files, but it is not a good practice. It could work, considering you only have one Oracle Home installed and you want to purge it, restarting installation right from the very start if you require it.
If you want to take this approach it's ok, but you must delete also the OUI repository, otherwise the oracle home reference with the list of available products will not be consistent with what you physically have.
~ Madrid. 
Hi,
I have the same problem but also a little more
complicate.
My system is based under Solaris 8 and no X-Window
can be run.
How can I unistall Oracle database from my system?Please clarify ... no X11 can be run in your shop at all, or no X11 can be run on the Solaris box.
It makes a huge difference. You see, the Oracle program wants an X11 server to display output (unless you use Silent Install and have installed 10g or higher). However, that X11 server does not need to be on the Solaris machine.
I often install on headless Solaris or Linux and use a WIndows-based X11 server as the display. Suitable WIndows-based X11 servers are Hummingbird eXceed (commercial X11) or cygwin X (free open source system, http://www.cygwin.com) 
Remove the oracle directories manually. As i did them
manually too :), though its not been recommended to do it in this way.Even you removed oracle home manually , entry for this oracle home and installed product will remain Oracle Inventory. If this is the only oracle home you have on server/PC then remove oracle inventory and oratab as well.
Virag Sharma

Mobile Server 11g Install Issue

I am trying to install the 11g Mobile Server on Linux (v5 64 bit) and it gives an error saying "Error during pre-requisite calculation". I don't see any information where it indicates what prerequisite check is failing though. This server has an operating Oracle 11g db on it and I was using the same oracle_home. I also installed glassfish as it appeared that the new mobile server will need that (and that is up and running fine using port 8070 for http). As far as I can tell from the install docs, this setup should meet all the prerequisites.
Does anyone know where I can find which one it thinks is missing or if there might be some other common things that might not be so obvious from the install document that I should check?
Thanks 
Sounds like an OUI issue. What flavor of linux are you putting this on? 
This is a test server with CentOS 5.4 (2.6.18-164.el5). Is this something where it will only install under Oracle Enterprise Linux? 
No, I don't believe so. The OUI checker might not have your version listed. It's an OUI issue. I can dig a little bit, but I would recommend looking up similar issues with other Oracle products on CentOS. 
OK - so I finally got this set. I really think the Installation Guide is very poor as it relates to setting this up. First off, it had nothing to do with the OS, it was related the the install location and glassfish. Instead of installing into the normal oracle_home, the installation needs to go into the glassfish install location (in my case /opt/oracle/glassfish3/glassfish). When you select that location the installer warns you that this is a bad choice as it expects an empty directory. This warning seems particularly bad since by definition, if you need to select the glasfish install location, there are going to be other files and directories there.
Then to run the repwizard, you need to have a MOBILE_HOME set, which, again I don't think is specified in the install guide. In fact, for the MDK it says that MOBILE_HOME should be $ORACLE_HOME/mobile/sdk, but if you set it to that then you can't run the repwizard. I needed to set that to the same install location (/opt/oracle/glassfish3/glassfish).
Its not clear to me if there is some other way I should have been able to configure this, but I can't imagine how trying to follow the installation guide would ever result in a successful installation. The only line that even hints at this is: "2. On the Specify Home screen, enter the name and path where you want to install Oracle Database Mobile Server, which cannot include any spaces. You should install Oracle Database Mobile Server into a new or existing Oracle Home. When you use OracleAS, WebLogic, or Glassfish as your middle-tier, install Oracle Database Mobile Server into the same Oracle Home where the application server is installed."

Oracle 11g installer question

I am using the installer on AIX.  Whenever I start this,  it only directs me to installing products.  I would only like to see what products I have installed so far using the installer for UNIX.   I am specifically looking to see if the ODBC for UNIX (via Instalnt Client is installed).  How do I know see what products are installed in my Oracle Home ? thanks in advance
When you launch installer, you should get a prompt to change/select an ORACLE_HOME, upon which it should show you whats installed. Can you post a screenshot ?
I do not see any options to view what is in the desired oracle home.  The old installer had a tab that you could view what is installed.  This is the 11g installer.  It is running on an AIX server using reflections as the x windows emulator
It looks like you are running the installer from the client media. Instead, navigate to $ORACLE_HOME/oui/bin and you should find an installer executable there - launch that instead.
That solved it !   thanks

Oracle installation

Hi team,
I know this is very weired and I have tried to resolve by myself.
But I could not .
I have installed, oracle 8.i enterprise version on my lap top .
The operating system is windows 2000 professional. It is working
fine.
Now, I a trying to install the same software on to my desktop, I
could not install it.
As soon as I keep the cd in cd rom drive, the initial screen is
displyed.Then I select "Install/Deinstall oracle products"
option.Nothing is happening.
I know you guys knows more than me as I am not oracle
professional.
I hope that, there will be some light on this issue.
Raghu 
Heyy same with me...
u know i have windows ME at ma home so could i install oracle 8i on ma home desk top??? plzz help me asap. 
You must read carefully the following steps here. If you previously installed any Oracle's products on your machine, I strongly recommend you to clean up thoroughly before install the new products.
==================================================================================
The easiest way to remove ALL traces of Oracle software, for an 8i or 9i installation, is:
(1) Using regedit, remove the key \\HKEY_LOCAL_MACHINE\\SOFTWARE\ORACLE.
(2) Remove all the Oracle services (usually called Ora-something) from \\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
(3) Go to the ORACLE_HOME directory (usually C:\Oracle\Ora81). Go to the BIN directory beneath this. Rename the file OCIW32.DLL to something like OCIW32.OLD.
(4) Reboot your box.
(5) Once you have logged on again, delete the directories C:\Program Files\Oracle and C:\Oracle.
(6) Right-click on My Computer, select Properties->Environment. Edit the environmental variable PATH to remove all refernces to files in the two directories you have just deleted.
(7) Remove the Oracle folders from your Start menu.
*** Obviously, using regedit on your machine always entails risks, and I won't be held responsible if you end up trashing your system. However, the above procedure is one I have used many times with complete success. You have been warned! ;) ***
As to logging on, the "standard" Oracle accounts are:
SYS/change_on_install (SYSDBA - database owner)
SYSTEM/manager (Owns various VIEWs and utility PACKAGEs)
and (optionally):
SCOTT/tiger (Training account containing some sample tables)
If you're using PO8i on the local machine, you shouldn't need to worry about setting up NET*8 (Oracle's networking protocols)
==================================================================================
The solution of making a local copy of the installation CD on
the hard disk and renameing symcjit.dll to symcjit.old does
work to allow installation of Oracle Client 8.1.7 on a Pentium 4
This function is useful and you can find two file to rename
==================================================================================
Windows ME
Solution to the installation of Oraclei8.1.7 PE in Windows Millennium
Oracle does not support installing version 8.1.7 PE into
Windows Millennium.
As an unsupported workaround, you may add the following line
to the [compatibility95] section of win.ini prior to
installation:
Jrew=0x00080000
After setup is complete, Oracle will recommend a reboot.
There is one additional step necessary prior to reboot;
Oracle may add a non-standard path statement to the
autoexec.bat file. Please modify this SET PATH
statement to use short-filenames if you find a quoted
LFN string represented as part of the path. You can
confirm that the path was merged successfully into the
registry after reboot by examining the PATH variable
in the registry at
HKLM\System\CurrentControlSet\Control\SessionManager\Environment
Symptoms of a missing Oracle path statement in the registry are that Net8 Easy Config will not launch.
Please note that Oracle does not support the use of this
product in Windows ME, but have authorized these workarounds
for testing purposes only.
===================================================================================
Windows XP Home Edition
Oracle 8i is not certified on windows XP. Even if yes, it must be Windows XP Professional.
You can install Oracle8i on windows XP Home Edition, try like this:
1 - Copy your Oracle CD into hard disk in your
machine. For example Copy from oracle8i CD into C:\Oracle\ ...
2 - Search the two files named Symcjit.dll on the D drive (where you have copied Oracle8i. You can found them in (example):
C:\Oracle\stage\Components\oracle.swd.jre\1.1.7.30\1
\DataFiles\Expanded\jre\win32\bin\symcjit.dll
3 - Rename this file (Example): symcjit_back.dll (make sure to find two files and rename them)
4 - Execute the Oracle setup.exe from C:\Oracle\setup.exe
=====================================================================================
When Oracle 8i dies on the install or the installer hangs, here is the fix for this, make sure that you have Service Pack 2 installed.
1. \JRE\1.3.1\ From Sun. (You can download java program at http://java.sun.com/products/jdk/1.1/jre/download-jre-windows.html)
2. Install the java file.
There is also a problem in the installation disk.
3. Make a copy of the Oracle 8i disk on the local hard disk.
4. Do a search for the two files called symcjit.dll and rename them for example: symcjit.old.
5. Install Oracle from the win32 directory.
======================================================================================
PLEASE NOTE THAT ORACLE DOESN'T SUPPORT THE USE OF THOSE PRODUCTS IN SOME WINDOWS, BUT HAVE AUTHORIZED THESE WORKAROUNDS FOR TESTING PURPOSES ONLY
Best Regards,
Beau Leo 
Hi Leo,
I tried to work out you're inatructiona but i could'nt install it. I have windows XP home edition. I renamed the file "Symcjit.dll" and then tried re-installing.
I'm getting an error while installing is "Invalid staging area. There are no top level componets for windows NT available for install from this staging area.
I would appreciate, if you can help me installation.
Thanks,
venu. 
I am requesting your help.I am not an oracle professional.I installed oracle8i personal edition for windows 98 release 8.1.5 for educational purposes on my home computer. But I cannot start up the database.Asking for a password to start up the database. This is my first attempt to install an oracle product.I am really appreciated your help if any of you would help me with the problem
Thank you
sudha 
Dear all,
I have windows 2000 professional running on my system and any time I try to install Oracle 10g, an error appears;
"Invalid staging area. There are no top level componets for windows NT available for install from this staging area"
Please help me out.
Ositadimma Ugwu
Marina, Lagos- Nigeria
Question --- It's Dec 2005 now. Can Oracle 10g be installed on Windows XP HOME Edition? 
As far as n know Oracle 10 does not support the operating systems Win Me and Win XP Home,because of the reason that XP home doesn`t support networking as stongley as Win XP Professional.

Categories

Resources