Home » Infrastructure » Linux » Oracle on Linux
| Oracle on Linux [message #365987] |
Wed, 23 August 2000 15:29  |
Ming Shao
Messages: 3
Registered: August 2000
|
Junior Member |
|
|
Hi,
I experienced some problem when I was installing
Oracle on Linux. I send the mail to you and hope
someone who is expert on Linux and Oracle can give me help.
In order to install Oracle, I have to run one file
called orainst.cm (this file is binary file). The file is in the Oracle CD-ROM. When I ran this file, I keep getting the message.
>bash: orainst.cm: no this file or directory.
I am sure that the CD-ROM has this file and all
necessary requirements are satisfied.
1. I ran this file in current directory, and the PATH
includes current directory
2. The file and the mount point (directory) are all executable.
3. When I mounted the CD-ROM, I used the command> chmod 777 /mnt/cdrom
> mount –t ios9660 /dev/hdc /mnt/cdrom
I don’t understand that why my Linux can’t pick up
this file. When I "ls –l" the directory, I can see the
file, including its size, permission …. Following is my system information
Pentium 200, 64 MB MEM. 200 MB swap space. 1 GB disk
space (partition). My Linux version is 3.0.3, kernel
is 1.3.18. My Oracle is 8.0.5 on Linux.
Does anyone know how to make this file running ?
Please help, help….
Thanks
Ming
|
|
|
|
| Re: Oracle on Linux [message #366006 is a reply to message #365987] |
Tue, 12 September 2000 02:26  |
nature
Messages: 2
Registered: September 2000
|
Junior Member |
|
|
Sir, you can try these steps:
before your install, you must have some developer tools, such as glibcXXX, you can find it on oracle tips, your linux kernal high enough, for e.g , 2.2.15 version, after done,
addgroup dba
adduser oracle -g dba
and set oracle user variable,($ORACLE_HOME,$PATH,$ORACLE_SID..)
after these you logon use oracle
and begin install
mount /dev/cdrom /cdrom
cd /cdrom/orainst
./orainst
you pc have 64MB Ram, you must modify your linux kernal source memory parameters, but these is not
very important.
on you first install, don't create DB, and not
select the document options. Because there have a bug on it. After you install, patch it first, and then create DB.
after install, you login in as root and on
$ORACLE_HOME /orainst directory, run root.sh
Good luck!
|
|
|
|
| Re: Oracle on Linux [message #366008 is a reply to message #366006] |
Thu, 14 September 2000 16:10 |
Ming Shao
Messages: 3
Registered: August 2000
|
Junior Member |
|
|
Sir,Thank you for your message.
I followed most of your instruction and installed
Oracle in my Linux. But still I can't run Oracle. I
did what you told me and didn't create database when
intalling Oracle. But I got Segmentation Fault(core
dump) when I used svrmgrl. Do you think it's a bug ?
In your message you said I have to have glibcXXX. What
is this ? You told me to get this file from Oracle
tips. How to get it? What is Oracle tips ?
You said that after installing Oracle I have to patch
it. How ? Where can I get the patch program ?
Thanks agian. I am greatly appreciate your help and
looking forward to your message.Ming
|
|
|
|
| Re: Oracle on Linux [message #366009 is a reply to message #366008] |
Thu, 14 September 2000 21:15 |
nature
Messages: 2
Registered: September 2000
|
Junior Member |
|
|
glibcXXX is 'glibcpatch.tgz ' on ftp.oracle.com
server you can download it,after done, try these command:
tar -xvzf glibcpatch.tgz
/*Run the script*/
sh glibcpatch.sh
then you can link infomation on screen, this mean
link unix execute file and .so file, this is a patch, you must do this, then you can begin
otherwise, your can contact me. my icq No: 85237240 or mail to me :i_Nature@china.com
|
|
|
|
| Re: Oracle on Linux [message #366010 is a reply to message #366009] |
Fri, 15 September 2000 10:18 |
Ming Shao
Messages: 3
Registered: August 2000
|
Junior Member |
|
|
Hi (85237240)
Thank you for your message. I couldn't find file glibcpatch.tgz on ftp.oracle.com
Could you give me more detailed instruction to find this file ?
Thanks
Ming
|
|
|
|
| Re: Oracle on Linux [message #366011 is a reply to message #366010] |
Fri, 15 September 2000 14:09 |
jj wang
Messages: 3
Registered: August 2000
|
Junior Member |
|
|
Procedure to install Oracle8 in RedHat LINUX:
0) Install Redhat LINUX 5.2 Server (Kernel 2.0.36-0.7)
----------------------------------------
df -k
Filesystem 1024-blocks Used Available Capacity Mounted on
/dev/hda8 257598 20115 224179 8% /
/dev/hda1 19485 593 17886 3% /boot
/dev/hda6 1521567 2485 1440460 0% /home
/dev/hda5 1521567 243681 1199264 17% /usr
/dev/hda7 257598 6249 238045 3% /var
/dev/fd0 1390 21 1297 2% /mnt/floppy
Note: The RH5.2 Server installation provides space for
applications to load in /usr directory space.
1) Login root.
----------------------------------------
login> root
pwd> xxxxxx
startx
cd
vi .bash_profile
Add:
PATH=$PATH:$HOME/bin:.
ORACLE_OWNER=oracle
Add to export list:
ORACLE_OWNER
Run:
. .bash_profile
[[executed automatically at login for other users (e.g. su - oracle)]]
Add User & Group, Use GUI System Configuration tool:
linuxconf
Add dba group, Group ID=101, view with Accept button
Add oracle user in dba group, Login name=oracle, Full
Name=Oracle Administrator, group=dba, view Accept.
mount /mnt/cdrom
cd /mnt/cdrom/orainst
[[INSTALLATION NOTE:
If EAP FTP file download, then do this:
cd /home/oracle
su - oracle
ftp connect to/from NT box as oracle.
ftp 805ship.tgz file to oracle home.
Unpack 805ship.tgz with:
cat 805ship.tgz | tar -zx
This will add 540M files to / (root) directory in df -k.
Refer to these files instead of /mnt/cdrom in paths below.
END OF INSTALLATION NOTE]]
. oratab.sh | more
[[with 'more' can see shell output if errors occur, except
can't see prompted question. Just press enter.]]
Questions are:
1) Is it OK to continue (Y/N)?Y
2) Are these settings correct (Y/N)?Y
The ORACLE_OWNER is set as: oracle
Checking for "oracle" user id...
Creating /etc/oratab file...
Verify:
cd /etc
ls -al ora*
come back to oratab file later
Run:
[[INFORMATION ONLY, SKIP DOWN]]
Novice user installs oracle in /usr directory because space
available in RedHat 5.2 Server configuration. But, better to
have created under /ora8db as partition on another drive, e.g.
/ora8db 1000M Drive 2
/ora8dc 1000M Drive 3, etc.
If expert, then create partitions /ora8db, or /ora8dc, and links as follows:
mkdir /u01
mkdir /u02
mkdir /u03
mkdir /u04
Build softlinks for mount points:
ln -s /ora8db/u01 /u01
ln -s /ora8db/u02 /u02
ln -s /ora8db/u03 /u03
ln -s /ora8db/u04 /u04
END OF INFORMATION ONLY
But, since we're just novices, we'll do following instead:
cd /usr
mkdir ora8db
cd ora8db
mkdir u01
mkdir u02
mkdir u03
mkdir u04
chgrp dba u01
chgrp dba u02
chgrp dba u03
chgrp dba u04
chown oracle u01
chown oracle u02
chown oracle u03
chown oracle u04
ls -al
[[looks okay, permissions set with 'oracle dba']]
Run:
ln -s /usr/ora8db/u01 /u01
ln -s /usr/ora8db/u02 /u02
ln -s /usr/ora8db/u03 /u03
ln -s /usr/ora8db/u04 /u04
cd /
ls -al
[[looks okay, links are owned by root]]
df -k
Filesystem 1024-blocks Used Available Capacity Mounted on
/dev/hda8 257598 20120 224174 8% /
/dev/hda1 19485 593 17886 3% /boot
/dev/hda6 1521567 2485 1440460 0% /home
/dev/hda5 1521567 243681 1199264 17% /usr
/dev/hda7 257598 6249 238045 3% /var
/dev/fd0 1390 21 1297 2% /mnt/floppy
/dev/hdc 397472 397472 0 100% /mnt/cdrom
2) Login oracle.
----------------------------------------
su - oracle
[[login(su - oracle) will cd to /oracle/home and source .bash_profile]]
Workaround listener permission error:
Run:
umask
[[Must return 000 to workaround bug w/listener permissions.
When listener permissions are fixed use 022.]]
Add:
vi .bash_profile
umask 000
retest
. .bash_profile (manually source .bash_profile)
Run:
vi .bash_profile
Add:
PATH=$PATH:$HOME/bin:/u01/app/oracle/products/8.0.5/bin:.
USERNAME="oracle"
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/products/8.0.5
ORACLE_SID=ORCL
ORACLE_TERM=vt100
TMPDIR=/var/tmp
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export USERNAME BASH_ENV PATH ORACLE_BASE ORACLE_HOME ORACLE_SID _
ORACLE_TERM TMPDIR LD_LIBRARY_PATH
umask 000
Run:
. .bash_profile (manually source .bash_profile)
cd /mnt/cdrom/orainst
./orainst [[if you added '.' to the PATH just type orainst]]
3) Run Installer.
----------------------------------------
Select:
Default Install.
Preample.txt:
OK
README.FIRST:
OK
Installation Activity Choice:
Install, Upgrade, or De-Install Software
OK
Installation Options:
Install New Product - Create DB Objects
OK
Environment Variables:
/u01/app/oracle
/u01/app/oracle/products/8.0.5
ORCL
OK
.../defaults:
OK
Software Asset Manager, select to install:
Client Software 8.0.5.0.0
Net8 8.0.5.0.0
TCP/IP Protocol Adapters 8.0.5.0.0
Oracle Intelligent Agent 8.0.5.0.0
Oracle Unix Installer 4.0.3.0.0
Oracle8 JDBC Drivers 8.0.5.0.0
Oracle Server, Release 8.0.5.0.0 Documentation 8.0.5.0.0
Oracle Standard (RDBMS) 8.0.5.0.0
PL/SQL 8.0.5.0.0
Pro*C/C++ 8.0.5.0.0
SQL*Plus 8.0.5.0.0
[[skip the '-' header stuff]]
INSTALL
Selected: 275M in 11 products Available: 1247M (lies, lies)
Default Database Startup Using Prebuilt Datafiles:
OK
Information:
environment ULIMIT not set
OK
Database Mount Points:
/u02
/u03
/u04
OK
[[INSTALLATION NOTE:
By using /u02 instead of /u01 as mount point 1, the default db
loads in the /u02 directory like this:
/u01---(358M)---/app---/oracle---...(the 8.0.5 product is here)
/u02---(126M)---/oradata---/ORCL---...(the default db is here)
/u03---...
/u04---...
Verify with:
cd /usr/ora8db
du -ks u*
END OF INSTALLATION NOTE]]
ORACLE_DOC:
/u01/app/oracle/products/8.0.5/doc like EAP
OK
[[INSTALLATION NOTE:
Do not use CDROM default, because installer errors copying documentation:
/u01/app/oracle/doc CDROM default
END OF INSTALLATION NOTE]]
Documentation Format:
Both
OK
Installer Actions Completed:
OK
Software Asset Manager:
EXIT
Confirmation:
YES
verify success at end of install
Result: Success.
df -k
Filesystem 1024-blocks Used Available Capacity Mounted on
/dev/hda8 257598 20121 224173 8% /
/dev/hda1 19485 593 17886 3% /boot
/dev/hda6 1521567 2492 1440453 0% /home
/dev/hda5 1521567 730971 711974 51% /usr
/dev/hda7 257598 6512 237782 3% /var
/dev/fd0 1390 21 1297 2% /mnt/floppy
/dev/hdc 397472 397472 0 100% /mnt/cdrom
4) Login Root.
----------------------------------------
login> root
pwd> xxxxxx
cd
. .bash_profile
[[executed automatically at login for other users (e.g. su - oracle)]]
[[verify env with ORACLE_OWNER=oracle]]
env | grep ORA
Run:
. /u01/app/oracle/products/8.0.5/orainst/root.sh
Environment Variables Set:
Y
Local Bin Directory:
/usr/local/bin
[[verify in oracle user path. Login oracle, use 'echo $PATH']]
ORACLE_HOME does not match the home directory for oracle /home/oracle:
Y [[Yes, its Y]]
Updating /etc/oratab file...
Leaving common section of Oracle8 root.sh.
Verify:
cd /usr/local/bin
ls -al
[[verify scripts: dbhome, oraenv, coraenv(cshell not used)]]
. dbhome | more
. oraenv ORCL
[[verfiy ORACLE_SID = ORCL]]
5) Login oracle.
----------------------------------------
su - oracle
[[login(su - oracle) will cd to /oracle/home and source .bash_profile]]
View/edit listener files.
/u01/app/oracle/products/8.0.5/network/admin
cp listener.ora listener.ora.bup
cp tnsnames.ora tnsnames.ora.bup
Run:
vi tnsnames.ora
Copy ORCL = ..., and make a new alias of da82
da82 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= xxx.xxx.xxx.xxx)(Ports= 1521)
(CONNECT_DATA = (SID = ORCL))
)
Startup DB sequence:
svrmgrl
connect internal
[[good idea to change password on sys & system now]]
alter user sys identified by manager
/
alter user system identified by manager
/
shutdown immediate
startup
exit
Remember oratab?:
cd /etc
ls -al ora*
oracle owner of this file
Run:
vi oratab
Set to run:
ORCL:/u01/app/oracle/products/8.0.5:Y
switch N to Y
Find database scripts, and fix permissions:
su root
pwd> xxxxxx
Check all db scripts, fix incorrect permissions:
cd /u01/app/oracle/products/8.0.5/bin
ls -al db*
chown oracle dbsnmp
Check all other permissions, make owner oracle:
ls -al | more
chown oracle oratclsh
chown oracle osh
chown oracle tnslsnr
Test database scripts:
exit back to oracle
whoami should be oracle
dbshut
dbstart
dbhome
dbsnmp
Test listener:
lsnrctl start listener
lsnrctl stop
lsnrctl status
Test with:
tnsping da82
Reply is:
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=x.x.x.x)(Port=1521)
OK (310 msec) first time
!! again
OK (10 msec)
df -k
Filesystem 1024-blocks Used Available Capacity Mounted on
/dev/hda8 257598 20123 224171 8% /
/dev/hda1 19485 593 17886 3% /boot
/dev/hda6 1521567 2499 1440446 0% /home
/dev/hda5 1521567 730995 711950 51% /usr
/dev/hda7 257598 6515 237779 3% /var
/dev/fd0 1390 21 1297 2% /mnt/floppy
/dev/hdc 397472 397472 0 100% /mnt/cdrom
7) Configure Intelligent Agent
----------------------------------------
su - oracle
Configuring the Intelligent Agent:
lsnrctl dbsnmp_start
lsnrctl dbsnmp_stop
lsnrctl dbsnmp_status
[[Does it work? Not with RH5.2, so read on]]
Setup detailed tracing(optional):
cd $ORACLE_HOME/network/agent
cp snmp_rw.ora snmp_rw.ora.bup
vi snmp_rw.ora
nmi.trace_level=admin (or 16 if you want more)
nmi.trace_directory=/u01/app/oracle/products/8.0.5/network/log
nmi.trace_file=agent
Read the logs, or delete to refresh(stop/start listener):
cd $ORACLE_HOME/network/log
rm dbsnmpc.log
rm dbsnmpw.log (read this log)
rm listener.log
rm nmiconf.log
rm agent.log
Troubleshoot if not starting, NMS-315 error:
cd /u01/app/oracle/products/8.0.5/network/admin
ls -al sn*
[[Problem if owner of snmp_ro.ora, or snmp_rw.ora is root]]
Remove (only) files with incorrect (root) owner:
su root
pwd> xxxxxx
cd /u01/app/oracle/products/8.0.5/network/log
ls -al
rm dbsnmpc.log
rm dbsnmpw.log
rm nmiconf.log
cd /u01/app/oracle/products/8.0.5/network/admin
ls -al
rm snmp_ro.ora
rm snmp_rw.ora
cd /u01/app/oracle/products/8.0.5/network/agent
ls -al
rm dbsnmp.ver
rm services.ora
exit back to oracle
Intelligent Agent workaround on RH5.2, until bug fixed by Oracle:
Upgrade to older tcl-8.0.2-16.i386.rpm package, from RH5.1.
su root
pwd> xxxxxx
umount /mnt/cdrom
Insert RH5.1 Cdrom
mount /mnt/cdrom
cd /mnt/cdrom/RedHat/RPMS
ls -al tcl*
rpm -ivh tcl-8.0.2-16.i386.rpm
numerous conflict warnings
rpm -Uvh --oldpackage tcl-8.0.2-16.i386.rpm
rpm -q tcl
exit back to oracle
[[INSTALLATION NOTE:
IF YOU INSTALL OLDER TCL PKG YOU WILL EXPERIENCE RH5.2 OS PROBLEMS.
E.g. GUI version of RPMS is now broken, etc..
END INSTALLATION NOTE]]
Make sure the usr/lib/libtcl.so link is pointing to libtcl8.0.so
cd /usr/lib
ls -al libtcl*
Test Intelligent Agent:
su - oracle
lsnrctl dbsnmp_start
lsnrctl dbsnmp_status
[[Intelligent Agent should now be working, although RH5.2 OS may not be]]
Actually, there is another bug in Intelligent Agent:
If you start agent with the event queue empty, the events you
register will never get triggered. A workaround is to shutdown
and restart your agent with some events registered. After that,
all the events, including events you register before restart,
will work properly (compliments jou@us.oracle.com).
Return to original tcl-8.0.3-20.i386.rpm package to fix RH5.2 OS:
su root
cd /
umount /mnt/cdrom
Insert RH5.2 Cdrom
mount /mnt/cdrom
cd /mnt/cdrom/RedHat/RPMS
ls -al tcl*
rpm -Uvh tcl-8.0.3-20.i386.rpm
rpm -q tcl
exit back to oracle
Extra commands to remove a package:
rpm -e tcl-8.0.2-16
rpm -e tcl-8.0.3-20
Test Intelligent Agent:
su - oracle
lsnrctl dbsnmp_stop
lsnrctl dbsnmp_start
lsnrctl dbsnmp_status
Intelligent Agent is no longer working
8) We can skip the kernel rebuild.
----------------------------------------
Notes if interested. Not tested, use at own risk.
----------------------------------------
SEE THIS HEADER FILE IN RPM Packages for RedHat:
----------------------------------------
find . -name "*.h" | xargs grep SHMMAX
find . -name "*.h" | xargs grep SHMMIN
find . -name "*.h" | xargs grep SHMMNI
find . -name "*.h" | xargs grep SHMSEG
/usr/src/linux-2.0.36/include/asm-i386/shmparam.h find #define
find . -name "*.h" | xargs grep SHMMNS ?? only calculated
find . -name "*.h" | xargs grep SEMMNI
find . -name "*.h" | xargs grep SEMMSL
/usr/src/linux-2.0.36/include/linux/sem.h find #define
find . -name "*.h" | xargs grep SEMMNS ?? only calculated
Run:
ipcs -l
Record parameters for:
----------------------------------------
SHMMAX(max seg size, kbytes): 32768
SHMMIN(min seg size): 1
SHMMNI(max number of segments): 128
SHMSEG(formula below, max num sms user process can attach): 512
SHMMNS(max total shared memory, kbytes): 16777216
Formula: SHMMNS=SHMMAX*SHMSEG
16777216 = 32768*512
SEMMNS(max sempahores system wide): 4096
SEMMNI(max number of arrays): 128
SEMMSL(max semaphores per array): 32
Update to (we've got 128MB actual RAM):
----------------------------------------
SHMMAX(max seg size, kbytes): 4194304 (4292967295 bytes)
SHMMIN(min seg size): 1
SHMMNI(max number of segments): 128
SHMSEG(formula below, max num sms user process can attach): 10
SHMMNS(max total shared memory, kbytes): 16777216
Formula: SHMMNS=SHMMAX*SHMSEG
41943040 = 4194304*10
SEMMNS(max sempahores system wide): 7000
SEMMNI(max number of arrays): 70
SEMMSL(max semaphores per array, >=PROCESSES): 100
Formula: SEMMNS=SEMMNI*SEMMSL
7000 = 70*100
[[Our default db has 50 processes, NT default db has 100.
Set it high, and maybe helps with web config.
Look in init<sid>.ora for parameter PROCESSES.]]
----------------------------------------
|
|
|
|
|
|
Goto Forum:
Current Time: Wed Apr 24 07:52:09 CDT 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
