Skip to main content

Posts

Setting up Java Servlet & JSP Environment With APACHE TOMCAT SERVER

================================================================= Setting up Java Servlet and JSP Environment With APACHE TOMCAT SERVER ================================================================= •    Required tools     o    Jdk [eg. Jdk7.0]     o    Apache Tomcat Server [eg. Tomcat 7.0]        [Note: This tutorial will work on Apache tomcat  7.0]      [Note: Place your tomcat directory into C:\]      [Note: Install the jdk into C:\Program files\]   •    Sitting up Java Environment     o    Install JDK     o    After successful installation find the “BIN” directory within installation directory       [eg. C:\Program Files\Java\jdk1.6.0_26\bin]. Copy the full path and set the “PATH” environment variable as the copied ...
Post a Comment
Read more

Creating Oracle Database instead of DBCA

CREATE DATABASE mynewdb    USER SYS IDENTIFIED BY sys_password    USER SYSTEM IDENTIFIED BY system_password    LOGFILE GROUP 1 ('/u01/app/oracle/oradata/mynewdb/redo01.log') SIZE 100M,            GROUP 2 ('/u01/app/oracle/oradata/mynewdb/redo02.log') SIZE 100M,            GROUP 3 ('/u01/app/oracle/oradata/mynewdb/redo03.log') SIZE 100M    MAXLOGFILES 5    MAXLOGMEMBERS 5    MAXLOGHISTORY 1    MAXDATAFILES 100    CHARACTER SET US7ASCII    NATIONAL CHARACTER SET AL16UTF16    EXTENT MANAGEMENT LOCAL    DATAFILE '/u01/app/oracle/oradata/mynewdb/system01.dbf' SIZE 325M REUSE    SYSAUX DATAFILE '/u01/app/oracle/oradata/mynewdb/sysaux01.dbf' SIZE 325M REUSE    DEFAULT TABLESPACE users       DATAFILE '/u01/app/oracle/oradata/mynewdb/users01.dbf'       SIZE 500...
Post a Comment
Read more

Creation of TABLESPACE on ORACLE 10g..

Concept: An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data. Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running. A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consisting of two datafiles (for a total of six datafiles). SYNTAX:- CREATE SMALLFILE/BIGFILE TABLESPACE <TSPACE_NAME> DATAFILE '<PHYSICAL_LOCATION\FILE_NAME>' SIZE <FILE_SIZE>[M/K/G/T] AUTOEXTEND ON/OFF {Note: If On}                         NEXT <INCREASE_SIZE>[M/K/G/T ]  MAXSIZE   <FILE_SIZE>[M/K/G...
Post a Comment
Read more

How to install oracle 10g express edition in ubuntu

1. double click the oracle 10g installation file. it will check some dependencies. if some files are missing it will let you know. depending on that you have to install some more packages. it is almost certain that you will need libaio1 package. if it is required then just install it from the deb file you just downloaded. if there are no dependencies to be satisfied then install the package. 2. after the installation is finished you need to configure it. for that open the terminal and type Code: Select All /etc/init.d/oracle-xe configure it will ask for some port numbers. just press enter. it will keep the default port. it will also ask for the password. give it and then confirm it. then it will ask to whether to start it at startup or not. I would recommend no. 3. Now you have to add it to the bash. in the terminal type Code: Select All sudo gedit ~/.bashrc at the end of the file add Code: Select All ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2...
Post a Comment
Read more

How to intall .rpm in ubuntu & linux mint

Linux Mint & Ubuntu Support only deb package installation, If you have some software in rpm package you can install it in Linux Mint easily. To install open Terminal (Press Ctrl+Alt+T) and copy the following command in the Terminal: sudo apt-get install alien dpkg-dev debhelper build-essential Now convert package from RPM format to DEB format, use the following command. Change your packagename in command: sudo alien packagename .rpm To install the deb package enter following command: sudo dpkg -i packagename .deb
Post a Comment
Read more

Generate Sqare Matrix: HTML & jScript

<html> <head>     <script>         function mktab(a)         {             var i=1;             var j=1;             var cnt=1;                        document.write("<center><table border=0 bordercolor=black style='color:white;font-size:25'>");             for(i=1;i<=a;i++)             {                 document.write("<tr border=0>")                 for(j=1;j<=a;j++)                 { d...
Post a Comment
Read more

Sample: Oracle Create, Update, Insert, Triggers, Cursors, Procedures

/* IGNOU MCA SOLVED QUESTION PAPER MCSL-045 DEC-2012*/ create table Sales_Person  (S_id number, S_name varchar2(30), Experience number, S_Designation varchar2(30), S_product varchar2(30)); create table Sales_Record  (S_id number, S_target number, S_sold number, S_order number); create table Sales_Salary  (S_id number, S_basic number, S_grade number, S_salary number); /* A trigger for auto update SALARY */ CREATE OR REPLACE TRIGGER CL_SALARY  AFTER INSERT OR DELETE OR UPDATE ON Sales_Person BEGIN     UPDATE SALES_SALARY SET S_SALARY=S_BASIC+S_GRADE; END CL_SALARY; INSERT INTO Sales_Person VALUES(5, 'TUHIN SUMANTA', 30,'MANAGER','COSMETICS'); INSERT INTO Sales_Record VALUES(4,70,65,22); INSERT INTO SALES_SALARY VALUES(5,7850,500,0); UPDATE SALES_SALARY SET S_SALARY=S_BASIC+S_GRADE; SELECT * FROM SALES_PERSON; SELECT * FROM SALES_RECORD; SELECT * FROM SALES_SALARY; /* Creating View with JOIN */ CREATE OR REPLACE VIEW S_VIEW_...
Post a Comment
Read more