All Questions
20
questions
1
vote
2
answers
7k
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 ...
3
votes
1
answer
716
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
1
answer
2k
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
1
answer
900
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 ...
1
vote
2
answers
23k
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
0
answers
375
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
0
answers
80
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 ...
0
votes
1
answer
638
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. ...
3
votes
2
answers
11k
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....
1
vote
1
answer
10k
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
1
answer
62
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
1
answer
8k
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
4
answers
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
1
answer
9k
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
2
answers
8k
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 ...