tag:blogger.com,1999:blog-51924985652190682602024-03-19T04:11:03.534-07:00INDIALOTSGet latest tech updates, songs, lyrics, oracle issues and vtu notes.Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.comBlogger55125tag:blogger.com,1999:blog-5192498565219068260.post-86368520858250273812021-02-11T01:35:00.000-08:002021-02-11T01:35:34.823-08:00PostgreSQL Tutorial<p><a href="https://orahow.com/postgresql-download/" target="_blank">PostgreSQL Download</a> for installation.</p><p><b>How to Install PostgreSQL in Linux -</b> <a href="https://orahow.com/install-postgresql-on-linux/" target="_blank">PostgreSQL Installation</a></p><p><b>How to Create Database in PostgreSQL -</b> <a href="https://orahow.com/postgresql-create-database/" target="_blank">PostgreSQL Create Database</a> </p><p><b>How to Create User in PostgreSQL -</b> <a href="https://orahow.com/create-user-in-postgresql/">PostgreSQL Create User</a></p><p><b>How to Rename Table in PostgreSQL -</b> <a href="https://orahow.com/postgresql-rename-table/" target="_blank">PostgreSQL Rename Table</a></p><p><b>Listing Database in PostgreSQL -</b> <a href="https://orahow.com/listing-databases-in-postgresql/" target="_blank">PostgreSQL List Database</a> / <a href="https://orahow.com/listing-databases-in-postgresql/" target="_blank">PostgreSQL Show Database</a></p><p><br /></p>Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-30311610228810842172019-09-16T23:41:00.001-07:002019-09-16T23:41:56.987-07:00Recreate temp tablespace in OracleSQL> create temporary tablespace temp1 tempfile '/scratch/u01/app/oracle/oradata/tmp01/temp01.dbf' size 10G;<br /><br />
SQL> alter database default temporary tablespace temp1;<br /><br />
SQL> drop tablespace temp INCLUDING CONTENTS AND DATAFILES;<br /><br />
Tablespace dropped.<br /><br />
<br /><br />
<br /><br />
<a href="https://orahow.com/drop-and-recreate-temp-tablespace-in-oracle/" target="_blank">https://orahow.com/drop-and-recreate-temp-tablespace-in-oracle/</a>Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-71341616863472804332014-12-11T11:24:00.000-08:002014-12-11T11:24:24.430-08:00How to Check Airtel 4g LTE Dongle Data Usage<div dir="ltr" style="text-align: left;" trbidi="on">
Airtel 4G - Fourth Generation Technology provides upto 5 times faster speeds than 3G making it suitable for all type of high speed applications and services. It is also touted to be the fastest wireless internet service. The latest after 2G and 3G which gives you a faster and rich internet experience. With 4G hi-speeds, you can notice a visible difference while downloading files, doing video-chat, playing multiplayer games or while viewing HD videos online.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig1lJQzORqP9fk2GB3OL5B8dwIhihnlcka3Oq9wLyKQZ-dSbMThY0XEbZhcdY273JzU_c9ILs9K7U40hRW9OrefIRlLIfySqhudRdI7okXYgsi3GGFVY4VcQ8ZRJNPDvBVqrR24zOkviA4/s1600/Airtel.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig1lJQzORqP9fk2GB3OL5B8dwIhihnlcka3Oq9wLyKQZ-dSbMThY0XEbZhcdY273JzU_c9ILs9K7U40hRW9OrefIRlLIfySqhudRdI7okXYgsi3GGFVY4VcQ8ZRJNPDvBVqrR24zOkviA4/s1600/Airtel.PNG" /></a></div>
<b><span style="color: #0b5394;"><br /></span></b>
<br />
<h3 style="text-align: left;">
<b><span style="color: #0b5394;">How to Check Airtel 4g LTE Data Usage</span></b></h3>
To check airtel data usage click on the link below:<br />
<br />
<br />
<div style="text-align: center;">
<a href="http://www.airtel.in/applications/airteldongle.jsp" rel="nofollow" target="_blank"><b>Airtel Data Usage</b></a></div>
<br />
<br />
<b>Artel 4G can be used at home or your office for :</b><br />
<b><br /></b>
<br />
<ul style="text-align: left;">
<li> Wireless internet access.</li>
<li>Access rich content and multimedia applications eg: Movies, HD videos, e-learning, HD content and more.</li>
<li> multiple downloads of heavy files, high definition multimedia content at the same time will be possible.</li>
<li>Higher uplink and downlink speeds.</li>
<li>Seamless online streaming – ZERO buffering.</li>
<li> High definition online gaming Access business applications that require higher speeds and last mile connectivity.</li>
<li> Face-2-face video chat seamlessly.</li>
</ul>
<div>
airtel 4G LTE FAQs<br />
<br />
<a href="http://www.airtel.in/forme/wireless-internet/4g_lte/4g_lte_faqs/4g_faqs">http://www.airtel.in/forme/wireless-internet/4g_lte/4g_lte_faqs/4g_faqs</a></div>
</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-28220080137698101632014-09-15T12:23:00.000-07:002014-09-15T12:23:21.355-07:00Windows: How to Hide/Unhide Hard Disk Partition using Command Prompt<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: justify;">
People generally use drive locker to lock or unlock hard drive partition on their systems to protect data from unauthorized access. Use of software for this task is quite tricky when you forget password because in general life it is difficult to manage passwords from your laptop to ATM. </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
So to get rid of this problem we can suggest you to use this method using which you can hide or unhide hard disk partition your windows laptops without use of any software.<br />
<br /></div>
<div style="text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnqR8nVwiGo1M-bpGQqu0qOD8B_J1cdnToiEf6GMMzTJIYSUrivfTke9Zv4EhA880sveiRagrAqK2mHmU8r08cwxLaCttbn8NRiwVWR3ZkrTVmQKY6xHyB16dl6zCBNt53uHYojI2-LapE/s1600/windows-8-pro.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjnqR8nVwiGo1M-bpGQqu0qOD8B_J1cdnToiEf6GMMzTJIYSUrivfTke9Zv4EhA880sveiRagrAqK2mHmU8r08cwxLaCttbn8NRiwVWR3ZkrTVmQKY6xHyB16dl6zCBNt53uHYojI2-LapE/s1600/windows-8-pro.PNG" height="354" width="640" /></a><span style="color: black;"></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span></div>
<div style="text-align: justify;">
<div style="text-align: justify;">
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span>
<span style="color: black;"><span style="color: black;"><br /></span></span><br />
<div style="text-align: left;">
<span style="color: black;"><span style="color: black;">So let's start diskpart prompt to do our task. For this <b>open Command Prompt</b>, it will be much better when you open "CMD" as an administrator.</span></span></div>
</div>
<br />
<br />
Now, on cmd prompt type <b>"Diskpart"</b>. After few seconds you will be prompted to "Diskpart" prompt.<br />
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiI-ljzEPblpP-0FF6VsEQZjBqQLK6LomMrCerksSnf0_3i3GLSIr156HznHR3hRowWOu8D7JHRuni4bA05oDKfLsGvJkKx13scjy00kjTrHyqNb6r5u_zRr10Ytmb18DDpMKz5iybx3yB8/s1600/hide_hard_disk.PNG" /><br />
<span style="text-align: justify;"><br /></span>
<span style="text-align: justify;">Type "</span><b style="text-align: justify;">List Vol" </b><span style="text-align: justify;">so that you can see all the volumes or drives attached to your PCs as shown in the above figure. Using this command you can find the particular drive information like it's volume number, letters associated with it, labels (if any), file system type, size, status and info.</span><br />
<div style="text-align: justify;">
<br /></div>
Now select the dive letter which you want to remove as:<br />
<br />
<b>DISKPART> list vol</b><br />
<b>DISKPART> select vol 4</b><br />
<br />
Finally remove the letter associated with this drive.<br />
<br />
<b>DISKPART> remve letter E </b><br />
<br />
<div style="text-align: justify;">
When you press enter you will get a message : Diskpart successfully removed the drive letter or mount point. After completion of this step your selected drive will be no longer visible to you and no doubt others.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1jap3g2vMtZzjQK1x9YMpBuhyphenhyphenvJig1KnH9IpQVg_LAWtkF0PDdi1hhFEpLZSRei9VSkU7lEG84mxVfVm3mh0zCNUwZuxkpOfVkGClXJDeOeR318ml3YRZVIldn7hyphenhyphenkqzByT8eTQ9gNdv2/s1600/hide_partition.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsqpXvCuuCGwEroU0vOy93Zyg9LOxkaC0nxntx64A3o5vt7PtjrXjQvQ6KSzNiyNhlvSwgpGvNSeT6YyZgeALLGBKR4y8cy1IBjwJL-ucC5NIVlYd9zWXJCJ5kAs5H1n9tE5CuUU5Kkmek/s1600/hide_partition.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgsqpXvCuuCGwEroU0vOy93Zyg9LOxkaC0nxntx64A3o5vt7PtjrXjQvQ6KSzNiyNhlvSwgpGvNSeT6YyZgeALLGBKR4y8cy1IBjwJL-ucC5NIVlYd9zWXJCJ5kAs5H1n9tE5CuUU5Kkmek/s1600/hide_partition.PNG" /></a></div>
<br />
To gain access to this partition again you need to follow the same steps but in place of <b>remove letter</b> you need to enter <b>assign letter</b>. So lets look into this method:<br />
<br />
<div style="text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgz19PrCQU-z9719Xrt73xqBQ0VdP9v09hETZ46sZWd7DqOaYjPm4L8DxvzoNDWvhiuBGs6FhCoSlmSL7uAKH_KfV4oK-P1xy_bBFoGKrrfplT5UiiHsQKh7oMJ8YZAmW3e1e4UyYRhiH0q/s1600/unhide_hard_drive.PNG" /></div>
<div style="text-align: left;">
<br />
To bring back or <b>unhide partition</b> , select volume which you want to unhide and assign letter to the selected volume. In some cases when you release a particular letter windows automatically assign it to others, so first check whether the letter which you are going to assign is not in use, otherwise you can assign any other letter.</div>
<br />
<div style="text-align: left;">
<b>DISKPART> list vol</b></div>
<b>DISKPART> select vol 4</b><br />
<b>DISKPART> assign letter E</b><b> </b><br />
<br />
<div style="text-align: left;">
After the completion of this step you can see the particular volume. For more tech stuff stay connected on G+, Facebook, Twitter.</div>
</div>
</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-26406101706125562602014-08-31T10:32:00.000-07:002014-08-31T10:32:40.407-07:00Lyrics: Gulabi Aankhein Jo Teri Dekhi Md.Rafi <div dir="ltr" style="text-align: left;" trbidi="on">
Gulabi Aankhein Jo Teri Dekhi (Md.Rafi)<br />
Movie/Album: The Train (1970)<br />
Music By: R. D. Burman<br />
Lyrics By: Anand Bakshi<br />
Performed By: Mohammed Rafi<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNJ4VvZiaEiShjWFHPd6SJykNhnjJ0ZGISURpVKnt1QLsgE8IdrPbwrfPWgBxCuN1zJim9rTu69-D49MlZmjfqHXYt6nEd2B_BNK7ybgccAB2RdlfpmHq7k2IgmtKuz5tpjse7TlaVRP9E/s1600/train.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNJ4VvZiaEiShjWFHPd6SJykNhnjJ0ZGISURpVKnt1QLsgE8IdrPbwrfPWgBxCuN1zJim9rTu69-D49MlZmjfqHXYt6nEd2B_BNK7ybgccAB2RdlfpmHq7k2IgmtKuz5tpjse7TlaVRP9E/s1600/train.PNG" height="426" width="640" /></a></div>
<br />
Gulaabi Aankhen Jo Teri Dekhi<br />
Sharaabi Yeh Dil Ho Gaya<br />
Sambhaalo Mujhko O Mere Yaaron<br />
Sambhalna Mushkil Ho Gaya<br />
<br />
Dil Mein Mere Khwaab Tere<br />
Bas Tere Jaise Ho Deewaar Pe<br />
Tujhpe Fida Main Kyoon Hua<br />
Aata Hai Gussa Mujhe Pyaar Pe<br />
Main Lut Gaya Maanke Dil Ka Kaha<br />
Main Kahin Tha Na Raha<br />
<br />
Kya Kahoon Main Dilruba<br />
Pura Yeh Jaadu Teri Aankhon Ka<br />
Yeh Mera Kaatil Ho Gaya<br />
Gulaabi Aankhen Jo Teri Dekhi<br />
Sharaabi Yeh Dil Ho Gaya<br />
<br />
Maine Sada Chaaha Yehi<br />
Daaman Bacha Loon Haseenon Se Main<br />
Teri Kasam Khwaabon Mein Bhi<br />
Bachta Fida Naazneenon Se Main<br />
Tauba Magar Mil Gayi Tujhse Nazar<br />
Mil Gaya Dard-E-Jigar<br />
<br />
Sun Zara O Bekhabar<br />
Zara Sa Haske Jo Dekha Tune<br />
Main Tera Bismil Ho Gaya<br />
Gulaabi Aankhen Jo Teri Dekhi<br />
Sharaabi Yeh Dil Ho Gaya<br />
Sambhaalo Mujhko O Mere Yaaron<br />
Sambhalna Mushkil Ho Gaya<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="380" src="//www.youtube.com/embed/2rvoiBkDePY" width="580"></iframe>
---------------------------------------------------------------------------------<br />
<br />
गुलाबी आँखें, जो तेरी देखी, शराबी ये दिल हो गया<br />
सम्भालो मुझको, ओ मेरे यारों, सम्भलना मुश्किल हो गया<br />
<br />
दिल में मेरे, ख़्वाब तेरे, तस्वीरें जैसे हों दीवार पे<br />
तुझपे फ़िदा, मैं क्यूँ हुआ, आता है गुस्सा मुझे प्यार पे<br />
मैं लुट गया, मान के दिल का कहा<br />
मैं कहीं का ना रहा, क्या कहूँ मैं दिलरुबा<br />
बुरा ये जादू तेरी आँखों का, ये मेरा क़ातिल हो गया<br />
गुलाबी आँखें जो तेरी देखी...<br />
<br />
मैंने सदा, चाहा यही, दामन बचा लूं हसीनों से मैं<br />
तेरी क़सम, ख़्वाबों में भी, बचता फिरा नाज़नीनों से मैं<br />
तौबा मगर, मिल गई तुझसे नज़र<br />
मिल गया दर्द-ए-जिगर, सुन ज़रा ओ बेख़बर<br />
ज़रा सा हँस के, जो देखा तूने, मैं तेरा बिस्मिल हो गया<br />
गुलाबी आँखें जो तेरी देखी......<br />
<div>
<br /></div>
</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-16257783888278382622014-08-30T02:41:00.002-07:002014-08-30T02:41:53.803-07:00COMPUTER NETWORKS - VTU CSE/ISE CN LAB MANUAL<div dir="ltr" style="text-align: left;" trbidi="on">
NETWORKS LABORATORY: CN LAB PROGRAMS FOR <a href="http://elearning.vtu.ac.in/10CSL77.html" rel="nofollow" target="_blank">VTU</a> CSE/ISE STUDENTS<br />
Subject Code : 06CSL77<br />
IA Marks : 25<br />
No. of Practical Hrs./ Week : 03<br />
Exam Hours : 03<br />
Total No. of Practical Hrs. : 42<br />
Exam Marks : 50<br />
<br />
<div style="text-align: left;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6iFaim96Xkd4n0KBDZ_zNH4q1srBoJDmqP366dk-b82fbk-IHUDWQvhDdzXjL-ccgfKrXgWbnq5ZjqS8faoGrNqr24YMHKXFeiLXu_qPDqPrg_iSijQYiqYNflFQvbTPcQfwVca4x_Ggp/s1600/NETWRK.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6iFaim96Xkd4n0KBDZ_zNH4q1srBoJDmqP366dk-b82fbk-IHUDWQvhDdzXjL-ccgfKrXgWbnq5ZjqS8faoGrNqr24YMHKXFeiLXu_qPDqPrg_iSijQYiqYNflFQvbTPcQfwVca4x_Ggp/s1600/NETWRK.png" height="243" width="640" /></a></div>
<br /></div>
Note: Student is required to solve one problem from PART-A and one<br />
problem from PART-B. The questions are allotted based on lots. Both<br />
questions carry equal marks.<br />
<br />
<br />
<div style="text-align: center;">
<span style="font-size: x-large;"><b><a href="https://drive.google.com/file/d/0B4p64sHnMDm4TmZ4Z3dZdFprX2s/edit?usp=sharing" rel="nofollow" target="_blank">DOWNLOAD</a></b></span></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<a href="http://sunstarsunil.webs.com/Downloads/network%20lab.doc" rel="nofollow" target="_blank"><span style="font-size: x-large;"><b>SSIT CN LAB</b></span></a></div>
<br />
PART - A<br />
<br />
SIMULATION EXERCISES<br />
<br />
The following experiments shall be conducted using either NS / OPNET or<br />
any other suitable simulator.<br />
1. Simulate a three nodes point – to – point network with duplex links<br />
between them. Set the queue size and vary the bandwidth and find the<br />
number of packets dropped.<br />
<br />
2. Simulate a four node point-to-point network with the links connected as<br />
follows:<br />
n0 – n2, n1 – n2 and n2 – n3. Apply TCP agent between n0-n3 and UDP<br />
between n1-n3. Apply relevant applications over TCP and UDP agents<br />
changing the parameter and determine the number of packets sent by<br />
TCP / UDP.<br />
<br />
3. Simulate the different types of Internet traffic such as FTP and TELNET<br />
over a network and analyze the throughput.<br />
<br />
4. Simulate the transmission of ping messages over a network topology<br />
consisting of 6 nodes and find the number of packets dropped due to<br />
congestion.<br />
<br />
5. Simulate an Ethernet LAN using n nodes (6-10), change error rate and<br />
data rate and compare throughput.<br />
<br />
<br />
6. Simulate an Ethernet LAN using n nodes and set multiple traffic nodes<br />
and determine collision across different nodes.<br />
<br />
7. Simulate an Ethernet LAN using n nodes and set multiple traffic nodes<br />
and plot congestion window for different source / destination.<br />
<br />
8. Simulate simple ESS and with transmitting nodes in wire-less LAN by<br />
simulation and determine the performance with respect to transmission<br />
of packets.<br />
<br />
<b>PART - B</b><br />
<br />
<b>Implement the following in C/C++:</b><br />
1. Write a program for error detecting code using CRC-CCITT (16- bits).<br />
<br />
2. Write a program for frame sorting technique used in buffers.<br />
<br />
3. Write a program for distance vector algorithm to find suitable path for<br />
transmission.<br />
<br />
4. Using TCP/IP sockets, write a client – server program to make the client<br />
send the file name and to make the server send back the contents of the<br />
requested file if present.<br />
<br />
5. Implement the above program using as message queues or FIFOs as IPC<br />
channels.<br />
<br />
6. Write a program for simple RSA algorithm to encrypt and decrypt the<br />
data.<br />
<br />
7. Write a program for Hamming code generation for error detection and<br />
correction.<br />
<br />
8. Write a program for congestion control using leaky bucket algorithm.</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-55779746554275590782014-08-29T23:42:00.002-07:002014-08-29T23:42:44.647-07:00VTU: COMPUTER GRAPHICS LAB PROGRAMS FOR 6th SEM<div dir="ltr" style="text-align: left;" trbidi="on">
<b>COMPUTER GRAPHICS AND VISUALIZATION LABORATORY - <a href="http://vtu.ac.in/" rel="nofollow" target="_blank">VTU</a></b><br />
<br />Subject Code : 06CSL67 IA Marks : 25<br />No. of Practical Hrs./ Week : 03 Exam Hours : 03<br />Total No. of Practical Hrs. : 42 Exam Marks : 50<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIKzcl6wfXMJa8LGo2qJesNLBwQBAGCQFZeXXFGpGwUAUMrUeQUUxfHMOv_1oG85IrTtDDArxbEUy0Hj75UxUP0iHNV03kmUawaM6nvlB1muXLE40SIxmm_ljCfHM1qUq2Og7XFnO2U6fy/s1600/cg-lab.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIKzcl6wfXMJa8LGo2qJesNLBwQBAGCQFZeXXFGpGwUAUMrUeQUUxfHMOv_1oG85IrTtDDArxbEUy0Hj75UxUP0iHNV03kmUawaM6nvlB1muXLE40SIxmm_ljCfHM1qUq2Og7XFnO2U6fy/s1600/cg-lab.png" height="248" width="640" /></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<span style="color: #0b5394;"><span style="font-size: x-large;"><b><a href="https://drive.google.com/file/d/0B4p64sHnMDm4MjV5QTdMR2VsaU0/edit?usp=sharing" rel="nofollow" target="_blank">DOWNLOAD</a></b></span></span></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />PART - A<br />
<br />IMPLEMENT THE FOLLOWING PROGRAMS IN C / C++<br />
<br />1. Program to recursively subdivide a tetrahedron to from 3D Sierpinski<br />gasket. The number of recursive steps is to be specified by the user.<br />
<br />2. Program to implement Liang-Barsky line clipping algorithm.<br />
<br />3. Program to draw a color cube and spin it using OpenGL transformation<br />matrices.<br />
<br />4. Program to create a house like figure and rotate it about a given fixed<br />point using OpenGL functions.<br />
<br />5. Program to implement the Cohen-Sutherland line-clipping algorithm.<br />Make provision to specify the input line, window for clipping and view<br />port for displaying the clipped image.<br />
<br />6. Program to create a cylinder and a parallelepiped by extruding a circle<br />and quadrilateral respectively. Allow the user to specify the circle and<br />the quadrilateral.<br />
<br />7 Program, using OpenGL functions, to draw a simple shaded scene<br />consisting of a tea pot on a table. Define suitably the position and<br />properties of the light source along with the properties of the properties<br />of the surfaces of the solid object used in the scene.<br />
<br />8. Program to draw a color cube and allow the user to move the camera<br />suitably to experiment with perspective viewing. Use OpenGL functions.<br />
<br />9. Program to fill any given polygon using scan-line area filling algorithm.<br />(Use appropriate data structures.)<br />
<br />10. Program to display a set of values { fij } as a rectangular mesh.<br />
<br />PART - B<br />Develop a suitable Graphics package to implement the skills learnt in the<br />theory and the exercises indicated in Part A. Use the OpenGL.</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-26889900742656252122014-08-29T22:59:00.000-07:002014-08-29T23:00:08.609-07:00VTU CSE/ISE WEB PROGRAMMING LAB MANUAL<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<span style="font-weight: normal;">WEB PROGRAMMING LABORATORY 7th SEM</span></h3>
<br />
Subject Code : 06CSL78<br />
IA Marks : 25<br />
No. of Practical Hrs./ Week : 03<br />
Exam Hours : 03<br />
Total No. of Practical Hrs. : 42<br />
Exam Marks : 50<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPKMQHLiHv3mEPpMx4OyOdj1VW79Y5ojbzRlXm_t0UrO3XQHY9QNIepSN7tNMWH48Bn1xjgm4Py42aca2VNfwP3K18IsphNFhMPHYUgf2wNug52Du4t7dMmBN7qMaYYoSx746jRvwKimNy/s1600/web+lab.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPKMQHLiHv3mEPpMx4OyOdj1VW79Y5ojbzRlXm_t0UrO3XQHY9QNIepSN7tNMWH48Bn1xjgm4Py42aca2VNfwP3K18IsphNFhMPHYUgf2wNug52Du4t7dMmBN7qMaYYoSx746jRvwKimNy/s1600/web+lab.png" height="258" width="640" /></a></div>
<br />
<br />
<br />
<div style="text-align: center;">
<a href="https://drive.google.com/file/d/0B4p64sHnMDm4OUVOQUpqWHBfbjA/edit?usp=sharing" rel="nofollow" target="_blank"><span style="background-color: white;"><span style="font-size: x-large;"><span style="color: #0b5394;"><u><b>DOWNLOAD</b></u></span></span></span></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
<br />
1. Develop and demonstrate a XHTML document that illustrates the use<br />
external style sheet, ordered list, table, borders, padding, color, and the<br />
tag.<br />
<br />
2. Develop and demonstrate a XHTML file that includes Javascript script<br />
for the following problems:<br />
a) Input: A number n obtained using prompt<br />
Output: The first n Fibonacci numbers<br />
b) Input: A number n obtained using prompt<br />
Output: A table of numbers from 1 to n and their squares using alert<br />
<br />
3. Develop and demonstrate a XHTML file that includes Javascript script<br />
that uses functions for the following problems:<br />
a) Parameter: A string<br />
Output: The position in the string of the left-most vowel<br />
b) Parameter: A number<br />
Output: The number with its digits in the reverse order<br />
<br />
4. a) Develop and demonstrate, using Javascript script, a XHTML<br />
document that collects the USN ( the valid format is: A digit from 1 to 4<br />
followed by two upper-case characters followed by two digits followed by<br />
two upper-case characters followed by three digits; no embedded spaces<br />
allowed) of the user. Event handler must be included for the form element<br />
that collects this information to validate the input. Messages in the alert<br />
windows must be produced when errors are detected.<br />
b) Modify the above program to get the current semester also<br />
(restricted to be a number from 1 to 8)<br />
<br />
5. a) Develop and demonstrate, using Javascript script, a XHTML<br />
document that contains three short paragraphs of text, stacked on top of<br />
each other, with only enough of each showing so that the mouse cursor<br />
can be placed over some part of them. When the cursor is placed over the<br />
exposed part of any paragraph, it should rise to the top to become<br />
completely visible.<br />
b) Modify the above document so that when a paragraph is moved from<br />
the top stacking position, it returns to its original position rather than to<br />
the bottom.<br />
<br />
6. a) Design an XML document to store information about a student in an<br />
engineering college affiliated to VTU. The information must include<br />
USN, Name, Name of the College, Brach, Year of Joining, and e-mail id.<br />
Make up sample data for 3 students. Create a CSS style sheet and use it to<br />
display the document.<br />
b) Create an XSLT style sheet for one student element of the above<br />
document and use it to create a display of that element.<br />
<br />
7. a) Write a Perl program to display various Server Information like<br />
Server Name, Server Software, Server protocol, CGI Revision etc.<br />
b) Write a Perl program to accept UNIX command from a HTML form<br />
and to display the output of the command executed.<br />
<br />
8. a) Write a Perl program to accept the User Name and display a<br />
greeting message randomly chosen from a list of 4 greeting messages.<br />
b) Write a Perl program to keep track of the number of visitors visiting<br />
the web page and to display this count of visitors, with proper headings.<br />
<br />
9. Write a Perl program to display a digital clock which displays the<br />
current time of the server.<br />
<br />
10. Write a Perl program to insert name and age information entered by<br />
the user into a table created using MySQL and to display the current<br />
contents of this table.<br />
<br />
11. Write a PHP program to store current date-time in a COOKIE and<br />
display the ‘Last visited on’ date-time on the web page upon reopening of<br />
the same page.<br />
<br />
12. Write a PHP program to store page views count in SESSION, to<br />
increment the count on each refresh, and to show the count on web page.<br />
<br />
13. Create a XHTML form with Name, Address Line 1, Address Line 2,<br />
and E-mail text fields. On submitting, store the values in MySQL table.<br />
Retrieve and display the data based on Name.<br />
<br />
14. Using PHP and MySQL, develop a program to accept book<br />
information viz. Accession number, title, authors, edition and publisher<br />
from a web page and store the information in a database and to search for<br />
a book with the title specified by the user and to display the search results<br />
with proper headings.</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-61120375309830656032014-08-24T13:00:00.000-07:002014-08-29T14:44:57.172-07:00VTU CSE/ISE DBMS Lab Programs <div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
Database - DBMS Lab Manual - All Programs </h3>
<h3 style="text-align: left;">
<br /><a href="http://vtu.ac.in/" rel="nofollow" target="_blank">VTU</a> 5 th Sem </h3>
<h3 style="text-align: left;">
<a href="http://www.vtuforum.com/Thread-DBMS-lab-program-5th-sem-cse-ise" rel="nofollow" target="_blank">Vtu Forum</a> </h3>
<br />
SQL> create user username identified by password; <br />
SQL>create user santosh identified by manager<br />
<br />
SQL> grant connect, resource to username;<br />
SQL> grant connect, resource to santosh;<br />
login with same account<br />
<br />
<br />
<br />
<br />
<u><b>Program 1:</b></u><br />
<br />
<b> Consider the Insurance database given below. The primary keys are underlined and the data types are specified:<br /><br />PERSON (driver-id:string,name:string,address:string) <br />CAR (Regno:string,model:string,year:int)<br />ACCIDENT (report-number:int,date:date,location:string)<br />OWNS (driver-id:string,regno:string)<br />PARTICIPATED (driver-id:string,regno:string,report-number:int,damage-amount:int)</b><br />
<b><br />i) create the above tables by properly specifying the primary keys and the foreign keys<br />ii) Enter atleast five tuples for each relation<br />iii) Demonstrate how you<br />a. Update the damage amount for the car with a specific regno in accident with report number 12 to 25000 <br />b. Add a new accident to the database<br />iv) Find the total number of people who owned cars that were involved in accidents in 2006.<br />v) Find the number of accidents in which cars belonging to a specific model were involved.<br />vi) Generation of suitable reports <br />vii) Create suitable front end for querying and display the results</b><br />
<br />
<br />
<b>SOLUTION:</b><br />
<br />
<b>i) Create the above tables by properly specifying the primary keys and the foreign keys</b><br />
<br />
create table person(driver_id char(4) primary key,<br />
name varchar(30),<br />
address varchar(30)<br />
);<br />
<br />
create table car(reg_no char(15) primary key,<br />
model char(20),<br />
year number(4)<br />
);<br />
<br />
create table accident(report_no number primary key,<br />
acc_date date,<br />
location varchar(30)<br />
);<br />
<br />
create table owns(driver_id references person,<br />
reg_no references car<br />
);<br />
<br />
create table participated( driver_id references person,<br />
reg_no references car,<br />
report_no references accident,<br />
damage_amt number(10,2)<br />
);<br />
<br />
<br />
<b>ii) Enter atleast five tuples for each relation</b><br />
<br />
insert into person values('1234','amith','no a-1-12 koppal');<br />
insert into person values('2345','anil','23 vijaya apts');<br />
insert into person values('3412','john','no 3423 vicky apts');<br />
insert into person values('4567','arun','kamal nivas koppal');<br />
insert into person values('4522','sunil','no 54 ravi nagar');<br />
<br />
<br />
insert into car values('ka37k32','hyundai',2004);<br />
insert into car values('ka05d34','maruti 800',1998);<br />
insert into car values('ka23j90','zen',2002);<br />
insert into car values('ka35f45','fiat',2001);<br />
insert into car values('ka36m78','benz',2000);<br />
<br />
insert into accident values(12,'12-feb-1990','vit cross');<br />
insert into accident values(34,'31-jan-1999','jayanagar');<br />
insert into accident values(56,'12-dec-1998','btm layout');<br />
insert into accident values(67,'07-jul-2003','jp nagar');<br />
insert into accident values(87,'01-may-2001','allalsandra');<br />
<br />
insert into owns values('1234','ka37k32');<br />
insert into owns values('2345','ka05d34');<br />
insert into owns values('3412','ka23j90');<br />
insert into owns values('4567','ka35f45');<br />
insert into owns values('4522','ka36m78');<br />
<br />
insert into participated values('1234','ka37k32',12,12000);<br />
insert into participated values('2345','ka05d34',34,13000);<br />
insert into participated values('3412','ka23j90',56,14000);<br />
insert into participated values('4567','ka35f45',67,12450);<br />
insert into participated values('4522','ka36m78',87,10000);<br />
<br />
<br />
<b><br />iii) Demonstrate how you<br />a. Update the damage amount for the car with a specific regno in accident with report number 12 to 25000 <br />b. Add a new accident to the database</b><br />
<br />
<b>Solution:</b><br />
<br />
a. Update participated set damage_amt = 25000 where reg_no = ‘&reg_no’ and report_no = 12;<br />
b. Insert into accident values(93,’02-may-2002’,’allalsandra’);<br />
<br />
<b>iv) Find the total number of people who owned cars that were involved in accidents in 2006.</b><br />
<br />
SQL> Select count(*) from accident where to_char(acc_date,’yy’) = 02;<br />
v) Find the number of accidents in which cars belonging to a specific model were involved.<br />
<br />
SQL> Select count(a.report_no) from accident a,participated p,car c where c.reg_no = <br />
p.reg_no and <br />
a.report_no = p.report_no and c.model = '&model' group by a.report_no<br />
<br />
---------------------------------------------------------------------------<br />
<b><br /><br /><u>Program 2:</u></b><br />
<br />
<b> Consider the following relations for an order processing database application in a company.<br /><br />CUSTOMER (Cust #: int, Cname: string, City: string)<br />ORDER (Order #: int, Odate: date, Cust #: int, Ord-Amt: int)<br />ORDER-ITEM (Order #: int, Item #: int, qty: int)<br />ITEM (Item #: int, Unit Price: int)<br />SHIPMENT (Order #: int, Warehouse #: int, Ship-Date: date)<br />WAREHOUSE (Warehouse #: int, City: string)<br /><br />i) Create the above tables by properly specifying the primary keys and the foreign keys.<br />ii) Enter at least five tuples for each relation.<br />iii) Produce a listing: CUSTNAME, NO_OF_ORDERS, AVG_ORDER_AMT, where the middle column is the total number of orders by the customer and the last column is the average order amount for that customer.<br />iv) List the Order# for the orders that were shipped from all the warehouses that the company has in a specific city.<br />v) Demonstrate how you delete Item# 10 from the ITEM table and make that field null in the ORDER-ITEM table.<br />vi) Generation of suitable reports.<br />vii) Create a suitable front end for querying and displaying the results.</b><br />
<br />
<br />
<b>Solution:</b><br />
<b><br />i) Create the above tables by properly specifying the primary keys and the foreign keys.</b><br />
<br />
create table customer(cust_no number primary key,<br />
cname varchar(30),<br />
city varchar(30));<br />
<br />
create table orders( order_no number primary key,<br />
odate date,<br />
cust_no references customer,<br />
ord_amt number);<br />
<br />
create table item( item_no number primary key,<br />
unit_price number);<br />
<br />
create table orders_item( order_no references orders,<br />
item_no references item on delete cascade,<br />
qty number);<br />
<br />
create table warehouse(warehouse_no number primary key,<br />
city varchar(30));<br />
<br />
create table shipment(order_no references orders,<br />
warehouse_no references warehouse,<br />
ship_date date);<br />
ii) Enter at least five tuples for each relation.<br />
<br />
insert into customer values(10,'ajay','bangalore');<br />
insert into customer values(21,'arun','hyderabad');<br />
insert into customer values(32,'ikram','hubli');<br />
insert into customer values(45,'suraj','kanpur');<br />
insert into customer values(78,'niraja','panji');<br />
<br />
insert into orders values(12345,'25-mar-2005',10,0);<br />
insert into orders values(12346,'26-mar-2005',21,0);<br />
insert into orders values(12347,'30-mar-2005',32,0);<br />
insert into orders values(12348,'01-apr-2005',45,0);<br />
insert into orders values(12349,'01-apr-2005',78,0);<br />
<br />
insert into item values(10,100);<br />
insert into item values(20,60);<br />
insert into item values(30,140);<br />
insert into item values(40,35);<br />
insert into item values(50,150);<br />
<br />
insert into orders_item values(12345,10,4);<br />
insert into orders_item values(12346,20,2);<br />
insert into orders_item values(12347,30,5);<br />
insert into orders_item values(12348,40,10);<br />
insert into orders_item values(12349,50,18);<br />
<br />
insert into warehouse values(1501,'bangalore');<br />
insert into warehouse values(1502,'hyderabad');<br />
insert into warehouse values(1503,'hubli');<br />
insert into warehouse values(1504,'delhi');<br />
insert into warehouse values(1505,'belgaum');<br />
<br />
insert into shipment values(12345,1501,'5-mar-2005');<br />
insert into shipment values(12346,1502,'28-mar-2005');<br />
insert into shipment values(12347,1503,'01-apr-2005');<br />
insert into shipment values(12348,1504,'04-apr-2005');<br />
insert into shipment values(12349,1505,'05-apr-2005');<br />
<br />
update orders set ord_amt = (select sum(oi.qty * i.unit_price) from orders_item oi,item I where oi.order_no = orders.order_no and I.item_no = oi.item_no);<br />
<br />
commit;<br />
<br />
<b>iii) Produce a listing: CUSTNAME, NO_OF_ORDERS, AVG_ORDER_AMT, where the middle column is the total number of orders by the customer and the last column is the average order amount for that customer.</b><br />
<br />
SQL> select cname “CustName”,count(*) “No of Orders”,avg(ord_amt) “Average order <br />
amt” from orders o,customer c where o.cust_no = c.cust_no group by cname;<br />
<br />
CustName No of Orders Average amt<br />
------------------------------ ------------ ---------------------------<br />
ajay 1 400<br />
arun 1 120<br />
ikram 1 700<br />
niraja 1 2700<br />
suraj 1 350<br />
<b><br /><br />iv) List the Order# for the orders that were shipped from all the warehouses that the company has in a specific city.</b><br />
<br />
SQL> Select order_no from warehouse w,shipment s where w.warehouse_no = <br />
s.warehouse_no and w.city = ‘&city’;<br />
<b><br />v) Demonstrate how you delete item# 10 from the item table and make that field null in the order table.</b><br />
<br />
SQL> Delete from item where item_no = 10;<br />
<br />
<b>-----------------------------------------------------------------------------------------------------</b><br />
<b><br />Program 3:</b><br />
<br />
<b> Consider the following database of student enrollement in courses and books adopted for each course .<br /><br />STUDENT (regno :string , name : string , major : string , bdate : int)<br />COURSE (course# : int , cname : string , dept : string)<br />ENROLL ( regno : string , course#: int , sem : int , marks : int )<br />BOOK_ADOPTION ( course#: int , sem : int , book_isbn :int)<br />TEXT( book_isbn : int , book-title : string , publisher : string , author : string).<br /><br />i) Create the above tables by properly specifying the primary keys and the foreign key .<br />ii) Enter atleast five tuples for each relation . <br />iii) Demonstrate how you add a new text book to the database and make this book be adopted by some department.<br />iv) Produce a list of text books( include course # ,book_isbn,book-title) in the alphabetical order for courses offered by the cs department that use more than 2 books.<br />v) List any department that has all its adopted books published by specific publisher.<br />vi) Generation of suitable reports.<br />Create suitable front end for querying and display the results</b><br />
<br />
<br />
<b>Solution:<br />i) Create the above tables by properly specifying the primary keys and the foreign key .</b><br />
<br />
create table student(reg_no char(10) primary key,<br />
name varchar(30),<br />
major char(1),<br />
bdate date<br />
);<br />
<br />
<br />
create table course(course_no number primary key,<br />
cname varchar(30),<br />
dept varchar(30)<br />
);<br />
<br />
create table enroll(reg_no references student,<br />
course_no references course,<br />
sem number(1),<br />
marks number(3),<br />
primary key(reg_no,course_no,sem)<br />
);<br />
<br />
create table text(book_isbn number(4) primary key,<br />
book_title varchar(30),<br />
publisher varchar(30),<br />
author varchar(30)<br />
);<br />
<br />
create table book_adoption(course_no references course,<br />
sem number(1),<br />
book_isbn references text<br />
);<br />
<br />
<br />
<b>ii) Enter atleast five tuples for each relation . </b><br />
<br />
insert into student values('1mv02is033','prasanna','y','24-oct-84');<br />
insert into student values('1mv02is050','sunil','y','22-may-84');<br />
insert into student values('1mv02cs001','aditya','y','11-jan-83');<br />
insert into student values('1mv02mca22','raju','n','30-mar-83');<br />
insert into student values('1mv02mba33','vishal','y','02-apr-82');<br />
<br />
insert into course values(1,'be','ise');<br />
insert into course values(2,'be','cse');<br />
insert into course values(3,'be','ece');<br />
insert into course values(4,'mca','ca');<br />
insert into course values(5,'mba','hr');<br />
<br />
insert into enroll values('1mv02is033',1,6,97);<br />
insert into enroll values('1mv02is050',2,5,66);<br />
insert into enroll values('1mv02cs001',3,4,45);<br />
insert into enroll values('1mv02mca22',4,1,77);<br />
insert into enroll values('1mv02mba33',5,2,88);<br />
<br />
insert into text values(1234,'dbms','bpb','navathe');<br />
insert into text values(2345,'cn','lpe','tanenbaum');<br />
insert into text values(3456,'ds','galgotia','padmareddy');<br />
insert into text values(4567,'cpp','pearson','herbert');<br />
insert into text values(5678,'unix','bpb','das');<br />
insert into text values(1333,'cn','pearson','tanenbaum');<br />
insert into text values(1444,'cn','pearson','tanenbaum');<br />
<br />
insert into book_adoption values(1,6,1234);<br />
insert into book_adoption values(2,5,2345);<br />
insert into book_adoption values(3,4,3456);<br />
insert into book_adoption values(5,1,5678);<br />
insert into book_adoption values(4,2,1234);<br />
insert into book_adoption values(2,6,4567);<br />
insert into book_adoption values(2,1,5678);<br />
insert into book_adoption values(2,6,1333);<br />
insert into book_adoption values(2,6,1444);<br />
<br />
<br />
commit;<br />
<br />
<b>iii) Demonstrate how you add a new text book to the database and make this book be adopted by some department.</b><br />
<br />
SQL> insert into text values(1222,’maths’,’DSC’,’KSC’);<br />
SQL> insert into book_adoption values(4,6,1222);<br />
<br />
<b>iv) Produce a list of text books( include course # ,book_isbn,book-title) in the alphabetical order for courses offered by the cs department that use more than 2 books.</b><br />
<br />
SQL> select b.course_no,b.book_isbn,t.book_title from book_adoption b,text t where b.book_isbn=t.book_isbn and b.course_no in(select course_no from book_adoption where course_no in(select course_no from course where dept like 'cse') group by course_no having count(course_no)>=2);<br />
<br />
<b><br />v) List any department that has all its adopted books published by specific publisher.</b><br />
<br />
SQL> select c.dept,t.publisher from course c,book_adoption b,text t where<br />
c.course_no = b.course_no and<br />
b.book_isbn = t.book_isbn and<br />
t.publisher = '&publisher' <br />
group by c.dept,t.publisher;<br />
<br />
Enter value for publisher: bpb<br />
old 4: t.publisher = '&publisher'<br />
new 4: t.publisher = 'bpb'<br />
<br />
DEPT PUBLISHER<br />
------------------------------ ------------------------------<br />
ca bpb<br />
cse bpb<br />
hr bpb<br />
ise bpb<br />
<br />
--------------------------------------------------------------------------------------<br />
<br />
<br />
<b><u>Program 4: </u> </b><br />
<br />
<b>Consider the following relations for the details maintained by a book dealer.<br /><br />AUTHOR (Author-id: int, Name: string, City: string, Country: string)<br />PUBLISHER (Publisher-id: int, Name: string, City: string, Country: string)<br />CATALOG (Book-id: int, title: string, author-id: int, Publisher-id: int, Category-id: int, Year: int, Price: int)<br />CATEGORY (Category-id: int, Description: string)<br />ORDER-DETAILS (Order-no : int, Book-id: int, Quantity: int)<br />i. Create the above tables by properly specifying the primary keys and the foreign keys.<br />ii. Enter at least five tuples for each relation.<br />iii. Give the details of the authors who have 2 or more books in the catalog and the price of the books is greater than the average price of the books in the catalog and the year of publication is after 2000.<br />iv. Find the author of the book which has maximum sales.<br />v. Demonstrate how you increase the price of books published by a specific publisher by 10%.<br />vi. Generation of suitable reports.<br />vii. Create a suitable front end for querying and displaying the results.</b><br />
<br />
<br />
Solution:…<br />
i) Create the above tables by properly specifying the primary keys and the foreign keys.<br />
<br />
create table author(author_id number(4) primary key,<br />
aname varchar(30),<br />
acity varchar(30),<br />
acountry varchar(30)<br />
);<br />
<br />
create table publisher(pub_id number(4) primary key,<br />
pname varchar(30),<br />
pcity varchar(30),<br />
pcountry varchar(30)<br />
);<br />
<br />
create table category(cat_id number(4) primary key,<br />
description varchar(30)<br />
);<br />
<br />
create table catalog(book_id number(4) primary key,<br />
title varchar(30),<br />
author_id references author,<br />
pub_id references publisher,<br />
cat_id references category,<br />
year number(4),<br />
price number(6,2)<br />
);<br />
<br />
create table order_details(order_no number(4) primary key,<br />
book_id references catalog,<br />
qty number(5)<br />
);<br />
<br />
<b>ii) Enter at least five tuples for each relation.</b><br />
<br />
insert into author values(1001,'balaguruswamy','hyderabad','india');<br />
insert into author values(1002,'tenanbaum','california','usa');<br />
insert into author values(1003,'padma reddy','bangalore','india');<br />
insert into author values(1004,'godse','pune','india');<br />
insert into author values(1005,'oppenham','los angeles','usa');<br />
<br />
insert into publisher values(3001,'suhas','bangalore','india');<br />
insert into publisher values(3002,'bpb','delhi','india');<br />
insert into publisher values(3003,'prentice','delhi','india');<br />
insert into publisher values(3004,'pearson','california','usa');<br />
insert into publisher values(3005,'subhas','bangalore','india');<br />
<br />
insert into category values(4001,'programming');<br />
insert into category values(4002,'os');<br />
insert into category values(4003,'database');<br />
insert into category values(4004,'networks');<br />
insert into category values(4005,'logic design');<br />
<br />
insert into catalog values(1,'let us c',1001,3001,4001,1999,375);<br />
insert into catalog values(2,'database',1002,3002,4003,2002,450);<br />
insert into catalog values(3,'network',1003,3003,4002,1998,500);<br />
insert into catalog values(4,'logic design',1004,3004,4004,2004,750);<br />
insert into catalog values(5,'c++',1005,3005,4005,2005,450);<br />
insert into catalog values(6,'c',1001,3002,4002,2003,880);<br />
insert into catalog values(7,'cn',1001,3004,4002,2005,750);<br />
<br />
insert into order_details values(1,1,34);<br />
insert into order_details values(2,1,45);<br />
insert into order_details values(3,2,45);<br />
insert into order_details values(4,2,75);<br />
insert into order_details values(5,3,69);<br />
<br />
<b>commit;</b><br />
<br />
<b>iii) Give the details of the authors who have 2 or more books in the catalog and the price of the books is greater than the average price of the books in the catalog and the year of publication is after 2000.</b><br />
<br />
SQL> select * from author where author_id in<br />
(select author_id from catalog c where c.year>2000 and c.price>(select avg(price) from catalog) group by author_id having count(*)>=2);<br />
<br />
<b>Find the author of the book which has maximum sales.</b><br />
<br />
SQL> Select a.author_id,a.aname from author a,catalog c,max_sales m where<br />
a.author_id = c.author_id and<br />
c.book_id = m.book_id and<br />
m.book_id in (select book_id from max_sales where quantity = <br />
(select max(quantity) from max_sales));<br />
<b><br />iv) Demonstrate how you increase the price of books published by a specific publisher by 10%.</b><br />
<br />
SQL> update catalog set price = price*1.1 where pub_pd = &publisher_id;<br />
<br />
----------------------------------------------------------------------------------<br />
<br />
<b><u>Program 5</u>: </b><br />
<br />
<b>Consider the following database for a banking enterprise<br /><br />BRANCH (branch_name: string, branch_city: string, assets: real)<br />ACCOUNT (accno: int, branch_name: string, balance: real)<br />CUSTOMER (customer_name: string, customer_street: string, city:string)<br />DEPOSITOR (customer_name: string, accno: int)<br />LOAN (loan_number: int, branch_name: string, amount: real)<br />BORROWER (customer_name: string, loan_number: int) <br /><br />i) Create the above tables by properly specifying the primary keys and the foreign keys. <br />ii) Enter atleast five tuples for each relation.<br />iii) Find all the customers who atleast two accounts at the MAIN branch.<br />iv) Find all the customers who have an account at all branches located in a specific city.<br />v) Demonstrate how you delete all account tuples at every branch located in a specific city.<br />vi) Generation of suitable reports.<br />vii) Create suitable front end for querying and displaying the results.</b><br />
<br />
<br />
<b>Solution:</b><br />
<b><br />i) Create the above tables by properly specifying the primary keys and the foreign keys.</b><br />
<br />
create table branch(br_name varchar(30) primary key,<br />
br_city varchar(30),<br />
assets number(10,2)<br />
);<br />
<br />
create table account(acc_no number(4) primary key,<br />
br_name references branch,<br />
balance number(10,2)<br />
);<br />
<br />
create table customers(c_name varchar(30) primary key,<br />
c_street varchar(30),<br />
c_city varchar(30)<br />
);<br />
<br />
create table depositor(c_name references customers,<br />
acc_no references account,<br />
qty number<br />
);<br />
<br />
create table loan(loan_no number(4) primary key,<br />
br_name references branch,<br />
amt number(10,2)<br />
);<br />
<br />
create table borrower(c_name references customers,<br />
loan_no references loan<br />
);<br />
<br />
<b>ii) Enter atleast five tuples for each relation.</b><br />
<br />
insert into branch values('rajaji nagar','bangalore',1000000);<br />
insert into branch values('jayanagar','bangalore',50000);<br />
insert into branch values('mvit','bangalore',10000);<br />
insert into branch values('jawahar nagar','bangalore',100000);<br />
insert into branch values('rajbhavan','bangalore',23566);<br />
<br />
insert into account values(1000,'rajaji nagar',2500);<br />
insert into account values(2000,'rajaji nagar',8996);<br />
insert into account values(3000,'rajaji nagar',7415);<br />
insert into account values(4000,'jayanagar',2121);<br />
insert into account values(5000,'mvit',8596);<br />
insert into account values(6000,'jawahar nagar',9999);<br />
insert into account values(7000,'rajbhavan',235);<br />
<br />
insert into customers values('prasanna','patel road','raichur');<br />
insert into customers values('harish','indiranagar','bangalore');<br />
insert into customers values('sunil','ring road','bangalore');<br />
insert into customers values('srinivas','woc road','bangalore');<br />
insert into customers values('rudre','maruti galli','belgaum');<br />
<br />
insert into depositor values('prasanna',1000,2000);<br />
insert into depositor values('prasanna',2000,3000);<br />
insert into depositor values('harish',3000,5000);<br />
insert into depositor values('sunil',4000,1520);<br />
insert into depositor values('srinivas',5000,1120);<br />
insert into depositor values('rudre',6000,1250);<br />
insert into depositor values('prasanna',7000,1250);<br />
<br />
insert into loan values(100,'rajaji nagar',5000);<br />
insert into loan values(200,'rajaji nagar',4000);<br />
insert into loan values(300,'jayanagar',6323);<br />
insert into loan values(400,'mvit',4512);<br />
insert into loan values(500,'jawahar nagar',1235);<br />
insert into loan values(600,'rajbhavan',9632);<br />
insert into loan values(700,'rajbhavan',3456);<br />
<br />
insert into borrower values('prasanna',100);<br />
insert into borrower values('harish',200);<br />
insert into borrower values('sunil',300);<br />
insert into borrower values('srinivas',400);<br />
insert into borrower values('rudre',500);<br />
<b><br />iii) Find all the customers who atleast two accounts at the MAIN branch.</b><br />
<br />
SQL>Select c_name from depositor d,account a where<br />
a.acc_no = d.acc_no and<br />
a.br_name = 'rajaji nagar’<br />
group by c_name <br />
having count(*) > 2;<br />
<br />
<b>iv) Find all the customers who have an account at all branches located in a specific city.</b><br />
<br />
SQL> select distinct c_name from depositor where acc_no in<br />
(select acc_no from account where br_name in<br />
(select br_name from branch where br_city='bangalore'));<br />
<b><br />Demonstrate how you delete all account tuples at every branch located in a specific city.</b><br />
<br />
SQL> Delete from account where br_name in <br />
(select br_name from branch where br_city = 'bangalore);</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-23293461810551001892014-08-17T04:19:00.001-07:002014-08-17T04:24:36.829-07:00How to Increase Internet Speed using Google public DNS server<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="font-size: large;"><span style="font-size: small;">Very slow internet connection speed is common now a days, but you can make it faster using some DNS settings of your internet connection. Generally for connectivity we use Dynamic Host Protocol Configuration (DHCP) which assign dynamic IP address to every devices connected to the network by establishing connection with available DNS during start up of your PCs.</span></span><br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-size: small;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9PR0kLmCFa3DL-Zf9FIW12Kg8qr06HGFxaTxpTVu5OEhPQkXH7svilNwKUSsjkjB9tuswxbr9OsOnDNdSvKNKmsZE6fT1z0lM8xL5wlRwClBiDgLLaD9HpqIwgfx7oV-YqaKNHhub-XJJ/s1600/speed_up_internet.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9PR0kLmCFa3DL-Zf9FIW12Kg8qr06HGFxaTxpTVu5OEhPQkXH7svilNwKUSsjkjB9tuswxbr9OsOnDNdSvKNKmsZE6fT1z0lM8xL5wlRwClBiDgLLaD9HpqIwgfx7oV-YqaKNHhub-XJJ/s1600/speed_up_internet.png" height="175" width="640" /></a></span></span></div>
<span style="font-size: large;"><span style="font-size: small;"><br /></span></span>
<br />
<h3 style="text-align: center;">
<span style="font-size: large;"><span style="font-size: small;"> Steps For Speed Up Your Internet Speed </span></span></h3>
<span style="font-size: large;"><span style="font-size: small;"><b> Step 1:</b> </span></span><br />
<br />
<span style="font-size: large;"><span style="font-size: small;">Open control panel and click on Network and Internet which is located in the left side of the panel.<br /><br /><b>Step 2:</b></span></span><br />
<br />
<span style="font-size: large;"><span style="font-size: small;">A new Network and Sharing Center will appear. Now click on "Change adapter settings" located on the top left side of the panel.</span></span><br />
<br />
<span style="font-size: large;"><span style="font-size: small;"><b> Step 3:</b></span></span><br />
<br />
<span style="font-size: large;"><span style="font-size: small;"> </span></span><span style="font-size: large;"><span style="font-size: small;">Select the type of network adapter for which you want to configure.<br />For example: you can select Ethernet if you are connected to cable, wi-fi if you are connected to this n/w.</span></span><br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkKfHo-BrjyKCMJKoTM56x8-JY2gjqs5o3KVOLf-5xU2MLPw1k7Bfh920_8gWT2TvMVJc62Ih9FQn1Zotti9naXhacPvpBX65QUed5Uis_Ii0dqef_ACT1PKlUFWv7lMNEIrRC70hkvzEj/s1600/increase_internet_speed2.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkKfHo-BrjyKCMJKoTM56x8-JY2gjqs5o3KVOLf-5xU2MLPw1k7Bfh920_8gWT2TvMVJc62Ih9FQn1Zotti9naXhacPvpBX65QUed5Uis_Ii0dqef_ACT1PKlUFWv7lMNEIrRC70hkvzEj/s1600/increase_internet_speed2.PNG" /></a><span style="font-size: large;"><span style="font-size: small;"><br /> </span></span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: large;"><span style="font-size: small;"><b> Step 4:</b></span></span><br />
<span style="font-size: large;"><span style="font-size: small;"><b> </b><br />Right click on the selected n/w and goto properties.<br />Drop down the configuration menu and select "Internet Protocol Version4 (TCP/IPv4)".</span></span><br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXJ_ZI5aR7lpX1fEKHbQIZZrX0nkT873FMCI9Iz_Cm3IsNBC8JcVa2QkTigDRqc9OqKC06MOmTXHqxT4eSCHMmWXaswonsJcTcqmGMpdfgxzagXuBgfknV8DUVBmYn-J5hS8CMlouJF2WH/s1600/speed_up_internet.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXJ_ZI5aR7lpX1fEKHbQIZZrX0nkT873FMCI9Iz_Cm3IsNBC8JcVa2QkTigDRqc9OqKC06MOmTXHqxT4eSCHMmWXaswonsJcTcqmGMpdfgxzagXuBgfknV8DUVBmYn-J5hS8CMlouJF2WH/s1600/speed_up_internet.PNG" /></a><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="text-align: left;">
<span style="font-size: large;"><span style="font-size: small;"><b>Step 5:</b></span></span></div>
<div style="text-align: left;">
</div>
<span style="font-size: large;"><span style="font-size: small;">Select "Use the following DNS server address"<br />Preferred DN Server 8.8.8.8<br />Alternet DNS Server 8.8.4.4 </span></span><br />
<br />
<span style="font-size: large;"><span style="font-size: small;"></span></span><br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWIYY-59QMZV1aFMrMwmL6jqBKHEOjqPP6phyphenhyphen6n95IBEyD0_TMkDSjftbtF6IjPs7L2V6dv32_eCt1rm-nDD4n3au5Kvz5AUY6hdRQHZJZlz8d9fInVmAycSEHN_9b8vXYLb0XKXdfsk8e/s1600/speed_up_internet1.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWIYY-59QMZV1aFMrMwmL6jqBKHEOjqPP6phyphenhyphen6n95IBEyD0_TMkDSjftbtF6IjPs7L2V6dv32_eCt1rm-nDD4n3au5Kvz5AUY6hdRQHZJZlz8d9fInVmAycSEHN_9b8vXYLb0XKXdfsk8e/s1600/speed_up_internet1.PNG" /></a><span style="font-size: large;"><span style="font-size: small;"><br /></span></span><br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: large;"><b><span style="font-size: small;">Step 6: </span></b></span><br />
<br />
<span style="font-size: large;"><b> </b></span><span style="font-size: large;"><span style="font-size: small;">Finally click on OK to save changes and test the connection.</span></span><br />
<br />
<span style="font-size: large;"><b> </b></span><span style="font-size: large;"><b><a href="https://developers.google.com/speed/public-dns/docs/using#testing" rel="nofollow" target="_blank">Test Connection</a></b></span><br />
<br />
<br />
<br /></div>
<!-- Blogger automated replacement: "https://images-blogger-opensocial.googleusercontent.com/gadgets/proxy?url=http%3A%2F%2F4.bp.blogspot.com%2F-nbw9CDdfym0%2FU-hjMw5NLhI%2FAAAAAAAAAUM%2FP01Yr7Z0M_U%2Fs1600%2Fspeed_up_internet.PNG&container=blogger&gadget=a&rewriteMime=image%2F*" with "https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXJ_ZI5aR7lpX1fEKHbQIZZrX0nkT873FMCI9Iz_Cm3IsNBC8JcVa2QkTigDRqc9OqKC06MOmTXHqxT4eSCHMmWXaswonsJcTcqmGMpdfgxzagXuBgfknV8DUVBmYn-J5hS8CMlouJF2WH/s1600/speed_up_internet.PNG" -->Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-73727720203024512052014-08-15T04:21:00.002-07:002014-08-15T04:21:54.380-07:00How to Renew a Godaddy Domain Name before ExpireYou must renew your domain name before it expire because after grace period Godaddy place your domain name in parked areas and it will cost much more than usual rates.<br />
<br />
<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRcuDQfDPayEZSZGAKHZWMU_n97qaeX7Q3YvH_VQSf5rewgxJhPdiFZEOm12WR9L5utXEG1-khKGYEkt3Nl8oWSOfLNlPzCotecEtieDRepaoxMK-Hp3ATQ_4bmZrbmrEvOQc8eW_kOwyn/s1600/godaddy.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRcuDQfDPayEZSZGAKHZWMU_n97qaeX7Q3YvH_VQSf5rewgxJhPdiFZEOm12WR9L5utXEG1-khKGYEkt3Nl8oWSOfLNlPzCotecEtieDRepaoxMK-Hp3ATQ_4bmZrbmrEvOQc8eW_kOwyn/s1600/godaddy.PNG" height="233" width="640" /></a><br />
<br />
<b><br /></b>
<b>Here you will learn how to renew domain step-by-step.</b><br />
<b><br /></b>
<b><br /></b>
<br />
<ul>
<li>Log in to your Godaddy Account Manager.</li>
<li>Go to the Renewals tab, where you will see a list of domain to renew.</li>
</ul>
<br />
<ul>
<li>Click on expand that containing an items you want to renew.</li>
</ul>
<div>
</div>
<br />
<div>
<span style="color: #0000ee;"><u><br /></u></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOpFzg1pzz3V4OG6EJgkmUKNH9Ubl7ufegGJrPVElLW9nwMP82Z4-MO4EHIKrwhj5Mnz9KXq3uWBsyLtGrAU-Z7Ji-uVgsFvKM_GHBQqbvL6rAJt2g1qhA6CEAXJ1dEYW2jsG4ZmJqPqHC/s1600/godaddy-renue.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOpFzg1pzz3V4OG6EJgkmUKNH9Ubl7ufegGJrPVElLW9nwMP82Z4-MO4EHIKrwhj5Mnz9KXq3uWBsyLtGrAU-Z7Ji-uVgsFvKM_GHBQqbvL6rAJt2g1qhA6CEAXJ1dEYW2jsG4ZmJqPqHC/s1600/godaddy-renue.PNG" height="224" width="640" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<br />
<ul>
<li>Select the domains or products you want to renew along with the type of registration and renewal length.</li>
<li>Click to Continue.</li>
</ul>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-SedzbnKXwPBFIS-D29OYSqIyxLKYHFqAe2d7aut2gdNTGegvLgoohuY1sHnmcgy1cr4UfA8pIGJDvQrEsxGrC9u0BZJssNkB3cXlrPY-nHe4D1UhfVE7WW35LDo60rSFe_VNShf6-O5o/s1600/godaddy-checkout.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-SedzbnKXwPBFIS-D29OYSqIyxLKYHFqAe2d7aut2gdNTGegvLgoohuY1sHnmcgy1cr4UfA8pIGJDvQrEsxGrC9u0BZJssNkB3cXlrPY-nHe4D1UhfVE7WW35LDo60rSFe_VNShf6-O5o/s1600/godaddy-checkout.PNG" height="320" width="240" /></a></div>
<ul>
<li>You can also Customize your order to add other products or services to your order and finally click on continue.</li>
<li>Select Payment details and finally click on place your order.</li>
</ul>
<div>
<ul>
<li>Check your billing details that includes your address and type of transaction.</li>
<li>Regarding payment details: </li>
<li>Select Payment mode. For example you can select online banking, debit card, cash card etc and proceed further.</li>
</ul>
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY0wqq5MrH9y2EC43PGAyQMA37Cjx3tr8SuMx0KH6XN2qLPayPMsxrFK6TdOjN2m4taQFqopAB3Xgqxy_EdwbPwZlDc2-b2StbE20KaWijn-hkyGnOIaIiyldXIZYv724mNd-rQgUFkzrR/s1600/godaddy-transaction.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjY0wqq5MrH9y2EC43PGAyQMA37Cjx3tr8SuMx0KH6XN2qLPayPMsxrFK6TdOjN2m4taQFqopAB3Xgqxy_EdwbPwZlDc2-b2StbE20KaWijn-hkyGnOIaIiyldXIZYv724mNd-rQgUFkzrR/s1600/godaddy-transaction.PNG" height="166" width="320" /></a></div>
<ul>
<li>This will open a new window where you have to enter your card details and finally click on submit.</li>
<li>Regarding transaction verification you will receive OTP on your registered mobile number which you have to enter.</li>
<li>At the end you will get a final receipt of your transaction. </li>
</ul>
<div>
<br /></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-54526241442031080562014-08-14T23:00:00.002-07:002014-08-14T23:02:51.979-07:00Lyrics: Tum Hi Ho by Arijit Singh - Aashiqui 2 <div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQYe0dFjDib1Dfu7t5rRWY8jqlIyN5pu7dpS6Sf_viBR4F71hIbnbkxl7RWVovdCMhNh7qkzn2SN9Hx4TZCRmny06kUqWMr6-4CESK_pHWR4CaAywZsoCaUbUMURASlIl6MLdJfan7ZRyU/s1600/tum-hi-ho.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Tum Hi Ho Lyrics" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQYe0dFjDib1Dfu7t5rRWY8jqlIyN5pu7dpS6Sf_viBR4F71hIbnbkxl7RWVovdCMhNh7qkzn2SN9Hx4TZCRmny06kUqWMr6-4CESK_pHWR4CaAywZsoCaUbUMURASlIl6MLdJfan7ZRyU/s1600/tum-hi-ho.PNG" height="324" title="Tum Hi Ho Lyrics" width="640" /></a></div>
<br />
Movie / Album: Aashiqui-2<br />
Singer(s): Arijit Singh<br />
Lyricist(s): Mithoon<br />
Music composer: Ankit Tiwari, Mithoon, Jeet Ganguly, <br />
Music © T-Series<br />
<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="340" src="//www.youtube.com/embed/Umqb9KENgmk?feature=player_detailpage" width="580"></iframe>
<br />
<br />
<br />
<br />
<b>Tum Hi Ho Lyrics</b><br />
<br />
Hum tere bin ab reh nahi sakte<br />
Tere bina kya wajood mera (x2)<br />
<br />
Tujhse juda gar ho jaayenge<br />
Toh khud se hi ho jaayenge judaa<br />
<br />
Kyunki tum hi ho<br />
Ab tum hi ho<br />
Zindagi ab tum hi ho<br />
Chain bhi, mera dard bhi<br />
Meri aashiqui ab tum hi ho<br />
<br />
Tera mera rishta hai kaisa<br />
Ik pal door gawara nahi<br />
Tere liye har roz hai jeete<br />
Tujh ko diya mera waqt sabhi<br />
Koi lamha mera na ho tere bina<br />
Har saans pe naam tera<br />
<br />
Kyunki tum hi ho<br />
Ab tum hi ho<br />
Zindagi ab tum hi ho<br />
Chain bhi, mera dard bhi<br />
Meri aashiqui ab tum hi ho<br />
<br />
Tumhi ho... Tumhi ho...<br />
Tere liye hi jiya main<br />
Khud ko jo yun de diya hai<br />
Teri wafa ne mujhko sambhala<br />
Saare ghamon ko dil se nikala<br />
Tere saath mera hai naseeb juda<br />
Tujhe paake adhoora naa raha hmm..<br />
<br />
Kyunki tum hi ho<br />
Ab tum hi ho<br />
Zindagi ab tum hi ho..<br />
Chain bhi, mera dard bhi<br />
Meri aashiqui ab tum hi ho (x2)<br />
<br />
<br />
------------------------------------------------<br />
<br />
हम तेरे बिन अब रह नहीं सकते<br />
तेरे बिना क्या वजूद मेरा (x2)<br />
<br />
तुझसे जुदा गर हो जाएँगे<br />
तो खुद से ही हो जाएंगे जुदा<br />
<br />
क्योंकि तुम ही हो<br />
अब तुम ही हो<br />
ज़िन्दगी अब तुम ही हो<br />
चैन भी, मेरा दर्द भी<br />
मेरी आशिकी अब तुम ही हो<br />
<br />
तेरा मेरा रिश्ता है कैसा<br />
इक पल दूर गंवारा नहीं<br />
तेरे लिए हर रोज़ हैं जीते<br />
तुझको दिया मेरा वक़्त सभी<br />
कोई लम्हा मेरा न हो तेरे बिना<br />
हर सांस पे नाम तेरा<br />
क्योंकि तुम ही हो...<br />
<br />
तेरे लिए ही जिया मैं<br />
खुद को जो यूँ दे दिया है<br />
तेरी वफ़ा ने मुझको संभाला<br />
सारे ग़मों को दिल से निकाला<br />
तेरे साथ मेरा है नसीब जुड़ा<br />
तुझे पा के अधूरा ना रहा<br />
क्योंकि तुम ही हो...<br />
<br />
क्योंकि तुम ही हो<br />
अब तुम ही हो<br />
ज़िन्दगी अब तुम ही हो<br />
चैन भी, मेरा दर्द भी<br />
मेरी आशिकी अब तुम ही हो -(x2)<br />
<br />
<br />
<br /></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-61773185265139106572014-08-14T08:01:00.001-07:002014-08-14T08:01:22.067-07:00Oracle: Recover Database Using RMAN Until a Log Sequence Number<div dir="ltr" style="text-align: left;" trbidi="on">
<b>In this scenario we will recover database using RMAN until a log sequence number SCN.</b><br />
<br />
<b>First create a table called customers and count the number of rows.</b><br />
<b><br /></b>
<b>SQL> select count(*) from customers;</b><br />
<br />
COUNT(*)<br />
----------<br />
4<br />
<br />
<b>SQL> alter system switch logfile;</b><br />
<br />
System altered.<br />
<br />
Check whether database is in archivelog mod or not.<br />
<br />
<b>SQL> archive log list</b><br />
Database log mode Archive Mode<br />
Automatic archival Enabled<br />
Archive destination D:\app\SantoshTiwari\oradata\arc<br />
Oldest online log sequence 1<br />
Next log sequence to archive 2<br />
Current log sequence 2<br />
<br />
Now delete table customers.<br />
<br />
<b>SQL> delete customers;</b><br />
<br />
4 rows deleted.<br />
<br />
<b>SQL> commit;</b><br />
<br />
Commit complete.<br />
<br />
<br />
<b>SQL> select count(*) from customers;</b><br />
<br />
COUNT(*)<br />
----------<br />
0<br />
<br />
Now check the sequence no to apply so that we can recover table as it was before deletion.<br />
<br />
<b>SQL> select sequence#,first_change#, to_char(first_time,'HH24:MI:SS') from v$log order by</b><br />
<b>3;</b><br />
<br />
SEQUENCE# FIRST_CHANGE# TO_CHAR(<br />
---------- ------------- --------<br />
1 1025275 18:31:53<br />
2 1025651 18:34:56<br />
3 1025944 18:37:59<br />
<br />
Shut down the database and start in mount state.<br />
<br />
<br />
<b>SQL> shutdown immediate</b><br />
Database closed.<br />
Database dismounted.<br />
ORACLE instance shut down.<br />
<br />
<b>SQL> startup mount</b><br />
ORACLE instance started.<br />
<br />
Total System Global Area 606806016 bytes<br />
Fixed Size 1376268 bytes<br />
Variable Size 398462964 bytes<br />
Database Buffers 201326592 bytes<br />
Redo Buffers 5640192 bytes<br />
Database mounted.<br />
<br />
<br />
Recover using SQL prompt.<br />
<br />
<b>SQL> recover database UNTIL CHANGE 2;</b><br />
Media recovery complete.<br />
<br />
-----------------------------------------------<br />
Recover using RMAN<br />
<br />
RMAN> run {<br />
2> set until sequence=2;<br />
3> restore database;<br />
4> recover database;<br />
5>alter database open resetlogs;<br />
6> }<br />
<div>
-------------------------------------</div>
<br />
<div>
<div>
SQL> select count(*) from customers;</div>
<div>
<br /></div>
<div>
COUNT(*)</div>
<div>
----------</div>
<div>
4</div>
</div>
<br /></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-7753528853169422642014-08-13T07:43:00.000-07:002014-08-13T07:43:18.301-07:00Oracle: How to Get the DBID in NOMOUNT State<div dir="ltr" style="text-align: left;" trbidi="on">
DBID is the most important parameter to restore and recover controlfile using Rman. You can easily find DBID in open state but what you will do in nomount stat.<br />
<div>
<br /></div>
<div>
<b>Steps to find DBID in NOMOUNT state:</b></div>
<div>
<b><br /></b></div>
<div>
<b>First, start the database in nomount state:</b></div>
<div>
<b><br /></b></div>
<div>
<b>SQL>startup nomount;</b></div>
<div>
<br /></div>
<div>
Now set the label for identification of tracefile that will be generated during this process. </div>
<div>
<br /></div>
<div>
<b>SQL>alter session set tracefile_identifier =santosh;</b></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Get datafile name and location using v$datafile and dump some blocks of that datafile.</div>
<div>
<br /></div>
<div>
<div>
<b>SQL> select name from v$datafile;</b></div>
<div>
<br /></div>
<div>
<div>
NAME</div>
<div>
----------------------------------------------------</div>
<div>
D:\APP\SANTOSH\ORADATA\TEST11\SYSTEM01.DBF</div>
<div>
D:\APP\SANTOSH\ORADATA\TEST11\SYSAUX01.DBF</div>
<div>
D:\APP\SANTOSH\ORADATA\TEST11\UNDOTBS01.DBF</div>
<div>
D:\APP\SANTOSH\ORADATA\TEST11\USERS01.DBF</div>
<div>
D:\APP\SANTOSH\ORADATA\TEST11\USERS02.DBF</div>
</div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b>SQL> alter system dump datafile 'D:\APP\SANTOSH\ORADATA\TEST11\USERS02.DBF' </b></div>
<div>
<b> 2 block min 1 block max10;</b></div>
<div>
<br /></div>
<div>
<b>System altered.</b></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Now, check trace file using tracefile_identifier(Label) in my case it is santosh. To see the the trace file location we have:</div>
<div>
<br /></div>
<div>
<b>SQL> show parameter user_dump_dest</b></div>
<div>
<b><br /></b></div>
<div>
<b>Now open the trace file and you will get Db ID =XXXXX</b></div>
<div>
<br /></div>
<div>
Start dump data block from file D:\APP\SANTOSHTIWARI\ORADATA\TEST11\USERS02.DBF minblk 1 maxblk 10</div>
<div>
V10 STYLE FILE HEADER:</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>Compatibility Vsn = 186646528=0xb200000</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span><b>Db ID=3561501508</b>=0xd4483344, Db Name='TEST11'</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>Activation ID=0=0x0</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>Control Seq=932=0x3a4, File size=1280=0x500</div>
<div>
<span class="Apple-tab-span" style="white-space: pre;"> </span>File Number=5, Blksiz=8192, File Type=3 DATA</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Note: Take sufficient backup before dumping blocks because you may loose data, so perform this operation on your own risk.</div>
</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-46298805435357884162014-08-12T06:14:00.002-07:002014-08-12T06:14:31.235-07:00RMAN-05541: No Archived Logs Found in Target Database<div dir="ltr" style="text-align: left;" trbidi="on">
Issue: RMAN-05541: no archived logs found in target <a href="http://indialots.blogspot.in/search/label/oracle" target="_blank">database</a>.<br />
<br />
When performing a RMAN Database duplication, I get the following error:<br />
<br />
RMAN-03002: failure of Duplicate Db command at 07/30/2013 09:39:05<br />
RMAN-05501: aborting duplication of target database<br />
RMAN-05541: no archived logs found in target database<br />
<br />
Cause:<br />
<br />
<br />
<ul style="text-align: left;">
<li>Target database may not be in the archivelog mode before taking backup so first check it.</li>
<li>Sometimes Database in archived log mode, but control file did not have any archived log records. </li>
</ul>
<br />
Solution:<br />
<br />
<b>Enable archivelog mode and perform log switch before backup</b>.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjV4puvPFV3-5cBBzwXPMZqXfpCJsTktXgn41tk1jM4pC1sz99ZKzwhAcRlVi4Dy4UvDmM6nkTzaGO0OeeHoY8WMdoYm6EdGO2VLKNLL7b2hd_KSAeGOQsyLTDVNzGnmZGKhqZq_piQhF8/s1600/rman-05541.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt=" no archive logs found in target database" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjV4puvPFV3-5cBBzwXPMZqXfpCJsTktXgn41tk1jM4pC1sz99ZKzwhAcRlVi4Dy4UvDmM6nkTzaGO0OeeHoY8WMdoYm6EdGO2VLKNLL7b2hd_KSAeGOQsyLTDVNzGnmZGKhqZq_piQhF8/s1600/rman-05541.PNG" title="rman-05541: no archive logs found in target database" /></a></div>
<br />
<br />
<b>sql> alter database archivelog;</b><br />
<br />
<br />
<b>SQL> archive log list</b><br />
Database log mode Archive Mode<br />
Automatic archival Enabled<br />
Archive destination D:\app\SantoshTiwari\oradata\arc<br />
Oldest online log sequence <br />
Next log sequence to archive <br />
Current log sequence <br />
<br />
<br />
<b>SQL> alter system archive log current;</b><br />
<div>
System altered.</div>
<br />
<br />
<br />
<div>
<br /></div>
</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-3329549063760451062014-08-12T05:09:00.000-07:002014-08-12T05:12:28.416-07:00Oracle: Find Default Permanent Tablespace using Database_Properties<div dir="ltr" style="text-align: left;" trbidi="on">
To prevent people from accidentally having their own database objects in the SYSTEM tablespace Oracle introduced a default permanent tablespace because it is not healthy in terms of usability point of view to keep your own objects in SYSTEM tablespace.<br />
<br />
Every database users allocated a default permanent tablespace as USERS to store their own objects like tables and indexes.<br />
<b><br /></b>
<b>Sometimes Default Permanent Tablespace Set to a System Tablespace, </b>it means that default tablespace for newly created user will assign this tablespace.<br />
<br />
<h3 style="text-align: left;">
<b>To find Default Permanent Tablespace:</b></h3>
<br />
SQL> select PROPERTY_VALUE from database_properties<br />
2 where PROPERTY_NAME='DEFAULT_PERMANENT_TABLESPACE';<br />
<br />
PROPERTY_VALUE<br />
---------------<br />
USERS<br />
<b><br /></b>
<b> If it is system tablespace then change it as:</b><br />
<b><br /></b>
<b>sql>alter database default tablespace users;</b><br />
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-81452143370185856222014-08-12T04:43:00.001-07:002014-08-12T05:18:01.850-07:00Oracle: How to Find the Table Size<div dir="ltr" style="text-align: left;" trbidi="on">
There are different ways to find table size in <a href="http://indialots.blogspot.in/search/label/oracle">oracle</a>, views associated to check size of tables are:<br />
<br />
<ul style="text-align: left;">
<li>DBA_EXTENTS</li>
<li>USER_EXTENTS</li>
<li>DBA_SEGMENTS</li>
</ul>
<br />
<div>
<b>Method 1:</b></div>
<div>
<br /></div>
<div>
To find size of tables using view DBA_SEGMENTS:</div>
<div>
<br /></div>
<div>
<b>SQL> SELECT SEGMENT_NAME, SEGMENT_TYPE, BYTES/1024/1024 MB, TABLESPACE_NAME</b></div>
<div>
<div>
<b> 2 FROM DBA_SEGMENTS</b></div>
<div>
<b> 3 WHERE SEGMENT_TYPE='TABLE' AND SEGMENT_NAME='CUSTOMERS';</b></div>
<div>
<br /></div>
<div>
SEGMENT_NAME SEGMENT_TY MB TABLESPACE_NAME</div>
<div>
--------------- ---------- ---------- ------------------------------</div>
<div>
CUSTOMERS TABLE .0625 SYSTEM</div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFAxbMWPzR_9AJzGqPGQVG3m1reX513R7DE0_J9Cl7j6tAzNwkK6tA7CExcK96xZ16ehNPBvMWUtrhYePTjRfyrI4dc-shKr1JJsQ41ptCUpIQ9yAu50rH-WyskVpVgdE-7znJ3RDp2iqw/s1600/table_size.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFAxbMWPzR_9AJzGqPGQVG3m1reX513R7DE0_J9Cl7j6tAzNwkK6tA7CExcK96xZ16ehNPBvMWUtrhYePTjRfyrI4dc-shKr1JJsQ41ptCUpIQ9yAu50rH-WyskVpVgdE-7znJ3RDp2iqw/s1600/table_size.PNG" /></a></div>
<div>
<br /></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<b><br /></b></div>
<div>
<br /></div>
<div>
<b><br /></b></div>
<div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<b>Method 2:</b></div>
<div>
<br /></div>
<div>
To find size of tables using view DBA_EXTENTS:</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
<b>SQL> SELECT SEGMENT_NAME, SEGMENT_TYPE, BYTES/1024/1024 MB, TABLESPACE_NAME</b></div>
<div>
<b> 2 FROM DBA_EXTENTS</b></div>
<div>
<b> 3 WHERE SEGMENT_TYPE='TABLE' AND SEGMENT_NAME='CUSTOMERS';</b></div>
</div>
<div>
<br /></div>
<div>
<div>
SEGMENT_NAME SEGMENT_TY MB TABLESPACE_NAME</div>
<div>
--------------- ---------- ---------- -------------------</div>
<div>
CUSTOMERS TABLE .0625 SYSTEM</div>
</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
As a user you can also use<b> user_extents</b>.</div>
<div>
<br /></div>
<div>
<br /></div>
</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-18560279109800496472014-08-09T06:21:00.000-07:002014-08-09T06:21:01.622-07:00Oracle: Find Total Size of The Database<div dir="ltr" style="text-align: left;" trbidi="on">
The size of the <a href="http://indialots.blogspot.in/search/label/oracle" target="_blank">oracle</a> database is the total size of the data files, redo log files and temp files that make up the tablespaces of the database. These details are found in the dba_extents view. Type the following lines at the SQL prompt:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmpcogjQgAh8mFkcAeg00o390basOUWsk3bXDBY-pZyrafbPDAih8t7G5KIFgOld2WCJNX7aJ6XrnJAPD71LO81SWstW9PatddgJT3ghVt-Ls-py4X7l6VT_A25178bidRy7AHQi1v5yiS/s1600/oracle.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Total-size-of-oracle-database" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmpcogjQgAh8mFkcAeg00o390basOUWsk3bXDBY-pZyrafbPDAih8t7G5KIFgOld2WCJNX7aJ6XrnJAPD71LO81SWstW9PatddgJT3ghVt-Ls-py4X7l6VT_A25178bidRy7AHQi1v5yiS/s1600/oracle.png" height="212" title="size-of Oracle-database" width="640" /></a></div>
<br />
<br />
<b>Method 1: To find used space within the database.</b><br />
<br />
<b>SQL>select sum(bytes/1024/1024/1024) as SIZE from dba_extents;</b><br />
<br />
<b>Method 2: To find overall database size:</b><br />
<br />
The biggest portion of a database's size comes under the datafiles.<br />
To get size of all datafiles in MB:<br />
<b><br />SQL>select sum(bytes)/1024/1024 "Meg" from dba_data_files;<br /></b>To get the size of all TEMP files:<b><br /><br />select nvl(sum(bytes),0)/1024/1024 "Meg" from dba_temp_files;<br /></b>To get the size of the on-line redo-logs:<b><br /><br />select sum(bytes)/1024/1024 "Meg" from sys.v_$log;<br /></b><br />
<br />
<b>Combining all together we will get overall size: </b><br />
<b><br /></b>
<b>SQL> select ( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +<br />( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +<br />( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) +<br />( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) "Size in GB"<br />from<br />dual</b><br />
<br />
<b>Check Oracle database faq:</b><br />
<b><a href="http://www.orafaq.com/wiki/Oracle_database_FAQ" rel="nofollow" target="_blank">http://www.orafaq.com/</a> </b></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-14710754919626354762014-08-03T00:46:00.000-07:002014-08-03T00:46:50.290-07:00Tere Hoke Rahenge Lyrics - Raja Natwarlal | Arijit Singh<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: left;">
<span style="font-weight: normal;"><b>Tere Hoke Rahenge Lyrics from movie Raja Natwarlal:</b> The song Tere Hoke Rehengay is sung by Arijit Singh and music by </span><span style="font-weight: normal;"><span style="font-weight: normal;">uvan Shankar Raja.</span></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="font-weight: normal;"><span style="font-weight: normal;"></span><i><b>Song: Tere Hoke Rehengay<br />Movie: Raja Natwarlal (2014)<br />Singer: Arijit Singh<br />Music: Yuvan Shankar Raja<br />Lyrics: Irshad Kamil<br />Star Cast: Emraan Hashmi, Humaima Malick<br />Music Label: Junglee Music</b></i></span></div>
<h3 style="text-align: left;">
</h3>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZOfmKu8Nhy-F02tNlW2A0uvaiK-zxO9lfp-ZkyKNmzcHUxW7OCkFujRFKYNlve5Og_XHwwTnz8-b5JCt2Az-xjrI1MyCYZ_KZx9GftzkPNQtdod6ppMIQQGbEnZ-0N0qqs8tpFthMKpf7/s1600/natwarlal.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Tere Hoke Rahenge Lyrics" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZOfmKu8Nhy-F02tNlW2A0uvaiK-zxO9lfp-ZkyKNmzcHUxW7OCkFujRFKYNlve5Og_XHwwTnz8-b5JCt2Az-xjrI1MyCYZ_KZx9GftzkPNQtdod6ppMIQQGbEnZ-0N0qqs8tpFthMKpf7/s1600/natwarlal.PNG" title="Tere Hoke Rahenge Lyrics" /></a></div>
<h3 style="text-align: left;">
</h3>
<h3 style="text-align: left;">
Tere Hoke Rahenge Lyrics</h3>
<div style="text-align: left;">
Kal the miley, phir kyun lage aise<br />
Tumse miley... arsaa hua jaise<br />
Ab tu bataa.. jo ho pataa..<br />
Tere bina lamha lamha jiyenge kaise?<br />
<br />
Teri baahon ka ghera<br />
Badaa mehfooz lage hai<br />
Badi bekhauf jagah hai ye.. oo ooo..<br />
Inme hi rehna chaahein, teri panaahein</div>
<br />
Jab tak hai jeena chahenge, oo ooo..<br />
Tere hoke rahenge, oo ooo..<br />
Dil zid pe adaa hai, oo ooo..<br />
Tere hoke rahenge, oo ooo..<br />
Tera shauq chadha hai, oo.. oo ooo..<br />
<br />
Aankhon mein sapno ko rakh le mere<br />
Inko naa jag tod de<br />
Phir meri kismat ko jaise ho dil<br />
Waisa hi tu mod de<br />
Tu hi toh hai hausla<br />
Chaahat ka tu hai sila<br />
Jeete jee na jee sakein<br />
Kahin ab jo tu naa mila..<br />
<br />
Oo ooo.. Tere hoke rehengay<br />
Oo ooo.. Dil zidd pe adaa hai<br />
Oo ooo.. Tere ho ke rahenge..<br />
Oo ooo.. Tera shauq chadha hai<br />
Oo oo oo ooo..<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="350" src="//www.youtube.com/embed/waqWldvxw_M?feature=player_detailpage" width="550"></iframe>
=====================================<br />
<br />
कल थे मिले<br />
फिर क्यों लगे ऐसे<br />
तुमसे मिले अरसा हुआ जैसे<br />
अब तू बता जो हो पता<br />
तेरे बिना लम्हा लम्हा जिएंगे कैसे<br />
<br />
तेरी बाहों का घेरा<br />
बड़ा मेहफ़ूज़ लगे है<br />
बड़ी बेख़ौफ़ जगह है ये… ओ…<br />
इनमे ही रहना चाहें<br />
तेरी पनाहें<br />
जब तक है जीना चाहेंगे<br />
ओ… ओ…<br />
तेरे होके रहेंगे ओ… ओ…<br />
दिल ज़िद पे अड़ा है ओ… ओ…<br />
तेरे होके रहेंगे ओ… ओ… <br />
तेरा शौक़ चढ़ा<br />
ओ… ओ…<br />
<br />
आँखों में सपनों को रख ले मेरे<br />
इनको ना जग तोड़ दे<br />
फिर मेरी क़िस्मत को जैसे हो दिल<br />
वैसा ही तू मोड़ दे<br />
तू ही तो है हौसला<br />
चाहत का तू है सिला<br />
जीते जी ना जी सकें<br />
कहीं अब जो तू ना मिला<br />
<br />
ओ… ओ… तेरे होके रहेंगे<br />
ओ… ओ… दिल ज़िद पे अड़ा है<br />
ओ… ओ… तेरे होके रहेंगे<br />
ओ… ओ… तेरा शौक़ चढ़ा<br />
ओ… ओ… </div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0United States40.178873314346959 -107.57812514.656838814346958 -148.886719 65.700907814346962 -66.269531tag:blogger.com,1999:blog-5192498565219068260.post-86285755372377409012014-08-02T11:33:00.001-07:002014-08-02T11:33:12.402-07:00How to Make all Windows Version OS genuine using CMD<div dir="ltr" style="text-align: left;" trbidi="on">
It is good prescription that you should always try to avoid pirated version of windows OS like WIN 7, 8, 8.1 etc., you must buy and use genuine operating system. Yes, there is no doubt that it cost much but after and all, it's all features and support will be accessible to you.<br />
<br />
Few days back one of my friend was using downloaded windows 8 OS and found that some of it's features was not working well and a message was there on his laptop screen that make it genuine. So if you are not able to buy original product, here is a best method to make all version of windows operating system like original.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUcdIcPd0_Xstf9xERiUw5G_njdrmUFVnFtV6ZlafzgrLdFp_mopgMyKzwee0a1K9CychJc1p6ued66FJiKNH2fXVcBpT_t1o6O4TBArrZxeiaCCcc9EJqAtuALHtGBymO6OF3JP1aJ5is/s1600/windows.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Make all windows version OS Genuine" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgUcdIcPd0_Xstf9xERiUw5G_njdrmUFVnFtV6ZlafzgrLdFp_mopgMyKzwee0a1K9CychJc1p6ued66FJiKNH2fXVcBpT_t1o6O4TBArrZxeiaCCcc9EJqAtuALHtGBymO6OF3JP1aJ5is/s1600/windows.PNG" title="Make windows OS Genuine" /></a></div>
<i><u><br /></u></i>
<h3 style="text-align: left;">
<i><u>
Steps to make Windows OS (any version- 7/8/8.1) Genuine </u></i></h3>
<b>Step1:</b> Open Command Prompt (CMD) in Administrative mode:<br />
<ul style="text-align: left;">
<li>Go to start menu</li>
<li>Type "CMD"</li>
<li>Right click on "CMD" and choose "Run as administrator. </li>
</ul>
<br />
<b>Step 2:</b> On "CMD" type SLMGR -REARM as shown below, wait for few seconds until it process the request.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyhrrwSGUk_1JNdpW3dMIxTiov2uMKdlxJSFc-7MLbgt2tKnxKjwQB9eYu7LstNxXSRAB9E8JGHIFg2gmzKavECIi13yHifXi475t5abhDPhJ-tiWhXZxstfC7VgOd28m8wbxAd9aPAUoS/s1600/window-genuen.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyhrrwSGUk_1JNdpW3dMIxTiov2uMKdlxJSFc-7MLbgt2tKnxKjwQB9eYu7LstNxXSRAB9E8JGHIFg2gmzKavECIi13yHifXi475t5abhDPhJ-tiWhXZxstfC7VgOd28m8wbxAd9aPAUoS/s1600/window-genuen.PNG" /></a></div>
<br />
<br />
<br />
<br />
<b>Step3:</b> After few seconds a message window will popup having message "Restart your computer" press OK.<br />
<br />
<b>Step4:</b> After reboot you will see that there is no message regarding "make windows genuine error"or "Fix WGA" error. <br />
<br />
NOTE: This activation is only for a months. So after one months you will have to do this again.<br />
<br />
If you run the command SLMGR -REARM for more than 3 time you will get an error.<br />
Error:
0xC004D307 The maximum allowed number of re-arms has been exceeded. You
must re-install the OS before trying to re-arm again.<br />
<br />
<h3 style="text-align: left;">
<u><i>Simple steps to Reset Windows 7 Rearm:</i></u></h3>
<ul style="text-align: left;">
<li>Just open the "command prompt" or run. </li>
<li>Type "Regedit" on Command prompt and press enter.</li>
<li>Windows Registry Window would open .</li>
<li>Now search for Registry Key</li>
</ul>
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows NT/CurrentVersion/SoftwareProtectionPlatform<br />
–>“SkipRearm”=dword:00000000<br />
<br />
<b>Just
change 00000000 to 00000001.</b><br />
<br />
After 3 attempts windows OS Rearm key would
change to 00000000, So you need to change the value to enable Rearm once
again. Using this method you can make windows legal for lifetime. </div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com1tag:blogger.com,1999:blog-5192498565219068260.post-53823130278168600192014-08-01T06:28:00.001-07:002014-08-02T22:50:51.462-07:00How to Enable/Disable Archive Log Mode in 10g/11g<div dir="ltr" style="text-align: left;" trbidi="on">
By default when you enter CREATE DATABASE statement, it is in noarchive log mode, to change the archiving mode of the database, use the ALTER DATABASE statement with the ARCHIVELOG or NOARCHIVELOG clause using administrator privileges (AS SYSDBA).<br />
<div>
<br /></div>
<div>
<br /></div>
By default, <a href="http://indialots.blogspot.in/search/label/oracle">Oracle</a> database store archive logs data into the flash recovery area. If you want to set new location for archive logs, you can set using the parameter LOG_ARCHIVE_DEST_n to the location in which you wish to write archive logs.<br />
<b><br /></b>
<b>SQL> show parameter recovery_file_dest</b><br />
<br />
<b>NAME TYPE VALUE</b><br />
<b>------------------------------------ ----------- ------------------------------</b><br />
<b>db_recovery_file_dest string /u01/app/oracle/flash_recovery</b><br />
<b> _area</b><br />
<b>db_recovery_file_dest_size big integer 2782M</b><br />
<b>SQL></b><br />
<br />
<br />
<br />
<b><br /></b>
<b>SQL> alter system set log_archive_dest_1='LOCATION=/u02/app/oracle/oradata/orcl01/arch01' scope = both;</b><br />
<br />
<b>System altered.</b><br />
<br />
<b>SQL> archive log list;</b><br />
<b>Database log mode No Archive Mode</b><br />
<b>Automatic archival Disabled</b><br />
<b>Archive destination /u02/app/oracle/oradata/orcl01/arch01</b><br />
<b>Oldest online log sequence 26</b><br />
<b>Current log sequence 28</b><br />
<b>SQL> </b><br />
<b><br /></b>
<b><u><i>How to Enable Archive log Mode</i></u></b><br />
<br />
Shut down the database instance and startup in mount stage:<br />
<br />
<b>SQL> shutdown immediate</b><br />
Database closed.<br />
Database dismounted.<br />
ORACLE instance shut down.<br />
<br />
<b>SQL> startup mount</b><br />
<b><a href="http://www.oracle.com/index.html" rel="nofollow" target="_blank">ORACLE</a> instance started.</b><br />
<b><br /></b>
<b>Total System Global Area 606806016 bytes</b><br />
<b>Fixed Size 1376268 bytes</b><br />
<b>Variable Size 394268660 bytes</b><br />
<b>Database Buffers 205520896 bytes</b><br />
<b>Redo Buffers 5640192 bytes</b><br />
<b>Database mounted.</b><br />
<b><br /></b>
<br />
<b>SQL> alter database archivelog;</b><br />
<br />
Database altered.<br />
<br />
<b>SQL> alter database open;</b><br />
<br />
Database altered.<br />
<br />
<b>SQL> archive log list</b><br />
Database log mode Archive Mode<br />
Automatic archival Enabled<br />
Archive destination /u02/app/oracle/oradata/orcl01/arch01<br />
Oldest online log sequence 26<br />
Next log sequence to archive 28<br />
Current log sequence 28<br />
<br />
<b><u><i>How to Disable Archive log Mode</i></u></b><br />
<br />
<b>SQL> archive log list;</b><br />
Database log mode Archive Mode<br />
Automatic archival Enabled<br />
Archive destination /u02/app/oracle/oradata/orcl/arch<br />
Oldest online log sequence 26<br />
Next log sequence to archive 28<br />
Current log sequence 28<br />
<br />
<b>Shut down the oracle database instance and start in mount stage.</b><br />
<br />
<b>SQL> shutdown immediate</b><br />
Database closed.<br />
Database dismounted.<br />
ORACLE instance shut down.<br />
<br />
<b>SQL> startup mount</b><br />
<b>ORACLE instance started.</b><br />
<b><br /></b>
<b>Total System Global Area 606806016 bytes</b><br />
<b>Fixed Size 1376268 bytes</b><br />
<b>Variable Size 394268660 bytes</b><br />
<b>Database Buffers 205520896 bytes</b><br />
<b>Redo Buffers 5640192 bytes</b><br />
<b>Database mounted.</b><br />
<br />
<b>SQL> alter database noarchivelog;</b><br />
<br />
Database altered.<br />
<br />
<b>SQL> alter database open;</b><br />
<br />
Database altered.<br />
<br />
<b>SQL> archive log list;</b><br />
Database log mode No Archive Mode<br />
Automatic archival Disabled<br />
Archive destination /u02/app/oracle/oradata/orcl01/arch01<br />
Oldest online log sequence 26<br />
Current log sequence 28<br />
<br />
You can also check official oracle docs for enabling/disabling archivelog mode here:<br />
<br />
<b><a href="http://docs.oracle.com/cd/B28359_01/server.111/b28310/archredo003.htm" rel="nofollow" target="_blank">Controlling Archive</a></b></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-17427072992193539972014-08-01T05:40:00.001-07:002014-08-01T06:34:50.213-07:00Oracle: How to Find the Database ID (DBID)<div dir="ltr" style="text-align: left;" trbidi="on">
Every Oracle database has it's unique identifier called DBID which is necessary in most critical situations like recovery from loss of all control file using rman autobackup.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC8XCPjlwQNVF1XpJ6OAOlNtjPaBGb_VUwWVuNPaypOhemZxkJrx66G0wyLL7cV0GCqthizTx5Cn3uhnTygJZF6oOqarduCrmV1r90KqsfWa-iR8ayba7BfZkh8B18sTw4w4iPMnRfXmr_/s1600/dbid.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="How to Find Oracle DBID" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC8XCPjlwQNVF1XpJ6OAOlNtjPaBGb_VUwWVuNPaypOhemZxkJrx66G0wyLL7cV0GCqthizTx5Cn3uhnTygJZF6oOqarduCrmV1r90KqsfWa-iR8ayba7BfZkh8B18sTw4w4iPMnRfXmr_/s1600/dbid.PNG" title="Find Oracle DBID" /></a></div>
<br />
<h3 style="text-align: left;">
<b><i><u>How to find Oracle DBID ?</u></i></b></h3>
<div>
<b><i><u><br /></u></i></b></div>
<div>
<b><i><u>Method 1:</u></i></b></div>
<div>
<b><i><u><br /></u></i></b></div>
<div>
You can easily find using V$database view:</div>
<div>
<b><i><u><br /></u></i></b></div>
<div>
<b></b><br />
<div>
<b>SQL> select dbid from v$database;</b></div>
<b>
</b>
<div>
<b><br /></b></div>
<b>
<div>
DBID</div>
<div>
----------</div>
<div>
3561501577</div>
<div>
<br /></div>
<div>
<i><u>Method 2:</u></i></div>
</b></div>
<div>
<b><br /></b></div>
<div>
Find using RMAN:</div>
<div>
<br /></div>
<div>
<b></b><br />
<div>
<b>C:\windows\system32>rman target /</b></div>
<b>
</b>
<div>
<b><br /></b></div>
<b>
<div>
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 1 18:06:14 2014</div>
<div>
<br /></div>
<div>
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.</div>
<div>
<br /></div>
<div>
connected to target database: TEST11 (DBID=3561501508)</div>
<div>
<br /></div>
</b></div>
<div>
<b><br /></b></div>
<b><br /></b></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-493666864682222014-08-01T05:22:00.001-07:002014-08-01T06:35:12.143-07:00How to Restore/Recover Lost of Control File Using Rman<div dir="ltr" style="text-align: left;" trbidi="on">
Oracle database maintain three copies of Controlfile at three different locations. There are some situations arises when you loses all your controlfile. So in this case how to restore and recover controlfile using RMAN autobackup option.<br />
<br />
One day when I tried to mount the Database I encountered with an error code:<br />
<b>ORA-00205: error in identifying control file, check alert log for more info</b><br />
<b><br /></b>
SQL> startup mount<br />
ORACLE instance started.<br />
<br />
Total System Global Area 606806016 bytes<br />
Fixed Size 1376268 bytes<br />
Variable Size 394268660 bytes<br />
Database Buffers 205520896 bytes<br />
Redo Buffers 5640192 bytes<br />
<b>ORA-00205: error in identifying control file, check alert log for more info</b><br />
=============================================================<br />
<b>How to restore control file using RMAN</b><br />
<br />
C:\windows\system32><b>rman target /</b><br />
<br />
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 1 15:45:17 2014<br />
<br />
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.<br />
<br />
connected to target database: TEST11 (not mounted)<br />
<br />
<b>RMAN> restore controlfile from autobackup;</b><br />
<br />
Starting restore at 01-AUG-14<br />
using target database control file instead of recovery catalog<br />
allocated channel: ORA_DISK_1<br />
channel ORA_DISK_1: SID=133 device type=DISK<br />
<br />
RMAN-00571: ===========================================================<br />
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />
RMAN-00571: ===========================================================<br />
RMAN-03002: failure of restore command at 08/01/2014 15:46:27<br />
RMAN-06495: must explicitly specify DBID with SET DBID command<br />
<br />
<b>RMAN> restore controlfile;</b><br />
<br />
Starting restore at 01-AUG-14<br />
using channel ORA_DISK_1<br />
<br />
RMAN-00571: ===========================================================<br />
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<br />
RMAN-00571: ===========================================================<br />
RMAN-03002: failure of restore command at 08/01/2014 15:47:03<br />
RMAN-06563: control file or SPFILE must be restored using FROM AUTOBACKUP<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiikF7u8uPtsQJV3kioIkanspviFxEDwk4vriJjiYV91DaX7loJhnh1fPGmd1Sa_Nhn8EK07PScrwJMwHQL90FfIoDipli2HQpjW73_lulPBm0DMbBuG8Xdx1zkjNnPzbH-LsLswHEBMkG/s1600/rman%5D.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjiikF7u8uPtsQJV3kioIkanspviFxEDwk4vriJjiYV91DaX7loJhnh1fPGmd1Sa_Nhn8EK07PScrwJMwHQL90FfIoDipli2HQpjW73_lulPBm0DMbBuG8Xdx1zkjNnPzbH-LsLswHEBMkG/s1600/rman%5D.PNG" /></a></div>
<br />
<br />
<br />
<br />
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b>STEP 1: You need to set DBID before recovery</b><br />
<br />
<b> SQL> host rman target /</b><br />
<b><br /></b>
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 1 17:26:13 2014<br />
<br />
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.<br />
<br />
connected to target database:<b> TEST11 (DBID=3561501508)</b><br />
<b><br /></b>
<b>SQL> select dbid from v$database;</b><br />
<b><br /></b>
<b> DBID</b><br />
<b>----------</b><br />
<b></b><br />
<b>3561501508</b><br />
<b><br /></b>
<b>But if your database is not mounted, you cannot find DBID. So set ID to any number you want.</b><br />
<b>ex: </b><br />
<br />
<b>RMAN> set DBID=3561501508</b><br />
<b><br /></b>
<br />
executing command: SET DBID<br />
<br />
<b>STEP2: Restore control file from autobackup:</b><br />
<b><br /></b>
<b>RMAN> restore controlfile from autobackup;</b><br />
<br />
Starting restore at 01-AUG-14<br />
using channel ORA_DISK_1<br />
<br />
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20140801<br />
channel ORA_DISK_1: AUTOBACKUP found: c-3561501508-20140801-00<br />
channel ORA_DISK_1: restoring control file from AUTOBACKUP c-3561501508-20140801-00<br />
channel ORA_DISK_1: control file restore from AUTOBACKUP complete<br />
output file name=D:\APP\SANTOSHTIWARI\ORADATA\TEST11\CONTROL01.CTL<br />
Finished restore at 01-AUG-14<br />
<br />
<b>STEP3: </b><br />
<b><br /></b>
<b>RMAN> alter database mount;</b><br />
<br />
database mounted<br />
released channel: ORA_DISK_1<br />
<b><br /></b>
<b>STEP4</b><br />
<b>RMAN> recover database;</b><br />
<br />
Starting recover at 01-AUG-14<br />
allocated channel: ORA_DISK_1<br />
channel ORA_DISK_1: SID=133 device type=DISK<br />
<br />
starting media recovery<br />
<br />
archived log for thread 1 with sequence 3 is already on disk as file D:\APP\SANTOSHTIWARI\ORADATA\TEST11\REDO03.LOG<br />
archived log file name=D:\APP\SANTOSHTIWARI\ORADATA\TEST11\REDO03.LOG thread=1 sequence=3<br />
media recovery complete, elapsed time: 00:00:01<br />
Finished recover at 01-AUG-14<br />
<br />
<b>RMAN> alter database open resetlogs;</b><br />
<br />
database opened<br />
<br /></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-8566379046038681202014-07-29T05:56:00.000-07:002014-08-01T06:35:28.587-07:00ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1], [65], [52510], [52529], []<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
<b>ORA-00600 internal error code:</b></h3>
This error code is native to internal exceptions from the Oracle programs. It<br />
indicates that the process has encountered an unexpected problem. It may be<br />
due to:<br />
Timeout<br />
A corrupted file<br />
A crash that has affected stored data<br />
I/O issue "(physical memory)"<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitZRk1c9EEvKh_4_AUdzfiCOUn8icZGvU8sagtmR7xW7qQvDN9YjLXqPmlD16ZjT3hdXTVDMjqrNzUhW64RdX54EkRcfJEbrb0k55Xk1P4HjRwoP-x3tthKGZg26GczPEA29yNL4ExgIbP/s1600/oracle.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitZRk1c9EEvKh_4_AUdzfiCOUn8icZGvU8sagtmR7xW7qQvDN9YjLXqPmlD16ZjT3hdXTVDMjqrNzUhW64RdX54EkRcfJEbrb0k55Xk1P4HjRwoP-x3tthKGZg26GczPEA29yNL4ExgIbP/s1600/oracle.png" height="215" width="640" /></a></div>
<br />
<br />
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<br />
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b><br /></b>
<b>ORA-00600: internal error code resolved:</b><br />
<b><br /></b>
<b><br /></b>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBKg4f-de9daGauAoVywNwDkfOTUqC06q0Ct-BNq_CVOTNJA4oLVzf82popEG4S-09J0oahnj4ue88L_59gak0QqneaojUWCtvo8ka-9bX1EJPq18-qdY-2bqFsPsjBtWx_1BeK97mAQZZ/s1600/ORA+ERROR.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBKg4f-de9daGauAoVywNwDkfOTUqC06q0Ct-BNq_CVOTNJA4oLVzf82popEG4S-09J0oahnj4ue88L_59gak0QqneaojUWCtvo8ka-9bX1EJPq18-qdY-2bqFsPsjBtWx_1BeK97mAQZZ/s1600/ORA+ERROR.PNG" /></a><b><br /></b>
SQL> alter database open<br />
2 ;<br />
alter database open<br />
*<br />
ERROR at line 1:<br />
ORA-00600: internal error code, arguments: [kcratr_nab_less_tha<br />
[65], [52510], [52529], [], [], [], [], [], [], []<br />
<br />
<b>THIS ERROR IS DUE TO INVALID ENTRY IN THE CONTROL FILE:</b><br />
<br />
<b><u>SOLUTION TO ORA-00600:</u></b><br />
<b><u><br /></u></b>
<b>IT IS BETTER TO CREATE A NEW CONTROL FILE.</b><br />
<b><br /></b>
<b>FIRST CHECK IF CONTROL FILE EXIST OR NOT?</b><br />
<b><br /></b>
SQL>STARTUP NOMOUNT<br />
<br />
SQL> ed a.sql<br />
<br />
<br />
IF THERE WILL BE A CONTROL FILE THEN IT WILL OPEN. NOW INSIDE CONTROL FILE CHECK THE LOCATION OF:<br />
REDO LOGS<br />
SYSTEM FILE<br />
SYSAUX FILE<br />
UDO FILE<br />
USER FILE<br />
<br />
FINALLY DELETE OR BACKUP OLDER CONTROL FILE AND RECREATE NEW ONE USING:<br />
SQL>@ a.sql<br />
<br />
CASE 2: IF CONTROL FILE DOESN'T EXIST THEN RECREATE NEW ONE:<br />
<br />
SQL>SHUT IMMEDIATE<br />
SQL>STARTUP MOUNT<br />
SQL> alter database backup controlfile to trace<br />
2 ;<br />
<br />
Database altered.<br />
<br />
SQL> shutdown abort<br />
ORACLE instance shut down.<br />
SQL> startup nomount<br />
ORACLE instance started.<br />
<br />
Total System Global Area 606806016 bytes<br />
Fixed Size 1376268 bytes<br />
Variable Size 385880052 bytes<br />
Database Buffers 213909504 bytes<br />
Redo Buffers 5640192 bytes<br />
SQL> ed a.sql<br />
DELETE OLDER CONTROL FILE BEFORE CREATING NEW ONE:<br />
SQL> @ a.sql<br />
<br />
Control file created.<br />
<br />
SQL> ALTER DATABASE OPEN RESETLOGS;<br />
<br />
Database altered.<br />
<br />
SQL> SELECT OPEN_MODE FROM V$DATABASE;<br />
<br />
OPEN_MODE<br />
--------------------<br />
READ WRITE<br />
<br />
<br /></div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0tag:blogger.com,1999:blog-5192498565219068260.post-39087473872152186862014-07-20T03:56:00.004-07:002014-08-03T00:07:57.380-07:00Muskurane Ki Wajah Lyrics - Citylights | Arijit Singh<div dir="ltr" style="text-align: left;" trbidi="on">
<h3 style="text-align: left;">
Mukurane ki wajah song Lyrics of hindi film CITYLIGHTS. </h3>
<div style="text-align: left;">
The music is composed by Jeet Ganguli, <a href="http://indialots.blogspot.in/search/label/Lyrics">lyrics</a> written by Rashmi Singh and music out on <a href="http://en.wikipedia.org/wiki/Sony_Music_Entertainment" rel="nofollow">Sony Music</a>. Here you will get this lyrics in both version I.,e hindi and English. You can prefer any one according to your needs.</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFDAktWBs2RFkOJHRM2ZhIA5TF37UbqGrlW-O-gYrtl5qaZjUagGvlIV_eiozjHgp0gL19enm25ZeXArkVeNM26HNJJ9K-juLWbJ7uiNwLgXUuPYyVT-4GrNESRvyVv0_1GUKDHB51oZKv/s1600/muskurane.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="muskurane ki song lyrics" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFDAktWBs2RFkOJHRM2ZhIA5TF37UbqGrlW-O-gYrtl5qaZjUagGvlIV_eiozjHgp0gL19enm25ZeXArkVeNM26HNJJ9K-juLWbJ7uiNwLgXUuPYyVT-4GrNESRvyVv0_1GUKDHB51oZKv/s1600/muskurane.PNG" title="muskurane ki lyrics" /></a></div>
<br />
Details:<br />
<br />
SONG: Muskurane<br />
SINGER: Arijit Singh<br />
LYRICS: Rashmi Singh <br />
MUSIC: Jeet Ganguli<br />
MOVIE: Citylights (2014)<br />
STARS: Rajkumar Rao, Patraleka<br />
MUSIC ON: Sony Music<br />
<br />
<br />
<b>Muskurane Lyrics:</b><br />
=================================================<br />
<br />
Muskurane ki wajah tum ho<br />
Gungunane ki wajah tum ho<br />
Jiya jaaye na, jaaye na, jaaye na..<br />
O re piya re...<br />
Jiya jaaye na, jaaye na, jaaye na..<br />
O re piya re....<br />
O re lamhe tu kahin mat jaa<br />
Ho sake toh umr bhar tham jaa<br />
Jiya jaaye na, jaaye na, jaaye naa..<br />
O re piya re..<br />
Jiya jaaye na, jaaye na, jaaye naa..<br />
O re piya re.. piyaa re..<br />
Dhoop aaye toh, chhaanv tum laana<br />
Khwahishon ki baarishon mein<br />
Bheeg sang jaana (x2)<br />
Jiya jaaye na jaaye na jaaye na<br />
O re piya re...<br />
Jiya jaaye na jaaye na jaaye na<br />
O re piya re.. piya re...<br />
Jo mile usme kaat lenge hum<br />
Thodi khushiyaan thode aansu baant lenge hum<br />
Jo mile usme kaat lenge hum<br />
Thodi khushiyaan thode aansu baant lenge hum<br />
Jiya jaaye na jaaye na jaaye na<br />
O re piya re...<br />
Jiya jaaye na jaaye na jaaye na<br />
O re piya re.. piya re..<br />
Muskurane ki wajah tum ho<br />
Gungunane ki wajah tum ho<br />
Jiya jaaye na, jaaye na, jaaye na<br />
O re piya re.. <br />
Jiya jaaye na, jaaye na, jaaye na<br />
O re piya re.. piya re...<br />
Piya re...<br />
Wo o ho.. oo.....<br />
<br />
<br />
<iframe allowfullscreen="" frameborder="0" height="360" src="//www.youtube.com/embed/HQ4Ox7mLqds?feature=player_detailpage" width="560"></iframe>
<br />
<br />
================================================================<br />
<br />
मुस्कुराने की वज़ह तुम हो <br />
गुनगुनाने की वज़ह तुम हो <br />
जिया जाए ना <br />
जिया जाए ना <br />
जिया जाए ना <br />
ओ रे पिया रे… <br />
<br />
ओ रे लम्हे तू कहीं मत जा<br />
हो सके तो उमर भर थम जा <br />
जिया जाए ना <br />
जाए ना, जाए ना <br />
ओ रे पिया रे… <br />
जिया जाए ना <br />
जाए ना, जाए ना <br />
ओ रे पिया रे… <br />
पिया रे…<br />
<br />
धुप आए तो, छाँव तुम लाना <br />
ख़्वाहिशों की बारिशों में <br />
भीग संग जाना (X2)<br />
जिया जाए ना <br />
जाए ना, जाए ना <br />
ओ रे पिया रे… <br />
जिया जाए ना <br />
जाए ना, जाए ना <br />
ओ रे पिया रे… <br />
पिया रे…</div>
Santoshhttp://www.blogger.com/profile/11544041608381279512noreply@blogger.com0