Sunday, October 28, 2012

How to Start oracel Database 11gR 2 manually on Linux

Hi Folks,


Steps to start  the Oracle Database 11G R2 manually.

Follow the Steps in each terminal as highlighted below.

Step1:  Starting DB
















Step 2:  Starting Listener








You will see the following once excuted the above commands

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 28-OCT-2012 11:30:22
Copyright (c) 1991, 2009, Oracle.  All rights reserved.
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/Venkat/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Venkat)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Venkat)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                28-OCT-2012 11:30:23
Uptime                    0 days 0 hr. 0 min. 1 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/Venkat/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Venkat)(PORT=1521)))
The listener supports no services
The command completed successfully


Step 3 :  Starting DBconsole










In the Next Post we will see how to Install RCU.



Thanks
Venkat


 

How to Install OBIEE 11.1.1.1.6 on Linux OEL5 update 8 -- Part -6

Installing the Oracle database on  OEL 5.8 update :


Before  going ahead with installation do the follwng steps :


a) SU As Root and Create Directories to Install the oracle database

 Make Oracle directories

 mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
 chown -R oracle:oinstall /u01/app
 chmod -R 775 /u01/app

b) Add xhost - the hostname

xhost +Venkat
c) Set up Oracle Profile

Login as Oracle and do   vi ~/.bash_profile 

Your bash_profile will be opned. Press insert and enter the highlighted text as below with your environment specific


# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=Venkat; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH


LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
 
"~/.bash_profile" 34L, 909C   


I was planning to give OracleSID name as DB11g so I gave that name

Oracle_HOSTNAME = venkat (My host name).

If you are not sure what you host name. just do hostname in teh terminal. it will gove your host name

d)
DISPLAY=<machine-name>:0.0; export DISPLAY

I copied my datbase installation files to the oracle Home folder. Run the Installer as follows.


























Before 100 %  it will ask you to excute some shell scripts.

Su as ROOT and you have to the do the following at the command prompt

1) cd /u01/app/oraInventory/orainstRoot.sh
2)/u01/app/oracle/product/11.2.0/db_1/root.sh


After Running the Shell Scripts. We have to do the following steps





















































Database will create and once it is done you will see th epassword management Screen. lock (or) unlock schemas you want to do and clcik ok.


That's it you are done with oracle database installation



Saturday, October 20, 2012

How to Install OBIEE 11.1.1.1.6 on Linux OEL5 update 8 -- Part -5

Installing a common shared between host and the VM ware OS ( OEL5 update 8).

Setting  a  shared folder between host and vmware os willhlp us to transfer files withen two OS.


Click on Vmware machine setting and click on options. click on shared folders and Select Always Enabled. Create a folder in the host system and  Add the path to the folder as shown below.




In the next post we will see  how to installl Oracle database 11g R2 on Linux.

Thanks
Venkat