Oracle in World

I will add 5000+ facebook page likes from Usa Australia countries in 48 hours, all real and active fb fans, pagelikes, fbfans, facebook pages, fanpages

noreply@blogger.com (Arju) — Mon, 17 Dec 2012 00:47:42 PST

From now on I will give you facebook likes who are interested to buy likes or fans for their photo/fanpage/website/video/status likes/post like/subscriber/add friends. A very cheap rate, just 100 likes for $5.

Buy your fans now!

Yes, I'll give you 100 facebook fans on your fanpage. Majority of page likes from Australian and American countries, super fast delivery, all real and active, fans to your fb page, every time you start a your business or hobby, all you want is audience, fb page a great source to get them, pagelikes are necessary to look good and is also good for SEO as well, your page indicated and define your business.

I will give you that audience, in the fastest possible time and I'm sure you'll. You'll see a rise in your traffic and earning you never had before. You can order as many times as you want! You can order in bulk too. 5000 USA likes for $200 only. Please email me arjuiut@gmail.com if you see any confusion. I am also available on gtalk and skype. Contact me now.

If you want just from Australia or Canada or USA just mention me while buying. Grow your business, be familiar. I can also deliver if you want fans USA statewise. In that case per 25 fans/likes amount will be $5. No refund policy once I deliver you fans. If I fail to deliver fans then 100% refundable.

Contact me, if you want to buy in bulk.
Thanks.

Dedicated Hosting at $149.99 per month

noreply@blogger.com (Arju) — Mon, 12 Nov 2012 18:57:40 PST

Buy your website hosting only at $149.99 per month.

A web hosting service is a type of Internet hosting service that allows individuals and organizations to make their website accessible via the World Wide Web. Web hosts are companies that provide space on a server owned or leased for use by clients, as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for other servers located in their data center, called colocation, also known as Housing in Latin America or France.

The scope of web hosting services varies greatly. The most basic is web page and small-scale file hosting, where files can be uploaded via File Transfer Protocol (FTP) or a Web interface. The files are usually delivered to the Web "as is" or with minimal processing. Many Internet service providers (ISPs) offer this service free to subscribers. Individuals and organizations may also obtain Web page hosting from alternative service providers. Personal web site hosting is typically free, advertisement-sponsored, or inexpensive. Business web site hosting often has a higher expense.

Single page hosting is generally sufficient for personal web pages. A complex site calls for a more comprehensive package that provides database support and application development platforms (e.g. PHP, Java, Ruby on Rails, ColdFusion, or ASP.NET). These facilities allow customers to write or install scripts for applications like forums and content management. Also, Secure Sockets Layer (SSL) is typically used for e-commerce.

The host may also provide an interface or control panel for managing the Web server and installing scripts, as well as other modules and service applications like e-mail. Some hosts specialize in certain software or services (e.g. e-commerce), which are commonly used by larger companies that outsource network infrastructure.

Abasa Arju's Birthday Photos

noreply@blogger.com (Arju) — Tue, 23 Oct 2012 00:46:05 PDT

It was 1st June. But was too much busy to post. Before EID I just posted some before leaving for house to enjoy EID Vacation.

Banglalink Internet Packages

noreply@blogger.com (Arju) — Fri, 14 Sep 2012 21:11:36 PDT

currently banglalink is providing following gprs packages

duration	who can buy	pack id	package details	package price (excluding vat)
monthly packs	postpaid, prepaid, call & control	p2	unlimited	tk. 650
		p3	night-time unlimited (12-8am free usage only & 8:01am-11:59pm 1kb@0.02tk+vat)	tk. 300
		p6	1gb	tk. 275
	prepaid, call & control	p13	morning unlimited - monthly (5-10am free & 10:01am to 4:59am 1mb@1.03tk+vat)	tk. 200
	prepaid, call & control	p5	100mb	tk. 100
weekly packs	prepaid, call & control	p12	morning unlimited - weekly (5am -10am free & 10:01am to 4:59am 1mb@1.03tk+vat)	tk. 70
weekly packs	prepaid, call & control	p8	50mb	tk. 50
daily packs	prepaid, call & control	p4	200mb	tk. 50
		p11	morning unlimited - daily (5am -10am free & 10:01am to 4:59am 1mb@1.03tk+vat)	tk. 20
		p7	15mb	tk. 20
		p9	5mb	tk. 8
		p10	2mb	tk. 4
pay-as-you-go	postpaid, prepaid, call & control	p1	1kb@0.02tk (prepaid) 1kb@0.015tk (postpaid and call and control subscribers)	free

*note: all items are subject to 15% vat in addition to the abovementioned charges.

how to purchase

dialing *500# internet menu, a subscriber can choose from different packs. or, s/he can dial directly to place request for a specific pack as follows.

pack validity	pack id	direct dialing ussd code (internet menu)
monthly	p2	500111#
	p3	500121#
	p6	500131#
	p13	500141#
	p5	500151#
weekly	p12	500211#
weekly	p8	500221#
daily	p4	500311#
	p11	500321#
	p7	500331#
	p9	500341#
	p10	500351#
pay as you go	p1	5004*1#

alternatively, he/ she can request by typing pack id (example: p2 or p6 or p10) and sending sms to 3343.
whichever way the subscriber places the request, s/he will receive a reply sms will come from 3343.
prepaid and call and control subscribers will have to follow the instruction to confirm the purchase of desired pack.

internet balance check & un-subscription

prepaid and call and control subscribers can dial following:

purpose	ussd code
balance check	2223#
un-subscription	2222#

please note, if your handset has any previous settings of other operator then you need to make the banglalink gprs settings as your default/preferred setting.

banglalink internet fair usage policy applies.

services and features

wap/ internet browsing

handset browsing
with gprs you’ll be able to browse the internet using your gprs enabled handset. most websites available in the internet can be accessed through gprs enabled handsets.

laptop/ personal computer (pc) browsing
you will also be allowed to use the gprs enabled handset as a modem and log in to the internet using a pc or a laptop. standard connectivity tools like data cable, infrared, bluetooth, as well as driver software is required for laptop/pc browsing

pcmcia/usb connect card
standard pcmcia or usb connect cards can be connected to pc/laptops for browsing. handset is not required, only the sim card needs to be inserted inside the connect card for internet browsing

frequently asked questions

gprs service

1. how can i know if my handset supports gprs?
ans: most current handset models released within the last 2-3 years supports gprs. you can also verify with the handset manufactures or the handset manual.

2. what is the difference between gprs and edge?ans: technically edge is a faster data bearer than gprs, but both technologies provide the same services

3. i am using other operator’s edge/gprs service with my handset. can i use banglalink gprs with the same handset?ans: yes, but banglalink gprs settings needs to be set as the default setting

4. can i check email using gprs?ans: yes, you can check any web based email account like yahoo, hotmail through gprs. other email accounts (business email, email account provided by internet provider) might also be accessed through gprs; depending on the type of handset used.

5. can i only activate wap or web browsing service?ans: no; all the gprs services need to be activated (wap, web). however, you may use only wap or web browsing if you so wish.

6. what is wap?ans: wap (wireless application protocol) is a special protocol that enables mobile phone users to access the internet in a simplified format. most handsets have built in wap support.

7. my handset does not support web, but supports wap. can i browse the internet?ans: yes, you can visit the simplified wap versions of most popular web sites. if you enter the web address, you will be automatically taken to the respective web site’s wap versions.

connect card

1. what is a gprs/edge connect card?ans: it is a device where you can insert a gprs enabled sim card and get connected to the internet through a pc/laptop.

2. how do i install a connect card?ans: the connect card needs to be connected to either pcmcia port (laptop) or usb port (laptop/pc). most connect cards are bundled with appropriate driver software, which can be installed easily.

3. do i need a data cable for my mobile to use connect card?ans: no, actually connect card totally eliminates the need for using the handset and its accessories for using internet.

4. can i receive calls during using a connect card?ans: you have to remove the sim card from your handset in order to insert it in to the connect card and hence you cannot receive calls.

5. why would i use a connect card when i can use internet by connecting my handset through data cable/infra-red?ans: handset battery charge depletes very fast when it is used for gprs browsing. also, infra-red connectivity is unstable, and a slight movement might cause disconnection.

6. where can i find a connect card?ans: connect cards are available in most computer shops situated in idb. also, it can be found in etc.

gprs settings

internet

web settings
profile name	blweb
apn (access point name)	blweb
**protocol	http

wap

wap settings
profile name	blwap
apn (access point name)	blwap
gateway (proxy) ip	10.10.55.34 or 010.010.055.34
gateway (proxy) port	8799
**protocol	http

mms

mms settings
profile name	banglalink mms
apn (access point name)	blmms
gateway (proxy) ip	10.10.55.34
gateway (proxy) port	8799
relay server url	http://mmsc1:10021/mmsc/01
data bearer	gprs
** maximum allowed size for mms is 100 kb; messages exceeding 100 kb will not be delivered.

Banglalink Important USSD dial numbers

noreply@blogger.com (Arju) — Thu, 30 Aug 2012 19:30:54 PDT

banglalink top 50 USSD dial no's:

1. Check Own Number: *511#
2. Check Current Package: *125#
3. Banglalink Advance: *874#
4. GPRS Pack P2 Activation:*222*1*4#
5. GPRS Pack P3 Activation:*222*1*12#
6. GPRS Pack P4 Activation:*222*1*1#
7. GPRS Pack P6 Activation:*222*1*8#
8. GPRS Pack P7 Activation:*222*1*5#
9. GPRS Pack P8 Activation:*222*1*6#
10. GPRS Pack P9 Activation:*222*1*7#
11. GPRS Pack P5 Activation:*222*1*3#
12. GPRS Pack P10 Activation:*222*1*2#
13. GPRS Pack P11 Activation:*222*1*9#
14. GPRS Pack P12 Activation:*222*1*10#
15. GPRS Pack P13 Activation:*222*1*11#
16. GPRS Data Check: *222*3#
17. GPRS Deactivation: *222*2#
18. GPRS Bonus Check:*124*5#
19. Special FnF Activation: *166*7*Number#
20. Special FnF Deactivation: *166*7*old FnF*new FnF#
21. Set FnF: *789*7*3*1#
22. Check FnF: *789*7*3*2#
23. Change FnF: *789*7*3*3#
24. Remove FnF: *789*7*3*4#
25. SME C&C 500 Activation: *132*12#
26. SME C&C 500 Dectivation: *132*13#
27. SME C&C 500 Usage Check: *132*12#
28. Call Me Back: *126*Number#
29. MCA Out of Reach: **62*622#
30. Power Menu: *789#
31. USSD Alert Service: *234#
32. Prize Point Check: *567*1 # OR*720*1#
33. 100 SMS Activation: *222*8#
34. 100 SMS Deactivation: *222*9#
35. 100 SMS Balance Check: *124*3#
36. 500 SMS Activation: *132*1#
37. 500 SMS Balance Check: *124*2#
38. Check Bonus Talktime & Validity: *124*3# OR *124*4#
39. Check Bonus SMS Balance & Validity: *124*3# OR *124*4#
40. 65paisa/min Activation: *166*4*2#
41. 65paisa/min Dectivation: *166*5#
42. Banglalink Emergency: *321#
43. VMS Activation: **21*770#
44. Dial Up Number: *99***1#
45. Bill Pay Service: *777#
46. Mobile Train Ticket: *131#
47. Jobs Link Subscribe: *108*1#
48. Jobs Link Unsubscribe: *108*1*2#
49. Bibaho Link Subscribe: *108*2#
50. Bibaho Link Unsubscribe: *108*2*3#

