Dear Readers, In this article we will see Key components in Cassandra. Gossip Cassandra uses The Gossip protocol for internal communication between nodes in a cluster. A peer-to-peer communication protocol to discover and share location and state information about the other nodes in a Cassandra cluster. Gossip information… Read More
Dear Readers, In this article we will see Key structures in Cassandra. Node Node is the basic infrastructure component of Cassandra. Where we can store data in a cluster. Cassandra is a Masterless architecture so all nodes in a cluster having same priority. Datacenter… Read More
Dear Readers, In this article we will see Cassandra Introduction. Apache Cassandra one of the Popular NoSQL database. it’s an Highly scalable, Masterless open source NoSQl database. it can suitable for managing the large amounts of structured, semi-structured, and unstructured data across homogeneous nodes. Cassandra… Read More
Hi All, Please click on below link for Cassandra demo. https://vimeo.com/216395411 Please send email to ktexperts@gmail.com for password. All the best.
Setting up glogin.sql : cd $ORACLE_HOME/sqlplus/admin cp glogin.sql glogin.sql.bkp vi glogin.sql SET termout off DEFINE myv = ‘Not connected’ COLUMN myc new_value myv select user || ‘@QA@’ || global_name myc from global_name; SET sqlprompt ‘&myv:SQL> ‘ Execution : $ sqlplus scott/PW SQL*Plus: Release 12.1.0.2.0 Production… Read More
Use this script to setup oramenu:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
#!/bin/bash # set -x # Pawan - www.orskl.com - Setting environmental variables from menu. Date: 27-Mar-2017 # # THIS SCRIPT WILL draw the menu of all available Oracle Instances from /etc/oratab. # It will simplify the way you set environment varaibles. # # Get the list of SID's from /etc/oratab file # Draw the menu # let user select the option # set those environment variables. # if [ -f /etc/oratab ] then echo "Please select your SID to set its environment variables" select sid in `cut -f "1" -d "#" /etc/oratab | awk -F: '{print $1}' | grep -v '^$'` do if [ `echo "X"${sid}` == "X" ] then echo "Invalid selection. Select numbers of respectice SID" break else . /usr/local/bin/oraenv <<< $sid >/dev/null break fi done else echo "Oracle is not installed on this server" fi |
~$ chmod +x oramenu ~$ sudo su – root ~# cp /home/oracle/oramenu /usr/local/bin/ ~# exit logout ~$ . oramenu Or Example : $ chmod +x oramenu oracle@server123:ORCL1:/home/oracle > $ . oramenu Please select your SID to… Read More
—– Create user for using EXPDP/IMPDP : create user admin identified by PW; grant connect,resource to admin; grant unlimited tablespace to admin; grant create any view to admin; create or replace directory DBA_EXPORT as ‘/u01/app/oracle/admin/cloud12c/dpdump’ grant write on directory DBA_EXPORT to admin; grant EXP_FULL_DATABASE to… Read More
Checking Default_Temp_Tablespace : col property_name for a35 col property_value for a20 col description for a45 set linesize 300 SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME=’DEFAULT_TEMP_TABLESPACE’; Temp tablespace usage : set linesize 300 SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,… Read More
RMAN Backup Size : set linesize 300 SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; PROMPT PROMPT +————————————————————————+ PROMPT | Report : RMAN Status | PROMPT | Instance : ¤t_instance | PROMPT +————————————————————————+ SET ECHO OFF… Read More
Dear Readers, In this article we will see Installing GG in AWS (Table replication in same DB). Step 1 : Download GG software Step 2 : check for xclock in AWS server. [ec2-user@ip-172-31-21-177 tmp]$ su – oracle Password: Last login: Sat Dec 24 12:03:29… Read More
