Installing and Oracle Reponse file for 11.2.0.1 has errors #44
Comments
|
Hi, thanks for reporting this. Don't know if this works in ubuntu but maybe you can create a swap file exec { "create swap file": exec { "attach swap file": #add swap file entry to fstab |
|
The new file does help now thanks for that, I had to add a lot of extra pre stuff like setting up swap etc to get it to work better and that has resolved the out of memory errors when unzipping and copying. However I try to install using this setup on an ubuntu 14.04.1LTS Server and when I start the VM I can't get the tns listener to start. I have the installdb call and it all appears to work properly but when I call lsnrctl it just blanks. Is installing oracle EE on Ubuntu a total no-no? I can get the XE edition working on a 14.04LTS desktop ok. Thanks again for the quick reply, I have been trying to fix it unsuccessfully for the last few days now! |
|
Strange Did you install the required packages , set ulimits and kernel parameters ( described in the oradb readme.md ), disable iptables and SElinux maybe you try oracle 11.2.0.4 from edelivery or 12.1.0.1 from OTN because 11.2.0.1 is getting old( I heard others who had the same listener issue with 11.2.0.1) and you got a brand new OS Thanks |
|
I don't know how to disable the iptables or SElinux elements I'll try with 12.1.0.1 from. I have the following two files made up to do the pre-config class oradb::preparation{
package {
["dos2unix"
,'alien'
,'autoconf'
,'automake'
,'autotools-dev'
,'binutils'
,'bzip2'
,'doxygen'
,'elfutils'
,'expat'
,'gawk'
,'gcc'
,'gcc-multilib'
,'g++-multilib'
,'ksh'
,'less'
,'lib32z1'
,'libaio1'
,'libaio-dev'
,'libc6-dev'
,'libc6-dev-i386'
,'libc6-i386'
,'libelf-dev'
,'libltdl-dev'
,'libmotif4'
,'libodbcinstq4-1'
,'libodbcinstq4-1:i386'
,'libpth-dev'
,'libpthread-stubs0-dev'
,'libstdc++5'
,'libstdc++5:i386'
,'lsb-cxx'
,'make'
,'openssh-server'
,'pdksh'
,'rlwrap'
,'rpm'
,'sysstat'
,'unixodbc'
,'unixodbc-dev'
,'unzip'
,'x11-utils'
,'zlibc']:
ensure => installed;
}
->
exec { 'preparation output':
path => '/bin',
command => 'echo packages done!',
logoutput => true,
}
exec {
"create swapfile":
# Needs to be 2 times the memory
command => "/bin/dd if=/dev/zero of=/swapfile bs=1M count=4096",
user => root,
creates => "/swapfile";
"set up swapfile":
command => "/sbin/mkswap /swapfile",
require => Exec["create swapfile"],
user => root,
unless => "/usr/bin/file /swapfile | grep 'swap file' 2>/dev/null";
"enable swapfile":
command => "/sbin/swapon /swapfile",
require => Exec["set up swapfile"],
user => root,
unless => "/bin/cat /proc/swaps | grep '^/swapfile' 2>/dev/null";
"add swapfile entry to fstab":
command => "/bin/echo >>/etc/fstab /swapfile swap swap defaults 0 0",
user => root,
unless => "/bin/grep '^/swapfile' /etc/fstab 2>/dev/null";
} ->
exec { 'swapfile output':
path => '/bin',
command => 'echo swapfile done!',
logoutput => true,
}
file {
"/swapfile":
mode => 600,
owner => root,
group => root,
require => Exec['create swapfile'];
}
#setup kernel params
sysctl { 'kernel.msgmnb': ensure => 'present', permanent => 'yes', value => '65536',}
sysctl { 'kernel.msgmax': ensure => 'present', permanent => 'yes', value => '65536',}
sysctl { 'kernel.shmmax': ensure => 'present', permanent => 'yes', value => '2588483584',}
sysctl { 'kernel.shmall': ensure => 'present', permanent => 'yes', value => '2097152',}
sysctl { 'fs.file-max': ensure => 'present', permanent => 'yes', value => '6815744',}
sysctl { 'net.ipv4.tcp_keepalive_time': ensure => 'present', permanent => 'yes', value => '1800',}
sysctl { 'net.ipv4.tcp_keepalive_intvl': ensure => 'present', permanent => 'yes', value => '30',}
sysctl { 'net.ipv4.tcp_keepalive_probes': ensure => 'present', permanent => 'yes', value => '5',}
sysctl { 'net.ipv4.tcp_fin_timeout': ensure => 'present', permanent => 'yes', value => '30',}
sysctl { 'kernel.shmmni': ensure => 'present', permanent => 'yes', value => '4096', }
sysctl { 'fs.aio-max-nr': ensure => 'present', permanent => 'yes', value => '1048576',}
sysctl { 'kernel.sem': ensure => 'present', permanent => 'yes', value => '250 32000 100 128',}
sysctl { 'net.ipv4.ip_local_port_range': ensure => 'present', permanent => 'yes', value => '9000 65500',}
sysctl { 'net.core.rmem_default': ensure => 'present', permanent => 'yes', value => '262144',}
sysctl { 'net.core.rmem_max': ensure => 'present', permanent => 'yes', value => '4194304', }
sysctl { 'net.core.wmem_default': ensure => 'present', permanent => 'yes', value => '262144',}
sysctl { 'net.core.wmem_max': ensure => 'present', permanent => 'yes', value => '1048576',}
}and then I have this: class oradb::fixlinkproblem{
exec{"fix link problem step 1":
command => "/bin/ln -s /usr/lib/x86_64-linux-gnu /usr/lib64",
creates => "/usr/lib64/x86_64-linux-gnu";
"fix link problem step 2":
command => "/bin/ln -sf /bin/bash /bin/sh";
"fix link problem step 3":
command => "/bin/ln -s /usr/bin/awk /bin/awk",
creates => "/bin/awk";
"fix link problem step 4":
command => "/bin/ln -s /usr/bin/rpm /bin/rpm",
creates => "/bin/rpm";
"fix link problem step 5":
command => "/bin/ln -s /usr/bin/basename /bin/basename",
creates => "/bin/basename";
"fix link problem step 6":
command => "/bin/ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 .",
creates => "/lib64/libgcc_s.so.1",
cwd => "/lib64";
}
}Where or how do I disable the other elements? Do you know a stable Ubuntu version 12/13 that I could get 11.2.0.1 on if this doesn't work? |
|
and then in my main class I have this as its dependant on the oracle user being created: class { 'limits':
config => {
'*' => { 'nofile' => { soft => '2048' , hard => '8192', },},
'oracle' => { 'nofile' => { soft => '65536' , hard => '65536', },
'nproc' => { soft => '2048' , hard => '16384', },
'stack' => { soft => '10240' ,},},
},
use_hiera => false,
require => Oradb::Installdb['112010_Linux-x86-64']
} |
|
When I look at this |
|
yeah that looks terrible... What would be the best platform/OS to build this on then? Oracle Linux or RedHat for Oracle 11.1.0.1 or 12.1.0.1? |
|
Just use CentOS 6.5 ( its opensource) or Oracle Linux 6.5 or RedHat6.5 probably fedora will also work |
Hi there, I have been working on these modules and have had a few issues when trying to use these modules via vagrant.
I am using vagrant 1.5.2
When its trying to copy or unzip the install zip's it gets a fork error out of memory, I'm trying to push to an ubuntu 14.04LTS instance with 2GB ram but I think its ruby running out of memory when it copies, how did you get this to work properly?
So I worked around it and copied the database files manually to the /install folder but I get the following errors when it tries to install:
Debug: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/File[/install/db_install_11.2.0.1.rsp]: The container Oradb::Installdb[112010_Linux-x86-64] will propagate my refresh event
Debug: Execinstall oracle database 112010_Linux-x86-64: Executing '/bin/sh -c 'unset DISPLAY;/install/linux.x64_11gR2_database/database/runInstaller -silent -waitforcompletion -ignoreSysPrereqs -ignorePrereq -responseFile /install/db_install_11.2.0.1.rsp''
Debug: Executing '/bin/sh -c 'unset DISPLAY;/install/linux.x64_11gR2_database/database/runInstaller -silent -waitforcompletion -ignoreSysPrereqs -ignorePrereq -responseFile /install/db_install_11.2.0.1.rsp''
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: Starting Oracle Universal Installer...
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns:
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: Checking Temp space: must be greater than 120 MB. Actual 67819 MB Passed
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: Checking swap space: must be greater than 150 MB. Actual 166 MB Passed
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-08-19_05-54-56PM.
Please wait ...[FATAL] [INS-10105] The given response file /install/db_install_11.2.0.1.rsp is not valid.
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: CAUSE: Syntactically incorrect response file. Either unexpected variables are specified
or expected variables are not specified in the response file.
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: ACTION: Refer the latest product specific response file template
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: SUMMARY:
Notice: /Stage[main]/Cpmdb::Installoracle11g/Oradb::Installdb[112010_Linux-x86-64]/Exec[install oracle database 1120
10_Linux-x86-64]/returns: - cvc-complex-type.2.4.a: Invalid content was found starting with element 'oracle.i
nstall.db.EEOptionsSelection'. One of '{"":oracle.install.option, "":INVENTORY_LOCATION, "":UNIX_GROUP_NAME, "":orac
le.install.db.InstallEdition, "":ORACLE_HOME, "":oracle.install.db.DBA_GROUP, "":oracle.install.db.isCustomInstall,
"":oracle.install.db.customComponents, "":oracle.install.db.config.starterdb.SID, "":oracle.install.db.config.starte
rdb.memoryLimit, "":oracle.install.db.config.starterdb.enableSecuritySettings, "":oracle.install.db.config.starterdb
.password.SYS, "":oracle.install.db.config.starterdb.password.SYSMAN, "":oracle.install.db.config.starterdb.password
.SYSTEM, "":oracle.install.db.config.starterdb.automatedBackup.enable, "":oracle.install.db.config.starterdb.automat
edBackup.osuid, "":oracle.install.db.config.starterdb.automatedBackup.ospwd, "":DECLINE_SECURITY_UPDATES, "":MYORACL
ESUPPORT_USERNAME, "":MYORACLESUPPORT_PASSWORD, "":PROXY_PORT, "":PROXY_USER}' is expected.
It looks like the response file is missing params or has not got all the params filled in. I just downloaded the files for linux.x64_11gR2_database this morning from OTN.
Has anyone any ideas on how to amend the response file or adjust the way I run the manifest?
My manifest is below which is ostensibly a copy from the readme:
oradb::installdb{ '112010_Linux-x86-64':
version => '11.2.0.1',
file => "linux.x64_11gR2_database",
databaseType => 'SE',
eeOptionsSelection => true,
eeOptionalComponents => 'oracle.rdbms.partitioning:11.2.0.1.0',
oracleBase => '/oracle',
oracleHome => '/oracle/product/11.2/db',
createUser => true,
user => 'oracle',
group => 'dba',
group_install => 'oinstall',
group_oper => 'oper',
downloadDir => '/install',
zipExtract => false,
}
Thanks in advance
The text was updated successfully, but these errors were encountered: