Search results for query: *

Has anyone installed oracle ASM? I am sort of confused on what steps to take to install the instance. For example, I've installed asmLib and created/marked by disks to be added to a group. What is the next step? Install the software in its own home ==> run the dbca ==> create an asm instance ==>...

Hey Mufasa, Thanks for your help on this. It was very helpful. Are there any other standard scripts that need to be run when using 10G? For example in oracle 9i, I also had to run these scripts: JServer.sql ordinst.sql interMedia.sql context.sql xdb_protocol.sql...

Thanks Mufusa. Would have a sample of your init.ora param settings? This is for a lightweight db. I'm actually creating a repository for rman catalog. So, I would just need barebone settings for a small db. Thank you.

Mufasa, Would you have a sample that configures the SYSAUX tablespace? I think this is new to 10g. Thanks.

Hi Mufasa, This would be for unix. I'm trying to create a db on Linux platform. Thanks.

Hello. Can anyone share a standard create database script for oracle 10g? I tried using my old oracle 9i scripts and I am finding there are some gotchas with creating a db in 10gR2. Thanks.

Thank you MillerH for your tips.

I think I worked it out... (@date)=localtime; $date[5]+=1900;$date[4]++; $today=sprintf("%0.4d-%0.2d-%0.2d",$date[5],$date[4]++, $date[3]-1); # fetch rows while (($errorlog, $continuationrow )= $sth->fetchrow_array( )) { if ($errorlog =~ /$today/) { if...

Can you show me how to write that? I'm still unclear on how to plug this in. Thanks. Looking at the sample from perl doc: # Format number with up to 8 leading zeroes $result = sprintf("%08d", $number); # Round number to 3 digits after decimal point $rounded = sprintf("%.3f", $number)...

Hi I need help in writing this perl code for matching a string with today's date. I have the following code that gives me date: #!/usr/bin/perl ($sec,$min,$hour,$mday,$mon,$year,$wday, $yday,$isdst)=localtime(time); printf "%4d-%02d-%02d\n", $year+1900,$mon+1,$mday; Result => 2007-02-20 I...

I think it would work. Let me know if you are able to test it.

Hi, I found this a lot easier to work for me. http://www.perl.com/pub/a/2003/09/03/perlcookbook.html?page=2 Here's my code: # # using sendmail and mailing an attachment # $msg = MIME::Lite->new(From => 'youremailhere', To => 'youremailhere'...

Does anyone now how to use sendmail for sending an attached file? Is sendmail good for this purpose?

Hi Kevin, For curiosity, how would you do this using split?

You're right. I might just change the delimiter back to double quotes or use a "|" or tab for that matter. Neat exercise. You taught me a lot today! Thanks again. ;-> -btw how do I used that "code" box? I can't seem to find a link to post code.

You're the best! Thanks. Now, I need to do this for more than one column now..just apply the same logic right? Thanks again..I learned a bunch ;-> my $commas2 = $COL2 =~ tr/,/,/; if ($commas2 !=2) { $COL2 = '",,"'; } elsif ("$COL2" eq "0") { $COL2 = '",,"' }; my $commas3...

Great! Thanks Kevin. I just did the print "$_\n" for @results; ========= Results: ========= ",,",0:0 ",,",AFV,AFVForFree,7822,y ",,",0:0 ",,",0:0 ",,",0:0 ",,",0:0 ",,",0:0 ",,",0:0 Is there a way to strip off the double-quotes?

this is troublesome, I'm trying to troubleshoot the case for having "0" as a value. When I try to evaluate it, I still can't manage to capture it. ============= code so far: ============= while (( $S_YSVACCEPT, $S_YMJACCEPT ) = $sth->fetchrow_array()) { my $commas...

kevin, same problems. is it perhaps because 0 is actually a "0" string? if so, how do we fix it?

# Process the dataset one row at a time while (( $S_YSVACCEPT, $S_YMJACCEPT ) = $sth->fetchrow_array()) { # Let's print the columns with pipe seperation print "$S_YSVACCEPT | $S_YMJACCEPT \n"; my $commas = $S_YSVACCEPT =~ tr/,/,/; $S_YSVACCEPT = '",,"' if...