Use Grameenphone Internet Modem for another Operator (Banglalink, Robi, Airtel, Teletalk)

noreply@blogger.com (Arju) — Sat, 25 Aug 2012 01:11:39 PDT

At first open the default Software given to you with modem, then go to ...

Tools > Options > Profile Management

By Default Profile Name : GP-INTERNET is selected.

To use the modem with another operator SIM you have to create new profele.
So click on the right side panel select "New"

For Aktel/Robi

Profile Name : AKTEL-INTERNET
APN Static : internet
Access Number : *99***1#
Then press OK .

Now insert Aktel SIM on your modem & select profile name : AKTEL-INTERNET .
Then click Connect.

For Warid/Airtel

Profile Name : WARID-INTERNET
APN Static: internet
Access Number : *99***1#
Then press OK

Now insert Warid SIM on your modem & select profile name : WARID-INTERNET .
Then click Connect.

For Banglalink

Profile Name : Banglalink-WEB
APN Static : blweb
Access Number : *99***1#
Then press OK

Now insert Banglalink SIM on your modem & select profile name : Banglalink-WEB .
Then click Connect.

FOR TELETALK

Service Type - No Use No Pay
APN wap
IP 192.168.145.101
Port (optional) 9201

Service - Monthly/Daily Unlimited
APN gprsunl
IP 192.168.145.101
Port (optional) 9201

How to detect iPhone and iPad's User Agent using PHP or JavaScript

noreply@blogger.com (Arju) — Thu, 09 Aug 2012 23:01:07 PDT

Whenever a user visit your website or a page via iPhone or iPad Apple provides user agent agent.

iPad's user agent string is:

Mozilla/5.0 (iPad; U; CPU OS 3_2 like Mac OS X; en-us) AppleWebKit/531.21.10 (KHTML, like Gecko) Version/4.0.4 Mobile/7B334b Safari/531.21.10

The iPhone's user agent string appears as follows:

HTTP_USER_AGENT=Mozilla/5.0 (iPhone; U; CPU like Mac OS X; en) AppleWebKit/420+ (KHTML, like Gecko) Version/3.0 Mobile/1C25 Safari/419.3

Provided with this information, it's fairly straight forward to use JavaScript to detect the user agent, and send the user to a specific page:
JavaScript Solution
<script type="text/javascript">

if((navigator.userAgent.match(/iPhone/i)) ||

(navigator.userAgent.match(/iPod/i))) {

if (document.cookie.indexOf("iphone_redirect=false") == -1) window.location = "http://iphone.yoursite.com/";

}

</script>

PHP Solution
You can achive the same functionality by using server side scripting via PHP,
if(strstr($_SERVER['HTTP_USER_AGENT'],'iPhone') || strstr($_SERVER['HTTP_USER_AGENT'],'iPod'))
{
header('Location: http://yoursite.com/iphone');
exit();
}
?>
.htaccess Solution.
You can also use .htaccess file to do the same thing on the server side of things:
RewriteCond %{HTTP_USER_AGENT} ^.*iPad.*$
RewriteRule ^(.*)$ http://ipad.yourdomain.com [R=301]

How to check active processes in Oracle

noreply@blogger.com (Arju) — Fri, 22 Jun 2012 07:48:22 PDT

In Oracle, you can check currently active process. Following is the query with output. This query is shown for all users. So you can filter processes by USERNAME.

SET pagesize 55
SET linesize 170
col SQL format a80
col SERVER heading 'SERVER' format a10
col EVENT heading 'WAITING' format a30 fold_after
col OSUSER heading 'OSUSER' format a8
col USERNAME heading 'USERNAME' format a8
col PID heading 'OSPID' format 99999
col DISK_READS heading 'DISK I/O' format 99999999
col BUFFER_GETS heading 'BUFFER|GETS' format 99999999
 
SELECT  SUBSTR(V$SESSION.USERNAME,1,8) USERNAME,
     V$SESSION.OSUSER OSUSER,
     V$SESSION.SERVER SERVER,
     V$SQLAREA.DISK_READS DISK_READS,
     V$SQLAREA.BUFFER_GETS BUFFER_GETS,
        SUBSTR(V$SESSION.LOCKWAIT,1,10) LOCKWAIT,
     V$SESSION.PROCESS PID,
     V$SESSION_WAIT.EVENT EVENT,
        V$SQLAREA.SQL_TEXT SQL
FROM    V$SESSION_WAIT, V$SQLAREA, V$SESSION
WHERE   V$SESSION.SQL_ADDRESS = V$SQLAREA.ADDRESS AND
     V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE AND
        V$SESSION.SID = V$SESSION_WAIT.SID (+) AND
     V$SESSION.STATUS = 'ACTIVE' AND
     V$SESSION_WAIT.EVENT != 'client message'
ORDER BY V$SESSION.LOCKWAIT ASC, V$SESSION.USERNAME;

Here goes a sample output from the above query,

SQL> SET pagesize 55
SQL> SET linesize 170
SQL> col SQL format a80
SQL> col SERVER heading 'SERVER' format a10
SQL> col EVENT heading 'WAITING' format a30 fold_after
SQL> col OSUSER heading 'OSUSER' format a8
SQL> col USERNAME heading 'USERNAME' format a8
SQL> col PID heading 'OSPID' format 99999
SQL> col DISK_READS heading 'DISK I/O' format 99999999
SQL> col BUFFER_GETS heading 'BUFFER|GETS' format 99999999
SQL>
SQL> SELECT  SUBSTR(V$SESSION.USERNAME,1,8) USERNAME,
  2       V$SESSION.OSUSER OSUSER,
  3       V$SESSION.SERVER SERVER,
  4       V$SQLAREA.DISK_READS DISK_READS,
  5       V$SQLAREA.BUFFER_GETS BUFFER_GETS,
  6          SUBSTR(V$SESSION.LOCKWAIT,1,10) LOCKWAIT,
  7       V$SESSION.PROCESS PID,
  8       V$SESSION_WAIT.EVENT EVENT,
  9          V$SQLAREA.SQL_TEXT SQL
 10  FROM    V$SESSION_WAIT, V$SQLAREA, V$SESSION
 11  WHERE   V$SESSION.SQL_ADDRESS = V$SQLAREA.ADDRESS AND
 12       V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE AND
 13          V$SESSION.SID = V$SESSION_WAIT.SID (+) AND
 14       V$SESSION.STATUS = 'ACTIVE' AND
 15       V$SESSION_WAIT.EVENT != 'client message'
 16  ORDER BY V$SESSION.LOCKWAIT ASC, V$SESSION.USERNAME;

                                          BUFFER
USERNAME OSUSER   SERVER      DISK I/O      GETS LOCKWAIT OSPID        WAITING
-------- -------- ---------- --------- --------- -------- ------------ ------------------------------
SQL
--------------------------------------------------------------------------------
SYS      USER-PC\ DEDICATED          0        51          2072:5608    SQL*Net message to client
         Administ
         rator
SELECT  SUBSTR(V$SESSION.USERNAME,1,8) USERNAME,      V$SESSION.OSUSER OSUSER,
    V$SESSION.SERVER SERVER,      V$SQLAREA.DISK_READS DISK_READS,      V$SQLARE
A.BUFFER_GETS BUFFER_GETS,         SUBSTR(V$SESSION.LOCKWAIT,1,10) LOCKWAIT,
  V$SESSION.PROCESS PID,      V$SESSION_WAIT.EVENT EVENT,         V$SQLAREA.SQL_
TEXT SQL FROM    V$SESSION_WAIT, V$SQLAREA, V$SESSION WHERE   V$SESSION.SQL_ADDR
ESS = V$SQLAREA.ADDRESS AND      V$SESSION.SQL_HASH_VALUE = V$SQLAREA.HASH_VALUE
 AND         V$SESSION.SID = V$SESSION_WAIT.SID (+) AND      V$SESSION.STATUS =
'ACTIVE' AND      V$SESSION_WAIT.EVENT != 'client message' ORDER BY V$SESSION.LO
CKWAIT ASC, V$SESSION.USERNAME

What's the difference between %TYPE vs %ROWTYPE

noreply@blogger.com (Arju) — Fri, 22 Jun 2012 07:30:50 PDT

Both %TYPE and %ROWTYPE are used to define variables in PL/SQL as it is defined within the database. If the datatype or precision of a column changes, the program automatically picks up the new definition from the database.

The %TYPE and %ROWTYPE constructs provide data independence, reduce maintenance costs, and allows programs to adapt as the database changes.

Here is shown an example of the differences between two.

-- %TYPE is used to declare a field with the same type as 
-- that of a specified table's column. In this example emp table column name ename. 
 
DECLARE
   v_EmpName  emp.ename%TYPE;
BEGIN
   SELECT ename INTO v_EmpName FROM emp WHERE ROWNUM = 1;
   DBMS_OUTPUT.PUT_LINE('Name = ' || v_EmpName);
END;
/
 
 
 
-- %ROWTYPE is used to declare a record with the same types as 
-- found in the specified database table, view or cursor: 
 
DECLARE
  v_emp emp%ROWTYPE;
BEGIN
  v_emp.empno := 10;
  v_emp.ename := 'XXXXXXX';
END;
/

"Invalid Entry Size" Error During Oracle Database Installation

noreply@blogger.com (Arju) — Wed, 20 Jun 2012 22:59:37 PDT

Problem Description
While installing Oracle database the following error is reported.

ID: oracle.install.commons.util.exception.DefaultErrorAdvisor:6133
oracle.install.commons.base.driver.common.SetupDriverException: invalid entry size (expected 46818332 but got 46818399 bytes)
at oracle.install.driver.oui.OUISetupDriver.setup(OUISetupDriver.java:483)
at oracle.install.driver.oui.SetupJob.call(SetupJob.java:178)
at oracle.install.driver.oui.SetupJob.call(SetupJob.java:52)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:284)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:678)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:703)
at java.lang.Thread.run(Thread.java:811)
Caused by: oracle.sysman.oii.oiic.OiicInstallAPIException: invalid entry size (expected 46818332 but got 46818399 bytes)
at oracle.sysman.oii.oiic.OiicAPIInstaller.doOperation(OiicAPIInstaller.java:1017)
at oracle.sysman.oii.oiic.OiicAPIInstaller.doOperation(OiicAPIInstaller.java:937)
at oracle.install.driver.oui.OUISetupDriver.setup(OUISetupDriver.java:472)
... 7 more

Cause of the Problem
The cause was due to corrupted Installation Source files which can happen during download, copy, or ftp transfer to another server.

Solution of the Problem

1. Once the Oracle installation kit has been downloaded from either OTN or Oracle Software Delivery Cloud confirm the filesizes and checksums match the values from the download. I have written a post about how you can verify checksums in http://arjudba.blogspot.com/2012/06/how-to-verify-checksum-of-patchsoftware.html .

2. If you are moving the software installation from one server to another then transfer the source using ftp/scp in binary mode and check the checksums before starting the installation.

How to verify checksum of a Patch/Software Download

noreply@blogger.com (Arju) — Wed, 20 Jun 2012 23:00:06 PDT

What is MD5 checksum?

MD5 stands for Message-Digest algorithm 5. The MD5 algorithm takes as input a message of random length and produces as output a 128-bit "fingerprint" or "message digest". By comparing the MD5sum of the input (the file to be downloaded) and the output (the downloaded file), the integrity of the download can be verified.

What is SHA-1 checksum?

SHA stands for Secure Hash Algorithm. There are five algorithms in SHA, denoted by SHA-1, SHA-224, SHA-256, SHA-384, and SHA-512. SHA-1, like MD5, is another algorithm that is used to verify data integrity. The main difference between the two algorithms is that while MD5 uses 128bits to produce a message digest, SHA-1 uses 160 bits.

