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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ErrolDC2

    Loop through all tables in DB and add column

    Yes. All the tables in this database are identical. I need to add 2 columns to the tables to upgrade them for higher revision of the application that is using the database.
  2. ErrolDC2

    Loop through all tables in DB and add column

    Could someone share a simple exmaple with me? Thanks,
  3. ErrolDC2

    SQL 2005 - Only listing databases you have permission to

    How do I limit the list of databases seen in SQL 2005 to only those a user has permissions to? For example, in STM, when a user logs in, they see all databases. How does one limit this? Thanks,
  4. ErrolDC2

    Netapp NOOB - Just looking to understand

    I'm doing some analysis of storage in an environment and I'm reviewing some data for a few Netapp filers. I was hoping to gain some understanding from the group here on a few data points that I don't really get. I've personally not worked with Netapp devices before so any help here would be...
  5. ErrolDC2

    135 Dropped by Rule 996

    I am running a discovery tool against a system that has the Checkpoint SecuRemote VPN client installed. This client has policies that I assume are pushed down to it from a master server. When i run our discovery against this system, the first couple of packets to port 135 will be accepted...
  6. ErrolDC2

    Perl Script to query MySQL

    ...use DBI; # Connect to the database. my $host = "host.domain.com"; my $database = "mail"; my $user = "readonly"; my $password = "***"; my $dsn = "DBI:mysql:database=$database;host=$host"; my $dbh = DBI->connect($dsn, $user, $password); if (! $dbh) {...
  7. ErrolDC2

    Service-Policy on PIX 7.0.2

    Hi all. I recently installed a service-policy on my PIX to police inbound http responses from the Internet. Although I got it to work, in order to do so, I had to apply it to the inside interface of my PIX and set the source port to http? This didn't make any sense to me. access-list...
  8. ErrolDC2

    Formating Dates using HTTP::Date

    thanks for your help. im just an add hoc perl person so i never considered parsing the substr. thanks again for your help.
  9. ErrolDC2

    Formating Dates using HTTP::Date

    I have a simple script that I need to return the timestamp of files as YYYY-MM-DD. Im using HTTP::Date but it's returning more than I need. Is there a way to further format the date easily? #!/usr/bin/perl -w use File::stat; use Time::localtime; use Time::Zone; use HTTP::Date qw(parse_date...
  10. ErrolDC2

    ORA-00942 - WHY?

    I'm trying to understand why i get "table or view does not exist" when i execute a select statement against a table in a local production database versus getting the object returned in a development database. The only execption is when I append "USERS." onto the tablename when making the query...
  11. ErrolDC2

    Reading a file and storing contents as array.

    Excellent! Okay. Now, I have two functions. One of the functions needs to only find the file named default. The other needs to process every other file. How do I do that? Also, would it make any difference if the the '1' were a '2'? What would happen if I set another array to use '1'? Now...
  12. ErrolDC2

    Reading a file and storing contents as array.

    ...line in that says "read any file" right? $fh = new FileHandle; $fh->open("$filename"); $filename = lc($filename); while(<$fh>) { chomp; s/#.*$//; # Strip comments s/\S*:\S*//g; # Strip any words with ":" in them s/^\s+//g; # Strip leading whitespace s/^(\S+)\s.*$/$1/; # Use only...
  13. ErrolDC2

    Global symbol X requires explicit package name...

    ...= /default/i) { $fh = new FileHandle; $fh->open("$filename"); $filename = lc($filename); while(<$fh>) { chomp; s/#.*$//; # Strip comments s/\S*:\S*//g; # Strip any words with ":" in them s/^\s+//g; # Strip leading whitespace...
  14. ErrolDC2

    Dealing with Jitter over a WAN

    I'm not sure there is a "fix". Only workarounds. 7960'd have ajitter buffer of about 2s. A gateway running g711 at medium complexity has only about 70ms.That is why phone to phone calls are crystal clear. We are going to upgrade or 1760s to 2800 or 3700 series routers - whatver allows us to...
  15. ErrolDC2

    Dealing with Jitter over a WAN

    I am have an issue. (I know, get in line :) ) I have a user that with a Cisco 7960G behind a 3002 hardware vpn client. We are having one-way voice quality issues when the user calls anyone outside of the company, IE his phone talks to the gateways not another 7960. Packet captures show high...
  16. ErrolDC2

    Oracle Management Server and Node Level Permissions

    Hi. I'm trying to use Oracle Management Server to give people tiered access to Oracle databases scattered throughout my orgainzation. In my testing - I find that I'm having some issues getting the node level permissions correct. For example, I have a test user who is trying to export and import...
  17. ErrolDC2

    Intelligent Agent skipping my SIDS!

    Once again, thanks for the reply and assistance. It is much appreciated. cat services.ora twdb01 = (ORACLE_NODE, twdb01, twdb01, (PLATFORM=(osName=SunOS)(osVersion=5.10)(oracleHomes=/u01/app/oracle/product/9.2.0.1.0))) twdb01:443 = (oracle_sysman_webserver, twdb01...
  18. ErrolDC2

    Intelligent Agent skipping my SIDS!

    Thanks for the reply. I added those two lines but the results are the same. Any other ideas you can think of?
  19. ErrolDC2

    Intelligent Agent skipping my SIDS!

    ...database should , "Y", or should not, # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # *:/u01/app/oracle/product/9.2.0.1.0:N iedportl:/u01/app/oracle/product/9.2.0.1.0:Y weblogic:/u01/app/oracle/product/9.2.0.1.0:Y Stuff hit the...
  20. ErrolDC2

    TableSpace PITR

    ...not contained in recovery set CAPDBA DOCTY TABLE constraint between tables CAP PE not contained in recovery set **snip** 65 rows selected. What does it mean that the constraint is not containted int he recovery set?

Part and Inventory Search

Back
Top