Skip to main content


Showing posts from November, 2011

How to create batch file to start and stop Oracle Service on Windows

Everytime you want to start or stop a database service you will have to either do this using sqlplus prompt or through windows services. There is a much simpler way of stopping or starting a database. Follow the steps below. Create a file with an extension .bat for example start.bat Open this file and add the following line in it. NET START OracleServiceORCL Create another file as stop.bat , open this file and add the following line. NET STOP OracleServiceORCL Here I have 3 words, 1. NET helps start and stop services. 2. START/STOP -- Keyword means start or stop the services 3. OracleServiceORCL -- This is the service name of the database which has been installed on my windows. To start the database just double click on start.bat and to stop the database double click on stop.bat. To know the service name of the database on your machine, follow the steps below. 1. Go to Control Panel --> Administrative Tools --> Click on Services icon. This will open

How to start or stop database using SQLPLUS

Login to sqlplus session either on your command prompt or on sql*plus window using user "/as sysdba" or user SYSTEM. If you are using user "/as sysdba" then it does not require any password. Check the screenshot below, just enter "/as sysdba" and click ok you will be allowed to login or user SYSTEM user and its password to login. Once you have logged in issue an sql*plus command SHUTDOWN. SQL> shutdown Database closed. Database dismounted. ORACLE instance shut down. SQL> This shutsdown your database. To start the database you need to login again as

Starting and Stopping Database on Windows

First, Go to Control Panel --> Administrative Tools --> Click on Services icon. This will open a window show below. Here scroll down to names starting with alphabet O check for anything starting with Oracle. Observe the screenshot and look at Startup Type, for all the service names starting with Oracle Startup Type is set to Automatic except one. This means that everytime you restart your windows database restarts automatically. This is why you feel your windows has gone slow after installing the database. Now right click on each of the Oracle Service and Click

Standards and Full Forms

Listing some of the Standards and Full Forms of standard institutes and programing languages. This is not the complete list, you can contribute to this list by posting comments to this article. ANSI    -- American National Standards Institute IEEE    -- Institute of Electrical and Electronics Engineers -- ISO     -- International Organization for Standardization BIS     -- Bureau of Indian Standards IEC     -- International Electrotechnical Commission ITU     -- International Telecommunication Union SEI     -- Software Engineering Institute WSC     -- World Standards Cooperation NSB     -- National Standards Bodies W3C     -- World Wide Web Consortium IETF    -- Internet Engineering Task Force UPU     -- Universal Postal Union CEC     -- European Committee for Standardization CENELEC -- European Committee for Electrotechnical Standardization PASC    -- Pacific Area Standards Congress CMMI    -- Capability Maturity Model Institute COPANT  -- Pan America

Security Vulnerability for Webcache -- SSL Weak Cipher Suites Supported

SSL Vulnerability with Webcache with SSL Weak Cipher Following is one of the reports from Nessus. SSL Weak Cipher Suites Supported Synopsis: The remote service supports the use of weak SSL ciphers. Description: The remote host supports the use of SSL ciphers that offer either weak encryption or no encryption at all. Note: This is considerably easier to exploit if the attacker is on the same physical network. Risk factor: Medium CVSS Base Score:4.3 CVSS2#AV:N/AC:M/Au:N/C:P/I:N/A:N See also: Solution: Reconfigure the affected application if possible to avoid use of weak ciphers. This is usually reported from your security scanner. It does not matter if you have a strong encryption with 128 bit, it all depends on your SSL Cipher version supported. In security it is said that with a weak SSL cipher version server is still vulnerable to attacks. There are 3 types of SSL Version, SSL 2.0, 3.0 and 3.1 or TLS. TLS st

BrainBench Free Online Tests one of the sites that I have come across which gives you access to free online tests. Anything good that comes for free is rare :-D. Brainbench tests that are available for free. There are about 600 assessments and certifications that they offer, and a great way to try it. There are four types of free tests, to know and try them access the link below. CLICK HERE FOR BRAIN BENCH FREE TESTS

SQL 10g Reference

Free download from Oracle and end to end SQL reference guide. I can just say that it is a bible for SQL. CLICK HERE FOR ORACLE 10G SQL REFERENCE --DOWNLOAD PDF CLICK HERE FOR SQL, PL/SQL, and SQL*Plus Syntax and Examples -- ONLINE REFERENCE