Whenever you download any file from Internet or from Oracle Technology Network or Oracle support it is important to ensure that the file did not get corrupt during the download. This can be achieved by comparing the MD5 and/or SHA-1 checksum as shown below:

Once you download a file, the SHA-1 and MD5 should match that of the source. If they do not match, it is required to download the file again.

Linux
Calculating MD5 checksum in Linux:

The command is,

$md5sum absolute_path_of_file_name

Here, file_name is the complete location of the downloaded file.

Example of calculating MD5 checksum in Linux:

$md5sum /home/oracle/test.zip

a34d8cd98f00cf24e9800998ecf823e4 /home/oracle/test.zip

Calculating SHA-1 checksum in Linux:

Here, file_name is the complete location of the downloaded file.

$sha1sum complete_path_of_file_name

Example of calculating SHA-1 checksum in Linux:

$sha1sum /home/oracle/test.zip

a34d8cd98f00cf24e9800998ecf823e4 /home/oracle/test.zip

Solaris
Solaris does not ship with md5sum installed.

For Solaris 8 and 9:
md5sum, sha1sum utilities are included in the GNU 'coreutils' package available at www.sunfreeware.com

For Solaris 10:
'digest' utility must be installed.

Calculating MD5 checksum in Solaris 10:

The digest utility calculates the message digest of the given file(s) or stdin using the algorithm specified.

$ digest -v -a md5 absolute_path_of_file_name

Here, file_name is the complete location of the downloaded file.

Example of calculating MD5 checksum in Solaris 10:

$ digest -v -a md5 /home/oracle/test.zip

md5 /home/oracle/test.zip = a34d8cd98f00cf24e9800998ecf823e4

Calculating SHA-1 checksum in Solaris 10:

Specify the algorithm to be used in the digest utility.

$/usr/bin/digest -v -a sha1 complete_path_of_file_name

Here, file_name is the complete location of the downloaded file.

Example of calculating SHA-1 checksum in Solaris 10:

$/usr/bin/digest -v -a sha1 /home/oracle/test.zip

sha1 (/home/oracle/test.zip) = a34d8cd98f00cf24e9800998ecf823e4

Calculating MD5 and SHA-1 checksum in AIX:

For MD5:

csum

For SHA-1:

csum -h SHA1

Example of MD5 and SHA-1 checksum utility on AIX:

MD5:

:csum p8202632_10205_AIX64-5L_1of2.zip

1b58a3f5478fbdf9c660fcce5f9558cb p8202632_10205_AIX64-5L_1of2.zip

SHA-1:

:csum -h SHA1 p8202632_10205_AIX64-5L_1of2.zip

be78759fe031cd3a59b8490ee1d27b1ca321dd8f p8202632_10205_AIX64-5L_1of2.zip

Calculating MD5 and SHA-1 checksum in Windows:

Microsoft offers a tool called the File Checksum Integrity Verifier utility, available for download from Microsoft Technet within Knowledge Base article number 841290. This utility can be used on Windows to verify the integrity of the downloaded file. The syntax is:

fciv.exe -both downloaded_filename

For example, these are the results for an opatch download from Metalink:

fciv -both p2617419_10102_GENERIC.zip
//
// File Checksum Integrity Verifier version 2.05.
//
MD5 SHA-1
-------------------------------------------------------------------------
64f18de4aa1a41894cf08cddc1cd1dbc 276c2c529324744021f279d84cbb46c189896390

p2617419_10102_generic.zip

BEGIN failed--compilation aborted at C:/xampp/perl/site/lib/ModPerl/Const.pm line 18

noreply@blogger.com (Arju) — Wed, 20 Jun 2012 23:00:33 PDT

Problem Description
While starting Apache web server it fails with following error message.

[Tue Jun 19 16:21:17 2012] [error] Attempt to reload DynaLoader.pm aborted.
Compilation failed in require at C:/xampp/perl/site/lib/ModPerl/Const.pm line 18.
BEGIN failed--compilation aborted at C:/xampp/perl/site/lib/ModPerl/Const.pm line 18.
Compilation failed in require at C:/xampp/perl/site/lib/Apache2/Const.pm line 18.
BEGIN failed--compilation aborted at C:/xampp/perl/site/lib/Apache2/Const.pm line 18.
Compilation failed in require at C:/xampp/apache/conf/extra/startup.pl line 9.
BEGIN failed--compilation aborted at C:/xampp/apache/conf/extra/startup.pl line 9.
Compilation failed in require at (eval 2) line 1.

Investigation of the Problem
No other process is listening on port 80. I have manually checked via netstat -aon command as it is stated in http://arjudba.blogspot.com/2009/07/how-to-check-or-identify-which-process.html. Even I manually off the teamviewer, Skype. But nothing happens. Still same problem while starting Apache.

I dig into it further and I found the culprit is Oracle.

Cause of the Problem
I found I was getting this error because PERL5LIB was set. During Oracle installation the environmental variable PERL5LIB was set by Oracle 10g. So the simplest solution is to unset PERL5LIB when starting the Apache web sever. I did this by creating a cmd file that unsets PERL5LIB and runs Apache along with a shortcut for starting it.

By the way Oracle 10g had defined PERL5LIB to:

PERL5LIB=C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib;C:\oracle\product\10.2.0\db_1\perl\5.8.3\lib\MSWin32-x86;C:\oracle\product\10.2.0\db_1\perl\site\5.8.3;C:\oracle\product\10.2.0\db_1\perl\site\5.8.3\lib;C:\oracle\product\10.2.0\db_1\sysman\admin\scripts;

Solution of the Problem

@c:
@cd \xampp
@set PERL5LIB=
apache_start.bat

Here is the output,

C:\xampp>@c:

C:\xampp>@cd \xampp

C:\xampp>@set PERL5LIB=

C:\xampp>apache_start.bat
Diese Eingabeforderung nicht waehrend des Running beenden
Bitte erst bei einem gewollten Shutdown schliessen
Please close this command only for Shutdown
Apache 2 is starting ...

Here goes the output from Apache logfile,

[Tue Jun 19 16:26:22 2012] [notice] Digest: generating secret for digest authentication ...
[Tue Jun 19 16:26:22 2012] [notice] Digest: done
[Tue Jun 19 16:26:23 2012] [notice] Apache/2.2.21 (Win32) mod_ssl/2.2.21 OpenSSL/1.0.0e PHP/5.3.8 mod_perl/2.0.4 Perl/v5.10.1 configured -- resuming normal operations
[Tue Jun 19 16:26:23 2012] [notice] Server built: Sep 10 2011 11:34:11
[Tue Jun 19 16:26:23 2012] [notice] Parent: Created child process 3604
[Tue Jun 19 16:26:24 2012] [notice] Digest: generating secret for digest authentication ...
[Tue Jun 19 16:26:24 2012] [notice] Digest: done
[Tue Jun 19 16:26:25 2012] [notice] Child 3604: Child process is running
[Tue Jun 19 16:26:25 2012] [notice] Child 3604: Acquired the start mutex.
[Tue Jun 19 16:26:25 2012] [notice] Child 3604: Starting 150 worker threads.
[Tue Jun 19 16:26:25 2012] [notice] Child 3604: Starting thread to listen on port 443.
[Tue Jun 19 16:26:25 2012] [notice] Child 3604: Starting thread to listen on port 443.
[Tue Jun 19 16:26:25 2012] [notice] Child 3604: Starting thread to listen on port 80.
[Tue Jun 19 16:26:25 2012] [notice] Child 3604: Starting thread to listen on port 80.

How to Connect your Samsung Cell Phone to PC Using Bluetooth

noreply@blogger.com (Arju) — Wed, 06 Jun 2012 23:48:25 PDT

Make sure you have download bluetooth driver for your computer/laptop from Internet or download from CD. Most laptop now have built-in Bluetooth transceivers that can accommodate several Bluetooth devices and peripherals. When connected, the built-in Bluetooth technology of both the Samsung cell phone and PC allows the user to share documents, music, video, and to sync email and other programs.

Activate Bluetooth on PC
Step 1
Click the "Start" button and type "Services.msc" in the search box. Press "Enter" on the keyboard to launch the "Services" window. In many laptop there is shortcut button through which by pressing one key you can activate bluetooth.

Step 2
Right-click "Bluetooth" from the services list. Click "Properties" from the pop-up menu.

Step 3
Click the "General" tab. Click the drop-down menu next to "Startup type." Click "Automatic." Click "OK" to save the changes and return to the "Services" window.

Step 4
Right-click "Bluetooth" services. Click "Start" from the pop-up menu. Close the "Services" window and return to the desktop.

Step 5
Click "Start" and type "Bluetooth" in the search box. Press "Enter" on the keyboard to launch the "Bluetooth" services window.

Step 6
Click "Change Bluetooth settings." Click the "Options" tab, and under "Discovery", check "Allow Bluetooth devices to find this computer," then "Alert me when a new Bluetooth device wants to connect". Click "Apply" then "OK" to close out of the window.

Activate Bluetooth on Samsung Cell Phone
Step 1
Press the "Menu" key from the Home screen. Locate and tap the "Settings" icon. From the "Settings" menu, tap "Wireless and network," then "Bluetooth settings." You can also activate by tapping top section and then pressing down and then just click B/T.

Step 2
Tap "Bluetooth" located at the top of the "Bluetooth settings" list. Tap "On" to activate the service.

Step 3
Tap "Visibility" or "Visible" to change the device from "Hidden" to "Always Visible" or "Visible for 3 minutes."

Connect the Devices
Step 1
Click "Start" and type "Bluetooth" in the search box. Press "Enter" on the keyboard to launch the "Bluetooth" services window. Click "Add a Bluetooth device." Windows will search for the Samsung cell phone.

Step 2
Select "Pair without using a code," and enter the Samsung cell phone passkey. Click "Next."

Step 3
Click "Close" once the two devices are connected.

Unlimited Bandwidth Unlimited Space Unlimited Emails Unlimited Domains Hosting

noreply@blogger.com (Arju) — Thu, 19 Jul 2012 03:24:33 PDT

Unlimited Bandwidth Unlimited Space Unlimited Emails Unlimited Domains Hosting is Just $49 or $99 (For High Configuration Server)
Features of Web Hosting

- Unlimited Web Space
- Unlimited Bandwidth
- Unlimited Domain
- Unlimited MySQL Database
- Shell Accesss
- Unlimited Subdomains
- Unlimited FTP Account
- Unlimited POP3 Account
- Free Cpanel
- Reseller Account
For High Configuration $99.99 Unlimited Web Hosting Server use following link,

For Low Configuration Server Ultimate web hosting use following like,

This hosting contains following features:

Control Panel

A control panel, in web hosting, is a web-based interface provided by the hosting company that allows customers to manage their various hosted services in a single place.

Right now we are using Cpanel.net which is an organization that wins the loyalty of customers around the world by providing feature-rich applications backed by a team of developers, technical support engineers and quality assurance experts that provide stable builds, direct support, and fantastic customer service.

Client Control Panel Features

Latest cPanel Control Panel

Website Statistics: AWStats, Webalizer, Raw Log Manager, Referrer and Error Logs

Fantastico: Instant Shopping Carts, Blogs, Portals, Forums, Counters, Formmail

Password Protected Directories and Custom Error Pages

Web Based File Manager, Hotlink Protection, IP Deny Manager, Redirect URL

And many More...

Programming and Database Features

Unlimited MySQL Databases with phpMyAdmin Access

Programming Language: CGI, Fast CGI, PHP 5, Ruby on Rails, Perl, Python, SSI

