The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [sqlplus]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
1answer
114 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
579 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 ...
0
votes
0answers
239 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 ...
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?