Search results for query: *

Hi Chuck I had tried that before, and I have tried it again before responding. It didn´t return anything. My iSCSIs are formated as OCFS2 and mounted in the server. Any other ideas? I´d expect this to be in some system file also, no? Regards, T.

Hi all, this will be a quick question for some of you: I am trying to find the UUID of iSCSI disks that my RedHat Linux sees. I am looking in /sys/class/... but I keep finding symbolic links that send me round in circles: [root@ovs1-ec host6]# pwd /sys/class/iscsi_host/host6/subsystem/host6...

Hi, I am trying to concatenate the output of a while loop to a $message variable that will be printed once the loop has completed, but as it stands, it returns nothing from the inside $message variable. I am currently not very interested in the else condition. As long as $inexistent has...

Ah, I see. However, it is not all rows I want to be given a value from 1 to n. And those that are to be given a value from the sequence need to be assigned one in a particular order, not as they appear in the table. In my case, the table contains, among other details about materialized views...

Hi ChrisHunt, your suggestion sounds neater than the MOD function. I´m going to try it shortly. But, I don´t think I´ll be able to do without the cursor as I need to update row by row with the next number... I like it though. Will update you when I´ve tried it. Thanks! T.

Thanks Santa and Turkbear, you definitely have the Oracle globe covered between the two of you.. ;o) Santa, I didn´t put the whole script because it does a few other things also. I was narrowing the problem down to where it doesn´t function as expected. My script most definitely has a BEGIN...

...relevant part of the script is as follows: DEFINE NUMBER_SCRIPTS=&1 DECLARE N_SCRIPT INTEGER:=&&NUMBER_SCRIPTS; CURSOR CONTROL IS SELECT ilv.*, ROWNUM FROM ( SELECT SEGMENT_NAME, SEGMENT_TYPE FROM REPLICA_CONTROL_TABLE WHERE SEGMENT_TYPE...

Thanks George! Point learned. :o) However, I´ve ran my script with a NUMBER_SCRIPTS=5 and all rows were assigned a value of 5. I am wondering whether having made the inline view change you suggested, the MOD(ROWNUM, N_SCRIPT)+1 still needs changing. After all, dividing some rownums in the...

Hi! I have a table with an id column which I would like to update with values 1 to n. Value n is to be defined each time the script is run. I´m using the MOD function, but it´s not working as desired. If I set NUMBER_SCRIPTS=3 most of the rows are assigned ID=3. Should be assigned in the...

Hi! I need to select from a field just part of a character string. The field, specifically is comment_text from dba_audit_trail, and contains: Authenticated by: OS; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.203.31)(PORT=59609)) I´m only interested in the IP address from each row...

Thanks Steve. 1. The line next unless (-e $sqlnet); makes it work even if one of the files is missing. Thanks a lot! 2. Regarding adding unless ($_ =~ /^SQLNET\.AUTHENTICATION_SERVICES/i) { to identify the files that don´t contain that string doesn´t do what I need it to do, because this...

Ok, regarding the same script, I´ve noticed that if the sqlnet.ora file doesn´t exist in the expected directory, the script fails and does not print the string starting with "em_result". How can I handle this (other than creating an empty sqlnet.ora file in each of the expected directories)? It...

...my $oratab='/home/tmillan/oratab'; open(BIN, "<$oratab\n") or die "Couldn't open file for reading: $!n"; while (<BIN>) { s/#.*//; #ignore comments next if /^(\s)*$/; #ignore blank lines chomp...

JT, you will have to create a password file as this is only necessary if remote_login_passwordfile is set to EXCLUSIVE or SHARED. Other values ignore the existence of the password file, hence I doubt very much DBCA will create it. T.

Thank you Travis! T.

...my $oratab='/home/tmillan/oratab'; open(BIN, "<$oratab\n") or die "Couldn't open file for reading: $!n"; while (<BIN>) { s/#.*//; #ignore comments next if /^(\s)*$/; #ignore blank lines chomp...

Sorry, should have said, all 4 lines in the oratab file are appended to the array as it is. This is the output of the script as it is. As you´ll notice, the line print @lines, "\n"; does print all 4 lines one after the other. This is, I think, why I can´t see the way to treat line by line (of...

...then it is checking the permissions of the binary files ending in zero in $ORACLE_HOME/bin of the first oratab line, /opt/oracle/product/db10g/bin/*0. I am not clear as to whether the array has stored the lines from oratab into one line, or it is just the way it lists them. If it lists them...

...then it is checking the permissions of the binary files ending in zero in $ORACLE_HOME/bin of the first oratab line, /opt/oracle/product/db10g/bin/*0. I am not clear as to whether the array has stored the lines from oratab into one line, or it is just the way it lists them. If it lists them...

...to my earlier question. My script now looks like this: open (FILE, "< $filename\n") or die "Cant open $filename: $!\n"; while (<FILE>) { s/"*"//; #ignore comments and ORA_HOME with no db defined next if /^(\s)*$/; #skip blank lines chomp; #remove...