Programming Modules: Curl, CPAN, GD Library, ImageMagick

System Management: SSH Access and Cron Job Scheduling

FrontPage Extensions

Email Features

Unlimited POP3 Email Accounts with SMTP

WebMail Access: Horde, SquirrelMail, RoundCube

Receive your email to your phone via IMAP Support

Prevent spam with SpamAssassin

Unlimited Autoresponders, Mail Forwards, Email Aliases, Mailing Lists

Application Hosting

Instantly install over 75 open-source scripts with just a click!

WordPress Hosting - Host your very own WordPress blog

Joomla Hosting & Drupal Hosting - Professional CMS Solutions

Magento Hosting - Free E-commerce platform for your own store

Wiki Hosting - Start a Wiki web site with MediaWiki

SQL Analytical Extensions and Materialized Views

noreply@blogger.com (Arju) — Tue, 05 Jun 2012 20:50:10 PDT

For the lab this week we are going to look at how the ROLLUP and CUBE extensions available in SQL can be used to create query result sets that have more than one dimension to them. Both of these extensions are used in conjunction with the GROUP BY clause and allow for a much more broad look at the data.
The first thing you will do for this lab is download the lab6_create.sql file and run the file in your database instance. This file will log into the DBM449_USER and then create and populate a set of tables that will be used for this lab. Instructions for this are outlined in Step 1.
To record your work for this lab use the LAB6_Report.doc found in Doc Sharing. As in your previous labs you will need to copy/paste your SQL statements and results from SQL*Plus into this document. This will be the main document you submit to the Dropbox for Week 6.

L A B S T E P S

STEP 1: Setting up Your Instance

For this lab you will be using a different user and set of tables than you have used so far for other labs. To set up your instance you will need to do the following.

Download the lab6_create.sql file associated with the link to either the C drive on your computer or the F drive in your Citrix account.I have pasted lab6_create.sql at the end of this post.
Open up the file and edit the login information at the top for the new user that is being created. You will need to replace the @ORACLE piece with the specifics for your instance name. DO NOT include AS SYSDBA after the name of your instance for this login.
Now log into your instance as the SYS user. Run the script. The script is too long to copy/paste it into your SQL*Plus session so you should run the script using the @ sign from the SQL> prompt.
Once the script has finished running then issue a SELECT * FROM TAB; sql statement. The result set will have tables from other labs as well but you want to make sure that you see the following tables listed.

TNAME                          TABTYPE CLUSTERID
------------------------------ ------- ----------
SUPPLIER                       TABLE
PRODUCT                        TABLE
DISTRICT                       TABLE
CUSTOMER                       TABLE
TIME                           TABLE
SALES                          TABLE

STEP 2: Using the ROLLUP Extension

In this section of the lab you are going to create a sales report that will show a supplier code, product code and the total sales for each product based on unit price times a quantity. More importantly the column that shows the total sales will also show a grand total for the supplier as well as a grand total over all (this will be the last row of data shown). To do this you will use the ROLLUP extension as part of the GROUP BY clause in the query. Use aliases for the column names so that the output columns in the result set look like the following.
SUPPLIER CODE PRODUCT TOTAL SALES
------------- ---------- -----------
For this report you are going to use the SALES, PRODUCT and SUPPLIER tables. You should be able to write your query using NATURAL JOIN but if you feel more comfortable using a traditional JOIN method that will work just as well. When finished you should have a total of 16 rows in your report and the grand total amount should show 2810.74.
Be sure to copy your SQL code and the result set produced and paste it into the appropriate place in the LAB6_REPORT.

STEP 3: Using the CUBE Extension

In this section of the lab you are going to create a sales report that will show a month code, product code and the total sales for each product based on unit price times a quantity. In this report the column that shows the total sales will also show a subtotal for each month (in this case representing a quarter) . Following the monthly totals for each product and the subtotal by month then the report will list a total for each product sold during the period with a grand total for all sales during the period (this will be the last row of data shown). To do this you will use the CUBE extension as part of the GROUP BY clause in the query. Use aliases for the column names so that the output columns in the result set look like the following.
MONTH PRODUCT TOTAL SALES
---------- ---------- -----------
For this report you are going to use the SALES, PRODUCT and TIME tables. You should be able to write your query using NATURAL JOIN but if you feel more comfortable using a traditional JOIN method that will work just as well. When finished you should have a grand total amount of 2810.74 (same total as in the step 2).
Be sure to copy your SQL code and the result set produced and paste it into the appropriate place in the LAB6_REPORT.

STEP 4: Materialized Views and View Logs

Materialized views, sometimes referred to as snapshots are a very important aspect of dealing with data when doing data mining or working with a data warehouse. Unlike regular views, a materialized view does not always automatically react to changes made in the base tables of the view. To help keep track of changes made to the base tables you must create what is call a Materialized View Log on each base table that will be used in the view. In this step of the lab we will do this.
For the Materialized View we are going to create we are going to use the TIME and the SALES tables. Before we can create the view you will need to create a Materialized View Log on each of these two tables that will keep track of the ROWID and Sequence and include new values that have been added to the base table.
Be sure to copy your SQL code and the result set produced and paste it into the appropriate place in the LAB6_REPORT.

STEP 5: Creating and Using the Materialized View

Now that we have our logs created we can progress on to the view itself. For this part of the lab you are going to create a Materialized View, demonstrate that the view works, insert a row of data into one of the base tables and then update the view. Finally, you will show that the new data is in the view. The following steps will help move you through this process.

First, write the SQL CREATE statement that will create a Materialized View based on the following:

Name the view SALESBYMONTH.
Include clauses that will build the view immediately, completely refresh the view, and enable a query rewrite.
For the columns of the view you want to show the YEAR, MONTH, PRODUCT CODE, a TOTAL SALES UNITS, and a TOTAL SALES.
You will want to group the columns by year, month and product code respectively.

Execute your script to create the view and then issue a SELECT * FROM SALESBYMONTH.

The output columns from your view should look similar to the following (use aliases to format the column headings) and you should have 18 rows in the result set.

YEAR MONTH PRODUCT CO UNITS SOLD SALES TOTAL
-------- ---------- ---------- ---------- -----------

Now we are going to add some data and update the view. Because we have several derived columns in out view we will have to force the update as Oracle will not automatically update a view with this configuration.

To begin with, insert the following data into the SALES table - (207, 110016, 'SM-18277',1,8.95).
Now we are going to use a subprogram within the Oracle built in package DBMS_MVIEW. The REFRESH subprogram within this package will update our view so that we can see the new data.
Write an SQL EXECUTE statement that will use the REFRESH procedure in the DBMS_MVIEW package (HINT: packagename.subprogram). The REFRESH subprogram accepts two parameters; the name of the materialized view to refresh, and either a 'c', 'f', or '?'. For the purposes of the lab use the 'c'. (you can refer back to pages 654-659 of the DBA Handbook readings for week 3).
Execute your statement to update the view and then query the view once again.

You should now see that the row for units sold in month 10 for SM-18277 has increased from 3 to 4 and total sales amount has gone from 26.85 to 35.80.
Be sure to copy your SQL code and the result set produced and paste it into the appropriate place in the LAB6_REPORT.

Deliverables

Submit your completed Lab 6 Report to the Dropbox. Your report should contain copies of each query and result set outlined in the lab along with the requested explanation of whether or not it satisfied the business requirement outlined for that particular section of the lab.

/* DATA WAREHOISE SQL FOR LAB6    */
/* Script file for ORACLE 10G DBMS   */
/* This script file connects to the DBM49_USER user     */
/* and then creates the following tables:         */
/* SUPPLIER, PRODUCT, CUSTOMER, DISTRICT, TIME, SALES */
/* and loads the default data rows   */

CONN DBM449_USER/DEVRY@DB####.WORLD

DROP TABLE SALES;
DROP TABLE CUSTOMER;
DROP TABLE DISTRICT;
DROP TABLE PRODUCT;
DROP TABLE SUPPLIER;
DROP TABLE TIME;

CREATE TABLE SUPPLIER ( 
SUP_CODE   INTEGER PRIMARY KEY, 
SUP_NAME  VARCHAR(35),
SUP_AREACODE  CHAR(3), 
SUP_STATE  CHAR(2));

CREATE TABLE PRODUCT (
PROD_CODE   VARCHAR2(10) PRIMARY KEY,
PROD_DESCRIPT  VARCHAR2(35),
PROD_CATEGORY VARCHAR(5),
SUP_CODE  NUMBER REFERENCES SUPPLIER);

CREATE TABLE DISTRICT ( 
DIST_ID  INTEGER PRIMARY KEY,
DIST_NAME VARCHAR(10));

CREATE TABLE CUSTOMER (
CUST_CODE NUMBER PRIMARY KEY,
CUST_LNAME VARCHAR(15),
CUST_FNAME VARCHAR(15),
CUST_INITIAL CHAR(1),
CUST_STATE  CHAR(2),
DIST_ID  NUMBER REFERENCES DISTRICT);

CREATE TABLE TIME ( 
TIME_ID  INTEGER PRIMARY KEY,
TIME_YEAR  INTEGER, 
TIME_MONTH INTEGER,
TIME_DAY  INTEGER,
TIME_QTR   INTEGER); 

CREATE TABLE SALES (
TIME_ID    NUMBER,
CUST_CODE NUMBER,
PROD_CODE  VARCHAR(10),
SALE_UNITS NUMBER,
SALE_PRICE  NUMBER,
PRIMARY KEY (TIME_ID, CUST_CODE, PROD_CODE));

/* Loading data rows     */

SET ESCAPE ON;

INSERT INTO SUPPLIER VALUES(31225,'Bryson, Inc.'    ,'615','TN');
INSERT INTO SUPPLIER VALUES(31226,'SuperLoo, Inc.'  ,'904','FL');
INSERT INTO SUPPLIER VALUES(31231,'DE Supply'     ,'615','TN');
INSERT INTO SUPPLIER VALUES(31344,'Gomez Bros.'     ,'615','KY');
INSERT INTO SUPPLIER VALUES(32567,'Dome Supply'     ,'901','GA');
INSERT INTO SUPPLIER VALUES(33119,'Randsets Ltd.'   ,'901','GA');
INSERT INTO SUPPLIER VALUES(44004,'Brackman Bros.'  ,'615','TN');
INSERT INTO SUPPLIER VALUES(44288,'ORDVA, Inc.'     ,'615','TN');
INSERT INTO SUPPLIER VALUES(55443,'BK, Inc.'      ,'904','FL');
INSERT INTO SUPPLIER VALUES(55501,'Damal Supplies'  ,'615','TN');
INSERT INTO SUPPLIER VALUES(55595,'Rubicon Systems' ,'904','FL');

