Posts

Showing posts from September, 2018

Arduino UNO Sound Sensor

Image
In this short tutorial I will share with you the circuit diagrams, code and a sample video. Expected Results: Components  1*Arduino Uno board  1*USB data cable  1*High-Sensitive voice sensor module  Several jumper wires LED 220K Ohms or 1K Ohms Resistor (Otherwise your LED will blow) breadboard  Connect the sound sensor to the board as shown in the diagram below Connect the LED as shown below Black -  connect to the blue channel of the breadboard and to GND of the UNO RED - Connect to the Red Channel of the breadboard and to the 12 pin of the board. (If 12 seems to give you problems, try 11. Sometimes they are mismatched) Now its time to code.. Compile and deploy the code below /*********************************************** * name:Voice Sensor * function: you can see the value of sound intensity on Serial Monitor. **************************************************/ const int ledPin = 12; //pin 13 built-in led -- note this const int so

Arduino Temperature sensor and LCD Display

Image
In this post I am going to share with you the circuit diagram, code and how to fix faint display or completely invisible texts on the screen. Final Product Components -  Arduino  Uno board - 1 * Breadboard - 1 * USB data cable (To connect the board to your PC) - 1 * LM35 Temperature Sensor - 1 * I2C LCD1602 (QPASS LCD Display) - Several jumper wires LM35 Circuit For this project you need to add LiquidCrystal Library to your Arduino IDE. In this case I am using V1.07 Download and install by selecting the zip as shown below CODE: // This sketch tests the standard 7-bit addresses // Devices with higher bit address might not be seen properly. // #include void setup() {   Wire.begin();   Serial.begin(9600);   Serial.println("\nI2C Scanner"); } void loop() {   byte error, address;   int nDevices;   Serial.println("Scanning...");   nDevices = 0;   for(address = 1; addr

Importing a dump file in Oracle 12C

Image
Database Version: Oracle 12c To start with, Create a pluggable(container) before you import your data. (You have to be logged in to your database)  eg. sqlplus sys as sysdba Step 1: Use the command below to create pluggable CREATE PLUGGABLE DATABASE <your_container_name> ADMIN USER PDB_ADMIN IDENTIFIED BY oracle FILE_NAME_CONVERT = ('/oradata/orcl/pdbseed/','/oradata/orcl/ <your_container_name> '); Note: username  oracle  in this case is the admin user for your database that you configured during installation. Step 2: Run these commands in order: alter session set container=<your_container_name>; startup; execute this on a new terminal tab to create pdb folder manually: mkdir -p /oradata/orcl/<your_container_name> Step 3: Execute the following 7 commands inside your container in their order: 01. CREATE OR REPLACE DIRECTORY PLUGGABLE_DATA_PUMP_DIR as '/oradata/orcl/<your_container_name>'; 02. GRANT REA