search for: sqlplus

...eless.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 component using SQLPlus*: sqlplus system at DBname When the password prompt appears: Enter password: I type in the password and viola!!! the password appears on the screen! I try to use a password file (sort of like an .INI file) and the password again shows up on the screen. Needless to say, this compromises my sec...

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 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 since I can''t install OCI8 and I can''t install SQLPlus since I can''t install Oracle on AMD...

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

Has anyone experienced "hangs" with the WEBrick/OCI8 combination? The sequence of actions I perform to consistently get WEBrick to hang is: 1. start WEBrick 2. list a table form my Oracle 10g DB 3. startup sqlplus and update a few records in the table 4. go back to my browser and reload the table Here none of the chances I made directly to the table are reflected in the listing. Restarting WEBrick and/or the browser does not help either. 5. hit the "edit" button for a record that I know I'...

Hi All, Please provide the syntax for executing sqlplus command and need more information on creating database and managing database using puppet. Thanks, Feroz -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe...

Hi guys, I have a working samba and openldap pdc which is actively being tested. I have a group of users that have specifics tools to use such as oracle client tools (sqlplus etc). I tried to logon as a test user and run the sqlplus but nothing happened, I tried adding this user to the local poweruser group but it produced the same result. Can this be achieved? It works fine if this user is a member of local admin group which I dont want to do because I want to limit...

http://bugzilla.mindrot.org/show_bug.cgi?id=469 ------- Additional Comments From markus at openbsd.org 2003-01-26 22:39 ------- sorry, what exactly are you doing? ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee.

> I generate with SQL*Plus a CSV file. How to convert this to PDF? Or more > generally: how to get SQL*Plus output to PDF on Linux? Marked as Off Topic. I would do this: sqlplus SET MARKUP HTML ON SPOOL foo.html SELECT * FROM emp; SPOOL OFF Quit sqlplus and use htmldoc to convert foo.html to foo.pdf, or load it in a browser and use CutePDF or something to print it to a .pdf if in a hurry. Josh

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 about missing sym...

...couldn''t find any Rails-specific info about this on google. Here are the circumstances: /usr/local/bin/ruby --version ruby 1.8.4 (2005-12-24) [i686-linux] /usr/local/bin/rails --version Rails 1.1.6 ## Create mcd app rails mcd -d oracle cd mcd ## Create oracle tablespace & user sqlplus ''/ as sysdba'' create tablespace mcd datafile ''/oracle/oradata/d102/mcd_0.dbf'' SIZE 500M; create user mcd identified by XXX default tablespace mcd ; grant select_catalog_role, connect, resource, XXX, create session to mcd; ## Start server app ruby script/se...

I searched this site on Oracle && MySql, nothing came up, so perhaps this is a new topic for this forum. I''d like to access two databases from the same application simultaneously (well, more precisely, in rapid succession, calling one first and then the other, as any "joins" will be done in the application code). One database is in MySql, the other is Oracle.

How can I configure oracle to run under wine in linux. I tried copy the configuration as I had in windows, but did not work. Someone can help me ? thanks. piu.

Is rails + oci8 + mac os x intel a winning combination? It appears that oci8 might be a issue.

We''re running a Solaris 10 container, with an Oracle 9.2.0.4 database - every 5-10 min, an Oracle process shoots up (using 20% + CPU) and then goes down in CPU %, doing a [i]pollsys [/i](see it via dtruss). I tried using some of the trace scripts in the Dtracetoolkit to see what the process is doing, but without any luck - also tried with the following, but dtrace process goes up to 30%

I have a table with "expires_on" a DATE field. "Show" and "Destroy" work, but "Edit" errors: /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:150:in `select_hour'' /usr/local/lib/ruby/gems/1.8/gems/actionpack-1.11.2/lib/action_view/helpers/date_helper.rb:149:in `select_hour'' It only happens when

Hi all CentOS users, I have writing shell script for check oracle processes in real time and alert with e-mail. I read script like below NUMBEROFPRO=/oracle/10.2.0/db_1/bin/sqlplus / as sysdba <<EOF1 |grep processes|awk '{print $2}' SELECT resource_name,current_utilization,limit_value FROM V\$RESOURCE_LIMIT WHERE RESOURCE_NAME IN ('processes','sessions'); quit EOF1 if [ $NUMBEROFPRO > 150 ] then /bin/mail -s "Processes number bigger then...

...ccording to the architecture of your server. Download the following two (2) RPM packages: * oracle-instantclient11.2-basic-11.2.0.2.0.ARCH.rpm * oracle-instantclient11.2-11.2.0.2.0.ARCH.rpm after compared this with content of spacewalk wiki, I think this should be oracle-instantclient11.2-sqlplus-11.2.0.2.0.ARCH.rpm So, could someone correct this mistake, then I colud update the Chinese version ? GaoHu -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos-docs/attachments/20110508/9baa5f84/attachment-0006.html>

...v=dbDriver("Oracle") and it complains about not finding a function. The DBI.pdf does not require anything else installed, but looking at the archive I discovered there is more stuff to be installed. This is on Solaris 5.10 with a full Oracle install, so all Oracle libs are available and sqlplus works. I am trying to connect remotely to another Oracle instance. Thank you very much Stephen [[alternative HTML version deleted]]

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 the quick-and-dirty rout...