INSERT INTO PRODUCT VALUES('11QER/31','Power painter, 15 psi., 3-nozzle'     ,'CAT1',55595);
INSERT INTO PRODUCT VALUES('13-Q2/P2','7.25-in. pwr. saw blade'              ,'CAT1',31344);
INSERT INTO PRODUCT VALUES('14-Q1/L3','9.00-in. pwr. saw blade'              ,'CAT1',31344);
INSERT INTO PRODUCT VALUES('1546-QQ2','Hrd. cloth, 1/4-in., 2x50'            ,'CAT2',33119);
INSERT INTO PRODUCT VALUES('1558-QW1','Hrd. cloth, 1/2-in., 3x50'            ,'CAT2',33119);
INSERT INTO PRODUCT VALUES('2232/QTY','BD jigsaw, 12-in. blade'            ,'CAT2',44288);
INSERT INTO PRODUCT VALUES('2232/QWE','BD jigsaw, 8-in. blade'             ,'CAT3',44288);
INSERT INTO PRODUCT VALUES('2238/QPD','BD cordless drill, 1/2-in.'         ,'CAT3',55595);
INSERT INTO PRODUCT VALUES('23109-HB','Claw hammer'                          ,'CAT4',31225);
INSERT INTO PRODUCT VALUES('23114-AA','Sledge hammer, 12 lb.'                ,'CAT4',31225);
INSERT INTO PRODUCT VALUES('54778-2T','Rat-tail file, 1/8-in. fine'          ,'CAT1',31344);
INSERT INTO PRODUCT VALUES('89-WRE-Q','Hicut chain saw, 16 in.'              ,'CAT2',44288);
INSERT INTO PRODUCT VALUES('PVC23DRT','PVC pipe, 3.5-in., 8-ft'              ,'CAT3',31225);
INSERT INTO PRODUCT VALUES('SM-18277','1.25-in. metal screw, 25'             ,'CAT4',31225);
INSERT INTO PRODUCT VALUES('SW-23116','2.5-in. wd. screw, 50'                ,'CAT2',31231);
INSERT INTO PRODUCT VALUES('WR3/TT3' ,'Steel matting, 4''x8''x1/6", .5" mesh','CAT3',55595);

INSERT INTO DISTRICT VALUES(1,'NE');
INSERT INTO DISTRICT VALUES(2,'NW');
INSERT INTO DISTRICT VALUES(3,'SE');
INSERT INTO DISTRICT VALUES(4,'SW');

INSERT INTO CUSTOMER VALUES(110010,'Ramas'   ,'Alfred','A' ,'TN',3);
INSERT INTO CUSTOMER VALUES(110011,'Dunne'   ,'Leona' ,'K' ,'GA',3);
INSERT INTO CUSTOMER VALUES(110012,'Smith'   ,'Kathy' ,'W' ,'NY',1);
INSERT INTO CUSTOMER VALUES(110013,'Olowski' ,'Paul'  ,'F' ,'NJ',1);
INSERT INTO CUSTOMER VALUES(110014,'Orlando' ,'Myron' ,NULL,'CO',2);
INSERT INTO CUSTOMER VALUES(110015,'O''Brian','Amy'   ,'B' ,'TN',3);
INSERT INTO CUSTOMER VALUES(110016,'Brown'   ,'James' ,'G' ,'GA',3);
INSERT INTO CUSTOMER VALUES(110017,'Williams','George',NULL,'CA',4);
INSERT INTO CUSTOMER VALUES(110018,'Farriss' ,'Anne'  ,'G' ,'CA',4);
INSERT INTO CUSTOMER VALUES(110019,'Smith'   ,'Olette','K' ,'CO',2);

INSERT INTO TIME VALUES(201,2009,09,29,3);
INSERT INTO TIME VALUES(202,2009,09,30,3);
INSERT INTO TIME VALUES(203,2009,09,31,3);
INSERT INTO TIME VALUES(206,2009,10,03,4);
INSERT INTO TIME VALUES(207,2009,10,04,4);

INSERT INTO SALES VALUES(201,110014,'13-Q2/P2',1,14.99);
INSERT INTO SALES VALUES(201,110014,'23109-HB',1,11.95);
INSERT INTO SALES VALUES(201,110015,'54778-2T',2,5.99);
INSERT INTO SALES VALUES(201,110015,'2238/QPD',1,38.95);
INSERT INTO SALES VALUES(202,110016,'1546-QQ2',1,311.95);
INSERT INTO SALES VALUES(202,110016,'13-Q2/P2',5,15.99);
INSERT INTO SALES VALUES(202,110017,'54778-2T',3,5.99);
INSERT INTO SALES VALUES(202,110017,'23109-HB',2,11.95);
INSERT INTO SALES VALUES(202,110018,'PVC23DRT',12,5.87);
INSERT INTO SALES VALUES(203,110012,'SM-18277',3,8.95);
INSERT INTO SALES VALUES(203,110014,'2232/QTY',1,109.92);
INSERT INTO SALES VALUES(203,110015,'23109-HB',1,11.95);
INSERT INTO SALES VALUES(203,110015,'89-WRE-Q',1,258.95);
INSERT INTO SALES VALUES(203,110016,'13-Q2/P2',2,15.99);
INSERT INTO SALES VALUES(203,110016,'54778-2T',1,5.99);
INSERT INTO SALES VALUES(203,110016,'PVC23DRT',5,5.87);
INSERT INTO SALES VALUES(203,110017,'WR3/TT3',3,111.95);
INSERT INTO SALES VALUES(203,110017,'23109-HB',1,11.95);
INSERT INTO SALES VALUES(203,110017,'13-Q2/P2',1,15.99);
INSERT INTO SALES VALUES(203,110018,'23109-HB',1,11.95);
INSERT INTO SALES VALUES(203,110018,'54778-2T',2,5.99);
INSERT INTO SALES VALUES(203,110018,'2238/QPD',1,38.95);
INSERT INTO SALES VALUES(203,110019,'1546-QQ2',1,311.95);
INSERT INTO SALES VALUES(206,110010,'13-Q2/P2',5,15.99);
INSERT INTO SALES VALUES(206,110010,'54778-2T',3,5.99);
INSERT INTO SALES VALUES(206,110010,'23109-HB',2,11.95);
INSERT INTO SALES VALUES(206,110010,'PVC23DRT',12,5.87);
INSERT INTO SALES VALUES(206,110011,'SM-18277',3,8.95);
INSERT INTO SALES VALUES(206,110011,'2232/QTY',1,109.92);
INSERT INTO SALES VALUES(206,110012,'23109-HB',1,11.95);
INSERT INTO SALES VALUES(206,110012,'89-WRE-Q',1,258.95);
INSERT INTO SALES VALUES(207,110013,'13-Q2/P2',2,15.99);
INSERT INTO SALES VALUES(207,110013,'54778-2T',1,5.99);
INSERT INTO SALES VALUES(207,110013,'PVC23DRT',5,5.87);
INSERT INTO SALES VALUES(207,110014,'WR3/TT3',3,111.95);
INSERT INTO SALES VALUES(207,110015,'23109-HB',1,11.95);

COMMIT;

SET ESCAPE OFF;

Distributed database exercise

noreply@blogger.com (Arju) — Tue, 19 Jun 2012 00:17:20 PDT

Scenario/Summary

To the end user working with databases distributed through out a company's network is not different than working with multiple tables within a single database. The fact that the different databases exist in other locations should be totally transparent to the user. For this lab we are going to take on the roll of a database administrator in a company that has three regional offices in the country. You work in the central regional office, but there is also a West Coast Region located in Seattle and an East Coast Region located in Miami. Your roll is to gather report information from the other two regions.

For this lab you are going to work with three different databases. You already have your own database instance. You will also be working with the a database named SEATTLE representing the West Coast Region and a database named MIAMI representing the East Coast Region. Login information for these two additional database instances is as follows:

SEATTLE: Userid - seattle_user
Password - seattle
Host String - seattle

MIAMI: Userid - miami_user
Password - miami
Host String - miami

To record your work for this lab use the LAB3_Report.doc found in Doc Sharing. As in your previous labs you will need to copy/paste your SQL statements and results from SQL*Plus into this document. This will be the main document you submit to the Drop Box for Week 3.

L A B S T E P S

STEP 1: Setting up Your Environment

Be sure you are connected to the DBM449_USER schema that was created in lab 1.
To begin this lab you will need to download the LAB3_DEPTS.SQL script file associated with the link and run the script in your DBM449_USER schema of your database instance. This script contains a single table and that you will be using to help pull data from each of the other two database instances. Notice that the DEPTNO column in this table is the PRIMARY KEY column and can be used to reference or link to the DEPTNO column in the other two database employee tables.
Now you need to create a couple of private database links that will allow you to connect to your other two regional databases. To accomplish this use the connection information listed above in the Lab Overview section. Name your links using your database instance name together with the region name as the name for the link. Separate the two with an underscore (example - DB1000_SEATTLE).
After creating both of your database links, query the USER_DB_LINKS view in the data dictionary to retrieve information about your database links. The output from your query should look similar to what you see below. You will need to set your linesize to 132 and format the DB_LINK and HOST columns to be only 25 bytes wide to get the same format that you see.

DB_LINK USERNAME HOST CREATED
------------------------- ------------------------------ ------------------------- ---------
DB1000_MIAMI MIAMI_USER miami 09-DEC-08

STEP 2: Testing your Database Links

Each of your remote databases has an employee data table. The tables are named SEATTLE_EMP and MIAMI_EMP respective to the database they are in. Using the appropriate database link, query each of the two tables to retrieve the employee number, name, job function, and salary. (HINT: you can issue a DESC command on each of the distributed tables to find out the actual column names just like you would for a table in your own instance.)

STEP 3: Connecting Data in the Seattle Database

Write a query that will retrieve all employees from the Seattle region who are salespeople working in the marketing department. Show the employee number, name, job function, salary, and department name (HINT: The department name is in the DEPT table) in the result set.

STEP 4: Connecting Data in the Miami Database

Write a query that will retrieve all employees from the Miami region who work in the accounting department. Show the employee number, name, job function, salary, and department name (HINT: The department name is in the DEPT table) in the results set.

STEP 5: Connecting Data in all Three Databases

Now we need to increase our report. Write a query that will retrieve employees from both the Seattle and Miami regions who work in sales. Show the employee number, employee name, job function, salary and location name in the result set (HINT: The location name is in the DEPT table).

STEP 6: Improving Data Retrieval from all Three Databases

Writing queries like the ones above can be fairly cumbersome. It would be much better to be able to pull this type of data as though it was coming from a single table, and in fact this can be done by creating a view.

Using the query written above as a guide, write and execute the SQL statement that will create a view that will show all employees in both the Seattle and Miami regions (you can use your own naming convention for the view name). Show all the employee number, name, job, salary, commission, department number and location name for each employee (HINT: The location name is in the DEPT table).
Now write a query that will retrieve all the data from the view just created.

Deliverables

Submit your completed Lab 3 Report to the Dropbox. Your report should contain copies of each query and result set outlined in the lab along with the requested explanation of whether or not it satisfied the business requirement outlined for that particular section of the lab.

See Syllabus/"Due Dates for Assignments & Exams" for due date information. Submit your assignment to theDropbox located on the silver tab at the top of this page.

OEM Query optimization LAB

noreply@blogger.com (Arju) — Sat, 12 May 2012 09:43:37 PDT

In this lab we will focus on several common performance tuning issues that one might encounter while working with a database. You will need to refer to both your text book and the lecture material for this week for examples and direction to complete this lab.

To record your work for this lab use the LAB2_Report.doc found in Doc Sharing. As in your first lab you will need to copy/paste your SQL statements and results from SQL*Plus into this document. This will be the main document you submit to the Drop Box for Week 2.

L A B S T E P S

STEP 1: Examine Query Optimization using OEM

Oracle Enterprise Manager (OEM) provides a graphical tool for query optimization. The tables that you will be using in this lab are the same ones that were created in the first lab in the DBM449_USER schema.

Start OEM via Citrix iLab. If you need help or instructions on how to do this you can refer to the How_to_use_OEM_in_Citrix iLab.pdf file associated with this link.
Select Database Tools icon from the vertical tool bar and Select SQL Scratchpad icon from the expanded tool bar. If you need help or instructions on how to do this your can refer to the Executing_and_Analyzing_Queries_in_OEM.pdf file associated with this link.
Write a SQL statement to query all data from table COURSE (you will need to connect as the DBM449_USER). Click on Execute. Take a screen shot that shows the results and paste that into the lab document.
Click on Explain Plan. Take screen shot of the results and past that into the lab document.
Write a comment how this query is executed.
Write a SQL statement to query the course_name, client_name and grade from the COURSE, COURSE_ACTIVITY and CLIENT tables and order the results by course name, and within the same course by client name.
Click on Explain Plan. Take screen shot of the results and past that into the lab document.
Exit out of OEM at this point.
Write a comment on how this query is executed.

