0
votes
1answer
76 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. ...
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
4k 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
970 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 ...
1
vote
2answers
3k 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
393 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 ...
44
votes
10answers
111k 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 ...