LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 12-20-2007, 12:59 AM   #1
reddysubba
LQ Newbie
 
Registered: May 2007
Posts: 2

Rep: Reputation: 0
installing oracle 10g


hi


how to install oracle 10g on linux 4AS


iam facing problems while installing please do the neddfull


Thanks and Regards

Subbareddy
 
Old 12-20-2007, 01:20 AM   #2
yusufs
Member
 
Registered: Oct 2007
Posts: 162

Rep: Reputation: 30
Quote:
Originally Posted by reddysubba View Post
hi


how to install oracle 10g on linux 4AS


iam facing problems while installing please do the neddfull


Thanks and Regards

Subbareddy


Hai,

Let us know the error.. complete documentation with screenshots available online ..google for the same...


Yusuf
 
Old 12-27-2007, 08:09 AM   #3
reddysubba
LQ Newbie
 
Registered: May 2007
Posts: 2

Original Poster
Rep: Reputation: 0
TNS error dont have permissions to logon
 
Old 12-29-2007, 01:49 AM   #4
yusufs
Member
 
Registered: Oct 2007
Posts: 162

Rep: Reputation: 30
Quote:
Originally Posted by reddysubba View Post
TNS error dont have permissions to logon


Reddy,

if am not wrong, is that an installation error.. which point you are getting this error.. Does the OUI installer did that successfully ?

let me know
Yusuf
 
Old 01-03-2009, 06:21 AM   #5
patel_nainesh222
LQ Newbie
 
Registered: Jul 2008
Posts: 4

Rep: Reputation: 0
Smile Installing Oracle10g on RHEL4

Installation of Oracle 10g Database Enterprise Edition on RHEL4

1. When installing RHEL 4, Select Automatic Partition Method in Disk Partition Which will use whole Hard Disk Space.

2. Choose “EVERYTHING”in Software Selection Window.

Kernel Version Shuould Be as Below :

