Questions tagged [sqlplus]
22 questions
0
votes
1 answer
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 has been created using ORAPWD utility
ORACLE_HOME…
oradbanj
- 161
- 1
- 1
- 6
0
votes
1 answer
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/oracle/instantclient_10_2…
drenocartero
- 115
- 4
0
votes
0 answers
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 this is working fine. We launch some apps to get…
DenCowboy
- 313
- 3
- 6
- 15
0
votes
0 answers
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 application's server using sqlplus.
Our security…
loscuropresagio
- 101
- 1
0
votes
1 answer
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. For example:
INSERT INTO TEST_ROUTING VALUES (24,…
0
votes
1 answer
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?
user458739
0
votes
1 answer
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 configured identically, so they both have an…
David
- 103
- 3