LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices


Reply
  Search this Thread
Old 07-18-2005, 02:42 AM   #1
ehegagoka
Member
 
Registered: Jun 2005
Distribution: Slackware
Posts: 68

Rep: Reputation: 15
Oracle 10g on Slackware


Hi!

I've been searching for an installation HOWTO for installing Oracle 10g on Slackware. I've got Slackware 8 & 9. I've tried google but nothing seems to be specific for Slackware and I'm just wandering if it's really possible for it. Thank you very much!!!

Ryan
 
Old 07-18-2005, 03:25 AM   #2
Namaseit
Member
 
Registered: Dec 2003
Distribution: Slackware
Posts: 325

Rep: Reputation: 30
Huh. I wish I could help you. Is there any documentation for installing it on any linux distro in particular? You could just use the bits and pieces from that one and try and get it working with slackware.

Then make a howto yourself!
 
Old 07-18-2005, 04:19 AM   #3
Basel
Member
 
Registered: Feb 2004
Location: United States
Distribution: Ubuntu 10.10
Posts: 319

Rep: Reputation: 30
I have tried to install Oracle before on a distribution that is not supported by Oracle but I couldn't do so. The Oracle installation script checks your system and stops the installation process if it is not one of the supported OS. Here is a link for istalling Oracle 10g under SuSE 9.3 Prof:
Introduction to Oracle 10g R1 (10.1.0.3) on SUSE LINUX Professional 9.3

BTW, as part of the requirements the swap size must be double your RAM. Minimum ram I guess should be 512MB or 1GB, I cann't remember exactly.
 
Old 07-18-2005, 05:33 AM   #4
ehegagoka
Member
 
Registered: Jun 2005
Distribution: Slackware
Posts: 68

Original Poster
Rep: Reputation: 15
Hi!

Thank you so much for all your post, So Oracle really checks those supported distro. Thanks for the link, I'll see if I could used other HOWTO's patch by patch he9x. The currently supported as what the docu says are:

Red Hat Enterprise Linux 3.0 (Update 3 or later)

Red Hat Enterprise Linux 4.0

SUSE Linux Enterprise Server 9.0

Asianux 1.0

Asianux 2.0


I'll continue searching he9x. Thanks!

Ryan
 
Old 07-18-2005, 05:38 AM   #5
Basel
Member
 
Registered: Feb 2004
Location: United States
Distribution: Ubuntu 10.10
Posts: 319

Rep: Reputation: 30
What is he9x?
 
Old 07-18-2005, 06:43 AM   #6
ehegagoka
Member
 
Registered: Jun 2005
Distribution: Slackware
Posts: 68

Original Poster
Rep: Reputation: 15
Hi!

he9x, simply means I'm happy, just some sort of smiley =). I've check some installation howto using Oracle 9i on Slackware 8.

Ryan
 
Old 08-25-2005, 03:06 PM   #7
endlos
LQ Newbie
 
Registered: Nov 2004
Location: PERU
Distribution: Slackware, Fedora Core, Red Hat Enterprise
Posts: 8

Rep: Reputation: 0
he9x <- thats the most weird smile I have ever seen O_o
 
Old 08-26-2005, 02:12 AM   #8
ehegagoka
Member
 
Registered: Jun 2005
Distribution: Slackware
Posts: 68

Original Poster
Rep: Reputation: 15
Hi!

weird? he9x. I've got a howto on installing oracle on slackware but it uses Slackware 8, and I'm having trouble finding an ISO for Slackware 8. Should I make an ISO? How is it done?

Thank you so much again!

Ryan
 
Old 08-26-2005, 02:34 AM   #9
gbonvehi
Senior Member
 
Registered: Jun 2004
Location: Argentina (SR, LP)
Distribution: Slackware
Posts: 3,145

Rep: Reputation: 53
ftp://ftp.scarlet.be/pub/slackware/slackware-8.0-iso/

But it should be possible to install on Slackware 10.1, maybe if you show us the errors you're getting we could "fix" them.
 
Old 08-26-2005, 04:42 AM   #10
ehegagoka
Member
 
Registered: Jun 2005
Distribution: Slackware
Posts: 68

Original Poster
Rep: Reputation: 15
Hi!

Thanks for the reply, for some reason I don't have my Slackware 10 right now, the only version I have at home is version 9.1, will it also work? Ok I'll try installing it again tom. and then I'll post any errors that I may encounter. Can't get that ftp site, or is it just the restrictions in the office. Thank you so much again!


Ryan
 
Old 09-05-2005, 02:13 AM   #11
thick_guy_9
Member
 
Registered: Jan 2004
Location: Singapore
Distribution: VMS, CentOS
Posts: 109

Rep: Reputation: 16
for Oracle 9.0.1 on Slackware 8.0 see this:ora9

Oracle 10G uses a file - /etc/redhat-release for OS verification. You'll have to create it and add something like "Red Hat Enterprise Linux AS release 3 (Taroon)".


Werner's howto is also a good resource.

