Oracle 10g and SuSE9.1 2004-09-22 - By Niall O Broin
I know this is an unsupported combination, but I understand from various postings here and there that people have got it to run so perhaps someone can assist me.
The install went OK with the exception of the database create assistant which failed. However, the installer insisted that this was optional and not really a problem.
However, now when I try to connect using sqlplus I get the (quite common, from what I read) error: ORA-12547 (See ORA-12547.ora-code.com): TNS:lost contact
Googling for this find s messages about checking kernel parameters but yet I have already set the kernel parameters to reasonable values (it's a test box with only 512M of memory) as:
# sysctl -a|egrep "shmall|shmmax|shmmni|l\.sem|shm-use-hugepages|fs.file-max| ip_local_port_range"
net.ipv4.ip_local_port_range = 1024 65000 kernel.shm-use-hugepages = 0 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 2097152 kernel.shmmax = 2147483648 fs.file-max = 65536
I have shm-use-hugepages set to 0 because this isn't a big box, and I have $ORACLE_HOME/bin/oracle replaced by a wrapper script which does
export DISABLE_HUGETLBFS=1
before actually running oracle. I think I have covered all the bases I have found by googling for this problem, but still it doesn't work. Ideas anyone?
-- Niall
-- To unsubscribe, email: suse-oracle-unsubscribe@(protected) For additional commands, email: suse-oracle-help@(protected) Please see http://www.suse.com/oracle/ before posting
|
|