Posts

Featured post

How To Enable/Disable Archive Log Mode In Oracle Database?

How To Enable/Disable Archive Log Mode In Oracle Database Step 1: Connect to the database the following command ============================== [oracle@localhost ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 22 14:40:27 2021 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1157627168 bytes Fixed Size 8895776 bytes Variable Size 436207616 bytes Database Buffers 704643072 bytes Redo Buffers 7880704 bytes Database mounted. Database opened. Step 2: To check the ARCHIVELOG mode status, enter the following SQL command: ================================== SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination /u01/app/oracle/archive Oldest online log sequence 22 Current log sequence 24 Step 3:To enable ARCHIVELOG mode status, enter the following SQL commands: =================

What is the alert log?

Each database has an alert log file, which contains a chronological(sequential order in which they occurred) log of database messages and errors. Oracle will automatically create a new alert log file whenever the old one is deleted. The alert log includes the following errors and log messages: All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60). Administrative operations such as DDL statements and the SQL*Plus commands STARTUP, SHUTDOWN, ARCHIVE LOG, and RECOVER. Several messages and errors relating to the functions of shared server and dispatcher processes. Errors during the automatic refresh of a materialized view Find the Location of alert log file in Oracle To view alert log, first you need to find it’s location using select command. SQL> SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace'; VALUE -------------------------------------------------------------------------------- /u01/app/oracle/diag/rdbms/orcl/orcl/trace To vi

Daily GK Updates 29-1-2020

Current Affairs Indian Railways commissions 1st waste to energy plant in Bhubaneswar Indian Railways has commissioned India’s 1st governmental waste-to-energy plant in Mancheswar Carriage Repair workshop at Bhubaneswar under the East Coast Railway zone. NOTES: Union Minister of Ministry of Railways: Piyush Goyal. Qatar names Sheikh Khalid bin Khalifa bin Abdelaziz Al Thani new PM Qatar’s emir has appointed Sheikh Khalid bin Khalifa bin Abdelaziz Al Thani as new Prime Minister. He will replace Sheikh Abdullah bin Nasser bin Khalifa Al Thani. NOTES: Qatar Capital: Doha; Currency: Qatari riyal. Govt of Odisha launches virtual police station The State Government of Odisha has launched a virtual police station where people can lodge complaints from their respective districts without visiting Police Station. The e-police station will function from the State Crime Records Bureau in Bhubaneswar. NOTES: Utkal Divas or Odisha Day falls every year on 01st April.

Indian Bank Recruitment 2020

Name of the Post: Indian Bank  Specialist Officer  2020 Total Vacancy: 138 Information: Indian Bank has announced a notification for the recruitment of  Specialist Officer vacancies. Those Candidates who are interested in the vacancy details & all eligibility criteria can read the notification and apply online. Application Fee For All Others:  Rs. 600/- + GST For SC/ST/PWD:   Rs. 100/- + GST Payment Mode:  through Online Important Dates Starting Date :  22-01-2020 Closing Date:   10-02-2020 Last Date for Printing of Application : 25-02-2020 Download of call letters for online examination:  20-02-2020 Date for Online Examination:  08-03-2020 Age Limit (as on 01-07-2019) Age Limit for Sl No. 01: 20-30 Years Age Limit for Sl No. 02 to 07: 25-35 Years Age Limit for Sl No. 08: 27-37 Years Age relaxation is applicable as per rules. Qualification Candidates Should Possess Any Degree/ CA/ ICWA/

What is the architecture of a DBMS?

Image
DBMS Architecture The DBMS design depends upon its architecture. The basic client/server architecture is used to deal with a large number of PCs, web servers, database servers and other components that are connected with networks. The client/server architecture consists of many and a workstation which are connected via the network. DBMS depends upon how users are connected to the database to get their request done. Types of DBMS Architecture Database architecture can be seen as a single tier or multi-tier. But logically, database architecture is of two types like:  2-tier architecture  and  3-tier architecture . 1-Tier Architecture In this architecture, the database is directly available to the user. It means the user can directly sit on the DBMS and uses it. Any changes done here will directly be done on the database itself. It doesn't provide a handy tool for end users. The 1-Tier architecture is used for development of the local application, where programmer

What is 1G, 2G, 3G, 4G, and 5G technology?

1G - First Generation Cell phones began with 1G technology in the 1980s. 1G is the first generation of wireless cellular technology. 1G supports voice only calls. 1G is analog technology, and the phones using it had poor battery life and voice quality, little security, and were prone to dropped calls. The maximum speed of 1G technology is 2.4 Kbps. 2G - Second Generation Cell phones received their first major upgrade when their technology went from 1G to 2G. This leap took place in Finland in 1991 on GSM networks and effectively took cell phones from analog to digital communications. The 2G telephone technology introduced call and text encryption, along with data services such as SMS, picture messages, and MMS. Although 2G replaced 1G and is superseded by later technology versions, it's still used around the world. The maximum speed of 2G with General Packet Radio Service (GPRS) is 50 Kbps. The speed is 1 Mbps with Enhanced Data Rates for GSM Evolution (EDGE). Before

What is the uses of int compareTo () method in Java?

Java.lang.String.compareTo() There are  three  variants of  compareTo()  method. This article depicts about all of them, as follows 1. int compareTo(Object obj)   :  This method compares this String to another Object. Syntax : int compareTo(Object obj) Parameters : obj : the Object to be compared. Return Value : The value 0 if the argument is a string lexicographically equal to this string; a value less than 0 if the argument is a string lexicographically greater than this string; and a value greater than 0 if the argument is a string lexicographically less than this string. public class Test {    public static void main(String args[]) {       String str1 = "Strings are immutable";       String str2 = new String("Strings are immutable");       String str3 = new String("Integers are not immutable");       int result = str1.compareTo( str2 );       System.out.println(result);       result = str2.compareTo( str3 );