SQLcl has many new little tricks that can help us on a daily basis, below is an example how we … More
Category: SQL*Plus
12c DISPLAY_NAME column in v$event_name view
in 12c Oracle has introduced and new field in the v$event_name view called DISPLAY_NAME. After review the contents on more … More
Install sqlplus instant client on macOS
Download Instant Client for macOS http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html#ic_osx_inst
How to fix “Error accessing PRODUCT_USER_PROFILE”?
When logging in SQL*PLus if one receives the following message. SQL> connect scott/tiger Error accessing PRODUCT_USER_PROFILE Warning: Product user profile … More
Using timing in SQL*Plus
Using timing feature on SQL*Plus one can monitor elapsed time. Example: — start timer with the name monitor_timing, name is … More
How to skip blank lines in between SQL statements in SQL*Plus?
If a SQL script file has blank lines in between SQL statements one may see errors when executing the script … More
Substitution Variable Examples
How to include instance name in spool filename?
Using the example below one can include instance name in the spool filename when using SQL*Plus SQL> set termout off … More
Clean up script with oratab
A simple script to delete trace files and arc logs from remote location, based on oratab instances. #!/bin/ksh export PATH=/usr/bin:$PATH … More
sqlplus: error while loading shared libraries: /u01/app/oracle/product/11.1.0/db_1/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied
Immediately after a successful RDBMS installation (perhaps even including a sample DB instance creation), sqlplus will not start: [oracle@test ~]$ … More
