Oracle Client Silent Installation on OEL8

Download oracle client from Oracle web site and copy to Linux machine. Unzip the file to any location. “client” folder will be extracted. Edit Response File client_install.rsp file will be available in “client” folder -> “response” folder. Paths need to be according to your system. set the following parameters – UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/oraclient/oraInventory ORACLE_HOME=/u01/oraclient/app/oracle/product/21.0.0/client_1 ORACLE_BASE=/u01/oraclient/app/oracle oracle.install.client.installType=Administrator … Read more

Display Date and Time for DATE Datatype.

Session Level To display time with date for DATE datatype in SQLPLUS/SQL Developer/Toad etc. we can set “NLS_DATE_FORMAT” at session level using below command. alter session set nls_date_format = ‘DD-MON-YYYY HH24:MI:SS’; Permanent Settings to Display Date Format in SQL Developer In SQL developer we set at session level or make change in settings and display … Read more

Check Oracle Database

Here are some ways to check Oracle database version – PRODUCT_COMPONENT_VERSION – PRODUCT_COMPONENT_VERSION is data dictionary view provides PRODUCT information like Enterprise or Standard or Express editions, VERSION provides actual base version of Oracle database, VERSION_FULL provides with latest Release update & STATUS information of the database. V$VERSION – V$VERSION columns BANNER, BANNER_LEGACY columns display … Read more