The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
113 views

SQLPlus for Oracle 11 not rolling back

I have a shell script which invokes an SQL file. However even with AUTOCOMMIT OFF and on SQLERROR EXIT ROLLBACK. Sqlplus fails to rollback. My sql file has 3 lines 3 are correct and 1 is incorrect. ...
1
vote
2answers
2k views

Running SQL*Plus with bash causes wrong encoding

I have a problem with running SQL*Plus in the bash. Here is my code #!/bin/bash #curl http://192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql > script.sql wget -O script.sql ...
1
vote
1answer
1k views

ORA-12514: Message 12514 not found with two Oracle clients

A user is getting the following error when attempting to connect to an Oracle database through an Oracle Forms app. I also get the same error when I try to connect from their computer using sqlplus. ...
1
vote
1answer
87 views

gqlplus Too many open files [closed]

When compiling gqlplus.sf.net it throws: Too many open files What is causing this? After make, I usually do a cp gqlplus sqlplus
0
votes
1answer
47 views

Problem installing Oracle

I'm not an Oracle DBA, but now must install a instance. I use sqlplus to login but all commands return '2' Why is this so?
0
votes
1answer
3k views

sqlplus: I have a table that's more than 20 columns wide. How can I display it properly

In sqlplus from Oracle XE Client 10, I want to run select * from t_abc where rownum<11 on sqlplus I planned to save the result into a text file that I can view with a text viewer. I've learned ...
4
votes
4answers
5k views

starting oracle 10g on ubuntu, Listener failed to start

I have installed oracle 10g on a ubuntu 10.x, This is my first time installation. After installing I tried to start it with the command below. ...
0
votes
1answer
1k views

PL/SQL Plus script just gives me numbers

I have an PL/SQL Script that I'm trying to run from the command shell with SQLPLUS. However, whenever I go to run it, All I get back is a number and a cursor waiting for some input. When I hit enter, ...
2
votes
2answers
2k views

Executing Oracle SQLPlus in a Powershell Invoke-Command statement against a remote machine

We have a basic powershell script that attempts to execute SQLPlus.exe on a remote machine. The remote does not have Oracle Instant client installed, but we have bundled all the necesary dlls in a ...
3
votes
3answers
2k views

Oracle Instant Client installation woes - “HTTP proxy setting has incorrect value”

When I run sqlplus I get the following error: #sqlplus Error 46 initializing SQL*Plus HTTP proxy setting has incorrect value SP2-1502: The HTTP proxy server specified by http_proxy is not ...
0
votes
1answer
1k views

sqlplus CONNECT command with an '@' symbol in the password

I'm trying to connect to an Oracle XE database using sqlplus.exe with the following command: CONNECT SYSTEM/password@ Yes that's right, the '@' symbol is the last letter of the password, and needs ...
1
vote
2answers
4k views

Starting SQLPlus in linux

How do you start sqlplus in linux? I know this is a service in windows.
0
votes
1answer
1k views

installing Oracle Instant Client 10.2 on Solaris

we are trying to install Oracle Instant Client 10.2.0.2 for Solaris x86-64 in order to connect to an Oracle database on another server. I downloaded and unzipped the required files into an ...
0
votes
1answer
404 views

How to handle oracle installations with same SID on same subnet?

I have two Oracle RAC clusters on the same subnet. For this discussion, let's assume one is a QA cluster and one is a DEV cluster. They are both running on RedHat Enterprise Linux 5, 64-bit. They are ...
46
votes
10answers
122k views

Run Oracle SQL script and exit from sqlplus.exe via command prompt

I would like to run an Oracle script through SQL Plus via a Windows command prompt. The script does not contain an "exit" command, but I would still like SQL Plus to exit, returning control to the ...