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...

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 order...

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...

Hi all! I include below my script and the files involved. Currently, it prints the sqlnet.ora files that contain SQLNET.AUTHENTICATION_SERVICES set to something other than (NONE). However, I need to add a condition that includes in this list files that don´t contain this parameter as well...

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.

Please see my script and other file contents below. What I´m trying to do is check whether the sqlnet.ora file in each directory it checks contains SQLNET.AUTHENTICATION_SERVICES!=(NONE) and get an error message for every file checked that either doesn´t contain this parameter, or its value is...

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...

Hi, I need help with a loop in a script that is not doing what I want it to do. I include the whole script at the bottom of this message. The intention is that (1) it reads a file /var/opt/oratab into an array (this works), (2) It should go line by line, and separating the fields by : so that...

Hi Ishnid, thanks for your help (and the explanations)! I hope you could help me with a loop in the same script that is not doing what I want it to do. I include the whole script at the bottom of this message. The intention is that (1) it reads a file /var/opt/oratab into an array (this I´ve...

Ok, I´ve got an answer 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...