![]() | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Miscellaneous issues with Oracle 8i (all versions) |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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 | |
|
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.
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.
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.
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.
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.
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.
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;
From mails on suse-oracle@suse.com.
Stefan Sels wrote:
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:
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=noneNote 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.
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.
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.
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).
|
|