Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sqlplus]

The tag has no usage guidance.

2
votes
1answer
60 views

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 ...
0
votes
2answers
263 views

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 ...
1
vote
2answers
8k 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 192.168.168....
0
votes
1answer
663 views

ORA-12154 when trying to connect as SYSDBA

here is my environment Oracle 12.2 NON-CDB The oracle user is part of dba and oinstall group as follows $ id oracle uid=1000(oracle) gid=54322(dba) groups=54322(dba),54321(oinstall) The ORAPW file ...
1
vote
1answer
376 views

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 ...
0
votes
1answer
8k views

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 ...
0
votes
2answers
12k 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 ...
0
votes
0answers
233 views

vpnc timeout on Oracle DB

We are using a VPN to connect with our Oracle Database. We use vpnc and start it with: vpnc /etc/vpnc/our.conf After that we execute our firewall script. We use sqlplus64 to verify the connection and ...
0
votes
0answers
42 views

Is using sqlplus in a server environment considered as a bad practice?

We have a web application (a COTS product) and we need to query the application DB periodically using an external scheduler for alert purposes. DB is Oracle, se we decided to schedule a job on the ...
1
vote
1answer
7k 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
559 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. ...
111
votes
10answers
380k 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 ...
2
votes
2answers
6k 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 ...
4
votes
4answers
9k 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. tsegay@server-name:/u01/app/oracle/product/10.2.0/db_1/...
4
votes
3answers
11k 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
1answer
101 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
54 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?
1
vote
1answer
7k 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 ...
3
votes
1answer
7k 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, ...
0
votes
1answer
657 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 ...
1
vote
2answers
12k views

Starting SQLPlus in linux

How do you start sqlplus in linux? I know this is a service in windows.
0
votes
1answer
2k 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 /apps/...