SQL*Plus - Chronicles of Technology

Getting ORA-12504 when connecting with sqlplus

I happened to install the Oracle Instant Client (instructions here) to quickly connect to a database using sqlplus. ProblemAfter installation, I simply tried to connect to my database as follows: ./sqlplus scott@dbhost:1521/dsoa.revelationtech.comAnd got the ORA-12504 error shown here: SQL*

SQL*Plus

Quickest way to set up the Oracle Instant Client for sqlplus access to the Oracle Database

Need quick and immediate access to SQL*Plus (i.e., sqlplus) from your Linux server? 1. Navigate to: https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html 2. Download these files: instantclient-basic-linux.x64-21.5.0.0.0dbru.zipinstantclient-sqlplus-linux.x64-21.5.0.0.0dbru.zip

SQL*Plus

Getting `ORA-00933: SQL command not properly ended` due to blank line

What's strange is that a SQL script someone wrote (which apparently was running fine for months) seemed to return an ORA-00933: SQL command not properly ended error when executed through the Linux command line, as shown below: oracle@dbhost:/home/oracle> /u01/sqlplus/instantclient_

JDBC

Using "utils.dbping" to test JDBC database connectivity

Recently I ran into a problem with an Oracle WebLogic Server data source. We were getting an IO Error: Connection reset in the console and logs when we try to