similar to: Execute sqlplus command in oracle 11g

Hi This is Anjan and I am creating a module to create a database for oracle 11g. I have a problem to execute a cmd ie sqlplus "/as sysdba" @/home/oracle/cr_$dbn Please tell how to exucute the above cmds through puppet module. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to

I downloaded the RPMs from the Oracle web site (otn.oracle.com) and successfully installed them on my C5 box, but the sqlplus client software would not run properly. After a few iterations with sealert, I finally got a handle on what was happening. It turns out that most of the shared libraries Oracle installs need to have their SElinux file context modified to allow relocation. Here's

http://bugzilla.mindrot.org/show_bug.cgi?id=469 ------- Additional Comments From robert.ozark at weblinkwireless.com 2003-05-07 04:54 ------- Sorry for the delay in getting back to you, but I just got back to working on NT problems. Problem: when I login to my NT4.0 server, using VanDyke's SecureCRT4.0 and SSH2, I get the usual screen. All seems well. Now I connect to the Oracle

Hi folks I have here a CentOS box where i need to setup cronjob (with session to remote Oracle instance). On the remote DB i have no access, expect limited user. How to avoid putting passwords in shell scripts? The solution doesn't need to be perfect, only better than plain text passwords in scripts. Mostly remote host only support password authentication (no certificates and so on).

Hi all, I'm trying to run an AGI in PERL which uses the module DBD-Oracle. Currently my AGI is working fine in my two servers but not in my other four servers. When I tried execute an AGI (as a user asterisk) in command line it works fine (even I also declare environmental variables in user profile and in my AGI), but when I tried to call my AGI (perl) in dial plan, it don't get

Hi folks, Does anyone know how to install the OCI8 ruby interface on Debian64 without having to install Oracle? My understanding, from experience with Debian i386, is that you need Oracle (specifically the SQLPlus) installed to be able to compile OCI8. Since my new dev machine is AMD64 running Debian, I''m stuck. My rails applications need to connect to a remote Oracle 10g, but cannot

Hello, I am running Linux, I have downloaded instantclient-basiclite-linux32-11.2.0.2.0.zip instantclient-sqlplus-linux32-11.2.0.2.0.zip instantclient-sdk-linux32-11.2.0.2.0.zip instantclient-precomp-linux32-11.2.0.2.0.zip All these tarballs are unzipped in /usr/local/lib/instantclient, I have added this path in the library path of the host. I can run sqlplus and proc, they do not complain

Hi all I am running two node active/passive cluster on RHEL3U8-64 bit operating system for my oracle 9i database.I am facing issue when cluster fail over to node 2 my oracle start up script not starting up even though i configured start up script in my cluster configuration but if i type clustat on node 2 it shows service is started. If i shift the service manually from node 2 to node 1 or even

Has anyone got a puppetmaster to populate a remote oracle server? The only thing I have found is http://www.djelibeybi.net/2010/08/using-oracle-database-for-puppet-stored-configuration/ I have installed the prerequisties, yet I when I run: puppet master --no-daemonize --verbose --debug I get no indication of any database activity and I get no tables created in my database when a client asks

Hi, I have installed the Puppet and configured the Client / server set up. I have noticed that when I place any code in site.pp on server machine, that is executed in regular intervals of time and runs the script on client. Is there any command that takes the Client IP as parameter and executes the modules specified on the client. Thanks in advance, Sateesh B. -- You received this message

Hi, puppet 3.6.1 on a vanilla trusty ubuntu server, trying to install oracle-jdk: class { 'java': distribution => 'oracle-jdk', version => 'latest', } exits with the following error: Error: Could not update: Execution of '/usr/bin/apt-get -q -y -o DPkg::Options::=--force-confold install oracle-j2sdk1.7' returned 100: Reading package

Hi All, Thank's for your hint Tim Panton I could connect my asterisk machine to my oracle machine. I used unixODBC-2.2.11.tar.gz, oracle-instantclient-basic-10.2.0.3-1.i386.rpm, oracle-instantclient-sqlplus-10.2.0.3-1.i386.rpm and the drive from www.oracle.com (odbc-oracle-3.1.0-linux-x86-glibc.tar) to configure my asterisk machine. I can connect to my oracle machine with isql and in

Hey; I''m still very new to puppet having *just* finished the pro puppet book. Going to have to go back to that a few times for re-reading, I suspect. Any rate, I have a client who''s leaning very heavily towards OEM w/the configuration management pack. Despite some fairly exhaustive google sessions, I haven''t been able to find a direct comparison between these

Hello, I installed RGui 2.5.1 and package DBI on Windows XP and tried to connect to Oracle database which is on a Linux server. When I tried to use dbDriver("Oracle"), I got an error as follows: > drv <- dbDriver("Oracle") Error in do.call(as.character(drvName), list(...)) : could not find function "Oracle" > Could anyone tell me how

Howdy, I'm trying to use R to access Oracle 8i using the RODBC package On Linux Red Hat 7.3. Specs R version 1.51 Driver: Easysoft ODBC - Oracle driver Driver Manager: unixODBC I get the following error when trying to executing RODBC commands. Can anybody give me pointers as to what I'm missing or doing wrong > library(RODBC) > channel <- ("DSNName") >

R-help, I get the following error message when trying to connect to an Oracle database through R (2.8.1) under Linux (Ubuntu 9.04). > channel<-odbcConnect("magnus",uid="luisr",pwd="juanayzakarias") Warning messages: 1: In odbcDriverConnect(st, ...) : [RODBC] ERROR: state IM002, code 0, message [unixODBC][DriverManager]Data source name not found, and no

Hi all Today I face a problem at wine 1.1.15 I am working at oracle SqlPlus and then i open OpenOffice at wine. Then I receive a problem $wine scalc.exe fixme:file:MoveFileWithProgressW MOVEFILE_WRITE_THROUGH unimplemented err:dbghelp:pe_load_dbg_file Couldn't find .DBG file "ole32.dbg" ("\xa4\xe93") err:dbghelp:pe_load_dbg_file Couldn't find .DBG file

Hi, I am running the 64bit version of R on a AIX RS6000 cluster on which is also running the ' SQL*Plus: Release 9.2.0.2.0' in the 'ORACLE-environment Version 64 bit AIX 5.1'. I have problems setting up an Oralce database connection. I can instantiate a driver using drv <- Oracle(). But when I try to connect to my database using dbConnect (dbConnect(drv,

Has anybody gotten Oracle client programs to work on Wine? I'd like to study your environment to see how I could make mine work on wine. I have sqlplus and tnsping working but any OCI or OO4O related programs for Oracle do not work currently. -Crispin

Long afternoon, but finally got it. Hope this spares you some pain: Installation instructions mainly based on: http://ruby.about.com/od/enterprise/ss/ruby_oracle.htm Install Oracle Instant Client: mkdir C:\oracle cd c:\oracle Get the following files from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html and unzip them into the c:\oracle\ unzip