Topic: Oracle on Unix/Linux >> Oracle 10g Installation problem (FC4)
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Oracle 10g Installation problem (FC4) |
| sathish |
Posted: Jun 19, 2006 03:04:12 AM |
Total Post: 47
Joined: Mar, 2006
|
Here i give the full installation steps i tried . but i unable to run successfully , pls give the guidlines to install 10g in Fedoracore core 4
OS - linux Fedora Core4
1. Kernel parameters
File - /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
#semaphores: semmsi, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
/sbin/sysctl -p
----------------------------
2. File - /etc/security/limits/conf
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
3.File - /etc/pam.d/login
session required /lib/security/pam_limits.so
4.File - /etc/selinux/config
selinux = disabled
5. group - oinstall
user - oracle created
6. Installed Path /u01/app/oracle/product/10.1.0/db_1
chown -R oracle.oinstall /u01
7. oracle user settings
/usr/share/doc/bash-3.0/startup-files/Bash_profile
(Is this path correct?)
Bash_profile file
-----------------
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1;export ORACLE_HOME
ORACLE_SID=ORCL; 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/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
if [ $USER = \"oracle\" ]; then
if [ $SHELL = \"/bin/ksh\" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
----------------------------------
8./etc/redhat-release
9. ./runInstaller
10. OUI
Destination
orainstRoot.sh—as root from the Oracle inventory directory
/home/oracle/oraInventory/orainstRoot.sh
Name : dbca
path : /u01/app/oracle/product/10.1.0/db_1
Selection Type :Enterprise Edition
Select Database Configuration : Create started database(General purpose)
Specify database configuration option :
Globaldatabase name :orcl.localhost.localdomain SID : ORCL
(Create database with sample schema)
select Database management option
Specify database File storage option
specify backup/recovery option
specify database schema passwords
summary
install
configuration assistant
/u01/app/oracle/product/10.1.0/db_1/sh root.sh
end of installation
11. Post Installation
File - /etc/oratab
ORCL:/u01/app/oracle/product/10.1.0/db_1:Y( changed N to Y)
Setup auto start of the database
-------------------------------------
File - /etc/init.d/dbora
#!/bin/bash
# Oracle auto start-stop script.
# Set ORA_HOME to be equivalent to the $ORACLE_HOME from which you wish to execute
# dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
ORA_HOME=/u01/app/oracle/product/10.1.0/db_1
ORA_OWNER=oracle
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo \"Oracle startup: cannot start\"
exit
fi
case \"$1\" in
\'start\')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c \"$ORA_HOME/bin/lsnrctl start\"
su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
;;
\'stop\')
# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
su - $ORA_OWNER -c \"$ORA_HOME/bin/lsnrctl stop\"
;;
esac
-----------------------------------------
12 . chmod 750 /etc/init.d/dbora
ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora
ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora
13.After Successful Installation
I tried to login using web browser with following
http://localhost.localdomain:5520/em
But I got the following error msg:
\"The connection was refused when attempting to contact localhost.localdomain\"
Here I need to configure any web server (pl tell me)
14.while SQL*PLUS window in terminal
[oracle@localhost ~]$ pwd
/home/oracle
[oracle@localhost ~]$ /u01/app/oracle/product/10.1.0/db_1/bin/sqlplus
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[oracle@localhost ~]$
15.dbstart command
[oracle@localhost ~]$ /u01/app/oracle/product/10.1.0/db_1/bin/dbstart
SQL*Plus: Release 10.1.0.2.0 - Production on Sun Jun 18 21:53:04 2006
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Database \"ORCL\" warm started.
[oracle@localhost ~]$
16. Lisentner control
[oracle@localhost home]$ /u01/app/oracle/product/10.1.0/db_1/bin/lsnrctl start
LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 18-JUN-2006 21:58:07
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
TNS-00515: Message 515 not found; No message file for product=network, facility=TNS
Linux Error: 2: No such file or directory
[oracle@localhost home]$
17.sysdba
[oracle@localhost home]$ /u01/app/oracle/product/10.1.0/db_1/bin/sqlplus / as sysdba
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
[oracle@localhost home]$
18.start enterprise manager server
[oracle@localhost home]$ /u01/app/oracle/product/10.1.0/db_1/bin/emctl start dbconsole
TZ set to Asia/Calcutta
Environment variable ORACLE_SID not defined. Please define it.
[oracle@localhost home]$
regards
sathish
|
|
|
 Vigyan |
| Posted: Jun 20, 2006 09:58:14 AM |  |
|
Total Post: 386
Joined: May, 2001
|
Hi Sathish,
For successful installation, you have to install few RPMs. Check the following article.
http://www.dbapool.com/articlelist.php?id=082205.php
Fedora Core 4 RPM for Oracle 10.1.0.2 installation
compat-db-4.2.52-2.i386.rpm
compat-gcc-32-3.2.3-47.fc4.i386.rpm
compat-gcc-32-c++-3.2.3-47.fc4.i386.rpm
compat-libstdc++-33-3.2.3-47.fc4.i386.rpm
openmotif-2.2.3-10.i386.rpm
setarch-1.7-3.i386.rpm
tcl-8.4.9-3.i386.rpm
xorg-x11-deprecated-libs-6.8.2-31.i386.rpm
You can download these RPM from the following URL.
http://www.dbapool.com/downloads.php
Remove old installation and follow the article.
Hope it helps.
Vigyan
|
|
|
|
|
| ramesh |
| Posted: Jan 17, 2007 12:07:13 AM | |
|
Total Post: 16
Joined: Dec, 2006
|
hi sathish
visit this URL you will get the usefull installation tips.
http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html
and root must be a group member of dba
ex: usermod -G dba root.
this url is for linux 4AS.i think this is same for fedora.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
