Code Monkey home page Code Monkey logo

biemond-oradb's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

biemond-oradb's Issues

Use Unicode AL32UTF8

When using the enterprise edition you are able to choose advanced and then select AL32UTF8 Character Set. Is there a way to do this with the installdb.pp? I see there is an option for ee_optional_components, but I have no idea how I would know what those components are.

oracle10

oraInst.loc group and mode not set

Some sites by default might make their File resources only root readable. This will cause oraInst.loc to not be readable by grid/oracle user, which causes configuration to later fail.

dborainst.pp has parameters for group, but does not use them when creating the oraInst.loc File resource? /var/opt/oracle can be mode 0755 as well.

readme update for sol11 package names

The documentation for sol10 was very close for sol11, but oracle has changed their packag naming. The following 2 packages are needed to be installed for sol11.

 package { ['shell/ksh', 'developer/assembler']:
    ensure => present,
  }

Listener entry in tnsnames.ora file

Is there currently a way (or can you provide one) to make entries like this in the tnsnames.ora file?

LISTENER_DB1.PEOPLETTTT.AAAA.BBBB_ONS =
  (ADDRESS = (PROTOCOL = tcp)(HOST = db.example.edu)(PORT = 1234))

LISTENER_DB2.PEOPLETTTT.AAAA.BBBB_ONS =
  (ADDRESS = (PROTOCOL = tcp)(HOST = db.example.edu)(PORT = 1234))

LISTENER_DB3.PEOPLETTTT.AAAA.BBBB_ONS =
  (ADDRESS = (PROTOCOL = tcp)(HOST = db.example.edu)(PORT = 1234))

unable to find initdatabasename.ora

Hi biemond,

After I installed oracle database server I am not able to find initdatabasename.ora file it is not creating it under /u01/app/oracle/product/11.2/db/dbs/

Let me know

thank you,
Supriya

rootadd_rdbms.sh rootadd_filemap.sh are not being created

Hi,

I keep running into the following error :

Error: Check /orabase/product/11.2.0/4.0/install/root_puppetagent1.vagrant.vm_2015-03-02_11-56-39.log for the output of root script

Error: /Stage[main]/Profile::Oracledb::Install::Install/Oradb::Installdb[11.2.0.4_Linux-x86-64]/Exec[run root.sh script 11.2.0.4_Linux-x86-64]/returns: change from notrun to 0 failed: Check /orabase/product/11.2.0/4.0/install/root_puppetagent1.vagrant.vm_2015-03-02_11-56-39.log for the output of root script

The text below is from the log mentioned in the error above:

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
/orabase/product/11.2.0/4.0/root.sh: line 14: /orabase/product/11.2.0/4.0/rdbms/install/rootadd_rdbms.sh: No such file or directory
/orabase/product/11.2.0/4.0/root.sh: line 16: /orabase/product/11.2.0/4.0/rdbms/install/rootadd_filemap.sh: No such file or directory

puppet variables are camelcase instead of snakecase

Great module! Curious why most of the variables do not follow the puppet guidelines and use camel case instead of the snake case guideline?

II think the difference in this casing is causing problems with rspec puppet as I am not able to test properly when using this module.

Hi Biemond

Do you have any module how to create tnsnames in oradb module.I only see listener.pp

Please help me.

Appreciate your help

Thank You,
Supriya

user creation with oracle_user

Hi,

When I use oracle_user to create a user and it already exists puppet gives an error:
Info: Connecting to Oracle sid HYBPRD with user sysdba
Notice: /Stage[main]/Ccoracle/Oracle_user[hybusr]/grants: revoked the UNLIMITED TABLESPACE right(s)
Info: Executing: [] on database HYBPRD
Info: Executing sql-command []
Info: Connecting to Oracle sid HYBPRD with user sysdba
Error: /Stage[main]/Ccoracle/Oracle_user[hybusr]: Could not evaluate: Error in execution of SQL command: [].
Found error SP2-0042: unknown command "[]" - rest of line ignored.

Notice: /Stage[main]/Ccoracle/Oradb::Listener[stop listener patch]/Exec[listener other stop listener patch]: Dependency Oracle_user[hybusr] has failures: true
Warning: /Stage[main]/Ccoracle/Oradb::Listener[stop listener patch]/Exec[listener other stop listener patch]: Skipping because of failed dependencies

Is it possible to prevent that when the user already exists an empty statement is being processed which results in an error?

Kind regards

couldn't execute "/u01/app/oracle/product/12/OPatch/ocm/bin/emocmrsp": permission denied

Hi,

I am getting below permission denied error when i try to do opatch upgrade, I was able to fix this by adding a file resource to change file permission of emocmrsp file. Could you pls check and let me know..If i am doing something wrong.

==> ve_oracle_centos6: Debug: Exec[extract opatch opatch_upgrade opatch.zip](provider=posix): Executing 'unzip -o /var/tmp/install/opatch.zip -d /u01/app/oracle/product/12'
==> ve_oracle_centos6: Debug: Executing with uid=oracle gid=oinstall: 'unzip -o /var/tmp/install/opatch.zip -d /u01/app/oracle/product/12'
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Oradb::Opatchupgrade[opatch_upgrade]/Exec[extract opatch opatch_upgrade opatch.zip]/returns: executed successfully
==> ve_oracle_centos6: Debug: /Stage[main]/Ve_oracle::Patch/Oradb::Opatchupgrade[opatch_upgrade]/Exec[extract opatch opatch_upgrade opatch.zip]: The container Oradb::Opatchupgrade[opatch_upgrade] will propagate my refresh event
==> ve_oracle_centos6: Debug: Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh](provider=posix): Executing 'ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh'
==> ve_oracle_centos6: Debug: Executing with uid=oracle gid=oinstall: 'ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh'
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Oradb::Opatchupgrade[opatch_upgrade]/Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh]/returns: spawn /u01/app/oracle/product/12/OPatch/ocm/bin/emocmrsp -no_banner
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Oradb::Opatchupgrade[opatch_upgrade]/Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh]/returns: couldn't execute "/u01/app/oracle/product/12/OPatch/ocm/bin/emocmrsp": permission denied
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Oradb::Opatchupgrade[opatch_upgrade]/Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh]/returns:     while executing
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Oradb::Opatchupgrade[opatch_upgrade]/Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh]/returns: "spawn /u01/app/oracle/product/12/OPatch/ocm/bin/emocmrsp -no_banner"
==> ve_oracle_centos6: Debug: Oradb::Opatchupgrade[opatch_upgrade]: Resource is being skipped, unscheduling all events
==> ve_oracle_centos6: Info: Oradb::Opatchupgrade[opatch_upgrade]: Unscheduling all events on Oradb::Opatchupgrade[opatch_upgrade]
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Exec[download-patch]: Dependency Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh] has failures: true
==> ve_oracle_centos6: Debug: /Stage[main]/Ve_oracle::Patch/Exec[download-patch]: Resource is being skipped, unscheduling all events
==> ve_oracle_centos6: Debug: Oradb::Opatch[_db_patch]: Resource is being skipped, unscheduling all events
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Oradb::Opatch[_db_patch]/File[/var/tmp/install/p22191659_121020_Linux-x86-64.zip]: Dependency Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh] has failures: true
==> ve_oracle_centos6: Debug: /Stage[main]/Ve_oracle::Patch/Oradb::Opatch[_db_patch]/File[/var/tmp/install/p22191659_121020_Linux-x86-64.zip]: Resource is being skipped, unscheduling all events
==> ve_oracle_centos6: Notice: /Stage[main]/Ve_oracle::Patch/Oradb::Opatch[_db_patch]/Exec[extract opatch p22191659_121020_Linux-x86-64.zip _db_patch]: Dependency Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh] has failures: true
==> ve_oracle_centos6: Debug: /Stage[main]/Ve_oracle::Patch/Oradb::Opatch[_db_patch]/Exec[extract opatch p22191659_121020_Linux-x86-64.zip _db_patch]: Resource is being skipped, unscheduling all events
==> ve_oracle_centos6: Error: ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh returned 1 instead of one of [0]
==> ve_oracle_centos6: Error: /Stage[main]/Ve_oracle::Patch/Oradb::Opatchupgrade[opatch_upgrade]/Exec[ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh]/returns: change from notrun to 0 failed: ksh /var/tmp/install/opatch_upgrade_opatch_upgrade_12.1.0.1.9.ksh returned 1 instead of one of [0]