# uname -r
2.6.9-22.ELsmp
I use RHEL4 Update 6, My Kernel Version is :
# uname -r
2.6.9-67.ELsmp
Required package versions (or later):
binutils-2.15.92.0.2-10.EL4
compat-db-4.1.25-9
control-center-2.8.0-12
gcc-3.4.3-9.EL4
gcc-c++-3.4.3-9.EL4
glibc-2.3.4-2
glibc-common-2.3.4-2
gnome-libs-1.4.1.2.90-44.1
libstdc++-3.4.3-9.EL4
libstdc++-devel-3.4.3-9.EL4
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
xscreensaver-4.18-5.rhel4.2
libaio-0.3.96
These Packages are already there if you are using RHEL4 update 6, so Don't worry about that, if There might be something wrong during Installation you can check this.
To verify that your system meets the minimum requirements for an Oracle Database 10g Release 2 database, log in as root and run the commands below.
To check the amount of RAM and swap space available, run this:
# grep MemTotal /proc/meminfo
MemTotal: 1034680 kB
# grep SwapTotal /proc/meminfo
SwapTotal: 1534196 kB
The minimum RAM required is 1024MB, and the minimum required swap space is 1GB. Swap space should be twice the amount of RAM for systems with 2GB of RAM or less and between one and two times the amount of RAM for systems with more than 2GB.
You also need 2.5GB of available disk space for the Oracle Database 10g Release 2 software and another 1.2GB for the database. The /tmp directory needs at least 400MB of free space. To check the available disk space on your system, run the following command:
# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 6.8G 1.3G 5.2G 20% /
/dev/sda1 99M 17M 77M 18% /boot
The example shows that the /tmp directory does not have its own filesystem. (It's part of the root filesystem for this guide.) With 5.2 GB available, the root filesystem has just enough space for the installation (2.5 + 1.2 + 0.4 = 4.1GB) with a little room left over.
Minimum Space Requirement for Oracle 10g Database Enterprise Edition is 5 GB.


3. Create the Oracle Groups and User Account
Next, create the Linux groups and user account that will be used to install and maintain the Oracle Database 10g Release 2 software. The user account will be called oracle, and the groups will be oinstall and dba. Execute the following commands as root:

# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g oinstall -G dba oracle
# id oracle
uid=501(oracle) gid=502(oinstall) groups=502(oinstall),503(dba)
Set the password on the oracle account:
# passwd oracle
Changing password for user oracle.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.


4. Create Directories
Now create directories to store the Oracle Database 10g Release 2 software and the database files. This guide adheres to the Optimal Flexible Architecture (OFA) for the naming conventions used in creating the directory structure.
The following assumes that the directories are being created in the root filesystem. This is done for the sake of simplicity and is not recommended as a general practice. These directories would normally be created as separate filesystems.

Issue the following commands as root:
# mkdir -p /u01/app/oracle
# chown -R oracleinstall /u01/app/oracle
# chmod -R 775 /u01/app/oracle


5. Configuring the Linux Kernel Parameters
The Linux kernel is a wonderful thing. Unlike most other *NIX systems, Linux allows modification of most kernel parameters while the system is up and running. There's no need to reboot the system after making kernel parameter changes. Oracle Database 10g Release 2 requires the kernel parameter settings shown below. The values given are minimums, so if your system uses a larger value, don't change it.
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
If you're following along and have just installed Linux, the kernel parameters will all be at their default values and you can just cut and paste the following commands while logged in as root.
cat >> /etc/sysctl.conf <<EOF
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
EOF
/sbin/sysctl -p
Output after /sbin/sysctl -p should be :
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
Run the following commands as root to verify your settings:
/sbin/sysctl -a | grep shm
/sbin/sysctl -a | grep sem
/sbin/sysctl -a | grep file-max
/sbin/sysctl -a | grep ip_local_port_range
/sbin/sysctl -a | grep rmem_default
/sbin/sysctl -a | grep rmem_max
/sbin/sysctl -a | grep wmem_default
/sbin/sysctl -a | grep wmem_max
Output of these commands should be :
# /sbin/sysctl -a | grep shm
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shm-use-bigpages = 0
# /sbin/sysctl -a | grep sem
kernel.sem = 250 32000 100 128
# /sbin/sysctl -a | grep file-max
fs.file-max = 65536
# /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 1024 65000
# /sbin/sysctl -a | grep rmem_default
net.core.rmem_default = 262144
# /sbin/sysctl -a | grep rmem_max
net.core.rmem_max = 262144
# /sbin/sysctl -a | grep wmem_default
net.core.wmem_default = 262144
# /sbin/sysctl -a | grep wmem_max
net.core.wmem_max = 262144


6. Setting Shell Limits for the oracle User
Oracle recommends setting limits on the number of processes and open files each Linux account may use. To make these changes, cut and paste the following commands as root:
cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF
cat >> /etc/pam.d/login <<EOF
session required /lib/security/pam_limits.so
EOF
For RHEL4,use the following:
cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF
cat >> /etc/csh.login <<EOF
if ( \$USER == "oracle" ) then
limit maxproc 16384
limit descriptors 65536
umask 022
endif
EOF


7. Install JDK-1.7.0
DO NOT RESTART COMPUTER FROM STEP 8 to 15 :
8. Installing Oracle
Extract the zip file to /tmp
$ cd database
Start the Oracle Universal Installer.
$ ./runInstaller
1.Select Installation Method
Select Basic Installation
Oracle Home Location: /u01/app/oracle/product/10.2.0/db_1
Installation Type: Enterprise Edition (1.3GB)
UNIX DBA Group: oinstall
Make sure Create Starter Database is checked
Global Database Name: demo1
Enter the Database Password and Confirm Password
Click on Next
2.Specify Inventory Directory and Credentials
Inventory Directory: /u01/app/oracle/oraInventory
Operating System group name: oinstall
Click on Next
3.Product-specific Prerequisite Checks
If you've been following the steps in this guide, all the checks should pass without difficulty. If one or more checks fail, correct the problem before proceeding.
Click on Next
4.Summary
A summary of the products being installed is presented.
Click on Install.
5.Configuration Assistants
The Oracle Net, Oracle Database, and iSQL*Plus configuration assistants will run automatically
6.Execute Configuration Scripts
At the end of the installation, a pop up window will appear indicating scripts that need to be run as root. Login as root and run the indicated scripts.
Click on OK when finished.
7.End of Installation
Make note of the URLs presented in the summary, and click on Exit when ready.


8.Congratulations! Your new Oracle Database 10g Release 2 database is up and ready for use.


9. Setting Environment Variables
Log into Linux as oracle. Set the environment.
Set the Oracle environment variables:
$ . oraenv
ORACLE_SID = [oracle] ? demo1


10. Setting Global Variables
Edit File /etc/Profile
Add Following Lines at The End of File
export ORACLE_SID=demo1
export ORACLE_HOME=/u01/app/product/oracle/10.2.0/db_1
export PATH=$PATH:/u01/app/product/oracle/10.2.0/db_1/bin


11. Edit Some configuration Files
Once the instance is created, edit the "/etc/oratab" file setting the restart flag for each instance to 'Y':
demo1:/u01/app/oracle/product/10.2.0:Y


12. Creating Oracle Service
Next, create a file called "/etc/init.d/dbora" as the root user, containing the following.

#-------------START OF FILE----------------------
#!/bin/sh
#
# /etc/rc.d/init.d/oracle
# Description: Starts and stops the Oracle database and listeners
# See how we were called.
case "$1" in
start)
echo -n "Starting Oracle Databases: "
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
su - oracle -c dbstart >> /var/log/oracle
echo "Done."
echo -n "Starting Oracle Listeners: "
su - oracle -c "lsnrctl start" >> /var/log/oracle
echo -n "Starting Enterprise Manager Console: "
su - oracle -c "emctl start dbconsole" >> /var/log/oracle
echo "Starting iSQLPlus Console: "
su - oracle -c "isqlplusctl start" >> /var/log/oracle
echo "Done."
echo ""
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
stop)
echo -n "Shutting Down Oracle Listeners: "
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Shutting Down Oracle Databases as part of system down." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
su - oracle -c "lsnrctl stop" >> /var/log/oracle
su - oracle -c "emctl stop dbconsole" >> /var/log/oracle
su - oracle -c "isqlplusctl stop" >> /var/log/oracle
echo "Done."
rm -f /var/lock/subsys/oracle
echo -n "Shutting Down Oracle Databases: "
su - oracle -c dbshut >> /var/log/oracle
echo "Done."
echo ""
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
;;
restart)
echo -n "Restarting Oracle Databases: "
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Restarting Oracle Databases as part of system up." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
su - oracle -c dbshut >> /var/log/oracle
su - oracle -c dbstart >> /var/log/oracle
echo "Done."
echo -n "Restarting Oracle Listeners: "
su - oracle -c "lsnrctl stop" >> /var/log/oracle
su - oracle -c "emctl stop dbconsole" >> /var/log/oracle
su - oracle -c "isqlplusctl stop" >> /var/log/oracle
su - oracle -c "lsnrctl start" >> /var/log/oracle
su - oracle -c "emctl start dbconsole" >> /var/log/oracle
# echo "Starting iSQLPlus Console: "
su - oracle -c "isqlplusctl start" >> /var/log/oracle
echo "Done."
echo ""
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
*)
echo "Usage: oracle {start|stop|restart}"
exit 1
esac
#---------------------END OF FILE-----------------------


