SuSE Linux  |Products |Services |Solutions |Support & Download |Partners |Company | Home
SitemapLinksHome
 Search:
 

* SuSE Linux Installation Support
* GNU General Public License
* Security Announcements
* mySAP.com and SuSE Linux
* Mailing Lists
* Download
* Whitepapers
* HowTos and FAQs

Support & Download > Installation Tips > db > 81x_common


Mailto SuSE

Oracle Logo at SuSE

Miscellaneous issues with Oracle 8i (all versions)

This is a list of small issues people had with the installation.

 

 
* Changelog
  6 June, 2001: new document.
7 June, 2001: added kernel-update instructions.
11 June, 2001: moved OPS relink problem out of here
12 June, 2001: added a listener problem
27 July, 2001: added more variables to the LANG env. variable issue
22 january, 2002: added tip for using "sux" instead of "su"
22 january, 2002: added example for the MAXSIZE setting in tablespace creation
 

 
* Possible Oracle 8i issues
 
  • How to switch user and automatically set the X-environment!
    Instead of using the su command simply use the sux command, and you can immediately start X-programs because this command transfers the X environment to the new user shell.

  • Which JRE?
    Oracle bundles the IBM JRE 1.1.8 in Oracle 8.1.6 and 8.1.7. Before that, for Oracle 8.1.5 you need Blackdown JRE 1.1.6v5, see our support page for that Oracle version (right here). If you have 8.1.6 or 8.1.7, you do not have to do ANYTHING, Oracle knows where it's own JRE is already! In particular, do NOT change the path to point to any particular JRE, do NOT install any other JRE (it does not hurt if you do, it's just not necessary), and do NOT set any CLASSPATHs or other Java stuff.

  • Which JDK?
    This is something different from the above, which is just the Java Runtime Environment. The JDK is a Java DEVELOPMENT Kit. It is needed for Java development. The JRE should still be used to run the Oracle GUI tools. Oracle uses the JDK 1.1.8. You can use the IBM JDK 1.1.8 or the Blackdown one.

  • Installer does not work at all
    Do you have a glibc 2.2 system (SuSE Linux 7.1 and later)? Do an unset LANG and try again. In addition, you should also "unset LC_CTYPE" and "unset RC_TYPE" if set, to clear all locale settings from the oracle user's environment.

    Other problem: We usually do a SuSE Linux "Default" installation and have never had any other problem than the above, same with the engineers (ours and Oracle). What did happen sometimes that another attempt to start any of the Java GUI tools was needed, but that was rare.

  • Installer: buttons don't work
    The NUMLOCK key on the numeric keyboard must be OFF when the installer is started or the Installer may not function correctly, like you cannot press any of the buttons. Cancel the installer, turn off NUMLOCK and restart the installer.

  • Hidden dependencies
    If you de-select items to be installed in the Oracle installer, the installation may fail. That is because as part of the installation the binaries (e.g. oracle, sqlplus, svrmgrl) are relinked, and if some components are missing this step will fail, because soem libraries needed for this step might be missing. Unfortunately, the installer will not warn you if you de-select some of these vital components. Solution: install everything which is already selected.

  • Corruption: tablespace accidentally grows larger >2GB
    Due to a bug in Oracle, if you have autoextend set to ON - which is the case with any default database created by dbassist - your tablespace(s) may actually grow a few bytes beyond the 2 GB filesize limit that is present in Oracle 8i (because it does not support the large-files API in the newer glibc's).

    To avoid this, either turn autoextend OFF or at tablespace creation set MAXSIZE to 2147450880 (that is 2GB-32kByte, max. size of a block in Oracle).

    Examples for the tablespace creation commands:

       CREATE DATABASE "TEST"
        maxdatafiles 254
        maxinstances 8
        maxlogfiles 32
        character set US7ASCII
        national character set US7ASCII
        DATAFILE '/opt/oracle/oradata/test/system01.dbf' SIZE 200M 
        AUTOEXTEND ON NEXT 640K MAXSIZE 2147450880
        ...
        ...;
    
      CREATE TABLESPACE "EXAMPLE" 
       DATAFILE '/data/oradata/tst/example01.dbf' SIZE 50M 
       AUTOEXTEND ON NEXT 640K MAXSIZE 2147450880;
    

    Check the settings:

      SELECT file_name,AUTOEXTENSIBLE,to_char(maxbytes,'999999999999') 
      FROM dba_data_files;

  • Listener dies
    From mails on suse-oracle@suse.com.

    Stefan Sels wrote:
    I am running Oracle 8.1.17 on Suse 7.1. The listener makes some trouble: It stops working after a minute. If I restart it (lsnctrl stop, lsnctrl start) it works again (for a minute). I did not find a notice in the listener or alert log. Stefan Sels later wrote:
    Because I got some respone from people who had the same problem, so here my solution which I found :
    It had a relation with the MTS (MultiThreaded Server) stuff in initSID.ora. I commented everything that started wit MTS_ and after a restart of database and listener everything worked fine.

  • "shutdown immediate" hangs
    During testing at SAP Labs we had the problem that shutdown immediate would not work. It would just hang forever. The problem turned out to be - a too long environment variable!

    In SuSE Linux the environment variable $LS_COLORS is >256 Bytes in the default configuration. Unsetting this variable solved the problem! It seems there was some buffer overflow somewhere in Oracle.

    Add this to your Oracle startup script:
        - Bourne shell: unset LS_COLORS
        - C shell: unsetenv LS_COLORS

  • Pro-C/C++ setup
    To install Pro-C/C++ you have to go to 'Client Installation' and select the developer option in the Oracle installer.

    Here is what your Pro-C/C++ configuration file $ORACLE_HOME/precomp/admin/pcscfg.cfg, which is completely empty after the installation, should look like (replace [ORACLE_HOME] with your ORACLE_HOME, the full path, no variable possible; make the first line ONE line, we added the line breaks for formatting on this page only):

    sys_include=([ORACLE_HOME]/precomp/syshdr,
      /usr/lib/gcc-lib/i486-suse-linux/2.95.2/include,
      /usr/include,/usr/include/linux)
    include=[ORACLE_HOME]/precomp/public
    include=[ORACLE_HOME]/oracode/include
    include=[ORACLE_HOME]/oracode/public
    include=[ORACLE_HOME]/rdbms/include
    include=[ORACLE_HOME]/rdbms/public
    include=[ORACLE_HOME]/rdbms/demo
    include=[ORACLE_HOME]/network/include
    include=[ORACLE_HOME]/network/public
    include=[ORACLE_HOME]/plsql/public
    include=[ORACLE_HOME]/otrace/public
    include=[ORACLE_HOME]/ldap/public
    ltype=none
    
    Note that in SuSE Linux 7.2 and above it is ...i486-suse-linux/2.95.3/include instead of 2.95.2 because it comes with gcc 2.95.3.

    For C++ you may have to add a line parse=partial (or 'none'), please check the Pro-C/C++ docs for details, available on OTN.

    Also check out http://govt.oracle.com/~tkyte/proc_makefile/ for a simple example how to make a Makefile for Pro-C files.

  • Selfmade CD: cannot start installer
    One user alerted us that when he used Windows to burn a CD from the archive downloaded from download.oracle.com the installer would not start. This was due to Windows not supporting the executable bit, he said.

  • SuSE Updates:
    This tip is of general nature, Oracle will run without it as well.

    Do not forget to collect all patches for SuSE Linux from ftp://ftp.suse.com/pub/suse/i386/update/[version]. you can use YOU (YaST Online Update, SuSE Linux 7.1+) to do this, but not all patches are available via YOU yet (due to bandwidth considerations), so you should also check manually. An easy way to do this is to use YaST1->Package Management->Install packages->FTP (use the provided default URL, it already points to the update area for this version of SuSE Linux on the SuSE ftp server)

    Note that ftp.suse.com has a restriction of currently ~32kByte/s per user to give everyone a chance. You may find that one of the mirrors is faster for you.

  • Kernel Update:
    Please get the latest kernel update for your SuSE Linux from ftp://ftp.suse.com/pub/suse/i386/update/[version]/kernel/.

    You may also need any updates for at least lvm, modutils and yast from the ./a1/ directory when you upgrade the kernel.

    You can get the pre-compiled binary kernel rpm's or the sources.

    To install from the kernel sources:

        rpm -Uvh kernel-source.rpm
        cd /usr/src/linux
        make cloneconfig dep clean bzlilo modules modules_install
        mk_initrd
        lilo
        reboot

    To install the binary kernel rpm:

        rpm -Uvh [k_deflt|k_smp].rpm
        cp /boot/vmlinuz /boot/vmlinuz.suse
        mk_initrd
        lilo
        reboot
        
    Make sure mk_initrd and more so lilo report no errors! If lilo reports one it probably didn't write a new loader, which means your system cannot be rebooted. No need to be afraid of a kernel update now, we just have to mention this possibility. Knowing this in advance and not rebooting while you search for the cause of the problem is better than having a system that won't boot.

    Note that if you are NOT using a kernel that has /proc/config.gz (original SuSE kernels do) the make cloneconfig will not work. If you changed lilo.conf in an incompatible way the make bzlilo may fail (if you didn't touch that file it will work).