Below is my code

oradb::opatchupgrade{'opatch_upgrade':
  oracle_home               => hiera('oracle_home_dir'),
  patch_file                => 'opatch.zip',
  opversion                 => '12.1.0.1.9',
  user                      => hiera('oracle_os_user'),
  group                     => 'oinstall',
  download_dir              => hiera('oracle_download_dir'),
  puppet_download_mnt_point => hiera('oracle_source'),
} 

file { '/u01/app/oracle/product/12/OPatch/ocm/bin/emocmrsp':
   ensure => present,
   mode   => '0755',
   owner  => 'oracle',
   group  => 'oinstall',
}  

Oradb module confused when installdb and installasm instantiated on the same node

It's probably not meant to work this way, but I happen to use installdb and installasm on the same node (mostly for testing purposes).

This causes both installations to happen and work correctly during the first deploy, but afterwards during the next runs, the module gets confused because it makes a comparison between the different installations and decides to re-do the installation of one of them over and over again:

==> oracle12asm: Info: Loading facts
==> oracle12asm: Info: oracle_exists: oracle_exists /oragrid/product/12.1/grid;
==> oracle12asm: Info: oracle_exists: oracle_exists compare /oragrid/product/12.1/grid; with /oragrid/product/12.1/grid
==> oracle12asm: Info: oracle_exists: oracle_exists return true
==> oracle12asm: Info: oracle_exists: oracle_exists /oragrid/product/12.1/grid;
==> oracle12asm: Info: oracle_exists: oracle_exists compare /oragrid/product/12.1/grid; with /oradb/product/12.1/db
==> oracle12asm: Info: oracle_exists: oracle_exists return false
==> oracle12asm: Notice: Compiled catalog for oracle12asm.vagrantup.com in environment production in 2.18 seconds
==> oracle12asm: Info: Applying configuration version '1433334088'
==> oracle12asm: Notice: oradb::installdb /oradb/product/12.1/db does not exists
==> oracle12asm: Notice: /Stage[main]/Vdab_oracledb/Oradb::Installdb[12.1.0.2_Linux-x86-64]/Notify[oradb::installdb /oradb/product/12.1/db does not exists]/message: defined 'message' as 'oradb::installdb /oradb/product/12.1/db does not exists'

So basically this is the problem:

==> oracle12asm: Info: oracle_exists: oracle_exists compare /oragrid/product/12.1/grid; with /oradb/product/12.1/db

Install database from template

Hi,

With the current module it is not possible to install a database from a template. We are however interested in performing installations this way. If we'd fork your repo and implement the necessary changes (maintaining backwards compatibility), is that something you would pull in?

Kind regards,

Tom

Oracle Net Services configuration failed on ubuntu 14.04

I 'am trying to install oracle using oradb on my ubuntu machine(14.04 with 64 bit architecture).
Though Oracle(12.1.0.1) get installed, it fail in the subsequent step i,e
while running the oradb::net class.

Below is the error log :

root@tpcloud:/etc/puppet# puppet agent -t
Info: Retrieving plugin
Info: Loading facts
Info: Caching catalog for tpcloud.puppet.com
Info: Applying configuration version '1420206351'
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: UnsatisfiedLinkError exception loading native library: njni12
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: java.lang.UnsatisfiedLinkError: /oracle/product/12.1/db/lib/libnjni12.so: /oracle/product/12.1/db/lib/libclntsh.so.12.1: file too short
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: java.lang.UnsatisfiedLinkError: oracle.net.common.NetGetEnv.jniGetOracleHome()Ljava/lang/String;
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: at oracle.net.common.NetGetEnv.jniGetOracleHome(Native Method)
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: at oracle.net.common.NetGetEnv.getOracleHome(Unknown Source)
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: at oracle.net.ca.NetCALogger.getOracleHome(NetCALogger.java:230)
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: at oracle.net.ca.NetCALogger.initOracleParameters(NetCALogger.java:215)
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: at oracle.net.ca.NetCALogger.initLogger(NetCALogger.java:130)
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: at oracle.net.ca.NetCA.main(NetCA.java:433)
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns:
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: Error: oracle.net.common.NetGetEnv.jniGetOracleHome()Ljava/lang/String;
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: Oracle Net Services configuration failed. The exit code is 1
Error: netca /silent /responsefile /install/netca_12.1.rsp returned 1 instead of one of [0]
Error: /Stage[main]/Oraclesetup::Oracledb/Oradb::Net[config net8]/Exec[install oracle net config net8]/returns: change from notrun to 0 failed: netca /silent /responsefile /install/netca_12.1.rsp returned 1 instead of one of [0]
Notice: /Stage[main]/Oraclesetup::Oracledb/Oradb::Listener[start listener]/Exec[listener start start listener]: Dependency Exec[install oracle net config net8] has failures: true

I have struggling with it for last 2 weeks but not getting any solution.
Can anyone please help me here .

Install ASM Issue

Hi Edwin,

I'm trying to install 11gR2 on RHEL 6.5 using oradb::installasm.

I have gridBase => '/app/oragrid/base'
and
gridHome => '/app/oragrid/11.2.0/grid'

When I run the agent, I get the following error from oradb::instalasm:
Error: Could not retrieve catalog from remote server: Error 400 on SERVER: gridHome folder should be under the gridBase folder at /etc/puppet/modules/oradb/manifests/installasm.pp:65

Yet, when I put the gridHome under gridBase:
gridBase => '/app/oragrid/base',
gridHome => '/app/oragrid/base/11.2.0/grid',

Then I get a runInstaller error:

Notice: /Stage[main]/Test01::Createasm/Oradb::Installasm[asm]/Exec[install oracle grid asm]/returns: Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-02-23_06-22-00PM. Please wait ...[FATAL] [INS-32026] The Software Location specified should not be under Oracle base location.

Notice: /Stage[main]/Test01::Createasm/Oradb::Installasm[asm]/Exec[install oracle grid asm]/returns: CAUSE: Grid Infrastructure for a Cluster installation will assign root ownership to all parent directories of Oracle Clusterware software location. As a result, all named directories in the software location path will acquire root ownership. This may create problems for subsequent installations into the same Oracle base.

Notice: /Stage[main]/Test01::Createasm/Oradb::Installasm[asm]/Exec[install oracle grid asm]/returns: ACTION: Specify software location outside of Oracle base.

Seems a bit like a catch-22 situation here. Am I doing something wrong?

Regards,

mohammed

Rollback 12.1.0.2.5 PSU

Hi Biemond,

I tried to apply 12.1.0.2.5 PSU like this.

oradb::opatch{'21555660_db_patch':
ensure => 'present',
oracle_product_home => '/u01/sq/ora_1/db/12.1.0.2',
patch_id => '21520444',
patch_file => 'p21520444_121020_Linux-x86-64.zip',
bundle_sub_patch_id => '21555660',
bundle_sub_folder => '21555660',
user => 'oracle',
group => 'oinstall',
download_dir => '/spare/psu',
ocmrf => true,
require => Oradb::Opatchupgrade['121010_opatch_upgrade'],
puppet_download_mnt_point => '/spare/psu_source',
}

