Run Oracle SQL script and exit from sqlplus.exe via command prompt
Another way is to use this command in the batch file: echo exit | sqlplus user/pass@connect @scriptname
Uncategorized
Where to check log of sendmail?
Where are the logs? The default location depends on your linux/unix system, but the most common places are /var/log/maillog /var/log/mail.log /var/adm/maillog /var/adm/syslog/mail.log If it’s not there, look up /etc/syslog.conf. You should see something like this mail.* -/var/log/maillog sendmail writes logs to the mail facility of syslog. Therefore, which file it gets written to depends on … Read more
What’s the meaning of ‘@’ in a DNS zone file?
RFC 1035 defines the format of a DNS zone file. … on page 35 you’ll find: @ A free standing @ is used to denote the current origin. This means that @ is a shortcut for the name defined with $ORIGIN. You can find more information on $ORIGIN here, which is an excerpt from Pro … Read more
How do I rename a task in Task Scheduled on Windows Server 2008 R2
Congratulations! You’ve come up against a problem that has stumped many a Windows user/admin. No, you cannot rename a task except for exporting, renaming and importing again. Yes, it’s rather silly. Perhaps an enterprising scripter could create a simple PowerShell script that automates this, but until then, you’re stuck with your export/import two-step. Sorry. =( … Read more
Can you help me with my capacity planning?
The Server Fault community generally can’t help you with capacity planning – the best answer we can offer is “Benchmark your code on hardware similar to what you’ll be using in production, identify any bottlenecks, then determine how much of a workload your current hardware can handle, and/or how much hardware horsepower you need to … Read more
The Joel Test for system administrator jobs
Do you use an incident/ticket tracking system?
What port should I open to allow remote desktop?
Remote Desktop requires TCP port 3389 to be open. Also, opening UDP port 3389 enables acceleration since RDP 8.0. It is possible to change the port used by the terminal server (or PC which is accessed), see this Microsoft support article: How to change the listening port for Remote Desktop. The UDP port for accelerated … Read more
How can I upgrade to Java 1.8 on an Amazon Linux Server?
To remove java 1.7 and install java 1.8: sudo yum install java-1.8.0 sudo yum remove java-1.7.0-openjdk
Should servers be turned off at night?
To liken it to a car analogy: A taxi can do over 500,000 kilometers before it needs an engine rebuild. The reason for this is because they are always running, 24/7, and after a car’s engine is up to temperature, the amount of wear it receives while it is running is greatly reduced. A computer … Read more
Why can’t a CNAME record be used at the apex (aka root) of a domain?
CNAME records were originally created to allow multiple names that provide the same resource to be aliased to a single “canonical name” for the resource. With the advent of name based virtual hosting, it has instead become commonplace to use them as a generic form of IP address aliasing. Unfortunately, most people who come from … Read more