Linux Version : CentOS 7.5 Oracle Version : 18c (18.3.0.0) 1. Download the Zip file from Oracle Website and create…
Tag oracle
While creating a on-premise 18c (18.3) database with DBCA in the silent mode I got the below error dbca -createDatabase…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
On my test server I have got 2 ORACLE_HOMES 12cR1 (12.1.0.2) and 12cR2 (12.2.0.1) My listener.ora file on my server…
Create a new interactive report based on SQL Query. Make sure the column where image is store is populated in…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
If you are going to work on Oracle Database in cloud or in environments where X11 client or server is…
Oracle has released the latest version of Apex and keeping in line with their naming convention Apex has jumped from…
1. Add Encryption Wallet in sqlnet.ora Location $ORACLE_HOME/network/admin [oracle@localhost admin]$ vi sqlnet.ora ENCRYPTION_WALLET_LOCATION = (SOURCE =(METHOD = FILE)(METHOD_DATA = (DIRECTORY…
Oracle Apex is a modern framework to quickly develop and deploy web apps sitting on top of Oracle Database. Apex…
Install Latest NodeJS on CentOS 6 or 7 ————————————– 1. Add Repo and Install NodeJS For Stable Release:- $ yum…
Quick Integration with Twitter in Oracle Apex 18.1 https://blogs.oracle.com/apex/quick-and-easy-twitter-api-with-apex-181
So you have got your Oracle APEX instance up and running and you want to customize your first app. The…
This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the…
1. Generate RPM list on Old Server rpm -qa –queryformat=’%{NAME}\n’ | sort > serverold.txt 2. Generate RPM list on New…
If you have worked in any sort of Enterprise big or small, most likely you have worked on a Relational…
This error is mostly due to a mismatch in the Java system classes. It happened to us when we cloned…
— If doing on Source Server — ::12c–>sqlplus “/as sysdba” set head off pages 0 feed off echo off verify…
spool index_rebuild.sql select ‘alter index ‘||owner||’.’||index_name ||’ rebuild online nologging;’ from dba_indexes where owner=upper(‘SAMPLE’); spool off
Query to Select the First Day and Last Day of the Current Month select trim(to_date(last_day(sysdate),’DD/MM/YYYY’)) as lastday from dual; select…
The new PL/SQL procedure REDEF_TABLE in Oracle 12c lets you redefine a table online in a single step. It can…
One of the amazing features of Oracle Database 12c is that now you can do a logical restore from…
This is caused by a mismatch between the character set in which the table radm_fptm$ is created and in which…
Oracle 12c TDE on RAC Database with Physical Standby RAC. The Oracle Database Home has Multiple Instances, due to which…