STEP 2: Examine Query Optimization using SQL*Plus

In this portion of the lab we are going to use SQL*Plus to replicate what we did in Step one using OEM. At the end of this part of the lab you will be asked to compare the results between the processes.

Before you can analyze an SQL statement in SQL*Plus you first need to create a Plan Table that will hold the results of your analysis. To do this you will need to download the UTLXPLAN.SQL file associated with this link and run this script in an SQL*Plus session while logged in as the DBM449_USER user. Once the script has completed then execute a DESC command on the PLAN_TABLE.
Again you are going to write a SQL statement to query all data from table COURSE. Remember to make the modifications to the query so that it will utilize the plan table that you just created.
Now write the query that will create a results table similar to the one below by using the DBMS_XPLAN procedure.

PLAN_TABLE_OUTPUT

Plan hash value: 1263998123

Id	Operation	Name	Rows	Bytes	Cost (%CPU)	Time
0	SELECT STATEMENT		5	345	3 (0)	00:00:01
1	TABLE ACCESSFULL	COURSE	5	345	3 (0)	00:00:01

Note

PLAN_TABLE_OUTPUT

- dynamic spamling used for this statement

Now execute the second query you used in Step 1 and then show the results in the plan table for that query. HINT: Before you run your second query you will need to delete the contents of the plan table so that you will get a clean analysis.
Write a short paragraph comparing the output from OEM to the output from the EXPLAIN PLAN process you just ran. Be sure to copy/paste all of the queries and results set from this step into the lab report section for this step.

STEP 3: Dealing With Chained Rows

In this portion of the lab we are going to create a new table and then manipulate some data to generate a series of chained rows within the table. After you have generated this problem then we are going to go through the process of correcting the problem and tuning the table so that the chained rows are gone. The process is a little tricky and is going to require you to think through your approach to some of the SQL. Remember that every table has a hidden column named ROWID that is created implicitly by the system when the table is created. This column can be queried just like any other column. You will need this information in step 6 of this part of the lab.

For this part of the lab you will need to create a new user named GEORGE. You can determine your own password but you want to make sure that the default tablespace is USERS and the temporary tablespace is TEMP. Grant both the connect and resource rolls to the new user and then log in to create a session for the new user GEORGE.
Once logged in to the new user then write the SQL to create a new table using the given column information and storage parameters listed below. NOTE: the parameters have been chosen intentionally so please do not change them.

Table name: NEWTAB
Columns: Prod_id       NUMBER
     Prod_desc VARCHAR2(30)
     List_price NUMBER(10,2)
     Date_last_upd DATE

Tablespace:	USERS
PCTFREE	10
PCTUSED	90
Initial and Next extents:	1K
MinExtents	1
MaxExtents	121
PCTINCREASE	0

Next, you will need to download both the UTLCHAIN.SQL and LAB2_FILL_NEWTAB.SQL scripts from the links shown. First run the UTLCHAIN script in your SQL*Plus session and then run the LAB2_FILL_TAB script. Be sure that you run them in the order just described.
Now execute the ANALYZE command on the table NEWTAB to gather any chained rows. HINT: refer back to the lecture material for this week and your text book.
Write and execute the query that will list the owner_name, table_name and head_rowid columns from the CHAINED_ROWS table. You will have approximately 200+ rows in your result set so please do not copy/paste all of them into the lab report. You only need the first 10 or 15 rows as a representation of what was returned.
Now you need to go through the steps of getting rid of all the chained rows using these steps.

You can create your temporary table to hold the chained rows of the NEWTAB table as a select statement based on the existing table. HINT: CREATE TABLE NEWTAB_TEMP AS SELECT * FROM NEWTAB.... You want to be sure that you only pull data from the existing table that matches the data in the CHANED_ROW table. To assure this you will need a WHERE clause to pull only this records with a HEAD_ROWID value in the CHAINED_ROWS table that matches a ROWID value for the NEWTAB table.
Now you need to delete the chained rows from the NEWTAB table. To accomplish this you will need a subquery that pulls the HEADROW_ID value from the CHAINED_ROWS table to match against the ROWID value in the NEWTAB table. The number of rows deleted should be the same as the number that you retrieved in the query for part 5 of this section.
Now write an insert statement that will insert all of the rows of data in the temporary table that you created above into the NEWTAB table. Be sure that you explicitly define the rows that you are pulling data from in the NEWTAB_TEMP table.
Next, write and execute the statement that will TRUNCATE the chained_rows table.
Now run the same ANALYZE statement you did in step 4 and then the query you did in part 5 above. This time you should get a return message stating no rows selected.

Be sure that you copy/paste all of the above SQL code and returned results sets and messages into the appropriate place in the Lab Report for this week.

Deliverables

What is Due

Submit your completed Lab 2 Report to the Dropbox as stated below. Your report should contain copies of each query and result set outlined in the lab along with the requested explanation of whether or not it satisfied the business requirement outlined for that particular section of the lab.

After enabling Label Security SQL developer shows ORA-00904: "ORA_ROWSCN": invalid identifier

noreply@blogger.com (Arju) — Wed, 09 May 2012 23:45:13 PDT

Problem Description
The use of ORA_ROWSCN is not compatible with Fine Grained Access policies (either dbms_rls or OLS).

When connecting to DB 10.1 or > 11g using SQL Developer 3.0 or 2.0, and choosing any specific table on the left side, the "Details" tab on the right hand pane throws ORA-904. This happens only with 10gR1 Database (10.1.x) and later version. It works fine for other older versions of Database.

Cause of the Problem
This is SQL Developer bug.

Solution of the Problem
Analyze the table and its structure.

a. Analyze table tablename validate structure

Check if you can disable the use of this pseudo column in sql developer, this seems to be possible
under Tools --> Preferences --> Database --> ObjectViewer. other versions of sql developer may not use this also.

Once you disable the use of ORA_ROWSCN in sql developer you can now access the tables data without any problem.

Hostgator Hosting Coupon Codes

noreply@blogger.com (Arju) — Thu, 03 May 2012 18:18:24 PDT

Hostgator hosting is good to me. I have several sites hosted there. I wanna post several coupon codes of them which you can use towards your web hosting order. These coupons apply to the web hosting portion of your order, and are not applied towards any other services, like domain registration. Hostgator official coupon does not give you this much discount. So you can use it for your hosting order with hostgator.

25% OFF - Coupon Code ArjuOFF25HOSTING
Use any of the following coupon code to get 25% OFF in hostgator hosting.

ArjuOFF25HOSTING
SUPERHOSTING25OFF
MY25DOLLAROFF

Shared and Reseller Coupons

The 25% off coupon can be used by new and existing customers. It only applies to new orders, and only includes the months of hosting (not domain registrations) that are part of your initial order. If you sign up for more than one month on the shared plans, Hostgator do discount all of the months.

VPS and Dedicated Coupons

You can apply above 25% off coupon code while placing your order in case of VPS and Dedicated Coupons

The 25% off coupon can be used by new and existing customers. It only applies to new orders, and applies to your first month of hosting.

Note that, in this case you will NOT be able to use the 25% off coupon and pay annually or semi-annually. You can't sign up for more than one month of dedicated or VPS on our website; therefore, the coupon is only good for the first month.

$9.94 Off

GETOFF994HOSTING
ARJU994HOSTINGOFF

Through these coupon code you can take up to $9.94 off any new hosting purchase by a new customer. Use this for any initial order totaling $49.70 or less (new customers only, one-time use). If your web hosting order totals more than $49.70, then the 25% off coupon gives you a better discount.

.001$ Hosting

By using above two $9.94 off coupon code you can get the first month of Baby hosting for only a penny. So you can try hostgator Baby hosting with no risk. You still get the 45-day money-back guarantee on your penny.

So, can you get Baby for free if you choose the cheaper payment option?

No, to get the annual or semi-annual discounted rates, you would need to pay in advance, so the signup price will not be less than $9.94.

So, can you get Hatchling for free?

No, the coupon will only take $8.94 off a Hatchling plan, so the first month costs a penny. This is because hostgator has a minimum charge to setup your account, which is $0.01 (one penny).

24.94$ off on Reseller Hosting
Coupon Code:

ARJUOF25RESELLER
MY25OFFHOSTING

Visit http://www.hostgator.com/ to get your hosting and apply these coupons for maximum benefits.

SEOP Review! Beware of SEOP Company! They are simply crap

noreply@blogger.com (Arju) — Wed, 25 Apr 2012 19:50:22 PDT

If you ever thought about SEO for your company beware about some SEO companies who really cheat on clients. One of the biggest crap I have ever found is seop.com. They simply took a huge money from us with their worst services. Whenever we assigned some keywords to them we were around 1st, 2nd or 3rd page in google. After 2 months of work whenever they sent us report we saw all of the keywords go down and what they did is several directory submission. LOL. As a result for many keywords our website is nowhere in google and down for all websites. We spent about $6000 with them!

Simply, seop.com is of the worst seo sites I have ever dealt with. They spammed our website full of unprofessional work and charged us $6000.00. Then I just googled them about their services and saw several horror stories from others that have had the same results with seop! They cheat by saying money back guarantee, they will never do and they will cause so much damage to your site and you'll pay thousands - just like we are to get it fixed! SEOP guys don't know what they are doing but they charge you every month.

The reality is that SEOP has NO CLUE of what they are doing, or what business they are in for that matter. DO NOT HIRE THIS COMPANY TO DO YOUR WORK, Learn from our EXPENSIVE mistake!

A customer who used them described in this way,
"SEOP can't even get me to Page 2 Google Organic, when you type in the exact word phrase, matching my domain name. How bad is that. Page 3 when I started using them, Page 6 upon completion. My 3 months money wasted and worst result with them. Simply Crap! Way to go SEOP! "

Simply beware them. If you wanna lose your website ranking, if you want to give away your money to water, go with them. After 3 months of work by them you will find your site nowhere in search engine.

Here is one email from them how they start crap!
From: "Bahareh Seifikabir"
Date: April 9, 2012 12:59:24 PM EDT
Cc: "'Manuel Clark'"

Subject: RE: March Reports

Hi,

I hope you are doing well. If you would be kind enough to review the ranking section of the previous email as it provide detailed information regarding ranking fluctuations. As indicated, the latest Google update has caused many of the sites to fluctuate in rankings and this is rather normal process. We are working on creating engaging and authentic content pieces and continue with our linking efforts and optimization of keywords to move up the rankings.

Please also note that we do run our reports from the same machine, IP, and geographical area monthly as a gauge/benchmark, but what you might see on your end could be slightly off and, as you know, Google is generally changing their algorithm at least once a day, and any given change can affect your rankings

Therefore the Google’s latest panda update, the fluctuation in ranking is typical and as we continue with the progress, you will definitely see improvement across the board. In terms of the “......” keywords please note that we are basing the strategy and keywords that are targeted on the keyword map that you had approved which is also available in the initial site analysis document. The keywords and allocation of them are outlined below. As you can see, we do have the word “.....” targeted but in different variations to allocated to the homepage for example. Also, if you notice in the spreadsheet we are also monitoring and targeting different variation of word.

Rubbish! They send same emails to all of them once they fail.

Here is some more pathetic situation with some other customer who went through them.