oradb::opatch{'21359755_db_patch':
ensure => 'present',
oracle_product_home => '/u01/sq/ora_1/db/12.1.0.2',
patch_id => '21520444',
patch_file => 'p21520444_121020_Linux-x86-64.zip',
bundle_sub_patch_id => '21359755',
bundle_sub_folder => '21359755',
user => 'oracle',
group => 'oinstall',
download_dir => '/spare/psu',
ocmrf => true,
require => Oradb::Opatchupgrade['121010_opatch_upgrade'],
puppet_download_mnt_point => '/spare/psu_source',
}

The PSU was appiled successfully.

However, when it comes to rollback the PSU.

oradb::opatch{'21555660_db_patch':
ensure => 'absent',
oracle_product_home => '/u01/sq/ora_1/db/12.1.0.2',
patch_id => '21520444',
patch_file => 'p21520444_121020_Linux-x86-64.zip',
bundle_sub_patch_id => '21555660',
bundle_sub_folder => '21555660',
user => 'oracle',
group => 'oinstall',
download_dir => '/spare/psu',
ocmrf => true,
require => Oradb::Opatchupgrade['121010_opatch_upgrade'],
puppet_download_mnt_point => '/spare/psu_source',
}

oradb::opatch{'21359755_db_patch':
ensure => 'absent',
oracle_product_home => '/u01/sq/ora_1/db/12.1.0.2',
patch_id => '21520444',
patch_file => 'p21520444_121020_Linux-x86-64.zip',
bundle_sub_patch_id => '21359755',
bundle_sub_folder => '21359755',
user => 'oracle',
group => 'oinstall',
download_dir => '/spare/psu',
ocmrf => true,
require => Oradb::Opatchupgrade['121010_opatch_upgrade'],
puppet_download_mnt_point => '/spare/psu_source',
}

It fails to rollback the PSU because it should rollback <bundle_sub_patch_id> rather than <21520444>.

Info: search for patchid 21555660
Info: opatch_status for patch 21520444 command: /u01/sq/ora_1/db/12.1.0.2/OPatch/opatch lsinventory -patch_id -oh /u01/sq/ora_1/db/12.1.0.2 -invPtrLoc /etc/oraInst.loc
Info: opatch_status output 21555660 for patchId 21555660
Info: opatch action: absent with command /u01/sq/ora_1/db/12.1.0.2/OPatch/opatch rollback -id 21520444 -silent -oh /u01/sq/ora_1/db/12.1.0.2
Argument(s) Error... Patch not present in the Oracle Home, Rollback cannot proceed
If the patch was applied using -no_inventory option, use -ph option
to specify the patch shiphome location. Use 'opatch rollback -help'
to get more information.

Info: opatch result: Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Please check the arguments and try again.

OPatch failed with error code 135

Error: Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Please check the arguments and try again.

OPatch failed with error code 135

Error: /Stage[main]/test_ora/Oradb::Opatch[21555660_db_patch]/Db_opatch[21520444 21555660_db_patch]/ensure: change from present to absent failed: Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Please check the arguments and try again.

OPatch failed with error code 135

Info: search for patchid 21359755
Info: opatch_status for patch 21520444 command: /u01/sq/ora_1/db/12.1.0.2/OPatch/opatch lsinventory -patch_id -oh /u01/sq/ora_1/db/12.1.0.2 -invPtrLoc /etc/oraInst.loc
Info: opatch_status output 21359755 for patchId 21359755
Info: opatch action: absent with command /u01/sq/ora_1/db/12.1.0.2/OPatch/opatch rollback -id 21520444 -silent -oh /u01/sq/ora_1/db/12.1.0.2
Argument(s) Error... Patch not present in the Oracle Home, Rollback cannot proceed
If the patch was applied using -no_inventory option, use -ph option
to specify the patch shiphome location. Use 'opatch rollback -help'
to get more information.

Info: opatch result: Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Please check the arguments and try again.

OPatch failed with error code 135

Error: Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Please check the arguments and try again.

OPatch failed with error code 135

Error: /Stage[main]/test_ora/Oradb::Opatch[21359755_db_patch]/Db_opatch[21520444 21359755_db_patch]/ensure: change from present to absent failed: Oracle Interim Patch Installer version 12.1.0.1.9
Copyright (c) 2016, Oracle Corporation. All rights reserved.

Please check the arguments and try again.

OPatch failed with error code 135

Thanks and regards,
Anthony

Response file used during installation

Hi,

What would be best way to use non-standard response file during automated installation? I presume it would be modifying templates / db_install_...rsp.erb, but I just want to confirm if that is the case. Thanks.

Listener, DB creation start/stop create/remove implementation

I have a question regarding the choice of how to define, start/stop Listeners and the creation and deletion of databases.

I notice that you need to first define the relative instance, but then create other resources depending if you want to for example, start a listener, and then use another instance with the stop action to stop one.

Why not add the action in the instance itself? Or use ensure =>

Example

Current situation:

 # tnslsnr Net
  oradb::net{ 'config net8':
    oracleHome   => $ora_home,
    version      => '12.1',
    user         => $ora_user,
    group        => $ora_group,
    downloadDir  => '/install',
    dbPort       => '1521', #optional
  }

  # Listeners
   oradb::listener{'stop listener':
     oracleBase   => $ora_base,
     oracleHome   => $ora_home,
    user         => $ora_user,
     group        => $ora_group,
     action       => 'stop',
     require      => Oradb::Net['config net8'],
   }

  oradb::listener{'start listener':
    oracleBase   => $ora_base,
    oracleHome   => $ora_home,
    user         => $ora_user,
    group        => $ora_group,
    action       => 'start',
   require      => Oradb::Listener['stop listener'],
  }

This would make more sense to me:

 # with ensure you could define  'running', 'stopped', or 'absent'

 # tnslsnr Net
  oradb::net{ 'config net8':
    oracleHome   => $ora_home,
    version      => '12.1',
    ensure    => 'running',
    user         => $ora_user,
    group        => $ora_group,
    downloadDir  => '/install',
    dbPort       => '1521', #optional
  }

install Enterprise Manager 13c

Anyone tried to install Enterprise Manager 13c with this module?
We want to do 13c. I plan on trying it and making any adjustments...

Patch Oracle db

Hi,

I try to patch my db using

for this example OPatch 14727310

the OPatch utility must be upgraded ( patch 6880880, see above)

oradb::opatch{'18031668_db_patch':
oracleProductHome => $oracleHome,
patchId => '18031668',
patchFile => 'p18031668_112040_Linux-x86-64.zip',
user => $dbUser,
group => $dbGroup,
downloadDir => $downloadDir,
ocmrf => true,
require => [Oradb::Opatchupgrade['112000_opatch_upgrade'],
Oradb::Dbactions['stop testDb patch']],
puppetDownloadMntPoint => $puppetDownloadMntPoint,
}

The modules I'm using are:
[root@puppet ~]# puppet module list
/etc/puppetlabs/puppet/modules
โ”œโ”€โ”€ biemond-oradb (v1.0.13)
โ”œโ”€โ”€ ccoracle (???)
โ”œโ”€โ”€ elision_hybris (???)
โ”œโ”€โ”€ elision_mysql (???)
โ”œโ”€โ”€ elision_packages (???)
โ”œโ”€โ”€ elision_usergroup (???)
โ”œโ”€โ”€ erwbgy-limits (v0.3.1)
โ”œโ”€โ”€ fiddyspence-sysctl (v0.4.1)
โ”œโ”€โ”€ hajee-easy_type (v0.12.4)
โ””โ”€โ”€ hajee-oracle (v0.2.6)

