Oracle

Golden Gate Error while loading shared libraries.

by

Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export LD_LIBRARY_PATH=$ORACLE_HOME/libldd ggsci ORACLE Set DB Env which is configured for GG Setup For 19c: Trigger below commands for the fix ln -s /u01/oracle/product/19/db/lib/libnnz19.so libnnz19.soln -s /u01/oracle/product/19/db/lib/libclntsh.so.19.1 libclntsh.so.19.1ln -s /u01/oracle/product/19/db/lib/libclntshcore.so.19.1 libclntshcore.so.19.1 ./ggsci For 11g: Trigger below … Read more

ORA-15032: not all alterations performed in Oracle ASM !!

by

The ORA-15032 error in Oracle is related to issues with the disk groups and ASM. This error indicates that some of the requested alterations to the disk group could not be completed. The reasons for this error can vary, but it often involves problems with disk group configurations, permissions, or the state of the ASM … Read more

18c New Features

by

Automatic In-Memory Oracle In-Memory was introduced in version 12c as a way to accelerate performance by storing columnar-compressed database segments into memory. In 18c, Oracle furthers development on In-Memory by introducing Automatic In-Memory (AIM). AIM works by building a heat map of the in-memory enabled objects and makes room for those objects that are more … Read more

Database in restricted mode.

by

Restrict Mode in which Oracle database allow making connection with special rights such as DBA, SYSDBA to perform the maintenance activity like rebuilding index, remove fragmentation etc. DBA can start database in restricted mode for planned maintenance activity. So, no other user such as application users will be able to connect with database until they … Read more

COALESCE Function

by

The Oracle COALESCE() function accepts a list of arguments and returns the first one that evaluates to a non-null value. In this syntax, the COALESCE() function returns the first non-null expression in the list. It requires at least two expressions. In case all expressions evaluate to null, the function returns null. The following example returns one because it is … Read more

Check history of Executed queries

by

The view v$sql contains almost of queries which are executed in your Oracle DB. Basicallyyou have privileges to query this view, you can check all from it. Below are some usefulqueries for you to do on this view. Get latest query select sql_text from v$sql where first_load_time=(select max(first_load_time) from v$sql); Sort executed queries by load … Read more

CASSANDRA-SPARK INSTALLATION AND CONNECTION

by

Install JDK, PYTHON, SCALA Set path for JDK and Python3 Install & Configure Cassandra Load Data In Cassandra Install & Configure Spark Set Path for Spark Setup Cassandra-spark connector and test INSTALLATION OF JAVA ON CENTOS 7 ISSUE RESOLUTION RELATED TO SUDOERS FILE: [root@cass-1 ~]# usermod -aG wheel cass [root@cass-1 ~]# su – cass [cass@cass-1 … Read more

Cluster failed to start due to ASM password file Issue (ORA-01017: invalid username/password)

by

Node server2 got evicted from the Cluster due to NIC hardware failure oracle@server2 /home/oracle06:19:25 : olsnodes -nserver1 1server2 2server3 3 DB Alert Log: /u01/oracle/product/diag/crs/server3/crs/trace/alert.log String containing event: 2022-07-09 04:06:51.055 [OCSSD(62652)]CRS-1612: Network communication with node server2 (2) has been missing for 50% of the timeout interval. If this persists, removal of this node from cluster will … Read more