Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sqlplus]

22 questions
140
votes
11 answers

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 command prompt on completion of the script. My goal…
JoshL
  • 1,595
  • 3
  • 13
  • 11
4
votes
4 answers

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. tsegay@server-name:/u01/app/oracle/product/10.2.0/db_1/bin$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0…
tkt986
  • 141
  • 1
  • 3
4
votes
3 answers

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 accessible I've just installed the oracle instant client…
chickeninabiscuit
  • 1,104
  • 6
  • 20
  • 33
3
votes
1 answer

Exit sqlplus on error but not warning

We have a script that deploys code to our database as part of our application deployments. Currently, if a view or package errors, it ignores that error and moves on. We want it to fail at that point and exit sqlplus. I found the WHENEVER SQLERROR…
Dessa Simpson
  • 539
  • 7
  • 27
3
votes
2 answers

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 192.168.168.165:8080/api_test/xsql/f_exp_order_1016.xsql set…
Petr Mensik
  • 235
  • 1
  • 3
  • 11
3
votes
1 answer

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, it just increments the number and repeats the…
Scott
  • 199
  • 4
  • 6
2
votes
2 answers

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 remote folder. For example we have sqlplus.exe and…
Scott Muc
  • 918
  • 10
  • 9
1
vote
1 answer

SQLPlus: Execute SQL scripts located on database server machine

Is there a possibility to execute an SQL script that is located on the database server using SQLPlus? For example, if I execute @@?/rdbms/admin/awrrpti.sql the SQL file located on the client machine is used (if existent). Can I tell SQLPlus to look…
Gernot R. Bauer
  • 113
  • 4
1
vote
2 answers

SQL Developer cannot connect but SQL*plus can

I have a developer who is able to connect to Oracle database using SQL*Plus from command line. But the person is not able to connect by using SQL*Developer. The error is as follows : "IO Error: The network adapter could not establish the connection"
oradbanj
  • 161
  • 1
  • 1
  • 6
1
vote
1 answer

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. ORA-12514: Message 12514 not found;…
Jivlain
  • 111
  • 1
  • 4
1
vote
1 answer

gqlplus Too many open files

When compiling gqlplus.sf.net it throws: Too many open files What is causing this? After make, I usually do a cp gqlplus sqlplus
Juergen
  • 11
  • 2
1
vote
1 answer

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 about spool and set pagesize 10000. If each record stays…
Haozhun
  • 267
  • 2
  • 5
  • 10
1
vote
2 answers

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 escaping. :( Many thanks. See also Oracle pl-sql…
ian_scho
  • 113
  • 1
  • 1
  • 7
1
vote
2 answers

Starting SQLPlus in linux

How do you start sqlplus in linux? I know this is a service in windows.
sandos
  • 160
  • 1
  • 1
  • 6
0
votes
2 answers

Escape all characters that shell or sqlplus need escaped in any password given

You may try for yourself by creating this user: CREATE USER "karl" IDENTIFIED BY "/?'!@#$%^&*()_+=-~`" (Maybe there are other symbols I should have included for my testing, but that seemed like a good start) These characters seem to all be…
Karl Henselin
  • 113
  • 1
  • 2
  • 8
1
2