Do post your experience as a HOWTO for slackware. I feel slackware will become more popular with its users using (hacking) it to run databases (oracle and sybase) and for development (kylix etc).

good luck.
 
Old 09-05-2005, 02:58 AM   #12
Tinkster
Moderator
 
Registered: Apr 2002
Location: earth
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928Reputation: 928
I found the following a while ago (lives in my snippets-folder):

Quote:
Yep, got Oracle 10g running on Slack 10/current. These are my own notes, so
are only a basic guide to remind me. And what makes sense to me might not
to other poeple, but it may be of use:


===========================================================================
7- RUN ORACLE ON SLACKWARE

INSTALLING ORACLE9i/10g

These were originally based on 9i but have been changed to cover 10g,
although much as stayed the same.

System Requirements (realistic minimum):
RAM = 512MB
SWAP = 1024MB
/tmp = 400MB free
files = 2500MB installation size
data = 1200MB initial database installation size

To find sizes:
grep MemTotal /proc/meminfo
grep SwapTotal /proc/meminfo
df -h /tmp



\1.

Delete OLD files

rm -f -R /etc/oratab
rm -f -R /etc/orainst.loc
rm -f -R /usr/local/bin/oraenv
rm -f -R /usr/local/bin/coraenv
rm -f -R /usr/local/bin/dbhome


open /etc/hosts enter IP_ADDRESS HOST.DOMAIN HOST specific to your setup:
192.168.1.1 localhost.mydomain localhost



\2.

groupadd dba
groupadd oinstall
groupadd oper

After the groups are created, we can add an account for the Oracle owner:

useradd -c DBA -g oinstall -G dba oracle

which will create the oracle account, with primary group oinstall and
secondary - dba.

In addition, users who will use this database instance can be added to the
dba group in the /etc/group file.



\3.

You must create two mount points, one for the programs and one for the
database and enter the details into /etc/profile

add to /etc/profile :
---------------------------------------------------------------------
ORACLE_BASE=/mnt/oracle/app
ORACLE_HOME=/mnt/oracle/data
ORACLE_SID=ORA10g

PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/network/lib

export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH
---------------------------------------------------------------------

Create the directories

QUOTE
cd /mnt
mkdir oracle
cd oracle
mkdir app
mkdir data

chown oracle.dba /mnt/oracle /mnt/oracle/app /mnt/oracle/data

chmod 775 /mnt/oracle -R



\4.

Add these lines to rc.local:


# ORACLE SETTINGS
cd /proc/sys/kernel
echo
echo 250 32000 100 128 > sem
echo 2147483648 > shmmax
echo 4096 > shmmni
echo 2097152 > shmall
echo 65536 > /proc/sys/fs/file-max
ulimit -n 65536
echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range
ulimit -u 16384
umask 0022
echo
echo
#



\5.

Login as user oracle and after mounting the first disk, invoke a new
terminal window and change directory to /mnt/cdrom. This is your
installation mount point. From here run (use ./runInstaller -help to get a
list of options):

ldconfig
depmod -a
../runInstaller -ignoreSysPrereqs &


If you get an Xlib error similar to "Failed to connect to server,"
"Connection refused by server," or "Can't open display" when starting the
Oracle Universal Installer, you must run one of the following shell
commands on your X workstation.

In the session on your workstation, enter the following (type hostname to
get the host name):

hostname

xhost + whatever_the_hostname_command_returned

$DISPLAY=127.0.0.1:0.0; export DISPLAY




\6.


Unix Group Name should be oinstall

File locations should be fine as entered in /etc/profile

Database (first option) - Standard Database - CUSTOM INSTALL - NEW DATABASE,
select most options, change location from {BASE} to /mnt/oracle/data

Change passwords, unlock accounts of SYS, SYSTEM, DBSNMP, MDSYS

databasename = ora10glive
SID as mentioned in /etc/profile = ora10g

Ignore the errors during install, there will be scripts to run as root which
may seem to crash but they just take time. While setting up database the
Database Configuration Assistant might fail, unless the Custom option has
been selected.

Once installed relink takes a few mins by typing relink all

Edit /etc/oratab
Change ORTD: / blah from N to Y

Below is an example of a startup script, Oracle should start automatically
after the install, but will need a script or manual startup the next time
you re-boot / switch the machine off and on.


##############################################################################
# Create a script from this and place it in /usr/local/bin called eg #
#oracle-do
# Call it from RC.local after previous settings made as oracle-do start for
#example
#
#!/bin/bash
#
# Run-level Startup script for the Oracle Instance and Listener
#
# chkconfig: 345 91 19
# description: Startup/Shutdown Oracle listener and instance

ORA_HOME="/mnt/oracle/app"
ORA_OWNR="oracle"

# if the executables do not exist -- display error

if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
echo "Oracle startup: cannot start"
exit 1
fi

# depending on parameter -- startup, shutdown, restart
# of the instance and listener or usage display