But I receive following error:
Notice: /Stage[main]/Ccoracle/Oradb::Dbactions[stop testDb patch]/Exec[stop oracle database stop testDb patch]/returns: executed successfully
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Info: opatch result: Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home : /opt/product/11.2/db
Central Inventory : /opt/oraInventory
from : /opt/product/11.2/db/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.4.0
Log file location : /opt/product/11.2/db/cfgtoollogs/opatch/opatch2014-09-09_09-23-25AM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following executables are active :
/opt/product/11.2/db/lib/libclntsh.so.11.1
Log file location: /opt/product/11.2/db/cfgtoollogs/opatch/opatch2014-09-09_09-23-25AM_1.log

OPatch failed with error code 73

Error: Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home : /opt/product/11.2/db
Central Inventory : /opt/oraInventory
from : /opt/product/11.2/db/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.4.0
Log file location : /opt/product/11.2/db/cfgtoollogs/opatch/opatch2014-09-09_09-23-25AM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following executables are active :
/opt/product/11.2/db/lib/libclntsh.so.11.1
Log file location: /opt/product/11.2/db/cfgtoollogs/opatch/opatch2014-09-09_09-23-25AM_1.log

OPatch failed with error code 73

Error: /Stage[main]/Ccoracle/Oradb::Opatch[18031668_db_patch]/Db_opatch[18031668]/ensure: change from absent to present failed: Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home : /opt/product/11.2/db
Central Inventory : /opt/oraInventory
from : /opt/product/11.2/db/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.4.0
Log file location : /opt/product/11.2/db/cfgtoollogs/opatch/opatch2014-09-09_09-23-25AM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following executables are active :
/opt/product/11.2/db/lib/libclntsh.so.11.1
Log file location: /opt/product/11.2/db/cfgtoollogs/opatch/opatch2014-09-09_09-23-25AM_1.log

OPatch failed with error code 73

Do you know what is going wrong?

Kind regards

bash_profile for client installs

Is there a reason that setting bash_profile is not optional for the client? If not, would you add the toggle like on installdb?

database creation 12.1 using dbtemplate_12.1.dbt.erb fails

looks like 12.1 dbca fails on memoryPercentage, recoveryAreaDestination, totalMemory parameters

[main] [ 2016-02-03 08:26:00.864 PST ] [TemplateManager.validateTemplate:633] Tempalte validation failed with message: cvc-complex-type.2.4.a: Invalid content was found starting w
ith element 'memoryPercentage'. One of '{maxUserConn, percentageMemTOSGA, customSGA, characterSet, nationalCharacterSet, archiveLogMode, initParamFileName, dataVaultEnabled}' is ex
pected.

[main] [ 2016-02-03 08:46:27.865 PST ] [TemplateManager.validateTemplate:633] Tempalte validation failed with message: cvc-complex-type.2.4.a: Invalid content was found starting w
ith element 'recoveryAreaDestination'. One of '{maxUserConn, percentageMemTOSGA, customSGA, characterSet, nationalCharacterSet, archiveLogMode, initParamFileName, dataVaultEnabled}
' is expected.

[main] [ 2016-02-03 08:50:32.219 PST ] [TemplateManager.validateTemplate:633] Tempalte validation failed with message: cvc-complex-type.2.4.a: Invalid content was found starting w
ith element 'totalMemory'. One of '{maxUserConn, percentageMemTOSGA, customSGA, characterSet, nationalCharacterSet, archiveLogMode, initParamFileName, dataVaultEnabled}' is expecte
d.

set cwd during asm install

It would be helpful to add cwd to the exec for installasm. The root script and the install script will fail if the site's exec default cwd is / since the grid user does not have correct permissions on /.

I set root.sh to use $gridHome and install orracle grid to $gridBase

This is on sol11.2

I have not made it to installing oracle binaries yet, so this could also be the case there.

Hi biemond

how can I create 2 databases at the same time using oradb module.

Let me know

Thank you,
Supriya

/opt/grid/product/11.2.0/gr_1/bin/ocrconfig.bin: error while loading shared libraries: /opt/grid/product/11.2.0/gr_1/lib/libclntsh.so.11.1: file too short

Hello,

I'm trying to deploy a database with ASM and Grid but I keep getting this error :

/opt/grid/product/11.2.0/gr_1/bin/ocrconfig.bin: error while loading shared libraries: /opt/grid/product/11.2.0/gr_1/lib/libclntsh.so.11.1: file too short

And when I check its size it's 0 byte and there is no symlink pointing to another library

I'm out of idea, could you please help ?

Should you need more information, do not hesitate !

Thanks in advance and kind regards
Philippe

ASM instance sid for rac vs single instance

When setting the gridType to HA_CONFIG for a single instance ASM database, I get the sid of +ASM for ASM instance.
When setting the gridType to CRS_CONFIG for a RAC database, I get the sid of +ASM1 for ASM instance.

The grid user's bash_profile template should be expanded with a simple conditional for this.

Response file not generated during patching

Hello Edwin,

I'm trying to patch the oracle 11.2.0.3 home with your sample patch 14727310 and/or latest Oracle PSU patchset. When opatch is executed it fails with the error that the ocm.rsp file is missing. If I choose not to use a response file it tells me that it does need a response file when installing it in silence. How can I solve this issue?

Regards Michel