SEOP, INC. states in their contract that "IF CLIENT DOES NOT REACH FIVE KEYWORD PHRASES IN THE TOP TEN OF ONE OF THE TOP THREE SEARCH ENGINE WITH SIX MONTHS, THEN SEOP WILL CONTINUE TO WORK AT NO CHARGE UNTIL DESIRED RESULTS ARE ACHIEVED.". -This is a broken promise. We paid for six months of services and their own reports show that we never did get 5 key terms in any 1 of the top 3 search engines. LONG VERSION:I had originally contact Michael Tesauro with SEOP.com in early October of 2006. SEOP, Inc. is a company that programs web site search engine optimization (SEO). This allows web surfers to find you when performing a search on search engines. We had discussed services in length. Michael had provided me with a proposal (DOCUMENT M), time line (DOCUMENT O) and contract for services (DOCUMENT L). There was a load of information forwarded to me, much of which was in terminology that only people in the industry would understand. Therefore, understanding the service was overwhelming at times. However, Michael was very responsive to questions and left me feeling comfortable in contracting their services. October 28th, 2006 was the start date of our agreement. In the first couple months of service, we did see minor immediate results with the search engines. In early December 2006, our company was making major changes that would be implemented in the New Year. I had contacted Michael to let him know that it was very likely we would not have the funds to continue with service, as it was costing $1500/month. Michael and I had come to an agreement that SEOP, Inc. would continue services with the knowledge that we may become past due.

The agreement also stipulated that if we were to become 60days past due, all work to our site would cease until our account was caught up in full and we agreed to move on with services. Simply said, we had made a verbal agreement to go to a month to month agreement. This is documented in e-mail exchanges dated 12/13/06 and 12/21/06. (DOCUMENT A) On January 25th, 2006, documented in an e-mail to Dava Voss at SEOP, Inc., I had requested a freeze put on our account until we were caught up. This freeze never occurred. SEOP continued to bill me for billing periods of 01/28/07-02/27/07 and 2/28/07-3/27/07. (DOCUMENT B) When I continued to receive invoices, I again e-mailed a request to Dava & Michael to freeze our account until further notice. This request is documented in an e-mail sent on 03/07/07. (DOCUMENT C) On April 25th, 2007, Dava Voss sent an e-mail demanding payment or they would remove the work they had performed to the site. At this time, I had informed her that I would take over the payable and get the account caught up. I also cancelled services and stated that no further work should be done until the account is caught up in full and we request further services.

This cancellation is documented in an e-mail dated 04/25/07. (DOCUMENT D) NONE OF MY REQUESTS TO STOP SERVICES WERE EVER HONORED. THEY IGNORED THE REQUESTS AND KEPT BILLING. MIND YOU, NO WORK WAS BEING PERFORMED. In May our office had noticed that our site was starting to lose ranking. In particular, we were concerned about the massage therapists" pages. On 07/03/07 I had contacted Michael to ask why this would happen. He looked through the site and informed me that my "sitemap" was missing and furthermore that massage therapists pages were loaded with double "meta" content. These items combined would make the therapists web pages to drop in ranking. When I asked how a sitemap would disappear, Michael suggested that maybe my web programmer might have removed the file. I immediately called my web programmer and he assured me he did not do so, nor has ever even been in the ftp access anywhere near this info. In addition, my programmer stated that he saves all old work. Being that I have never had a problem with my web programmer and have worked with him for the past 4 years, I was quite sure that he did not do such a thing. I also asked my web programmer why all of a sudden we were getting double "meta" info loaded onto therapists web pages. He did look into this and informed me that SEOP had written code in the viewtherapist.asp file in the ftp files under the app manager directory to include addition "meta" info on each therapist web page. (DOCUMENT E)Naturally, having doubts, I started going through each individual therapist page and noticed that the duplicated content was the same for every single therapist. In addition to this, the "meta" info that was being loaded were the key terms that I was paying SEOP, Inc. to get me ranking results with. (DOCUMENT P) It is my belief that SEOP,

1. removed the sitemap due to a past due bill. And
2. lost us ranking with search engines due to the programming they wrote into my therapists" web pages, thus duplicating meta tags and resulting in search engines penalizing us by dropping rank. This has resulted in a financial loss to our company and furthermore completely works against what SEOP, Inc. was hired to do. In the later half of June 2007, Dava Voss had continued to supply me with an incorrect account balance. I had requested on several occasions (as documented by e-mails) that we discuss the invoices and see why there was a discrepancy our records vs. SEOP records. Dava was non-responsive each time and was not reachable by telephone. (DOCUMENT F) Two months later, in an e-mail dated 8/21/07, as documented, I had asked again that we get this discrepancy resolved once and for all. At this point, no one was able to supply whether any work was performed during the month of service in question, therefore Michael had agreed to "make the invoice go away". (DOCUMENT G) Once this was resolved, I had caught our account up on the past due balance and had not heard from SEOP at all. They had not sent any further invoicing, nor had they requested a "cancellation of service". At this time, I had also started having major doubts about SEOP, Inc. and the services they had provided. I had decided to review the work they had done. This lead me back to the proposal, contract and time line that Michael had originally supplied me with. Once I had reviewed these documents, I had noted many services I had never received and that I had been over billed two of the six months I paid for monthly services. I also discovered that my contract stated that SEOP, Inc. would optimize additional pages at no charge, yet I was charged $100 for 17 additional pages I had submitted to them. In addition to this, the proposal stated that with my "gold package", 136 man hours would be done on my site per month. I have never received a report of how these hours were being spent, nor what work was being done to my site on a monthly basis. This information was to be sent to me on the 28th of each month according to the time line provided. 10/04/07, I had e-mailed Michael Tesauro (as documented) a long list of questions regarding the proposal, time line and contract we had (DOCUMENT H). We had made a telephone appointment for 10/12/07 of which Michael cancelled due to an emergency. 10/15/07, I had left a message and e-mailed Michael asking when he was intending to reschedule our appointment to discuss our e-mail. 10/15/07, Michael had gotten back to me and we went over the e-mail point by point. (DOCUMENT H) I have attached his responses to each item. Many of these items he was to e-mail to me. To date, I have not received these items.

From: selina@wellkneadedmassage.com
To: michael@seop.com
Cc: selina@wellkneadedmassage.com
Sent: Thursday, October 04, 2007 10:56 PM
Subject: Questions regarding agreement and work performed -
PLEASE CONFIRM RECIEPT Hello Michael, I have some items regarding our contract I would like to go over.
#1 - our original contract included the first 3 months at $1000/month, plus a $500 start up fee. However, Dava billed us $1500 per month for the first 3 months. Therefore, I will need a $1000 refund please. -said he would look at it. Dava later issued credit on final invoice in question.

#2 - You had originally sent me an itemization of everything the gold package included. There are a few items I would like to clear up. ·H1 & H2 tags - what is the purpose and where is this located? - in the source code for individual pages, acts as a header tag for search engines. Helps bring attention to those group of words. ·SEO Hazard Analysis - what is this? I have not received it. - an analysis of the website to be sure no unethical techniques are being used to make you get banned from the site. None of these were found with our site. ·Additional 1 way links over 6 months ??? -coming from other websites. ·Creation of themed linked pages - was this the pages that you had broken down by state? How does this work? - This is pages that have links on them according to themes or related industries. -directory source or reciprocal links pages. We did not receive this. Their focus is on incoming links. NEVER RECEIVED. ·Manual Link requests to Related Websites (750)- our links do not seem to be related to our industry. How many people actually are linked to us? -SEOP sends these link requests to the sites. When they are incoming links, they do not need to be service relative. According to today's algorithms, we would want them to be related industries today. 10/15/07 –SPOKE TO SEVERAL OTHER SEOP COMPANIES. THIS IS ABSOLUTELY FALSE AND SHOULD HAVE BEEN RELATED LINKS ALL ALONG. FURTHERMORE, OTHER PROFESSIONALS SAID THAT OUR CURRENT INCOMING LINKS, IF ANYTHING, WILL HURT US. THIS IS BECAUSE THEY ARE TOTALLY UNRELATED INDUSTRIES AND LOOK LIKE LINK FARMS. (DOCUMENT N)

#3 - There are some items that I am not sure if were ever completed that were listed in the Time Line you had sent. ·

3rd week - Submissions to Search Engines & Directories - I did not get report with which Search Engines & Directories these included or the date(s) submitted. - I asked Michael to send me this. ·

4th week - Creation of Themed Link Pages - was this themed by state? How does this work? -addressed above. -Michael said they did not do this. –

NEVER RECEIVED ·4th week - Report of one-way links Directory Structure - I did not receive the directory structure - Directory structure from where reciprocal links are being tied into. We didn't do this. Michael said that nobody wanted to provide reciprocal links. –

NEVER RECEIVED ·5th week - Reciprocal Link Development including collecting related links,loading the links on he site and sending link requests -see note above. –

NEVER RECEIVED ·6th week - W3c Validation of Homepage (HTML Code) - I asked Michael to send it to me.

Received 10/16/07. ·November 28th - I am missing Ranking, Statistic & SEO Reports. -Michael said he could not provide Statistic reports because he did not have access to log files in our hosting information, which they never asked me for. I thought this was the ftp information that I had provided. -Michael said SEO Report would not be any good after the first month of work. ·

December 28th - I am missing Ranking, Statistic & SEO Reports.

NEVER RECEIVED ·January 28th - I am missing the Statistics & SEO Reports.

NEVER RECEIVED ·March 28th - I am missing the Statistics & SEO Reports.

NEVER RECEIVED ·April 28th - I am missing the Ranking, Statistic & SEO Reports.

NEVER RECEIVED #4 - Per section 11 of our agreement, I do not see that 5 keyword phrases of or 21 ever reached the top 10 of any 1 of the top 3 search engines. It states that you will continue working until this is achieved as the contract says they will work at no charge until desired results are achieved. How quickly do you think your team can achieve these results? -Michael replied stating they mean in combination of the top 3 search engines. NOT WHAT THE CONTRACT SAYS. (Obviously, they are not concerned with filling their promises)

#5 - Lastly, I would like some clarification regarding some things you had in our original proposal. ·

How would section 508 help us? -on page alt tags ·Was our Externalizing scripts done? -if it is not on the page itself. ·

What are the top 15 search engines that you submit to? -Asked Michael to send this to me. – NEVER RECEIVED ·

There is reference to bi-weekly ranking reports. I had never received these. -Michael responded with that they were just monthly.

NEVER RECEIVED ·Why is it you stated that our graphical design does not match to the type of clientele we are trying to attract? This was never addressed and I would like your input on this. -Michael stated that he doesn't remember In our conversation of addressing the above issues, I had requested a refund for over billing. At this point, all of a sudden Michael had stated that I had not provided the 60-day cancellation as agreed by our contract. I immediately forwarded Michael and Dava the e-mail from 4/25/07 canceling services. This e-mail is attached. (DOCUMENT I) 10/16/07, I received an invoice for $2000. This was a $3000 cancellation charge, minus $1000 credit for the over billing of our second and third month of service. I immediately responded by e-mail stating this was an error (DOCUMENT J) made complaint to BBB. 10/16/07 - I sent a certified letter to SEOP requesting reimbursement for services that were not received and for over billing. I also argued that I had already sent in a cancellation by e-mail and forwarded it to Dava and Michael. (DOCUMENT K) 10/19/07, I received a call from Jeff Jackson (949-340-7738) who called to tell me he assists in some legal matters. He stated that he or their attorneys might call me later today. He also stated that the CEO, Eric Shiffer was speaking with attorneys. 10/23/07, I had not received a check or response from SEOP, Inc. I filed small claims. (DOCUMENT L) Contractual Agreement with SEOP (DOCUMENT M)

