Administrating the Database INSTALLING ORACLE 8I RELEASE 2 (8.1.6.1) ON RED HAT LINUX 6.X/7.X Brian Lomasky, DBA Solutions, Inc.
(The following Linux distributions are also supported: SuSe 6.3 or 6.4 TurboLinux 6.0.2 Caldera eServer 2.3 (The eServer requires the following patches from ftp://ftp.caldera.com/pub/.eServer/updates/2.3/current/RPMS/:glibc-2.1.2-2S.i386.rpm, glibc-devel-2.1.2-2S.i386.rpm, glibc-devel-static-2.1.2-2S.i386.rpm, glibc-localedata-2.1.22S.i386.rpm) (Red Hat seems to better supported by Oracle than other Linux distributions). When performing the Red Hat installation: 1) Partition the hard disk as you see fit.
rpm -ivh kernel-source-2.2.*.i386.rpm 5) Unmount the CD: cd umount /mnt/cdrom Change the SHMMAX parameter value by doing: 1) Edit the source file which defines the SHMMAX parameter value: vi /usr/src/linux/include/asm/shmparam.h 2) Locate the line in the file that begins with the following: #define SHMMAX 0x2000000 Note that 0x2000000 is 32 megs, expressed as a hexadecimal value. Oracle recommends that this value be set to one half of the installed memory. Change the 0x2000000 value to your new value.
If gmake does not exist, create the symbolic link to make: ln -s /usr/bin/make /usr/bin/gmake 3) Ensure that your server has an entry in the /etc/hosts file. (This allows Oracle to determine the IP address of the server). 4) If a previous installation of Oracle 8i failed, you may have to clean up some files that were left over from the failed installation. Failure to do so may cause this new installation to fail. To clean up these left over files, type: rm mv rm rm rm rm rm rm rm -f /etc/oraInst.
12) Open a terminal window. 13) These instructions assume that your shell is: /bin/bash. Your shell can be viewed by typing: echo $SHELL If this is not your shell, substitute the appropriate file name for all following references to .bash_profile 14) Edit the .
# Russian russian # Simplified Chinese "simplified chinese" # Slovak slovak # Swedish swedish # Thai th # Traditional Chinese "traditional chinese" # Turkish turkish # (Include the quotes in the NLS_LANG value, if they are included in the above listing) NLS_LANG=american; export NLS_LANG ORACLE_TERM=vt100; export ORACLE_TERM PATH=$ORACLE_HOME/bin:$PATH; export PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib # For each , set the CLASSPATH environment # variable to include any product-specific jlib
15) ORA_NLS33 specifies the directory under which Oracle will store its *.nlb files (which define languages, territories, character sets, and linguistic sorting orders), and is necessary only if ORACLE_HOME has multiple versions of directories under which *.nlb files will be placed. The default is $ORACLE_HOME/ocommon/nls/admin/data. Specify ORA_NLS33 by including the following line in the .
e) At the "Available Product Components" screen, select the desired components to be installed. Click Next. f) At the "Component Locations" screen, Click Next to use the current volume as the location for the displayed software components. g) At the "Privileged Operating System Groups" screen, Click Next to select the oinstall group to be the OSDBA and OSOPER group. h) You will then be asked whether you wish to create a database as part of the installation.
CREATE THE DATABASE: Note that creating the database can take a long time (i.e. hours) on a slow system (mostly due to the fact the Oracle JServer is loaded into the database). 1) Start the Database Configuration Assistant, by typing: dbassist & 2) Select the "Create a Database" option and click Next. 3) When prompted for "Select the type of database to create", select "Custom".
lsnrctl start Note that Oracle recommends NOT using prespawned dedicated servers in Oracle 8.1.6. Check to see if the Oracle Server is running: ps -ef | grep pmon If no process is displayed, you can manually start the database by typing the following commands: sqlplus /nolog connect internal startup exit Verify that the Oracle server has been successfully started and that the database is accessible.
1) Configure Oracle to automatically start the Oracle database whenever the dbstart script is executed, and to automatically shutdown the Oracle database whenever the dbshut script is executed. Type: vi /etc/oratab On the last line, change the third parameter from N to Y to auto-start/stop the database. 2) Log in as root. 3) Create a file containing commands to startup or shutdown the Oracle database. Type: vi /etc/rc.d/init.d/dbora The file should look similar to the following: #!/bin/bash # # /etc/rc.
5) Link the file to the startup/shutdown directories, so that the operating system will run the above script when the system is started or shutdown. Type: ln -s /etc/rc.d/init.d/dbora /etc/rc.d/rc5.d/S99dbora ln -s /etc/rc.d/init.d/dbora /etc/rc.d/rc0.d/K01dbora 6) Log out from root and log back in as oracle. INIT.ORA PARAMETER SETTINGS: There is a template init$ORACLE_SID.ora file contained in $ORACLE_BASE/admin/$ORACLE_SID/pfile/init$ORACLE_SID.ora.
The Visual Information Retrieval Cartridge option is not supported. Only the secure socket layer (SSL) authentication is supported for the Advanced Security option. The OS cartridge for the Data Gatherer is not available. The Precompiler options (Pro*COBOL, Pro*Ada, Pro*FORTRAN) are not supported. Legato Storage Manager is not supported. Modified system header files for Pro*C/C++ are located in $ORACLE_HOME/precomp/public with the Oracle 8.1.6 for Linux distribution. You can not upgrade 8.0.5.
Since Oracle 8.1.6.1 is linked against glibc-2.1.3 and Red Hat 7.0 ships with glibc-2.1.9x, Oracle 8.1.6.1 fails to start on RedHat Linux 7.0 after relinking. Possible Symptoms are: Starting up the database fails with ORA-3113 after some time spent looping in semop() and a core file is generated.
LD="i386-glibc21-linux-gcc -shared -L${ORACLE_HOME}/lib" LD_RUNTIME="-Wl,-R${ORACLE_HOME}/lib" LD_OPT="-Wl,-h${CLNT_LIB}" 4) Rebuild libclntsh.so by running 'genclntsh' and relink oracle, svrmgrl, etc using the usual relink commands. You'll get warnings in the relink process, but they can be ignored. If trying to install IAS 8i, the relink script provided with IAS to relink the executables after editting the make files won't work.
(If you want to restore the Red Hat 7.0 version of the compiler, remove the gcc link and cp the gcc.linux7 file back to gcc). Another reported (but un-verified) workaround is: 1) Get the following RedHat 6.x packages (if not already installed): glibc-2.1.3-*.rpm 2) Extract the following files from the RPM package and copy them to $ORACLE_HOME/lib: libc-2.1.3.so libpthread.so libdl.so ld-linux.so.2 (Those were symlinks to some like libXX-2.1.3.so - Copy the targets) 3) Create $ORACLE_HOME/lib/libc.
cp $NAME $NAME.orig fi # Change cc and gcc for /usr/bin/i386-glibc21-gcc sed -e "s/gcc/\/usr\/bin\/i386-glibc21-linux-gcc/ s/CC=cc/CC=\/usr\/bin\/i386-glibc21-linux-gcc/" \ $NAME > $NAME.new mv $NAME.new $NAME done 3) Change the genclntsh script so that LD uses a different link script, searching for /usr/i386-glibc21linux/lib first. 4) Relink all oracle executables. Type: cd $ORACLE_HOME/bin ./genclntsh ./relink all 5) Create the Oracle database. (This idea is based on the Oracle 8.0.5 patch script).
The two most common GUI desktop environments are GNOME and KDE. Each provides a highly customizable interface, similar to what you are familiar with on a Windows NT system. In order to configure a Linux system, the linuxconf program functions in a similar mannner to NT's Control Panel applets. Additionally, there are command-line utilities for all of the system configuration options, allowing you to include any of them into your own standard or custom environment-setting scripts.
Security monitors/auditing: Spam filters: Spelling checkers: Spreadsheet: System configuration utilities: System performance utilities: Terminal emulators: Text editors: Text to Audio converters: User account creation and modification: Virus scan: Windows emulators: Word Processing: tiger, logcheck, tripwire junkbuster look, ispell, spell soffice, gnumeric linuxconf, gnomecc, sysctl gtop, top, sar, vmstat, iostat gnome-terminal, rxvt, konsole ed, emacs, gvim, vi, vim catspeech useradd, userdel, usermod ant