SQL*Plus - Chronicles of Technology

SQL*Plus

A collection of 6 posts

Oracle Database: Zoning Conundrum

Oracle Database: Zoning Conundrum

The Oracle Database has long and complicated relations with time-aware data. It has gotten even more interesting in the internet era and global data processing. As usual, it's a story about how a single line of code at the design time could save many work hours in maintenance.

Using the SQL*Plus Instant Client

Now that you have the Oracle SQL*Plus Instant Client installed, here's the quickest way to start using it. (Installation instructions on this blog post.) # Set the environment variables to your local installation export SQLPLUS_HOME=/u01/sqlplus/instantclient_21_5 export TNS_ADMIN=${SQLPLUS_HOME} export LD_

Getting ORA-12504 when connecting with sqlplus

I happened to install the Oracle Instant Client (instructions here [https://chronicler.tech/quickest-way-to-set-up-the-oracle-instant-client-for-sqlplus-access-to-the-oracle-database/] ) to quickly connect to a database using sqlplus. Problem After installation, I simply tried to connect to my database as follows: ./sqlplus scott@dbhost:1521/dsoa.revelationtech.com And got the ORA-12504 error shown here: SQL*

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.zip * instantclient-sqlplus-linux.x64-21.5.0.0.0dbru.zip 3. Unzip the software: unzip

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_12_2/sqlplus

Using "utils.dbping" to test JDBC database connectivity

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 start up the data source. I could connect to the target database using a client tool such as Oracle SQL