13. Run Following Commands for Service Integration
chmod 750 /etc/init.d/dbora
chkconfig --level 345 dbora on
$ ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
# Shutdown Oracle Database when Halting
$ ln -s /etc/init.d/dbora /etc/rc.d/rc6.d/K01dbora
# Shutdown Oracle Database when Rebooting


14. Edit /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora File Should be Like this :
#-----------START OF FILE-----------------
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = demo1)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(SID_NAME = demo1)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = RHEL4)(PORT = 1521))
)
)
#-----------END OF FILE----------------


15. Edit /u01/app/oracle/product/10.2.0/db_1/bin/dbstart
Edit the Line :
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
To :
ORACLE_HOME_LISTNER=/u01/app/oracle/product/10.2.0/db_1


16. Edit /u01/app/oracle/product/10.2.0/db_1/dbs/init.ora
Edit the Line :
db_name=DEFAULT
To :
db_name=demo1


17. Edit /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
#-----------START OF FILE------------------
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DEMO1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RHEL4)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = demo1)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
#-------------END OF FILE-------------------


18. Edit /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
#-----------START OF FILE------------------
# sqlnet.ora File: /u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
#-------------END OF FILE-------------------


19. Steps to Confirm Proper Operation of Oracle Database After Rebooting
Output of Command :
$ lsnrctl status
(should be)
--------------
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 13-DEC-2008 16:39:24
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 13-DEC-2008 16:25:43
Uptime 0 days 0 hr. 13 min. 40 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RHEL4)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "demo1" has 1 instance(s).
Instance "demo1", status READY, has 1 handler(s) for this service...
Service "demo1XDB" has 1 instance(s).
Instance "demo1", status READY, has 1 handler(s) for this service...
Service "demo1_XPT" has 1 instance(s).
Instance "demo1", status READY, has 1 handler(s) for this service...
The command completed successfully
There Must be some READY Instances of demo1 in output of “lsnrctl status”
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Installing Oracle 10g kponenation Slackware 3 01-03-2009 09:57 AM
Help installing Oracle 9i/10g on RedHat? Joncamp Linux - Software 1 03-16-2007 11:09 AM
Error when installing Oracle 10G on FC4 fvillavi Fedora 4 09-16-2005 08:32 PM
Installing oracle 10g on FC 2 qmon2002 Fedora 6 10-05-2004 05:04 AM
Installing Oracle 10g on Linux lardelbow Linux - Software 6 09-29-2004 07:52 AM


All times are GMT -5. The time now is 08:27 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration