Search results for query: *

I have a quick task to setup a job to load data directly into database from flat files. I was going to use SQL Loader. Attached are the two sample data files. 1st priority is with the log.par file. I need to set up a process where both of these get loaded into the database on a continuous basis...

I am receiving the following errors when attempting to setup sudo from user A (temp1) to user B (oracle): Sorry, user temp1 is not allowed to execute '/bin/su - oracle' as root host1 This happens with the following sudoers entry: temp1 ALL=(oracle) NOPASSWD:ALL This works only when I change...

Looking for a good DB state weekly status report template. We want something that also business level can understand. Report should include: * Top Issues * Recommended Resolutions * Top SQL * etc Graphs and chart format would be good. Thanks!

Looking for the recommended way to protect the root and user history logs. We had an instance where a user logged in as root and then ran malicious commands but then deleted the trace of these commands. What is the best way to prevent this? Also, is there a way to print/report for example who...

I need to scan and confirm security compliance for a RedHat Linux Server. I want to capture such items as the following: - open ports - review suid, sgid - user password security scan - privileged user scan - scan for availability of critical files - overall compliance scan Is there a free...

I need to follow best practice for logging daily root login activity as well as commands executed as root user. What is the recommended method? We are implementing tighter security on one of our Prod Enterprise Linux boxes.

Attempting to monitor root access w/ the following command - http://adminlinux.blogspot.com/2007/10/system-security-monitor-root-access.html: [root@prematics32 ~]# echo 'ALERT - Root Shell Access on:' `date` `who` mail -s "Alert: Root Access from `who cut -d"(" -f2 cut -d")" -f1`"...

A client had a 3 day span where their Red Hat server reboot several times throughout the day. We did not see any cronjobs or anything that stood out in the alert logs that would've caused the reboots. The system logs are attached. Client still seeking cause of reboot eventhough we have not seen...

I have a SQL 2000/2005 instance and am setting up maintenance plans. I was told that is best to only do maintenance plans (update stats, shrink DBs, rebuild indexes, etc) on User DBs. Should these also be periodically run on system DBs?

My team has limited shell scripting skills and we need to modify the following script to no longer delete only archive logs that have been backed up by Netbackup (because these files exist on 2 other servers and don't require backups). So we would like the archive logs to be deleted as they are...

I receive the following error when attempting to connect to the services in Studio Management: “Testing the registered server failed. Verify the server name, login credentials, and database, and then click test again.” All other services work with the same credentials but not Reporting. I...

I receive the following error when attempting to configure Reporting Services: “Testing the registered server failed. Verify the server name, login credentials, and database, and then click test again.” All other services work with the same credentials but not Reporting. I did not find much...

I need a monitoring tool (preferably freeware) for SQL Server to monitor our Prod SQL DB servers. We currently have about 100 server and we normally have to manually monitor each box. We are looking to monitor the following: - Failed SQL Server jobs - Disk space - SQL Agent up/down -...

I have been using the link below for my 2.0 to 3.0 upgrade but this documentation seems a little confusing. I have a very vanilla 2.0 environment and would like to know if there is any additional documentation out there that might be a little more straightforward? Thanks in advance for all...

I am getting the error below when attempting to access iSQLPlus using our Oracle10g Grid Control environment. This worked fine at one time but now I am getting the error. I have tried different browsers but same error. Also, all iSQLPlus services are started. Thanks in advance for any...

What is primary difference in results from the following commands? ALTER INDEX <INDEX_NAME> SHRINK SPACE; ALTER INDEX index_name REBUILD; ALTER INDEX index_name COALESCE;

I am upgrading my MS Sharepoint SQL Server 2000 database and am receiving the following message during upgrade: ######################## Name: Microsoft SQL Server 2000 Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and...

Looking for some feedback on anyone that has used Hyperic tool for SQL Server monitoring. I am a SQL Server DBA that needs to automate daily checks (maintenance jobs, backups, up/down, etc) for about 50 DB servers and I am trying to find a cheap (possibly free) monitor tool/method. Thx in advance!

I need a monitoring tool for SQL Server to monitor our Prod SQL DB servers. We currently have about 100 server and we normally have to manually monitor each box. We are looking to monitor the following: - Failed SQL Server jobs - Disk space - SQL Agent up/down - replication I know that tools...

I receive the error message below when attempting to access the default web page on my server. I expect the default page - http://tyw00373/ to direct me to http://tybw00373/default.aspx How can I configure this is IIS. The server was recently migrated from a Project Server 2003/Sharepoint box...