class profile::oracle-database-server::oradb {
oradb::opatch{'14727310_db_patch':
oracleProductHome => '/u01/oracle/11.2.0.3/db',
patchId => '14727310',
patchFile => 'p14727310_112030_Linux-x86-64.zip',
user => 'oracle',
group => 'oinstall',
downloadDir => '/install',
ocmrf => true,
require => Oradb::Opatchupgrade['112000_opatch_upgrade'],
puppetDownloadMntPoint => '/install/oracle',
remoteFile => false,
before => Oradb::Database['testDb_Create'],
}
}

Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatchupgrade[112000_opatch_upgrade]/Exec[extract opatch6-64.zip]/returns: executed successfully
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472racle Interim Patch Installer version 11.2.0.3.5
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472opyright (c) 2013, Oracle Corporation. All rights reserved.
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472rgument(s) Error... Given 'ocmrf' file does not exists.
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472lease check the arguments and try again.
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472
Notice: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 1472Patch failed with error code 135
Error: /u01/oracle/11.2.0.3/db/OPatch/opatch apply -silent -ocmrf /u01/oracle/11.2.0.3/db/OPatch/ocm.rsp -oh /u01/oracle/1310 returned 135 instead of one of [0]
Error: /Stage[main]/Profile::Oracle-database-server::Oradb/Oradb::Opatch[14727310_db_patch]/Exec[exec opatch ux ocmrf 14727ange from notrun to 0 failed: /u01/oracle/11.2.0.3/db/OPatch/opatch apply -silent -ocmrf /u01/oracle/11.2.0.3/db/OPatch/oc2.0.3/db /install/14727310 returned 135 instead of one of [0]

-bash-4.1$ /u01/oracle/11.2.0.3/db/OPatch/opatch apply -silent -oh /u01/oracle/11.2.0.3/db /install/14727310
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home : /u01/oracle/11.2.0.3/db
Central Inventory : /u02/oracle/oraInventory
from : /u01/oracle/11.2.0.3/db/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/oracle/11.2.0.3/db/cfgtoollogs/opatch/opatch2014-02-06_08-23-04AM_1.log

Verifying environment and performing prerequisite checks...
UtilSession failed:
To run in silent mode, OPatch requires a response file for Oracle Configuration Manager (OCM).
Please run "/u01/oracle/11.2.0.3/db/OPatch/ocm/bin/emocmrsp" to generate an OCM response file. The generated response file
can be reused on different platforms and in multiple OPatch silent installs.

To regenerate an OCM response file, Please rerun "/u01/oracle/11.2.0.3/db/OPatch/ocm/bin/emocmrsp".

Log file location: /u01/oracle/11.2.0.3/db/cfgtoollogs/opatch/opatch2014-02-06_08-23-04AM_1.log

OPatch failed with error code 73

opatch against 11.2.0.4 fails

opatch included with 11.2.0.4 ( opatch version 11.2.0.3.4 ) outputs string "OPatch succeeded", rather than "Opatch completed" which provider/db_opatch/db_opatch.rb expects.

installasm uses hardcoded path on unzip

installasm uses grid_${version} as a hardcoded path on unzip/silent install. This is noticed when using zipExtract => false as it does not match the documented example of installdb.

db_{control,listener} refreshonly always do a service restart

Hi Biemond,

What I wanted to achieve is stop the db instance only once after the opatchupgrade, then apply the patches but for some reason the stop db is being trigger every puppet run.

``Notice: /Stage[main]/Profile::Oracledb::Non_rac/Db_control[orclcondb stop_for_patching]/ensure: ensure changed 'start' to 'stop'`

oradb::opatchupgrade {  '12.1.0.1.10':
    oracle_home                          => $oracle_home,
    patch_file                                => 'p6880880_121010_SOLARIS64.zip',
    csi_number                             => undef,
    support_id                               => undef,
    opversion                                => '12.1.0.1.10',
    user                                        => $oracle_user,
    group                                      => $oracle_group,
    download_dir                          => '/install',
    puppet_download_mnt_point => '/var/tmp/oradb_patches',
 } 
 db_control { 'orclcondb stop_for_patching':
   ensure                              => 'stop',
   instance_name                 => 'orclcondb',
   oracle_product_home_dir => $oracle_home,
   os_user                             => $oracle_user,
   refreshonly                        => true,
   subscribe                          => Oradb::Opatchupgrade[,'12.1.0.1.10'],
 }
  oradb::opatch { '21948354':
   ensure                          => 'present',
   oracle_product_home  => $oracle_home,
   patch_id                       => '21948354',
   patch_file                     => 'p22191659_121020_SOLARIS64.zip',
   clusterware                  => false,
   use_opatchauto_utility => true,
   bundle_sub_patch_id  => undef,
   user                             => $oracle_user,
   group                           => $oracle_group,
   ocmrf                           => true,
   puppet_download_mnt_point => '/var/tmp/oradb_patches',
   require                          => Db_listener[ 'orclcondb stop_for_patching'],

`

cluster_nodes parameter is not used in database.pp

Unfortunately, I could not found any place where the cluster_nodes parameter is used in database.pp.
It would be nice if we could use this parameter for the -nodelist parameter from dbca to create a database in a RAC.

Missing resources?

In the README doc, it lists some native resources, but does not appear to have the corresponding types/provider. Are they available in another repo or are they wip? For example tablespace and oracle_user.

Oracle options

Hi,

Is there a way to configure which options will be installed?
For example if I don't need Oracle Text or Oracle Application Express or Spatial ...

Kind regards

error related to home directory during install on 11.2.0.3

Hello, I am using the module and notice some issues as you can see below. I believe that the home directory is not well set everywhere so that if /home/oracle is not used but /opt/oracle for instance, we some error appearing. you will find below my class and then the log going with:

::oradb::installdb { '11.2.0.3_Linux-x86-64':
version => '11.2.0.3',
file => 'p10404530_112030_Linux-x86-64',
databaseType => 'SE',
oracleBase => '/opt/oracle',
oracleHome => '/opt/oracle/product/11.2/db',
user => 'oracle',
group => 'dba',
group_install => 'oinstall',
downloadDir => '/install',
remoteFile => true,
puppetDownloadMntPoint => "puppet:///modules/oradb/",
}


Notice: oradb::installdb /opt/oracle/product/11.2/db does not exists
Notice: /Stage[main]/Profile::Oracle::Server_11203/Oradb::Installdb[11.2.0.3_Linux-x86-64]/Notify[oradb::installdb /opt/oracle/product/11.2/db does not exists]/message: defined 'message' as 'oradb::installdb /opt/oracle/product/11.2/db does not exists'
Notice: /Stage[main]/Profile::Oracle::Server_11203/Oradb::Installdb[11.2.0.3_Linux-x86-64]/Oradb::Utils::Dborainst[database orainst 11.2.0.3]/File[/etc/oraInst.loc]/ensure: created
Error: Could not set 'present' on ensure: No such file or directory - /home/oracle/.bash_profile20150417-10141-15kar6s.lock at 200:/etc/puppet/modules/oradb/manifests/installdb.pp
Error: Could not set 'present' on ensure: No such file or directory - /home/oracle/.bash_profile20150417-10141-15kar6s.lock at 200:/etc/puppet/modules/oradb/manifests/installdb.pp
Wrapped exception:
No such file or directory - /home/oracle/.bash_profile20150417-10141-15kar6s.lock
Error: /Stage[main]/Profile::Oracle::Server_11203/Oradb::Installdb[11.2.0.3_Linux-x86-64]/File[/home/oracle/.bash_profile]/ensure: change from absent to present failed: Could not set 'present' on ensure: No such file or directory - /home/oracle/.bash_profile20150417-10141-15kar6s.lock at 200:/etc/puppet/modules/oradb/manifests/installdb.pp

Seeded database Template capability (*.dbc)

We are trying to use the database.pp class to install the database. We were trying to use the Oracle Enterprise manager 12.1.0.5 template provided from oracle which has a *.dbc extension and it doesn't work with the *.dbt non seeded template.

So, Does this module support the EM 12.1.0.5 Template for database creation?

Oracle Patch 12539239 check: change from absent to present failed

Hello Edwin,

I have an issue with the opatch resource. I'm installing the following database software :
112030_Linux-x86-64
112000_opatch_upgrade
Install latest PSU patch: 18031683
after this, which is succesfull, I need to install a small OneOff patch 12539239.
I'm using the same Opatch resource as for PSU patch. :

oradb::opatch{"12539239_db_patch":
ensure => 'present',
oracleProductHome => "$oracleHome",
patchId => "12539239",
patchFile => "p12539239_112037_Linux-x86-64.zip",
user => "$user",
group => "$group",
downloadDir => "/tmp/oracle",
ocmrf => true,
require => Oradb::Opatch["${psuPatch}_db_patch"],
puppetDownloadMntPoint => "/software/oracle/rdbms/11g/patches/OneOff_patches/",
}

The opatch software applies this patch succesful but the check if it has been applied fails:

Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/11.2.0.3/db
Central Inventory : /u02/oracle/oraInventory
from : /u01/oracle/11.2.0.3/db/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/oracle/11.2.0.3/db/cfgtoollogs/opatch/opatch2014-09-16_13-50-20PM_1.log

Applying interim patch '12539239' to OH '/u01/oracle/11.2.0.3/db'
Verifying environment and performing prerequisite checks...
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/oracle/11.2.0.3/db')

Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...

Patching component oracle.rdbms, 11.2.0.3.0...

Verifying the update...
Patch 12539239 successfully applied
Log file location: /u01/oracle/11.2.0.3/db/cfgtoollogs/opatch/opatch2014-09-16_13-50-20PM_1.log

OPatch succeeded.

Error: /Stage[main]/Oracledb::Install/Oradb::Opatch[12539239_db_patch]/Db_opatch[12539239]/ensure: change from absent to present failed: Oracle
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home : /u01/oracle/11.2.0.3/db
Central Inventory : /u02/oracle/oraInventory
from : /u01/oracle/11.2.0.3/db/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/oracle/11.2.0.3/db/cfgtoollogs/opatch/opatch2014-09-16_13-50-20PM_1.log

Applying interim patch '12539239' to OH '/u01/oracle/11.2.0.3/db'
Verifying environment and performing prerequisite checks...
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/oracle/11.2.0.3/db')

Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...

Patching component oracle.rdbms, 11.2.0.3.0...

Verifying the update...
Patch 12539239 successfully applied
Log file location: /u01/oracle/11.2.0.3/db/cfgtoollogs/opatch/opatch2014-09-16_13-50-20PM_1.log

OPatch succeeded.

A check on the new host if the Oneoff patch has been applied is succesfull:

oracle@orabase:/u01/oracle/11.2.0.3/db/OPatch# ./opatch lsinventory |grep 12539239
Patch 12539239 : applied on Tue Sep 16 13:50:39 CEST 2014
12539239
oracle@orabase:/u01/oracle/11.2.0.3/db/OPatch#

I'm I doing something wrong or is there an small issue with the check within puppet?
Please advice.
Regards Michel

Install DB from local zip file

Hi,

I'm new in puppet so not sure I'm using your module correctly.

But I'm trying to install the Oracle DB in a Centos 6.4 machine (masterless) and when I apply the manifest the first time the it creates file: db_install_11.2.0.1.rsp and the temp zip file (for instance: linux.x64_11gR2_database_1of2.zip.puppettmp_3786) but it does not create the folder linux.x64_11gR2_database. When I apply the manifest a second time everything works wonder.

Here the my definition that I'm Using to install DB

$puppetDownloadMntPoint = "/home/vagrant"
$oracleBase = "/u01/app/oracle/"
$oracleHome = "/u01/app/oracle/product/11.2/db"

oradb::installdb{ '112010_Linux-x86-64':
version => '11.2.0.1',
file => 'linux.x64_11gR2_database',
databaseType => 'EE',
oracleBase => $oracleBase,
oracleHome => $oracleHome,
user => 'oracle',
group => 'dba',
group_install => 'oinstall',
group_oper => 'oper',
downloadDir => '/install',
zipExtract => true,
puppetDownloadMntPoint => $puppetDownloadMntPoint,
}
}`

Any Idea of why?

Thank you
Flavia

oradb::opatch{'22191577_grid does not work

11.2.0.4
p22378167_112040_linux-x86-64.zip

the switchpm fix is a hacky thingy but otherways it fails on that. Will try to make that into a pr later
Puppetcode:

$inst_dir = '/install'
$ora_gr_home = '/oracle/product/11.2.0/grid'

file {'switchpmfix':
  ensure => link,
  path   => '/usr/lib64/perl5/vendor_perl/Switch.pm',
  target => "${$ora_gr_home}/perl/lib/5.10.0/Switch.pm",
} ->

oradb::opatch{'22191577_grid_patch':
  ensure                    => present,
  oracle_product_home       => $ora_gr_home,
  patch_id                  => '22378167',
  patch_file                => 'p22378167_112040_linux-x86-64.zip',
  clusterware               => true,
  bundle_sub_patch_id       => '22191577', # sub patch_id of bundle patch ( else I can't detect it)
  #bundle_sub_folder         => '19380115', # optional subfolder inside the patch zip
  user                      => 'grid',
  group                     => 'oinstall',
  download_dir              => $inst_dir,
  ocmrf                     => true,
  puppet_download_mnt_point => $inst_dir,
  require                   => [Oradb::Opatchupgrade['112000_opatch_upgrade_asm'], File['switchpmfix'] ],
}

Error message:

Notice: /Stage[main]/Main/Oradb::Opatch[22191577_grid_patch]/Exec[extract opatch p22378167_112040_linux-x86-64.zip 22191577_grid_patch]/returns: executed successfully
Info: search for patchid 22191577
Info: opatch_status for patch 22378167 command: /oracle/product/11.2.0/grid/OPatch/opatch lsinventory -patch_id -oh /oracle/product/11.2.0/grid -invPtrLoc /etc/oraInst.loc
Info: opatch_status output NotFound for patchId 22191577
Info: opatch action: present with command /oracle/product/11.2.0/grid/OPatch/opatch auto /install/22378167  -ocmrf /oracle/product/11.2.0/grid/OPatch/ocm.rsp -oh /oracle/product/11.2.0/grid

Info: opatch result: Executing /oracle/product/11.2.0/grid/perl/bin/perl /oracle/product/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /install -patchn 22378167 -ocmrf /oracle/product/11.2.0/grid/OPatch/ocm.rsp -oh /oracle/product/11.2.0/grid -paramfile /oracle/product/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.report.log

2016-04-14 11:15:46: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/product/11.2.0/grid/crs/install/crsconfig_params
Enter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):ERROR: Unable to find patches

opatch auto failed.

Error: Executing /oracle/product/11.2.0/grid/perl/bin/perl /oracle/product/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /install -patchn 22378167 -ocmrf /oracle/product/11.2.0/grid/OPatch/ocm.rsp -oh /oracle/product/11.2.0/grid -paramfile /oracle/product/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.report.log

2016-04-14 11:15:46: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/product/11.2.0/grid/crs/install/crsconfig_params
Enter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):ERROR: Unable to find patches

opatch auto failed.

Error: /Stage[main]/Main/Oradb::Opatch[22191577_grid_patch]/Db_opatch[22378167 22191577_grid_patch]/ensure: change from absent to present failed: Executing /oracle/product/11.2.0/grid/perl/bin/perl /oracle/product/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /install -patchn 22378167 -ocmrf /oracle/product/11.2.0/grid/OPatch/ocm.rsp -oh /oracle/product/11.2.0/grid -paramfile /oracle/product/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.report.log

2016-04-14 11:15:46: Starting Oracle Restart Patch Setup
Using configuration parameter file: /oracle/product/11.2.0/grid/crs/install/crsconfig_params
Enter 'yes' if you have unzipped this patch to an empty directory to proceed  (yes/no):ERROR: Unable to find patches

opatch auto failed.

Notice: Finished catalog run in 85.34 seconds

Logfile

[root@lrv00061 OPatch]# cat /oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.log
2016-04-14 11:15:46: Using Oracle CRS home /oracle/product/11.2.0/grid
2016-04-14 11:15:46: The configuration parameter file /oracle/product/11.2.0/grid/crs/install/crsconfig_params is valid
2016-04-14 11:15:46: ### Printing the configuration values from files:
2016-04-14 11:15:46:    /oracle/product/11.2.0/grid/crs/install/crsconfig_params
2016-04-14 11:15:46:    /oracle/product/11.2.0/grid/crs/install/s_crsconfig_defs
2016-04-14 11:15:46: ASM_AU_SIZE=1
2016-04-14 11:15:46: ASM_DISCOVERY_STRING=
2016-04-14 11:15:46: ASM_DISKS=
2016-04-14 11:15:46: ASM_DISK_GROUP=
2016-04-14 11:15:46: ASM_REDUNDANCY=
2016-04-14 11:15:46: ASM_SPFILE=
2016-04-14 11:15:46: ASM_UPGRADE=false
2016-04-14 11:15:46: CLSCFG_MISSCOUNT=
2016-04-14 11:15:46: CLUSTER_GUID=
2016-04-14 11:15:46: CLUSTER_NAME=
2016-04-14 11:15:46: CRFHOME="/oracle/product/11.2.0/grid"
2016-04-14 11:15:46: CRS_LIMIT_CORE=unlimited
2016-04-14 11:15:46: CRS_LIMIT_MEMLOCK=unlimited
2016-04-14 11:15:46: CRS_LIMIT_OPENFILE=65536
2016-04-14 11:15:46: CRS_LIMIT_STACK=2048
2016-04-14 11:15:46: CRS_LSNR_STACK=10240
2016-04-14 11:15:46: CRS_NODEVIPS=
2016-04-14 11:15:46: CRS_STORAGE_OPTION=0
2016-04-14 11:15:46: CSS_LEASEDURATION=400
2016-04-14 11:15:46: DIRPREFIX=
2016-04-14 11:15:46: DISABLE_OPROCD=0
2016-04-14 11:15:46: EXTERNAL_ORACLE=/opt/oracle
2016-04-14 11:15:46: EXTERNAL_ORACLE_BIN=/opt/oracle/bin
2016-04-14 11:15:46: GNS_ADDR_LIST=
2016-04-14 11:15:46: GNS_ALLOW_NET_LIST=
2016-04-14 11:15:46: GNS_CONF=false
2016-04-14 11:15:46: GNS_DENY_ITF_LIST=
2016-04-14 11:15:46: GNS_DENY_NET_LIST=
2016-04-14 11:15:46: GNS_DOMAIN_LIST=
2016-04-14 11:15:46: GPNPCONFIGDIR=/oracle/product/11.2.0/grid
2016-04-14 11:15:46: GPNPGCONFIGDIR=/oracle/product/11.2.0/grid
2016-04-14 11:15:46: GPNP_PA=
2016-04-14 11:15:46: HOST_NAME_LIST=
2016-04-14 11:15:46: ID=/etc/init.d
2016-04-14 11:15:46: INIT=/sbin/init
2016-04-14 11:15:46: INITCTL=/sbin/initctl
2016-04-14 11:15:46: ISROLLING=true
2016-04-14 11:15:46: IT=/etc/inittab
2016-04-14 11:15:46: JLIBDIR=/oracle/product/11.2.0/grid/jlib
2016-04-14 11:15:46: JREDIR=/oracle/product/11.2.0/grid/jdk/jre/
2016-04-14 11:15:46: LANGUAGE_ID=AMERICAN_AMERICA.AL32UTF8
2016-04-14 11:15:46: MSGFILE=/var/adm/messages
2016-04-14 11:15:46: NETWORKS=
2016-04-14 11:15:46: NEW_HOST_NAME_LIST=
2016-04-14 11:15:46: NEW_NODEVIPS=
2016-04-14 11:15:46: NEW_NODE_NAME_LIST=
2016-04-14 11:15:46: NEW_PRIVATE_NAME_LIST=
2016-04-14 11:15:46: NODELIST=
2016-04-14 11:15:46: NODE_NAME_LIST=
2016-04-14 11:15:46: OCFS_CONFIG=
2016-04-14 11:15:46: OCRCONFIG=/etc/oracle/ocr.loc
2016-04-14 11:15:46: OCRCONFIGDIR=/etc/oracle
2016-04-14 11:15:46: OCRID=
2016-04-14 11:15:46: OCRLOC=ocr.loc
2016-04-14 11:15:46: OCR_LOCATIONS=NO_VAL
2016-04-14 11:15:46: OLASTGASPDIR=/etc/oracle/lastgasp
2016-04-14 11:15:46: OLD_CRS_HOME=
2016-04-14 11:15:46: OLRCONFIG=/etc/oracle/olr.loc
2016-04-14 11:15:46: OLRCONFIGDIR=/etc/oracle
2016-04-14 11:15:46: OLRLOC=olr.loc
2016-04-14 11:15:46: OPROCDCHECKDIR=/etc/oracle/oprocd/check
2016-04-14 11:15:46: OPROCDDIR=/etc/oracle/oprocd
2016-04-14 11:15:46: OPROCDFATALDIR=/etc/oracle/oprocd/fatal
2016-04-14 11:15:46: OPROCDSTOPDIR=/etc/oracle/oprocd/stop
2016-04-14 11:15:46: ORACLE_BASE=/oracle/grid
2016-04-14 11:15:46: ORACLE_HOME=/oracle/product/11.2.0/grid
2016-04-14 11:15:46: ORACLE_OWNER=grid
2016-04-14 11:15:46: ORA_ASM_GROUP=asmadmin
2016-04-14 11:15:46: ORA_DBA_GROUP=oinstall
2016-04-14 11:15:46: PRIVATE_NAME_LIST=
2016-04-14 11:15:46: RCALLDIR=/etc/rc.d/rc0.d /etc/rc.d/rc1.d /etc/rc.d/rc2.d /etc/rc.d/rc3.d /etc/rc.d/rc4.d /etc/rc.d/rc5.d /etc/rc.d/rc6.d
2016-04-14 11:15:46: RCKDIR=/etc/rc.d/rc0.d /etc/rc.d/rc1.d /etc/rc.d/rc2.d /etc/rc.d/rc4.d /etc/rc.d/rc6.d
2016-04-14 11:15:46: RCSDIR=/etc/rc.d/rc3.d /etc/rc.d/rc5.d
2016-04-14 11:15:46: RC_KILL=K15
2016-04-14 11:15:46: RC_KILL_OLD=K96
2016-04-14 11:15:46: RC_KILL_OLD2=K19
2016-04-14 11:15:46: RC_START=S96
2016-04-14 11:15:46: REUSEDG=false
2016-04-14 11:15:46: SCAN_NAME=
2016-04-14 11:15:46: SCAN_PORT=0
2016-04-14 11:15:46: SCRBASE=/etc/oracle/scls_scr
2016-04-14 11:15:46: SILENT=true
2016-04-14 11:15:46: SO_EXT=so
2016-04-14 11:15:46: SRVCFGLOC=srvConfig.loc
2016-04-14 11:15:46: SRVCONFIG=/var/opt/oracle/srvConfig.loc
2016-04-14 11:15:46: SRVCONFIGDIR=/var/opt/oracle
2016-04-14 11:15:46: TZ=Europe/Amsterdam
2016-04-14 11:15:46: UPSTART_INIT_DIR=/etc/init
2016-04-14 11:15:46: USER_IGNORED_PREREQ=true
2016-04-14 11:15:46: VNDR_CLUSTER=false
2016-04-14 11:15:46: VOTING_DISKS=NO_VAL
2016-04-14 11:15:46: ### Printing other configuration values ###
2016-04-14 11:15:46: CLSCFG_EXTRA_PARMS=
2016-04-14 11:15:46: HAS_GROUP=oinstall
2016-04-14 11:15:46: HAS_USER=grid
2016-04-14 11:15:46: HOST=lrv00061
2016-04-14 11:15:46: IS_SIHA=1
2016-04-14 11:15:46: OLR_DIRECTORY=/oracle/product/11.2.0/grid/cdata/localhost
2016-04-14 11:15:46: OLR_LOCATION=/oracle/product/11.2.0/grid/cdata/localhost/lrv00061.olr
2016-04-14 11:15:46: ORA_CRS_HOME=/oracle/product/11.2.0/grid
2016-04-14 11:15:46: SUPERUSER=root
2016-04-14 11:15:46: crscfg_trace=1
2016-04-14 11:15:46: crscfg_trace_file=/oracle/product/11.2.0/grid/cfgtoollogs/opatchauto2016-04-14_11-15-46.log
2016-04-14 11:15:46: hosts=
2016-04-14 11:15:46: osdfile=/oracle/product/11.2.0/grid/crs/install/s_crsconfig_defs
2016-04-14 11:15:46: parameters_valid=1
2016-04-14 11:15:46: paramfile=/oracle/product/11.2.0/grid/crs/install/crsconfig_params
2016-04-14 11:15:46: platform_family=unix
2016-04-14 11:15:46: srvctl_trc_suff=0
2016-04-14 11:15:46: user_is_superuser=1
2016-04-14 11:15:46: ### Printing of configuration values complete ###
2016-04-14 11:15:46: INC is /oracle/product/11.2.0/grid/crs/install /oracle/product/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /oracle/product/11.2.0/grid/perl/lib/5.10.0 /oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0 /oracle/product/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /oracle/product/11.2.0/grid/perl/lib/5.10.0/x86_64-linux-thread-multi /oracle/product/11.2.0/grid/perl/lib/5.10.0 /oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oracle/product/11.2.0/grid/perl/lib/site_perl/5.10.0 /oracle/product/11.2.0/grid/perl/lib/site_perl .

2016-04-14 11:15:46: No -patchfile specified, assuming the patch is already uncompressed
2016-04-14 11:15:46: Oracle user for /oracle/product/11.2.0/grid is grid
2016-04-14 11:15:46: Executing /bin/mkdir -m 777 -p /oracle/product/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch as grid
2016-04-14 11:15:46: Running as user grid: /bin/mkdir -m 777 -p /oracle/product/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch
2016-04-14 11:15:46: s_run_as_user2: Running /bin/su grid -c ' /bin/mkdir -m 777 -p /oracle/product/11.2.0/grid/cfgtoollogs/opatchauto/core/opatch '
2016-04-14 11:15:46: Removing file /tmp/filegzUsW1
2016-04-14 11:15:46: Successfully removed file: /tmp/filegzUsW1
2016-04-14 11:15:46: /bin/su successfully executed

2016-04-14 11:15:46: Status: 0
2016-04-14 11:15:46: ERROR: Unable to find patches

12.102 Install Issue

Hello,

I am not sure if this relates to 12.102 or not, but I was able to successfully get through everything and modify the site.pp file to allow for the minor release, but I get an error. The actual release file on the Oracle site (I can no longer download 12.101 or I would!) has an 'se2' in it, which may or may not be relevant. I successfully get all the way down to the listener starting, but then here is the error message set I get (more notes below the error):

Notice: /Stage[main]/Oradb_12c/Oradb::Database[oraDb]/Exec[oracle database oraDb]/returns: Copying database files
Notice: /Stage[main]/Oradb_12c/Oradb::Database[oraDb]/Exec[oracle database oraDb]/returns: 1% complete
Notice: /Stage[main]/Oradb_12c/Oradb::Database[oraDb]/Exec[oracle database oraDb]/returns: 2% complete
Notice: /Stage[main]/Oradb_12c/Oradb::Database[oraDb]/Exec[oracle database oraDb]/returns: 4% complete
Notice: /Stage[main]/Oradb_12c/Oradb::Database[oraDb]/Exec[oracle database oraDb]/returns: DBCA Operation failed.
Notice: /Stage[main]/Oradb_12c/Oradb::Database[oraDb]/Exec[oracle database oraDb]/returns: Look at the log file "/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.
Error: /oracle/product/12.1/db/bin/dbca -silent -responseFile /var/tmp/install/database_oraDb.rsp returned 1 instead of one of [0]
Error: /Stage[main]/Oradb_12c/Oradb::Database[oraDb]/Exec[oracle database oraDb]/returns: change from notrun to 0 failed: /oracle/product/12.1/db/bin/dbca -silent -responseFile /var/tmp/install/database_oraDb.rsp returned 1 instead of one of [0]
Notice: /Stage[main]/Oradb_12c/Oradb::Dbactions[start oraDb]/Db_control[instance control start oraDb]: Dependency Exec[oracle database oraDb] has failures: true
Warning: /Stage[main]/Oradb_12c/Oradb::Dbactions[start oraDb]/Db_control[instance control start oraDb]: Skipping because of failed dependencies
Notice: /Stage[main]/Oradb_12c/Oradb::Autostartdatabase[autostart oracle]/Exec[set dbora soarepos:/oracle/product/12.1/db]: Dependency Exec[oracle database oraDb] has failures: true
Warning: /Stage[main]/Oradb_12c/Oradb::Autostartdatabase[autostart oracle]/Exec[set dbora soarepos:/oracle/product/12.1/db]: Skipping because of failed dependencies

I changed the site.pp file to what is attached! Thank you so much in advance... I have been working on this for ages and really want to use this image, and if this isn't an 'issue', but something else, if you can point me in the right direction I would appreciate it!

-Adrienne
site.txt

Invalid content was found starting with element 'PROXY_REALM'

I'm getting the following Error which this puppet module. Not sure if the response file needs to be updated or if I have a different problem. This is on an Amazon AWS instance and I have no swap file. *This is a client install only. *

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB. Actual 57316 MB Passed
Checking swap space: 0 MB available, 150 MB required. Failed <<<<

Ignoring required pre-requisite failures. Continuing...

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-03-24_03-40-05PM. Please wait ...[FATAL] [INS-10105] The given response file /install/db_client_11.2.0.4.rsp is not valid.
CAUSE: Syntactically incorrect response file. Either unexpected variables are specified or expected variables are not specified in the response file.
ACTION: Refer the latest product specific response file template
SUMMARY:
- cvc-complex-type.2.4.a: Invalid content was found starting with element 'PROXY_REALM'. One of '{"":oracle.install.responseFileVersion, "":oracle.install.client.installType, _**"":SELECTED_LANGUAGES, "":ORACLE_HOSTNAME, "":INVENTORY_LOCATION, "":UNIX_GROUP_NAME, "":ORACLE_BASE, "":ORACLE_HOME, "":oracle.install.client.oramtsPortNumber, "":oracle.install.client.customComponents, "":oracle.install.client.schedulerAgentHostName, "":oracle.install.client.schedulerAgentPortNumber}' is expected.

Add oraInventory to client.pp optional parameters

For a supplier we had to put the orainventory directory one level up from where it is when you install it through your puppet module. Currently it is set somewhere in the code, but by moving it between the () section in client.pp, it is made an optional parameter. As far as I could see it was a 'harmless' modification and helped us out. The diff:

[root@someserver environments]# diff {mam,production}/modules/oradb/manifests/client.pp
9d8
<   $oraInventory            = "${oracleBase}/oraInventory",
33a33,34
> 
>   $oraInventory = "${oracleBase}/oraInventory"

prepareautostart failed due to chkconfig(version 1.3.30.2) in Oracle Linux Server release 5.7

It's due to the code in prepareautostart.pp

unless         => "chkconfig | /bin/grep 'dbora'",

with testing

[xxx@domain ~]$ cat /etc/issue | grep Linux
Oracle Linux Server release 5.7

[xxx@domain ~]$ chkconfig  | /bin/grep 'dbora'
chkconfig version 1.3.30.2 - Copyright (C) 1997-2000 Red Hat, Inc.
This may be freely redistributed under the terms of the GNU Public License.

usage:   chkconfig --list [name]
         chkconfig --add <name>
         chkconfig --del <name>
         chkconfig [--level <levels>] <name> <on|off|reset|resetpriorities>

[xxx@domain ~]$ chkconfig  --list | /bin/grep 'dbora'
dbora           0:off   1:off   2:off   3:on    4:on    5:on    6:off

,so change the unless check code , then okay, both works in Oracle Linux 5 & 6

unless         => "chkconfig --list | /bin/grep 'dbora'",

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.