Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How do I find wwid of iscsi disks in Linux?
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.- tmf33uk
- Post #3
- Forum: Linux (server)
-
How do I find wwid of iscsi disks in Linux?
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...- tmf33uk
- Thread
- Replies: 3
- Forum: Linux (server)
-
Help with global variables
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...- tmf33uk
- Thread
- Replies: 1
- Forum: UNIX Scripting
-
Assign number value circularly in PL/SQL
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...- tmf33uk
- Post #12
- Forum: Oracle: All versions
-
Assign number value circularly in PL/SQL
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.- tmf33uk
- Post #10
- Forum: Oracle: All versions
-
Assign number value circularly in PL/SQL
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...- tmf33uk
- Post #8
- Forum: Oracle: All versions
-
Assign number value circularly in PL/SQL
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...- tmf33uk
- Thread
- Replies: 12
- Forum: Oracle: All versions
-
Assign number value circularly in PL/SQL
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...- tmf33uk
- Post #3
- Forum: Oracle: All versions
-
Assign number value circularly in PL/SQL
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...- tmf33uk
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
Extracting just part of a field´s data
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...- tmf33uk
- Thread
- Replies: 4
- Forum: Oracle: All versions
-
How to return list of files that do not contain a given string
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... -
How to return list of files that do not contain a given string
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... -
How to return list of files that do not contain a given string
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... -
Password File Creation
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.- tmf33uk
- Post #3
- Forum: Oracle: All versions
-
Checking for files that do not contain a given string
Thank you Travis! T. -
Checking for files that do not contain a given string
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... -
How can I work line by line of an array and split line into fields?
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... -
How can I work line by line of an array and split line into fields?
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... -
Push value of $_ onto an array for later use without concatenating
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... -
Push value of $_ onto an array for later use without concatenating
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...