case "$1" in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
su - $ORA_OWNR -c $ORA_HOME/bin/dbstart
touch /var/lock/subsys/oracle
echo "password"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
su - $ORA_OWNR -c $ORA_HOME/bin/dbshut
rm -f /var/lock/subsys/oracle
echo "password"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: $0 start|stop|restart|reload"
exit 1
esac
exit 0
#############################################################################


To check if Oracle and its Listener is running type in ps -afx which should
give you something like:

5259 ? S 0:00 /oracle/data/bin/tnslsnr LISTENER -inherit
5300 ? S 0:00 ora_pmon_ORA10g
5302 ? S 0:00 ora_mman_ORA10g
5304 ? S 0:00 ora_dbw0_ORA10g
5306 ? S 0:00 ora_lgwr_ORA10g
5308 ? S 0:00 ora_ckpt_ORA10g
5310 ? S 0:00 ora_smon_ORA10g
5312 ? S 0:00 ora_reco_ORA10g
5314 ? S 0:00 ora_cjq0_ORA10g
5316 ? S 0:00 ora_d000_ORA10g
5318 ? S 0:00 ora_s000_ORA10g
5322 ? S 0:02 oracleORA10g (DESCRIPTION=(LOCAL=YES
(ADDRESS=(PROTOCOL=beq)))
5324 ? S 0:00 ora_qmnc_ORA10g
5326 ? S 0:00 ora_mmon_ORA10g
5328 ? S 0:00 ora_mmnl_ORA10g
5330 ? D 0:01 ora_j000_ORA10g
5332 ? D 0:00 ora_j001_ORA10g
5334 ? S 0:00 ora_j002_ORA10g
5336 ? R 0:02 ora_j003_ORA10g
5338 ? S 0:00 ora_j004_ORA10g
5340 ? S 0:00 ora_q000_ORA10g



\7.

After a re-boot it is possible the LISTENER will not work due to permissions
on the directory as it should be run by the user who installed it eg
oracle. So either change the groups that the user oracle is part of, or
make sure you su as oracle before trying to run the listener.

Try running lsnrctl start LISTENER as below:

root@axia:~# su oracle
oracle@axia:/mnt/oracle/data/bin$ ./lsnrctl start LISTENER

LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 13-MAR-2004 17:00:57
Copyright © 1991, 2004, Oracle. All rights reserved.
Starting /mnt/oracle/data/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /mnt/oracle/data/network/admin/listener.ora
Log messages written to /mnt/oracle/data/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=axia.axiahome
(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.1.0.2.0 - Production
Start Date 13-MAR-2004 17:00:57
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /mnt/oracle/data/network/admin/listener.ora
Listener Log File /mnt/oracle/data/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=axia.axiahome)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
The command completed successfully
oracle@axia:/mnt/oracle/data/bin$



\8.

SQLPLUS can be used to carry out operations in Oracle, eg create users,
tables etc.

sqlplus /nolog
connect sys/password as sysdba
create user steveo identified by password
grant dba to steveo
grant sysdba to steveo

SqlPlus can also be used to start the database eg
sqplus /nolog
connect / as sysdba
startup

To change passwords + unlock the accounts if not done through the GUI
installation:
sqlplus /nolog
connect / as sysdba
alter user username identified by password account unlock


ISQLPLUS is the web based version of SQLPLUS:
Usage:
isqlplusctl start| stop

root@axia:~# isqlplusctl start
iSQL*Plus 10.1.0.2.0
Copyright © 2004 Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.
root@axia:~#

Load browser:
http://localhost:5560/isqlplus


With 10g, enterprise manager is web based:
Oracle Enterprise Manager 10g Database Control commands:
emctl start| stop| status dbconsole
emctl secure

oracle@axia:/root$ emctl start dbconsole


Cheers,
Tink
 
Old 03-10-2006, 04:10 AM   #13
somanath
LQ Newbie
 
Registered: Mar 2006
Posts: 1

Rep: Reputation: 0
connecting oracle through bash script

Do anybody know how to connect oracle database through bash script and After making successfull connection. how to display the contents from the table.

Thanks,
som
 
Old 01-17-2010, 06:28 AM   #14
js888
LQ Newbie
 
Registered: Jan 2010
Posts: 1

Rep: Reputation: 0
If installing oracle 11g on slackware 13 x86 stops at linking phase with an error message saying that the installer is unable to link oracle liborasdkbase library, go to /lib and execute the following as root:

ln -s /usr/lib/libgcc_s.so.1 libgcc_s.so.1

Now, cd to $ORACLE_HOME, and execute:

sed -ie 's/$/ -lrt/' lib/sysliblist

Then click "Retry", the linking should now succeed.
 
  


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 08:57 AM
Oracle 10g on RHEL 4 notcrazy Red Hat 0 06-22-2005 07:46 PM
oracle database 10g on slackware 10.1 yoz Linux - Software 3 03-15-2005 03:43 PM
help needed on Oracle 10g coolamit78 Linux - Software 2 08-12-2004 02:47 AM
Oracle 10G vs 9i sashie Linux - Software 0 06-07-2004 02:37 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware

All times are GMT -5. The time now is 02:37 AM.

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
Open Source Consulting | Domain Registration