Service Proposal by SEOP (DOCUMENT N) List of links provided by SEOP (DOCUMENT O) Time Line provided by SEOP 05/14/08 - So, a couple weeks ago, I presented my case in court. Unfortunately, not having court experience, I missed the target. The court wants "PROOF" that SEOP, INC. failed to provide as agreed. (Tough to do with a virtual service. So be sure to get your reports & stay on top of it. Trusting professionals to do as contracted without regularly checking their work is not wise. - lesson learned.)My focus was driven on being over billed, damages being done to my site when they implemented code to our viewtherapist.asp files and the fact that I had to pay another SEO company a start up fee to get started again. My focus should have been on paragraph 11 - The guarantee of 5 of my keywords in the top 10 of 1 of the top 3 search engines. I had the reports to prove this, but my focus was in the wrong direction. I share this experience so that other consumers know what to focused on when SEO companies fail to deliver as promised. I also want consumers to understand that to be very aware of what you are getting for a "monthly maintenance fee". This is often a complete pile of bogus. Don't let terms such as "google changes their algorithms, so your site will require maintenance" scar you! These algorithms only change every 3-4 months AND they are very minor in 9 out of 10 instances. Furthermore, you can pay a one time fee to make changes to your site if necessary to comply with "algorithm changes". SEOP, INC CONSUMERS BEWARE! If you have a problem, don't hesitate to contact me. I have several other consumers who have been ripped of by this company. Through my experience, they have a better idea of how to approach the problem and a class action is brewing! For further direction, google the case against INTERNET ADVANCEMENT, INC in Washington. This sets a good precedent and can help give you direction. Too bad I hadn't found it earlier!

Data pump export to a network mapped drive fails with ORA-39002 ORA-39070

noreply@blogger.com (Arju) — Sun, 08 Apr 2012 09:30:18 PDT

Problem Description
A folder from a network of another machine is mapped to Z: drive in the Oracle server machine. Proper permission is given in that folder. Oracle directory is created as follows:

SQL> create or replace directory z as 'Z:\backupset';

Now whenever we try to do data pump export it fails with ORA-39002, ORA-39070 and ORA-29283: invalid file operation.

C:\Users\Administrator>expdp schemas=idencraft userid=system/sys directory=z logfile=data_pump_dir

Export: Release 11.2.0.3.0 - Production on Sun Apr 8 11:56:15 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation

If we change the log file location to any local directory of the server then error message change like following:

C:\Users\Administrator>expdp schemas=idencraft userid=system/sys directory=z logfile=data_pump_dir:log.log

Export: Release 11.2.0.3.0 - Production on Sun Apr 8 11:56:29 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "z:\backupset\expdat.dmp"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

Cause of the Problem
The CREATE DIRECTORY command used the drive letter, not the UNC naming convention (\\<server>\<sharepoint>).
In this example: CREATE DIRECTORY dump_dir AS 'Z:\backupset';

The account running the command does not have the necessary privileges to access the mapped network disk.
The user LOCAL SYSTEM normally will not have file system permissions or network permissions.

Solution of the Problem
Use UNC naming convention (\\<server>\<sharepoint>) on CREATE DIRECTORY command.

SQL> create or replace directory z as '\\172.16.1.36\c$\DB_Backup\backupset';

Directory created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64
bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Users\Administrator>expdp schemas=idencraft userid=system/sys directory=z log
file=data_pump_dir:log.log

Export: Release 11.2.0.3.0 - Production on Sun Apr 8 11:58:44 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02":  schemas=idencraft userid=system/*****
*** directory=z logfile=data_pump_dir:log.log
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 130.0 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_
PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

DIM-00014: Cannot open the Windows NT Service Control Manager

noreply@blogger.com (Arju) — Sat, 07 Apr 2012 23:26:15 PDT

Problem Description
While creating new Oracle service using oradim command it fails with DIM-00014: Cannot open the Windows NT Service Control Manager.

C:\Users\Arju>oradim -new -sid A -srvc OracleServiceA
DIM-00014: Cannot open the Windows NT Service Control Manager.
O/S-Error: (OS 5) Access is denied.

Cause of the Problem
The error indicates that the user from which you are using oradim does not have sufficient privileges. It might seem that you are running oradim from command prompt as Administrator user or there only exists one user in windows but still invoking oradim throws same error.

This error might also arises because of the newly introduced OS feature User Account Control (UAC), a new security component in Windows Vista .

Solution of the Problem
To workaround the issue either :

1. Disable the User Account Control (UAC) security component .

OR

2. Go to Start -> Accessories -> Right click on Command Prompt

and select "Run as Administrator".

to start the command prompt where oradim will be issued .

If you are working on command prompt you can use runas OS command while invoking oradim just like below.

C:\Users\Arju>runas /env /user:Arju "oradim -new -sid A -startmode manual -srvcstart system"
Enter the password for Arju:
Attempting to start oradim -new -sid A -startmode manual -srvcstart system as user "ARJU-PC\Arju" ...

Troubleshooting ASMCMD remote copy

noreply@blogger.com (Arju) — Tue, 03 Apr 2012 01:26:41 PDT

As it is discussed in http://arjudba.blogspot.com/2012/04/how-to-copy-asm-files-between-remote.html you can use cp command of ASMCMD to transfer a file in ASM filesystem from local ASM instance to remote ASM instance.

asmcmd remote copy works through listener connection.

However ASMCMD cp command arguments are not user friendly and also even a single mismatch will generate error. ASMCMD remote connection can fail with below generic error.

ASMCMD-08202: internal error: [asmcmdshare_error_msg_05] [8201]

[8201] means unable to connect remote ASM Instance.

It could be due to following reason.

1. not able to reach remote host.
2. Remote host listener is down.
3. Remote ASM Instance is not registered with listener and running non-default port.
4. sysasm remote connection does not work.
5. Incorrect password given for sys user.
6. Remote ASM Instance password file missing.

We need to enable additional tracing for asmcmd connection to get a exact failure message.

++ set DBI_TRACE environment variable for asmcmd perl tracing.

export DBI_TRACE=1

++ Now connect using asmcmd and re-produce the issue.

After enabling trace, if you notice it fails due to ORA-01031: insufficient privileges then sysasm privelege was not given to sys user on remote ASM Instance.

Given the SYSASM privilege to SYS ( or the user trying to connect ). When you grant a system privilege, the password file is updated.

SQL> grant sysasm to sys; 
Grant succeeded. 

SQL> select * from v$pwfile_users; 
USERNAME SYSDB SYSOP SYSAS 
------------------------------ ----- ----- ----- 
SYS TRUE TRUE TRUE

How much your bank charges for adsense check in Bangladesh

noreply@blogger.com (Arju) — Mon, 02 Apr 2012 20:23:49 PDT

In Bangladesh you have to pay a good amount of money in order to get cash against adsense check. If we issue any check via post office or normal delivery then this corrupted government of Bangladesh (Sheikh Hasina) don't deliver the check. Don't know why they do so. So we had to issue check via DHL and it cuts $28 as processing fee. Once we get the check we need to deposit the check into bank account. Upon cleared bank also charges a good amount of money from our end. This is very frustrating for the adsense publisher who get check in every month as well as your hard earned money is gone. This is reality in Bangladesh until Western Union is available for Bangladesh from Google.

Here goes my bank statement for each check it is cleared.

CHARGES
BCCDAK114431MNY
COMMISSION BDT 750.00
POSTAGE BDT 400.00
VAT BDT 172.50
T19800057
BANKING TERMINAL (UBT)
1,322.50

Here goes the screenshot from the bank statement,

This is from my HSBC bank. The good news is not all banks charges same amount of money. Some bank only charges 300 BDT as postal fee. No commission, no vat. As far as I heard and draw money, Islamic bank really good to deposit adsense check. However if you have any experience about your bank you can share in the comment.
Thanks.

How to Copy asm files between remote ASM instances using ASMCMD command

noreply@blogger.com (Arju) — Mon, 02 Apr 2012 05:37:57 PDT

In 11g we can use asmcmd command line interface to copy files from one machine to another machine which are on ASM file system. So copy the asm files between remote instances and local instances is possible. This feature is new in 11g and enables you to copy files between ASM disk groups on local instances and remote instances. You can also use this command to copy files from ASM disk groups to the operating system.

We can use cp command of asmcmd in order to copy from one machine ASM to another machine ASM instance.

The syntax is,
cp -ifr <source file name> <user_name>@<host_name>.<port Number>.<sid>:<target path>/<target file name>

user_name@host_name.<port Number>.<sid>

The user_name, host_name, and SID are required. The default port number is 1521.

For example to copy a file
named +DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991 from local ASM instance to
remote ASM instance named test
port 1525,
ASM instance name +ASM2
copy to location +data/spfilebakcup.bak
the command will be,

ASMCMD> cp +DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991 sys@test.1525.+ASM2:+data/spfilebakcup.bak
Enter password: ******
ASMCMD>

It will prompt you a password, provide grid sys user password. It is sysasm password, not OS password.

Lets see in remote machine to ensure that file is copied there.

Now let's see what happens if we miss anything in the command. Simply it will not copy and some bogus message it will be shown.

1) Wrong password.

ASMCMD> cp +DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991 sys@test.1525.+ASM2:+data/spfilebakcup.bak
Enter password: ********
ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
ASMCMD-08202: internal error: [asmcmdvol_error_msg_05] [8201]

2) Listener not up.

ASMCMD> cp +DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991 sys@drs-db-01.1525.+ASM2:+data/spfilebakcup.bak
Enter password: ********
ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
ASMCMD-08202: internal error: [asmcmdvol_error_msg_05] [8201]

3) Another variation.

ASMCMD> cp +DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991 sys@drs-db-01.1523.+ASM1:+data/g.baks
Enter password: *****
ORA-12505: TNS:listener does not currently know of SID given in connect descript                                                                                        or (DBD ERROR: OCIServerAttach)
ASMCMD-08202: internal error: [asmcmdvol_error_msg_05] [8201]

4) If destination file already exist.

ASMCMD> cp +DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991 sys@test.1525.+ASM2:+data/spfilebakcup.bak
Enter password: ******
ASMCMD-08014: can not open file->''
ASMCMD-08016: copy source->'+DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991' and target->'' failed
ORA-15056: additional error message
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 397
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

5) Note that, IP address instead of hostname will not work.

ASMCMD>  cp +DATA/BDDIPDC/PARAMETERFILE/spfile.639.737023991 sys@192.168.155.1.1525.+ASM2:+data/spfilebakcup.bak
Enter password: ******
ORA-12532: TNS:invalid argument (DBD ERROR: OCIServerAttach)
ASMCMD-08202: internal error: [asmcmdvol_error_msg_05] [8201]

6) Don't use port 1521.
If you use 1521 port you might see your command is hanged. CISCO and juniper hardware can treat 1521 port specially and it block traffic. So use other port.

Ensure that listener started in remote machine, for example in my remote machine:

[oracle@DRS-DB-02 ~]$ lsnrctl status LISTENER_NEW

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 02-APR-2012 14:36:19

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_DIP)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_NEW
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                29-MAR-2012 12:50:30
Uptime                    4 days 1 hr. 45 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/11.2.0/grid/log/diag/tnslsnr/DRS-DB-02/listener_new/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_DIP)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.155.1)(PORT=1525)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

Ensure that in local asm we can resolve the name of remote hostname.
Here goes /etc/hosts entry,

[grid@DC-DB-02 ~]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1       localhost.localdomain   localhost
::1     localhost6.localdomain6 localhost6
192.168.155.1 test

I will write another post how to troubleshoot remote copy using ASMCMD.